Hi,
In fact, in your case, adding larger TEMP is not the solution. Solution
is the adding TEMP with larger extent size.
Because, Oracle cleans up segments extent-by-extent. If you have more
extents, cleaning-up them will make more dictionary look-up and this will
eat CPU.
regards...
Charlie Mengler wrote:
I've had something like this happen to me.
My solution was to make TEMP larger;
after enduring the LONG wait for recovery
to complete.
"Naik, Kevin K" wrote:
Hi All,
I have an interesting problem, on one of my databases,
a data warehouse, a killed session was taking too long
to rollback. It was time for the backup, and I
had to do a shutdown abort.
No its time to open the database, instance parallel recovery
is taking place as normal, but the problem is,
its being running for more than 20 hours and the database
is still not open.
Does any body have any clues, thoughts, ideas ?? Is there
anyway I can see what exactly the dbms is up to ?
The instance processes running are completely idle
Thanx
K Naik
Disclaimer and confidentiality note
Everything in this e-mail and any attachments
relating to the official business of Standard Bank Investment Corporation(Stanbic)
is proprietary to the company. It is confidential, legally privileged and
protected by law. Stanbic does not own and
endorse any other content. Views and opinions are those of the sender unless
clearly stated as being that of Stanbic.
The person addressed in the e-mail
is the sole authorised recipient. Please notify the sender immediately
if it has unintentionally reached you and do not read, disclose or use
the content in any way.
Stanbic can not assure that the integrity
of this communication has been maintained nor that it is free of errors,
virus, interception or interference.
--
Web: http://www.unal-bilisim.com
*********
Questions and Answers: http://www.unal-bilisim.com/qa/discus/
*********
itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html
itrprof SQL Analyzer is a web based tool which analyzes
SQL_TRACE/Event10046 trace files of Oracle,
finds bottlenecks and offersinformation on how to tune them.
*********
iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html
iOraBugFinder is a web based tool which scans Oracle's alert log files,
ORA-600 and ORA-7445 trace files; extracts relevant information from
them
and generates URL links to relevant bugs, notes, forums at Metalink.
*********
Received on Mon Jun 11 2001 - 04:06:23 CDT
