OraFAQ Forum: SQL & PL/SQL » How to use application tracing in oracle

Home » SQL & PL/SQL » SQL & PL/SQL » How to use application tracing in oracle

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to use application tracing in oracle [message #610270]

Wed, 19 March 2014 00:33

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

I have study many links from Google to know about how to use application tracing in oracle but I am unable to understand it, please give me some example so that I can understand it easily.

Report message to a moderator

Re: How to use application tracing in oracle [message #610274 is a reply to message #610270]

Wed, 19 March 2014 01:05

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

If this is application tracing then it must be do in application.
In database you make database tracing/auditing depending on what you actually want to achieve.

Report message to a moderator

Re: How to use application tracing in oracle [message #610277 is a reply to message #610274]

Wed, 19 March 2014 01:25

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

I want to simple example so that I can achieve it and take help from others links.

Report message to a moderator

Re: How to use application tracing in oracle [message #610279 is a reply to message #610277]

Wed, 19 March 2014 01:27

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

And what do you want to achieve?

Report message to a moderator

Re: How to use application tracing in oracle [message #610280 is a reply to message #610279]

Wed, 19 March 2014 01:36

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

Hello respected Michel, first lot of thanks you for helping me, I am just learning it and I have no more idea about that, please tell me what I can achieve from it with some instances.

Report message to a moderator

Re: How to use application tracing in oracle [message #610283 is a reply to message #610280]

Wed, 19 March 2014 01:40

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Achieve what?
If we don't know what you want to achieve we can't help you to achieve it.

Report message to a moderator

Re: How to use application tracing in oracle [message #610284 is a reply to message #610283]

Wed, 19 March 2014 01:44

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

Please give some simple instances, which you prefer me for better.

Report message to a moderator

Re: How to use application tracing in oracle [message #610295 is a reply to message #610284]

Wed, 19 March 2014 03:41

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

Hello Michel, I am expecting answer from you.

Report message to a moderator

Re: How to use application tracing in oracle [message #610299 is a reply to message #610295]

Wed, 19 March 2014 04:26

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

I am expecting an answer from you.

Quote:

Achieve what?
If we don't know what you want to achieve we can't help you to achieve it.

Report message to a moderator

Re: How to use application tracing in oracle [message #610302 is a reply to message #610299]

Wed, 19 March 2014 04:43

vslabs
Messages: 26
Registered: March 2014
Location: Cape Town

Junior Member

As Michel said - we need to know what your requirements/goals are, and exactly what your definition of application tracing is.

Do you mean instrumentation? If so, tracing of application performance? Tracing of application execution paths? Tracing for debugging? Logging of processing events and steps? Etc.

You have framed a vague question - it is unreasonable of you to "demand" an answer for that from Michel.

Report message to a moderator

Re: How to use application tracing in oracle [message #610305 is a reply to message #610302]

Wed, 19 March 2014 05:06

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

Please tell me about tracing of application performance?

Report message to a moderator

Re: How to use application tracing in oracle [message #610307 is a reply to message #610305]

Wed, 19 March 2014 05:31

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

The best and first is to do it in the application itself.
Add code at the beginning and end of each feature/function/transaction... you want to trace and record the start and end time in a file (or maybe in a db table).

Report message to a moderator

Re: How to use application tracing in oracle [message #610427 is a reply to message #610305]

Thu, 20 March 2014 00:29

vslabs
Messages: 26
Registered: March 2014
Location: Cape Town

Junior Member

aaditya321 wrote on Wed, 19 March 2014 12:06

Please tell me about tracing of application performance?

If PL/SQL, look at DBMS_PROFILER, DBMS_TRACE, and so on.

Report message to a moderator

Re: How to use application tracing in oracle [message #610430 is a reply to message #610427]

Thu, 20 March 2014 01:10

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

Already I said, I am unable to getting from given link, also I have read it from various related Google links but not improvement in my knowledge. please tell me briefly at least what is sql tracing, why we use sql tracing, what is use of sql tracing etc.

Report message to a moderator

Re: How to use application tracing in oracle [message #610432 is a reply to message #610430]

Thu, 20 March 2014 01:17

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

DBMS_TRACE is behind this link, actually; @vslabs mistakenly posted two links for DBMS_PROFILER.

Report message to a moderator

Re: How to use application tracing in oracle [message #610436 is a reply to message #610430]

Thu, 20 March 2014 01:44

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

please tell me briefly at least what is sql tracing, why we use sql tracing, what is use of sql tracing etc.

Unable to use Google or Search feature in the documentation?

Report message to a moderator

Re: How to use application tracing in oracle [message #610442 is a reply to message #610436]

Thu, 20 March 2014 02:11

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

I have read this link DBMS_TRACE 2-3 times but not fully understand then after that I came here and asking our query.

Report message to a moderator

Re: How to use application tracing in oracle [message #610444 is a reply to message #610442]

Thu, 20 March 2014 02:17

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

And what about Google for dbms_trace and or dbms_profiler to find an example?

Report message to a moderator

Re: How to use application tracing in oracle [message #610445 is a reply to message #610444]

Thu, 20 March 2014 02:22

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

I didn't get dbms_trace and or dbms_profiler an example which that available there.

Report message to a moderator

Re: How to use application tracing in oracle [message #610446 is a reply to message #610445]

Thu, 20 March 2014 02:28

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

And I get many just googling.

Report message to a moderator

Re: How to use application tracing in oracle [message #610447 is a reply to message #610446]

Thu, 20 March 2014 02:35

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

Hello respected Michel, truly you are right here but two persons can't be equal and should not be? You get many things from Googling caused your mind caliber is great, please don't compare so like and collaborate me.

Report message to a moderator

Re: How to use application tracing in oracle [message #610448 is a reply to message #610447]

Thu, 20 March 2014 02:43

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

The result of a Google search does not depend on anyone IQ or color of eyes.
So do search.
I help you: "Oracle dbms_trace example".

[Updated on: Thu, 20 March 2014 02:44]

Report message to a moderator

Previous Topic:	Writing SQL Query
Next Topic:	pls 00103 error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 15:59:35 CDT 2024