Purge sql from shared-Pool

Toad for Oracle Idea Pond
1

It would be useful to purge one or many sql-Statements from the shared - Pool.
The function could be implemented in the SGA-Trace Window.
My wish is that I mark one or many statements, and then internaly it executes the sys.dbms_shared_pool.purge command.

2

Hi Bruno,

Good idea. I'll add it.

Thanks

John

3

Hi John,

Thanks for accepting my idea.

Bruno

1 Like
4

This will be in the next beta.

Also, I have renamed this window to "Shared Pool Browser". The old name was not good, as the window has nothing to do with tracing or optimization, not to mention the fact the only portion of the SGA that it deals with is the Shared Pool.

5

I'm really impressed that it was implemented so quickly.
Thank you.

Bruno

1 Like