SQL Performance (MOSC)

MOSC Banner

sql track on object

edited Aug 28, 2013 10:40PM in SQL Performance (MOSC) 5 commentsAnswered ✓
 Hi All,

Is there anyway we can track the sql's that used a particular object for the past 3 days,

i used this below statement  to pull sqlid ,but i also need the sql text to be included,i tried with some joins but i get various error messages,

select distinct sql_id,timestamp from dba_hist_sql_plan where timestamp > sysdate -3;

also we need to drop columns in table which are not used ,how do we check unused columns

version: 11.2.0.1

-Thanks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center