How can you tell how much space is left on a given file
system and how much space each of the file system's
what is the role of dip user in our database?
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 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
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
What do the 9i dbms_standard.sql_txt() and
dbms_standard.sql_text() procedures do?
Which dictionary view(s) would you first look at to
understand or get a high-level idea of a given Advanced
what are the differences of where and if in SAS?
What are statistics, under what circumstances they go out
of date, how do you update them?
In which dictionary table or view would you look to
determine at which time a snapshot or MVIEW last
Why does Oracle not permit the use of PCTUSED with indexes?
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?
what is the last version,the release date of that version
and fix pack of ibm db2 udb?
Database crashes. Corruption is found scattered among the
file system neither of your doing nor of Oracle's. What
database recovery options are available? Database is in
archive log mode.
How would you go about verifying the network name that the
local_listener is currently using?