oracle--v$lock type字段详解

NameDescriptionADASM Disk AU LockAFAdvisor FrameworkAGAnalytic Workspace GenerationAKGES Deadlock TestAOMultiWriter Object AccessASService OperationsATAlter TablespaceAWAnalytic WorkspaceBRBackup/RestoreCFControlfile TransactionCICross-Instance Call InvocationCLLabel Security cacheCMASM Instance EnqueueCTBlock Change TrackingCUCursorDBDbsDriverDDASM Local Disk GroupDFDatafile Online in RACDGASM Disk Group ModificationDIGES InternalDLDirect Loader Index CreationDMDatabase Mount/OpenDNDiskgroup number generatorDPLDAP ParameterDQASM RBAL doorbellDRDistributed RecoveryDSDatabase SuspendDTDefault Temporary TablespaceDVDiana VersioningDXDistributed TransactionELibrary Cache Lock 2FAASM File Access LockFBFormat BlockFCDisk Group Chunk MountFDFlashback DatabaseFGACD Relocation Gate EnqueueFLFlashback database logFMFile MappingFRDisk Group RecoveryFSFile Set / Dictionary CheckFTDisk Group Redo GenerationFUDBFUSGLibrary Cache Pin 2HDASM Disk HeaderHPQueue PageHQHash QueueHVDirect Loader High Water MarkHWSegment High Water MarkIAInternalIDNIDILLabel SecurityIMKti blr lockIRInstance RecoveryISInstance StateITIn-Mem Temp Table Meta CreationIVLibrary Cache InvalidationIZINSTANCE LOCKJDJob Queue DateJIMaterialized ViewJQJob QueueJSJob SchedulerKKKick Instance to Switch LogsKMSchedulerKPKupp Process StartupKTScheduler PlanLLibrary Cache Lock 1MDMaterialized View Log DDLMHAQ Notification Mail HostMLAQ Notification Mail PortMNLogMinerMRMedia RecoveryMSMaterialized View Refresh LogMWMWIN ScheduleNLibrary Cache Pin 1OCOutline CacheOLOutline NameOQOLAPI HistoriesPDProperty LockPEParameterPFPassword FilePGGlobal ParameterPHAQ Notification ProxyPIRemote PX Process Spawn StatusPLTransportable TablespacePMASM PST SignallingPRProcess StartupPSPX Process ReservationPTASM Partnership and Status TablePVKSV slave startupPWBuffer Cache PreWarmQRow CacheRBASM Rollback RecoveryRFData Guard BrokerRMGES Resource RemasteringRNRedo Log Nab ComputationROMultiple Object ReuseRPResilver / RepairRSReclaimable SpaceRTRedo ThreadSBLogicalStandbySCSystem Change NumberSFAQ Notification SenderSHActive Session History FlushingSIStreams Table InstantiationSKShrink SegmentSMSMON SerializationSQSequence CacheSRSynchronized ReplicationSSSort SegmentSTSpace TransactionSUSaveUndo SegmentSVSequence OrderingSWSuspend WritesTAInstance UndoTBSQL Tuning Base Existence CacheTCTablespace CheckpointTDKTF map table enqueueTEKTF broadcastTFTemporary FileTLLog LockTMDMLTOTemp ObjectTQQueue table enqueueTSTemporary SegmentTTTablespaceTWCross-Instance TransactionTXTransactionULUser-definedUNUser NameUSUndo SegmentWAAQ Notification WatermarkWFAWR FlushWLBeing Written Redo LogWPAWR PurgeWSLogWriter StandbyXHAQ Notification No-ProxyXRQuiesce / Force LoggingXYInternal Test