| Identifying trace files and how to retrieve from the server (merged) [message #376320] |
Tue, 16 December 2008 23:27  |
sathyam2627
Messages: 52
Registered: November 2006
|
Member |
|
|
Hi,
I have few queries regarding trace files. when we trace a session related trace files will be stored in user_dump_dest directory.
Consider that we dont have access to server and working as a client to server. My queries are as follows
1. How to identify trace file names as there might be n number of trace files in user_dump_dest location and can we customized name to trace files which is generated for other sessions?
2. is it possible to change user_dump_dest direcory? If yes, is there any possible side effects?
3. How do we generate tkprof files Since this can be done at command prompt or at sql*plus? Can we generate tkprof files from server only or else we can also do the same by using client installation of database?
4. How do we read the trace files from server or tkprof files?
I know we can do this through creating a batch file but i am not getting the implementation.
Thanks in advance
|
|
|
|
|
|
|
|
| Re: Identifying trace files and how to retrieve from the server (merged) [message #376589 is a reply to message #376490] |
Wed, 17 December 2008 23:38  |
sathyam2627
Messages: 52
Registered: November 2006
|
Member |
|
|
Hi Rajendran,
Thanks for your suggestion. I would like to take brief explation about this.
1.alter session set tracefile_identifier='myidentifier' as this will work for our session trace files or also for other session trace files.
2. Trace files are residing in server. I don't have access to the server to look into it. Is there any way that i can put a copy of trace files in the client machine?
3. Tkrprof utility can we install at client side?
You are refering to a manual. can you please tell me where this would be available.
Thanks
|
|
|
|
| Re: Identifying trace files and how to retrieve from the server (merged) [message #376847 is a reply to message #376589] |
Thu, 18 December 2008 20:18 |
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
|
Senior Member |
|
|
| Quote: |
You are refering to a manual. can you please tell me where this would be available.
|
Have you read the concept document in http://tahiti.oracle.com? Or have you searched in Google about user_dump_dest - udump?
sys@LOYALTY> col name format a15
sys@LOYALTY> col value format a25
sys@LOYALTY> select name, value
2 from v$parameter
3 where name like 'user%';
NAME VALUE
--------------- -------------------------
user_dump_dest /loyalty/app/oracle/admin
/loyalty/udump
sys@LOYALTY> ! ls -l /loyalty/app/oracle/admin/loyalty/udump
total 48
-rw-r----- 1 oracle oinstall 849 Dec 15 15:11 loyalty_ora_17714.trc
-rw-r----- 1 oracle oinstall 608 Dec 15 15:12 loyalty_ora_17721.trc
-rw-r----- 1 oracle oinstall 924 Dec 15 15:12 loyalty_ora_17751.trc
-rw-r----- 1 oracle oinstall 608 Dec 15 15:13 loyalty_ora_17752.trc
-rw-r----- 1 oracle oinstall 2779 Dec 15 15:13 loyalty_ora_17779.trc
-rw-r----- 1 oracle oinstall 829 Dec 15 15:13 loyalty_ora_17806.trc
-rw-r----- 1 oracle oinstall 745 Dec 15 15:14 loyalty_ora_17817.trc
-rw-r----- 1 oracle oinstall 1152 Dec 15 15:14 loyalty_ora_17820.trc
-rw-r----- 1 oracle oinstall 793 Dec 15 15:14 loyalty_ora_17821.trc
-rw-r----- 1 oracle oinstall 608 Dec 15 15:14 loyalty_ora_17824.trc
-rw-r----- 1 oracle oinstall 664 Dec 15 15:14 loyalty_ora_17851.trc
-rw-r----- 1 oracle oinstall 708 Dec 15 15:15 loyalty_ora_17852.trc
-rw-r----- 1 oracle oinstall 792 Dec 15 15:16 loyalty_ora_17879.trc
-rw-r----- 1 oracle oinstall 608 Dec 15 15:16 loyalty_ora_17882.trc
-rw-r----- 1 oracle oinstall 664 Dec 15 15:16 loyalty_ora_17911.trc
-rw-r----- 1 oracle oinstall 792 Dec 15 15:25 loyalty_ora_17980.trc
-rw-r----- 1 oracle oinstall 608 Dec 15 15:25 loyalty_ora_17983.trc
-rw-r----- 1 oracle oinstall 664 Dec 15 15:25 loyalty_ora_18012.trc
-rw-r----- 1 oracle oinstall 960 Dec 15 15:29 loyalty_ora_18013.trc
-rw-r----- 1 oracle oinstall 608 Dec 15 15:29 loyalty_ora_18034.trc
-rw-r----- 1 oracle oinstall 664 Dec 15 15:29 loyalty_ora_18063.trc
sys@LOYALTY>
| Quote: |
2. Trace files are residing in server. I don't have access to the server to look into it. Is there any way that i can put a copy of trace files in the client machine?
|
-- No, you only to access the server with appropriate account to read them.
-- Using the account to copy them - user_trace_file to your clien
| Quote: |
3. Tkrprof utility can we install at client side?
|
-- No
Thanks [/quote]
[Updated on: Thu, 18 December 2008 20:36] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
