-
Available memory in my database and rollback hit ratio stats
pls how do i know available memory in my database and also if the rollback hit ratio is less than 95% what do I do.
My db is 8.1.6
Last edited by cca; 08-31-2005 at 11:37 AM.
-
ratios suck generally - what are you trying to ptove - and define how much memory - in what part?
-
I want to find out available memory in my SGA and PGA.
I have rollback hit ratio of 89%. Thats why I want to know what to do when its less than 95%
-
show sga
show parameter pga (if you are using automatic work area sizing)
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
|