'1. IT Story' 카테고리의 글 목록 (28 Page)

NTP 보안 (Network Time Protocol)

1. IT Story/Basic Studies 2019. 1. 31. 18:27

NTP 보안 (Network Time Protocol)

1. NTP 보안 (Network Time Protocol)의 개요

1-1. 정의

- 인터넷을 통한 시스템들의 시간동기화를 위한 프로토콜인 NTP의 취약점을 이용한 공격유형

- monlist 획득이나 UDP123포트를 이용하여 대량의 서비스 거부 공격이 주로 발생함

1-2. 특징

- UDP 패킷 공격, 반사공격, 대용량 DDoS공격, NTP 취약점, monlist

2. NTP 보안 (Network Time Protocol)의 개념도

1) 공격자는 변조된 소스 IP를 취약한 NTP 서버로 monlist 명령어를 전송함

2) 취약한 NTP 서버는 최근 접속한 시스템 목록을 변조된 소스 IP로 monlist 명령어에 대한 Response 패킷을 전송하여 대량의 네트워크 트래픽을 유발함.

3) NTP 서비스를 이용한 DDoS 공격 수행

4) 이패킷은 다시 NTP 서버로 보내져, NTP Servers가 DDoS 공격 유발

3. NTP 보안 (Network Time Protocol)의 보안 취약점 및 대응방안

1) 망분리

취약점: NTP Monlist 패킷, Web Shell 취약점, 대용량 DDos 공격

대응방안: 망분리를 통한 외부 NTP 서버 접속 차단, 사내망 NTP 서버 별도 도입 검토

2) 서비스 조사

취약점: 서버 전수 검사, 대량의 서버에 대한 관리적 방안 보안 필요

대응방안: NTP 서비스 실행중인 서버 대상 파악, NTP 서비스 사용 여부에 대한 검토 진행

3) 기술적 처리

취약점: 원격 쉘 명령어를 통해서 서비스 확인, 보안 스캐너 장비 이용 등

대응방안: NTP 버전 업데이트, NTP 설정 파일 수정 등

저작자표시 동일조건

'1. IT Story > Basic Studies' 카테고리의 다른 글

자율주행자동차 (0)	2019.02.07
소프트웨어 가시화 (Software Visualization) (0)	2019.02.03
아두이노 (Arduino) (0)	2019.02.02
라즈베리파이 (Raspberry Pi) (0)	2019.01.31
PoE (Power over Ethernet) (0)	2019.01.30
CASB(Cloud Access Security Broker) (0)	2019.01.30
Conversational platforms-대화형 플랫폼 (0)	2019.01.28
SDN(Software-Defined Network) (0)	2019.01.28

운명을바꾸는자

IT와 함께 살아가는 삶

,

PoE (Power over Ethernet)

1. IT Story/Basic Studies 2019. 1. 30. 20:28

PoE (Power over Ethernet)

1. PoE (Power over Ethernet)의 개요

1-1. 정의

- 중앙 스위치에서 이더넷으로 연결된 디바이스(VoIP 전화기, WLAN 송신기 등)까지 전력이 전송되는 기술

- 표준 LAN인프라 상에서 파워와 Data를 동시에 공급하는 기술

1-2. 특징

1) 지능화 : N/W관리자가 SNMP를 이용 전원 차단 또는 공급 가능

2) 비용절감: 별도의 전원장비 또는 전원선 포서 비용이 절감됨

3) 설치용이 : 전원과 상관없이 제품 설치가 가능

4) 신뢰성 : UPS를 Ethernet 스위치와 사용할 경우, 주 전원이 중단 되어도 동작 가능

2. PoE (Power over Ethernet)의 구성도 및 구성요소

2-1. PoE (Power over Ethernet) 구성도

- PoE 스위치는 전원과 Ethernet을 입력 받아서 하나의 선로에 전원, 데이터를 동시에 공급한다.

2-2. PoE (Power over Ethernet) 구성요소

1) PoE 스위치 : 전원과 Ethernet을 동시에 입력 받아서 하나의 선로로 공급

2) Midspan : PoE 스위칭 기능과 더불어 PoE 카메라를 자동인식

3) Splitter : PoE 케이블에서 전원과 Data를 분리하여 Non-PoE제품을 지원

3. PoE (Power over Ethernet) 장점 및 활용

3-1. 장점

- 신뢰성: 전원이 나간 경우에도 지속적인 가능이 가능하도록 함

- 효율성: 에너지 효율성 개선을 위한 전력 중앙관리, 장애 감지, 치유, 사용량 감소 기능

- 단순성: 다른 전력 공급 어댑터를 찾을 필요가 없음

- 비용절감: 별개의 전선 및 아웃렛 설치가 필요 없어 설치 비용 절감

3-2. 활용

- 네트워크 보안 카메라, 무선랜 액세스, VoIP 전화기 등에서 활용이 가능하다.

저작자표시 동일조건

'1. IT Story > Basic Studies' 카테고리의 다른 글

소프트웨어 가시화 (Software Visualization) (0)	2019.02.03
아두이노 (Arduino) (0)	2019.02.02
라즈베리파이 (Raspberry Pi) (0)	2019.01.31
NTP 보안 (Network Time Protocol) (0)	2019.01.31
CASB(Cloud Access Security Broker) (0)	2019.01.30
Conversational platforms-대화형 플랫폼 (0)	2019.01.28
SDN(Software-Defined Network) (0)	2019.01.28
V2X(Vehicle to everything) (0)	2019.01.27

운명을바꾸는자

IT와 함께 살아가는 삶

,

CASB(Cloud Access Security Broker)

1. IT Story/Basic Studies 2019. 1. 30. 20:06

CASB(Cloud Access Security Broker)

1. CASB(Cloud Access Security Broker)의 개요

1-1. 정의

- 클라우드 이용에 있어서 안전을 담보해 주는 중개자 기능을 제공하는 보안 레이어

1-2. 핵심기능

1) 클라우드 서비스 검색 및 위험평가 : 서비스 위험평가와 회사에서 사용중인 모든 클라우드 서비스 검색

2) 암호화 : 기업 제어 암호화 키를 사용하여 클라우드 데이터 암호화

3) 접근통제 : 사용자,장치,위치의 컨텍스트를 기반으로 클라우드 서비스에 대한 접근제어

4) 데이터 손실 방지(DLP) : 내부 정보 유출방지 또는 사용중인 DLP 솔루션과의 통합을 통해 클라우드로 이동하는 데이터 DLP 적용

5) 로깅 및 감사 : 클라우드 서비스에서 수행한 모든 작업의 로깅 및 감사 추적을 통해 법규 및 보안정책 준수 여부를 검증하고 잠재적 위반 조사

6) 이상탐지 : 잠재적인 데이터 유출, 보안 위반 등을 판단하여 보안 관리자에게 제시 및 해당 이용자에게 경고

2. CASB(Cloud Access Security Broker)의 특징 비교

3. CASB(Cloud Access Security Broker)의 고려사항

- 보안정책 변경에 따른 정책의 일치성, 동시성 보장

- 중복된 보안기능 수행 최소화

- CASB 사이의 효율적이고 안전한 보안통신

저작자표시 동일조건

'1. IT Story > Basic Studies' 카테고리의 다른 글

아두이노 (Arduino) (0)	2019.02.02
라즈베리파이 (Raspberry Pi) (0)	2019.01.31
NTP 보안 (Network Time Protocol) (0)	2019.01.31
PoE (Power over Ethernet) (0)	2019.01.30
Conversational platforms-대화형 플랫폼 (0)	2019.01.28
SDN(Software-Defined Network) (0)	2019.01.28
V2X(Vehicle to everything) (0)	2019.01.27
몰입 경험(Immersive Experience) (0)	2019.01.25

운명을바꾸는자

IT와 함께 살아가는 삶

,

Oracle SEGMENT STAT 조회 스크립트

1. IT Story/Scripts 2019. 1. 29. 23:23

SEGMENT STAT 조회 스크립트

WITH A

AS ( SELECT DBID,

OBJ#,

SUM (LOGICAL_READS_DELTA) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS_DELTA) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES_DELTA) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS_DELTA) PHYSICAL_READS,

SUM (PHYSICAL_WRITES_DELTA) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT_DELTA) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT_DELTA) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS_DELTA) ITL_WAITS,

SUM (ROW_LOCK_WAITS_DELTA) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED_DELTA) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED_DELTA) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED_DELTA) SPACE_USED,

SUM (SPACE_ALLOCATED_DELTA) SPACE_ALLOCATED,

SUM (TABLE_SCANS_DELTA) TABLE_SCANS

FROM DBA_HIST_SEG_STAT

WHERE DBID = (select dbid from v$database) --변경

AND INSTANCE_NUMBER = (select INSTANCE_NUMBER from v$instance) --변경

AND SNAP_ID BETWEEN :3 AND :4

GROUP BY DBID, OBJ#),

A_TOT

