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'));

24 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...

Way cool! Some extremely valid points! I appreciate you writing this post plus the rest of
the site is extremely good.

Check out my weblog; Stateside Associates in Arlington VA

Anonymous said...

Excellent beat ! I would like to apprentice while you amend your web site, how could
i subscribe for a blog web site? The account aided me
a acceptable deal. I had been a little bit acquainted of this your
broadcast provided bright clear idea

Also visit my site ... Belinda Broido

Sridevi Koduru said...

I am Sridevi Koduru, Senior Oracle Apps Trainer at Oracleappstechnical.com With 8 Yrs Exp on Oracle Apps and 13 Yrs IT Exp Providing Online Training on Oracle Apps Technical, Oracle Apps Financial Functional, Oracle Apps SCM, Oracle Apps HRMS, Oracle Financial for Indian Localization, SQL, PL/SQL and D2K. I have Provided Training for 500+ Professionals Most of them are Working in Real Time now.

Contact for (One to One Personal Online Training) on Oracle Apps Technical, Oracle Apps Financial Functional, Oracle Financial for Indian Localization, Oracle Apps SCM, Oracle Apps HRMS, SQL, PL/SQL and D2K at training@oracleappstechnical.com | sridevikoduru@oracleappstechnical.com | +91 – 9581017828 | http://www.oracleappstechnical.com

LinkedIn profile - http://in.linkedin.com/pub/sridevi-koduru/8b/76a/9b8/

oakleyses said...

tory burch outlet, polo ralph lauren, ugg boots, chanel handbags, tiffany jewelry, longchamp outlet, longchamp pas cher, gucci handbags, sac longchamp pas cher, uggs on sale, jordan pas cher, michael kors pas cher, ray ban sunglasses, oakley sunglasses, polo outlet, louboutin pas cher, longchamp outlet, burberry pas cher, louis vuitton, cheap oakley sunglasses, replica watches, replica watches, longchamp outlet, christian louboutin outlet, prada handbags, oakley sunglasses wholesale, louis vuitton outlet, oakley sunglasses, ray ban sunglasses, louis vuitton, prada outlet, nike outlet, louis vuitton outlet, christian louboutin, nike free run, nike roshe, ugg boots, nike air max, polo ralph lauren outlet online, kate spade outlet, christian louboutin uk, tiffany and co, nike free, oakley sunglasses, jordan shoes, louis vuitton outlet, nike air max, ray ban sunglasses

oakleyses said...

nike tn, ralph lauren uk, true religion outlet, nike air max uk, burberry handbags, michael kors, abercrombie and fitch uk, nike blazer pas cher, oakley pas cher, timberland pas cher, hogan outlet, uggs outlet, michael kors outlet online, replica handbags, sac vanessa bruno, true religion outlet, converse pas cher, guess pas cher, ray ban pas cher, ray ban uk, true religion outlet, michael kors outlet, mulberry uk, nike roshe run uk, hollister uk, coach outlet, kate spade, nike air max, new balance, true religion jeans, north face, coach outlet store online, uggs outlet, michael kors outlet online, polo lacoste, michael kors outlet, lululemon canada, nike air force, vans pas cher, michael kors outlet, hollister pas cher, michael kors outlet online, sac hermes, michael kors, burberry outlet, michael kors outlet online, north face uk, nike air max uk

oakleyses said...

converse, louboutin, soccer jerseys, ferragamo shoes, hermes belt, longchamp uk, p90x workout, north face outlet, baseball bats, instyler, nike trainers uk, babyliss, mont blanc pens, soccer shoes, nfl jerseys, valentino shoes, oakley, hollister clothing, abercrombie and fitch, chi flat iron, ralph lauren, nike air max, north face outlet, gucci, ray ban, vans, beats by dre, herve leger, jimmy choo outlet, giuseppe zanotti outlet, mac cosmetics, ghd hair, reebok outlet, nike roshe run, hollister, mcm handbags, timberland boots, nike air max, lululemon, bottega veneta, insanity workout, nike huaraches, vans outlet, hollister, iphone cases, wedding dresses, new balance shoes, converse outlet, asics running shoes, celine handbags

oakleyses said...

marc jacobs, ugg,uggs,uggs canada, louis vuitton, swarovski, barbour uk, montre pas cher, moncler outlet, louis vuitton, canada goose outlet, louis vuitton, pandora charms, wedding dresses, juicy couture outlet, moncler, canada goose outlet, louis vuitton, canada goose uk, ugg uk, canada goose, ugg pas cher, coach outlet, hollister, moncler, canada goose outlet, ugg, pandora jewelry, moncler outlet, karen millen uk, pandora jewelry, links of london, louis vuitton, canada goose, canada goose, swarovski crystal, moncler uk, moncler, moncler, doudoune moncler, juicy couture outlet, canada goose jackets, thomas sabo, replica watches, ugg,ugg australia,ugg italia, barbour, pandora uk, supra shoes, lancel, toms shoes