Monday, December 24, 2007

Way to get Query execution plan in Oracle10g

traditional method before 10g

select * from v$sql where address='&ADDRESS' and hash_value=&HASH_VALUE;

10g

select * from v$sql where sql_id='&SQL_ID';
select * from v$sqlstats where sql_id='&SQL_ID';
select * from dba_hist_sqlstat where sql_id='&SQL_ID';

select * from table(DBMS_XPLAN.DISPLAY_CURSOR('&SQL_ID', NULL, 'ALL'));
select * from table(DBMS_XPLAN.DISPLAY_AWR('&SQL_ID',&PLAN_HASH,NULL,'ALL'));

18 comments:

Anonymous said...

Your blog keeps getting better and better! Your older articles are not as good as newer ones you have a lot more creativity and originality now. Keep it up!
And according to this article, I totally agree with your opinion, but only this time! :)

Anonymous said...

I really like when people are expressing their opinion and thought. So I like the way you are writing

Anonymous said...

Thanks for the marvelous posting! I quite enjoyed reading it,
you might be a great author.I will make sure to bookmark your blog and may
come back very soon. I want to encourage that you continue
your great job, have a nice weekend!

my web site atlaslm.com

Anonymous said...

You can certainly see your skills in the work you write.
The arena hopes for more passionate writers like you who are
not afraid to say how they believe. At all times follow your heart.


Also visit my web blog :: https://www.wctt.info:1444/Alfonzo24

Anonymous said...

Superb post however I was wanting to know if you could write a litte more on this topic?

I'd be very grateful if you could elaborate a little bit further. Kudos!

Also visit my blog post Abercrombie Paris

Anonymous said...

I will immediately grab your rss as I can't to find your e-mail subscription link or newsletter service. Do you've
any? Kindly allow me understand in order that I may subscribe.
Thanks.

Review my site :: Louis Vuitton Handbags Outlet

Anonymous said...

What's up Dear, are you truly visiting this website regularly, if so after that you will without doubt take pleasant knowledge.

Also visit my webpage http://www.earlylearningpreschool.com/

Anonymous said...

Now I am ready to do my breakfast, later than having my breakfast coming again to read additional news.



Weight loss supplement

Anonymous said...

Hi there mates, its impressive post concerning cultureand entirely defined, keep it up all
the time.


money from home

Anonymous said...

For latest information you have to pay a visit world-wide-web and on web I
found this web page as a most excellent website for latest updates.


Also visit my website: Christian Louboutin UK

Anonymous said...

I do not even know how I ended up here, but I thought this post was great.

I don't know who you are but definitely you are going to a famous blogger if you aren't already ;) Cheers!


Stop by my website stiletto beats

Anonymous said...

Hi! This post couldn't be written any better! Reading this post reminds me of my old room mate! He always kept talking about this. I will forward this article to him. Pretty sure he will have a good read. Thanks for sharing!

Also visit my web site: Louis Vuitton Purses

Anonymous said...

Hello it's me, I am also visiting this site on a regular basis, this web page is really fastidious and the users are in fact sharing good thoughts.

Also visit my page ... Acai Berry Fresh Review (acaiberryfreshs.com)

Anonymous said...

I could not refrain from commenting. Well written!

my page Chaussure De Foot Pas Cher

Anonymous said...

It's going to be ending of mine day, however before ending I am reading this impressive article to improve my knowledge.

Feel free to visit my homepage ... Michael Kors Outlet

Anonymous said...

I am curious to find out what blog platform you have been working with?
I'm experiencing some small security issues with my latest site and I'd like to find something more safe.
Do you have any solutions?

Feel free to visit my blog :: Louis Vuitton Bags

Anonymous said...

Why people still make use of to read news papers when in this technological globe the whole thing is presented on web?



Have a look at my weblog ... Clash Of Clans Cheat

Anonymous said...

Post writing is also a fun, if you know then you can write if not it is difficult to write.