-----Original Message-----
From: Sebastian Norma J.
[mailto:oracledba-ezmlmshield-x72398569.[Email address protected]
Sent: woensdag 30 augustus 2006 4:40
To: LazyDBA Discussion
Subject: 300 hours to drop 2 tablespaces - need help reducing time.
Hi,
I am trying to drop an Oracle tablespace which contains 0 segments. It
is an index tablespace whose accompanying table data tablespace was
already dropped (which is the reason the index space is now empty).
It took 120+ hours to drop the tablespace with the tables in it. The
drop of the index tablespace which has ZERO segments has now surpassed
100 hours.....
Why is this taking so long? the space is EMPTY !!
I am relatively new to Oracle.
I found another thread that mentioned running the following to see what
Oracle was doing: (my tablespace is #33)
SQL> select file#, count(*) from sys.fet$ where ts#=33 group by ts#,
file#;
FILE# COUNT(*)
---------- ----------
10 29890
11 25239
131 18244
132 19854
133 19044
136 19984
137 20144
139 19693
140 20136
141 20077
142 20335
FILE# COUNT(*)
---------- ----------
143 42997
146 13033
177 9590
178 9019
15 rows selected.
I have run the query a few times tonight and the numbers returned are
slowly reducing.
What is this sys.fet$ table?
and why does it matter?
and why is it taking so long?
Please advise. Any ways to make this run faster would be very much
appreciated.
This is an SAP system. The Oracle version is 9.2.0.6.0
it is on Sun Solaris 2.9
the command being run is:
drop tablespace PSAPODSI including contents and datafiles cascade
constraints
The reason i am trying to do this DB reorg is because the tablespaces
have been changed to be defined as LMTS but they won't really be that
way until i export the data/drop tblspace/recreate tblspc as LMTS/import
data.
I need this process to be fast.... preferrably less than 5 hours. (so
far just dealing with these 2 tablespaces (PSAPODSD and PSAPODSI) have
consumed nearly 300 hours! I can't get a reorg outage that long).
thanks for your help,
Norma Jean Sebastian
============================================================
The information contained in this message may be privileged
and confidential and protected from disclosure. If the reader of this
message is not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, you
are hereby notified that any reproduction, dissemination or distribution
of this communication is strictly prohibited. If you have received this
communication in error, please notify us immediately by replying to the
message and deleting it from your computer. Thank you. Tellabs
============================================================
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
-----------------------------------------------------------------
ATTENTION:
The information in this electronic mail message is private and
confidential, and only intended for the addressee. Should you
receive this message by mistake, you are hereby notified that
any disclosure, reproduction, distribution or use of this
message is strictly prohibited. Please inform the sender by
reply transmission and delete the message without copying or
opening it.
Messages and attachments are scanned for all viruses known.
If this message contains password-protected attachments, the
files have NOT been scanned for viruses by the ING mail domain.
Always scan attachments before opening them.
-----------------------------------------------------------------
Oracle LazyDBA home page