Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Dec 7th, 2011

Online backup also known as hot backup / open backup can be performed even the database is open and while users are working and is available for read and write activity. To perform Online backup, the ...

Answer Question  Select Best Answer

Why we use Sort_area_size parameter in init.ora file?Kindly let me know?

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Dec 7th, 2011

SORT_AREA_SIZE is one of the deferred Oracle Server Parameters which is set in init.ora. Its value as bytes (integer) sets the size of in-memory sort work area. The default is 64K and the maximum valu...

Answer Question  Select Best Answer

If have 50 inactive session and i want to to kill all session at once tell me the procedure to kill all 50 session at once

muthu5047

 Profile Answers by muthu5047 Questions by muthu5047

• Sep 3rd, 2011

in our project to kill all the inactive session we use the following script.. run the sql script given below it will give u all inactive sessions sid and serial no and redirect output to (inactive_kil...

Answer Question  Select Best Answer

Harieshsivam

 Profile Answers by Harieshsivam Questions by Harieshsivam

• Oct 13th, 2011

Show sga;

we can see the memory of SGA space

Answer Question  Select Best Answer

mary

• Jun 7th, 2012

Backup can be taken in 3 ways 1)Cold backup 2)Hot Backup 3)RMAN Backup 1)For taking cold backup we need to shutdown database.So it is not advisable 2)Hotbackup can be taken while the DB upon running...

Answer Question  Select Best Answer

I am new here and i am not sure if I am posting this in the correct place. But I have recently started studying to be a programmer but because there is so much out there between these two I am getting more and more confused about how to answer this. Could someone please answer these so I can at least get my head around it all? Thank you!! This is what the questions are:

After initial...

Tom Haughey

 Profile Answers by Tom Haughey Questions by Tom Haughey

• Apr 30th, 2012

I will refer predominantly to Relational DBMS. In a file system, data is contained in a flattened structure that is often a variable length structure. For example, a shipment received could contain th...

Answer Question  Select Best Answer

NEERAJ KHANNA

• Oct 2nd, 2013

Checkpointing is nothing but give the signal / instruction to DBWN process to write the date from the database buffer cache to the datafile and after this ckpt process also update the SCN number in the header of data file and control file also.

FYIP

Answer Question  Select Best Answer

In a given relation R, If an attribute A uniquely define all other attributes, then the attribute A is the key attribute which is also known as

1. Functional key
2. Foreign key
3. Candidate key
4. All of the above

Nandini

• Mar 9th, 2015

Candidate key

Answer Question  Select Best Answer

Akbar Yuldoshev

• Jun 18th, 2016

By allocate_extent_clause

Answer Question  Select Best Answer

What is utlu211i.sql in Oracle DBA in upgrade concepts? Any one explain in detail

Mudassir

• Dec 4th, 2015

It is a utility provided by Oracle to change invalid objects valid

Answer Question  Select Best Answer

How many database writers are available (max) to create in Oracle.

Ayub

• Feb 3rd, 2016

20

Answer Question  Select Best Answer

If I have incremental backup by RMAN of Mon, Tue, Wed and on Thursday Morning our database will crash somehow. Then which day we recover first and how?

Raju

• Nov 24th, 2016

If I have incremental backup by RMAN of Mon, Tue, Wed and on Thursday Morning our database will crash somehow. Then which day we recover first and how?

Answer Question  Select Best Answer

What is the difference between Roll back and Roll forward process?

ashok

• Oct 6th, 2016

Redo is for roll forward that can recover your data from online redolog files (archivelog file) and undo is for rollback of data from undo tablespace within default retention 900s(15 mins)

Answer Question  Select Best Answer

Kindly differentiate Redo, undo, Roll back and Roll forward

musa

• Aug 1st, 2016

Redo is for roll forward that can recover your data from online redolog files (archivelog file) and undo is for rollback of data from undo tablespace within default retention 900s(15 mins)

Answer Question  Select Best Answer

If there was a abnormal termination, upon startup smon performs instance recovery and rolls forward and rollbacks committed and uncomitted transaction. But if this happens before startup the DB files are not open before startup then how does smon carry out recovery.

harshini

• Oct 8th, 2017

Secondary Backup Server

Answer Question  Select Best Answer

habib

• Nov 12th, 2005

Send me questions about databases and certifications tools of databases oracle sqlserver please

Chiranjeevi Manne

• Nov 9th, 2005

FIRST_ROWSLAST_ROWSFIRST_ROWS_10FIRST_ROWS_100FIRST_ROWS_1000ALL_ROWS

Answer Question  Select Best Answer

dhampack

 Profile Answers by dhampack Questions by dhampack

• Nov 24th, 2008

I would say, write more sql statementfor exin join statement if x=y, y=z (you can also add x=z to give more hint to optimizer)

LAKSHMAN CHOWDARY

• Oct 17th, 2005

USING COMMENT LINES WITH (+) SIGN YOU CAN PASS THE HINTS TO SQL ENGINE----------->/* +PARALLEL() */

Answer Question  Select Best Answer

kashyap_aseem

 Profile Answers by kashyap_aseem Questions by kashyap_aseem

• Feb 14th, 2008

In 10g there is a option to lock an acount we can lock system user through this correct me if i am wrong

Ritesh Raj Singh

• Jul 12th, 2006

There is no possibilities of disabling the connection as sysdba because sys is the owner of the database who has all the powers of the database so you can disable the account of sys what u can do is y...

Answer Question  Select Best Answer

Pooja Chaturvedi

• Nov 19th, 2006

Log shipping transfers database dumps and logs from the primary server to the secondary server. As with any warm standby solution, failure detection and failover processing is not automated. When log ...

Baby Sarojini M

• Aug 28th, 2006

I thought of going thru the answers once -- for gaining knowledge

Answer Question  Select Best Answer

How will you find-out if your database is using recovery catalog or not?

Ram

• Jun 20th, 2012

Querying views like rc_database in each catalog will identify the target database it is registered with.

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Dec 7th, 2011

There are few ways through which you would find if your database uses recovery catalog: Check backup scripts and findout if the scripts are making any connection to a recovery catalog. Check tnsnames...

Answer Question  Select Best Answer