Hello, I would be grateful with some assistance on the following :


In oracle, when you run a query where is the query plan stored?

When you run the same query twice you will get better performance on the second version because;

The actual statements are stored in the DB BUFFERS
Sorts are in memory
Library cache stores the DD calls thus reducing recursive calls.

Is this all true?

How can you manually flush the Library cache and DB Buffers?