OraFAQ Forum: SQL & PL/SQL » how can we know the execution performance

Home » SQL & PL/SQL » SQL & PL/SQL » how can we know the execution performance (

) 1 Vote

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

how can we know the execution performance [message #288577]

Tue, 18 December 2007 01:35

kommerashashi
Messages: 23
Registered: November 2007

Junior Member

Hi,

i am unable to know how the peromance will be measure....the way like distinct function will decrease the perfomance while comparing with the normal select statement.............how we know that.please help me

Thanx in advance

Report message to a moderator

Re: how can we know the execution performance [message #288582 is a reply to message #288577]

Tue, 18 December 2007 01:42

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

response time
logical io
cpu
physical io
wait times
...

Choose your criteria.

Regards
Michel

Report message to a moderator

Re: how can we know the execution performance [message #288585 is a reply to message #288577]

Tue, 18 December 2007 01:45

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

>i am unable to know how the peromance will be measure....
there is not magic instrument to know performance.

>the way like distinct function will decrease the perfomance >while comparing with the normal select statement.
Becuase there is difference between "distinct" or "normal" sql statment that is why performance also different.

>.............how we know that.please help me
It is very easy to know ...but hard to understand.
generate execution plan,autotrace output and try to understand those report.

Report message to a moderator

Re: how can we know the execution performance [message #288587 is a reply to message #288577]

Tue, 18 December 2007 01:49

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

http://www.orafaq.com/forum/mv/msg/93669/288581/102589/#msg_288581

kommerashashi wrote on Tue, 18 December 2007 08:42

we can measure the performance through................OEM tool thats called as Oracle Enterprise Managemnt tool........with that we can measure the performance ....
r else we can know throgh the TOAD fully licenced version ..we can get the measurment ............bye

kommerashashi already answered to kommerashashi's question.

[Updated on: Tue, 18 December 2007 01:50]

Report message to a moderator

Previous Topic:	How to define and use procedures
Next Topic:	Constraints

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 15:02:15 CST 2024