-
Index tablespace for a Database
How to assign an index tablespace for a database permanently, so that whatever indexes we are creating in the database, should automatically goes to that tablespace i.e. we neednot supply the tablespace name during index creation.
kailasTile
- Dec 17th, 2007
There is no such provision in oracle to have default index tablespace. Workaround is- you can have a job which will scan for indexes in other tablespaces and rebuild into desired one.
-
What are the fixed memory structures inside the SGA?
rajat_dua
- Mar 3rd, 2009
Part of the SGA contains general information about the state of the database and the instance, which the background processes need to access; this is called the fixed SGA. No user data is stored here....
-
Cloning and Standby Databases
What is the difference between Cloning and Standby databases?
rajendra_thanekar
- Jan 2nd, 2008
Cloning is nothing but the copy of your database which can be open in read write mode. The standby database is also a copy of your database which is in standby mode and which is made in sink with prod...
-
Installing Oracle9i/10g at unix (RedHat) environment
While Installing Oracle9i/10g at unix (RedHat) environment , which parameter needs to be set at OS level, to login as a sysdba in Oracle for the first time?
skpanuganti
- Feb 8th, 2008
.bash_profile has to set at OS level before connecting to oracle database.
-
Difference between failover and switch over servers
kailasTile
- Mar 27th, 2008
Failover: Primary fails and standby is made primary.Switchover: Primary and secondary interchanges the role.Effectively, in both cases, standby becomes primary, main difference is, when failover happe...
-
Cost Based Optimizer and Rule Based Optimizer
What is the difference between Cost Based Optimizer and Rule Based Optimizer?(CBO is the default optimizer)
ajay.ocp
- Aug 20th, 2008
In brief the rule-based method means that when executing a query the database must follow certain predefined rules and matter what data is stored in affected database tables. The cost-based method mea...
-
Limit and Default size of Tablespace
Can we create as many tablespace as we require. What is the limit? What is the default size of tablespace? (System and User tablespace). Mention name of some tablespace.
-
Compression Parameter
You have a database of 2GB. Can you convert the database to 1GB. Which compression parameter will you use?
hemant.agarwal03
- Mar 18th, 2008
COMPRESSION =(METADATA_ONLY | NONE) - This parameter applies from Oracle 10.2. It specifies whether to compress metadata before writing to the dump file set. Compression reduces the amount of disk spa...
-
Datafile Size
What is your datafile size? How long it can go? What is the max limit to which you can extend?
hemant.agarwal03
- Mar 18th, 2008
v$datafile data dictionary view will tell us the size of a datafile.to check the number of datafile you can check db_files init parameter. you can also alter this parameter but it will reflect after restartthe database.you can also resize the datafile size.
-
Cache Fusion Technology
What is Cache Fusion Technology?
bhuvannpg
- Feb 28th, 2008
Cache Fusion is a new technology that uses a high speed interprocess communication (IPC) interconnect to provide cache to cache transfers of data blocks between instances in a cluster. This eliminates...
-
DBMS_meta_data Parameter
DBMS_meta_data. This parameter is very usefull. What you infer from this parameter. What info you will find in that. explain in detail.
hemant.agarwal03
- Mar 12th, 2008
To find the structure of a external table we used this package.syntax is below:SELECT DBMS_METADATA.GET_DDL ('TABLE','<Table Name in CAPS>')||';' FROM DUAL
-
Disk (sort) Ratio
The ratio of disk (sort) is high. Is that good or bad? Why? How will you reduce disk sort?
rajendra_thanekar
- Apr 17th, 2008
Hi,Disk(sort)ratio is high is not good.Please set sort_area_retained_size and sort_area_size so that session can sort in max in memory.
-
Overcome Alert Log Error
Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error.
rajendra_thanekar
- Mar 24th, 2008
Hi,Oracle write error in alert log file. Depending upon the error corrective action needs to be taken.1) DeadLock Error : Take the trace file in user dump destination and analysis it for the error.2) ...
-
Flash Back Query
What is a flash back query? This feature is also available in 9i. whats the difference between 9i and 10g (related to flash back query).
hemant.agarwal03
- Mar 12th, 2008
Oracle 10g offers significant enhancements that help insure the high availability of any Oracle database, as well as improvements in the database disaster recovery arena. This paper explores one of th...
-
Standby Databases
What is standby databases? Difference between Physical and logical standby databases
rajendra_thanekar
- Mar 14th, 2008
A standby database is a transactionally consistent copy of the primary database. Using a backup copy of the primary database, you can create up to nine standby databases.A standby database can be eith...
-
Oracle memory segments
How do you see how many memory segments are acquired by Oracle Instance.
olilogu
- May 11th, 2009
Check on x$bh it show you what objects are in the buffer.Try this query;SELECT /*+ ordered use_hash(o) use_hash(bh) */ bp.NAME BUFFER_POOL, ...
-
Oracle segments
How do you see how many memory segments are acquired by Oracle Instance.
Baipaneni
- Jan 23rd, 2009
For shared memory segmets in UNIX or LINUX:-->In HOST1_LINUX has one instance $ ipcs -m oracle@HOST1_LINUX:$ ipcs -m------ Shared Memory Segments --------key &nb...
-
Remove Oracle memory segments
How do you remove memory segments
bassem_farouk
- Sep 18th, 2008
To see the Oracle memory segments from UNIX write ipcsthen look at the status column, the one with status is empty and? owner is oraclewrite down the shmid, ex: 2 find 2 shmid 123 and 456?in order t...
-
Oratab file
What is stored in Oratab file
mandarkelkar
- Jun 5th, 2008
This file is used by ORACLE utilities. It is created by root.sh and updated by the Database Configuration Assistant when creating a database.A colon, ':', is used as the field terminator...
-
Can you change priority of a Process in Unix
jituoracle
- Jan 6th, 2009
Unix does provide the command nice [increment] command to lower a priority of a process. As system administrator you can use the renice command to change the priority of a process, all processes of a...
Oracle DBA Interview Questions
Ans