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

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

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

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

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

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

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

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

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

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

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

What is the difference in Oracle 10g and 11g Architecture

rahul

• Sep 25th, 2015

Simplified and improved automatic memory management etc.

Munender Singh

• Sep 13th, 2015

There are about 9-10 differences. Some of them are here: 1. The memory tuning feature is there in 11g. 2. Automatic diagnostic Repository infrastructure to prevent, detect, diagnose, and help resolve...

Answer Question  Select Best Answer

How to collects the "current" redolog members(redo group) if these are physically deleted. There is no backup and NARCHIVELOG mode in database

Mohammed irfan Hussain

• Feb 8th, 2016

The moment you start the instance the smon gets started and collects redolog member data to datafiles. i,e crash recovery.

Answer Question  Select Best Answer

Please Give any scenario (Or) example of its very help full?

Somesh Menaria

 Profile Answers by Somesh Menaria Questions by Somesh Menaria

• Feb 22nd, 2016

It is used to improve quering performance

Arjun

• May 29th, 2015

Materialized view is an option when we have data coming on a regular fashion in slots like last weeks data that will be used this week and data is too huge to generate at any point of time this is jus...

Answer Question  Select Best Answer

what will happen after checkpoint ?
i means .. dbwr write or redo log entries like that .. i am asking..

Somesh Menaria

 Profile Answers by Somesh Menaria Questions by Somesh Menaria

• Feb 22nd, 2016

When checkpoint occurs the datafiles and control file header are updated and also dbwr writes dirty buffer to datafiles checkpoint give the signal.

ahmed

• Jul 11th, 2015

Whenever switch log occur, checkpoint event will occur, and ckpt event will invoke checkpoint process, then ckpt process will generate SCN No. for specific transaction, and that SCN info will be load into control file and SCN No. writes into data file header, and invoke to dbwr.

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

Temp table running out of space, What will you do?

Suresh Borse

• Apr 8th, 2016

Add the tempfile to temp tablespace.

amjath

• Mar 11th, 2016

Check the temp tablespace usage and kill inactive sessions or contact high space usage users to kill their sessions.

Answer Question  Select Best Answer

User failed to connect database due to tnsnames, what activity you are going to do?

hunk

• Aug 3rd, 2016

Ensure listener is up and running on the server, lsnrctl status SID

Tammy Harte

• Jul 6th, 2016

1) Verify tnsnames.ora file exists
2) Ensure its in the correct folder $ORACLE_HOME/network/admin
3) Ensure listener is up and running on the server, lsnrctl status SID
4) Tnsping SID to verify response / can also putty to host db server and run cmd: ps -ef |grep -I tns

Answer Question  Select Best Answer

Rahul Gupta

• Aug 8th, 2016

OWNER TRIGGER_NAME TRIGGER_TYPE TRIGGERING_EVENT TABLE_OWNER BASE_OBJECT_TYPE TABLE_NAME COLUMN_NAME REFERENCING_NAMES WHEN_CLAUSE STATUS DESCRIPTION ACTION_TYPE TRIGGER_BODY CROSSEDITIO...

ANIL

• Dec 13th, 2011

ABOUT TRIGGERNAME,
OWNER,
TRIGGERTYPE,
TRIGGEREVENT,
TABLEOWNER EXC
information is stored in DBA_TRIGGERS.

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