ORA-14450: -- 续

前几天发生这个ORA 14450错误。通过查看v$lock里面有type。解决zhe'这个问题的时候，typesh是TO，

查询官方文档，没有发现TO这个类型。

https://docs.oracle.com/cd/E11882_01/server.112/e40402/dynviews_2027.htm#REFRN30121

Table 8-1 Values for the TYPE Column: System Types

System Type	Description	System Type	Description
AE	Edition enqueue	MR	Media recovery
AT	Lock held for the ALTER TABLEstatement	NA..NZ	Library cache pin instance (A..Z = namespace)
BL	Buffer hash table instance	PF	Password File
CF	Control file schema global enqueue	PI, PS	Parallel operation
CI	Cross-instance function invocation instance	PR	Process startup
CU	Cursor bind	QA..QZ	Row cache instance (A..Z = cache)
DF	datafile instance	RT	Redo thread global enqueue
DL	Direct loader parallel index create	SC	System change number instance
DM	Mount/startup db primary/secondary instance	SM	SMON
DR	Distributed recovery process	SN	Sequence number instance
DX	Distributed transaction entry	SQ	Sequence number enqueue
FS	File set	SS	Sort segment
HW	Space management operations on a specific segment	ST	Space transaction enqueue
IN	Instance number	SV	Sequence number value
IR	Instance recovery serialization global enqueue	TA	Generic enqueue
IS	Instance state	TS	Temporary segment enqueue (ID2=0)
IV	Library cache invalidation instance	TS	New block allocation enqueue (ID2=1)
JQ	Job queue	TT	Temporary table enqueue
KK	Thread kick	UN	User name
LA .. LP	Library cache lock instance lock (A..P = namespace)	US	Undo segment DDL
MM	Mount definition global enqueue	WL	Being-written redo log instance

今天看官方文档Oracle Database Reference，里面发现有这个TO的解释。

https://docs.oracle.com/cd/E11882_01/server.112/e40402/enqueues.htm#REFRN102

The Oracle enqueues are:

• BL, Buffer Cache Management

• BR, Backup/Restore

• CF, Controlfile Transaction

• CI, Cross-instance Call Invocation

• CU, Bind Enqueue

• DF, Datafile

• DL, Direct Loader Index Creation

• DM, Database Mount

• DR, Distributed Recovery Process

• DW, SecureFiles

• DX, Distributed Transaction

• FP, File Object

• FS, File Set

• HW, High-Water Lock

• IN, Instance Number

• IR, Instance Recovery

• IS, Instance State

• IV, Library Cache Invalidation

• JI, Enqueue used during AJV snapshot refresh

• JQ, Job Queue

• KK, Redo Log "Kick"

• KP, contention in Oracle Data Pump startup and shutdown processes

• KO, Multiple Object Checkpoint

• L[A-P], Library Cache Lock

• LS, Log Start or Switch

• MM, Mount Definition

• MR, Media Recovery

• N[A-Z], Library Cache Pin

• PE, ALTER SYSTEM SET PARAMETER = VALUE

• PF, Password File

• PI, Parallel Slaves

• PR, Process Startup

• PS, Parallel Slave Synchronization

• Q[A-Z], Row Cache

• RO, Object Reuse

• RT, Redo Thread

• RW, Row Wait

• SC, System Commit Number

• SM, SMON

• SN, Sequence Number

• SQ, Sequence Number Enqueue

• SR, Synchronized Replication

• SS, Sort Segment

• ST, Space Management Transaction

• SV, Sequence Number Value

• TA, Transaction Recovery

• TC, Thread Checkpoint

• TE, Extend Table

• TM, DML Enqueue

• TO, Temporary Table Object Enqueue

• TS, Temporary Segment (also TableSpace)

• TT, Temporary Table

• TX, Transaction

• UL, User-defined Locks

• UN, User Name

• US, Undo Segment, Serialization

• WL, Being Written Redo Log

• XA, Instance Attribute Lock

• XI, Instance Registration Lock

• ZA, Exclusive Lock When Moving Audit Table

 

END。