The primary functional difference between logical and physical standby database setups is that logical standby permits you to add additional objects (tables, indexes, etc) to the database, while physical standby is always an exact structural duplicate of the master database. The downside, though, is that logical standby is based on newer technologies (logical standby is new in Oracle 9.2) and tends...

Ashu Shukla

• Oct 29th, 2007

A physical or logical standby database is a database replica created from a backup of a primary database. A physical standby database is physically identical to the primary database on a block-fo...

santhosh

• Jun 26th, 2006

Physical Standby - acheived by copying the archivle log filesLogical Standby - makes the dml statements using archivelogs generated and applies to the secondary database

Answer Question  Select Best Answer

senthilora

 Profile Answers by senthilora Questions by senthilora

• Sep 24th, 2007

1. set SHARED_SERVERS=(more than 1) in init.ora2. make changes in tnsnames.ora file to get the connection with DISPATHERS rather than dedicated servers

SALIH

• Dec 15th, 2005

Use DBCA toolYou will get the option to select shared server mode.

Answer Question  Select Best Answer

paparao03@gmail.com

• Oct 31st, 2006

Query Rewrite option advantages we can get with the materialize view option also.

paparao03@gmail.com

• Oct 27th, 2006

I am agree with above(sheela) comments.along with It is more usedful OPTIONS LIKE FAST, COMPLETE, FORCE, WITH THE HELP OF MATERIALIZED VIEW LOG IS MORE USEFUL.

Answer Question  Select Best Answer

senthilora

 Profile Answers by senthilora Questions by senthilora

• Sep 24th, 2007

And.. It does not store any data value in it unlike normal index do.Queries will not get benefitted. This can be used only for analysis.

Varun

• Sep 11th, 2005

1. These are permanent and continue to exist unless we drop them.2. Their creation will not affect existing and new sessions. Only sessions marked for Virtual Index usage will become aware of their ex...

Answer Question  Select Best Answer

Sandesh

• Jun 6th, 2007

Change the domain name in the sqlnet.ora file in NAMES.DEFAULT_DOMAIN parameter.

Bhavani Shekhar

• Mar 15th, 2006

The Question is not clear about Where the Oracle database is residing.If the Oracle Database is resides on ur local machine then the domain name must be updated in the tnsnames.ora file. change this f...

Answer Question  Select Best Answer

sean21

 Profile Answers by sean21 Questions by sean21

• Mar 8th, 2010

Optimizer_mode = TYPICAL

Tirumal Devulapalli

• Feb 23rd, 2006

CBO (Cost Based Optimizer):Generates an execution plan for a SQL statementoptimizer_index_cost_adj parameter can be set to help CBO to decide an execution plan, which effects the speed of SQL query.we...

Answer Question  Select Best Answer

What is OERR Utility

Alpana G

 Profile Answers by Alpana G Questions by Alpana G

• Jun 20th, 2011

The OERR utility will display the complete error message text and the source of the error and recommended steps for resolving the problem.Syntax- oerr ora “error”oerr ora 0060000600, 00000...

Ramshankardba

 Profile Answers by Ramshankardba Questions by Ramshankardba

• Jan 17th, 2009

OERR Utility is an Oracle error lookup utility in UNIX environment.

Answer Question  Select Best Answer

Sriniv@s..

• Jun 5th, 2012

Schema is a set of objects own by particular user.
Tables,indexes,Triggers,constraints etc..are schema objects..

Jacob

• Jul 9th, 2005

A schema is a collection of database objects. A schema is owned by a database user and has the same name as that user. Schema objects are logical structures created by users. Objects may define areas ...

Answer Question  Select Best Answer

sivaraju.sateesh

 Profile Answers by sivaraju.sateesh Questions by sivaraju.sateesh

• Apr 7th, 2009

Private synonym is a synonym which resides in the owners schema

Dan

• Jul 9th, 2005

To create a private synonym in your own schema, you must have CREATE SYNONYM system privilege.  To create a private synonym in another user's schema, you must have CREATE ANY SYNONYM system ...

Answer Question  Select Best Answer

imran44

 Profile Answers by imran44 Questions by imran44

• Jul 10th, 2009

At the time of database creation 2 redo log files are created, these redo log files act in circular fashion, when log switch occur, redo log file will dump its contents in archived log destination, an...

nagabhushan reddy

• Feb 8th, 2006

Redo log file contains data which changes made to the database.it is used for recovery purpose.

Answer Question  Select Best Answer

imran44

 Profile Answers by imran44 Questions by imran44

• Jul 10th, 2009

SGA+Background Process = InstanceAs soon as user process starts and server process takes control from user process, instance created with help of background processes and most important background pro...

