- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Query to help determine what PGA sizing might ...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-04-2008 07:38 AM
тАО01-04-2008 07:38 AM
Does anyone know of a query that would help me determine what my unaggregated PGA for each individual connection in dedicated server mode might be?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-04-2008 09:39 AM
тАО01-04-2008 09:39 AM
Re: Query to help determine what PGA sizing might be?
column name format a25
column total format 999 heading 'Cnt'
column bytes format 9999,999,999 heading 'Total Bytes'
column avg format 99,999,999 heading 'Avg Bytes'
column min format 99,999,999 heading 'Min Bytes'
column max format 9999,999,999 heading 'Max Bytes'
ttitle 'PGA = dedicated server processes - UGA = Client machine process'
compute sum of minmem on report
compute sum of maxmem on report
break on report
select se.sid,n.name,
max(se.value) maxmem
from v$sesstat se,
v$statname n
where n.statistic# = se.statistic#
and n.name in ('session pga memory','session pga memory max',
'session uga memory','session uga memory max')
group by n.name,se.sid
order by 3
/
One problem I have had with using the AUTO workarea_size_policy is that it does not allocate sort space as generously as I would like. There apprears be a limit of about 5% of total space per session - regardless of the number of sessions. So I tend to set the pga_aggregate_target higher than I originally calculated was needed.
Patti
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-07-2008 03:46 AM
тАО01-07-2008 03:46 AM
SolutionSince you are just talking about PGA, you should the following value, where 1.3 is for overhead:
select n.name
, round( sum(se.value) * 1.5 / 1024 / 1204) pga_agg_target_mb
from v$sesstat se,
v$statname n
where n.statistic# = se.statistic#
and n.name = 'session pga memory'
group by n.name;
PS: I have pga_aggregate_target = 640 and the above query is returning 671
Best Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-07-2008 03:50 AM
тАО01-07-2008 03:50 AM
Re: Query to help determine what PGA sizing might be?
Where I wrote:
"Since you are just talking about PGA, you should the following value, where 1.3 is for overhead:...", I wanted to say:
Since you are just talking about PGA, you should the following value, where 1.5 is for overhead...:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-07-2008 01:56 PM
тАО01-07-2008 01:56 PM
Re: Query to help determine what PGA sizing might be?
This helps quite a bit, and is more like what I expected. I ran something I had from a script I found on Oracle, and it way underreported the numbers. From your two scripts, although the numbers are very different for just the PGA ports (I edited Patti's script down to just that factor) - and they vary by 33% - it gives me a better guideline, and more in line of what I was thinking the requirement was than what was being provided to me before.
Thanks much!