| Sun OS paging and SGA [message #52662] |
Mon, 05 August 2002 10:04  |
Toyn
Messages: 36
Registered: April 2001
|
Member |
|
|
|
I have my sga (612MB) and shared_pool_size(90MB) sized fairly large, however I still have a hefty amount of paging occurring when I execute simple, large joins. Is this paging indicative of a poorly tuned SGA, OS, or is it a normal occurrence while executing a large join? The issue lays in the fact that my joins are taking waaaaay to long, and I really don't feel that it's a sql issue. Thanks!
|
|
|
|
| Re: Sun OS paging and SGA [message #52664 is a reply to message #52662] |
Mon, 05 August 2002 11:19  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
More information would be good, for any diagnosis for performance tuning.
To start with, try the following:
1. Increase the temp segments and make sure the temp tablespaces are used
2. Increase the sort_area_size and
sort_area_retained_size
3. Make sure the indexes are properly used.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