cmanne

 Profile Answers by cmanne Questions by cmanne

• Jan 4th, 2006

An Oracle instance is a combination of background processes and memory structures (SGA)

Answer Question  Select Best Answer

 A  database  instance  (Server) is a set of memory structure and background processes that access a set of database files. The process can be shared by all users. The  memory  structure  that  are  used  to  store  most  queried data from database.  This  helps up to improve database performance by decreasing the...

ranjanam

• Aug 26th, 2007

Database instance(server) is the combination of memory structure and background process. It's a way to connect to the oracle database.

satyam_Ora

 Profile Answers by satyam_Ora Questions by satyam_Ora

• Aug 18th, 2007

A database instance also know as server is a set of memory structures and background processes that access a set of database files.It is possible for a single database to be accessed by multiple insta...

Answer Question  Select Best Answer

venu

• Sep 1st, 2012

The transportabel tablespaces enable us to transport data objects across different platforms.

Backing up or recovering a particular user/schema objects or data objects or tablespaces or entire databases is possible, which cannot be done using other backup techniques.

Sriniv@s..

• Jun 2nd, 2012

Moving data using transportable tablespace can be much faster than performing either export/import or unload/load of the same data.Bcz transporting a tablespace only requires the copying of datafiles & integrating the tablespace structural information.

Answer Question  Select Best Answer

MA123

 Profile Answers by MA123 Questions by MA123

• Jan 25th, 2008

Snapshots can't upated. While MV can be updated contantley.

taraldesai

 Profile Answers by taraldesai Questions by taraldesai

• Jun 19th, 2007

No difference ..snapshot was used untill v8 and 8i onwards called mv

Answer Question  Select Best Answer

How would you plan for an Oracle upgrade? What are the prerequisites?

deepak subramoniam

• Aug 3rd, 2014

Ensure the nls Characterset of the parent and child database are same
Ensure the editions of both the database are same.
Ensure UTL_SMTP,UTL_HTTP,UTL_FILE Packages are available. (for 10g to 11g se)
wm_concat needs to be changed in the 11g because in 11g the function will not be supported by Oracle

rohith

• Jul 21st, 2014

if u want to any up-gradation in oracle first we need to check version compatibility like if u want to upgrade from 10g to 11g the 10g version should be 10.2.0.4 or 10.2.0.5. then install the 11g sof...

Answer Question  Select Best Answer

senthilora

• Sep 24th, 2007

And.. I think, the question is about Data Migration - something related to migrating data between different databases.I have done using different tools like Data Junction, Informatica, even PL/SQL and SQL Loader.

Jacob Asirwadam SK, Biguvu

• May 21st, 2007

RAC stands for Real Application Cluster. In previous versions, it is known as PARALLEL SERVER. RAC is a mechanism that allows multiple instances (on different hosts/nodes) to access the same database....

Answer Question  Select Best Answer

Sriniv@s..

• Jun 2nd, 2012

SGA(system global area) & PGA(program global area) are two memory structures in oracle. SGA::is used to store shared information.It having Buffercache,Redolog buffer,Shared pool,java pool,Larg pool an...

AJU JOHNSON

• Apr 29th, 2005

PGA Program global area Contains  Session variables ,Stack space,Cursor status ,Sort Areas

Answer Question  Select Best Answer

Pooja Agrawal

• Nov 22nd, 2006

Additionally,PGA_Aggregate_target set when Work_area_policy is set to auto and FAST_START_MTTR_Target set may also affect d/b performance

Ratna Kumari

• Aug 2nd, 2005

These are the Parameters for init.ora  DB_BLOCK_BUFFERSSHARED_POOL_SIZESORT_AREA_SIZEDBWR_IO_SLAVESROLLBACK_SEGMENTSSORT_AREA_RETAINED_SIZEDB_BLOCK_LRU_EXTENDED_STATISTICSSHARED_POOL_RESERVE_SIZE

Answer Question  Select Best Answer

senthilora

 Profile Answers by senthilora Questions by senthilora

• Sep 24th, 2007

PARTITION is one of the options, which you can enable when you install Oracle Enterprice Edition.You may enable it later if you didn't choose to install at first time.  You will have to insta...

V.A.SURESH

• Nov 12th, 2005

Install 8i enterprise version. partition enables automatically

Answer Question  Select Best Answer

RASH

• Mar 24th, 2007

I'm sceptical about the .mdb.The simple, answer is Fixed width or Delimited TEXT files.

vnktummala

 Profile Answers by vnktummala Questions by vnktummala

• Jun 30th, 2006

1. .txt2. .dat3. .csv4. .mdb

Answer Question  Select Best Answer