oracle 小知识(1-10)

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;