OS환경 : Oracle Linux 7.6 (64bit)
DB 환경 : Oracle Database 19.15.0.0
방법 : 오라클 19c sysaux 테이블스페이스 안에 들어있는 정보 확인
v$sysaux_occupants 뷰를 이용해 sysaux 테이블스페이스에 어떤 데이터가 들어있는지 확인 가능함
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
|
SQL>
set lines 200 pages 1000
col schema_name for a25
col occupant_name for a25
select schema_name, occupant_name, occupant_desc, round(space_usage_kbytes/1024) mb
from v$sysaux_occupants
order by 4 desc;
SCHEMA_NAME OCCUPANT_NAME OCCUPANT_DESC MB
------------------------- ------------------------- ---------------------------------------------------------------- ----------
SYS SM/ADVISOR Server Manageability - Advisor Framework 11155
SYS SM/AWR Server Manageability - Automatic Workload Repository 6582
SYS SM/OPTSTAT Server Manageability - Optimizer Statistics History 1386
XDB XDB XDB 63
SYS SM/OTHER Server Manageability - Other Components 62
SYSTEM LOGMNR LogMiner 11
SYS JOB_SCHEDULER Unified Job Scheduler 8
WMSYS WM Workspace Manager 7
SYS SQL_MANAGEMENT_BASE SQL Management Base Schema 5
SYS PL/SCOPE PL/SQL Identifier Collection 3
SYS SMON_SCN_TIME Transaction Layer - SCN to TIME mapping 3
SYS AO Analytical Workspace Object Table 2
SYSTEM LOGSTDBY Logical Standby 2
SYS STREAMS Oracle Streams 2
SYS AUTO_TASK Automated Maintenance Tasks 1
DBSNMP EM_MONITORING_USER Enterprise Manager Monitoring User 1
MDSYS SDO Oracle Spatial 0
SYS XSOQHIST OLAP API History Tables 0
ORDSYS ORDIM Oracle Multimedia ORDSYS Components 0
ORDDATA ORDIM/ORDDATA Oracle Multimedia ORDDATA Components 0
ORDPLUGINS ORDIM/ORDPLUGINS Oracle Multimedia ORDPLUGINS Components 0
SI_INFORMTN_SCHEMA ORDIM/SI_INFORMTN_SCHEMA Oracle Multimedia SI_INFORMTN_SCHEMA Components 0
SYSMAN EM Enterprise Manager Repository 0
CTXSYS TEXT Oracle Text 0
WKSYS ULTRASEARCH Oracle Ultra Search 0
WK_TEST ULTRASEARCH_DEMO_USER Oracle Ultra Search Demo User 0
EXFSYS EXPRESSION_FILTER Expression Filter System 0
AUDSYS AUDSYS AUDSYS schema objects 0
TSMSYS TSM Oracle Transparent Session Migration User 0
SYS AUDIT_TABLES DB audit tables 0
PERFSTAT STATSPACK Statspack Repository 0
OLAPSYS XSAMD OLAP Catalog 0
32 rows selected.
|
cs |
'ORACLE > Admin' 카테고리의 다른 글
| 오라클 19c 테이블 compress 압축률 비교 (0) | 2023.07.27 |
|---|---|
| 오라클 19c exachk 수집 가이드 (0) | 2023.07.26 |
| 오라클 19c 동시에 같은 테이블에 datapump 시 발생하는 lock 확인 (0) | 2023.07.06 |
| 오라클 19c expdp가 ADG Standby db에서 동작하는지 확인 (1) | 2023.07.06 |
| 오라클 19c 테이블 move 시 발생하는 lock 확인 (0) | 2023.07.06 |