What is the recommended interval at which to run statspack
snapshots, and why?
What would you do with an "in-doubt" distributed transaction?
How to bind a cobol module to a given job?
I am not able to understand this concept.Can anyone help me
out as how to carry out this task?
What are statistics, under what circumstances they go out
of date, how do you update them?
What are the commands you'd issue to show the explain plan
for "select * from dual"?
what are the differences of where and if in SAS?
how do we explain a project in cognos in an interview?
please help me. Also how do we perform testing in cognos
after creating reports?
can u plz tell me what r the mandatory skills for getting
job as a sql dba......plz send me all details thank you
my id :email@example.com
You have 4 instances running on the same UNIX box. How can
you determine which shared memory and semaphores are
associated with which instance?
How to craeate the New Database Schema in Oracle and mysql?
Please tell me with Example?
Claims and Drains are the locks used to control the
concurrency between SQL processes and utilities.
Referring to the above statement, what is the maximum
number of concurrent Claimers for a Subsystem?
In what script is "snap$" created? In what script is the
"scott/tiger" schema created?
i have 10gp file.now i need store in database..but database
have only 7gb memory only..how do u store the file ?
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?