| Need Help in Tuning.. [message #50415] |
Thu, 14 March 2002 07:05  |
krb
Messages: 25
Registered: March 2002
|
Junior Member |
|
|
I think all my queries are taking more time than expected. I think that some parameter is not tuned properly.I am enclosing the specifications below..
for ex: This query takes almost 11 minutes
17:38:55 SQL> select substr(tablespace_name,1,10)TS_NAME,total_extents
17:38:55 2 "Total_Extnts",extents_coalesced,round(percent_extents_coalesced,0)
17:38:55 3 from dba_free_space_coalesced
17:38:55 4 /
SYSTEM 24 24 100
RBS 20 20 100
USERS 9991 9991 100
TEMP 1188 397 33
TOOLS 1 1 100
INDX 1 1 100
6 rows selected.
17:49:51 SQL>
Specifications. are listed below
WinNT Dual CPU dedicate server
500M RAM
3* 30GH HDD
RAID
Oracle 8.1.6
No. of Users Connected : 52
Buffer Cache hit Rate : 97.3872
Buffer Busy wait Ration : 0.0031
Free buffer wait Ratio : 0.0000
Lib. Cache get hit ratio: 99.4574
lib. Cache pin hit ratio: 99.4196
redo soace wait ratio : 0.5692
Parse/excecute ratio : 117.1479
Is there anything to be changed??
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
