Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle STS (SQL Tuning Set) based on Session IDs

538022Aug 24 2009 — edited Aug 25 2009

Hello,
i want to create a STS for a specific session.
I am going to login to the system and have my session id. Now i want to create a STS only with SQL statements that were performed in this particular session.

I have check the columns that are available through the PL/SQL package DBMS_SQLTUNE.SELECT_CURSOR_CACHE .. so that i can filter it .. but there is no sesssion_id.

Has anybody resolved such an issue?

Regards
Stefan

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 22 2009

Added on Aug 24 2009

#general-database-discussions

2 comments

695 views