Database is hung. Old and new user connections alike hang on
impact. What do you do? Your SYS SQLPLUS session IS able to
connect.
No Answer is Posted For this Question
Be the First to Post Answer
As a part of your job, what are the DBCC commands that you commonly use for database maintenance?
How will u copy the objects of one schema to another schema in datapump & export/import?
Explain the difference between a data block, an extent and a segment.
CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva
What is checkpoint?
what is a user-defined lock?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
What are the different sql server versions you have worked on? : sql server DBA
what are the performance views in an oracle rac environment?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?
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)