Database Tuning (MOSC)

MOSC Banner

Licensing required for dbms_space.asa_recommendations?

edited Feb 14, 2012 3:23AM in Database Tuning (MOSC) 2 commentsAnswered

Hi,

We were wondering if we can use the following query without voilating any licensing requirements when it comes to tuning / diagnostic pack

SELECT segment_name,
          round(allocated_space/1024/1024,1) alloc_mb,
          round( used_space/1024/1024, 1 ) used_mb,
              round( reclaimable_space/1024/1024) reclaim_mb,
              round(reclaimable_space/allocated_space*100,0) pctsave,
              recommendations
     FROM TABLE(dbms_space.asa_recommendations())
Can someone please shed some light if we need any extra licensing to use the above and if yes, what exactly do we need
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