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:
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! :)
I really like when people are expressing their opinion and thought. So I like the way you are writing
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
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
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
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
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/
Now I am ready to do my breakfast, later than having my breakfast coming again to read additional news.
Weight loss supplement
Hi there mates, its impressive post concerning cultureand entirely defined, keep it up all
the time.
money from home
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
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
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
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)
I could not refrain from commenting. Well written!
my page Chaussure De Foot Pas Cher
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
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
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
Post writing is also a fun, if you know then you can write if not it is difficult to write.
Post a Comment