[ Oracle - System Table 사용예제 ]
|
☞ Dictionary Table
|
| |
SELECT * FROM DICTIONARY ;
- 사용자가 소유한 모든 데이터 사전 뷰 :
SELECT table_name FROM dictionary WHERE table_name LIKE 'USER%'; |
|
☞ physical I/O가 많은 상위 10개 테이블 조회하기
|
| |
select table_name,total_phys_io
from ( select owner||'.'||object_name as table_name,
sum(value) as total_phys_io
from v$segment_statistics
where owner!='SYS' and object_type='TABLE'
and statistic_name in ('physical reads','physical reads direct',
'physical writes','physical writes direct')
group by owner||'.'||object_name
order by total_phys_io desc )
where rownum <=10; |
|
☞ DBA권한을 가진 계정 검색
|
| |
select * from dba_role_privs where granted_role='DBA' |
|
