SQL to check active users connect MS_SQL database

SQL to check active users connect MS_SQL database
=======================================

SELECT  @@Servername AS Server ,
        DB_NAME(database_id) AS DatabaseName ,
        COUNT(database_id) AS Connections ,
        Login_name AS LoginName ,
        MIN(Login_Time) AS Login_Time ,
        MIN(COALESCE(last_request_end_time, last_request_start_time))
                                                         AS Last_Batch
FROM    sys.dm_exec_sessions
WHERE   database_id > 0
        AND DB_NAME(database_id) NOT IN ( 'master', 'msdb' )
GROUP BY database_id ,
         login_name
ORDER BY DatabaseName;

How to check Authentication mode of SQL server

How to check Authentication mode of SQL server ( SQL Server /Windows Authentication (or) both)
=========================================

Use Master
GO

SELECT
            CASE SERVERPROPERTY('IsIntegratedSecurityOnly')
            WHEN 0 THEN 'Mixed Mode - Allows Both SQL Server and Windows Authentication Mode'
            WHEN 1 THEN 'Allows Only Windows Authentication Mode'
END AS [Currently Used SQL Server Authentication Mode]
GO

How to check trans log backup details in ms-sql

how to check trans log backup details in ms-sql
=====================================

SELECT   d.name,
         MAX(b.backup_finish_date) AS backup_finish_date
FROM     master.sys.sysdatabases d
         LEFT OUTER JOIN msdb..backupset b
         ON       b.database_name = d.name
         AND      b.type          = 'L'
GROUP BY d.name
ORDER BY backup_finish_date DESC

ms-sql backup start time and finish time to check

===========================================
BACKUP START TIME AND FINISH TIME
===========================================


DECLARE @dbname sysname
SET @dbname = NULL --set this to be whatever dbname you want
SELECT bup.user_name AS [User],
 bup.database_name AS [Database],
 bup.server_name AS [Server],
 bup.backup_start_date AS [Backup Started],
 bup.backup_finish_date AS [Backup Finished]
 ,CAST((CAST(DATEDIFF(s, bup.backup_start_date, bup.backup_finish_date) AS int))/3600 AS varchar) + ' hours, '
 + CAST((CAST(DATEDIFF(s, bup.backup_start_date, bup.backup_finish_date) AS int))/60 AS varchar)+ ' minutes, '
 + CAST((CAST(DATEDIFF(s, bup.backup_start_date, bup.backup_finish_date) AS int))%60 AS varchar)+ ' seconds'
 AS [Total Time]
FROM msdb.dbo.backupset bup
WHERE bup.backup_set_id IN
  (SELECT MAX(backup_set_id) FROM msdb.dbo.backupset
  WHERE database_name = ISNULL(@dbname, database_name) --if no dbname, then return all
  AND type = 'D' --only interested in the time of last full backup
  GROUP BY database_name)
/* COMMENT THE NEXT LINE IF YOU WANT ALL BACKUP HISTORY */
AND bup.database_name IN (SELECT name FROM master.dbo.sysdatabases)
ORDER BY bup.database_name

MS-sql database back up check.

MS-sql database back up check.
==========================


--------------------------------------------------------------
Most Recent Database Backup for Each Database
---------------------------------------------------------------
SELECT
   CONVERT(CHAR(100), SERVERPROPERTY('Servername')) AS Server,
   msdb.dbo.backupset.database_name,
   MAX(msdb.dbo.backupset.backup_finish_date) AS last_db_backup_date
FROM   msdb.dbo.backupmediafamily
   INNER JOIN msdb.dbo.backupset ON msdb.dbo.backupmediafamily.media_set_id = msdb.dbo.backupset.media_set_id
WHERE  msdb..backupset.type = 'D'
GROUP BY
   msdb.dbo.backupset.database_name
ORDER BY
   msdb.dbo.backupset.database_name
 


----------------------------------------------------------------------------------
Most Recent Database Backup for Each Database  in detailed view
-----------------------------------------------------------------------------------


