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

How to insert records into Oracle db table if I got error while inserting 4th record then how to insert 5th,6th.... records continuously

Sunil Borra

• Sep 6th, 2018

I am pretty sure that unless you correct the 4th rec or remove it altogether from all the other inserts you would not make past the 4th insert. How are you inserting the data by the way?

Answer Question  Select Best Answer

How to find out the max high value using varray?

Kaushik Nayak

• Jan 19th, 2018

Code
 

Answer Question  Select Best Answer

gyanudba

 Profile Answers by gyanudba Questions by gyanudba

• Jul 29th, 2011

We can not delete responsibillity but we can disable the responsibility from user so that user can not use this resp he is not authorised to use particular responsibility.

psicre

 Profile Answers by psicre Questions by psicre

• Jul 22nd, 2010

You cannot delete reps in EBS....

Answer Question  Select Best Answer

aStewart

 Profile Answers by aStewart Questions by aStewart

• Feb 23rd, 2010

The index status can be found in the dba_indexes, dba_objects, or the equivalent  user_ view. The possibilities are VALID, INVALID, UNUSABLE, or N/A.  Invalid or unusable indexes will not be...

Asim Jamal

• Apr 13th, 2006

The current status and details of an index could be accessed by system table sys.dba_indexes. The status could be VALID,INVALID,N/A.The invalid indexes unnecessarily occupies the space in a Tablespace.

Answer Question  Select Best Answer