Other than making use of the statspack utility, what would
you check when you are monitoring or running a health check
on an Oracle 8i or 9i database?
You have 4 instances running on the same UNIX box. How can
you determine which shared memory and semaphores are
associated with which instance?
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?
how to restore files with rman?
Can you tell me about your experience with the
administration of COTS system..? Also, how do you set up
How would you best determine why your MVIEW couldn't FAST
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
As a part of your job, what are the DBCC commands that you
commonly use for database maintenance?
Query processing is slow(eg select query)how will u solve that
how can you connect from 10g user to 11g user??
Typically, where is the conventional directory structure
chosen for Oracle binaries to reside?
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.
I got an error SQL1042C. An unexpected system error
A system error occurred. One possible reason for this error
is that the database manager is not installed correctly or
the environment is not set up correctly.
On OS/2, while trying to start the database manager, a very
common reason for this error is a corrupted NET.ACC file.
The command cannot be processed.
The tables and views would not be opened. What is the way
to open the dataase?
pls help me
What is the recommended interval at which to run statspack
snapshots, and why?
What view(s) do you use to associate a user's SQLPLUS
session with his o/s process?