블로그 이미지
bedbmsguru

Notice

Recent Post

Recent Comment

Recent Trackback

Archive

calendar

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
  • total
  • today
  • yesterday
2018. 8. 28. 11:27 Zabbix

http://yallalabs.com/linux/how-to-monitor-mysqlmariadb-using-zabbix-server/

posted by bedbmsguru
2018. 8. 27. 10:38 오라클

http://adminid.kr/oracle/51350

posted by bedbmsguru
2018. 8. 13. 16:52 오라클

--특정테이블 index Size 조회


SELECT 
T1.owner, T1.segment_name, T1.segment_type, T1.bytes/1024/1024 SIZE_MB, T2.PRIMARY_KEY, T2.UNIQUENESS, INDEX_POS1, INDEX_POS2, INDEX_POS3, INDEX_POS4, INDEX_POS5, INDEX_POS6, INDEX_POS7, INDEX_POS8, INDEX_POS9, INDEX_POS10
FROM DBA_SEGMENTS T1
INNER JOIN 
(
SELECT * FROM TABLE(PKG_DBA_REPOSITORY.GET_INDEX_INFO('테이블이름'))
) T2
ON T1.SEGMENT_NAME = T2.INDEX_NAME



--PKG_DBA_REPOSITORY.GET_INDEX_INFO 함수 생성

http://bedbmsguru.tistory.com/101?category=793983

posted by bedbmsguru
2018. 8. 10. 08:24 SQL SERVER

https://www.mssqltips.com/sqlservertip/3598/troubleshooting-transactional-replication-latency-issues-in-sql-server/?utm_source=dailynewsletter&utm_medium=email&utm_content=headline&utm_campaign=20180809

'SQL SERVER' 카테고리의 다른 글

Index REBUILD OR REORG 쿼리  (0) 2018.10.26
알아봐요 할 DMV  (0) 2018.09.19
Replication Subscription Type 확인  (0) 2018.05.09
Backup 및 Restore 진행현황 쿼리  (0) 2017.11.08
SSMS에서 Agent Job 전체를 스크립팅  (0) 2017.10.17
posted by bedbmsguru