Exadata General (MOSC)

MOSC Banner

Exadata Past cell metrics and configuration

Hello,

The AWR report contains several sections related to the Exadata cells configuration (flash cache, flash log, number of cells, etc....) and a couple of metrics for those Exadata cells.

However, what I want is to write historical SQL scripts using the following AWR views

col owner for a30
col view_name for a30

SELECT
  owner,
  view_name
FROM
  all_views
WHERE
  view_name LIKE 'DBA_HIST_CELL%';


OWNER             VIEW_NAME           
------------------------------ ------------------------------
SYS              DBA_HIST_CELL_CONFIG      
SYS              DBA_HIST_CELL_CONFIG_DETAIL  
SYS              DBA_HIST_CELL_NAME       
SYS              DBA_HIST_CELL_DISKTYPE     
SYS              DBA_HIST_CELL_DISK_NAME    
SYS              DBA_HIST_CELL_GLOBAL_SUMMARY  
SYS              DBA_HIST_CELL_DISK_SUMMARY   
SYS              DBA_HIST_CELL_METRIC_DESC   
SYS              DBA_HIST_CELL_IOREASON_NAME  
SYS              DBA_HIST_CELL_GLOBAL      
SYS              DBA_HIST_CELL_IOREASON     
SYS              DBA_HIST_CELL_DB        
SYS              DBA_HIST_CELL_OPEN_ALERTS   

13 rows selected. 

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