[20210722]sqlplus下show recycebin的小問題.txt
[20210722]sqlplus下show recycebin的小問題.txt
--//sqlplus下執行show recycebin遇到一些疑問,透過測試慢慢展開問題的探究.
1.環境:
SCOTT@test01p> @ ver1
PORT_STRING VERSION BANNER CON_ID
------------------------------ -------------- -------------------------------------------------------------------------------- ----------
IBMPC/WIN_NT64-9.1.0 12.2.0.1.0 Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production 0
SCOTT@test01p> create table tx as select * from dept ;
Table created.
SCOTT@test01p> create table ty as select * from dept ;
Table created.
2.測試:
SCOTT@test01p> show recyclebin
SCOTT@test01p> drop table tx ;
Table dropped.
SCOTT@test01p> drop table ty ;
Table dropped.
SCOTT@test01p> show recyclebin
ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME
---------------- ------------------------------ ------------ -------------------
TX BIN$T7f14az+TMuluJgGIOXiPA==$0 TABLE 2021-07-21:20:33:43
TY BIN$5quvB25qT7eMZtdPExTTZg==$0 TABLE 2021-07-21:20:33:45
--//OK正確.在結尾加入分號看看.
SCOTT@test01p> show recyclebin;
ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME
---------------- ------------------------------ ------------ -------------------
TX BIN$T7f14az+TMuluJgGIOXiPA==$0 TABLE 2021-07-21:20:33:43
TY BIN$5quvB25qT7eMZtdPExTTZg==$0 TABLE 2021-07-21:20:33:45
--//OK正確.在結尾加入空格(tab鍵)與分號看看.
SCOTT@test01p> show recyclebin ;
--//顯示為空,為什麼?
3.使用toad自帶的SQL Tracker跟蹤:
SELECT ORIGINAL_NAME ORIGNAME_PLUS_SHOW_RECYC,
OBJECT_NAME OBJECTNAME_PLUS_SHOW_RECYC,TYPE OBJTYPE_PLUS_SHOW_RECYC,
DROPTIME DROPTIME_PLUS_SHOW_RECYC
FROM USER_RECYCLEBIN
WHERE CAN_UNDROP = 'YES'
AND ORIGINAL_NAME = UPPER(:NMBIND_SHOW_OBJ)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
ORDER BY ORIGINAL_NAME,DROPTIME DESC,OBJECT_NAME;
--//為了美觀,我做了格式化處理.你可以發現下劃線帶入引數:NMBIND_SHOW_OBJ.很明顯我在分號前一個空格的情況下,
--//帶入的引數為空,這樣就沒有顯示.
SCOTT@test01p> show recyclebin tx
ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME
---------------- ------------------------------ ------------ -------------------
TX BIN$T7f14az+TMuluJgGIOXiPA==$0 TABLE 2021-07-21:20:33:43
SCOTT@test01p> show recyclebin tx ;
ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME
---------------- ------------------------------ ------------ -------------------
TX BIN$T7f14az+TMuluJgGIOXiPA==$0 TABLE 2021-07-21:20:33:43
--//你可以發現帶入引數的情況下顯示正確.如果你執行show recyclebin;執行的sqlplus如下:
SELECT ORIGINAL_NAME ORIGNAME_PLUS_SHOW_RECYC,
OBJECT_NAME OBJECTNAME_PLUS_SHOW_RECYC,TYPE OBJTYPE_PLUS_SHOW_RECYC,
DROPTIME DROPTIME_PLUS_SHOW_RECYC
FROM USER_RECYCLEBIN
WHERE CAN_UNDROP = 'YES'
ORDER BY ORIGINAL_NAME,DROPTIME DESC,OBJECT_NAME
--//沒有繫結變數,說明我的判斷正確.
4.繼續,以上測試在windows下進行,如果linux呢?
SCOTT@book> @ ver1
PORT_STRING VERSION BANNER
------------------------------ -------------- --------------------------------------------------------------------------------
x86_64/Linux 2.4.xx 11.2.0.4.0 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
SCOTT@book> show recyclebin;
ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME
---------------- ------------------------------ ------------ -------------------
TY BIN$x5jlVlgTFx3gU05kqMAqNg==$0 TABLE 2021-07-21:09:20:02
SCOTT@book> show recyclebin ;
ORA-24550: signal received: [si_signo=11] [si_errno=0] [si_code=1] [si_int=33260000] [si_ptr=0x1fb81e0] [si_addr=(nil)]
kpedbg_dmp_stack()+362
<-kpeDbgCrash()+192
<-kpeDbgSignalHandler()+119
<-skgesig_sigactionHandler()+218
<-__sighandler()
<-afiwsk()+544
<-afinsym()+80
<-afishosop()+1930
<-afisho()+516
<-aficmd()+2714
<-aficfd()+2669
<-aficdr()+138
<-afidrv()+4237
<-frame_dummy()+123
<-__libc_start_main()+244
--//注:我做了折行處理，不然太長了。
rlwrap: warning: sqlplus crashed, killed by SIGSEGV.
rlwrap itself has not crashed, but for transparency,
it will now kill itself (without dumping core) with the same signal
warnings can be silenced by the --no-warnings (-n) option
Segmentation fault
--//在分號前有空格的情況下,連線程式直接crash.
--//使用查詢，複製和貼上如下：
kpedbg_dmp_stack()+362
<-kpeDbgCrash()+192
<-kpeDbgSignalHandler()+119
<-skgesig_sigactionHandler()+218
<-__sighandler()
<-afiwsk()+544
<-afinsym()+80
<-afishosop()+1930
<-afisho()+516
<-aficmd()+2714
<-aficfd()+2669
<-aficdr()+138
<-afidrv()+4237
<-frame_dummy()+123
<-__libc_start_main()+244
Parsed stack:
Discovered stack type: short stack
Parsed short stack:
kpedbg_dmp_stack()+362 kernel programmatic interface [partial hit for: kp ]
kpeDbgCrash()+192 kernel programmatic interface [partial hit for: kp ]
kpeDbgSignalHandler()+119 kernel programmatic interface [partial hit for: kp ]
skgesig_sigactionHandler()+218 operating system dependent kernel generic [partial hit for: skg ]
__sighandler() (?) [partial hit for: ]
afiwsk()+544 (?) [partial hit for: ]
afinsym()+80 (?) [partial hit for: ]
afishosop()+1930 (?) [partial hit for: ]
afisho()+516 (?) [partial hit for: ]
aficmd()+2714 (?) [partial hit for: ]
aficfd()+2669 (?) [partial hit for: ]
aficdr()+138 (?) [partial hit for: ]
afidrv()+4237 (?) [partial hit for: ]
frame_dummy()+123 (?) [partial hit for: ]
__libc_start_main()+244 (?) [partial hit for: ]
$ oerr ora 24550
24550, 00000, "unhandled signal #%ld received. %s"
// *Cause: Serious error: signal received
// *Action: Refer to the platform-specific signal code, and see if the
// application code caused the error. Otherwise, record
// all error state and notify Oracle Support Services.
5.繼續登入測試:
SCOTT@book> @ spid
SID SERIAL# PROCESS SERVER SPID PID P_SERIAL# C50
---------- ---------- ------------------------ --------- ------ ------- ---------- --------------------------------------------------
295 9 17218 DEDICATED 17219 21 5 alter system kill session '295,9' immediate;
$ strace -f -p 17219
Process 17219 attached - interrupt to quit
read(7, "", 8208) = 0
close(10) = 0
close(7) = 0
getrusage(RUSAGE_SELF, {ru_utime={0, 22996}, ru_stime={0, 14997}, ...}) = 0
times({tms_utime=2, tms_stime=1, tms_cutime=0, tms_cstime=0}) = 1825693747
times({tms_utime=2, tms_stime=1, tms_cutime=0, tms_cstime=0}) = 1825693747
close(4) = 0
times({tms_utime=2, tms_stime=1, tms_cutime=0, tms_cstime=0}) = 1825693747
open("/u01/app/oracle/product/11.2.0.4/dbhome_1/rdbms/mesg/diaus.msb", O_RDONLY) = 4
fcntl(4, F_SETFD, FD_CLOEXEC) = 0
lseek(4, 0, SEEK_SET) = 0
read(4, "\25\23\"\1\23\3\t\t\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 256) = 256
lseek(4, 512, SEEK_SET) = 512
read(4, "\371\311\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 512) = 512
lseek(4, 1024, SEEK_SET) = 1024
read(4, "\210\273\353\273\363\273\373\273\4\274\16\274\26\274!\274)\2741\274<\274G\274T\274_\274k\274t\274"..., 192) = 192
stat("/u01/app/oracle", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
getrlimit(RLIMIT_NOFILE, {rlim_cur=64*1024, rlim_max=64*1024}) = 0
getrlimit(RLIMIT_FSIZE, {rlim_cur=RLIM_INFINITY, rlim_max=RLIM_INFINITY}) = 0
stat("/u01/app/oracle/diag", {st_mode=S_IFDIR|0775, st_size=4096, ...}) = 0
stat("/u01/app/oracle/diag/rdbms", {st_mode=S_IFDIR|0775, st_size=4096, ...}) = 0
stat("/u01/app/oracle/diag/rdbms/book", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0
stat("/u01/app/oracle/diag/rdbms/book/book", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0
stat("/u01/app/oracle/diag/rdbms/book/book/trace", {st_mode=S_IFDIR|0750, st_size=5337088, ...}) = 0
stat("/u01/app/oracle/diag/rdbms/book/book/alert", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0
stat("/u01/app/oracle/diag/rdbms/book/book/incident", {st_mode=S_IFDIR|0750, st_size=12288, ...}) = 0
stat("/u01/app/oracle/diag/rdbms/book/book/metadata", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0
stat("/u01/app/oracle/diag/rdbms/book/book/metadata_pv", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0
stat("/u01/app/oracle/diag/rdbms/book/book/metadata_dgif", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0
stat("/u01/app/oracle/diag/rdbms/book/book/hm", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0
stat("/u01/app/oracle/diag/rdbms/book/book/ir", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0
stat("/u01/app/oracle/diag/rdbms/book/book/incpkg", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0
stat("/u01/app/oracle/diag/rdbms/book/book/sweep", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0
stat("/u01/app/oracle/diag/rdbms/book/book/lck", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0
stat("/u01/app/oracle/diag/rdbms/book/book/cdump", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0
stat("/u01/app/oracle/diag/rdbms/book/book/stage", {st_mode=S_IFDIR|0750, st_size=32768, ...}) = 0
stat("/u01/app/oracle/diag/rdbms/book/book/metadata", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0
lstat("/u01/app/oracle/diag/rdbms/book/book/metadata/ADR_CONTROL.ams", {st_mode=S_IFREG|0640, st_size=65536, ...}) = 0
stat("/u01/app/oracle/diag/rdbms/book/book/metadata/ADR_CONTROL.ams", {st_mode=S_IFREG|0640, st_size=65536, ...}) = 0
lstat("/u01/app/oracle/diag/rdbms/book/book/metadata/ADR_INVALIDATION.ams", {st_mode=S_IFREG|0640, st_size=65536, ...}) = 0
stat("/u01/app/oracle/diag/rdbms/book/book/metadata/ADR_INVALIDATION.ams", {st_mode=S_IFREG|0640, st_size=65536, ...}) = 0
lstat("/u01/app/oracle/diag/rdbms/book/book/metadata/INC_METER_IMPT_DEF.ams", {st_mode=S_IFREG|0640, st_size=65536, ...}) = 0
stat("/u01/app/oracle/diag/rdbms/book/book/metadata/INC_METER_IMPT_DEF.ams", {st_mode=S_IFREG|0640, st_size=65536, ...}) = 0
lstat("/u01/app/oracle/diag/rdbms/book/book/metadata/INC_METER_PK_IMPTS.ams", {st_mode=S_IFREG|0640, st_size=65536, ...}) = 0
stat("/u01/app/oracle/diag/rdbms/book/book/metadata/INC_METER_PK_IMPTS.ams", {st_mode=S_IFREG|0640, st_size=65536, ...}) = 0
lstat("/u01/app/oracle/diag/rdbms/book/book/metadata/INCIDENT.ams", {st_mode=S_IFREG|0640, st_size=475136, ...}) = 0
stat("/u01/app/oracle/diag/rdbms/book/book/metadata/INCIDENT.ams", {st_mode=S_IFREG|0640, st_size=475136, ...}) = 0
shmdt(0x60000000) = 0
shmdt(0x60c00000) = 0
shmdt(0x86800000) = 0
munmap(0x7fcda79d2000, 143360) = 0
munmap(0x7fcda79f5000, 143360) = 0
munmap(0x7fcda7a18000, 143360) = 0
close(4) = 0
munmap(0x7fcda7b7b000, 262144) = 0
munmap(0x7fcda75ba000, 524288) = 0
munmap(0x7fcda74ba000, 1048576) = 0
munmap(0x7fcda763c000, 524288) = 0
close(6) = 0
rt_sigprocmask(SIG_BLOCK, [ALRM], NULL, 8) = 0
rt_sigaction(SIGALRM, {SIG_DFL, ~[ILL ABRT BUS FPE SEGV USR2 XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x379a00eca0}, {0x7edfb0c, ~[ILL ABRT BUS FPE KILL SEGV USR2 STOP XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x379a00eca0}, 8) = 0
rt_sigprocmask(SIG_UNBLOCK, [ALRM], NULL, 8) = 0
rt_sigaction(SIGILL, {SIG_DFL, ~[ILL ABRT BUS FPE SEGV USR2 XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x379a00eca0}, {0x6b48fd6, ~[ILL ABRT BUS FPE KILL SEGV USR2 STOP XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_STACK|SA_SIGINFO, 0x379a00eca0}, 8) = 0
rt_sigaction(SIGTRAP, {SIG_DFL, ~[ILL ABRT BUS FPE SEGV USR2 XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x379a00eca0}, {0x6b48fd6, ~[ILL ABRT BUS FPE KILL SEGV USR2 STOP XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_STACK|SA_SIGINFO, 0x379a00eca0}, 8) = 0
rt_sigaction(SIGABRT, {SIG_DFL, ~[ILL ABRT BUS FPE SEGV USR2 XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x379a00eca0}, {0x6b48fd6, ~[ILL ABRT BUS FPE KILL SEGV USR2 STOP XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_STACK|SA_SIGINFO, 0x379a00eca0}, 8) = 0
rt_sigaction(SIGFPE, {SIG_DFL, ~[ILL ABRT BUS FPE SEGV USR2 XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x379a00eca0}, {0x6b48fd6, ~[ILL ABRT BUS FPE KILL SEGV USR2 STOP XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_STACK|SA_SIGINFO, 0x379a00eca0}, 8) = 0
rt_sigaction(SIGBUS, {SIG_DFL, ~[ILL ABRT BUS FPE SEGV USR2 XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x379a00eca0}, {0x6b48fd6, ~[ILL ABRT BUS FPE KILL SEGV USR2 STOP XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_STACK|SA_SIGINFO, 0x379a00eca0}, 8) = 0
rt_sigaction(SIGSEGV, {SIG_DFL, ~[ILL ABRT BUS FPE SEGV USR2 XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x379a00eca0}, {0x6b48fd6, ~[ILL ABRT BUS FPE KILL SEGV USR2 STOP XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_STACK|SA_SIGINFO, 0x379a00eca0}, 8) = 0
rt_sigaction(SIGSYS, {SIG_DFL, ~[ILL ABRT BUS FPE SEGV USR2 XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x379a00eca0}, {0x6b48fd6, ~[ILL ABRT BUS FPE KILL SEGV USR2 STOP XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_STACK|SA_SIGINFO, 0x379a00eca0}, 8) = 0
rt_sigaction(SIGXCPU, {SIG_DFL, ~[ILL ABRT BUS FPE SEGV USR2 XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x379a00eca0}, {0x6b48fd6, ~[ILL ABRT BUS FPE KILL SEGV USR2 STOP XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_STACK|SA_SIGINFO, 0x379a00eca0}, 8) = 0
rt_sigaction(SIGXFSZ, {SIG_DFL, ~[ILL ABRT BUS FPE SEGV USR2 XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x379a00eca0}, {0x6b48fd6, ~[ILL ABRT BUS FPE KILL SEGV USR2 STOP XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_STACK|SA_SIGINFO, 0x379a00eca0}, 8) = 0
rt_sigaction(SIGTERM, {SIG_DFL, ~[ILL ABRT BUS FPE SEGV USR2 XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x379a00eca0}, {0x1, ~[ILL ABRT BUS FPE KILL SEGV USR2 STOP XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x379a00eca0}, 8) = 0
rt_sigaction(SIGHUP, {SIG_DFL, ~[ILL ABRT BUS FPE SEGV USR2 XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x379a00eca0}, {0x1, ~[ILL ABRT BUS FPE KILL SEGV USR2 STOP XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x379a00eca0}, 8) = 0
rt_sigaction(SIGPIPE, {SIG_DFL, ~[ILL ABRT BUS FPE SEGV USR2 XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x379a00eca0}, {0x7edfb0c, ~[ILL ABRT BUS FPE KILL SEGV USR2 STOP XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x379a00eca0}, 8) = 0
rt_sigaction(SIGPIPE, {0x7edfb0c, ~[ILL ABRT BUS FPE SEGV USR2 XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x379a00eca0}, {SIG_DFL, ~[ILL ABRT BUS FPE KILL SEGV USR2 STOP XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x379a00eca0}, 8) = 0
rt_sigaction(SIGVTALRM, {SIG_DFL, ~[ILL ABRT BUS FPE SEGV USR2 XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x379a00eca0}, {0x1, ~[ILL ABRT BUS FPE KILL SEGV USR2 STOP XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x379a00eca0}, 8) = 0
rt_sigaction(SIGPROF, {SIG_DFL, ~[ILL ABRT BUS FPE SEGV USR2 XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x379a00eca0}, {0x1, ~[ILL ABRT BUS FPE KILL SEGV USR2 STOP XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x379a00eca0}, 8) = 0
rt_sigaction(SIGUSR1, {SIG_DFL, ~[ILL ABRT BUS FPE SEGV USR2 XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x379a00eca0}, {0x1, ~[ILL ABRT BUS FPE KILL SEGV USR2 STOP XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x379a00eca0}, 8) = 0
rt_sigaction(SIGUSR2, {SIG_DFL, ~[ILL ABRT BUS FPE SEGV USR2 XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x379a00eca0}, {0x6b48b00, ~[ILL ABRT BUS FPE KILL SEGV USR2 STOP XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x379a00eca0}, 8) = 0
close(3) = 0
munmap(0x7fcda7cbb000, 2116176) = 0
munmap(0x7fcda7a3b000, 1310720) = 0
exit_group(0) = ?
Process 17219 detached
--//如果正常執行跟蹤看到的是這個:
$ strace -f -p 17236
Process 17236 attached - interrupt to quit
read(7, "\2\t\0\0\6\0\0\0\0\0\21i\32\376\377\377\377\377\377\377\377\1\0\0\0\0\0\0\0\2\0\0"..., 8208) = 521
getrusage(RUSAGE_SELF, {ru_utime={0, 21996}, ru_stime={0, 15997}, ...}) = 0
times({tms_utime=2, tms_stime=1, tms_cutime=0, tms_cstime=0}) = 1825705565
getrusage(RUSAGE_SELF, {ru_utime={0, 21996}, ru_stime={0, 15997}, ...}) = 0
getrusage(RUSAGE_SELF, {ru_utime={0, 21996}, ru_stime={0, 15997}, ...}) = 0
times({tms_utime=2, tms_stime=1, tms_cutime=0, tms_cstime=0}) = 1825705565
getrusage(RUSAGE_SELF, {ru_utime={0, 21996}, ru_stime={0, 15997}, ...}) = 0
times({tms_utime=2, tms_stime=1, tms_cutime=0, tms_cstime=0}) = 1825705565
getrusage(RUSAGE_SELF, {ru_utime={0, 21996}, ru_stime={0, 15997}, ...}) = 0
times({tms_utime=2, tms_stime=1, tms_cutime=0, tms_cstime=0}) = 1825705565
getrusage(RUSAGE_SELF, {ru_utime={0, 21996}, ru_stime={0, 15997}, ...}) = 0
getrusage(RUSAGE_SELF, {ru_utime={0, 21996}, ru_stime={0, 15997}, ...}) = 0
times({tms_utime=2, tms_stime=1, tms_cutime=0, tms_cstime=0}) = 1825705565
getrusage(RUSAGE_SELF, {ru_utime={0, 21996}, ru_stime={0, 15997}, ...}) = 0
getrusage(RUSAGE_SELF, {ru_utime={0, 21996}, ru_stime={0, 15997}, ...}) = 0
getrusage(RUSAGE_SELF, {ru_utime={0, 21996}, ru_stime={0, 15997}, ...}) = 0
getrusage(RUSAGE_SELF, {ru_utime={0, 21996}, ru_stime={0, 15997}, ...}) = 0
times({tms_utime=2, tms_stime=1, tms_cutime=0, tms_cstime=0}) = 1825705566
times({tms_utime=2, tms_stime=1, tms_cutime=0, tms_cstime=0}) = 1825705566
getrusage(RUSAGE_SELF, {ru_utime={0, 21996}, ru_stime={0, 15997}, ...}) = 0
getrusage(RUSAGE_SELF, {ru_utime={0, 21996}, ru_stime={0, 16997}, ...}) = 0
getrusage(RUSAGE_SELF, {ru_utime={0, 21996}, ru_stime={0, 16997}, ...}) = 0
getrusage(RUSAGE_SELF, {ru_utime={0, 21996}, ru_stime={0, 16997}, ...}) = 0
times({tms_utime=2, tms_stime=1, tms_cutime=0, tms_cstime=0}) = 1825705566
write(10, "\2\302\0\0\6\0\0\0\0\0\20\27\0\0\0oh\241\271\24\37\270gC\33\240\301\32#\30\246x"..., 706) = 706
read(7, "\0\25\0\0\6\0\0\0\0\0\3\5\34\3\0\0\0\310\0\0\0", 8208) = 21
getrusage(RUSAGE_SELF, {ru_utime={0, 21996}, ru_stime={0, 16997}, ...}) = 0
times({tms_utime=2, tms_stime=1, tms_cutime=0, tms_cstime=0}) = 1825705566
getrusage(RUSAGE_SELF, {ru_utime={0, 21996}, ru_stime={0, 16997}, ...}) = 0
getrusage(RUSAGE_SELF, {ru_utime={0, 21996}, ru_stime={0, 16997}, ...}) = 0
getrusage(RUSAGE_SELF, {ru_utime={0, 21996}, ru_stime={0, 16997}, ...}) = 0
getrusage(RUSAGE_SELF, {ru_utime={0, 21996}, ru_stime={0, 16997}, ...}) = 0
times({tms_utime=2, tms_stime=1, tms_cutime=0, tms_cstime=0}) = 1825705566
write(10, "\0\254\0\0\6\0\0\0\0\0\4\1\0\0\0\32\0\1\1\0\0\0{\5\0\0\0\0\3\0\0\0"..., 172) = 172
read(7,
--//sqlplus下使用show recycebin給維護者埋了一個不小的坑.浪費一個上午的時間定位這個問題.
--//在linux下太難定位了,直接crash,真心沒想到問題出在這個空格+分號上.
--//如果不在windows下測試,無法定位這個問題,不知道為什麼windows下的oracle資料庫連線程式為什麼不會crash,也許linux與windows
--//有一些不同.windows使用執行緒,而linux下使用程式.
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/267265/viewspace-2782601/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- [20240818]測試21c下sqlplus show recyclebin的小問題2.txtSQL
- [20211220]記錄使用sqlplus的小問題.txtSQL
- [20211221]記錄使用sqlplus的小問題補充.txtSQL
- [20180420]windows下使用cmd的小問題.txtWindows
- [20160113]sqlplus使用問題.txtSQL
- Mysql show processlist 排查問題MySql
- [20221203]sqlplus set trimspool 問題.txtSQL
- 故障分析 | show processlist 引起的效能問題
- [20221202]sqlplus set trimout 問題.txtSQL
- linux 下sqlplus 歷史記錄問題LinuxSQL
- [20191204]sqlplus特殊定義導致的問題.txtSQL
- [20180130]sqlplus欄位顯示問題.txtSQL
- Linux下共享庫問題導致無法啟動SQLPLUS的問題解決LinuxSQL
- [20190108]rlwrap sqlplus tee相關問題.txtSQL
- 11g SQLPLUS新增SHOW SPPARAMETER命令SQL
- [20210722]ORA-38760與flashback database.txtDatabase
- sqlplus註釋問題SQL
- sqlplus與空行.txtSQL
- 登陸sqlplus出現問號的問題SQL
- [20210722]資料庫異常關閉的處理.txt資料庫
- [20120109]sqlplus 與set longchunksize 設定問題.txtSQLGC
- LINUX下非oracle使用者執行sqlplus問題LinuxOracleSQL
- [20190110]rlwrap sqlplus tee相關問題3.txtSQL
- LINUX 下安裝ORACLE的幾個小問題LinuxOracle
- 小問題-用分析函式求平均時間段的統計數.txt函式
- [20150727]使用標量子查詢小問題.txt
- oracle sqlplus中文顯示亂碼的問題OracleSQL
- sqlplus註釋行號錯誤的問題SQL
- 解決Windows下棧記憶體過小的問題Windows記憶體
- Git clone 的小問題Git
- jquery中的小問題jQuery
- postgresql copy UNICODE txt 問題。SQLUnicode
- [20190114]conemu與kitty小問題.txt
- v-if與v-show造成部分元素丟失的問題——v-if複用元素問題
- sqlplus小記SQL
- sqlplus下的命令SQL
- show_space 查詢表資料塊碎片問題 - show_space 結果解釋 7
- [20171215]關於md5sum的計算的小問題.txt