vikram singh

• Jun 27th, 2015

In this situation there are some condition 1) There is any locking on table. 2) Full table scan. 3) Any other process is also hitting on same table. 1) First we check the table locking a. Table le...

Fabio B

• Jun 9th, 2015

If the same query is slow you need to analyse the following: 1) Did the path changed? Check actual path vs previous path is possible? 2) Does the table have more data and the full scan or other thing ...

Answer Question  Select Best Answer

1) How to install patches? And what are pre-requsites?
2) How to upgrade 10.2.0.1 to 10.2.0.4 AND 11.2.0.1 to 11.2.0.3 and 10.2.0.4 to 11.2.0.1?
3) How to take the backup of oracle_home and oracle_inventory?
4) What is OCR & voting disk?
5) How to take backup of OCR and voting?
6) Which one take backup if OCR and voting disk?
7) Suppose lose OCR what happen...

Sanjay Srivastava

• Feb 9th, 2017

We can take backup of OCR file.
ocrconfig -manual backup;

alekhya kumari

• Sep 22nd, 2016

# cat /etc/issue -os name & version of os. when we start a database its version is shown

Answer Question  Select Best Answer

hmounir

 Profile Answers by hmounir Questions by hmounir

• Dec 27th, 2009

The datafiles in an Oracle database are grouped together into one or more tablespaces. An Oracle tablespace consists of one or more datafiles; a datafile can be a part of one and only one tablespace.Schema can own any type of object in the database: Indexes, Sequences, Views, so forth.

imran44

 Profile Answers by imran44 Questions by imran44

• Jan 9th, 2009

The database is actually a collection of objects, which are made up of tablespaces and each tablespace must have datafile associate with it. The tablespace cannot be created without datafile. The tabl...

Answer Question  Select Best Answer

cmanne

 Profile Answers by cmanne Questions by cmanne

• Sep 2nd, 2009

During the design phase of database, The tablesapce size is estimated by calculating the size of typical row of various tables that are going to reside in that tablespace multiplied by the number of e...

cmanne

 Profile Answers by cmanne Questions by cmanne

• Sep 2nd, 2009

Select tablespace_name, sum(bytes)/1024/1024fromdba_data_filesgroup by tablespace_nameorder by tablespace_name;

Answer Question  Select Best Answer

Explain what are Oracle Catalog and Oracle Archive log?

Sriniv@s..

• May 23rd, 2012

Oracle catalog contain the metadata of objects.
RMAN catalog maintain the backup information.
Redo data persistently stored in archive logs,for recovery..

pandish

 Profile Answers by pandish Questions by pandish

• Dec 31st, 2010

Catalog term is used in 2 ways.Catalog - All tables/views stores information about database and all objects in it.RMAN Catalog - Schema where RMAN executable stores/reads/writes the information about ...

Answer Question  Select Best Answer

What is the difference between startup mount and startup nomount? when its used?

Sharif AlSiouri

• Mar 1st, 2015

Startup nnomount: Oracle will read the initialization parameter file (SPfile or PFile) to allocate the memory structure ( SGA ) and to run the Background processes, this is used to create the database...

AMRUTDHASKAT

• Feb 27th, 2015

At first,database is at rest. After startup nomount,Oracle 1st read parameter file,start background processes then allocate memory . then it reads controlfile and take the database in mount state. I...

Answer Question  Select Best Answer

Vla Su

• Feb 2nd, 2015

Dump control file into text what is the usage

Code
 

syed fahad

• Sep 13th, 2014

Control file which stores all information of database like
1)Name and location of datafile and redo logfile
2)Scn number information
3)Db_name information
4Checkpoint information

Answer Question  Select Best Answer

Manoranjan Dash

• Sep 18th, 2017

Query the v$session table.

Albert Z

• Mar 31st, 2015

SELECT SYS_CONTEXT (USERENV, HOST) from dual;

Answer Question  Select Best Answer

kirankumar c.s

• May 26th, 2012

Server process

baala

 Profile Answers by baala Questions by baala

• Aug 11th, 2008

DBWR only writes to the data files. So the answer is Server Process.

Answer Question  Select Best Answer

Shubham

• Oct 7th, 2016

No,
We can not give more then 32 column primary key

