A.SELECT SGA FROM V$DBA B.SELECT * FROM V$DBA C.SELECT * FROM V$SGA D.SELECT size FROM V%DBA
A.SELECT name FROM V$CONTROLFILE B.SELECT name FROM V$CTRLLFILE C.SELECT name FROM V$USERFILES D.SELECT name FROM V$DBAFILE
A.SELECT name,status FROM V$datafile B.SELECT name,status FROM V$userfile C.SELECT name,status FROM V$DBA D.SELECT name,status FROM V$ctrlfile