SELECT
   A.[Server],
   A.last_db_backup_date,
   B.backup_start_date,
   B.expiration_date,
   B.backup_size,
   B.logical_device_name,
   B.physical_device_name, 
   B.backupset_name,
   B.description
FROM
   (
   SELECT 
       CONVERT(CHAR(100), SERVERPROPERTY('Servername')) AS Server,
       msdb.dbo.backupset.database_name,
       MAX(msdb.dbo.backupset.backup_finish_date) AS last_db_backup_date
   FROM    msdb.dbo.backupmediafamily
       INNER JOIN msdb.dbo.backupset ON msdb.dbo.backupmediafamily.media_set_id = msdb.dbo.backupset.media_set_id
   WHERE   msdb..backupset.type = 'D'
   GROUP BY
       msdb.dbo.backupset.database_name
   ) AS A
 
   LEFT JOIN

   (
   SELECT 
   CONVERT(CHAR(100), SERVERPROPERTY('Servername')) AS Server,
   msdb.dbo.backupset.database_name,
   msdb.dbo.backupset.backup_start_date,
   msdb.dbo.backupset.backup_finish_date,
   msdb.dbo.backupset.expiration_date,
   msdb.dbo.backupset.backup_size,
   msdb.dbo.backupmediafamily.logical_device_name,
   msdb.dbo.backupmediafamily.physical_device_name, 
   msdb.dbo.backupset.name AS backupset_name,
   msdb.dbo.backupset.description
FROM   msdb.dbo.backupmediafamily
   INNER JOIN msdb.dbo.backupset ON msdb.dbo.backupmediafamily.media_set_id = msdb.dbo.backupset.media_set_id
WHERE  msdb..backupset.type = 'D'
   ) AS B
   ON A.[server] = B.[server] AND A.[database_name] = B.[database_name] AND A.[last_db_backup_date] = B.[backup_finish_date]
ORDER BY
   A.database_name



===========================================

To check ms-sql db recovery model type

select [name], DATABASEPROPERTYEX([name],'recovery')
from sysdatabases
where name not in ('master','model','tempdb','msdb')

Ms-sql db sizes for all check script

Ms-sql db sizes check script
===============================

SELECT
    D.name,
    F.Name AS FileType,
    F.physical_name AS PhysicalFile,
    F.state_desc AS OnlineStatus,
    CAST((F.size*8)/1024 AS VARCHAR(26)) + ' MB' AS FileSize,
    CAST(F.size*8 AS VARCHAR(32)) + ' Bytes' as SizeInBytes
FROM
    sys.master_files F
    INNER JOIN sys.databases D ON D.database_id = F.database_id
ORDER BY
    D.name

SQL server error log location check from database.

How to find SQL server error log location check
===========================================

USE MASTER
GO
EXEC xp_readerrorlog 0, 1, N'Logging SQL Server messages in file'
GO

MS-SQL Database File Location

How to find MS-SQL Database File Location :-
==============================

EXEC sp_Helpfile;

(or)

--  run under particular db for file location.

SELECT  @@Servername AS Server ,
        DB_NAME() AS DB_Name ,
        File_id ,
        Type_desc ,
        Name ,
        LEFT(Physical_Name, 1) AS Drive ,
        Physical_Name ,
        RIGHT(physical_name, 3) AS Ext ,
        Size ,
        Growth
FROM    sys.database_files
ORDER BY File_id;
GO

how to check MS-SQL Edition.

how to check  Edition.
=================

select serverproperty('Edition')

All locks and their definition in database

 All locks and their definition in database
========================================
by using below ssql you get same out put.
-------------------------------------------------------------------------

SELECT TYPE, name, description
  FROM v$lock_type
 ORDER BY TYPE; 

-------------------------------------------------------

output:-

