某SDE问题解决过程简记

最新推荐文章于 2022-03-21 11:17:22 发布
最新推荐文章于 2022-03-21 11:17:22 发布
阅读量2.8k 收藏
点赞数
分类专栏： Oracle数据库 文章标签： parsing loops nested table access sql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/liufeng1980423/article/details/6072511
版权

环境：

    ArcSDE 9.2+sp6
    Oracle9.2.0.8
    OS:HP-UX 11.11

    Desktop:9.2+sp6

现象：

     SDE的服务起来之后，无法使用ArcCatalog连接，报下图的错误：

 

image

SDE的后台日志为：

    sde的日志报错信息:
    ERROR(-8),could't start server task;

解决过程：

从ArcCatalog报的错误和SDE的后台日志报的错误，无法确定问题的原因。 但是从错误的本身可以判断出来在这个过程中数据库应该已经连上了，但是因为某些条件出现了问题，导致了又断开了。因此抓取了一下整个过程后台所执行的SQL语句：

使用 oracle 提供的10046事件跟踪，产生跟踪信息如下： 

   1:  
/**********************************************************************************************************/
   2:  
/oracle/admin
/newcrm/udump/newcrm_ora_7126.trc
   3:  
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
   4:  
With
 the Partitioning and
 OLAP options
   5:  
JServer Release 9.2.0.8.0 - Production
   6:  
ORACLE_HOME = /oracle/product/9.2.0
   7:  
System name: HP-UX
   8:  
Node name: superdb
   9:  
Release: B.11.11
  10:  
Version: U
  11:  
Machine: 9000/800
  12:  
Instance name: newcrm
  13:  
Redo thread mounted by
 this instance: 1
  14:  
Oracle process number: 13
  15:  
Unix process pid: 7126, image:oracle@superdb(TNS V1-V3)
  16:  
 
  17:  
*** SESSION
 ID:(9.34) 2008-11-24 18:20:55.972
  18:  
WAIT #0: nam='SQL*Net message to client'
 ela= 3 p1=1413697536 p2=1 p3=0
  19:  
WAIT #0: nam='SQL*Net message from client'
 ela= 1603 p1=1413697536 p2=1 p3=0
  20:  
=====================
  21:  
PARSING IN
 CURSOR
 #1 len=147 dep=1 uid=0 ct=3 lid=0 tim=10643870288245 hv=1356713530 ad='5e72de8'

  22:  
