When we trace the control file how many datafiles are created?

mbreddy5

 Profile Answers by mbreddy5 Questions by mbreddy5

• Mar 16th, 2009

No data files are created when we trace a control file. Tracing will create a word format of control file with all the information of data base (datafiles, log switching etc).

Answer Question  Select Best Answer

How to convert dictionary managed tablespace to locally managed tablespace?

mohibalvi

 Profile Answers by mohibalvi Questions by mohibalvi

• Mar 14th, 2009

You can use DBMS_SPACE_ADMIN package to convert DMT to LMT. exec dbms_space_admin.Tablespace_Migrate_TO_Local('ts_dm');where ts_dm is the name of tablespace that need to be converted to locally managed tablespace.

Answer Question  Select Best Answer

What difference does it make to a Oracle developer while using RAC ? Would/Should he realise that it is a RAC Database ?

suji

 Profile Answers by suji Questions by suji

• Mar 21st, 2011

It makes no difference for the developer and RAC technology is server side and affects the way DBA do they day to day job. Thanks, Suji

Answer Question  Select Best Answer

What is an Oracle Instance? Where it is present and How does it perform?

prajwal.achar

 Profile Answers by prajwal.achar Questions by prajwal.achar

• Jul 15th, 2009

Oracle Instance is a memory component of Oracle server which is a combination of memory structure and background processes..It is a means to access data in a database i.e., it is a path way to access data.

Answer Question  Select Best Answer

How to detect and prevent row chaining?

Nehasinha

 Profile Answers by Nehasinha Questions by Nehasinha

• Jul 15th, 2009

By increasing the PCT, Row chaining can be avoided.

Answer Question  Select Best Answer

How to drop or delete a datafile which has been miskenly added to a tablespace?

aravindhreturns

 Profile Answers by aravindhreturns Questions by aravindhreturns

• Apr 23rd, 2010

In most environments, this is done using Oracle Import/Export utility since certain privileges are restricted to the DBAs. Steps are below:- 1) Export the data 2) Drop the Tablespace, 3) Import the da...

Answer Question  Select Best Answer

How to see the Database size and version and RMAN size and version?

aravindhreturns

 Profile Answers by aravindhreturns Questions by aravindhreturns

• Apr 23rd, 2010

To find the ORACLE database size, you need to make a small calculation. The result of these two syntaxes below can be used to find the total allocated size of the database:- select sum(bytes)/10737418...

Answer Question  Select Best Answer

What is the purpose of redo log files?

harit79

 Profile Answers by harit79 Questions by harit79

• Aug 2nd, 2009

The purpose of redo log file is to record all changes made to the data during the recovery of database.It always advisable to have two or more redo log files and keep them in a  seperate disk, So you can recover the data during the system crash.

Answer Question  Select Best Answer

How to restore the control file by using RMAN backup?

aravindhreturns

 Profile Answers by aravindhreturns Questions by aravindhreturns

• Apr 22nd, 2010

Use these two methods to get the control file from autobackup:- (This applies only if you have configured AUTOBACKUP ON)One:-First, Login to RMAN (RMAN Target /)Set the DBID by querying v$database (SE...

Answer Question  Select Best Answer

What is PCT free and PCT used?

Prabhat Sahu

 Profile Answers by Prabhat Sahu Questions by Prabhat Sahu

• Oct 15th, 2018

-- PCTFREE , PCTUSED and High Level Watermark in datablock: ------------------------------------------------------------------------------ --> HLW is a term used with table segment in DB to show the...

Answer Question  Select Best Answer

What is PCT increase parameter in segment?

S. Lee

• Mar 9th, 2015

The percent increase in size of each subsequent extent that is added to your segment as it grows. Table test1 was created and is 4K in size. Initial size is set to 1K and pct increase set to 5. Once t...

Answer Question  Select Best Answer

What does Error 0600 mean?

ashokgaddipatidba

• Oct 15th, 2012

These are the internal errors. we have to contact Oracle Support

Answer Question  Select Best Answer

Amrut Swagat Dwivedy

• Apr 18th, 2014

These are different types of upgraded tools

Answer Question  Select Best Answer

Can Multiple Database access one Instance ?
Yes or No ? Explain

Swathika

• Apr 22nd, 2015

Yes. You can use dblink to connect to multiple DB in same instance

Answer Question  Select Best Answer

Sakshi

• Feb 21st, 2016

With Blenders, you can perform these actions:
l Process adds, moves, or deletes to an existing hierarchy
l Process activations and promotions (leaf to limb)
l Act upon any combination of hierarchies
l Create new hierarchies
l Map top nodes from a source hierarchy to nodes in a target hierarchy.

Answer Question  Select Best Answer

Is it possible to autoextend on option for two datafiles of same tablespace? How?

Dipika

• Aug 8th, 2016

Yes, a tablespace can have 2 datafile which is having autoextend on option

Answer Question  Select Best Answer

If a table contains 2 million rows, consider the below scenarios?
- DELETE command to delete just few rows in a 2 million row table.
- TRUNCATE command (will obviously deletes 2 million rows)
Which is faster. Truncate or Delete?

Mayur

• Jan 25th, 2017

Truncate will be faster as there is no condition to check however with delete it will go through the 2 million records to find which ones fit the condition.

Answer Question  Select Best Answer

Scenario: I forgot to Close the Cursor in PL/SQL block. I executed the block successfully. Again I am going to execute that block without Closing the cursor. An error will be thrown or not?

M Shaun Varney

• May 14th, 2017

That depends. If the cursor is declared inside the block in question, it will be automatically closed when the block ends and you will not get an error when you open it again. However, if the cursor ...

Answer Question  Select Best Answer

When and for what purpose do we use refcursor instead of other data type?

• May 28th, 2017

Refcursor or cursor variable....is used in scenarios when you need to pass on data (as variable) between two calling programs. The data can be a result set or singular value too.

Answer Question  Select Best Answer

CREATE OR REPLACE PACKAGE XX14_SO_INBOUND_PKG AS PROCEDURE main ( x_errbuf OUT NOCOPY VARCHAR2 , x_retcode OUT NOCOPY NUMBER , p_data_file_path IN VARCHAR2 ); END XX14_SO_INBOUND_PKG;

In above procedure what is the use of NOCOPY...?

Sasirekha

• Jan 8th, 2018

NOCOPY is used to pass the out variables also by reference

Answer Question  Select Best Answer