Curious Developing

-- 테이블찾기(Search Table) SELECT dataBasename, tablename FROM dbc.tablesv WHERE LOWER(tablename) LIKE '%ycl00%' -- 테이블용량(check table size) select a.DatabaseName, a.tablename, CreateTimeStamp, CAST(SUM(CurrentPerm)/(1024*1024*1024) as DECIMAL(18,5)) (TITLE 'Used(GB)') FROM dbc.tablesize A, dbc.tables b where a.tablename=b.tablename and a.DatabaseName = B.DatabaseName and A.DatabaseName = '~~~' and A..

- 매일 적재량 select trunc(COMPLETION_TIME) TIME, SUM(BLOCKS * BLOCK_SIZE)/1024/1024 size_MB from v$ARCHIVED_LOG group by trunc(completion_time); - 로그파일 사이즈 select a.group#, a.thread#, a.sequence#, a.archived, a.status, b.member as relog_file_name, a.bytes/1024/1024 as size_mb from v$log a inner join v$logfile b on a.group#=b.group# order by a.group# asc; - 파일사이즈 조정 alter system checkpoint; alter dat..

SELECT NAME, value$ FROM sys.props$ WHERE NAME LIKE '%CHARACTERSET%' ; --type 1의 charsetform - 1: varchar2, 2: nvarchar2 --type 2의 charsetform - 1: varchar 2: nchar varying --type 96의 charsetform - 1: char 2: nchar --type 112의 charsetform - 1: clob 2: nclob select distinct(nls_charset_name(charsetid)) CHARACTERSET, type#, charsetform from sys.col$ where charsetform in (1,2) and type# in (1,9,96,..

- Gather(통계수집 실행 ) -> ALL(전체) : DBMS_UTILITY.[ANALYZE_DATABASE / ANALYZE_SCHEMA] -> By table(테이블별) : DBMS_STATS.gather_table_stats (ex) exec dbms_stats.gather_table_stats(ownname=> 'HR', tabname => 'DEPT', cascade => TRUE, block_sample=>false , method_opt=>'for all columns size 1', granularity=>'GLOBAL', no_invalidate=> FALSE, estimate_percent => 0.01, degree=>16); - 확인 -> Table : select table_n..

딕셔너리(List of Dictionaries) : SELECT * FROM dict; 오브젝트 타입(List of Object Types) : INDEX, JOB CLASS, CONTEXT, TABLE SUBPARTITION, TYPE BODY, INDEXTYPE, DESTINATION, PROCEDURE, JAVA CLASS, RULE, SCHEDULE, TABLE PARTITION, WINDOW, JAVA RESOURCE, TABLE, TYPE, VIEW, LIBRARY, FUNCTION, TRIGGER, PROGRAM, MATERIALIZED VIEW, JAVA SOURCE, CLUSTER, SYNONYM, PACKAGE BODY, CONSUMER GROUP, EVALUATION CONTEXT, ..

[data unload] print " set long 99999999 set feedback off set pagesize 0 set linesize 2000 set tab off set define off alter session set nls_date_format = 'yyyymmdd'; SELECT A, B, C_clob, D FROM {Schema}.{table} WHERE A BETWEEN '20130901' AND '20130931';" | sqlplus -s {id}/{pw} > {data_file}.dat [ctl File] LOAD DATA INFILE * APPEND INTO TABLE {schema}.{table_name} FIELDS TERMINATED BY '^|' TRAILIN..