-
Oracle Memory usage estimation
Any formula or good document for memory usgae estimation of Oracle 9i Database server (such as PGA/SGA memory usage, memory for dictinonary/library cache, NET connection, SQL connection, ...) ???
Many thanks !!!
Shirley
-
Hi,
Check out this script... maybe it'll help.
SET LINESIZE 145
SET PAGESIZE 9999
SET FEEDBACK off
SET VERIFY off
COLUMN bytes FORMAT 999,999,999,999
COLUMN percent FORMAT 999.99999
break on report
compute sum of bytes on report
compute sum of percent on report
SELECT
a.name
, a.bytes
, a.bytes/(b.sum_bytes*100) Percent
FROM sys.v_$sgastat a
, (SELECT SUM(value)sum_bytes FROM sys.v_$sga) b
ORDER BY bytes DESC
/
Cheers
Oracbase
What's next after 10g?
-
I think the query should be like this:
SELECT
a.name
, a.bytes
, (a.bytes/b.sum_bytes)*100 Percent
FROM sys.v_$sgastat a
, (SELECT SUM(value)sum_bytes FROM sys.v_$sga) b
ORDER BY bytes DESC;
-Raja
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|