Somesh Menaria

 Profile Answers by Somesh Menaria Questions by Somesh Menaria

• Feb 22nd, 2016

Server process write data from datafiles to buffer cache

Answer Question  Select Best Answer

Can you take online backup of a Control File If yes, How?

venu

• Sep 1st, 2012

Code
 

Specify the path where you want to store the controlfile backup.

neha.awasthi1

 Profile Answers by neha.awasthi1 Questions by neha.awasthi1

• May 18th, 2011

We can do this by suding RMAN:configure control file auto backup on;

Answer Question  Select Best Answer

doc123

 Profile Answers by doc123 Questions by doc123

• Mar 22nd, 2012

Logical Structure of Oracle is following.

Tablespace =>Schema => Segments => Extent => Oracle Block. (Remember Oracle block is smallest logical unit).

csanthoshreddy

 Profile Answers by csanthoshreddy Questions by csanthoshreddy

• Mar 6th, 2012

The logical components of database are tablespaces, segments, extents, datablocks. datablock is the smallest unit of oracle I/0.

Answer Question  Select Best Answer

I have applied the following commands:Shutdown abortstartupNow what will happen, will the database will give an error / it will work.

Mohammed Nadeem

• Feb 12th, 2015

There will be the mismatch with SCN in header combining with Datafiles and controls files hence needed instance recovery which is automated by SMON

Mohammad Mubasheer Ahmed

• Jan 26th, 2015

Database will be down abruptly without writing the committed data to data files. When it is brought up, SMON will automatically perform instance recovery be scanning the online redo log files.

Answer Question  Select Best Answer

How many max datafiles can there be in an Oracle Database.

Mohit tayal

• Mar 20th, 2016

Max. database file per database is 65533.
Max. Datafile per tablespace 1022

Somesh Menaria

• Feb 22nd, 2016

In 11g we can use 1022 datafiles

Answer Question  Select Best Answer

vanithaananth

 Profile Answers by vanithaananth Questions by vanithaananth

• Jun 24th, 2011

Physical structures of oracle database consists of datafiles,controlfiles redologfiles and archivelogfiles...

dj_dj_dj

 Profile Answers by dj_dj_dj Questions by dj_dj_dj

• Feb 18th, 2010

Dear,             Oracle Physical Database Structure consist of Datafiles, Controlfile  & Online Redo Log files.    ...

Answer Question  Select Best Answer

syed fahad

• Sep 13th, 2014

Yes we can start the database ( pfile is a txt file and spfile is a binary file in 9i spfile is not used by oracle only pfile is maintain to start the database )

Saddam Mulla

• Mar 3rd, 2014

Yes we can start oracle database without spfile but required pfile
(Spfile is a system file and pfile is a manual crest file)

Answer Question  Select Best Answer

Fabio

• Jun 9th, 2015

On 11gR2 I would set automatic memory management MEMORY_TARGET=XX, then I would look on OEM the behavior of the memory and set the SGA and PGA accordingly the usage.

Camara

• May 7th, 2015

Sga_target and the sga_max_trget?

Answer Question  Select Best Answer

venu

• Sep 1st, 2012

SCN is generated by oracle when a transaction is successfully commited. This is referred to as SystemChangeNumber. We can think of it as a transaction id generated when we make some transaction in an ...

SANTHOSH

• Aug 15th, 2012

SCN no is a number which is generated by the oracle, when we made any changes to the data that statements will be recorded in redo log files and every committed statement will be given this SCN no by oracle.

Answer Question  Select Best Answer

Ashok

• Jul 13th, 2017

Tablespace is a logical storage device, the database stores the data physically in datafiles and logically in tablespaces

NARESH NADHAN

• May 4th, 2016

Simply I say DATABASE is divided into some logical storage units that is called TABLESPACE.This is logical storage.And a TABLESPACE can have 1024 datafiles.

Answer Question  Select Best Answer

Amitkumar S Solanki

• Oct 17th, 2014

SPFile is dynamic file and PFile is static

syed fahad

• Sep 13th, 2014

PFILE is a txt file and SPFILE is a binary(when u freshly create a database first database is read spfile after we open the database it will create pfile with the help of this command : create pfile from spfile)

Answer Question  Select Best Answer