ORA-12842: Cursor invalidated during parallel execution

Question Posted / guest

2 Answers
29644 Views
ACC, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

ORA-12842: Cursor invalidated during parallel execution..

Answer / guest

Cause: The cursor was invalidated during the parse phase of
deferred parallel processing, e.g. when set operands are
parallelized.

Action: Depends on why the cursor was invalidated. Possible
causes include DDL on a schema object and shared pool being
flushed.

Please add more information about this Error

Is This Answer Correct ?

7 Yes

1 No

ORA-12842: Cursor invalidated during parallel execution..

Answer / prepareinterview

1. What are the components of physical database structure of
Oracle database?
Oracle database is comprised of three types of files. One or
more datafiles, two are more redo log files, and one or more
control files.

2. What are the components of logical database structure of
Oracle database?
There are tablespaces and database's schema objects.

3. What is a tablespace?
A database is divided into Logical Storage Unit called
tablespaces. A tablespace is used to grouped related logical
structures together.

4. What is SYSTEM tablespace and when is it created?
Every Oracle database contains a tablespace named SYSTEM,
which is automatically created when the database is created.
The SYSTEM tablespace always contains the data dictionary
tables for the entire database.

5. Explain the relationship among database, tablespace and
data file.
Each databases logically divided into one or more
tablespaces one or more data files are explicitly created
for each tablespace.

Check out for more...

http://www.prepareinterview.com/tips/questiondatabase.asp

Is This Answer Correct ?

2 Yes

3 No

Post New Answer