Home » SQL & PL/SQL » SQL & PL/SQL » How do I trace another session into a table?
icon5.gif  How do I trace another session into a table? [message #217743] Mon, 05 February 2007 04:06 Go to next message
yshallom
Messages: 1
Registered: February 2007
Junior Member
Hi
I’m working on a server where I cannot reach the udump directory.
I’m thinking of tracing the other session into a table yet I don’t know how to do that.
Re: How do I trace another session into a table? [message #217773 is a reply to message #217743] Mon, 05 February 2007 07:15 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Hi,
Write your own procedure to log the messages (inserting into a table) using autonomous transaction and call that wherever you want.

By
Vamsi
Re: How do I trace another session into a table? [message #217827 is a reply to message #217773] Mon, 05 February 2007 15:23 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Get your DBA to fix the permissions and enable public access in the pfile/init.
_trace_files_public = TRUE


You can load a trace file (also with some DBA setup help).

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1112673450743

Previous Topic: ORA :01652
Next Topic: make one query from multiple query
Goto Forum:
  


Current Time: Fri Dec 09 15:31:11 CST 2016

Total time taken to generate the page: 0.23381 seconds