Home » RDBMS Server » Performance Tuning » Identifying trace files and how to retrieve from the server (merged)
Identifying trace files and how to retrieve from the server (merged) [message #376320] Tue, 16 December 2008 23:27 Go to next message
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 #376487 is a reply to message #376320] Wed, 17 December 2008 09:51 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>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?
You can create your own identifier.
alter session set tracefile_identifier='myidentifier'

>>2. is it possible to change user_dump_dest direcory? If yes, is there any possible side effects?
Yes. But it has to be in the server or some area where Oracle server can see ***all the time***. Not in your client.
>>How do we generate tkprof files Since this can be done at command prompt or at sql*plus?
It is OS utility. If you get the trace file, you use it any where.

>>4. How do we read the trace files from server or tkprof files?
Considering that you dot have access to server, you cannot do it.

Please read the fine manual.
Everything is clearly said there.
Re: Identifying trace files and how to retrieve from the server (merged) [message #376490 is a reply to message #376320] Wed, 17 December 2008 10:04 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Just another rhetoric question.
What are you trying to trace here?
If it is pl/sql, most can be accomplished with dbms_profiler.
If it is sql, trace & tkprof is the option.
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 Go to previous messageGo to next message
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 Go to previous message
trantuananh24hg
Messages: 668
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

Previous Topic: metric defintion for SYSMETRIC
Next Topic: open cursors
Goto Forum:
  


Current Time: Sat Dec 10 08:50:22 CST 2016

Total time taken to generate the page: 0.17643 seconds