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

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

 Name of the parameter file to be passed for export.

Mad

• Jan 17th, 2012

We can avoid explicitly showing password in the script by putting it in Parfile. If password has Pound "#" sign in it then parfile will treat the pound sign as a start of a comment so it wont work in that case.

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Answered by: Shrikant Pande

• Aug 24th, 2005

---

Alter table < Table_Name> move tablespace ; 
 
Alter index rebuild tablespace ;

Shrikant Pande

• Aug 24th, 2005

Alter table < Table_Name> move tablespace ;  Alter index rebuild tablespace ;

Improve 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

Read Best Answer

Editorial / Best Answer

sushilsb  

 Profile Answers by sushilsb Questions by sushilsb

• Member Since May-2006 | Jun 2nd, 2006

---

Number  of  times processes repeatedly query the dictionary table is called recursive  hints.  It  is due to the data dictionary cache is too small. By increasing  the SHARED_POOL_SIZE parameter we can optimize the size of Data Dictionary Cache.

sushilsb

 Profile Answers by sushilsb Questions by sushilsb

• Jun 2nd, 2006

Number  of  times processes repeatedly query the dictionary table is called recursive  hints.  It  is due to the data dictionary cache is too small. By increasing  the SHARED_POOL_SIZE parameter we can optimize the size of Data Dictionary Cache.

Improve Answer

Read Best Answer

Editorial / Best Answer

Answered by: Alok Kumar

• Sep 22nd, 2005

---

Hi,

Database buffers are used to store copy of data of data blocks that has been used recently.the set of database block buffers are called db buffer cache.redo log buffers are used to store temorary entries for redo that supose to written to redo logfiles.

thanks

Alok.

Alok Kumar

• Sep 22nd, 2005

Hi,Database buffers are used to store copy of data of data blocks that has been used recently.the set of database block buffers are called db buffer cache.redo log buffers are used to store temorary entries for redo that supose to written to redo logfiles.thanksAlok.

Improve 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

 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

My platform is Enterprise Linux (RHEL AS4) How to find BLOCK SIZE.

ianilreddy

 Profile Answers by ianilreddy Questions by ianilreddy

• Aug 7th, 2010

IFCONFIG LONG_BIT if we use this command we can find size of block size in os level

Answer Question  Select Best Answer

Hi All,I have a Materialized views Group, on this group I have 57 MVs these are all created on Master data (OLAP) log files and we have dependency schedule to run this jobs. Load dependency is like (MD tabs Then  Log files MVs) this is not a problem with us.For 57 views to get updated (refreshed) in 4 hours in these views one view is taking nearly 2 hours to update. We are updating this group...

 Yes. The advantages over file system files. I/O  will  be  improved  because  Oracle  is  bye-passing the kernnel which writing into disk.Disk Corruption will be very less.

prashatt

 Profile Answers by prashatt Questions by prashatt

• Jun 24th, 2008

Raw devices are controlled by the database engine so the OS kernel can be bypassed when using raw devices. System files reside on filesystem, filesystem is addressed by the kernel. So everytime a data...

Answer Question  Select Best Answer

prashatt

 Profile Answers by prashatt Questions by prashatt

• Jun 24th, 2008

RAM means Random access memory, which is used as a temporary memory space to load Operating system kernel, driver modules and services needed on the system. Whenever you switch off the system all the ...

Answer Question  Select Best 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

What is meant by Shared pool fragmentation.

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...

 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

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

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

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