Oracle DBA?òμ￥2ù×÷

--?′DD′?êy?àμ?SQL

select sql_text,executions from (

     select sql_text,executions from v$sqlarea order by executions desc

     ) where rownum<81;

--?áó2?ì?àμ?SQL

select sql_text,disk_reads from(

      select sql_text,disk_reads from v$sqlarea order by disk_reads desc

)   where rownum<21;

--.2é?′?ùóDó??§￡o

select * from dba_users;

select * from all_users;

select * from user_users;

--2é?′ó??§?ò??é??μí3è¨?T(?±?ó?3?μ??ó??§?ò??é?μ??μí3è¨?T)￡o

select * from dba_sys_privs;

select * from user_sys_privs;

--2é?′??é?(???ü2é?′μ???ó??§óμóDμ???é?)?ù°üo?μ?è¨?T

select * from role_sys_privs;

--2é?′ó??§???óè¨?T

select * from dba_tab_privs;

select * from all_tab_privs;

select * from user_tab_privs;

--2é?′?ùóD??é?

select * from dba_roles;

--2é?′ó??§?ò??é??ùóμóDμ???é?

select * from dba_role_privs; 

select * from user_role_privs;

--2é?′??D?ó??§óDsysdba?òsysoper?μí3è¨?T(2é?ˉê±Dèòa?àó|è¨?T)

select * from V$PWFILE_USERS

SELECT name,spare4 FROM SYS.USER$ WHERE password is not null;