Ok, I figured it out also…
Now, do I sent it to Batch optimizer SQL ? I am trying to see if this can figure out if Indexing are needed in this execution?
But very cool for sure !!!
FYI_ you guys need better videos on steps… I am former OCS . Oracle! lol
| Jeffrey | HCCO, Inc. | (585) 236-4303 |
From: Richard To [mailto:bounce-Richard_To@toadworld.com]
Sent: Tuesday, January 28, 2014 8:53 PM
Subject: RE: [SQL Optimizer for Oracle - Discussion Forum] SQL Optimizer ( Index exercises )
RE: SQL Optimizer ( Index exercises )
Reply by Richard To
You have to capture those dynamic SQL from SQL Area after/during the execution of the proc program. You can use our “Inspect SGA” to capture those dynamic SQL.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or Unsubscribe from SQL Optimizer for Oracle - General notifications altogether.
SQL Optimizer for Oracle - Discussion Forum
Flag this post as spam/abuse.