Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Archiver question
Yong is right.
Here is the strace result from linux.
[root_at_ebay-gwu root]# lsof -p 22306
COMMAND PID USER FD TYPE DEVICE SIZE NODE NAME oracle 22306 oracle cwd DIR 8,6 4096 4227253oracle 22306 oracle txt REG 8,6 51502644 1589446
/home/oracle/product/920/dbs
oracle 22306 oracle rtd DIR 8,1 4096 2 /
oracle 22306 oracle mem DEL 0,4 491520 /SYSVf7c1d84c oracle 22306 oracle 0r CHR 1,3 33524 /dev/null oracle 22306 oracle 1r CHR 1,3 33524 /dev/null oracle 22306 oracle 2w REG 8,6 616 4374730
/home/oracle/admin/ora9i/bdump/db_arc1_22306.trc
oracle 22306 oracle 3r CHR 1,3 33524 /dev/null oracle 22306 oracle 4r CHR 1,3 33524 /dev/null oracle 22306 oracle 5r CHR 1,3 33524 /dev/null oracle 22306 oracle 6w REG 8,6 22696 4374805
/home/oracle/admin/ora9i/bdump/alert_db.log
oracle 22306 oracle 7w REG 8,6 22696 4374805
tat64("/home/oracle/oradata/db/log2.log", {st_mode=S_IFREG|0640,
st_size=104858112, ...}) = 0
statfs("/home/oracle/oradata/db/log2.log", {f_type="EXT2_SUPER_MAGIC",
f_bsize=4096, f_blocks=13596911, f_bfree=7398656, f_bavail=6707962, f_files=6914048, f_ffree=6812472, f_fsid={0, 0}, f_namelen=255, f_frsize=0}) = 0 open("/home/oracle/oradata/db/log2.log", O_RDONLY|O_LARGEFILE) = 12 close(12) = 0statfs("/home/oracle/oradata/db/log2.log", {f_type="EXT2_SUPER_MAGIC",
f_bsize=4096, f_blocks=13596911, f_bfree=7398656, f_bavail=6707962, f_files=6914048, f_ffree=6812472, f_fsid={0, 0}, f_namelen=255, f_frsize=0}) = 0
f_bsize=4096, f_blocks=13596911, f_bfree=7398656, f_bavail=6707962, f_files=6914048, f_ffree=6812472, f_fsid={0, 0}, f_namelen=255, f_frsize=0}) = 0 open("/home/oracle/oradata/db/log2.log1", O_RDONLY|O_LARGEFILE) = 13 close(13) = 0statfs("/home/oracle/oradata/db/log2.log1", {f_type="EXT2_SUPER_MAGIC",
f_bsize=4096, f_blocks=13596911, f_bfree=7398656, f_bavail=6707962, f_files=6914048, f_ffree=6812472, f_fsid={0, 0}, f_namelen=255, f_frsize=0}) = 0
gettimeofday({1114027142, 447048}, NULL) = 0 gettimeofday({1114027142, 447101}, NULL) = 0 gettimeofday({1114027142, 447155}, NULL) = 0 close(7) = 0open("/home/oracle/admin/ora9i/bdump/alert_db.log", O_WRONLY|O_APPEND|O_CREAT, 0664) = 7
gettimeofday({1114027142, 447454}, NULL) = 0 gettimeofday({1114027142, 447516}, NULL) = 0 gettimeofday({1114027142, 447570}, NULL) = 0 close(7) = 0open("/home/oracle/admin/ora9i/bdump/alert_db.log", O_WRONLY|O_APPEND|O_CREAT, 0664) = 7
lseek(14, 0, SEEK_SET) = 0write(14, "\0\2\0\0\0\2\0\0\376\37\3\0]\\[Z\240\201\0\0[\230\0\0\0"..., 512) = 512
ftruncate64(14, 104857088) = 0 close(14) = 0stat64("/home/oracle/admin/ora9i/arch/1_14.dbf", {st_mode=S_IFREG|0640, st_size=104857088, ...}) = 0
close(14) = 0statfs("/home/oracle/admin/ora9i/arch/1_14.dbf", {f_type="EXT2_SUPER_MAGIC", f_bsize=4096, f_blocks=13596911, f_bfree=7398655, f_bavail=6707961, f_files=6914048, f_ffree=6812471, f_fsid={0, 0}, f_namelen=255, f_frsize=0}) = 0 open("/home/oracle/admin/ora9i/arch/1_14.dbf", O_RDWR|O_LARGEFILE) = 14
fcntl64(14, F_SETFD, FD_CLOEXEC) = 0 fcntl64(14, F_GETFL) = 0x8002 (flagsO_RDWR|O_LARGEFILE)
gettimeofday({1114027143, 182507}, NULL) = 0 gettimeofday({1114027143, 182581}, NULL) = 0 gettimeofday({1114027143, 182644}, NULL) = 0 gettimeofday({1114027143, 182706}, NULL) = 0 gettimeofday({1114027143, 182769}, NULL) = 0 gettimeofday({1114027143, 182831}, NULL) = 0pread(12, "\16\0\0\0\1 \0\0&\254%!\324\1\356D\0\0\0\0\2\0\2\0\2\0"..., 1048576, 4194816) = 1048576
gettimeofday({1114027143, 414111}, NULL) = 0 gettimeofday({1114027143, 414184}, NULL) = 0 gettimeofday({1114027143, 414246}, NULL) = 0 gettimeofday({1114027143, 414308}, NULL) = 0 gettimeofday({1114027143, 414373}, NULL) = 0 gettimeofday({1114027143, 414471}, NULL) = 0pread(12, "\16\0\0\0\1(\0\0&\254%!\f\1\7\265\303\2\22\2670\315EDS"..., 1048576, 5243392) = 1048576
gettimeofday({1114027143, 510415}, NULL) = 0 gettimeofday({1114027143, 510514}, NULL) = 0 gettimeofday({1114027143, 510578}, NULL) = 0 gettimeofday({1114027143, 510642}, NULL) = 0 gettimeofday({1114027143, 510709}, NULL) = 0 gettimeofday({1114027143, 510772}, NULL) = 0pread(12, "\16\0\0\0\0010\0\0&\254%!\330\1\277i\2\0\3\0\4\0\4\0\2"..., 1048576, 6291968) = 1048576
gettimeofday({1114027143, 677057}, NULL) = 0 gettimeofday({1114027143, 677141}, NULL) = 0 gettimeofday({1114027143, 677203}, NULL) = 0 gettimeofday({1114027143, 677266}, NULL) = 0 gettimeofday({1114027143, 677327}, NULL) = 0 gettimeofday({1114027143, 677385}, NULL) = 0pread(12, "\16\0\0\0\0018\0\0\'\254%!P\0J!\1\0\0\0\347S@\0\245\246"..., 1048576, 7340544) = 1048576
gettimeofday({1114027143, 811975}, NULL) = 0 gettimeofday({1114027143, 812071}, NULL) = 0 gettimeofday({1114027143, 812139}, NULL) = 0 gettimeofday({1114027143, 812204}, NULL) = 0 gettimeofday({1114027143, 812268}, NULL) = 0 gettimeofday({1114027143, 812334}, NULL) = 0pread(12, "\16\0\0\0\1@\0\0\'\254%!\220\0IgN\1\0\0NO\0\0DEFAULT\0"..., 1048576, 8389120) = 1048576
gettimeofday({1114027143, 895616}, NULL) = 0 gettimeofday({1114027143, 895694}, NULL) = 0 gettimeofday({1114027143, 895756}, NULL) = 0 gettimeofday({1114027143, 895816}, NULL) = 0 gettimeofday({1114027143, 895879}, NULL) = 0 gettimeofday({1114027143, 895939}, NULL) = 0pread(12, "\16\0\0\0\1H\0\0(\254%!\204\1\230@\v\0\10\0\2\0\0\0\10"..., 1048576, 9437696) = 1048576
gettimeofday({1114027144, 8043}, NULL) = 0 gettimeofday({1114027144, 8157}, NULL) = 0 gettimeofday({1114027144, 8230}, NULL) = 0 gettimeofday({1114027144, 8318}, NULL) = 0 gettimeofday({1114027144, 8397}, NULL) = 0 gettimeofday({1114027144, 8457}, NULL) = 0pread(12, "\16\0\0\0\1P\0\0(\254%!\360\1)\'\30\0\20\0006\0\6\0\21"..., 1048576, 10486272) = 1048576
gettimeofday({1114027144, 191048}, NULL) = 0 gettimeofday({1114027144, 191139}, NULL) = 0 gettimeofday({1114027144, 191204}, NULL) = 0 gettimeofday({1114027144, 191268}, NULL) = 0 gettimeofday({1114027144, 191335}, NULL) = 0 gettimeofday({1114027144, 191401}, NULL) = 0pread(12, "\16\0\0\0\1X\0\0=\254%!l\1\236\2\0\0\0\0\0\0\n\0\n\0\5"..., 1048576, 11534848) = 1048576
gettimeofday({1114027144, 356065}, NULL) = 0 gettimeofday({1114027144, 356184}, NULL) = 0 gettimeofday({1114027144, 356262}, NULL) = 0 gettimeofday({1114027144, 356338}, NULL) = 0 gettimeofday({1114027144, 356416}, NULL) = 0 gettimeofday({1114027144, 356494}, NULL) = 0pread(12,
gettimeofday({1114027144, 560434}, NULL) = 0 gettimeofday({1114027144, 560526}, NULL) = 0 gettimeofday({1114027144, 560597}, NULL) = 0 gettimeofday({1114027144, 560672}, NULL) = 0 gettimeofday({1114027144, 560742}, NULL) = 0 gettimeofday({1114027144, 560809}, NULL) = 0pread(12, "\16\0\0\0\1h\0\0>\254%!,\0[\323\4O\200\0\225\0\35\0\276"..., 1048576, 13632000) = 1048576
gettimeofday({1114027144, 687880}, NULL) = 0 gettimeofday({1114027144, 687972}, NULL) = 0 gettimeofday({1114027144, 688036}, NULL) = 0 gettimeofday({1114027144, 688118}, NULL) = 0 gettimeofday({1114027144, 688189}, NULL) = 0 gettimeofday({1114027144, 688256}, NULL) = 0pread(12, "\16\0\0\0\1p\0\0>\254%!|\1=\3\"\0\377\277\n\0-\0\33\1\0"..., 1048576, 14680576) = 1048576
gettimeofday({1114027144, 807682}, NULL) = 0 gettimeofday({1114027144, 807782}, NULL) = 0 gettimeofday({1114027144, 807849}, NULL) = 0 gettimeofday({1114027144, 807918}, NULL) = 0 gettimeofday({1114027144, 807986}, NULL) = 0 gettimeofday({1114027144, 808054}, NULL) = 0pread(12, "\16\0\0\0\1x\0\0>\254%!\370\1@\203\256O\200\0\364\247\5"..., 1048576, 15729152) = 1048576
gettimeofday({1114027145, 3720}, NULL) = 0 gettimeofday({1114027145, 3815}, NULL) = 0 gettimeofday({1114027145, 3885}, NULL) = 0 gettimeofday({1114027145, 3953}, NULL) = 0 gettimeofday({1114027145, 4021}, NULL) = 0 gettimeofday({1114027145, 4090}, NULL) = 0pread(12, "\16\0\0\0\1\200\0\0?\254%!,\1\35\352pC\377\277\220\273"..., 1048576, 16777728) = 1048576
gettimeofday({1114027145, 167149}, NULL) = 0 gettimeofday({1114027145, 167231}, NULL) = 0 gettimeofday({1114027145, 167338}, NULL) = 0 gettimeofday({1114027145, 167408}, NULL) = 0 gettimeofday({1114027145, 167478}, NULL) = 0 gettimeofday({1114027145, 167546}, NULL) = 0pread(12, "\16\0\0\0\1\210\0\0?\254%!\\\0\325FR_ASTATUS_MAP\6\0@"..., 1048576, 17826304) = 1048576
gettimeofday({1114027145, 277903}, NULL) = 0 gettimeofday({1114027145, 278016}, NULL) = 0 gettimeofday({1114027145, 278092}, NULL) = 0 gettimeofday({1114027145, 278171}, NULL) = 0 gettimeofday({1114027145, 278250}, NULL) = 0 gettimeofday({1114027145, 278329}, NULL) = 0pread(12, "\16\0\0\0\1\220\0\0@\254%!\264\1`?\0\0\0\0\0\0\0\0\0\0"..., 1048576, 18874880) = 1048576
gettimeofday({1114027145, 423007}, NULL) = 0 gettimeofday({1114027145, 423102}, NULL) = 0 gettimeofday({1114027145, 423167}, NULL) = 0 gettimeofday({1114027145, 423233}, NULL) = 0 gettimeofday({1114027145, 423299}, NULL) = 0 gettimeofday({1114027145, 423367}, NULL) = 0pread(12, "\16\0\0\0\1\230\0\0@\254%!p\0\205\21DISABLEDNO/\0DISA"..., 1048576, 19923456) = 1048576
gettimeofday({1114027145, 584904}, NULL) = 0 gettimeofday({1114027145, 585005}, NULL) = 0 gettimeofday({1114027145, 585071}, NULL) = 0 gettimeofday({1114027145, 585140}, NULL) = 0 gettimeofday({1114027145, 585209}, NULL) = 0 gettimeofday({1114027145, 585277}, NULL) = 0pread(12,
gettimeofday({1114027145, 679927}, NULL) = 0 gettimeofday({1114027145, 680037}, NULL) = 0 gettimeofday({1114027145, 680107}, NULL) = 0 gettimeofday({1114027145, 680176}, NULL) = 0 gettimeofday({1114027145, 680248}, NULL) = 0 gettimeofday({1114027145, 680346}, NULL) = 0pread(12, "\16\0\0\0\1\250\0\0A\254%!\0\0\20\255\4\0 \0-\0\0\0\0\0"..., 1048576, 22020608) = 1048576
gettimeofday({1114027145, 864741}, NULL) = 0 gettimeofday({1114027145, 864835}, NULL) = 0 gettimeofday({1114027145, 864902}, NULL) = 0 gettimeofday({1114027145, 864970}, NULL) = 0 gettimeofday({1114027145, 865039}, NULL) = 0 gettimeofday({1114027145, 865107}, NULL) = 0pread(12, "\16\0\0\0\1\260\0\0A\254%!\354\1\2319\30\0\6\0\0\0\0\0"..., 1048576, 23069184) = 1048576
gettimeofday({1114027146, 11979}, NULL) = 0 gettimeofday({1114027146, 12089}, NULL) = 0 gettimeofday({1114027146, 12175}, NULL) = 0 gettimeofday({1114027146, 12253}, NULL) = 0 gettimeofday({1114027146, 12332}, NULL) = 0 gettimeofday({1114027146, 12417}, NULL) = 0pread(12, "\16\0\0\0\1\270\0\0N\254%!(\0\267\327\2\21\0\0\310I\352"..., 1048576, 24117760) = 1048576
gettimeofday({1114027146, 184059}, NULL) = 0 gettimeofday({1114027146, 184157}, NULL) = 0 gettimeofday({1114027146, 184219}, NULL) = 0 gettimeofday({1114027146, 184285}, NULL) = 0 gettimeofday({1114027146, 184353}, NULL) = 0 gettimeofday({1114027146, 184420}, NULL) = 0pread(12, "\16\0\0\0\1\300\0\0N\254%!t\0\342N\5\3\1_+;@\0\233]@\0"..., 1048576, 25166336) = 1048576
gettimeofday({1114027146, 326897}, NULL) = 0 gettimeofday({1114027146, 326998}, NULL) = 0 gettimeofday({1114027146, 327070}, NULL) = 0 gettimeofday({1114027146, 327143}, NULL) = 0 gettimeofday({1114027146, 327213}, NULL) = 0 gettimeofday({1114027146, 327280}, NULL) = 0pread(12, "\16\0\0\0\1\310\0\0O\254%!\200\0\220(NO\0\0SYS$SESSION"..., 1048576, 26214912) = 1048576
gettimeofday({1114027146, 473040}, NULL) = 0 gettimeofday({1114027146, 473154}, NULL) = 0 gettimeofday({1114027146, 473234}, NULL) = 0 gettimeofday({1114027146, 473314}, NULL) = 0 gettimeofday({1114027146, 473396}, NULL) = 0 gettimeofday({1114027146, 473476}, NULL) = 0pread(12, "\16\0\0\0\1\320\0\0O\254%!\224\1\30\217\10\0\10\0\220\1"..., 1048576, 27263488) = 1048576
gettimeofday({1114027146, 699445}, NULL) = 0 gettimeofday({1114027146, 699554}, NULL) = 0 gettimeofday({1114027146, 699620}, NULL) = 0 gettimeofday({1114027146, 699694}, NULL) = 0 gettimeofday({1114027146, 699762}, NULL) = 0 gettimeofday({1114027146, 699829}, NULL) = 0pread(12,
gettimeofday({1114027146, 884599}, NULL) = 0 gettimeofday({1114027146, 884692}, NULL) = 0 gettimeofday({1114027146, 884759}, NULL) = 0 gettimeofday({1114027146, 884827}, NULL) = 0 gettimeofday({1114027146, 884895}, NULL) = 0 gettimeofday({1114027146, 884961}, NULL) = 0pread(12, "\16\0\0\0\1\340\0\0P\254%!\220\0\210:\271\33\0\0\0\0\0"..., 1048576, 29360640) = 1048576
gettimeofday({1114027147, 42177}, NULL) = 0 gettimeofday({1114027147, 42282}, NULL) = 0 gettimeofday({1114027147, 42361}, NULL) = 0 gettimeofday({1114027147, 42440}, NULL) = 0 gettimeofday({1114027147, 42519}, NULL) = 0 gettimeofday({1114027147, 42599}, NULL) = 0pread(12, "\16\0\0\0\1\350\0\0P\254%!\240\1,\\\0\0\1\0\1\0\2\0\7\0"..., 1048576, 30409216) = 1048576
gettimeofday({1114027147, 145956}, NULL) = 0 gettimeofday({1114027147, 146091}, NULL) = 0 gettimeofday({1114027147, 146203}, NULL) = 0 gettimeofday({1114027147, 146281}, NULL) = 0 gettimeofday({1114027147, 146361}, NULL) = 0 gettimeofday({1114027147, 146443}, NULL) = 0pread(12, "\16\0\0\0\1\360\0\0P\254%!\234\1\36\373\0\0\2\0\0\0\1\0"..., 1048576, 31457792) = 1048576
gettimeofday({1114027147, 247523}, NULL) = 0 gettimeofday({1114027147, 247620}, NULL) = 0 gettimeofday({1114027147, 247684}, NULL) = 0 gettimeofday({1114027147, 247750}, NULL) = 0 gettimeofday({1114027147, 247818}, NULL) = 0 gettimeofday({1114027147, 247883}, NULL) = 0pread(12, "\16\0\0\0\1\370\0\0Q\254%!\230\1\7N\0\0\10\0\2\0\3\0\10"..., 1048576, 32506368) = 1048576
gettimeofday({1114027147, 395883}, NULL) = 0 gettimeofday({1114027147, 395996}, NULL) = 0 gettimeofday({1114027147, 396072}, NULL) = 0 gettimeofday({1114027147, 396157}, NULL) = 0 gettimeofday({1114027147, 396237}, NULL) = 0 gettimeofday({1114027147, 396313}, NULL) = 0pread(12, "\16\0\0\0\1\0\1\0Q\254%!D\1\24\217oW@\0\276:@\0\377\22"..., 1048576, 33554944) = 1048576
gettimeofday({1114027147, 481713}, NULL) = 0 gettimeofday({1114027147, 481826}, NULL) = 0 gettimeofday({1114027147, 481910}, NULL) = 0 gettimeofday({1114027147, 481986}, NULL) = 0 gettimeofday({1114027147, 482065}, NULL) = 0 gettimeofday({1114027147, 482181}, NULL) = 0pread(12,
gettimeofday({1114027147, 575929}, NULL) = 0 gettimeofday({1114027147, 576021}, NULL) = 0 gettimeofday({1114027147, 576084}, NULL) = 0 gettimeofday({1114027147, 576151}, NULL) = 0 gettimeofday({1114027147, 576219}, NULL) = 0 gettimeofday({1114027147, 576285}, NULL) = 0pread(12, "\16\0\0\0\1\20\1\0Q\254%!\334\1C?\2\0\2\0\2\0\3\0\4\0\4"..., 1048576, 35652096) = 1048576
gettimeofday({1114027147, 728621}, NULL) = 0 gettimeofday({1114027147, 728772}, NULL) = 0 gettimeofday({1114027147, 728837}, NULL) = 0 gettimeofday({1114027147, 728904}, NULL) = 0 gettimeofday({1114027147, 728971}, NULL) = 0 gettimeofday({1114027147, 729038}, NULL) = 0pread(12, "\16\0\0\0\1\30\1\0R\254%!\344\1\242\204\30\0\20\0006\0"..., 1048576, 36700672) = 1048576
gettimeofday({1114027147, 841747}, NULL) = 0 gettimeofday({1114027147, 841860}, NULL) = 0 gettimeofday({1114027147, 841938}, NULL) = 0 gettimeofday({1114027147, 842015}, NULL) = 0 gettimeofday({1114027147, 842093}, NULL) = 0 gettimeofday({1114027147, 842171}, NULL) = 0pread(12, "\16\0\0\0\1 \1\0R\254%!\370\0\20\352\377\22\2\1\2\0<Z,"..., 1048576, 37749248) = 1048576
gettimeofday({1114027147, 951973}, NULL) = 0 gettimeofday({1114027147, 952095}, NULL) = 0 gettimeofday({1114027147, 952171}, NULL) = 0 gettimeofday({1114027147, 952249}, NULL) = 0 gettimeofday({1114027147, 952330}, NULL) = 0 gettimeofday({1114027147, 952415}, NULL) = 0pread(12, "\16\0\0\0\1(\1\0R\254%!\20\0\206\325\360\1\0\0\1\1\0\0"..., 1048576, 38797824) = 1048576
gettimeofday({1114027148, 82276}, NULL) = 0 gettimeofday({1114027148, 82408}, NULL) = 0 gettimeofday({1114027148, 82473}, NULL) = 0 gettimeofday({1114027148, 82542}, NULL) = 0 gettimeofday({1114027148, 82609}, NULL) = 0 gettimeofday({1114027148, 82675}, NULL) = 0pread(12, "\16\0\0\0\0010\1\0R\254%!\20\0\324S\f\2\0\0\1\1\0\0\244"..., 1048576, 39846400) = 1048576
gettimeofday({1114027148, 150792}, NULL) = 0 gettimeofday({1114027148, 150895}, NULL) = 0 gettimeofday({1114027148, 150973}, NULL) = 0 gettimeofday({1114027148, 151049}, NULL) = 0 gettimeofday({1114027148, 151127}, NULL) = 0 gettimeofday({1114027148, 151206}, NULL) = 0pread(12, "\16\0\0\0\0018\1\0S\254%!\24\0^F\26\0\24\0008\2\0\0\1\1"..., 1048576, 40894976) = 1048576