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

 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

 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

 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

 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

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

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

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

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

 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

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