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

onkar

• Sep 28th, 2005

exceptions can be handled in various ways in the stored procedures. Method (1) could be using EXCEPTION block in the procedure within which use WHEN <exceptionname> THEN. Method (2) could be dec...

Answer Question  Select Best Answer

cmanne

 Profile Answers by cmanne Questions by cmanne

• Jul 29th, 2006

it aviods fragmentation.

Answer Question  Select Best Answer

Lalit Chhimwal

• Aug 6th, 2006

buffer busy wait is the condition in which oracle server has to wait to access the segment header block for the table on which concurrent insert or delete operation r to be done.the segment header blo...

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

what is Referential Backup? Which case we use Referential Backup and which case we use Incremental backup?

Turn three of your Scarlett Talent Agency entities into relations.

Why the Standard Oracle supplied JDBC driver cannot be used when using a Real Application Cluster?Decribe the differences between an Oracle Real Application Cluster and Oracle Deployed in a Sun Cluster?

In Oracle RAC 3-node environment, If one node is down then how will the sessions balance among the remaining two nodes?

Give an example of a good database mission statement, and a bad database mission statement?

For this assignment task you will design a database for capturing student’s assessments marks and estimate the required amount of space.

Suppose we suppose that there are 5000 students at our institution and that on average each student registers for 5 courses in a semester design a database that can be used to capture the registration of courses and eventual capturing of a maximum...

What are the prerequisite we should before doing any alter of table in db2 database?