Alessandro Guimarães – Oracle Blog

December 26, 2008

Database Features Usage

Filed under: banco de dados — agleite @ 8:54 pm

Tem uma view no banco que mostra se uma determinada feature está sendo utilizada. Seu nome : DBA_FEATURE_USAGE_STATISTICS (10g). Mostra se a feature foi utilizada, alem de mostrar a primeira e ultima utilização. Portanto cuidado na utilização de features que não foram licensiadas😉

SQL> l
  1  SELECT NAME,DETECTED_USAGES “USAGE”,CURRENTLY_USED,FIRST_USAGE_DATE,LAST_USAGE_DATE
  2* FROM DBA_FEATURE_USAGE_STATISTICS WHERE DETECTED_USAGES >0 order by 1
SQL> /

NAME                                            USAGE      CURRE FIRST_USA LAST_USAG
———————————————– ———- —– ——— ———
Automatic SQL Execution Memory                  1          TRUE  26-DEC-08 26-DEC-08
Automatic Segment Space Management (system)     1          TRUE  26-DEC-08 26-DEC-08
Automatic Segment Space Management (user)       1          TRUE  26-DEC-08 26-DEC-08
Automatic Undo Management                       1          TRUE  26-DEC-08 26-DEC-08
Character Set                                   1          TRUE  26-DEC-08 26-DEC-08
Locally Managed Tablespaces (system)            1          TRUE  26-DEC-08 26-DEC-08
Locally Managed Tablespaces (user)              1          TRUE  26-DEC-08 26-DEC-08
Partitioning (system)                           1          TRUE  26-DEC-08 26-DEC-08
Protection Mode – Maximum Performance           1          TRUE  26-DEC-08 26-DEC-08
Recovery Area                                   1          TRUE  26-DEC-08 26-DEC-08
Server Parameter File                           1          TRUE  26-DEC-08 26-DEC-08
Streams (system)                                1          TRUE  26-DEC-08 26-DEC-08
Streams (user)                                  1          TRUE  26-DEC-08 26-DEC-08
Virtual Private Database (VPD)                  1          TRUE  26-DEC-08 26-DEC-08
XDB                                             1          TRUE  26-DEC-08 26-DEC-08

1 Comment »

  1. Alessandro,
    Muito bom post cara… Ajudou muito, tenha certeza..

    Eder

    Comment by Eder Ferreira — March 25, 2009 @ 11:25 pm


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: