| |
GeekInterview.com > Interview Questions > Oracle > Database Administration
| Print | |
Question: Differentiate file using filename
Answer: 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? |
| August 08, 2008 04:42:30 |
#1 |
| baala |
Member Since: August 2008 Total Comments: 4 |
RE: Differentiate file using filename
|
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.
|
| |
Back To Question | |
