Home » SQL & PL/SQL » SQL & PL/SQL » how can we know the execution performance  () 1 Vote
how can we know the execution performance [message #288577] Tue, 18 December 2007 01:35 Go to next message
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
Re: how can we know the execution performance [message #288582 is a reply to message #288577] Tue, 18 December 2007 01:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
response time
logical io
cpu
physical io
wait times
...

Choose your criteria.

Regards
Michel
Re: how can we know the execution performance [message #288585 is a reply to message #288577] Tue, 18 December 2007 01:45 Go to previous messageGo to next message
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.
Re: how can we know the execution performance [message #288587 is a reply to message #288577] Tue, 18 December 2007 01:49 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
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:
  


Current Time: Mon Dec 05 21:14:38 CST 2016

Total time taken to generate the page: 0.05487 seconds