DB_Hyun20 Oracle RAC crsctl force 안될시 11g RAC에서 간혹 crs deamon이 안내려가는 경우가 있다. crsctl stop crs or crsctl sop crs -f 명령어로도 deamon이 안내려간다면 CRS-2678: 'ora.crsd' on 'node1' has experienced an unrecoverable failure CRS-0267: Human intervention required to resume its availability. CRS-2795: Shutdown of Oracle High Availability Services-managed resources on 'node1' has failed CRS-4687: Shutdown command has completed with error(s). CRS-4000: .. 2012. 7. 20. Oracle MAX 값 정리 Datatype Limits Datatypes Limit Comments BFILE Maximum size: 4 GB Maximum size of a file name: 255 characters Maximum size of a directory name: 30 characters Maximum number of open BFILEs: see Comments The maximum number of BFILEs is limited by the value of the SESSION_MAX_OPEN_FILES initialization parameter, which is itself limited by the maximum number of open files the operating system will a.. 2012. 7. 19. oracle table row count 조회 migration 중 동기화가 잘되었는지 또는 table count 건수를 비교할 일이 생겼을 때 사용하면 유용할 듯하다 -- rows user별로 한번에 보기 (단 쿼리의 특성상 부하를 줄수 있습니다 ㅡ.ㅡ; SET FEEDBACK OFF set echo off set heading off set rowscount off set lin 400 set pagesize 50000 spool a.sql select 'select '''||owner||''' as col1, '''||table_name||''' as col2, count(*) as col3 from '||owner||'.'||table_name||' b UNION ALL' from dba_tables where owner not in ('SY.. 2012. 7. 19. oracle 11g deferred_segment_created 11g 부터 table 생성시 data가 들어오기 전까지 segment를 만들지 않게 설정 할 수 있습니다. SYS, SYSTEM, PUBLIC, OUTLN, XDB schema는 제외 됩니다. SQL> ALTER SYSTEM SET deferred_segment_creation=TRUE; - conn hyun/hyun SQL> create table deferred_table11(id number(8) CONSTRAINT id_pk_11 primary key); Table created. SQL> select segment_name, segment_type 2 from user_segments 3 where segment_name in ('DEFERRED_TA.. 2012. 1. 13. 이전 1 2 3 4 5 다음