Tuning issues

Tuning issues

https://jonathanlewis.wordpress.com/2016/05/05/e-rows-a-rows/

https://hourim.wordpress.com/2020/01/05/phv2/

 

https://hourim.wordpress.com/2011/06/07/trouble-shooting-read-by-other-sessions-wait-event/

https://jonathanlewis.wordpress.com/2008/02/06/trouble-shooting-2/#more-320

Query performance INDEX_FFS compared with FTS

https://community.oracle.com/thread/3924729

Cursor: Pin S Wait On X In The Top 5 Wait Events

https://blog.pythian.com/cursor-pin-s-wait-on-x-in-the-top-5-wait-events/

What is causing optimizer to ignore Parallel Hints ?

https://community.oracle.com/thread/4049237?start=0&tstart=0

https://hoopercharles.wordpress.com/2010/02/17/parallel-reasoning/

SQL Gone Bad – But Plan Not Changed? – Part 1

http://kerryosborne.oracle-guy.com/2013/06/sql-gone-bad-but-plan-not-changed/

http://kerryosborne.oracle-guy.com/2013/06/sql-gone-bad-but-plan-not-changed-part-2/

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s