Here is more info.
When running statspack, I see the session in
v$session_wait and it's waiting on an 'sort segment
request' event. I can see the session in v$sort_usage.
But nothing is going on.
- paquette stephane <stephane_paquette_at_yahoo.com> a
écrit :<br> > Date: Fri, 30 Jun 2000 06:10:04 -0700
(PDT)
> De: paquette stephane <stephane_paquette_at_yahoo.com>
> Objet: Stastpack problem or maybe k$kglob table
> problem
> À: ORACLE-L_at_fatcity.com
>
> 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/
>
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!
Received on Fri Jun 30 2000 - 11:24:33 CDT