查询一行所在块:
select dbms_rowid.ROWID_RELATIVE_FNO(rowid) file#,dbms_rowid.ROWID_BLOCK_NUMBER(rowid) block# from scott.t where a=2;
所在段:
select * from dba_segments where segment_name='T';
查询当前系统SCN:
select dbms_flashback.get_system_change_number from dual;
查询系统进程和数据库进程对应关系:
select * from v$process;
select * from v$session;
v$process的ADDR= v$session的PADDR
select * from v$open_cursor;
v$open_cursor的SADDR= v$session的SADDR
select * from v$sqltext
v$open_cursor的ADDRESS 、HASH_VALUE = v$sqltext中的ADDRESS 、HASH_VALUE
查询用户的权限:
select * from session_privs;
select * from user_tab_privs;
select * from user_role_privs;
查询实际表空间使用量:
select sum(*)/1024/1024 from dba_segments where tablespace_name='T';
查询实际表空间数据文件使用量:
select FILE_ID,SUM(BYTES)/1024/1024 from dba_free_space where tablespace_NAME='TBS_MPS' GROUP BY FILE_ID;
查看表空间大小:
SELECT SUM(BYTES)/1024/1024 FROM DBA_DATA_FILES WHERE TABLESPACE_NAME='TBS_MPS'
在oracle中:sessions和processes的关系是:sessions=1.1*processes + 5