|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
January 9th, 2006, 01:08 PM
|
||||
|
||||
|
Trace file help
I have a user that runs a fairly complex script. It started seizing up when we had to modify some user passwords.
Although the permissions seem to be restored, the job will not complete. If we kill the job, I don't have a log. Where can I view the trace log for this file in Oracle 9i? if it isn't on by default, where can I set the trace function prior to re-running this? thanks
__________________
Curious by Nature, Linux by Choice
|
|
#2
January 9th, 2006, 01:53 PM
|
|||
|
|||
|
First line in the script:
Code:
ALTER SESSION SET SQL_TRACE TRUE; The DBA can also ALTER session. The trace file usually lives in the Oracle home tree, down in a directory called udump. This is specified by the parameter (found in v$parameter.name = user_dump_dest).
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > Trace file help |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
