You create a private database link <link name> and upon
connection, fails with: ORA-2085: <Link name> connects to
<fully qualified remote db name>. What is the problem? How
would you go about resolving this error?
What spfile/init.ora file parameter exists to force the CBO
to make the execution path of a given statement use an
index, even if the index scan may appear to be calculated as
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 would you do with an "in-doubt" distributed transaction?
Does any body has ORACLE Certification Dumps or Materials
on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i
to 10g DBA Upgrade, Oracle 11i if any body have it, please
kindly drop an email to: email@example.com
Define the SGA and:
How you would configure SGA for a mid-sized OLTP environment?
What is involved in tuning the SGA?
one datafile is lost in standy side how can you recover that??
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?
what is the diffrence between core dba and apps dba?
Typically, where is the conventional directory structure
chosen for Oracle binaries to reside?
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 is ora 24313?what is the procedure to exclude that error?
How does propagation differ between Advanced Replication and
Snapshot Replication (read-only)?
Can you tell me about your experience with the
administration of COTS system..? Also, how do you set up
when we login sql editor using username and password then it
says this error "could not resolve service name" then what
can we do at client side.( here thing is tnsnames.ora file
is ok till yesterday and worked well, but now it giving error.