Comments on: Plan is same, Wait profile is different ?https://coskan.wordpress.com/2011/06/24/plan-is-same-wait-profile-is-different/
What I learned about OracleThu, 08 Dec 2016 12:24:51 +0000hourly1http://wordpress.com/By: 3hostcoupons.comhttps://coskan.wordpress.com/2011/06/24/plan-is-same-wait-profile-is-different/#comment-31731
Sat, 05 Dec 2015 10:24:24 +0000http://coskan.wordpress.com/?p=1023#comment-31731It is frustrating if you try to log on to your site, and the server is
down. Businesses looking for web hosting services would typically already have a their own domain name or register one when signing up for hosting.

In other words it’s time to turn the system off of autopilot and
decide how you want to get to your destination.

You are right it normally asks for other parameters as well if you want to see the runtime of a sql for a spesific session. At this occasion I am sure that this is the one I run so I only pass the sql_id but if you want to see session id spesific then better you also pass sql_id and sid together like below

Excellent example! I especially liked the part where the spread of sqls made such a difference. That’s the kind of trap a load test could easily miss.

]]>By: coskan gundogarhttps://coskan.wordpress.com/2011/06/24/plan-is-same-wait-profile-is-different/#comment-4585
Fri, 24 Jun 2011 13:15:26 +0000http://coskan.wordpress.com/?p=1023#comment-4585John, Thank you very much for stopping by and your comments. The shared_pool_reserved_size is not set explicitly in our case.

it normally should have been auto adjusted to its default which is 5% of the value of SHARED_POOL_SIZE but a little higher in our case which is I am not sure why.

When it comes to 10GB-8GB is just for the flexibility to grow “online” in case of a problem and secure the additional 2GB space to this database. I always find it more practical to give resources gradually to the end users so we can track down the real usage and not letting them waste the resources. When you have resource somebody will use it but real question is should they🙂

]]>By: Johnhttps://coskan.wordpress.com/2011/06/24/plan-is-same-wait-profile-is-different/#comment-4583
Fri, 24 Jun 2011 12:53:45 +0000http://coskan.wordpress.com/?p=1023#comment-4583Coskan, I think this is an excellent blog entry as it takes the reader through a good diagnostic approach and is well written and displayed.

I noted that in your seemingly similar environments shared_pool_reserved_size is 278M on prod and only 67M on QA

What do you see as the benefit of setting sga_max_size as 10Gb but sga_target to only use 8Gb. Teh additional 2Gb is still grabbed by oracle and is therefore unusable to anybody else. I appreciate that you can grow the database parameters later, without a bounce, but to my mind you might as well use that extra 2Gb in the buffer cache for now.
regards
John