Hi List,

SunSolaris 5.8, Oracle 9.2.0.1

from sqlplus with user REPORTING the following select statement hangs.
Nothing is returned after even a day, and CPU usage climbs up to 50%.
> SELECT COUNT(*) FROM fsos_v;

the strange thing is that with user 'SYS as sysdba'
the following query (same on the same view!!!!!!) is returned in less than 1
sec.
> SELECT COUNT(*) FROM REPORTING.fsos_v;

Note.:
The view is based on table (fsos) with around 30 partitions.
The two user have the same default, temp tablespaces.
All indexes, index partitions are valid/usable

Could someone give me a hint how to investigate, what the problem can be, if
you have heard about similar problem...
Thanks,
Rob


Oracle LazyDBA home page