DBA Data[Home] [Help]

VIEW: SYS.DBA_HIST_SGA_TARGET_ADVICE

Source

View Text - Preformatted

select "SNAP_ID","DBID","INSTANCE_NUMBER","SGA_SIZE","SGA_SIZE_FACTOR","ESTD_DB_TIME","ESTD_PHYSICAL_READS","CON_DBID","CON_ID" from INT$DBA_HIST_SGA_TARGET_ADVICE
View Text - HTML Formatted

SELECT "SNAP_ID"
, "DBID"
, "INSTANCE_NUMBER"
, "SGA_SIZE"
, "SGA_SIZE_FACTOR"
, "ESTD_DB_TIME"
, "ESTD_PHYSICAL_READS"
, "CON_DBID"
, "CON_ID"
FROM INT$DBA_HIST_SGA_TARGET_ADVICE