Fabio

• Jun 9th, 2015

You do not use it anymore, you would have to use it in old Oracle versions when you did not have RMAN!

Sriniv@s..

• May 23rd, 2012

In case of hot backup,table space is put into backup mode.At the time ts related datafile header is frozen
because for taking backup with out any data loss.And after that any data is coming,that one going to redolog file for recovery.

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

nunesrinivas

• Mar 25th, 2015

Select sum

Nadeem

• Feb 12th, 2015

Select sum(bytes)/1024/1024/1024 AS sizeGB from dba_data_files;

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

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

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

Carlos Andr?s Morales Machuca

• Sep 24th, 2014

Is a connection with another database, usually other database Oracle, but is possible with other brand using Heterogeneous Services.

Abhinav

• Nov 5th, 2012

A database link is a path to another database with the help of which a user can access the schema objects of later database.

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

syed fahad

• Sep 13th, 2014

Kill -9 (process id)
we can check the process is with the help of (ps -ef |grep pmon)

hemu

• Mar 15th, 2014

Kill -9 (process id)
pkill (process name)

Answer Question  Select Best Answer

How would you plan for an Oracle upgrade? What are the prerequisites?

deepak subramoniam

• Aug 3rd, 2014

Ensure the nls Characterset of the parent and child database are same
Ensure the editions of both the database are same.
Ensure UTL_SMTP,UTL_HTTP,UTL_FILE Packages are available. (for 10g to 11g se)
wm_concat needs to be changed in the 11g because in 11g the function will not be supported by Oracle

rohith

• Jul 21st, 2014

if u want to any up-gradation in oracle first we need to check version compatibility like if u want to upgrade from 10g to 11g the 10g version should be 10.2.0.4 or 10.2.0.5. then install the 11g sof...

Answer Question  Select Best Answer

In exception handling we have some NOT_FOUND and OTHERS. In inner layer we have some NOT_FOUND and OTHERS. While executing which one whether outer layer or inner layer will check first?

AK Badola

• Dec 17th, 2012

Inner layer

Answer Question  Select Best Answer

Nony

• Oct 7th, 2012

Alter table move tablespace USERS

chandrasekar.s

• Jun 1st, 2012

Using alter table command we can move one table from one schema to other

Code
 

Answer Question  Select Best Answer

hanuman

• Sep 4th, 2012

View does not consume space and materialized view consume space

manoj100

 Profile Answers by manoj100 Questions by manoj100

• Aug 26th, 2012

A view is a simple select statement executed each time user runs query against it A materialized view is a physical persistent object used for performance improvement of summary data or replication. ...

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

Code
 

will give the required result.

Wildy

• Jul 18th, 2011

Select instance_name, status, database_status, startup_time from v$instance;

Answer Question  Select Best Answer

venu

• Sep 1st, 2012

The transportabel tablespaces enable us to transport data objects across different platforms.

Backing up or recovering a particular user/schema objects or data objects or tablespaces or entire databases is possible, which cannot be done using other backup techniques.

Sriniv@s..

• Jun 2nd, 2012

Moving data using transportable tablespace can be much faster than performing either export/import or unload/load of the same data.Bcz transporting a tablespace only requires the copying of datafiles & integrating the tablespace structural information.

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

iv4122

• Jul 3rd, 2012

Using the storage options can bring further performance gains by using the techniques available for regular tables, including parallel option, partitioning or nologging for the table that holds the materialized view data.DRDPW

Sriniv@s.

• May 11th, 2012

Materialized views are useful for fast REPLICATION purpose..

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