Ajwat Hasan

• Oct 10th, 2007

Often the word "lock" is synonymous to enqueue. In this document, "enqueue" will be used for the locking mechanism that you can find in V$LOCK. "locking" will be used whe...

Answer Question  Select Best Answer

Whenever commit,checkpoint or redolog buffer is 1/3rd full

Jayesh Patel

• Oct 9th, 2007

LGWR writes:1) COMMIT/ ROLLBACK2) 1 MB of large transaction3) Before DBWR writes4) 1/3 of REDO LOG is full5) time out occurs6) Check Point encounters

SALIH

• Dec 15th, 2005

1.COMMIT or ROLLABCK2.time out occurs (3 secs)3 1/3 of log is full4. 1 mb of redo5. Checkpoint occurs

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

Mohammed Abdul Afroze

• Sep 28th, 2007

An Extent is a set of contignous data blocks obtain in a single allocation and used to store specific type of information.

Yoh

• Jul 30th, 2006

Extends are a collection of data blocks

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

senthilora

• Sep 24th, 2007

There are many ways to do that.? Following is the one of the ways I would prefer as I do it usually.You can achieve this by having a small Unix Scripting / Windows Shell Scripting?/ any other script...

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

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

senthilora

 Profile Answers by senthilora Questions by senthilora

• Sep 24th, 2007

Another suggestion could be: Find the Master Table(s) of the given table and export / import them all.

balakrishna

• May 28th, 2006

If u want to import the table just say constraints=n the movement table got imported then u create constriant on that tables.

Answer Question  Select Best Answer

senthilora

 Profile Answers by senthilora Questions by senthilora

• Sep 24th, 2007

ORA-1555 error can occur in Oracle 10g also even with UNDO RETENTION GUARANTEE enabled. ORA-1555 happens, when Oracle server process could not find the block-image in UNDO tablespace for the read...

paparao

• Oct 23rd, 2006

This shanshot too old. -> problem occurs generally in 9i only.  Whether in 10g, at the time of tablespace creation, retuntion guarentee is applied it automatically we can supress( by default i...

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

An  index  is a database structure used by the server to have direct access of a row in a table. An  index  is automatically created when a unique of primary key constraint clause is specified in create table comman (Ver 7.0)

satyam_Ora

 Profile Answers by satyam_Ora Questions by satyam_Ora

• Aug 18th, 2007

Indexes are used both to improve performence and to ensure uniquness of a column. Oracle automatically creates an index when a UNIQUE or PRIMARY key constarints clause is specified in a create table command.We can manually create our own indexes via the create index command.

satyam_Ora

 Profile Answers by satyam_Ora Questions by satyam_Ora

• Aug 18th, 2007

An index is a database structure used by the server to quickly find a row in a table.In a relational database the physical location of row is irrelevent-unless, of course, the database needs to find i...

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

Taj_N

• Jul 16th, 2007

An Index is based on tree structre that allow direct access to a row in a table, oracle uses different type of index 1) B-Tree Index2) Bitmap Index

srujana

• Aug 23rd, 2005

It is created in existing table to locate rows more quickly&efficiently. the users cannot see the indexes,they are just used to speed up the queries

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

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

dhussainpathan

• Apr 9th, 2007

The Redo log files records the changes made  to the database in the form of REDOLOG entries, which are helpful at the time of Database Recovery Process.

rajesh chadalawada

• Dec 2nd, 2006

     Redo Log is ment to trce or note  the modifications that are applied to data buffer cache it will note on folloing situations1)for every 3 seconds2)when redo log buffer reaches to 1MB3)before db_cache writes data to datafiles4)when ever commited

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

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

ram

• Mar 8th, 2007

question is not clear  sturucture of database can be foud in dataflies redo log control files 

Answer Question  Select Best Answer