TYPE	NAME	DESCRIPTION
AB	Auto BMR	A general class of locks used by auto BMR for various purposes
AC	Application Continuity	Synchronizes new service activation
AD	ASM Disk AU Lock	Synchronizes accesses to a specific ASM disk AU
AE	Edition Lock	Prevent Dropping an edition in use
AF	Advisor Framework	This enqueue is used to serialize access to an advisor task
AG	Analytic Workspace Generation	Synchronizes generation use of a particular workspace
AH	ASM Relocation Lock High	Protects locked extent pointers during ASM file relocation
AK	GES Deadlock Test	Lock used for internal testing
AM	ASM Enqueue	ASM instance general-purpose enqueue
AO	MultiWriter Object Access	Synchronizes access to objects and scalar variables
AP	SPM Autopurge	This enqueue is used to serialize the purging of SQL plan baselines
AQ	Queue Partitioning local enqueue	Synchronizes partition operations on queue table within instance
AR	ASM Relocation Lock	Protects locked extent pointers during ASM file relocation
AS	Service Operations	Synchronizes new service activation
AT	Alter Tablespace	Serializes 'alter tablespace' operations
AV	ASM volume locks	id1 is for persistent DG number locking. id2 is for other volume serialization
AW	Analytic Workspace	Synchronizes access to Analytic Workspace resources
AY	KSXA Test Affinity Dictionary	Affinity Dictionary test affinity synchronization
BA	non durable sub bmap alloc	Synchronizes access to globl Bitmap Alloc
BB	Global Transaction Branch	2PC distributed transaction branch across RAC instances
BC	BA Container	Backup Appliance Container
BF	BLOOM FILTER	Synchronize access to a bloom filter in a parallel statement
BI	BA Contained File Identification	Backup Appliance Contained File Identification
BM	clonedb bitmap file access	synchronizes clonedb bitmap file operations
BO	DRM Banned-Object List	Coordinates dynamic remastering banned-object list
BR	Backup/Restore	Lock held by a backup/restore operation to allow other operations to wait for it
BS	Backup/Restore spare enq	KRB space usage
BV	BA Group Rebuild/Validate	Backup Appliance Container Rebuild/Validate
BZ	BA Contained File Resize	Backup Appliance Contained File Resize
CA	Calibration	Lock used by IO Calibration
CB	CBAC Master Lock	Synchronizes accesses to the CBAC roles cached in KGL
CC	Column Key	Serializes Column Encryption Key Cache
CF	Controlfile Transaction	Synchronizes accesses to the controlfile
CI	Cross-Instance Call Invocation	Coordinates cross-instance function invocations
CL	Label Security cache	Synchronizes accesses to label cache and label tables
CM	ASM Instance Enqueue	ASM instance and gate enqueue
CN	KTCN REG enq	Enqueue held for registrations for change notifications
CO	KTUCLO Master Slave enq	Enqueue held for determining Master Slaves
CP	Pluggable Database	Coordinate pluggable database operations
CQ	Cleanup querycache registrations	Serializes access to cleanup client query cache registrations
CR	Reuse Block Range	Coordinates checkpointing of block range reuse
CT	Block Change Tracking	A general class of locks used by change tracking for various purposes
CU	Cursor	Recovers cursors in case of death while compiling
CX	TEXT: Index Specific Lock	Index Specific Lock on CTX index
DB	DbsDriver	Synchronizes modification of database wide supplementallogging attributes
DD	ASM Local Disk Group	Synchronizes local accesses to ASM disk groups
DF	Datafile Online in RAC	Enqueue held by foreground or DBWR when a datafile is brought online in RAC
DG	ASM Disk Group Modification	Synchronizes accesses to ASM disk groups
DI	GES Internal	Coordinates Global Enqueue Service deadlock detection
DL	Direct Loader Index Creation	Lock to prevent index DDL during direct load
DM	Database Mount/Open	Enqueue held by foreground or DBWR to synchronize database mount/open or pluggable database open with other operations
DN	Diskgroup number generator	Serializes Group number generations
DO	ASM Disk Online Lock	Synchronizes disk onlines and their recovery
DP	LDAP Parameter	Synchronizes access to LDAP parameters
DQ	ASM RBAL doorbell	Inter-RBAL process metadata invalidation notification
DR	Distributed Recovery	Serializes the active distributed recovery operation
DS	Database Suspend	Prevents a database suspend during LMON reconfiguration
DT	Default Temporary Tablespace	Serializes changing the default temporary table space and user creation
DV	Diana Versioning	Synchronizes access to lower-version Diana (PL/SQL intermediate representation)
DW	In memory Dispenser	Serialize in memory dispenser operations
DX	Distributed Transaction	Serializes tightly coupled distributed transaction branches
E	Library Cache Lock 2	Synchronizes accesses to library cache objects
FA	ASM File Access Lock	Synchronizes accesses to open ASM files
FB	Format Block	Ensures that only one process can format data blocks in auto segment space managed tablespaces
FC	Disk Group Chunk Mount	controls access to an ACD chunk
FD	Flashback Database	Coordinate flashback database
FE	KTFA Recovery	Flashback archive Enqueue to serialize recovery
FG	ACD Relocation Gate Enqueue	ACD relocation serialization
FH	Flush Stat	Serializes flush of ILM stats to disk
FL	Flashback database log	Synchronize access to flashback database log
FM	File Mapping	Synchronizes access to global file mapping state
FO	Oracle File System Operation	Synchronize Oracle File System Operations
FP	File Object	Synchronizes various File Object(FOB) operations
FR	Disk Group Recovery	enqueue to control ASM recovery
FS	File Set / Dictionary Check	Enqueue used to synchronize recovery and file operations or synchronize dictionary check
FT	Disk Group Redo Generation	controls the privilege to generate redo in a thread
FU	DBFUS	This enqueue is used to serialize the capture of the DB Feature           Usage and High Water Mark Statistics
FW	Flashback Writer	Coordinate RVWR on multiple instances
FX	ACD Xtnt Info CIC	serialize ACD relocation CIC
FZ	ASM Freezing Cache Lock	Freezes ASM Cache for a diskgroup
G	Library Cache Pin 2	Synchronizes accesses to the contents of library cache objects
HC	HSM cache	Add or Remove from HSM cache
HD	ASM Disk Header	Serializes accesses to ASM SGA data structures
HM	Hang Manager Test Resource	Resource to Generate Hangs for Hang Manager Testing
HP	Queue Page	Synchronizes accesses to queue pages
HQ	Hash Queue	Synchronizes the creation of new queue IDs
HV	Direct Loader High Water Mark	Lock used to broker the high water mark during parallel inserts
HW	Segment High Water Mark	Lock used to broker the high water mark during parallel inserts
IA	Internal
IC	IOServer Client	Gets a unique client ID
ID	NID	Lock held by a NID operation to allow other operations to wait for it
IF	IOServer File	Synchronizes file operations
IL	Label Security	Synchronizes accesses to internal label data structures
IM	Kti blr lock	Serializes block recovery for an IMU txn
IN	in-memory segment	Serialize in-memory segment create/drop
IP	PDB Instance State	Enqueue used to synchronize instance state changes for PDBs
IR	Instance Recovery	Synchronizes instance recovery
IS	Instance State	Enqueue used to synchronize instance state changes
IT	In-Mem Temp Table Meta Creation	Synchronizes accesses to a temp object's metadata
IV	Library Cache Invalidation	Synchronizes library cache object invalidations across instances
IZ	INSTANCE LOCK	Proctects the lock name space used by the instance
JD	Job Queue Date	Synchronizes dates between job queue coordinator and slave processes
JI	Materialized View	Lock held during materialized view operations (like refresh, alter) to prevent concurrent operations on the same materialized view
JQ	Job Queue	Lock to prevent multiple instances from running a single job
JS	Job Scheduler	Synchronizes accesses to the job cache
JX	SQL STATEMENT QUEUE	synchronize SQL statement queue operations
KD	Scheduler Master DBRM	Determine DBRM master
KE	ASM Cached Attributes	Synchronization of ASM cached attributes
KI	KJCI Serialization Enqueue	Enqueue to Serialize KJCI Cross-Instance Calls
KK	Kick Instance to Switch Logs	Lock held by open redo thread, used by other instances to force a log switch
KL	LOB KSI LOCK	KSI lock for buffer cache and wgc concurrency
KM	Scheduler	Synchronizes various Resource Manager operations
KO	Multiple Object Checkpoint	Coordinates checkpointing of multiple objects
KP	Kupp Process Startup	Synchronizes kupp process startup
KQ	ASM Attributes Enque	Single Inst Sync of ASM attributes
KT	Scheduler Plan	Synchronizes accesses to the current Resource Manager plan
KV	KEY VECTOR	Synchronizes access to a key vector in a parallel statement
KZ	ASM:Purge Audit	Coordinate GEN0 on multiple instances
L	Library Cache Lock 1	Synchronizes accesses to library cache objects
MC	SGA Log Operation	Lock held during dml/ddl for a securefile log
MD	Materialized View Log DDL	Lock held during materialized view log DDL statements
MF	SGA Log-Bkt Flush	Lock held during flushing a log bucket
MH	AQ Notification Mail Host	Lock used for recovery when setting Mail Host for AQ e-mail notifications
MK	Master Key	Serializes enc$ access
ML	AQ Notification Mail Port	Lock used for recovery when setting Mail Port for AQ e-mail notifications
MN	LogMiner	Synchronizes updates to the LogMiner dictionary and prevents multiple instances from preparing the same LogMiner session
MO	MMON restricted session	Serialize MMON operations for restricted sessions
MP	SGA Log Partition	Lock held during partitioning an instance log
MR	Media Recovery	Lock used to coordinate media recovery with other uses of datafiles
MS	Materialized View Refresh Log	Lock held during materialized view refresh to setup MV log
MV	Online Datafile Move	Synchronizes online datafile move operation or cleanup
MW	MWIN Schedule	This enqueue is used to serialize the calibration of the           manageability schedules with the Maintenance Window
MX	ksz synch	Used to synchronize storage server info across all nodes
N	Library Cache Pin 1	Synchronizes accesses to the contents of library cache objects
OC	Outline Cache	Synchronizes write accesses to the outline cache
OD	Online DDLs	Lock to prevent concurrent online DDLs
OE	DLM Enqueue Owner Serialization	Enqueue to serialize access to an Omni Enqueue Owner
OL	Outline Name	Synchronizes accesses to a particular outline name
OP	Label Security Profile	Synchronizes access to the ols$profile table
OQ	OLAPI Histories	Synchronizes access to olapi history resources
OT	TEXT: Generic Lock	Generic Lock on CTX index
OW	Encryption Wallet	Serializes wallet initialization and access
PA	Privilege Capture API	Lock held for modifying or reading a privilege capture
PB	PDB DDL Operations	Enqueue used to synchronize PDB DDL operations
PC	Enqueue for kzppctxs	Lock used for accesing kzppctx in SGA
PD	Property Lock	Serializes property update
PE	Parameter	Synchronizes system parameter updates
PF	Password File	Synchronizes accesses to the password file
PG	Global Parameter	Synchronizes global system parameter updates
PH	AQ Notification Proxy	Lock used for recovery when setting Proxy for AQ HTTP notifications
PI	Remote PX Process Spawn Status	Communicates remote Parallel Execution Server Process creation status
PL	Transportable Tablespace	Coordinates plug-in operation of transportable tablespaces
PM	ASM PST Signalling	Signals inter-instance access to ASM PST metadata
PP	GES Plug and Play Enqueue	Coordinates Adding Plug and Play Instances
PQ	Queue Ptning global enq	Synchronizes partitioning operations on queue table accross instances
PR	Process Startup	Synchronizes process startup
PS	PX Process Reservation	Parallel Execution Server Process reservation and synchronization
PT	ASM Partnership and Status Table	Gates inter-node synchronization of ASM PST metadata
PV	KSV slave startup	Synchronizes slave start_shut
PW	Buffer Cache PreWarm	Coordinates Direct Loads with Prewarmed cache buffers
PY	AVM RTA Access	Coordinate RTA info access on AVM
Q	Row Cache	Coordinates updates and accesses to row cache objects
RA	Real-Time ADDM Flood Control	Coordinate Flood Control in RAC
RB	ASM Rollback Recovery	Serializes ASM rollback recovery operations
RC	Result Cache: Enqueue	Accessing a result in the result-set cache
RD	RAC Load	synchronize update of RAC load info
RE	Block Repair/Resilvering	Synchronizes block repair/mirror resilvering operations
RF	Data Guard Broker	Synchronizes broker lock operation involving lock value
RK	wallet_set_mkey	Serializes wallet master key rekey
RL	RAC Encryption Wallet Lock	RAC encryption wallet lock
RM	GES Resource Remastering	Coordinates Global Enqueue Service resource remastering
RN	Redo Log Nab Computation	Coordinates nab computations of online logs during recovery
RO	Multiple Object Reuse	Coordinates flushing of multiple objects
RP	Resilver / Repair	Enqueue held when resilvering is needed or when datablock is repaired from mirror
RQ	Enqueue-Cross SCN	Synchronize enqueue-dequeue-cross on SCN generation
RR	Workload Capture and Replay	Prevents concurrent invokers of DBMS_WORKLOAD_*
RS	Reclaimable Space	Lock held by a space reclaimable operation to allow other operations to wait for it
RT	Redo Thread	Thread locks held by LGWR, DBW0, and RVWR to indicate mounted or open status
RU	Rolling Migration	Serilized rolling migration operations
RW	Materialized View Flags	Lock used when creating or readingmaterialized view flags in detail tables
RX	ASM Extent Relocation Lock	Synchronizes relocating ASM extents
RZ	RFS Logminer FLC	Synchronizes updates to logminer foreign log cache
SB	LogicalStandby	Synchronizes Logical Standby metadata operations
SC	System Change Number	Coordinates system change number generation on multiple instances
SE	Session Migration	Lock used by transparent session migration
SF	AQ Notification Sender	Lock used for recovery when setting Sender for AQ e-mail notifications
SG	OLS groups	Synchronizes access to ols$groups table
SH	Active Session History Flushing	To prevent multiple concurrent flushers
SI	Streams Table Instantiation	Prevents muiltiple streams table instantiations
SJ	KTSJ Slave Task Cancel	Serializes cancelling task executed by slave process
SK	Shrink Segment	Serialize shrink of a segment
SL	Serialize Lock request	Request serialization to LCK0
SM	SMON Serialization	Lock to check SMON global work in RAC
SO	Shared Object	Synchronizes access to Shared Object(PL/SQL Shared Object Manager)
SP	Spare Enqueue 0	Spare enqueue 0 for one-off backports
SQ	Sequence Cache	Lock to ensure that only one process can replenish the sequence cache
SR	Synchronized Replication	Coordinates replication / streams operations
SS	Sort Segment	Ensures that sort segments created during parallel DML operations aren't prematurely cleaned up
ST	Space Transaction	Synchronizes space management activities in dictionary-managed tablespaces
SU	SaveUndo Segment	Serializes access to SaveUndo Segment
SV	Sequence Ordering	Lock to ensure ordered sequence allocation in RAC mode
SW	Suspend Writes	Coordinates the 'alter system suspend' operation
SX	Spare Enqueue 1	Spare enqueue 1 for one-off backports
SY	IM chunk populate	Lock used to serialize in-memory chunk populates
SZ	IM segment populate	Lock used to serialize in-memory segment populates
TA	Instance Undo	Serializes operations on undo segments and undo tablespaces
TB	SQL Tuning Base Existence Cache	Synchronizes writes to the SQL Tuning Base Existence Cache
TC	Tablespace Checkpoint	Lock held to guarantee uniqueness of a tablespace checkpoint
TD	KTF map table enqueue	Serializes updates and inserts to the SMON_SCN_TIME mapping table
TE	KTF broadcast	Serializes broadcasts for flushes to SMON_SCN_TIME
TF	Temporary File	Serializes dropping of a temporary file
TH	Threshold Chain	Serializes threshold in-memory chain access
TK	Auto Task Serialization	Prevents more than one AutoTask Background Slave from being spawned
TL	Log Lock	Serializes threshold log table read and update
TM	DML	Synchronizes accesses to an object
TO	Temp Object	Synchronizes DDL and DML operations on a temp object
TP	Runtime Fixed Table Purge	Lock used for fixed runtime table purge and definition
TQ	Queue table enqueue	Synchronizes access to queue table
TS	Temporary Segment	Serializes accesses to temp segments
TT	Tablespace	Serializes DDL operations on tablespaces
TW	Cross-Instance Transaction	Lock held by one instance to wait for transactions on all instances to finish
TX	Transaction	Lock held by a transaction to allow other transactions to wait for it
TZ	in-memory	Serialize in-memory area create/drop
UL	User-defined	Lock used by user applications
US	Undo Segment	Lock held to perform DDL on the undo segment
V	Library Cache Lock 3	Synchronizes accesses to library cache objects
WA	AQ Notification Watermark	Lock used for recovery when setting Watermark for memory usage in AQ notifications
WF	AWR Flush	This enqueue is used to serialize the flushing of snapshots
WG	Write gather local enqueue	Long term lock on wgc file state
WL	Being Written Redo Log	Coordinates access to redo log files and archive logs
WM	WLM Plan Operations	Synchronizes new WLM Plan activation
WP	AWR Purge	This enqueue handles concurrency between purging and baselines
WR	LNS archiving log	Coordinates access to logs by Async LNS and ARCH/FG
WS	LogWriter Standby	Used by LogWriter to coordinate communication to standby databases
WT	AWR CDB-Wide Table Lock	This enqueue serializes CDB-Wide Operation on AWR Table
XB	ASM Group Block lock	Prevents client diskgroup use during storage reconfiguration
XC	XDB Configuration	Synchronization access to XDB configuration
XD	Auto Online Exadata disks	Serialize Auto Management of Exadata disks
XH	AQ Notification No-Proxy	Lock used for recovery when setting No Proxy Domains for AQ HTTP notifications
XK	GES Test-Lock for KSIRESTXDV	Lock used for internal testing
XL	ASM Extent Fault Lock	Keep multiple processes from faulting in the same extent chunk
XM	ASM RM Master Lock	RMON which process this lock is the Master
XQ	ASM Extent Relocation Enqueue	ASM extent relocation
XR	Quiesce / Force Logging	Lock held during database quiesce or for database force logging
XY	Internal Test	Lock used for internal testing
Y	Library Cache Pin 3	Synchronizes accesses to the contents of library cache objects
ZA	Audit Partition	Lock held for adding partition to Aud table
ZB	in-memory TS	Serialize in-memory tablespace create/drop
ZC	IM FastStart Seg	Lock used to serialize in-memory FS seg
ZD	IM FastStart CU	Lock used to serialize in-memory FS CU
ZF	FGA Partition	Lock held for adding partition to Fga table
ZG	File Group	Coordinates file group operations
ZH	Compression Analyzer	Synchronizes analysis and insert into compression$, prevents multiple threads analyzing the same table during a load
ZS	Spillover Audit files	Lock held for exclusive access on a Spillover audit file
ZX	repopulation file access	synchronizes file operations during repopulation
ZZ	Global Context Action	Lock held for updating Global context hash tables

Grant READ vs SELECT in oracle 12c new

Grant READ vs SELECT in oracle 12C
========================================

From oracle 12c has introduced new privilege  "READ" it will be little different than select.

The main difference b/w select and read are. select privilege will allow user can lock table rows, Read privilege does not allow to lock.

example:-

SQL> GRANT SELECT ANY TABLE TO <schema_name>;

Grant succeeded.

SQL> GRANT READ ANY TABLE TO <schema_name>;

Grant succeeded.

grant for particular object.


SQL> GRANT SELECT ON <schema_name.Object_name> TO <schema_name>;


Grant succeeded.

SQL> GRANT READ ON  <schema_name.Object_name> TO <schema_name>;

Grant succeeded.

Thanks for your visit!
your comment and suggestions are more helpful in my future posts more effective.