1.select sysdate from dual;
2.select * from v$version;
3.select name,log_mode from v$database;
4.select name, bytes from v$datafile;
5.select file_name, bytes from dba_data_files;
6.select member, bytes from v$logfile lf, v$log l where lf.group# = l.group#;
7.select name from v$controlfile;