Which dictionary tables and/or views would you look at to
diagnose a locking issue?
Answer Posted / braj123
sys.v$lock
v$locked_object
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
Explain about your sql server dba experience? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
How to start SQL Server in minimal configuration mode?
What are the operating modes in which database mirroring runs? : sql server DBA
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
What is a correlated sub-query? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
how can you create a user-defined lock?
what do you understand by flashback feature of oracle?
What are statistics, under what circumstances they go out of date, how do you update them?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
how does an oracle clusterware manage crs resources?