I'm using statspack on Oracle 8.1.5/solrais 2.6 since
2 months. Now the statistics collection doesn't work
anymore.
It hangs when inserting in stats$sql_summary. I've
tested the select part of the insert and it can run
for hours. The select is querying v$sql witch is in
fact k$kglob.
k$kglob contains only 26067 rows, how come it takes so
long ?
Any help is welcome.
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
spaquette_at_houra.fr
(33) 01 53 93 06 50
Do You Yahoo!?
Get Yahoo! Mail - Free email you can access from anywhere!
http://mail.yahoo.com/
Received on Fri Jun 30 2000 - 08:10:04 CDT
