What is the solution if some users are encountering slow performance in production db?

Abbey

• Feb 16th, 2018

Scan for virus first

Shalu

• Dec 4th, 2016

Check the query that is running in database, try to optimize the query by using correct hint and indexes"oracle8 SELECT department_id, last_name, salary FROM employees WHERE ...

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

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

Akbar Yuldoshev

• Jun 18th, 2016

By allocate_extent_clause

Answer Question  Select Best Answer

Akbar Yuldoshev

• Jun 18th, 2016

Oracle Enterprise Manager

malli

 Profile Answers by malli Questions by malli

• Aug 1st, 2015

SQL Loader

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

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

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

Which process creates parsing?

himaVemula

• Nov 18th, 2014

Hard parse is the process that creates parsing

sharmme

 Profile Answers by sharmme Questions by sharmme

• Feb 17th, 2010

Server process dedicated to the user both in shared and dedicated server connection configuration.

Answer Question  Select Best Answer

Amol Patil

• Sep 14th, 2014

DBMS: Collection of data in one particular or single table.that is not related to other data object.

RDBMS: Relation between two or database table or the entity of number of database is relate to each other is known RDBMS.

sandeep

• Feb 12th, 2007

In DBMS tables are not related. In RDBMS tables are related In DBMS only one user can access the same database, at the same time. In RDBMS many users simultaneously access the same database RDBMS is m...

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

What is a waterfall testing?

qaisar khan umraj

• Aug 12th, 2013

In waterfall we each step check 1st and last time means only one time we checking never take back checking never
we can repeat any previous steps

Answer Question  Select Best Answer

What is mean by fractured block in terms of manual hot backup?

ganesh

• Mar 12th, 2013

In case of hot backup we get fractured blocks, because of this reason hot backups is called Inconsistent backup. let say in hot backups our operating system copies OS block by OS block while copy is g...

alok83

 Profile Answers by alok83 Questions by alok83

• Apr 11th, 2008

The concept of fractured block occrus when backup is under process.It means you are taking backup and some other session is updating it.Then backup process can not get the consistent image of the block and it will be inconsistent right thats why it is called fractured block.

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

RAM

• Jun 20th, 2012

- - - - -
| | | | |
| | | | +----- Day of week (0-6)
| | | +------- Month (1 - 12)
| | +--------- Day of month (1 - 31)
| +----------- Hour (0 - 23)
+------------- Min (0 - 59)

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

Chintan

• May 29th, 2012

DDL is Auto Commited Statements.

cmanne

 Profile Answers by cmanne Questions by cmanne

• Mar 25th, 2007

There is no need to issue commit command after executing DDL statements as the DDL statements are commited automatically

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