Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Hang when using _disable_logging

Hang when using _disable_logging

From: Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com>
Date: Fri, 10 Feb 2006 22:17:15 -0400
Message-ID: <cd4305c10602101817h66b69167m24417ab278f0d021@mail.gmail.com> 





Hi, I know this is not to user in production database and hardly in
test database.


But  only for curiosity I want to get it work, but it hang very easily



I don't understand why this hanged



Some ideas please? :(


21:27:01 10.2>alter system set "_disable_logging"=True scope=spfile;
21:27:01 10.2>alter system switch logfile;
21:27:01 10.2>shutdown normal;




Base de datos cerrada.


Base de datos desmontada.


Instancia ORACLE cerrada.


21:28:32 10.2>startup pfile=E:\oraSERPG\init\initSERPG.ora
Instancia ORACLE iniciada.



Total System Global Area  301989888 bytes

Fixed Size                  1248648 bytes
Variable Size              62915192 bytes
Database Buffers          230686720 bytes
Redo Buffers                7139328 bytes


Base de datos montada.


Base de datos abierta.

21:28:48 10.2>create table test as select * from dba_objects where 1=-1;
21:28:52 10.2>insert into test select * from dba_objects;
21:28:57 10.2>rollback;
21:28:57 10.2>insert into test select * from dba_objects;
21:28:59 10.2>commit;
21:28:59 10.2>insert into test select * from dba_objects;
21:29:01 10.2>rollback;
21:29:01 10.2>insert into test select * from dba_objects;
21:29:03 10.2>commit;
21:29:03 10.2>insert into test select * from dba_objects;
21:29:06 10.2>rollback;
21:29:06 10.2>insert into test select * from dba_objects;
21:29:08 10.2>commit;
21:29:08 10.2>insert into test select * from dba_objects;
21:29:10 10.2>rollback;
21:29:11 10.2>insert into test select * from dba_objects;
21:29:12 10.2>commit;
21:29:13 10.2>insert into test select * from dba_objects;







******.. Hanged here indefinitively****







********The logwriter continued working,







The paremeters I'm using on 10.2 for windows are the following


audit_file_dest                E:\ORASERPG\AUDIT
background_dump_dest           E:\ORASERPG\TRACE\BACKGROUND
compatible                     10.2.0.1.0
control_files                 




E:\ORASERPG\CONTROLFILES\CTL_SERPG01.CTL,

E:\ORASERPG\CONTROLFILES\CTL_SERPG02.CTL, D

                              
:\ORASERPG\CONTROLFILES\CTL_SERPG01.CTL,

D:\ORASERPG\CONTROLFILES\CTL_SERPG02.CTL



core_dump_dest                 E:\ORASERPG\TRACE\CDUMP
cursor_sharing                 EXACT
cursor_space_for_time          FALSE
db_block_size                  8192
db_cache_size                  0
db_domain
db_file_multiblock_read_count  16
db_files                       15
db_keep_cache_size             83886080
db_name                        SERPG
db_recovery_file_dest          D:\ORASERPGflash_recovery_area
db_recovery_file_dest_size     94371840000
db_recycle_cache_size          54525952
_disable_logging               TRUE
dispatchers                    (PROTOCOL=TCP) (SERVICE=SERPGXDB)
fast_start_mttr_target         300
instance_name                  SERPG
java_pool_size                 0
job_queue_processes            10
large_pool_size                0
license_max_users              800
log_archive_format             ARC%S_%R.%T
log_buffer                     7029248
log_checkpoint_interval        0
log_checkpoint_timeout         0
open_cursors                   800
open_links                     20
optimizer_index_caching        90
optimizer_index_cost_adj       10
pga_aggregate_target           157286400
processes                      100
query_rewrite_enabled          TRUE
query_rewrite_integrity        TRUSTED
read_only_open_delayed         FALSE
remote_dependencies_mode       SIGNATURE
remote_login_passwordfile      EXCLUSIVE
session_cached_cursors         1000
session_max_open_files         100
sga_target                     301989888
shared_pool_size               0
spfile                         E:\ORASERPG\INIT\SPINITSERPG.ORA
timed_statistics               TRUE
undo_management                AUTO
undo_retention                 56000
undo_tablespace                TBL_UNDO
user_dump_dest                 E:\ORASERPG\TRACE\USER
utl_file_dir                   *
workarea_size_policy           AUTO





The script I'm trying to run is:



CONN SYS/SERPG70516996_at_SERPG AS SYSDBA



alter system set "_disable_logging"=True scope=spfile;
alter system switch logfile;


shutdown normal;


startup pfile=E:\oraSERPG\init\initSERPG.ora
create table test as select * from dba_objects where 1=-1;
insert into test select * from dba_objects;
rollback;


insert into test select * from dba_objects;
commit;


insert into test select * from dba_objects;
rollback;


insert into test select * from dba_objects;
commit;


insert into test select * from dba_objects;
rollback;


insert into test select * from dba_objects;
commit;


insert into test select * from dba_objects;
rollback;


insert into test select * from dba_objects;
commit;


insert into test select * from dba_objects;
rollback;


insert into test select * from dba_objects;
commit;


insert into test select * from dba_objects;
rollback;


insert into test select * from dba_objects;
commit;


insert into test select * from dba_objects;
rollback;


insert into test select * from dba_objects;
commit;


insert into test select * from dba_objects;
rollback;


insert into test select * from dba_objects;
commit;

insert into test select * from dba_objects;
insert into test select * from dba_objects;
insert into test select * from dba_objects;
insert into test select * from dba_objects;
insert into test select * from dba_objects;
insert into test select * from dba_objects;
insert into test select * from dba_objects;
insert into test select * from dba_objects;
insert into test select * from dba_objects;
insert into test select * from dba_objects;
insert into test select * from dba_objects;
insert into test select * from dba_objects;


rollback;

insert into test select * from dba_objects;
insert into test select * from dba_objects;
insert into test select * from dba_objects;
insert into test select * from dba_objects;
insert into test select * from dba_objects;
insert into test select * from dba_objects;
insert into test select * from dba_objects;
insert into test select * from dba_objects;
insert into test select * from dba_objects;
insert into test select * from dba_objects;
insert into test select * from dba_objects;
insert into test select * from dba_objects;


commit;


shutdown normal;


startup pfile=E:\oraSERPG\init\initSERPG.ora
truncate table test;


shutdown normal;


startup pfile=E:\oraSERPG\init\initSERPG.ora
shutdown normal;


startup pfile=E:\oraSERPG\init\initSERPG.ora

insert into test select * from dba_objects;
insert into test select * from dba_objects;
insert into test select * from dba_objects;
insert into test select * from dba_objects;
insert into test select * from dba_objects;
insert into test select * from dba_objects;
insert into test select * from dba_objects;
insert into test select * from dba_objects;
insert into test select * from dba_objects;
insert into test select * from dba_objects;
insert into test select * from dba_objects;
insert into test select * from dba_objects;


rollback;


shutdown normal;


startup pfile=E:\oraSERPG\init\initSERPG.ora

insert into test select * from dba_objects;
insert into test select * from dba_objects;
insert into test select * from dba_objects;
insert into test select * from dba_objects;
insert into test select * from dba_objects;
insert into test select * from dba_objects;
insert into test select * from dba_objects;
insert into test select * from dba_objects;
insert into test select * from dba_objects;
insert into test select * from dba_objects;
insert into test select * from dba_objects;
insert into test select * from dba_objects;


commit;


shutdown normal;


startup pfile=E:\oraSERPG\init\initSERPG.ora
truncate table test;


shutdown normal;


startup pfile=E:\oraSERPG\init\initSERPG.ora

--
http://www.freelists.org/webpage/oracle-l


Received on Fri Feb 10 2006 - 20:17:15 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US