Hang when using _disable_logging
- From: Juan Carlos Reyes Pacheco <juancarlosreyesp@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 10 Feb 2006 22:17:15 -0400
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,
***********
*** 2006-02-10 21:56:24.375
tkcrrsarc: (WARN) Failed to find ARCH for message (message:0x1)
tkcrrpa: (WARN) Failed initial attempt to send ARCH message (message:0x1)
tkcrrsarc: (WARN) Failed to find ARCH for message (message:0x1)
tkcrrpa: (WARN) Failed initial attempt to send ARCH message (message:0x1)
tkcrrsarc: (WARN) Failed to find ARCH for message (message:0x1)
tkcrrpa: (WARN) Failed initial attempt to send ARCH message (message:0x1)
.....
.....
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@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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
