Home » SQL & PL/SQL » SQL & PL/SQL » Oracle Log files
Oracle Log files [message #315115] Sat, 19 April 2008 03:07 Go to next message
hedonist123
Messages: 119
Registered: August 2007
Senior Member
Hi,

I have executed a package to perform data migration between tables.

However, 13 hours after executing the package, the number of rows on the affected tables are not increasing and the package is still running.

I believe it could be hanging.

Is there some way I could see the log files and have a look at where exactly or at what time this has happened?

Please let me know the tables to be queried or the files to be accessed to get this information.

Thanks,

Sharath
Re: Oracle Log files [message #315123 is a reply to message #315115] Sat, 19 April 2008 03:58 Go to previous messageGo to next message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
check the link posted by Michael in this post.
http://www.orafaq.com/forum/t/100967/94420/

Regards

Raj
Re: Oracle Log files [message #315134 is a reply to message #315115] Sat, 19 April 2008 07:05 Go to previous message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>Please let me know the tables to be queried or the files to be accessed to get this information.

If there is a single COMMIT at the end of the proceedure, it may be difficult for another session to observe any progress,
because Oracle will prevent the other session from seeing changed data until after the COMMIT occurs.
Previous Topic: How to handle where clause of a procedure dynamically (merged)
Next Topic: Join Algorthim
Goto Forum:
  


Current Time: Sun Dec 11 00:09:30 CST 2016

Total time taken to generate the page: 0.09143 seconds