Oracle database - June 17, 2010 at 12:30 PM by Babu Kunwar
Creating database is very simple in Oracle. We can use the DBCA database
configuration assistant to create a database. We can launch the DBCA by using
the windows command prompt utility..............
Read Answer
To completely re-name a database you need to change all of the components where
the instance name is located:
External files: sqlnet.ora, tnsnames.ora, init.ora (spfile)................
Read Answer
Oracle provides different types of tablespace namely SYSTEM tablespaces, the
SYSAUX tablespace, temporary tablespaces, undo tablespaces, and bigfile
tablespaces.....................
Read Answer
An oracle database consists of data files; redo log files, control files,
temporary files. And in order to find out the size of the entire database we
need to sum up size of all these files.................
Read
Answer
You can easily compute the amount of free space in each tablespace by using the
following query:
SQL> select tablespace_name, sum (bytes) from dba_free_space group by
tablespace_name;..........
Read Answer
The "alter session set sql_trace=true" command generates trace files in
USER_DUMP_DEST that can be used by developers as input to tkprof. On UNIX the
default file mask for these files are "rwx r-- ---"....................
Read Answer
ORADEBUG is a utility that allows users to perform the following
operations:...............
Read Answer
We can dump the entire internal database structure by dumping the internal files
of the database. The following SQL statements can be used to dump the internal
database files:.............
Read Answer
Semaphores: Inside Oracle database there are many processes or threads are
running and for successful running they need to communicate with each other.
The process through which they communicate.................
Read Answer
A deadlock is a rare situation in which two or more user processes of a database
cannot complete their transactions. This occurs because each process is holding
a resource that the other process requires in order to complete...............
Read Answer
LIBRARY CACHE PIN usually occurs during compiling and recompiling PL / SQL,
VIEW, TYPES. First we will determine the blocker information
as:.............
Read Answer
Automatic Performance Diagnostic and Tuning Features, Automatic Shared Memory
Management - Automatic Shared Memory Management puts Oracle in control of
allocating memory within the SGA..........
Due to Mirrored online redo logs and disk array mirroring, the occurrence of
redo log corruptions has dropped to practically
zero...................
Object data types are user defined data types. Both column and row can represent
an object type.................
|
