gopi

• Aug 8th, 2017

Check the alert log file, copy the pFile data and start the instance . suppose the data is not there in the alert log , we connect to RMAN and "startup nomount force;" and then we got some dummy pFile, modify accordingly for our requirements and then start instance with pFile or spFile

nagesh

• Jan 20th, 2012

We can get the pfile from the diagonostics_dest path, in this we select the appropriate parameters and then jst create a copy in $ORACLE_HOME/dbs location using another initdbname.ora
jst run it again its enough it works.

Answer Question  Select Best Answer

 Logical backup involves reading a set of database records and writing them into a file. Export utility is used for taking backup and Import utility is used to recover from backup.

gurubhai33

 Profile Answers by gurubhai33 Questions by gurubhai33

• Mar 26th, 2011

Backups that are done using exp/imp or Data pump as called logical backups. It take the backup of logical structure of database instead of physical.

Sriharsha N

 Profile Answers by Sriharsha N Questions by Sriharsha N

• Mar 25th, 2011

Logical backup means backing up the database objects like tables, views , indexes...etc using the EXPORT utility given by Oracle. The objects exported in this way can be imported into either same data...

Answer Question  Select Best Answer

sandeep vig

• Oct 13th, 2005

there are main two causes for reparsing1)the objects which the query is refrencing has been modified 2) or the parsed version of sql text has been aged out of the library cache.

praim Sankar

• Sep 1st, 2005

The Library Cache was introduced because parsing (and validating and checking privileges) is expensive in terms of CPU cycles.   Oracle uses a LRU/MRU mechanism to keep sql statements in cac...

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

Read Best Answer

Editorial / Best Answer

Answered by: Alok Kumar

• Sep 22nd, 2005

---

Hi,

Dictionary cache is memory arear in shared pool.dictionary cache are used to hold db blocks of recently used data dictionary tables.

thanks

Alok.

 

gopi

• Aug 8th, 2017

Data directory cache contains the all table and indexes, trigger and db_ objects information

Alok Kumar

• Sep 22nd, 2005

Hi,Dictionary cache is memory arear in shared pool.dictionary cache are used to hold db blocks of recently used data dictionary tables.thanksAlok. 

Improve Answer

prashatt

 Profile Answers by prashatt Questions by prashatt

• Jun 24th, 2008

Disk shadowing or mirroring is done either using a software or a hardware utility called RAID.  Disk shadowing enables another disk to take-over from a failed hard disk avoiding any downtimes. Generally Hardware fial-overs are enabled on all servers.

balu

• Oct 8th, 2005

Instead of taking seperate backups mirroring always helps taking backup simultanuesy.

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

Ravi Prakash Pichika

• Jun 6th, 2005

SGA - Stands for System Global Area, its a part of Memory structure! SGA consists of   Shared Pool Database Buffer Cache Redo Log Buffer Lock & Latch Management  & M...

nishit patel

• Mar 12th, 2005

SGA * stands for System/Shared Global Area* can be used/shared by all users* it is a part of memory structure of Instance* consists of memory components like 1> shared pool 2> Database cache 3...

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Answered by: Alok

• Sep 10th, 2005

---

Redo log buffer is circular buffer,lgwr writes these buffers in cyclic faishon.redo log buffers contains redo entreies which are used to reconstruct or redo chandes. 
 

Alok

• Sep 10th, 2005

Redo log buffer is circular buffer,lgwr writes these buffers in cyclic faishon.redo log buffers contains redo entreies which are used to reconstruct or redo chandes.  

priya

• May 30th, 2005

It is a memory location where the temporary changes are stored in abuffer

Improve Answer

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

Answered by: Lachi on 2005-06-08 07:28:04For perticular transaction Alter system set rollback segment 'name'; For database, we can set in pfile. Rollback_segment='name'

Lakshminarayan.

• Jun 13th, 2005

In above answer one correction is there,  For perticular transaction we can use fallowing syntax.  >set transaction use rollback segment 'name'

Lachi

• Jun 8th, 2005

For perticular transaction Alter system set rollback segment 'name'; For database, we can set in pfile. Rollback_segment='name'

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

agarwalk_2000

 Profile Answers by agarwalk_2000 Questions by agarwalk_2000

• Jun 16th, 2007

Calculate the total header size.Calulate the available data space?per data block.Calulcate the combined column length by the avarge row.Calultate total average?row size.Calculate avarge number of rows that can fit in data block.Calulate the number of blocks?bytes that required for a table.

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

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

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

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

 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