Differentiate file using filename

Three users at a time giving the following command:

alter database backup controlfile to trace;

How can you differentiate the file using the filename itself?

Questions by shanthiavari

Showing Answers 1 - 3 of 3 Answers

baala

  • Aug 11th, 2008
 

When you issue the command "alter database backup controlfile to trace ; " a trace file will be created in the user_dump destination.

The default name of the trace file would look something similar to
dbname_ora_5175.trc. The number 5175 is the unix process id of the user session which initiated this trace. As each user has their own unix pid, you can identify the file created by that user.

Still want to double confirm, open the trace files generated during that time and you will find the client information there.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions