|
-
1 Run top in unix to check which process consumes more memory.
2 Run vmstat to check paging is taking place at the OS level.
3 Kill unwanted sessions at unix and oracle level.
4 ALTER SYSTEM FLUSH SHARED_POOL;
5 Run utlbstat and utlestat and verify all the statistics.
6 If you can't figure it out the reason, shutdown oracle and unix and restart the box. If you experience slowness in the system, run sql trace at session level and take tkprof report.
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
|
Reply With Quote