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

Shrikant Pande

• Aug 24th, 2005

Yes : Schema objects can stored in different tablespace and a tablespace can contained one or more schema objects data.

sandeep

• Jul 4th, 2005

Yes , it can .  for example if you specify a different tablepace (B) for indexes, the indexes of the tables that the user create would be residing in B , and the table would reside in the user's default tablespace A. Rgds Sandeep Kurian

Answer Question  Select Best Answer

Rani Rathna

• Jul 9th, 2005

hash cluster --> preallocated based on number of keys and key size.  index cluster --> not preallocated  in both cases, you want to get the key size (amount of data associated with...

soccer_champ

• Jun 20th, 2005

Hash clusters are useful in cases where : (i) There is a uniform, even and predictable no. of key values. (ii) Queries using equality predicates. (iii) The table is NOT growing constantly, and the keys are rarely updated.

Answer Question  Select Best Answer

cmanne

 Profile Answers by cmanne Questions by cmanne

• Jul 29th, 2006

PUBLIC DATABASE LINKPRIVATE DATABASE LINK

Rani Rathna

• Jul 9th, 2005

You can create a private database link in a specific schema of a database. Only the owner of a private database link or  PL/SQL subprograms in the schema can use a private database link to access...

Answer Question  Select Best Answer

ajexpert

 Profile Answers by ajexpert Questions by ajexpert

• Jul 29th, 2006

Clusters are optional method of storing table data.  A cluster is group of tables that share same data  blocks because they share common columns and often use together.

sri

• Aug 4th, 2005

Groups of tables physically stored together because they share common columns and are often used together is called clusters

Answer Question  Select Best Answer

 Multiple   instances   accessing  the  same  database  (Only  In  Multi-CPU environments) 

satyam_Ora

 Profile Answers by satyam_Ora Questions by satyam_Ora

• Aug 18th, 2007

Very true---Multiple instances uses by single database files is called parallel server. in this condition database files act as a server and connected with differenet instances.But each instances can use database files in same time.So the database file is called Parallel server.

Answer Question  Select Best Answer

 Group  of  tables  physically  stored  together  because  they share common columns and are often used together is called Cluster.

parthokonar1

 Profile Answers by parthokonar1 Questions by parthokonar1

• Sep 28th, 2007

Yes that is true, For creating cluster we first create the cluster via index/hash, then we all the tables in the cluster.

Answer Question  Select Best Answer

 Two  processes wating to update the rows of a table which are locked by the other process then deadlock arises. In  a  database  environment  this will often happen because of not issuing proper  row  lock  commands. Poor design of front-end application may cause this situation and the performance of server will reduce drastically. These locks...

msabuu

 Profile Answers by msabuu Questions by msabuu

• Nov 6th, 2007

Oracle automatically detect deadlock , but not occar

Answer Question  Select Best Answer

doc123

 Profile Answers by doc123 Questions by doc123

• Mar 23rd, 2012

Dear friend, it is not RAP but it is WRAP. Using this utility of Oracle, we can hide our PL/SQL code from user.

Answer Question  Select Best Answer

cmanne

 Profile Answers by cmanne Questions by cmanne

• Jul 29th, 2006

DBMS_METADATADBMS_STATSDBMS_SUPPORTDBMS_SESSION

akebono

• Aug 26th, 2005

 DBMS_OUTPUT.PUT_LINE('strings'); print out the strings  DBMS_UTILITY.get_time() get the current time  DBMS_ALERT e.g begin dbms_alert.register('myregister'); end  to register interst in a named alert   

Answer Question  Select Best Answer

Deepa Kale

• Apr 11th, 2007

If user authentication is managed by the database, security administrators should develop a password security policy to maintain database access security. For example, database users should be require...

Answer Question  Select Best Answer

Radha B S

• Mar 15th, 2006

Srinivas reddy Wrote: 1. Dynamic Memomry Management  2. Default tablespace at the db levele  3. temporary tablespace at the dba level 4. Undo tablespace managemnet (auto/manual)

srinivas reddy

• Mar 25th, 2005

1. Dynamic Memomry Management  2. Default tablespace at the db levele  3. temporary tablespace at the dba level 4. Undo tablespace managemnet (auto/manual)

Answer Question  Select Best Answer

Latches are low level serialization mechanisms used to protect shared data structures in the SGA. The implementation of latches is operating system dependent, particularly in regard to whether a process will wait for a latch and for how long.A latch is a type of a lock that can be very quickly acquired and freed. Latches are typically used to prevent more than one process from executing the same piece...

manoj seemar

• Nov 2nd, 2007

Latches are simple, low-level serialization mechanisms to protect shared data structures in the system global area (SGA). For example, latches protect the list of users currently accessing the databas...

Answer Question  Select Best Answer

Enqueues are another type of locking mechanism used in Oracle. An enqueue is a more sophisticated mechanism which permits several concurrent processes to have varying degree of sharing of "known" resources. Any object which can be concurrently used, can be protected with enqueues. A good example is of locks on tables. We allow varying levels of sharing on tables e.g. two processes can lock a table...

manoj seemar

• Nov 2nd, 2007

An enqueue is a sophisticated locking mechanism that permits several concurrent processes to share known resources to varying degrees. Any object that can be used concurrently can be protected with en...

Answer Question  Select Best Answer

innovative

 Profile Answers by innovative Questions by innovative

• Feb 20th, 2006

tablespaces are the logical constructs which are group of datafiles. a datafile belongs to one database. in laymans language we can say that tablespaces are like folders in windows environment. as we ...

Gurmeet Singh

• Feb 13th, 2006

Use of tableapce in oracle are:1) we can assign different quotas to the user of databasae2)we can take a part of database unavailable from the user3)we can create a object which have block size different from standard block size4) we can take backup of part of the database

Answer Question  Select Best Answer

rajendra singh chauhan

• Mar 20th, 2007

When a select statement is executed first of all the statements hash code is genrated then that hash code is matched in library cache if the hash code matched then statement is directly executed and if the hash code is not present then hard parsing is done and statement is executed

Santhosh Kumar

• Sep 4th, 2006

Processing Of Sql select statement: When any user executes any sql statement a user process generated and it the request sents to server process. First Server process checks for any privious ex...

Answer Question  Select Best Answer