| please help me. performance problem [message #62081] |
Thu, 24 June 2004 00:51  |
Anu
Messages: 82
Registered: May 2000
|
Member |
|
|
hi!
can any body explain what i should do to improve my database performance.
i have a main table with an average row length of 37 bytes in our database. the table consists of more than 20 lakhs of records. i have set the values for db_cache_size to 64 mb and shared_pool_size to 96mb. and the total database size is 4 gb only.
while retrieving the hit ratio from the table v$sysstat i am getting
0.64 or less. if i select the total count of rows from the table it takes hardly 4 to 5 seconds for any combination. i disable all the constraints on the table but cant improve the hit ratio.
with regards
anu
|
|
|
|
|
|
| Re: please help me. performance problem [message #62086 is a reply to message #62085] |
Thu, 24 June 2004 04:03  |
Anu
Messages: 82
Registered: May 2000
|
Member |
|
|
hi!
i am sending execution plan. by this time it is showing 0.44 as hit ratio. one more thing could u please let me know. how u to analyse the execution plan by observing consistent gets or some other way else? here no indexes/keys
SQL> select count(*) from emp;
COUNT(*)
----------
2801746
Execution Plan
----------------------------------------------------------
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=140 Card=1)
1 0 SORT (AGGREGATE)
2 1 TABLE ACCESS (FULL) OF 'EMP' (Cost=140 Card=245760)
Statistics
----------------------------------------------------------
0 recursive calls
0 db block gets
20623 consistent gets
14778 physical reads
0 redo size
382 bytes sent via SQL*Net to client
499 bytes received via SQL*Net from client
2 SQL*Net roundtrips to/from client
0 sorts (memory)
thanks in advance
anu
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
