An Oracle Spin by Alex Lima

Sharing Tips & Tricks from my Database Experience

Menu Skip to content

Home
GoldenGate
General DBA
Oracle White Papers
Disclosure
About

August 22, 2010February 9, 2016 Alex Lima

Explain plan execution plan

Explain plan may not relay the correct execution plan optimizer may run, the following link shows an example
Explain Plan Lies

Share this:

Email
Tweet
Share on Tumblr
Telegram
WhatsApp

Like this:

Like Loading...

Tuning

execution
explain
incorrect
plan

Published by Alex Lima

View all posts by Alex Lima

Post navigation

Previous How to change unix prompt?

Next How to find the last time a session performed any activity?

Leave a Reply Cancel reply

Enter your comment here...

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

Email (required) (Address never made public)

Name (required)

Website

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

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

Connecting to %s

Notify me of new comments via email.

Notify me of new posts via email.

Δ

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Follow Me

Twitter
LinkedIn
YouTube

Categories

Search for:

Follow Alex's Blog

Enter your email address to follow this blog and receive notifications of new posts by email.

Email Address:

Join 4,078 other subscribers

Twitter Updates

Tweets by aoflima

Recent Posts

Migrate GoldenGate Classic to Microservices
GoldenGate Free 21c Deployment on Docker
Check for Long Open Transactions with Python
Key GoldenGate Microservices Benefits over Classic Architecture
Useful GoldenGate ACDR Views

Top Posts

Migrate GoldenGate Classic to Microservices
How to find jobs currently running or history about the jobs?
Install Chrome on Oracle Linux 7 (REHL7)
How to find the NLS_LANG to set for a database?
How to delete archive logs already archived to backup device?
How to delete/reset a parameter in spfile using ALTER SYSTEM?
How to see current utilization of processes/sessions and max utilization?
ALTER DATABASE BEGIN/END BACKUP
How to lock/unlock statistics on a table?
How to extract the DB LINKS DDL with the password

Blog at WordPress.com.

Follow Following
- An Oracle Spin by Alex Lima
- Already have a WordPress.com account? Log in now.

%d bloggers like this: