'Zabbix' 카테고리의 다른 글
Zabbix 3.0 Agent Repository (0) | 2023.05.09 |
---|---|
Zabbix5.0 With PostgreSQL (0) | 2021.06.01 |
Postgresql 모니터링 (0) | 2019.02.19 |
Linux DISK IO 모니터링 (0) | 2018.11.30 |
zabbix Agent 설치 (0) | 2018.10.26 |
Zabbix 3.0 Agent Repository (0) | 2023.05.09 |
---|---|
Zabbix5.0 With PostgreSQL (0) | 2021.06.01 |
Postgresql 모니터링 (0) | 2019.02.19 |
Linux DISK IO 모니터링 (0) | 2018.11.30 |
zabbix Agent 설치 (0) | 2018.10.26 |
SELECT IndexName = i.Name, ColName = c.Name FROM sys.indexes i INNER JOIN sys.index_columns ic ON ic.object_id = i.object_id AND ic.index_id = i.index_id INNER JOIN sys.columns c ON c.object_id = ic.object_id AND c.column_id = ic.column_id WHERE ic.is_included_column = 1 ORDER BY i.Name
https://stackoverflow.com/questions/18172359/list-all-indexes-with-included-columnsnonkeys
tempdb 할당 경합(Tempdb allocation contention) (0) | 2019.08.30 |
---|---|
새로운 서버로 Data 이관(How to migrate SQL Server from one machine to another) (0) | 2019.06.17 |
Extended Event Data Query로 Select (0) | 2019.02.19 |
Procedure나 Function 내용 검색 (0) | 2018.10.27 |
SQL SERVER Wait type 조사 (0) | 2018.10.27 |
SELECT owner, table_name, TRUNC(sum(bytes) / 1024 / 1024) Meg
FROM (SELECT segment_name table_name, owner, bytes
FROM dba_segments
WHERE segment_type = 'TABLE'
UNION ALL
SELECT i.table_name, i.owner, s.bytes
FROM dba_indexes i, dba_segments s
WHERE s.segment_name = i.index_name
AND s.owner = i.owner
AND s.segment_type = 'INDEX'
UNION ALL
SELECT l.table_name, l.owner, s.bytes
FROM dba_lobs l, dba_segments s
WHERE s.segment_name = l.segment_name
AND s.owner = l.owner
AND s.segment_type = 'LOBSEGMENT'
UNION ALL
SELECT l.table_name, l.owner, s.bytes
FROM dba_lobs l, dba_segments s
WHERE s.segment_name = l.index_name
AND s.owner = l.owner
AND s.segment_type = 'LOBINDEX')
WHERE owner in UPPER('&owner')
GROUP BY table_name, owner
HAVING SUM(bytes) / 1024 / 1024 > 10 /* Ignore really small tables */
ORDER BY SUM(bytes) desc;
출처: http://a2zakir.blogspot.com/2012/02/script-for-getting-oracle-table-size.html
DBLink(DB Link 생성) (0) | 2019.08.22 |
---|---|
oracle lock tree 확인 (0) | 2019.06.20 |
Oracle 11g 설치 오류 PRVF-0002 (0) | 2019.05.02 |
오라클 Object DDL 스크립트 추출 (0) | 2019.03.06 |
오라클 세션별 CPU, PGA 사용량 확인 쿼리 (0) | 2018.12.31 |
oracle lock tree 확인 (0) | 2019.06.20 |
---|---|
Table Size 확인(Index, Lob데이터포함) (0) | 2019.05.10 |
오라클 Object DDL 스크립트 추출 (0) | 2019.03.06 |
오라클 세션별 CPU, PGA 사용량 확인 쿼리 (0) | 2018.12.31 |
DML쿼리 튜닝방법 (0) | 2018.09.19 |