Which dictionary tables and/or views would you look at to
diagnose a locking issue?
- 2 Answers
- 5358 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
how can you generate profile of pl/sql applications to identify performance bottlenecks?
Explain the use of setting GLOBAL_NAMES equal to TRUE.
Why would you use sql agent? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Why does Oracle not permit the use of PCTUSED with indexes?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What is replication? : sql server DBA
how will u see whether the dabase is in archive log mode or not?
What authentication modes does sql server support? : sql server DBA
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
what is the differnce between process and thread ?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
