Oracle General (1803)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)
Oracle Security (38)
Oracle Forms Reports (510)
Oracle Data Integrator (ODI) (120)
Oracle ETL (15)
Oracle RAC (93)
Oracle D2K (72)
Oracle AllOther (241) Users get the following error: ora-00055 maximum number of dml locks exceeded? What is the problem and how do you fix it?
570Explain dual table. Is any data internally stored in dual table. Lot of users is accessing select sysdate from dual and they getting some millisecond differences. If we execute select sysdate from emp; what error will we get. Why?
621If you see the value for reloads is high in the estat library cache report is this a matter for concern?
677If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)
622using hot backup without being in archive log mode, can you recover in the event of a failure? Why or why not?
1 1083What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?
609
How to connect ms access to oracle servers?
How many types of cluster table in Oracle?
What is a trigger and what are its types?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
Explain the difference between sql and oracle?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
How to define a cusotmer as a supplier in ORACLE R12
What is the simplest tool to run commands on oracle servers?
Explain joins in oracle?
Why more redos are generated when the oracle database is in begin backup mode?
What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?
What are the restrictions in a oracle read only transaction?
Explain the use of show option in imp command.
Tell me about standby database? What should we watch out for?