Kishore Kumar Vuthpala

• Apr 11th, 2006

Hit Ratio is the ratio of shared SQL and PL/SQL items found in the Library Cache versus physical storage.It can also be defined in a mathematical expression as  1 - ((physical reads) / (db block gets + consistent reads))

Answer Question  Select Best Answer

 Cold backup is taking backup of all physical files after normal shutdown of database.  We need to take.     - All Data files.     - All Control files.     - All on-line redo log files.     - The init.ora file (Optional)

Ravi Prakash Pichika

• Jun 20th, 2006

A backup of one or more database files taken while the database is closed. Typically, closed backups are also whole database backups. If you closed the database cleanly, then all the files in the backup are consistent. SQL>SHUTDOWN IMMEDIATE (or) NORMAL  

cmanne

 Profile Answers by cmanne Questions by cmanne

• Jan 4th, 2006

A cold backup is taken after shutting down the database Cold backup contains the following files--Data Files--Redolog Files--Control File(s)

Answer Question  Select Best Answer

anandhi80

 Profile Answers by anandhi80 Questions by anandhi80

• Jun 28th, 2006

when a user updated a particular table (for example 100 rows)...the old value will be retained in the roll back segments(Oracle 8) and now it is Undo segment (oracle 9i). If the user issue a rollback ...

Mahendra

• Sep 2nd, 2005

Used to store undo data. In a transaction when data is updated , other seesions should not view the uncommited data . Other Sessions will access the undo dara in the Roll Back segment

Answer Question  Select Best Answer

 To manage the database level transactions such as modifications of the data dictionary table that record information about the free space usage.

Anu

• Oct 3rd, 2006

1.System tablespace is required in all databases.2.It is created with the database.3.Contains the data dictionary and stored program units.4.Contains SYSTEM undo segment.

Answer Question  Select Best Answer

 Each block contains entries as followsFixed block headerVariable block headerRow Header,row date (multiple rows may exists)PCTEREE (% of  free space for row updation in future)

Anu

• Oct 3rd, 2006

A block is divided into1. Header2.free space3.data spaceThe free space is in the middle shrinks as header and data space grow.Space usage in the data space :The data space is managed with 2 parameters...

Answer Question  Select Best Answer

 They allow the database to maintain read consistency between multiple transactions.

Anu

• Oct 4th, 2006

1.Transaction Rollback-When a transaction is rolled back to restore the old image.2.Transaction recovery-To undo any uncommitted changes when DB is open after instance failure.3.Read consistency-While transaction is on progress other users in DB do not see any uncommitted changes.

Answer Question  Select Best Answer

bijan Mohapatra

• Nov 5th, 2006

Edit itit.ora file after shutdown the data base, set path for another control file in the parameter setting. then copy the control file to the desired location where the path is setting, then start the database.

Shrikant Pande

• Aug 25th, 2005

1. Edit init.ora file set control_files parameter with multiple location 2. shutdown immediate 3. copy control file to multiple locations & confirm from init.ora contol_files parameter ...

Answer Question  Select Best Answer

 Shutdown the databaseCopy one of the existing control file to new locationEdit Config ora file by adding new control file. nameRestart the database.

nitanjandial

 Profile Answers by nitanjandial Questions by nitanjandial

• Jan 30th, 2007

+Before to insert new control files,we should verify the existing control files location+these are the ways to find it=======================================================1.show parameter control_fi...

Answer Question  Select Best Answer

 By querying DBA_SEGMENT table/view.

nitanjandial

• Jan 30th, 2007

+This is the view we should use to see the allocation space +Both the views return the same result.=============================================select name,sum(bytes)"allocated space in MB" from dba_data_files/v$datafile==============================================Thanks and RegardsNitan Jandial

Answer Question  Select Best Answer

Mohammed Abdul Afroze

• Mar 25th, 2007

Answer:  Shared Pool Comprises library cache and dictionary cache.Library Cache stores and shares sql statements,where as pl/sql procedure in memory.And the Default size is 8mb.

Ravi Prakash Pichika

• Jun 6th, 2005

The Shared Pool environment contains both fixed and variable structures. The Fixed structures remain relatively the same size, whereas the variable structures grow and shrink based on user and program...

Answer Question  Select Best Answer

 SET TRANSACTION USE ROLLBACK SEGMENT rbs_name.

schma16

 Profile Answers by schma16 Questions by schma16

• May 29th, 2007

Optimal Flexible Architecture is a set of configuration standard created to ensure reliable Ora installation that require little maintenance. It has a default file naming and Directory layout for nami...

Answer Question  Select Best Answer

agarwalk_2000

 Profile Answers by agarwalk_2000 Questions by agarwalk_2000

• Jun 16th, 2007

By Dba_segments and DBA_extents and dba_free_space views.

Answer Question  Select Best Answer

yathirajulu

• Sep 30th, 2007

The difference is Application server?provides some features:Multi-threading, persistence, security & Transperant, which supports various protocols.Where as, Web-server doesn't supports that features....

sushilsb

 Profile Answers by sushilsb Questions by sushilsb

• Jun 2nd, 2006

Web servers serves the HTTP request and reutrns the HTTP response whereas application server exposes the business methods. These business methods are invoked thru different protocols e.g. Http, TCP/IP...

Answer Question  Select Best Answer

simakas

 Profile Answers by simakas Questions by simakas

• Oct 9th, 2007

Yes. Using raw files/devices for database can have a slight performance gain. Raw files are unformatted disk partitions that can be used as one large file. Raw devices have the benefit of no file syst...

Answer Question  Select Best Answer

simakas

 Profile Answers by simakas Questions by simakas

• Oct 9th, 2007

Segment is droppedOn shrinkOn truncation (TRUNCATE used with drop option)

Answer Question  Select Best Answer

simakas

 Profile Answers by simakas Questions by simakas

• Oct 9th, 2007

Oracle raw devices are managed only with Oracle tools, at OS level they are just dd (character special files) devices. Raw devices are more difficult to administer than data files stored on a file system or in an ASM disk group.

Answer Question  Select Best Answer

 Export the user Perform import  using  the  command  imp  system/manager   file=export.dmp indexfile=newrite.sql. This will create all definitions into newfile.sql. Drop necessary objects. Run the script newfile.sql after altering the tablespaces. Import from the backup for the necessary objects.

simakas

 Profile Answers by simakas Questions by simakas

• Oct 9th, 2007

If its the same database use:alter table the_table move tablespace other_tablespace; alter index the_index rebuild tablespace other_tablespace;

Answer Question  Select Best Answer

Migration and Changing are two distinctly different types of problems that can exist when a row is too large to fit into a single data block.Row Changing:: Row changing occurs when a row is too large to fit into a single empty data block. When this occurs, Oracle will spread the row across as many blocks as are needed. Changing the row from from one block to the next.Row Migration:: Row migration occurs...

What is meant by Shared pool fragmentation.