rakesh

• Aug 4th, 2017

Server Process

Rammy

• Jul 13th, 2017

Exactly server process invoke and write data from datafiles to database buffercache..

Answer Question  Select Best Answer

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

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

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

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

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

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

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

 The set of objects owned by user account is called the schema.

Sriniv@s..

• Jun 20th, 2012

Schema is a set of objects own by a Particular user..

msabuu

 Profile Answers by msabuu Questions by msabuu

• Nov 6th, 2007

Schema is collection of database object.

Answer Question  Select Best Answer