AS (SELECT NULL DBID,

NULL OBJ#,

SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS,

COUNT (DISTINCT OBJ#) OBJ_CNT

FROM A),

A_LR

AS (SELECT V.VIEWTYPE,

V.RNUM,

V.DBID,

DO.OWNER,

NVL (DO.OBJECT_NAME, TO_CHAR (V.OBJ#)) OBJECT_NAME,

DO.SUBOBJECT_NAME,

DO.OBJECT_TYPE,

V.LOGICAL_READS,

V.BUFFER_BUSY_WAITS,

V.DB_BLOCK_CHANGES,

V.PHYSICAL_READS,

V.PHYSICAL_WRITES,

V.PHYSICAL_READS_DIRECT,

V.PHYSICAL_WRITES_DIRECT,

V.ITL_WAITS,

V.ROW_LOCK_WAITS,

V.GC_CR_BLOCKS_SERVED,

V.GC_CU_BLOCKS_SERVED,

V.SPACE_USED,

V.SPACE_ALLOCATED,

V.TABLE_SCANS

FROM (SELECT 'LOGICAL READS' VIEWTYPE,

DBID,

OBJ#,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

ROW_NUMBER ()

OVER (

ORDER BY

LOGICAL_READS DESC, PHYSICAL_READS DESC, ROWNUM)

RNUM

FROM A) V,

DBA_OBJECTS DO

WHERE V.OBJ# = DO.OBJECT_ID(+) AND RNUM <= :5 AND ROWNUM <= :6),

A_BBW

AS (SELECT V.VIEWTYPE,

V.RNUM,

V.DBID,

DO.OWNER,

NVL (DO.OBJECT_NAME, TO_CHAR (V.OBJ#)) OBJECT_NAME,

DO.SUBOBJECT_NAME,

DO.OBJECT_TYPE,

V.LOGICAL_READS,

V.BUFFER_BUSY_WAITS,

V.DB_BLOCK_CHANGES,

V.PHYSICAL_READS,

V.PHYSICAL_WRITES,

V.PHYSICAL_READS_DIRECT,

V.PHYSICAL_WRITES_DIRECT,

V.ITL_WAITS,

V.ROW_LOCK_WAITS,

V.GC_CR_BLOCKS_SERVED,

V.GC_CU_BLOCKS_SERVED,

V.SPACE_USED,

V.SPACE_ALLOCATED,

V.TABLE_SCANS

FROM (SELECT 'BUFFER BUSY WAITS' VIEWTYPE,

DBID,

OBJ#,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

ROW_NUMBER ()

OVER (

ORDER BY

BUFFER_BUSY_WAITS DESC,

LOGICAL_READS DESC,

ROWNUM)

RNUM

FROM A) V,

DBA_OBJECTS DO

WHERE V.OBJ# = DO.OBJECT_ID(+) AND RNUM <= :7 AND ROWNUM <= :8),

A_DBC

AS (SELECT V.VIEWTYPE,

V.RNUM,

V.DBID,

DO.OWNER,

NVL (DO.OBJECT_NAME, TO_CHAR (V.OBJ#)) OBJECT_NAME,

DO.SUBOBJECT_NAME,

DO.OBJECT_TYPE,

V.LOGICAL_READS,

V.BUFFER_BUSY_WAITS,

V.DB_BLOCK_CHANGES,

V.PHYSICAL_READS,

V.PHYSICAL_WRITES,

V.PHYSICAL_READS_DIRECT,

V.PHYSICAL_WRITES_DIRECT,

V.ITL_WAITS,

V.ROW_LOCK_WAITS,

V.GC_CR_BLOCKS_SERVED,

V.GC_CU_BLOCKS_SERVED,

V.SPACE_USED,

V.SPACE_ALLOCATED,

V.TABLE_SCANS

FROM (SELECT 'DB_BLOCK CHANGES' VIEWTYPE,

DBID,

OBJ#,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

ROW_NUMBER ()

OVER (

ORDER BY

DB_BLOCK_CHANGES DESC,

LOGICAL_READS DESC,

ROWNUM)

RNUM

FROM A) V,

DBA_OBJECTS DO

WHERE V.OBJ# = DO.OBJECT_ID(+) AND RNUM <= :9 AND ROWNUM <= :10),

A_PR

AS (SELECT V.VIEWTYPE,

V.RNUM,

V.DBID,

DO.OWNER,

NVL (DO.OBJECT_NAME, TO_CHAR (V.OBJ#)) OBJECT_NAME,

DO.SUBOBJECT_NAME,

DO.OBJECT_TYPE,

V.LOGICAL_READS,

V.BUFFER_BUSY_WAITS,

V.DB_BLOCK_CHANGES,

V.PHYSICAL_READS,

V.PHYSICAL_WRITES,

V.PHYSICAL_READS_DIRECT,

V.PHYSICAL_WRITES_DIRECT,

V.ITL_WAITS,

V.ROW_LOCK_WAITS,

V.GC_CR_BLOCKS_SERVED,

V.GC_CU_BLOCKS_SERVED,

V.SPACE_USED,

V.SPACE_ALLOCATED,

V.TABLE_SCANS

FROM (SELECT 'PHYSICAL READS' VIEWTYPE,

DBID,

OBJ#,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

ROW_NUMBER ()

OVER (

ORDER BY

PHYSICAL_READS DESC, LOGICAL_READS DESC, ROWNUM)

RNUM

FROM A) V,

DBA_OBJECTS DO

WHERE V.OBJ# = DO.OBJECT_ID(+) AND RNUM <= :11 AND ROWNUM <= :12),

A_PW

AS (SELECT V.VIEWTYPE,

V.RNUM,

V.DBID,

DO.OWNER,

NVL (DO.OBJECT_NAME, TO_CHAR (V.OBJ#)) OBJECT_NAME,

DO.SUBOBJECT_NAME,

DO.OBJECT_TYPE,

V.LOGICAL_READS,

V.BUFFER_BUSY_WAITS,

V.DB_BLOCK_CHANGES,

V.PHYSICAL_READS,

V.PHYSICAL_WRITES,

V.PHYSICAL_READS_DIRECT,

V.PHYSICAL_WRITES_DIRECT,

V.ITL_WAITS,

V.ROW_LOCK_WAITS,

V.GC_CR_BLOCKS_SERVED,

V.GC_CU_BLOCKS_SERVED,

V.SPACE_USED,

V.SPACE_ALLOCATED,

V.TABLE_SCANS

FROM (SELECT 'PHYSICAL WRITES' VIEWTYPE,

DBID,

OBJ#,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

ROW_NUMBER ()

OVER (

ORDER BY

PHYSICAL_WRITES DESC,

LOGICAL_READS DESC,

ROWNUM)

RNUM

FROM A) V,

DBA_OBJECTS DO

WHERE V.OBJ# = DO.OBJECT_ID(+) AND RNUM <= :13 AND ROWNUM <= :14),

A_PRD

AS (SELECT V.VIEWTYPE,

V.RNUM,

V.DBID,

DO.OWNER,

NVL (DO.OBJECT_NAME, TO_CHAR (V.OBJ#)) OBJECT_NAME,

DO.SUBOBJECT_NAME,

DO.OBJECT_TYPE,

V.LOGICAL_READS,

V.BUFFER_BUSY_WAITS,

V.DB_BLOCK_CHANGES,

V.PHYSICAL_READS,

V.PHYSICAL_WRITES,

V.PHYSICAL_READS_DIRECT,

V.PHYSICAL_WRITES_DIRECT,

V.ITL_WAITS,

V.ROW_LOCK_WAITS,

V.GC_CR_BLOCKS_SERVED,

V.GC_CU_BLOCKS_SERVED,

V.SPACE_USED,

V.SPACE_ALLOCATED,

V.TABLE_SCANS

FROM (SELECT 'PHYSICAL READS DIRECT' VIEWTYPE,

DBID,

OBJ#,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

ROW_NUMBER ()

OVER (

ORDER BY

PHYSICAL_READS_DIRECT DESC,

LOGICAL_READS DESC,

ROWNUM)

RNUM

FROM A) V,

DBA_OBJECTS DO

WHERE V.OBJ# = DO.OBJECT_ID(+) AND RNUM <= :15 AND ROWNUM <= :16),

A_IW

AS (SELECT V.VIEWTYPE,

V.RNUM,

V.DBID,

DO.OWNER,

NVL (DO.OBJECT_NAME, TO_CHAR (V.OBJ#)) OBJECT_NAME,

DO.SUBOBJECT_NAME,

DO.OBJECT_TYPE,

V.LOGICAL_READS,

V.BUFFER_BUSY_WAITS,

V.DB_BLOCK_CHANGES,

V.PHYSICAL_READS,

V.PHYSICAL_WRITES,

V.PHYSICAL_READS_DIRECT,

V.PHYSICAL_WRITES_DIRECT,

V.ITL_WAITS,

V.ROW_LOCK_WAITS,

V.GC_CR_BLOCKS_SERVED,

V.GC_CU_BLOCKS_SERVED,

V.SPACE_USED,

V.SPACE_ALLOCATED,

V.TABLE_SCANS

FROM (SELECT 'ITL WAITS' VIEWTYPE,

DBID,

OBJ#,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

ROW_NUMBER ()

OVER (

ORDER BY

ITL_WAITS DESC, LOGICAL_READS DESC, ROWNUM)

RNUM

FROM A) V,

DBA_OBJECTS DO

WHERE V.OBJ# = DO.OBJECT_ID(+) AND RNUM <= :17 AND ROWNUM <= :18),

A_RLW

AS (SELECT V.VIEWTYPE,

V.RNUM,

V.DBID,

DO.OWNER,

NVL (DO.OBJECT_NAME, TO_CHAR (V.OBJ#)) OBJECT_NAME,

DO.SUBOBJECT_NAME,

DO.OBJECT_TYPE,

V.LOGICAL_READS,

V.BUFFER_BUSY_WAITS,

V.DB_BLOCK_CHANGES,

V.PHYSICAL_READS,

V.PHYSICAL_WRITES,

V.PHYSICAL_READS_DIRECT,

V.PHYSICAL_WRITES_DIRECT,

V.ITL_WAITS,

V.ROW_LOCK_WAITS,

V.GC_CR_BLOCKS_SERVED,

V.GC_CU_BLOCKS_SERVED,

V.SPACE_USED,

V.SPACE_ALLOCATED,

V.TABLE_SCANS

FROM (SELECT 'ROW LOCK WAITS' VIEWTYPE,

DBID,

OBJ#,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

ROW_NUMBER ()

OVER (

ORDER BY

ROW_LOCK_WAITS DESC, LOGICAL_READS DESC, ROWNUM)

RNUM

FROM A) V,

DBA_OBJECTS DO

WHERE V.OBJ# = DO.OBJECT_ID(+) AND RNUM <= :19 AND ROWNUM <= :20),

A_GCRBS

AS (SELECT V.VIEWTYPE,

V.RNUM,

V.DBID,

DO.OWNER,

NVL (DO.OBJECT_NAME, TO_CHAR (V.OBJ#)) OBJECT_NAME,

DO.SUBOBJECT_NAME,

DO.OBJECT_TYPE,

V.LOGICAL_READS,

V.BUFFER_BUSY_WAITS,

V.DB_BLOCK_CHANGES,

V.PHYSICAL_READS,

V.PHYSICAL_WRITES,

V.PHYSICAL_READS_DIRECT,

V.PHYSICAL_WRITES_DIRECT,

V.ITL_WAITS,

V.ROW_LOCK_WAITS,

V.GC_CR_BLOCKS_SERVED,

V.GC_CU_BLOCKS_SERVED,

V.SPACE_USED,

V.SPACE_ALLOCATED,

V.TABLE_SCANS

FROM (SELECT 'GC CR BLOCKS SERVED' VIEWTYPE,

DBID,

OBJ#,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

ROW_NUMBER ()

OVER (

ORDER BY

GC_CR_BLOCKS_SERVED DESC,

LOGICAL_READS DESC,

ROWNUM)

RNUM

FROM A) V,

DBA_OBJECTS DO

WHERE V.OBJ# = DO.OBJECT_ID(+) AND RNUM <= :21 AND ROWNUM <= :22),

A_GCUBS

AS (SELECT V.VIEWTYPE,

V.RNUM,

V.DBID,

DO.OWNER,

NVL (DO.OBJECT_NAME, TO_CHAR (V.OBJ#)) OBJECT_NAME,

DO.SUBOBJECT_NAME,

DO.OBJECT_TYPE,

V.LOGICAL_READS,

V.BUFFER_BUSY_WAITS,

V.DB_BLOCK_CHANGES,

V.PHYSICAL_READS,

V.PHYSICAL_WRITES,

V.PHYSICAL_READS_DIRECT,

V.PHYSICAL_WRITES_DIRECT,

V.ITL_WAITS,

V.ROW_LOCK_WAITS,

V.GC_CR_BLOCKS_SERVED,

V.GC_CU_BLOCKS_SERVED,

V.SPACE_USED,

V.SPACE_ALLOCATED,

V.TABLE_SCANS

FROM (SELECT 'GC CU BLOCKS SERVED' VIEWTYPE,

DBID,

OBJ#,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

ROW_NUMBER ()

OVER (

ORDER BY

GC_CU_BLOCKS_SERVED DESC,

LOGICAL_READS DESC,

ROWNUM)

RNUM

FROM A) V,

DBA_OBJECTS DO

WHERE V.OBJ# = DO.OBJECT_ID(+) AND RNUM <= :23 AND ROWNUM <= :24),

A_SU

AS (SELECT V.VIEWTYPE,

V.RNUM,

V.DBID,

DO.OWNER,

NVL (DO.OBJECT_NAME, TO_CHAR (V.OBJ#)) OBJECT_NAME,

DO.SUBOBJECT_NAME,

DO.OBJECT_TYPE,

V.LOGICAL_READS,

V.BUFFER_BUSY_WAITS,

V.DB_BLOCK_CHANGES,

V.PHYSICAL_READS,

V.PHYSICAL_WRITES,

V.PHYSICAL_READS_DIRECT,

V.PHYSICAL_WRITES_DIRECT,

V.ITL_WAITS,

V.ROW_LOCK_WAITS,

V.GC_CR_BLOCKS_SERVED,

V.GC_CU_BLOCKS_SERVED,

V.SPACE_USED,

V.SPACE_ALLOCATED,

V.TABLE_SCANS

FROM (SELECT 'SPACE USED' VIEWTYPE,

DBID,

OBJ#,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

ROW_NUMBER ()

OVER (

ORDER BY

SPACE_USED DESC, LOGICAL_READS DESC, ROWNUM)

RNUM

FROM A) V,

DBA_OBJECTS DO

WHERE V.OBJ# = DO.OBJECT_ID(+) AND RNUM <= :25 AND ROWNUM <= :26),

A_SA

AS (SELECT V.VIEWTYPE,

V.RNUM,

V.DBID,

DO.OWNER,

NVL (DO.OBJECT_NAME, TO_CHAR (V.OBJ#)) OBJECT_NAME,

DO.SUBOBJECT_NAME,

DO.OBJECT_TYPE,

V.LOGICAL_READS,

V.BUFFER_BUSY_WAITS,

V.DB_BLOCK_CHANGES,

V.PHYSICAL_READS,

V.PHYSICAL_WRITES,

V.PHYSICAL_READS_DIRECT,

V.PHYSICAL_WRITES_DIRECT,

V.ITL_WAITS,

V.ROW_LOCK_WAITS,

V.GC_CR_BLOCKS_SERVED,

V.GC_CU_BLOCKS_SERVED,

V.SPACE_USED,

V.SPACE_ALLOCATED,

V.TABLE_SCANS

FROM (SELECT 'SPACE ALLOCATED' VIEWTYPE,

DBID,

OBJ#,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

ROW_NUMBER ()

OVER (

ORDER BY

SPACE_ALLOCATED DESC,

LOGICAL_READS DESC,

ROWNUM)

RNUM

FROM A) V,

DBA_OBJECTS DO

WHERE V.OBJ# = DO.OBJECT_ID(+) AND RNUM <= :27 AND ROWNUM <= :28),

A_TS

AS (SELECT V.VIEWTYPE,

V.RNUM,

V.DBID,

DO.OWNER,

NVL (DO.OBJECT_NAME, TO_CHAR (V.OBJ#)) OBJECT_NAME,

DO.SUBOBJECT_NAME,

DO.OBJECT_TYPE,

V.LOGICAL_READS,

V.BUFFER_BUSY_WAITS,

V.DB_BLOCK_CHANGES,

V.PHYSICAL_READS,

V.PHYSICAL_WRITES,

V.PHYSICAL_READS_DIRECT,

V.PHYSICAL_WRITES_DIRECT,

V.ITL_WAITS,

V.ROW_LOCK_WAITS,

V.GC_CR_BLOCKS_SERVED,

V.GC_CU_BLOCKS_SERVED,

V.SPACE_USED,

V.SPACE_ALLOCATED,

V.TABLE_SCANS

FROM (SELECT 'TABLE SCANS' VIEWTYPE,

DBID,

OBJ#,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

ROW_NUMBER ()

OVER (

ORDER BY

TABLE_SCANS DESC, LOGICAL_READS DESC, ROWNUM)

RNUM

FROM A) V,

DBA_OBJECTS DO

WHERE V.OBJ# = DO.OBJECT_ID(+) AND RNUM <= :29 AND ROWNUM <= :30)

SELECT /*+ OPT_PARAM('_gby_hash_aggregation_enabled','TRUE') OPT_PARAM('_optimizer_distinct_agg_transform','FALSE') BUG_9002336 */

A.VIEWTYPE,

A.TOR,

A.RNUM,

A.OWNER,

DECODE (A.SUBOBJECT_NAME,

NULL, A.OBJECT_NAME,

A.OBJECT_NAME || '(' || A.SUBOBJECT_NAME || ')')

OBJECT_NAME,

A.OBJECT_TYPE,

TO_CHAR (A.LOGICAL_READS,

'FM999,999,999,999,999,999,999,999,999,999,999')

LOGICAL_READS,

TO_CHAR (A.BUFFER_BUSY_WAITS,

'FM999,999,999,999,999,999,999,999,999,999,999')

BUFFER_BUSY_WAITS,

TO_CHAR (A.DB_BLOCK_CHANGES,

'FM999,999,999,999,999,999,999,999,999,999,999')

DB_BLOCK_CHANGES,

TO_CHAR (A.PHYSICAL_READS,

'FM999,999,999,999,999,999,999,999,999,999,999')

PHYSICAL_READS,

TO_CHAR (A.PHYSICAL_WRITES,

'FM999,999,999,999,999,999,999,999,999,999,999')

PHYSICAL_WRITES,

TO_CHAR (A.PHYSICAL_READS_DIRECT,

'FM999,999,999,999,999,999,999,999,999,999,999')

PHYSICAL_READS_DIRECT,

TO_CHAR (A.PHYSICAL_WRITES_DIRECT,

'FM999,999,999,999,999,999,999,999,999,999,999')

PHYSICAL_WRITES_DIRECT,

TO_CHAR (A.ITL_WAITS, 'FM999,999,999,999,999,999,999,999,999,999,999')

ITL_WAITS,

TO_CHAR (A.ROW_LOCK_WAITS,

'FM999,999,999,999,999,999,999,999,999,999,999')

ROW_LOCK_WAITS,

TO_CHAR (A.GC_CR_BLOCKS_SERVED,

'FM999,999,999,999,999,999,999,999,999,999,999')

GC_CR_BLOCKS_SERVED,

TO_CHAR (A.GC_CU_BLOCKS_SERVED,

'FM999,999,999,999,999,999,999,999,999,999,999')

GC_CU_BLOCKS_SERVED,

TO_CHAR (A.SPACE_USED,

'FM999,999,999,999,999,999,999,999,999,999,999')

SPACE_USED,

TO_CHAR (A.SPACE_ALLOCATED,

'FM999,999,999,999,999,999,999,999,999,999,999')

SPACE_ALLOCATED,

TO_CHAR (A.TABLE_SCANS,

'FM999,999,999,999,999,999,999,999,999,999,999')

TABLE_SCANS

FROM (SELECT VIEWTYPE,

RNUM,

DBID,

OWNER,

OBJECT_NAME,

SUBOBJECT_NAME,

OBJECT_TYPE,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

1 TOR

FROM A_LR

UNION ALL

SELECT 'LOGICAL READS' VIEWTYPE,

NULL RNUM,

0 DBID,

NULL OWNER,

'ETC' OBJECT_NAME,

NULL SUBOBJECT_NAME,

NULL OBJECT_TYPE,

V2.LOGICAL_READS - V1.LOGICAL_READS LOGICAL_READS,

V2.BUFFER_BUSY_WAITS - V1.BUFFER_BUSY_WAITS BUFFER_BUSY_WAITS,

V2.DB_BLOCK_CHANGES - V1.DB_BLOCK_CHANGES DB_BLOCK_CHANGES,

V2.PHYSICAL_READS - V1.PHYSICAL_READS PHYSICAL_READS,

V2.PHYSICAL_WRITES - V1.PHYSICAL_WRITES PHYSICAL_WRITES,

V2.PHYSICAL_READS_DIRECT - V1.PHYSICAL_READS_DIRECT

PHYSICAL_READS_DIRECT,

V2.PHYSICAL_WRITES_DIRECT - V1.PHYSICAL_WRITES_DIRECT

PHYSICAL_WRITES_DIRECT,

V2.ITL_WAITS - V1.ITL_WAITS ITL_WAITS,

V2.ROW_LOCK_WAITS - V1.ROW_LOCK_WAITS ROW_LOCK_WAITS,

V2.GC_CR_BLOCKS_SERVED - V1.GC_CR_BLOCKS_SERVED

GC_CR_BLOCKS_SERVED,

V2.GC_CU_BLOCKS_SERVED - V1.GC_CU_BLOCKS_SERVED

GC_CU_BLOCKS_SERVED,

V2.SPACE_USED - V1.SPACE_USED SPACE_USED,

V2.SPACE_ALLOCATED - V1.SPACE_ALLOCATED SPACE_ALLOCATED,

V2.TABLE_SCANS - V1.TABLE_SCANS TABLE_SCANS,

1 TOR

FROM (SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_LR) V1,

(SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_TOT) V2

UNION ALL

SELECT VIEWTYPE,

RNUM,

DBID,

OWNER,

OBJECT_NAME,

SUBOBJECT_NAME,

OBJECT_TYPE,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

3 TOR

FROM A_BBW

UNION ALL

SELECT 'BUFFER BUSY WAITS' VIEWTYPE,

NULL RNUM,

0 DBID,

NULL OWNER,

'ETC' OBJECT_NAME,

NULL SUBOBJECT_NAME,

NULL OBJECT_TYPE,

V2.LOGICAL_READS - V1.LOGICAL_READS LOGICAL_READS,

V2.BUFFER_BUSY_WAITS - V1.BUFFER_BUSY_WAITS BUFFER_BUSY_WAITS,

V2.DB_BLOCK_CHANGES - V1.DB_BLOCK_CHANGES DB_BLOCK_CHANGES,

V2.PHYSICAL_READS - V1.PHYSICAL_READS PHYSICAL_READS,

V2.PHYSICAL_WRITES - V1.PHYSICAL_WRITES PHYSICAL_WRITES,

V2.PHYSICAL_READS_DIRECT - V1.PHYSICAL_READS_DIRECT

PHYSICAL_READS_DIRECT,

V2.PHYSICAL_WRITES_DIRECT - V1.PHYSICAL_WRITES_DIRECT

PHYSICAL_WRITES_DIRECT,

V2.ITL_WAITS - V1.ITL_WAITS ITL_WAITS,

V2.ROW_LOCK_WAITS - V1.ROW_LOCK_WAITS ROW_LOCK_WAITS,

V2.GC_CR_BLOCKS_SERVED - V1.GC_CR_BLOCKS_SERVED

GC_CR_BLOCKS_SERVED,

V2.GC_CU_BLOCKS_SERVED - V1.GC_CU_BLOCKS_SERVED

GC_CU_BLOCKS_SERVED,

V2.SPACE_USED - V1.SPACE_USED SPACE_USED,

V2.SPACE_ALLOCATED - V1.SPACE_ALLOCATED SPACE_ALLOCATED,

V2.TABLE_SCANS - V1.TABLE_SCANS TABLE_SCANS,

3 TOR

FROM (SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_BBW) V1,

(SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_TOT) V2

UNION ALL

SELECT VIEWTYPE,

RNUM,

DBID,

OWNER,

OBJECT_NAME,

SUBOBJECT_NAME,

OBJECT_TYPE,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

4 TOR

FROM A_DBC

UNION ALL

SELECT 'DB_BLOCK CHANGES' VIEWTYPE,

NULL RNUM,

0 DBID,

NULL OWNER,

'ETC' OBJECT_NAME,

NULL SUBOBJECT_NAME,

NULL OBJECT_TYPE,

V2.LOGICAL_READS - V1.LOGICAL_READS LOGICAL_READS,

V2.BUFFER_BUSY_WAITS - V1.BUFFER_BUSY_WAITS BUFFER_BUSY_WAITS,

V2.DB_BLOCK_CHANGES - V1.DB_BLOCK_CHANGES DB_BLOCK_CHANGES,

V2.PHYSICAL_READS - V1.PHYSICAL_READS PHYSICAL_READS,

V2.PHYSICAL_WRITES - V1.PHYSICAL_WRITES PHYSICAL_WRITES,

V2.PHYSICAL_READS_DIRECT - V1.PHYSICAL_READS_DIRECT

PHYSICAL_READS_DIRECT,

V2.PHYSICAL_WRITES_DIRECT - V1.PHYSICAL_WRITES_DIRECT

PHYSICAL_WRITES_DIRECT,

V2.ITL_WAITS - V1.ITL_WAITS ITL_WAITS,

V2.ROW_LOCK_WAITS - V1.ROW_LOCK_WAITS ROW_LOCK_WAITS,

V2.GC_CR_BLOCKS_SERVED - V1.GC_CR_BLOCKS_SERVED

GC_CR_BLOCKS_SERVED,

V2.GC_CU_BLOCKS_SERVED - V1.GC_CU_BLOCKS_SERVED

GC_CU_BLOCKS_SERVED,

V2.SPACE_USED - V1.SPACE_USED SPACE_USED,

V2.SPACE_ALLOCATED - V1.SPACE_ALLOCATED SPACE_ALLOCATED,

V2.TABLE_SCANS - V1.TABLE_SCANS TABLE_SCANS,

4 TOR

FROM (SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_DBC) V1,

(SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_TOT) V2

UNION ALL

SELECT VIEWTYPE,

RNUM,

DBID,

OWNER,

OBJECT_NAME,

SUBOBJECT_NAME,

OBJECT_TYPE,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

2 TOR

FROM A_PR

UNION ALL

SELECT 'PHYSICAL READS' VIEWTYPE,

NULL RNUM,

0 DBID,

NULL OWNER,

'ETC' OBJECT_NAME,

NULL SUBOBJECT_NAME,

NULL OBJECT_TYPE,

V2.LOGICAL_READS - V1.LOGICAL_READS LOGICAL_READS,

V2.BUFFER_BUSY_WAITS - V1.BUFFER_BUSY_WAITS BUFFER_BUSY_WAITS,

V2.DB_BLOCK_CHANGES - V1.DB_BLOCK_CHANGES DB_BLOCK_CHANGES,

V2.PHYSICAL_READS - V1.PHYSICAL_READS PHYSICAL_READS,

V2.PHYSICAL_WRITES - V1.PHYSICAL_WRITES PHYSICAL_WRITES,

V2.PHYSICAL_READS_DIRECT - V1.PHYSICAL_READS_DIRECT

PHYSICAL_READS_DIRECT,

V2.PHYSICAL_WRITES_DIRECT - V1.PHYSICAL_WRITES_DIRECT

PHYSICAL_WRITES_DIRECT,

V2.ITL_WAITS - V1.ITL_WAITS ITL_WAITS,

V2.ROW_LOCK_WAITS - V1.ROW_LOCK_WAITS ROW_LOCK_WAITS,

V2.GC_CR_BLOCKS_SERVED - V1.GC_CR_BLOCKS_SERVED

GC_CR_BLOCKS_SERVED,

V2.GC_CU_BLOCKS_SERVED - V1.GC_CU_BLOCKS_SERVED

GC_CU_BLOCKS_SERVED,

V2.SPACE_USED - V1.SPACE_USED SPACE_USED,

V2.SPACE_ALLOCATED - V1.SPACE_ALLOCATED SPACE_ALLOCATED,

V2.TABLE_SCANS - V1.TABLE_SCANS TABLE_SCANS,

2 TOR

FROM (SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_PR) V1,

(SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_TOT) V2

UNION ALL

SELECT VIEWTYPE,

RNUM,

DBID,

OWNER,

OBJECT_NAME,

SUBOBJECT_NAME,

OBJECT_TYPE,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

5 TOR

FROM A_PW

UNION ALL

SELECT 'PHYSICAL WRITES' VIEWTYPE,

NULL RNUM,

0 DBID,

NULL OWNER,

'ETC' OBJECT_NAME,

NULL SUBOBJECT_NAME,

NULL OBJECT_TYPE,

V2.LOGICAL_READS - V1.LOGICAL_READS LOGICAL_READS,

V2.BUFFER_BUSY_WAITS - V1.BUFFER_BUSY_WAITS BUFFER_BUSY_WAITS,

V2.DB_BLOCK_CHANGES - V1.DB_BLOCK_CHANGES DB_BLOCK_CHANGES,

V2.PHYSICAL_READS - V1.PHYSICAL_READS PHYSICAL_READS,

V2.PHYSICAL_WRITES - V1.PHYSICAL_WRITES PHYSICAL_WRITES,

V2.PHYSICAL_READS_DIRECT - V1.PHYSICAL_READS_DIRECT

PHYSICAL_READS_DIRECT,

V2.PHYSICAL_WRITES_DIRECT - V1.PHYSICAL_WRITES_DIRECT

PHYSICAL_WRITES_DIRECT,

V2.ITL_WAITS - V1.ITL_WAITS ITL_WAITS,

V2.ROW_LOCK_WAITS - V1.ROW_LOCK_WAITS ROW_LOCK_WAITS,

V2.GC_CR_BLOCKS_SERVED - V1.GC_CR_BLOCKS_SERVED

GC_CR_BLOCKS_SERVED,

V2.GC_CU_BLOCKS_SERVED - V1.GC_CU_BLOCKS_SERVED

GC_CU_BLOCKS_SERVED,

V2.SPACE_USED - V1.SPACE_USED SPACE_USED,

V2.SPACE_ALLOCATED - V1.SPACE_ALLOCATED SPACE_ALLOCATED,

V2.TABLE_SCANS - V1.TABLE_SCANS TABLE_SCANS,

5 TOR

FROM (SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_PW) V1,

(SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_TOT) V2

UNION ALL

SELECT VIEWTYPE,

RNUM,

DBID,

OWNER,

OBJECT_NAME,

SUBOBJECT_NAME,

OBJECT_TYPE,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

6 TOR

FROM A_PRD

UNION ALL

SELECT 'PHYSICAL READS DIRECT' VIEWTYPE,

NULL RNUM,

0 DBID,

NULL OWNER,

'ETC' OBJECT_NAME,

NULL SUBOBJECT_NAME,

NULL OBJECT_TYPE,

V2.LOGICAL_READS - V1.LOGICAL_READS LOGICAL_READS,

V2.BUFFER_BUSY_WAITS - V1.BUFFER_BUSY_WAITS BUFFER_BUSY_WAITS,

V2.DB_BLOCK_CHANGES - V1.DB_BLOCK_CHANGES DB_BLOCK_CHANGES,

V2.PHYSICAL_READS - V1.PHYSICAL_READS PHYSICAL_READS,

V2.PHYSICAL_WRITES - V1.PHYSICAL_WRITES PHYSICAL_WRITES,

V2.PHYSICAL_READS_DIRECT - V1.PHYSICAL_READS_DIRECT

PHYSICAL_READS_DIRECT,

V2.PHYSICAL_WRITES_DIRECT - V1.PHYSICAL_WRITES_DIRECT

PHYSICAL_WRITES_DIRECT,

V2.ITL_WAITS - V1.ITL_WAITS ITL_WAITS,

V2.ROW_LOCK_WAITS - V1.ROW_LOCK_WAITS ROW_LOCK_WAITS,

V2.GC_CR_BLOCKS_SERVED - V1.GC_CR_BLOCKS_SERVED

GC_CR_BLOCKS_SERVED,

V2.GC_CU_BLOCKS_SERVED - V1.GC_CU_BLOCKS_SERVED

GC_CU_BLOCKS_SERVED,

V2.SPACE_USED - V1.SPACE_USED SPACE_USED,

V2.SPACE_ALLOCATED - V1.SPACE_ALLOCATED SPACE_ALLOCATED,

V2.TABLE_SCANS - V1.TABLE_SCANS TABLE_SCANS,

6 TOR

FROM (SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_PRD) V1,

(SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_TOT) V2

UNION ALL

SELECT VIEWTYPE,

RNUM,

DBID,

OWNER,

OBJECT_NAME,

SUBOBJECT_NAME,

OBJECT_TYPE,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

7 TOR

FROM A_IW

UNION ALL

SELECT 'ITL WAITS' VIEWTYPE,

NULL RNUM,

0 DBID,

NULL OWNER,

'ETC' OBJECT_NAME,

NULL SUBOBJECT_NAME,

NULL OBJECT_TYPE,

V2.LOGICAL_READS - V1.LOGICAL_READS LOGICAL_READS,

V2.BUFFER_BUSY_WAITS - V1.BUFFER_BUSY_WAITS BUFFER_BUSY_WAITS,

V2.DB_BLOCK_CHANGES - V1.DB_BLOCK_CHANGES DB_BLOCK_CHANGES,

V2.PHYSICAL_READS - V1.PHYSICAL_READS PHYSICAL_READS,

V2.PHYSICAL_WRITES - V1.PHYSICAL_WRITES PHYSICAL_WRITES,

V2.PHYSICAL_READS_DIRECT - V1.PHYSICAL_READS_DIRECT

PHYSICAL_READS_DIRECT,

V2.PHYSICAL_WRITES_DIRECT - V1.PHYSICAL_WRITES_DIRECT

PHYSICAL_WRITES_DIRECT,

V2.ITL_WAITS - V1.ITL_WAITS ITL_WAITS,

V2.ROW_LOCK_WAITS - V1.ROW_LOCK_WAITS ROW_LOCK_WAITS,

V2.GC_CR_BLOCKS_SERVED - V1.GC_CR_BLOCKS_SERVED

GC_CR_BLOCKS_SERVED,

V2.GC_CU_BLOCKS_SERVED - V1.GC_CU_BLOCKS_SERVED

GC_CU_BLOCKS_SERVED,

V2.SPACE_USED - V1.SPACE_USED SPACE_USED,

V2.SPACE_ALLOCATED - V1.SPACE_ALLOCATED SPACE_ALLOCATED,

V2.TABLE_SCANS - V1.TABLE_SCANS TABLE_SCANS,

7 TOR

FROM (SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_IW) V1,

(SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_TOT) V2

UNION ALL

SELECT VIEWTYPE,

RNUM,

DBID,

OWNER,

OBJECT_NAME,

SUBOBJECT_NAME,

OBJECT_TYPE,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

8 TOR

FROM A_RLW

UNION ALL

SELECT 'ROW LOCK WAITS' VIEWTYPE,

NULL RNUM,

0 DBID,

NULL OWNER,

'ETC' OBJECT_NAME,

NULL SUBOBJECT_NAME,

NULL OBJECT_TYPE,

V2.LOGICAL_READS - V1.LOGICAL_READS LOGICAL_READS,

V2.BUFFER_BUSY_WAITS - V1.BUFFER_BUSY_WAITS BUFFER_BUSY_WAITS,

V2.DB_BLOCK_CHANGES - V1.DB_BLOCK_CHANGES DB_BLOCK_CHANGES,

V2.PHYSICAL_READS - V1.PHYSICAL_READS PHYSICAL_READS,

V2.PHYSICAL_WRITES - V1.PHYSICAL_WRITES PHYSICAL_WRITES,

V2.PHYSICAL_READS_DIRECT - V1.PHYSICAL_READS_DIRECT

PHYSICAL_READS_DIRECT,

V2.PHYSICAL_WRITES_DIRECT - V1.PHYSICAL_WRITES_DIRECT

PHYSICAL_WRITES_DIRECT,

V2.ITL_WAITS - V1.ITL_WAITS ITL_WAITS,

V2.ROW_LOCK_WAITS - V1.ROW_LOCK_WAITS ROW_LOCK_WAITS,

V2.GC_CR_BLOCKS_SERVED - V1.GC_CR_BLOCKS_SERVED

GC_CR_BLOCKS_SERVED,

V2.GC_CU_BLOCKS_SERVED - V1.GC_CU_BLOCKS_SERVED

GC_CU_BLOCKS_SERVED,

V2.SPACE_USED - V1.SPACE_USED SPACE_USED,

V2.SPACE_ALLOCATED - V1.SPACE_ALLOCATED SPACE_ALLOCATED,

V2.TABLE_SCANS - V1.TABLE_SCANS TABLE_SCANS,

8 TOR

FROM (SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_RLW) V1,

(SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_TOT) V2

UNION ALL

SELECT VIEWTYPE,

RNUM,

DBID,

OWNER,

OBJECT_NAME,

SUBOBJECT_NAME,

OBJECT_TYPE,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

9 TOR

FROM A_GCRBS

UNION ALL

SELECT 'GC CR BLOCKS SERVED' VIEWTYPE,

NULL RNUM,

0 DBID,

NULL OWNER,

'ETC' OBJECT_NAME,

NULL SUBOBJECT_NAME,

NULL OBJECT_TYPE,

V2.LOGICAL_READS - V1.LOGICAL_READS LOGICAL_READS,

V2.BUFFER_BUSY_WAITS - V1.BUFFER_BUSY_WAITS BUFFER_BUSY_WAITS,

V2.DB_BLOCK_CHANGES - V1.DB_BLOCK_CHANGES DB_BLOCK_CHANGES,

V2.PHYSICAL_READS - V1.PHYSICAL_READS PHYSICAL_READS,

V2.PHYSICAL_WRITES - V1.PHYSICAL_WRITES PHYSICAL_WRITES,

V2.PHYSICAL_READS_DIRECT - V1.PHYSICAL_READS_DIRECT

PHYSICAL_READS_DIRECT,

V2.PHYSICAL_WRITES_DIRECT - V1.PHYSICAL_WRITES_DIRECT

PHYSICAL_WRITES_DIRECT,

V2.ITL_WAITS - V1.ITL_WAITS ITL_WAITS,

V2.ROW_LOCK_WAITS - V1.ROW_LOCK_WAITS ROW_LOCK_WAITS,

V2.GC_CR_BLOCKS_SERVED - V1.GC_CR_BLOCKS_SERVED

GC_CR_BLOCKS_SERVED,

V2.GC_CU_BLOCKS_SERVED - V1.GC_CU_BLOCKS_SERVED

GC_CU_BLOCKS_SERVED,

V2.SPACE_USED - V1.SPACE_USED SPACE_USED,

V2.SPACE_ALLOCATED - V1.SPACE_ALLOCATED SPACE_ALLOCATED,

V2.TABLE_SCANS - V1.TABLE_SCANS TABLE_SCANS,

9 TOR

FROM (SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_GCRBS) V1,

(SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_TOT) V2

UNION ALL

SELECT VIEWTYPE,

RNUM,

DBID,

OWNER,

OBJECT_NAME,

SUBOBJECT_NAME,

OBJECT_TYPE,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

10 TOR

FROM A_GCUBS

UNION ALL

SELECT 'GC CU BLOCKS SERVED' VIEWTYPE,

NULL RNUM,

0 DBID,

NULL OWNER,

'ETC' OBJECT_NAME,

NULL SUBOBJECT_NAME,

NULL OBJECT_TYPE,

V2.LOGICAL_READS - V1.LOGICAL_READS LOGICAL_READS,

V2.BUFFER_BUSY_WAITS - V1.BUFFER_BUSY_WAITS BUFFER_BUSY_WAITS,

V2.DB_BLOCK_CHANGES - V1.DB_BLOCK_CHANGES DB_BLOCK_CHANGES,

V2.PHYSICAL_READS - V1.PHYSICAL_READS PHYSICAL_READS,

V2.PHYSICAL_WRITES - V1.PHYSICAL_WRITES PHYSICAL_WRITES,

V2.PHYSICAL_READS_DIRECT - V1.PHYSICAL_READS_DIRECT

PHYSICAL_READS_DIRECT,

V2.PHYSICAL_WRITES_DIRECT - V1.PHYSICAL_WRITES_DIRECT

PHYSICAL_WRITES_DIRECT,

V2.ITL_WAITS - V1.ITL_WAITS ITL_WAITS,

V2.ROW_LOCK_WAITS - V1.ROW_LOCK_WAITS ROW_LOCK_WAITS,

V2.GC_CR_BLOCKS_SERVED - V1.GC_CR_BLOCKS_SERVED

GC_CR_BLOCKS_SERVED,

V2.GC_CU_BLOCKS_SERVED - V1.GC_CU_BLOCKS_SERVED

GC_CU_BLOCKS_SERVED,

V2.SPACE_USED - V1.SPACE_USED SPACE_USED,

V2.SPACE_ALLOCATED - V1.SPACE_ALLOCATED SPACE_ALLOCATED,

V2.TABLE_SCANS - V1.TABLE_SCANS TABLE_SCANS,

10 TOR

FROM (SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_GCUBS) V1,

(SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_TOT) V2

UNION ALL

SELECT VIEWTYPE,

RNUM,

DBID,

OWNER,

OBJECT_NAME,

SUBOBJECT_NAME,

OBJECT_TYPE,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

11 TOR

FROM A_SU

UNION ALL

SELECT 'SPACE USED' VIEWTYPE,

NULL RNUM,

0 DBID,

NULL OWNER,

'ETC' OBJECT_NAME,

NULL SUBOBJECT_NAME,

NULL OBJECT_TYPE,

V2.LOGICAL_READS - V1.LOGICAL_READS LOGICAL_READS,

V2.BUFFER_BUSY_WAITS - V1.BUFFER_BUSY_WAITS BUFFER_BUSY_WAITS,

V2.DB_BLOCK_CHANGES - V1.DB_BLOCK_CHANGES DB_BLOCK_CHANGES,

V2.PHYSICAL_READS - V1.PHYSICAL_READS PHYSICAL_READS,

V2.PHYSICAL_WRITES - V1.PHYSICAL_WRITES PHYSICAL_WRITES,

V2.PHYSICAL_READS_DIRECT - V1.PHYSICAL_READS_DIRECT

PHYSICAL_READS_DIRECT,

V2.PHYSICAL_WRITES_DIRECT - V1.PHYSICAL_WRITES_DIRECT

PHYSICAL_WRITES_DIRECT,

V2.ITL_WAITS - V1.ITL_WAITS ITL_WAITS,

V2.ROW_LOCK_WAITS - V1.ROW_LOCK_WAITS ROW_LOCK_WAITS,

V2.GC_CR_BLOCKS_SERVED - V1.GC_CR_BLOCKS_SERVED

GC_CR_BLOCKS_SERVED,

V2.GC_CU_BLOCKS_SERVED - V1.GC_CU_BLOCKS_SERVED

GC_CU_BLOCKS_SERVED,

V2.SPACE_USED - V1.SPACE_USED SPACE_USED,

V2.SPACE_ALLOCATED - V1.SPACE_ALLOCATED SPACE_ALLOCATED,

V2.TABLE_SCANS - V1.TABLE_SCANS TABLE_SCANS,

11 TOR

FROM (SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_SU) V1,

(SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_TOT) V2

UNION ALL

SELECT VIEWTYPE,

RNUM,

DBID,

OWNER,

OBJECT_NAME,

SUBOBJECT_NAME,

OBJECT_TYPE,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

12 TOR

FROM A_SA

UNION ALL

SELECT 'SPACE ALLOCATED' VIEWTYPE,

NULL RNUM,

0 DBID,

NULL OWNER,

'ETC' OBJECT_NAME,

NULL SUBOBJECT_NAME,

NULL OBJECT_TYPE,

V2.LOGICAL_READS - V1.LOGICAL_READS LOGICAL_READS,

V2.BUFFER_BUSY_WAITS - V1.BUFFER_BUSY_WAITS BUFFER_BUSY_WAITS,

V2.DB_BLOCK_CHANGES - V1.DB_BLOCK_CHANGES DB_BLOCK_CHANGES,

V2.PHYSICAL_READS - V1.PHYSICAL_READS PHYSICAL_READS,

V2.PHYSICAL_WRITES - V1.PHYSICAL_WRITES PHYSICAL_WRITES,

V2.PHYSICAL_READS_DIRECT - V1.PHYSICAL_READS_DIRECT

PHYSICAL_READS_DIRECT,

V2.PHYSICAL_WRITES_DIRECT - V1.PHYSICAL_WRITES_DIRECT

PHYSICAL_WRITES_DIRECT,

V2.ITL_WAITS - V1.ITL_WAITS ITL_WAITS,

V2.ROW_LOCK_WAITS - V1.ROW_LOCK_WAITS ROW_LOCK_WAITS,

V2.GC_CR_BLOCKS_SERVED - V1.GC_CR_BLOCKS_SERVED

GC_CR_BLOCKS_SERVED,

V2.GC_CU_BLOCKS_SERVED - V1.GC_CU_BLOCKS_SERVED

GC_CU_BLOCKS_SERVED,

V2.SPACE_USED - V1.SPACE_USED SPACE_USED,

V2.SPACE_ALLOCATED - V1.SPACE_ALLOCATED SPACE_ALLOCATED,

V2.TABLE_SCANS - V1.TABLE_SCANS TABLE_SCANS,

12 TOR

FROM (SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_SA) V1,

(SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_TOT) V2

UNION ALL

SELECT VIEWTYPE,

RNUM,

DBID,

OWNER,

OBJECT_NAME,

SUBOBJECT_NAME,

OBJECT_TYPE,

LOGICAL_READS,

BUFFER_BUSY_WAITS,

DB_BLOCK_CHANGES,

PHYSICAL_READS,

PHYSICAL_WRITES,

PHYSICAL_READS_DIRECT,

PHYSICAL_WRITES_DIRECT,

ITL_WAITS,

ROW_LOCK_WAITS,

GC_CR_BLOCKS_SERVED,

GC_CU_BLOCKS_SERVED,

SPACE_USED,

SPACE_ALLOCATED,

TABLE_SCANS,

13 TOR

FROM A_TS

UNION ALL

SELECT 'TABLE SCANS' VIEWTYPE,

NULL RNUM,

0 DBID,

TO_CHAR (V2.OBJ_CNT) OWNER,

'ETC' OBJECT_NAME,

NULL SUBOBJECT_NAME,

NULL OBJECT_TYPE,

V2.LOGICAL_READS - V1.LOGICAL_READS LOGICAL_READS,

V2.BUFFER_BUSY_WAITS - V1.BUFFER_BUSY_WAITS BUFFER_BUSY_WAITS,

V2.DB_BLOCK_CHANGES - V1.DB_BLOCK_CHANGES DB_BLOCK_CHANGES,

V2.PHYSICAL_READS - V1.PHYSICAL_READS PHYSICAL_READS,

V2.PHYSICAL_WRITES - V1.PHYSICAL_WRITES PHYSICAL_WRITES,

V2.PHYSICAL_READS_DIRECT - V1.PHYSICAL_READS_DIRECT

PHYSICAL_READS_DIRECT,

V2.PHYSICAL_WRITES_DIRECT - V1.PHYSICAL_WRITES_DIRECT

PHYSICAL_WRITES_DIRECT,

V2.ITL_WAITS - V1.ITL_WAITS ITL_WAITS,

V2.ROW_LOCK_WAITS - V1.ROW_LOCK_WAITS ROW_LOCK_WAITS,

V2.GC_CR_BLOCKS_SERVED - V1.GC_CR_BLOCKS_SERVED

GC_CR_BLOCKS_SERVED,

V2.GC_CU_BLOCKS_SERVED - V1.GC_CU_BLOCKS_SERVED

GC_CU_BLOCKS_SERVED,

V2.SPACE_USED - V1.SPACE_USED SPACE_USED,

V2.SPACE_ALLOCATED - V1.SPACE_ALLOCATED SPACE_ALLOCATED,

V2.TABLE_SCANS - V1.TABLE_SCANS TABLE_SCANS,

13 TOR

FROM (SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS

FROM A_TS) V1,

(SELECT SUM (LOGICAL_READS) LOGICAL_READS,

SUM (BUFFER_BUSY_WAITS) BUFFER_BUSY_WAITS,

SUM (DB_BLOCK_CHANGES) DB_BLOCK_CHANGES,

SUM (PHYSICAL_READS) PHYSICAL_READS,

SUM (PHYSICAL_WRITES) PHYSICAL_WRITES,

SUM (PHYSICAL_READS_DIRECT) PHYSICAL_READS_DIRECT,

SUM (PHYSICAL_WRITES_DIRECT) PHYSICAL_WRITES_DIRECT,

SUM (ITL_WAITS) ITL_WAITS,

SUM (ROW_LOCK_WAITS) ROW_LOCK_WAITS,

SUM (GC_CR_BLOCKS_SERVED) GC_CR_BLOCKS_SERVED,

SUM (GC_CU_BLOCKS_SERVED) GC_CU_BLOCKS_SERVED,

SUM (SPACE_USED) SPACE_USED,

SUM (SPACE_ALLOCATED) SPACE_ALLOCATED,

SUM (TABLE_SCANS) TABLE_SCANS,

SUM (OBJ_CNT) OBJ_CNT

FROM A_TOT) V2) A

ORDER BY TOR, VIEWTYPE, RNUM

저작자표시 동일조건

'1. IT Story > Scripts' 카테고리의 다른 글

Oracle DBMS_SCHEDULER 백업 설정 스크립트 (0)	2019.02.06
Oracle Hot Backup 스크립트 (0)	2019.02.05
Oracle 테이블스페이스 용량확인 스크립트 (0)	2019.02.04
Oracle 권한확인 스크립트 (0)	2019.02.03
Oracle 인덱스 정리 대상 추출 스크립트 (0)	2019.01.28
Oracle DB의 OS 상태 조회 스크립트 (0)	2019.01.27
OS(리눅스) 5초단위로 서버 및 DB 상태 출력 스크립트 (0)	2019.01.24
Oracle Alert Log Viewer (11gR2) (0)	2019.01.19

운명을바꾸는자

IT와 함께 살아가는 삶

,

Oracle 인덱스 정리 대상 추출 스크립트

1. IT Story/Scripts 2019. 1. 28. 22:20

Oracle 인덱스 정리 대상 추출 스크립트

set linesize 130

set pagesize 10000

col "OWNER" form a8

col table_name form a30

col "삭제대상 INDEX" form a35

col "삭제원인 INDEX" form a51

select

di.table_owner "OWNER"

,di.table_name

,dic1.index_name || chr(10) || '>' || replace(dic1.index_cols,' ',',') || decode(sign(dic1.cnt-6),1,'...') "삭제대상 INDEX"

,dic2.index_name || chr(10) || '>' || replace(dic2.index_cols,' ',',') || decode(sign(dic1.cnt-7),1,'...') "삭제원인 INDEX"

from

dba_indexes di

,(

select

table_owner,table_name,index_owner,index_name,

TRIM(MAX(DECODE(column_position, 1, column_name)) || ' ' ||

MAX(DECODE(column_position, 2, column_name)) || ' ' ||

MAX(DECODE(column_position, 3, column_name)) || ' ' ||

MAX(DECODE(column_position, 4, column_name)) || ' ' ||

MAX(DECODE(column_position, 5, column_name)) || ' ' ||

MAX(DECODE(column_position, 6, column_name))) INDEX_COLS,count(*) cnt

from dba_ind_columns dic

where table_owner not in ('SYS','SYSTEM')

group by

table_owner,table_name,index_owner,index_name

) dic1

,(

select

table_owner,table_name,index_owner,index_name,

TRIM(MAX(DECODE(column_position, 1, column_name)) || ' ' ||

MAX(DECODE(column_position, 2, column_name)) || ' ' ||

MAX(DECODE(column_position, 3, column_name)) || ' ' ||

MAX(DECODE(column_position, 4, column_name)) || ' ' ||

MAX(DECODE(column_position, 5, column_name)) || ' ' ||

MAX(DECODE(column_position, 6, column_name)) || ' ' ||

MAX(DECODE(column_position, 7, column_name))) INDEX_COLS,count(*) cnt

from dba_ind_columns dic

where table_owner not in ('SYS','SYSTEM')

group by

table_owner,table_name,index_owner,index_name

) dic2

where

di.table_owner not in ('SYS','SYSTEM')

and di.owner=dic1.index_owner

and di.index_name=dic1.index_name

and di.table_owner=dic1.table_owner

and di.table_name=dic1.table_name

and dic1.table_owner=dic2.table_owner

and dic1.table_name=dic2.table_name

and dic1.index_name<>dic2.index_name

and dic2.index_cols like dic1.index_cols || '%'

and dic2.cnt>dic1.cnt

저작자표시 동일조건

'1. IT Story > Scripts' 카테고리의 다른 글

Oracle Hot Backup 스크립트 (0)	2019.02.05
Oracle 테이블스페이스 용량확인 스크립트 (0)	2019.02.04
Oracle 권한확인 스크립트 (0)	2019.02.03
Oracle SEGMENT STAT 조회 스크립트 (0)	2019.01.29
Oracle DB의 OS 상태 조회 스크립트 (0)	2019.01.27
OS(리눅스) 5초단위로 서버 및 DB 상태 출력 스크립트 (0)	2019.01.24
Oracle Alert Log Viewer (11gR2) (0)	2019.01.19
Oracle Wait Event 조회 스크립트 (0)	2019.01.16

운명을바꾸는자

IT와 함께 살아가는 삶

,

Conversational platforms-대화형 플랫폼

1. IT Story/Basic Studies 2019. 1. 28. 22:02

Conversational platforms - 대화형 플랫폼

1. Conversational platforms의 개요

1-1. 정의

- 사용자가 컴퓨터의 언어를 습득하지 않아도 컴퓨터가 사람의 언어를 이해할 수 있도록 도와 사용자의 부담을 줄여주며, 사용자가 자연어를 활용해 기술과 상호작용할 수 있도록 함

- 대화형 플랫폼 시장은 가상개인비서(VPA), 가상고객비서(VCA), 가상직원비서(VEA), 챗봇

2. Conversational platforms의 구성도, 주요기술

2-1. Conversational platforms의 구성도

- 참고자료: 가트너의 2018 IT 트렌드 전망

2-2. Conversational platforms의 주요기술

1) 패턴 인식 (Pattern Recognition)

- 기계에 의하여 도형, 문자, 음성 등을 식별시키는 것

2) 자연어 처리 (Natural Language)

- 인간이 보통 쓰는 언어를 컴퓨터에 인식시켜서 처리하는 과정

- 정보검색, 질의응답 시스템, 자동변역 및 통역 등이 포함

3) 시맨틱 웹 (Semantic Web)

- 컴퓨터가 정보자원의 뜻을 이해하고 논리적 추론까지 할 수 있는 차세대 지능형 웹

4) 텍스트 마이닝(Text Mining)

- 비정형 텍스트 데이터에서 새롭고 유용한 정보를 찾아내는 과정 또는 기술

5) 상황인식컴퓨팅(Context Aware Computing)

- 가상공간에서 현실의 상황을 정보화하고 이를 활용하여 사용하는 중심의 지능화된 서비스를 제공하는 기술

3. Conversational platforms의 고려사항

- 현재 상용화된 대화형 플랫폼은 사용자의 의도를 파악하는 능력이 제한적이기 때문에 간단한 질문과 대화 정도를 처리하는 경우가 많다.

- 대화형 인공지능 기술을 기반으로 구축되는 ‘통합 대화형 플랫폼’이 필요 (가상개인비서(VPA), 가상고객비서(VCA), 가상직원비서(VEA), 챗봇)

- 애플의 시리, 마이크로소프트의 코타나, 아마존의 알렉사, 구글 어시스턴트, 바이두의 두어OS(DuerOS), IBM의 왓슨

[참고자료]

https://news.samsung.com/kr/%EC%B6%98%EC%B6%94%EC%A0%84%EA%B5%AD%EC%8B%9C%EB%8C%80-%EB%8C%80%ED%99%94%ED%98%95-ai-%EC%8B%9C%EC%9E%A5-%EC%84%A0%EC%A0%90-%EC%B5%9C%EC%9A%B0%EC%84%A0-%EA%B3%BC%EC%A0%9C%EB%8A%94-2

http://www.hellot.net/new_hellot/magazine/magazine_read.html?code=202&sub=001&idx=40686

https://blog.naver.com/kmkim1222/10159401919

저작자표시 동일조건

'1. IT Story > Basic Studies' 카테고리의 다른 글

라즈베리파이 (Raspberry Pi) (0)	2019.01.31
NTP 보안 (Network Time Protocol) (0)	2019.01.31
PoE (Power over Ethernet) (0)	2019.01.30
CASB(Cloud Access Security Broker) (0)	2019.01.30
SDN(Software-Defined Network) (0)	2019.01.28
V2X(Vehicle to everything) (0)	2019.01.27
몰입 경험(Immersive Experience) (0)	2019.01.25
OTT (Over The Top) (0)	2019.01.24

운명을바꾸는자

IT와 함께 살아가는 삶

,

SDN(Software-Defined Network)

1. IT Story/Basic Studies 2019. 1. 28. 20:59

SDN(Software-Defined Network)

1. SDN(Software-Defined Network)의 개요

1-1. 정의

- 소프트웨어 프로그래밍을 통해 네트워크 경로 설정과 제어 및 복잡한 운영관리를 편리하게 처리할 수 있는 차세대 네트워킹 기술

- 물리적 전송 부분과 SW제어 부분 분리하여 중앙 집중 관리 하는 네트워킹 기술.

- 네트워크 운영 효율화가 목적임.

1-2. 목적 및 필요성

1) 목적

- NW 유연성 향상, 운영관리 단순화

- NW 가용성 향상, 빠른 서비스 설정과 전달

- NW 기능 자동화 역량 향상

2) 필요성

- 네트워크 스위치, 라우터의 벤더간 인터페이스 상이

- 폐쇄형 네트워크 유지보수 어려움

- 폐쇄형 -> Open형을 발전시킨 OpenFlow 기술 등장

2. SDN의 구성도, 주요요소기술

2-1. SDN의 구성도

- 참고자료: 정부통합전산센터 제12호 Newsletter

- S/W, H/W 영역 분리 분산된 네트워크 장비 제어, OpenFlow 기술 적용, S/W기반 Controller 제어, 공통된 API제공.

2-2. SDN의 주요 요소 기술

- API 플렛폼 : 네트워크와 어플리케이션 연계

- 컨트롤러 에이전트 : 다양한 네트워크 장비와 애플리케이션 사이 역할

- NW오버레이 : 물리적/가상 네트워크를 포괄하는 네트워크 가상화 플랫폼

3. SDN의 도입시 주의사항

- 기술자체 완성도에 대한 불안감, 미숙한 솔루션, 기술 구현 미성숙

- ROI에 대한 확신 부재, 가치제안 부족, SDN 도입 규모 부족

저작자표시 동일조건

'1. IT Story > Basic Studies' 카테고리의 다른 글

NTP 보안 (Network Time Protocol) (0)	2019.01.31
PoE (Power over Ethernet) (0)	2019.01.30
CASB(Cloud Access Security Broker) (0)	2019.01.30
Conversational platforms-대화형 플랫폼 (0)	2019.01.28
V2X(Vehicle to everything) (0)	2019.01.27
몰입 경험(Immersive Experience) (0)	2019.01.25
OTT (Over The Top) (0)	2019.01.24
엣지 컴퓨팅 (edge computing) (0)	2019.01.24

운명을바꾸는자

IT와 함께 살아가는 삶

,

V2X(Vehicle to everything)

1. IT Story/Basic Studies 2019. 1. 27. 20:28

V2X(Vehicle to everything)

1. V2X(Vehicle to everything)의 개요

1-1. 정의

- 자동차가 자율주행하기 위해 도로에 있는 다양한 요소와 소통하는 기술이다.

- 도로 위의 차량에 적용 가능한 모든 형태의 통신 기술을 포함한 개념인다.

- 자동차와 사물, 자동차와 사물, 자동차와 네트워크, 자동차와 사람간의 통신 기술을 합한 기술이다.

2. V2X(Vehicle to everything)의 개념도, 구성요소

2-1. V2X(Vehicle to everything)의 개념도

- 참고자료: 완전 자율주행 차량을 위한 기술 로드맵 - 대학생신재생에너지기자단

2-2. V2X(Vehicle to everything)의 구성요소

1) V2V(차량<->차량) : 교통 상황과 차량 간 접근 통신기술

2) V2I(차량<->인프라(시설물)) : 신호등과 같은 인프라와 소통하는 통신기술

3) V2P(차량<->이동단말) : 보행자 정보를 지원하는 통신기술

4) V2N(차량<->네트워크) : 차량과 네트워크간 통신

3. V2X(Vehicle to everything)의 통신 기술 문제점

- 네트워크 인프라 구축 미비, 해킹 및 정보 유출, 주파수 간석 등의 문제점이 존재한다.

- 현재 도로 위에서의 네트워크 인프라 구축이 미비하여 차량간의 무선통신 기술을 차량에 적용하더라도 실제 차량 간 무선 통신을 할 수 없는 상황이다.

- 수천대가 넘는 자동차가 도로 위를 달리며 V2X통신을 한다면, 네트워크에 걸리는 부하는 상당한 규모로 판단된다.

해결방안 : 5G 통신으로 많은 수의 동시 접속과 대량의 데이터 처리가 가능한 통신으로 해결가능할 것으로 보인다.

저작자표시 동일조건

'1. IT Story > Basic Studies' 카테고리의 다른 글

PoE (Power over Ethernet) (0)	2019.01.30
CASB(Cloud Access Security Broker) (0)	2019.01.30
Conversational platforms-대화형 플랫폼 (0)	2019.01.28
SDN(Software-Defined Network) (0)	2019.01.28
몰입 경험(Immersive Experience) (0)	2019.01.25
OTT (Over The Top) (0)	2019.01.24
엣지 컴퓨팅 (edge computing) (0)	2019.01.24
5세대 이동통신 (5G) (0)	2019.01.23

운명을바꾸는자

IT와 함께 살아가는 삶

,

'1. IT Story'에 해당되는 글 397건

NTP 보안 (Network Time Protocol)

'1. IT Story > Basic Studies' 카테고리의 다른 글

PoE (Power over Ethernet)

'1. IT Story > Basic Studies' 카테고리의 다른 글

CASB(Cloud Access Security Broker)

'1. IT Story > Basic Studies' 카테고리의 다른 글

Oracle SEGMENT STAT 조회 스크립트

'1. IT Story > Scripts' 카테고리의 다른 글

Oracle 인덱스 정리 대상 추출 스크립트

'1. IT Story > Scripts' 카테고리의 다른 글

Conversational platforms-대화형 플랫폼

'1. IT Story > Basic Studies' 카테고리의 다른 글

SDN(Software-Defined Network)

'1. IT Story > Basic Studies' 카테고리의 다른 글

V2X(Vehicle to everything)

'1. IT Story > Basic Studies' 카테고리의 다른 글

공지사항

카테고리

태그목록

글 보관함

달력

링크

운명을바꾸는자

LATEST FROM OUR BLOG

LATEST COMMENTS

티스토리툴바