oracle 22835解决,SYS_AUTO_SQL_TUNING_TASK的job跑失败，连接2天失效了。<结贴>

$ cat  /u01/app/oracle/diag/rdbms/yongbing/YONGBING/trace/YONGBING_j004_18678.trc

Trace file /u01/app/oracle/diag/rdbms/yongbing/YONGBING/trace/YONGBING_j004_18678.trc

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1

System name:     Linux

Node name:     dbserver2

Release:     2.6.18-238.19.1.el5xen

Version:     #1 SMP Fri Jul 15 08:16:59 EDT 2011

Machine:     x86_64

VM name:     Xen Version: 3.1 (PVM)

Instance name: YONGBING

Redo thread mounted by this instance: 1

Oracle process number: 95

Unix process pid: 18678, image: oracle@dbserver2 (J004)

*** 2012-12-05 22:00:31.151

*** SESSION ID:(1397.63227) 2012-12-05 22:00:31.151

*** CLIENT ID:() 2012-12-05 22:00:31.151

*** SERVICE NAME:(SYS$USERS) 2012-12-05 22:00:31.151

*** MODULE NAME:(DBMS_SCHEDULER) 2012-12-05 22:00:31.151

*** ACTION NAME:(ORA$AT_SQ_SQL_SW_14823) 2012-12-05 22:00:31.151

status=(pst=ERROR)

error: pos=0, message follows:

kestsDumpMsg(): dump message

msg=(@=0x2ad7126cc3d8, fac=ORA, cod=16960, p1=ORA-16960: SQL Analyze could not reproduce the desired plan.)

*** 2012-12-05 22:14:23.599

status=(pst=SUCCESS)

**************************************************************

Execution Statistics

Exec count:         1

CR gets:            477607

CU gets:            0

Disk Reads:         409893

Disk Writes:        0

IO Read Requests:   35590

IO Write Requests:  0

Bytes Read:         3357843456

Bytes Written:      0

Bytes Exchanged with Storage:  3357843456

Bytes Exchanged with Disk:  3357843456

Bytes Simulated Read:  0

Bytes Simulated Returned:  0

Elapsed Time: 13 (s)

CPU Time: 3236 (ms)

User I/O Time: 9327 (ms)

status=(pst=ERROR)

status=(pst=SUCCESS)

**************************************************************

Execution Statistics

Exec count:         1

CR gets:            393109

CU gets:            0

Disk Reads:         8368

Disk Writes:        0

IO Read Requests:   8351

IO Write Requests:  0

Bytes Read:         68550656

Bytes Written:      0

Bytes Exchanged with Storage:  68550656

Bytes Exchanged with Disk:  68550656

Bytes Simulated Read:  0

Bytes Simulated Returned:  0

Elapsed Time: 7245 (ms)

CPU Time: 2116 (ms)

User I/O Time: 4847 (ms)

*** 2012-12-05 22:14:43.598

status=(pst=SUCCESS)

**************************************************************

Execution Statistics

Exec count:         1

CR gets:            2305

CU gets:            0

Disk Reads:         0

Disk Writes:        0

IO Read Requests:   0

IO Write Requests:  0

Bytes Read:         0

Bytes Written:      0

Bytes Exchanged with Storage:  0

Bytes Exchanged with Disk:  0

Bytes Simulated Read:  0

Bytes Simulated Returned:  0

Elapsed Time: 8831 (us)

CPU Time: 6800 (us)

User I/O Time: 0 (us)

status=(pst=SUCCESS)

*** 2012-12-05 22:16:08.786

**************************************************************

Execution Statistics

Exec count:         1

CR gets:            76936

CU gets:            2

Disk Reads:         587

Disk Writes:        0

IO Read Requests:   587

IO Write Requests:  0

Bytes Read:         4808704

Bytes Written:      0

Bytes Exchanged with Storage:  4808704

Bytes Exchanged with Disk:  4808704

Bytes Simulated Read:  0

Bytes Simulated Returned:  0

Elapsed Time: 3047 (ms)

CPU Time: 224 (ms)

User I/O Time: 2678 (ms)

status=(pst=ERROR)

status=(pst=SUCCESS)

**************************************************************

Execution Statistics

Exec count:         1

CR gets:            10984

CU gets:            2

Disk Reads:         509

Disk Writes:        0

IO Read Requests:   504

IO Write Requests:  0

Bytes Read:         4169728

Bytes Written:      0

Bytes Exchanged with Storage:  4169728

Bytes Exchanged with Disk:  4169728

Bytes Simulated Read:  0

Bytes Simulated Returned:  0

Elapsed Time: 154 (ms)

CPU Time: 139 (ms)

User I/O Time: 14 (ms)

*** 2012-12-05 22:17:24.011

status=(pst=SUCCESS)

**************************************************************

Execution Statistics

Exec count:         1

CR gets:            100734

CU gets:            0

Disk Reads:         90330

Disk Writes:        0

IO Read Requests:   1838

IO Write Requests:  0

Bytes Read:         739983360

Bytes Written:      0

Bytes Exchanged with Storage:  739983360

Bytes Exchanged with Disk:  739983360

Bytes Simulated Read:  0

Bytes Simulated Returned:  0

Elapsed Time: 6862 (ms)

CPU Time: 1068 (ms)

User I/O Time: 5197 (ms)

*** 2012-12-05 22:17:32.235

ORA-12012: error on auto execute of job "SYS"."ORA$AT_SQ_SQL_SW_14823"

ORA-01461: can bind a LONG value only for insert into a LONG column

ORA-06512: at "SYS.PRVT_ADVISOR", line 2735

ORA-06512: at "SYS.DBMS_ADVISOR", line 241

ORA-06512: at "SYS.DBMS_SQLTUNE", line 821

ORA-06512: at line 4