Have you tried setting SQL_TRACE true, then
dropping, so that you can read the trace file
and find out what SQL Oracle is firing off
afterwards ?
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
cnwy_at_my-deja.com wrote in message <8kls45$f0u$1_at_nnrp1.deja.com>...
>SQL> select count(*) from user_extents where
>segment_name='INCARDDAYSTAT';
>
> COUNT(*)
>---------
> 1
>
>SQL> select * from INCARDDAYSTAT;
>
>no rows selected
>
>SQL> truncate table INCARDDAYSTAT;
>
>Table truncated.
>
>SQL> drop table INCARDDAYSTAT;
>drop table INCARDDAYSTAT
> *
>ERROR at line 1:
>ORA-00604: error occurred at recursive SQL level 1
>ORA-01000: maximum open cursors exceeded
>
>sys user
>SQL> r
> 1* select statistic#,value from v$sesstat where statistic# in (2,3)
>and sid=18
>
>STATISTIC# VALUE
>---------- ---------
> 2 1081
> 3 0
>
>in hrd
>SQL> r
> 1* drop table INCARDDAYSTAT
>drop table INCARDDAYSTAT
> *
>ERROR at line 1:
>ORA-00604: error occurred at recursive SQL level 1
>ORA-01000: maximum open cursors exceeded
>
>in sys
>SQL> r
> 1* select statistic#,value from v$sesstat where statistic# in (2,3)
>and sid=18
>
>STATISTIC# VALUE
>---------- ---------
> 2 1586
> 3 0
>
>
>
>In article <8kas7o$ef7$1_at_nnrp1.deja.com>,
> satyam130268_at_my-deja.com wrote:
>> You wrote that the table is empty.
>> Can you do
>> select count(*) from user_extents where segment_name='INCARDDAYSTAT';
>> Is it very high ? If so, the table grew too large when all records are
>> deleted. Try to truncate the table before dropping.
>> I think you are connecting the session afresh before dropping table.
>> You can select statistic#,value from v$sesstat where statistic# in
(2,3)
>> for your session when the drop table is issued and monitor the growth
>> of Open cursors from another (DBA) session.
>>
>> Satyam J
>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Fri Jul 14 2000 - 00:00:00 CDT
