Some commands in third day of oracle knowledge

2009-04-22 01:20:14   Category:Database    Tags:

select * from v$parameter order by name;
select * from v$spparameter order by name;

select name,value from v$parameter where isBasic='TRUE' order by name

--------data dictionary
   ----for dba
select * from dba_tables;
select * from dba_objects;
select * from dba_users;
select * from dba_data_files;
select * from dba_alert_history;
select * from dba_objects where object_name='DBA_OBJECTS';
select * from dba_objects where object_name like 'V%SQL';
select * from  v$sql;

select * from user_tables;
select * from all_tables;
  -----for view
select t.name,d.NAME,d.BYTES from v$tablespace t join v$datafile d on d.TS#=t.TS# order by t.NAME ;
select t.tablespace_name,d.file_name,d.bytes from dba_tablespaces t join dba_data_files d on t.tablespace_name=d.tablespace_name order by tablespace_name;
select * from v$controlfile;
select value from v$parameter where name='control_files';
select m.group#,m.member,g.bytes from v$log g join v$logfile m on m.group#=g.group# order by m.group#,m.member;

------management
sqlplus /nolog
connect / as sysdba;
startup nomount;
alter database mount;
alter database open;
shutdown immediate;