신문지한장

쉘에서 @SQL 호출 시 무반응 원인과 해결

$cat check.shexport CDATE=`date +%Y%m%d`export ORACLE_SID=DJPsqlplus "/ as sysdba"
Oracle/sql&script 2024. 9. 3. 15:12
[SQL] select 쓸때 & 변수 사용

SYS@orcl19>select file_name from dba_data_files where tablespace_name='&1';Enter value for 1: SYSTEM -- SYSTEM 입력-- 출력FILE_NAME-------------------------------------------------------------------------------------/oracle/app/oracle/oradata/ORCL19/system01.dbf
Oracle/sql&script 2024. 9. 3. 15:11
Orcle RAC ACFS FileSystem 구성부터 마운트까지 (asmca, asmcmd 활용)

ACFS FileSystem 생성 테스트(Command-Line) ACFS란? ASM Cluster File System의 약자로 ASM으로 Cluster용 File System을 생성하여 각 노드 OS에 Mount하여 File System처럼 사용하는 기능 1. 현재 ASM DiskGroup 및 Disk 확인set line 250set pages 100col name for a30col state for a10col path for a50select GROUP_NUMBER, DISK_NUMBER, STATE, TOTAL_MB, FREE_MB, NAME, PATH, STATE from v$asm_disk order by 1, 2;GROUP_NUMBER DISK_NUMBER STATE TOTA..
Oracle/sql&script 2024. 8. 29. 18:59
[SQL] 테이블 통계정보 돌아간 시간 확인

SELECT OWNER,TABLE_NAME,NUM_ROWS,LAST_ANALYZED FROM DBA_TABLES where owner='DBA01'
Oracle/sql&script 2024. 8. 26. 11:10
[SQL] 테이블 정합성 확인 SQL

SELECT TABLE_NAME, NUM_ROWS FROM ALL_TABLES WHERE OWNER = 'DBA01' ORDER BY TABLE_NAME;select sum(bytes/1024/1024) mb from dba_segments where owner='DBA01' group by segment_type,segment_name,tablespace_name;SELECT OWNER,TABLE_NAME,NUM_ROWS,LAST_ANALYZED FROM DBA_TABLES where table_name='TB_20230418';
Oracle/sql&script 2024. 8. 26. 11:09
이전 Prev 1 2 3 4 5 6 7 Next 다음