소소한 DB 팁

이런 오류가 발생하면...   diff-hellman-sha256 ---> 클릭

[oracle@TEST: ] $    machinfoCPU info:    Intel(R)  Itanium(R)  Processor 9350 (1.73 GHz, 24 MB)    4 cores, 8 logical processors per socket    4.79 GT/s QPI, CPU version E0           Active processor count:           4 sockets           16 cores (4 per socket) --> 물리코어수          16 logical processors (4 per socket)           LCPU attribute is disabled Memory: 63482 MB (61.99 GB) 메모리

1. CPU 코어 전체 개수  [oracle@TEST ~]$ grep -c processor /proc/cpuinfo 32 2.물리 CPU 수 확인 [oracle@TEST ~]$ grep "physical id"  /proc/cpuinfo | sort -u | wc -l 4 3.CPU당 물리코어 수  [oracle@TEST ~]$ grep "cpu cores" /proc/cpuinfo | tail -l cpu cores       : 4 cpu cores       : 4 cpu cores       : 4 cpu cores       : 4 cpu cores       : 4 cpu cores       : 4 cpu cores       : 4 cpu cores       : 4 cpu cores  ..

기본 - telnet ip port - ping ip ----------------------------------------------------------------------- 연결안되면 방화벽 확인 Active : inactive 방화벽이 사용안함. ------------------------------------------------------------------------- 방화벽 시작 [root@TEST02~]# systemctl start firewalld 방화벽 포트 추가 [root@ TEST02 ~]# firewall-cmd --zone=public --add-port=70001/tcp 방화벽 포트 차단 [root@ TEST02 ~]# firewall-cmd --zone=public ..

ll --time-style full-iso | awk '{print $6" "$9}' | grep 2022-12 ll --time-style full-iso | awk '{print $6" "$9}' | grep 2022-12 | awk '{print $2}' ll --time-style full-iso | awk '{print $6" "$9}' | grep 2022-12 | awk '{print $2}' | xargs rm -f

일별 용량관리, AWR snapshot job에 등록하여 활용 --스케줄러 잡 생성 begin dbms_scheduler.create_job( job_name=>'TEST_JOB', job_type=>'plsql_block', job_action=>'begin dbms_workload_repository.create_snapshot; end;', start_date=>to_date('20201001 0804','yyyymmdd hh24mi'), end_date =>to_date('20201003 0904','yyyymmdd hh24mi'), repeat_interval=>'freq=daily;interval=1', enabled=>true ); end; --스케줄러 잡 삭제 begin dbms_sched..

DBCC SQLPERF(LOGSPACE)

SELECT A.SPID, A.LOGIN_TIME, A.LOGINAME, A.LAST_BATCH, A.STATUS, A.PROGRAM_NAME, A.CMD, B.CLIENT_NET_ADDRESS FROM SYS.SYSPROCESSES A, SYS.DM_EXEC_CONNECTIONS B WHERE A.SPID = B.SESSION_ID

SELECT TO_CHAR (SID) SID, SERIAL# SERIALNUMBER, SUBSTR (TO_CHAR (LAST_CALL_ET), 1, 6) EXECUTESECONDS, USERNAME, MACHINE, B.SQL_TEXT SQLTEXT FROM V$SESSION A, V$SQLTEXT B WHERE USERNAME NOT IN ('SYSTEM', 'SYS') AND A.TYPE != 'BACKGROUND' AND A.STATUS = 'ACTIVE' AND A.SQL_ADDRESS = B.ADDRESS(+) AND A.SQL_HASH_VALUE = B.HASH_VALUE(+) ORDER BY A.LAST_CALL_ET DESC, A.SID, A.SERIAL#, B.ADDRESS, B.HASH..

--테이블스페이스 사용량 사이즈 확인 SELECT SUBSTR(A.TABLESPACE_NAME,1,30) TABLESPACE, ROUND(SUM(A.TOTAL1)/1024/1024,1) "TOTALMB", ROUND(SUM(A.TOTAL1)/1024/1024,1)-ROUND(SUM(A.SUM1)/1024/1024,1) "USEDMB", ROUND(SUM(A.SUM1)/1024/1024,1) "FREEMB", ROUND((ROUND(SUM(A.TOTAL1)/1024/1024,1)-ROUND(SUM(A.SUM1)/1024/1024,1))/ROUND(SUM(A.TOTAL1)/1024/1024,1)*100,2) "USED%" FROM (SELECT TABLESPACE_NAME,0 TOTAL1,SUM(BYTES)..