select
 privilege#,level
 from
 sysauth$ connect
 by
 grantee#=prior
 privilege# and
 privilege#>0 start
 with
 (grantee#=:1 or
 grantee#=1) and
 privilege#>0
  23:  
END
 OF
 STMT
  24:  
PARSE #1:c=0,e=72,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=10643870288231
  25:  
BINDS #1:
  26:  
 bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 acflg=08 oacfl2=c000000600000001 size
=24 ffset=0
  27:  
   bfp=800003fa0006b730 bln=22 avl=02 flg=05
  28:  
   value
=37
  29:  
EXEC
 #1:c=0,e=204,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=10643870288570
  30:  
FETCH
 #1:c=0,e=293,p=0,cr=6,cu=0,mis=0,r=1,dep=1,og=4,tim=10643870288895
  31:  
FETCH
 #1:c=0,e=14,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,tim=10643870288951
  32:  
FETCH
 #1:c=0,e=6,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=10643870288984
  33:  
STAT #1 id=1 cnt=2 pid=0 pos=1 bj=0 p='CONNECT BY WITH FILTERING '

  34:  
STAT #1 id=2 cnt=2 pid=1 pos=1 bj=91 p='TABLE ACCESS BY INDEX ROWID SYSAUTH$ '

  35:  
STAT #1 id=3 cnt=2 pid=2 pos=1 bj=0 p='CONCATENATION  '

  36:  
STAT #1 id=4 cnt=0 pid=3 pos=1 bj=110 p='INDEX RANGE SCAN I_SYSAUTH1 '

  37:  
STAT #1 id=5 cnt=2 pid=3 pos=2 bj=110 p='INDEX RANGE SCAN I_SYSAUTH1 '

  38:  
STAT #1 id=6 cnt=0 pid=1 pos=2 bj=0 p='NESTED LOOPS  '

  39:  
STAT #1 id=7 cnt=2 pid=6 pos=1 bj=0 p='BUFFER SORT '

  40:  
STAT #1 id=8 cnt=2 pid=7 pos=1 bj=0 p='CONNECT BY PUMP  '

  41:  
STAT #1 id=9 cnt=0 pid=6 pos=2 bj=110 p='INDEX RANGE SCAN I_SYSAUTH1 '

  42:  
STAT #1 id=10 cnt=0 pid=1 pos=3 bj=91 p='TABLE ACCESS FULL SYSAUTH$ '

  43:  
=====================
  44:  
PARSING IN
 CURSOR
 #2 len=48 dep=2 uid=0 ct=3 lid=0 tim=10643870289770 hv=3997906522 ad='7eac418'

  45:  
select
 user
# from
 sys.user
$ where
 name = 'OUTLN'

  46:  
END
 OF
 STMT
  47:  
PARSE #2:c=0,e=73,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=10643870289763
  48:  
BINDS #2:
  49:  
EXEC
 #2:c=0,e=32,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=10643870289876
  50:  
FETCH
 #2:c=0,e=39,p=0,cr=2,cu=0,mis=0,r=1,dep=2,og=4,tim=10643870289942
  51:  
STAT #2 id=1 cnt=1 pid=0 pos=1 bj=22 p='TABLE ACCESS BY INDEX ROWID USER$ '

  52:  
STAT #2 id=2 cnt=1 pid=1 pos=1 bj=44 p='INDEX UNIQUE SCAN I_USER1 '

  53:  
=====================
  54:  
PARSING IN
 CURSOR
 #1 len=495 dep=1 uid=37 ct=42 lid=37 tim=10643870290284 hv=3607159657 ad='5e6a6b8'

  55:  
ALTER
 SESSION
 SET
 NLS_LANGUAGE= 'SIMPLIFIED CHINESE'
 NLS_TERRITORY= 'CHINA'
 NLS_CURRENCY= 'RMB'
 NLS_ISO_CURRENCY= 'CHINA'
 NLS_NUMERIC_CHARACTERS= '.,'
 NLS_CALENDAR= 'GREGORIAN'
 NLS_DATE_FORMAT= 'DD-MON-RR'
 NLS_DATE_LANGUAGE= 'SIMPLIFIED CHINESE'
  NLS_SORT= 'BINARY'
 TIME_ZONE= '+08:00'
 NLS_DUAL_CURRENCY = 'RMB'
 NLS_TIME_FORMAT = 'HH.MI.SSXFF AM'
 NLS_TIMESTAMP_FORMAT = 'DD-MON-RR HH.MI.SSXFF AM'
 NLS_TIME_TZ_FORMAT = 'HH.MI.SSXFF AM TZR'
 NLS_TIMESTAMP_TZ_FORMAT = 'DD-MON-RR HH.MI.SSXFF AM TZR'

  56:  
END
 OF
 STMT
  57:  
PARSE #1:c=0,e=638,p=0,cr=2,cu=0,mis=0,r=0,dep=1,og=4,tim=10643870290277
  58:  
BINDS #1:
  59:  
EXEC
 #1:c=0,e=502,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=10643870290860
  60:  
WAIT #0: nam='SQL*Net message to client'
 ela= 2 p1=1413697536 p2=1 p3=0
  61:  
WAIT #0: nam='SQL*Net message from client'
 ela= 772 p1=1413697536 p2=1 p3=0
  62:  
=====================
  63:  
PARSING IN
 CURSOR
 #1 len=21 dep=0 uid=37 ct=3 lid=37 tim=10643870291986 hv=1702091759 ad='7ea7170'

  64:  
SELECT
 USER
 FROM
 DUAL
  65:  
END
 OF
 STMT
  66:  
PARSE #1:c=0,e=72,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870291979
  67:  
BINDS #1:
  68:  
EXEC
 #1:c=0,e=28,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870292093
  69:  
WAIT #1: nam='SQL*Net message to client'
 ela= 2 p1=1413697536 p2=1 p3=0
  70:  
FETCH
 #1:c=0,e=76,p=0,cr=3,cu=0,mis=0,r=1,dep=0,og=4,tim=10643870292229
  71:  
WAIT #1: nam='SQL*Net message from client'
 ela= 889 p1=1413697536 p2=1 p3=0
  72:  
STAT #1 id=1 cnt=1 pid=0 pos=1 bj=222 p='TABLE ACCESS FULL DUAL '

  73:  
=====================
  74:  
PARSING IN
 CURSOR
 #1 len=80 dep=0 uid=37 ct=47 lid=37 tim=10643870293586 hv=1755109904 ad='6e49d28'

  75:  
BEGIN
 /* ArcSDE plsql */ dbms_utility.db_version (:version,:compatibility); END
;
  76:  
END
 OF
 STMT
  77:  
PARSE #1:c=0,e=222,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870293578
  78:  
BINDS #1:
  79:  
 bind 0: dty=1 mxl=128(64) mal=00 scl=00 pre=00 acflg=02 oacfl2=8000000100000010 size
=256 ffset=0
  80:  
   bfp=800003fa0005f650 bln=128 avl=00 flg=05
  81:  
 bind 1: dty=1 mxl=128(64) mal=00 scl=00 pre=00 acflg=02 oacfl2=8000000100000010 size
=0 ffset=128
  82:  
   bfp=800003fa0005f6d0 bln=128 avl=00 flg=01
  83:  
=====================
  84:  
PARSING IN
 CURSOR
 #2 len=62 dep=1 uid=0 ct=3 lid=0 tim=10643870294185 hv=1439923766 ad='7e96fa0'

  85:  
SELECT
 VALUE
   FROM
 SYS.V$PARAMETER
  WHERE
 NAME = 'compatible'

  86:  
END
 OF
 STMT
  87:  
PARSE #2:c=0,e=63,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=10643870294178
  88:  
BINDS #2:
  89:  
EXEC
 #2:c=0,e=34,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=10643870294292
  90:  
FETCH
 #2:c=0,e=4458,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,tim=10643870298771
  91:  
WAIT #1: nam='SQL*Net message to client'
 ela= 2 p1=1413697536 p2=1 p3=0
  92:  
EXEC
 #1:c=10000,e=5243,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=4,tim=10643870298907
  93:  
WAIT #1: nam='SQL*Net message from client'
 ela= 643 p1=1413697536 p2=1 p3=0
  94:  
=====================
  95:  
PARSING IN
 CURSOR
 #1 len=82 dep=0 uid=37 ct=3 lid=37 tim=10643870299752 hv=1074646296 ad='8dba280'

  96:  
SELECT
 major, minor, bugfix, description, release, sdesvr_rel_low FROM
 SDE.version
  97:  
END
 OF
 STMT
  98:  
PARSE #1:c=0,e=41,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870299745
  99:  
BINDS #1:
 100:  
EXEC
 #1:c=0,e=25,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870299860
 101:  
WAIT #1: nam='SQL*Net message to client'
 ela= 1 p1=1413697536 p2=1 p3=0
 102:  
FETCH
 #1:c=0,e=47,p=0,cr=3,cu=0,mis=0,r=1,dep=0,og=4,tim=10643870299985
 103:  
WAIT #1: nam='SQL*Net message from client'
 ela= 1061 p1=1413697536 p2=1 p3=0
 104:  
STAT #1 id=1 cnt=1 pid=0 pos=1 bj=156217 p='TABLE ACCESS FULL VERSION '

 105:  
=====================
 106:  
PARSING IN
 CURSOR
 #1 len=204 dep=0 uid=37 ct=47 lid=37 tim=10643870301339 hv=3503961007 ad='7e8df28'

 107:  
BEGIN
 /* ArcSDE plsql */   :rval:= dbms_utility.get_parameter_value(:nval,:ival,:sval);:sql_code := SDE.sde_util.SE_SUCCESS; EXCEPTION
 WHEN
 OTHERS THEN
 :sql_code := SQLCODE
; :error_string := SQLERRM; END
;
 108:  
END
 OF
 STMT
 109:  
PARSE #1:c=0,e=131,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870301331
 110:  
WAIT #1: nam='SQL*Net more data from client'
 ela= 15 p1=1413697536 p2=1 p3=0
 111:  
BINDS #1:
 112:  
 bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 acflg=00 oacfl2=8000000100000000 size
=80 ffset=0
 113:  
   bfp=800003fa0005f700 bln=22 avl=00 flg=05
 114:  
 bind 1: dty=1 mxl=32(24) mal=00 scl=00 pre=00 acflg=20 oacfl2=8000000100000010 size
=0 ffset=24
 115:  
   bfp=800003fa0005f718 bln=32 avl=12 flg=01
 116:  
   value
="open_cursors"
 117:  
 bind 2: dty=2 mxl=22(22) mal=00 scl=00 pre=00 acflg=00 oacfl2=8000000100000000 size
=0 ffset=56
 118:  
   bfp=800003fa0005f738 bln=22 avl=02 flg=01
 119:  
   value
=44
 120:  
 bind 3: dty=1 mxl=4000(4000) mal=00 scl=00 pre=00 acflg=20 oacfl2=8000000100000010 size
=4000 ffset=0
 121:  
   bfp=800003fa0005df30 bln=4000 avl=2000 flg=05
 122:  
   value
=""...
 123:  
 bind 4: dty=2 mxl=22(22) mal=00 scl=00 pre=00 acflg=00 oacfl2=8000000100000000 size
=24 ffset=0
 124:  
   bfp=800003fa0005f6d0 bln=22 avl=00 flg=05
 125:  
 bind 5: dty=1 mxl=2000(1024) mal=00 scl=00 pre=00 acflg=02 oacfl2=8000000100000010 size
=2000 ffset=0
 126:  
   bfp=800003fa0005d720 bln=2000 avl=00 flg=05
 127:  
=====================
 128:  
PARSING IN
 CURSOR
 #3 len=25 dep=1 uid=37 ct=3 lid=37 tim=10643870302296 hv=2403185938 ad='6e30078'

 129:  
SELECT
 USER
 FROM
 SYS.DUAL
 130:  
END
 OF
 STMT
 131:  
PARSE #3:c=0,e=63,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=10643870302289
 132:  
BINDS #3:
 133:  
EXEC
 #3:c=0,e=26,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=10643870302392
 134:  
FETCH
 #3:c=0,e=40,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=10643870302453
 135:  
BINDS #3:
 136:  
EXEC
 #3:c=0,e=26,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=10643870302742
 137:  
FETCH
 #3:c=0,e=21,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=10643870302786
 138:  
WAIT #1: nam='SQL*Net message to client'
 ela= 2 p1=1413697536 p2=1 p3=0
 139:  
WAIT #1: nam='SQL*Net more data to client'
 ela= 47 p1=1413697536 p2=2030 p3=0
 140:  
EXEC
 #1:c=0,e=1562,p=0,cr=6,cu=0,mis=0,r=1,dep=0,og=4,tim=10643870303000
 141:  
WAIT #1: nam='SQL*Net message from client'
 ela= 1556 p1=1413697536 p2=1 p3=0
 142:  
WAIT #0: nam='SQL*Net message to client'
 ela= 2 p1=1413697536 p2=1 p3=0
 143:  
WAIT #0: nam='SQL*Net message from client'
 ela= 504 p1=1413697536 p2=1 p3=0
 144:  
=====================
 145:  
PARSING IN
 CURSOR
 #4 len=47 dep=1 uid=0 ct=3 lid=0 tim=10643870305677 hv=2232614812 ad='8ed4910'

 146:  
select
 metadata from
 kopm$  where
 name='DB_FDO'

 147:  
END
 OF
 STMT
 148:  
PARSE #4:c=0,e=57,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=10643870305669
 149:  
BINDS #4:
 150:  
EXEC
 #4:c=0,e=33,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=10643870305791
 151:  
FETCH
 #4:c=0,e=17,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=10643870305836
 152:  
STAT #4 id=1 cnt=1 pid=0 pos=1 bj=350 p='TABLE ACCESS BY INDEX ROWID KOPM$ '

 153:  
STAT #4 id=2 cnt=1 pid=1 pos=1 bj=351 p='INDEX UNIQUE SCAN I_KOPM1 '

 154:  
WAIT #0: nam='SQL*Net message to client'
 ela= 2 p1=1413697536 p2=1 p3=0
 155:  
WAIT #0: nam='SQL*Net message from client'
 ela= 779 p1=1413697536 p2=1 p3=0
 156:  
WAIT #0: nam='SQL*Net message to client'
 ela= 1 p1=1413697536 p2=1 p3=0
 157:  
WAIT #0: nam='SQL*Net message from client'
 ela= 816 p1=1413697536 p2=1 p3=0
 158:  
=====================
 159:  
PARSING IN
 CURSOR
 #7 len=121 dep=0 uid=37 ct=3 lid=37 tim=10643870308650 hv=3709805476 ad='5e42fe0'

 160:  
select
 text from
 ALL_TYPE_VERSIONS where
 wner = 'SDE'
 and
 type_name = upper
(:type_name) and
 text like
 '%C_Type_Release%'

 161:  
END
 OF
 STMT
 162:  
PARSE #7:c=0,e=139,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870308642
 163:  
BINDS #7:
 164:  
 bind 0: dty=1 mxl=32(22) mal=00 scl=00 pre=00 acflg=20 oacfl2=c000000600000010 size
=32 ffset=0
 165:  
   bfp=800003fa00073008 bln=32 avl=11 flg=05
 166:  
   value
="ST_GEOMETRY"
 167:  
EXEC
 #7:c=0,e=1020,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870309752
 168:  
WAIT #7: nam='SQL*Net message to client'
 ela= 1 p1=1413697536 p2=1 p3=0
 169:  
FETCH
 #7:c=0,e=281,p=0,cr=11,cu=0,mis=0,r=1,dep=0,og=4,tim=10643870310100
 170:  
WAIT #7: nam='SQL*Net message from client'
 ela= 934 p1=1413697536 p2=1 p3=0
 171:  
STAT #7 id=1 cnt=1 pid=0 pos=1 bj=0 p='FILTER  '

 172:  
STAT #7 id=2 cnt=1 pid=1 pos=1 bj=71 p='TABLE ACCESS BY INDEX ROWID SOURCE$ '

 173:  
STAT #7 id=3 cnt=26 pid=2 pos=1 bj=0 p='NESTED LOOPS  '

 174:  
STAT #7 id=4 cnt=1 pid=3 pos=1 bj=0 p='NESTED LOOPS  '

 175:  
STAT #7 id=5 cnt=1 pid=4 pos=1 bj=0 p='NESTED LOOPS  '

 176:  
STAT #7 id=6 cnt=1 pid=5 pos=1 bj=22 p='TABLE ACCESS BY INDEX ROWID USER$ '

 177:  
STAT #7 id=7 cnt=1 pid=6 pos=1 bj=44 p='INDEX UNIQUE SCAN I_USER1 '

 178:  
STAT #7 id=8 cnt=1 pid=5 pos=2 bj=18 p='TABLE ACCESS BY INDEX ROWID OBJ$ '

 179:  
STAT #7 id=9 cnt=2 pid=8 pos=1 bj=37 p='INDEX RANGE SCAN I_OBJ2 '

 180:  
STAT #7 id=10 cnt=1 pid=4 pos=2 bj=300 p='INDEX UNIQUE SCAN I_TYPE2 '

 181:  
STAT #7 id=11 cnt=24 pid=3 pos=2 bj=119 p='INDEX RANGE SCAN I_SOURCE1 '

 182:  
STAT #7 id=12 cnt=0 pid=1 pos=2 bj=0 p='NESTED LOOPS  '

 183:  
STAT #7 id=13 cnt=0 pid=12 pos=1 bj=309 p='FIXED TABLE FULL X$KZSRO '

 184:  
STAT #7 id=14 cnt=0 pid=12 pos=2 bj=109 p='INDEX RANGE SCAN I_OBJAUTH2 '

 185:  
STAT #7 id=15 cnt=0 pid=1 pos=3 bj=310 p='FIXED TABLE FULL X$KZSPR '

 186:  
=====================
 187:  
PARSING IN
 CURSOR
 #7 len=142 dep=0 uid=37 ct=3 lid=37 tim=10643870311620 hv=3347668576 ad='8d986f0'

 188:  
SELECT
 status,validated FROM
   all_constraints WHERE
  wner = :table_owner AND
 constraint_name = :constraint_name AND
 table_name = :table_name
 189:  
END
 OF
 STMT
 190:  
PARSE #7:c=0,e=124,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870311612
 191:  
BINDS #7:
 192:  
 bind 0: dty=1 mxl=128(58) mal=00 scl=00 pre=00 acflg=00 oacfl2=10 size
=384 ffset=0
 193:  
   bfp=800003f9c000a908 bln=128 avl=03 flg=05
 194:  
   value
="SDE"
 195:  
 bind 1: dty=1 mxl=128(58) mal=00 scl=00 pre=00 acflg=00 oacfl2=10 size
=0 ffset=128
 196:  
   bfp=800003f9c000a988 bln=128 avl=09 flg=01
 197:  
   value
="STATES_FK"
 198:  
 bind 2: dty=1 mxl=128(58) mal=00 scl=00 pre=00 acflg=00 oacfl2=10 size
=0 ffset=256
 199:  
   bfp=800003f9c000aa08 bln=128 avl=06 flg=01
 200:  
   value
="STATES"
 201:  
EXEC
 #7:c=0,e=174,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870311876
 202:  
WAIT #7: nam='SQL*Net message to client'
 ela= 2 p1=1413697536 p2=1 p3=0
 203:  
FETCH
 #7:c=0,e=30,p=0,cr=4,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870311970
 204:  
WAIT #7: nam='SQL*Net message from client'
 ela= 583 p1=1413697536 p2=1 p3=0
 205:  
STAT #7 id=1 cnt=0 pid=0 pos=1 bj=0 p='FILTER  '

 206:  
STAT #7 id=2 cnt=0 pid=1 pos=1 bj=0 p='NESTED LOOPS OUTER '

 207:  
STAT #7 id=3 cnt=0 pid=2 pos=1 bj=0 p='NESTED LOOPS OUTER '

 208:  
STAT #7 id=4 cnt=0 pid=3 pos=1 bj=0 p='NESTED LOOPS OUTER '

 209:  
STAT #7 id=5 cnt=0 pid=4 pos=1 bj=0 p='NESTED LOOPS OUTER '

 210:  
STAT #7 id=6 cnt=0 pid=5 pos=1 bj=0 p='NESTED LOOPS  '

 211:  
STAT #7 id=7 cnt=0 pid=6 pos=1 bj=0 p='NESTED LOOPS OUTER '

 212:  
STAT #7 id=8 cnt=0 pid=7 pos=1 bj=0 p='NESTED LOOPS  '

 213:  
STAT #7 id=9 cnt=0 pid=8 pos=1 bj=0 p='NESTED LOOPS  '

 214:  
STAT #7 id=10 cnt=1 pid=9 pos=1 bj=22 p='TABLE ACCESS BY INDEX ROWID USER$ '

 215:  
STAT #7 id=11 cnt=1 pid=10 pos=1 bj=44 p='INDEX UNIQUE SCAN I_USER1 '

 216:  
STAT #7 id=12 cnt=0 pid=9 pos=2 bj=28 p='TABLE ACCESS BY INDEX ROWID CON$ '

 217:  
STAT #7 id=13 cnt=0 pid=12 pos=1 bj=48 p='INDEX UNIQUE SCAN I_CON1 '

 218:  
STAT #7 id=14 cnt=0 pid=8 pos=2 bj=31 p='TABLE ACCESS BY INDEX ROWID CDEF$ '

 219:  
STAT #7 id=15 cnt=0 pid=14 pos=1 bj=50 p='INDEX UNIQUE SCAN I_CDEF1 '

 220:  
STAT #7 id=16 cnt=0 pid=7 pos=2 bj=36 p='INDEX UNIQUE SCAN I_OBJ1 '

 221:  
STAT #7 id=17 cnt=0 pid=6 pos=2 bj=18 p='TABLE ACCESS BY INDEX ROWID OBJ$ '

 222:  
STAT #7 id=18 cnt=0 pid=17 pos=1 bj=36 p='INDEX UNIQUE SCAN I_OBJ1 '

 223:  
STAT #7 id=19 cnt=0 pid=5 pos=2 bj=36 p='INDEX UNIQUE SCAN I_OBJ1 '

 224:  
STAT #7 id=20 cnt=0 pid=4 pos=2 bj=28 p='TABLE ACCESS BY INDEX ROWID CON$ '

 225:  
STAT #7 id=21 cnt=0 pid=20 pos=1 bj=49 p='INDEX UNIQUE SCAN I_CON2 '

 226:  
STAT #7 id=22 cnt=0 pid=3 pos=2 bj=22 p='TABLE ACCESS CLUSTER USER$ '

 227:  
STAT #7 id=23 cnt=0 pid=22 pos=1 bj=11 p='INDEX UNIQUE SCAN I_USER# '

 228:  
STAT #7 id=24 cnt=0 pid=2 pos=2 bj=22 p='TABLE ACCESS CLUSTER USER$ '

 229:  
STAT #7 id=25 cnt=0 pid=24 pos=1 bj=11 p='INDEX UNIQUE SCAN I_USER# '

 230:  
STAT #7 id=26 cnt=0 pid=1 pos=2 bj=0 p='NESTED LOOPS  '

 231:  
STAT #7 id=27 cnt=0 pid=26 pos=1 bj=309 p='FIXED TABLE FULL X$KZSRO '

 232:  
STAT #7 id=28 cnt=0 pid=26 pos=2 bj=109 p='INDEX RANGE SCAN I_OBJAUTH2 '

 233:  
STAT #7 id=29 cnt=0 pid=1 pos=3 bj=310 p='FIXED TABLE FULL X$KZSPR '

 234:  
XCTEND rlbk=0, rd_only=1
 235:  
WAIT #0: nam='SQL*Net message to client'
 ela= 1 p1=1413697536 p2=1 p3=0
 236:  
WAIT #0: nam='SQL*Net message from client'
 ela= 739 p1=1413697536 p2=1 p3=0
 237:  
=====================
 238:  
PARSING IN
 CURSOR
 #7 len=82 dep=0 uid=37 ct=3 lid=37 tim=10643870314110 hv=1074646296 ad='8dba280'

 239:  
SELECT
 major, minor, bugfix, description, release, sdesvr_rel_low FROM
 SDE.version
 240:  
END
 OF
 STMT
 241:  
PARSE #7:c=0,e=29,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870314103
 242:  
BINDS #7:
 243:  
EXEC
 #7:c=0,e=23,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870314206
 244:  
WAIT #7: nam='SQL*Net message to client'
 ela= 1 p1=1413697536 p2=1 p3=0
 245:  
FETCH
 #7:c=0,e=36,p=0,cr=3,cu=0,mis=0,r=1,dep=0,og=4,tim=10643870314315
 246:  
WAIT #7: nam='SQL*Net message from client'
 ela= 938 p1=1413697536 p2=1 p3=0
 247:  
STAT #7 id=1 cnt=1 pid=0 pos=1 bj=156217 p='TABLE ACCESS FULL VERSION '

 248:  
=====================
 249:  
PARSING IN
 CURSOR
 #7 len=73 dep=0 uid=37 ct=3 lid=37 tim=10643870315460 hv=3244238113 ad='6e15f20'

 250:  
SELECT
 prop_name, char_prop_value, num_prop_value FROM
 SDE.SERVER_CONFIG
 251:  
END
 OF
 STMT
 252:  
PARSE #7:c=0,e=55,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870315453
 253:  
BINDS #7:
 254:  
EXEC
 #7:c=0,e=27,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870315563
 255:  
WAIT #7: nam='SQL*Net message to client'
 ela= 1 p1=1413697536 p2=1 p3=0
 256:  
FETCH
 #7:c=0,e=84,p=0,cr=3,cu=0,mis=0,r=41,dep=0,og=4,tim=10643870315711
 257:  
WAIT #7: nam='SQL*Net message from client'
 ela= 1391 p1=1413697536 p2=1 p3=0
 258:  
=====================
 259:  
PARSING IN
 CURSOR
 #8 len=31 dep=0 uid=37 ct=3 lid=37 tim=10643870317246 hv=2813680287 ad='5e338e0'

 260:  
SELECT
 COUNT
(*) FROM
 SDE.LAYERS
 261:  
END
 OF
 STMT
 262:  
PARSE #8:c=0,e=52,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870317239
 263:  
BINDS #8:
 264:  
EXEC
 #8:c=0,e=34,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=10643870317351
 265:  
WAIT #8: nam='SQL*Net message to client'
 ela= 1 p1=1413697536 p2=1 p3=0
 266:  
FETCH
 #8:c=0,e=58,p=0,cr=3,cu=0,mis=0,r=1,dep=0,og=4,tim=10643870317464
 267:  
WAIT #8: nam='SQL*Net message from client'
 ela= 916 p1=1413697536 p2=1 p3=0
 268:  
XCTEND rlbk=0, rd_only=1
 269:  
STAT #3 id=1 cnt=2 pid=0 pos=1 bj=222 p='TABLE ACCESS FULL DUAL '

 270:  
STAT #2 id=1 cnt=1 pid=0 pos=1 bj=0 p='MERGE JOIN  '

 271:  
STAT #2 id=2 cnt=872 pid=1 pos=1 bj=59 p='FIXED TABLE FULL X$KSPPCV '

 272:  
STAT #2 id=3 cnt=1 pid=1 pos=2 bj=0 p='FILTER  '

 273:  
STAT #2 id=4 cnt=1 pid=3 pos=1 bj=0 p='SORT JOIN '

 274:  
STAT #2 id=5 cnt=1 pid=4 pos=1 bj=58 p='FIXED TABLE FULL X$KSPPI '

 275:  
STAT #7 id=1 cnt=41 pid=0 pos=1 bj=156299 p='TABLE ACCESS FULL OBJ#(156299) '

 276:  
STAT #8 id=1 cnt=1 pid=0 pos=1 bj=0 p='SORT AGGREGATE '

 277:  
STAT #8 id=2 cnt=41 pid=1 pos=1 bj=156222 p='TABLE ACCESS FULL OBJ#(156222) '

 278:  
/****************************************************************************************************/

 

 

从后端执行的 sql 可以看出,还没有验证license信息就停止了,整个过程一共访问了以下几个sde的系统表:
sde.version,sde.server_config,sde.layers

其中version表记录sde的版本信息,layers表记录层信息，这两个表出错的肯能性不是很大，而server_config表
记录的sde的配置信息，所以重点查看server_config表中是否有参数被修改过,经查看status参数被修改成2.

查看帮助status参数的意义:
Values are 1 if this instance is accepting new connections or 2 if it is paused (not accepting new connections).

讲status改成1，问题解决。

至于为什么客户要这么修改，就不得而知了。

__风__
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
SDE的连接方法
echoant的专栏
01-16 1万+
ArcSDE数据库连接方法一、ArcCatalog中空间数据库连接方法：下面以基于Oracle 9i的ArcSDE数据库为例简要说明：1、应用服务器连接（也称为ArcSDE连接、三级连接）最常用的连接方式，默认情况下可读写，gsrvr进程由gimgr分配，在服务器端运行，要求服务器端ArcSDE服务启动。数据库 Oracle 9i Server 如：sdesvr Service 如：esri_s
网盘链接下载
09-27
直接复制百度网盘链接即可免登陆下载，速度比起百度网盘来，提升很大
oracle 写条件参数,触发redo写的几个条件
weixin_36330238的博客
04-03 250
触发redo写的几个条件WAIT #0: nam='rdbms ipc message' ela= 2999554 p1=300 p2=0 p3=0WAIT #0: nam='rdbms ipc message' ela= 2999470 p1=300 p2=0 p3=0WAIT #0: nam='rdbms ipc message' ela= 566819 p1=300 p2=0 p3=0WAI...
ArcSDE 日志文件表（一）
积思园
05-06 6735
今天跟大家介绍一下ArcSDE日志文件表，一直都想好好研究一下这块，因为基本上不太受大家重视，感兴趣的用户不是很多，但是一旦出现多用户并发查询或者版本操作的时候，这个东西就显得非常重要了，而且根据不同的用户场景设定不同的日志类型，对相关效率也是很有帮助的。注意：我们所说的ArcSDE日志文件表与经常提到的ArcSDE日志文件是不一样的，因为在ArcSDE创建库、启动服务、升级出现问题都会建议用户查
谈SDE服务无法接连解决方案
iteye_8029的博客
03-14 229
问题： 如果打开mxd文档，某些图层会失败，偶尔又会成功，使用catalog连接sde服务会出现"ORA-21561:OID generation failed的错误。sde日志有如下错误： MonMar 10 14:35:29 2014 - Process 8984, no shared information block established. MonMar 10 14:35:29 2...
oracle sde 用户过期问题解决
07-08
C:\Users\lenovo>sqlplus SQL*Plus: Release 11.2.0.1.0 Production on 星期日 7月 8 16:47:52 2012 Copyright (c) 1982, 2010,... 请输入用户名: sde/sde ERROR: ORA-28002: the password will expire within 7 days
SDE:各种SDE问题和解决方案的解决方案
03-16
SDE:各种SDE问题和解决方案的解决方案
解决OracleRAC集群下创建SDE时报Stored procedures错误问题.docx
03-18
解决OracleRAC集群下创建SDE时报Stored procedures错误问题 环境：Oracle11.2.0.3 两节点RAC集群，windows server2008R2，FCSAN共享存储，ArcGIS Desktop 1031
Arcgis连接 postgresql sde 时遇到的问题以及解决办法
12-16
6个dll的打包 Arcgis连接 postgresql sde 时遇到的问题以及解决办法 Arcgis连接 postgresql sde 时遇到的问题以及解决办法
SDE.rar_SDE
09-24
SQL2005的一个空间数据库搜索引擎 用来编写存储过程 和建立表格 表格在数据库中的表现形式是不可以直接看到内容的 需要这个软件来显示表格或者存储过程的实际意义
mysql更改执行计划_11g中 connect by 语句执行计划改变
weixin_28702613的博客
01-28 277
从10.2.0.3升级到11.2.0.4的朋友，如果细心会发现，以下sql在11.2.0.4中执行效率变低(该sql主要是获取连接用户获取权限信息)select privilege#,level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and priv...
连接用户获取权限信息
ckawt40802的专栏
09-25 550
有客户对AWR中报告中出现的一个查询GLOBAL_NAME的SQL存在疑问，详细分析后发现是客户端建立连接后获取权限信息的语句。 客户存在疑问的SQL是： select...
Oracle 应用短连接导致连接风暴
测试0901-1
12-26 1340
进一步对上一篇客户的环境进行排查，发现同步程序是以短连接的形式访问数据库，平均每秒70次的连接；通过在测试环境进行批量短连接测试，重现大量 select /*+ connect_by_filtering index(sysauth$ i_sysauth1) */ privilege#, bitand(nvl(option$, 0), 8), grante...
Android Qcom Display学习(四)
Android驱动开发
03-21 8891
DRM Linux DRM（二）基本概念和特性 DRM（Direct Rendering Manager）学习简介 DRM 的诞生就是用来处理多个程序对 Video Card 资源的协同使用问题，通过单单一个device node来控制所有硬件设备、通用访问硬件接口、通用内存管理机制。Framebuffer的架构它不能用于处理 基于视频卡的 GPU 的 3D 加速。 DRM从模块上划分，可以简单分为3部分：libdrm、KMS、GEM libdrm:对底层接口进行封装，向上层提供通用的API接口，主要是对各
统计每个url访问的topN用户以及访问次数(sql)
qq_40262372的博客
07-28 9004
一、题目如下 有一张表t1，假设有以下三个字段,代表某个userid在某一天访问了这个url： userid url event_day q1:20210725这一天每个url的pv／uv q2: 20210725这一天每个url访问的top10客户以及访问次数 输出：url, userid,pv，排名 q3: 20210725这一天的7日留存 表如下： 1.对于问题1 pv：每个url的总访问量 ...
【webrtc】websocket交换sdp实现ice链接
热门推荐
不忘初心，坚定道路！
12-14 4万+
前言 上一次进行了手动交换sdp成功进行了ice连接，但是正常情况下，不可能是让你手动交换，因为你能手动交换，说明你们之间已经有了传输通道，不然怎么获取对方的sdp。所以一般情况下，需要有个中间的服务器用来交换sdp，两个客户都通过中间服务器交换了sdp后实现ice连接。貌似这个过程的专业名词叫信令转发。 服务器搭建 首先初始化个npm项目，安装ws 起个ws到8001 const webSocket = require("ws"); const wss = new webSocket.Server
用户信息demo小结
Drama的博客
09-28 506
监听 RadioGroup监听 genderGroup.setOnCheckedChangeListener(new RadioGroup.OnCheckedChangeListener() { @Override public void onCheckedChanged(RadioGroup group, int checkedId) { // TOD
利用FORCE_MATCHING_SIGNATURE捕获非绑定变量SQL
weixin_33890526的博客
08-19 213
做为一个DBA，你大概习惯了定期要抓取数据库中的非绑定变量SQL，这些SQL经常扮演着一箱苹果中蛀虫的角色。看到下列SQL你必定觉得眼熟:SELECT substr(sql_text, 1, 80), count(1) FROM v$sql GROUP BY substr(sql_text, 1, 80) HAVING count(1) > 10 ORD...
sentaurus sde
最新发布
01-23
工艺模拟和优化则帮助工程师在制造过程中更好地理解和控制材料和工艺参数对器件性能的影响，从而优化电子产品的制造过程。电路仿真和验证则可以确保设计的电路在现实环境中能够正常工作，并满足指定的性能要求。 ...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值