Which dictionary tables and/or views would you look at to
diagnose a locking issue?
Answers were Sorted based on User's Feedback
who owns the operating system files created by the utl_file package?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What is database replicaion? What are the different types of replication you can set up in SQL Server?
Name a tablespace automatically created when you create a database.
Explain the concept of the DUAL table.
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What view would you use to look at the size of a data file?
What are the different sql server versions you have worked on? : sql server DBA
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
what is incremental checkpoint?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)