| Extremely high Consistent Gets and DB Buffer Gets [message #19215] |
Tue, 05 March 2002 10:42  |
Steve Karam
Messages: 3
Registered: March 2002
|
Junior Member |
|
|
The query is:
SELECT CAT_NAME, LEVEL, CAT_ID, PARENT_CAT_ID
FROM CATEGORY CAT
WHERE REALM_ID = 6
AND TYPE_NAME = 'LINK'
CONNECT BY PRIOR CAT_ID = PARENT_CAT_ID
This query used to run just fine, but now does this for statistics:
Statistics
----------------------------------------------------------
0 recursive calls
19148 db block gets
100507 consistent gets
3 physical reads
0 redo size
11969 bytes sent via SQL*Net to client
1646 bytes received via SQL*Net from client
13 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
168 rows processed
Why would it be doing that insane number of block gets and consistent gets? Thanks!
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
