ORA-12842: Cursor invalidated during parallel execution
Answers were Sorted based on User's Feedback
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 |
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 |
ORA-00029: session is not a user session
IMG-00523: invalid process verb
PLS-00459: this feature is not allowed in REPEATABLE subprogram
PCB-00553: FOR clause not allowed on this statement
NNL-00212: Cache checkpointing is now disabled
RMAN-06531: CHANGE ... KEEP not supported for incremental BACKUPSET
NCR-03023: NCRO: Cannot receive the break
RMAN-06033: channel string not allocated
SQL-02105: Inconsistent cursor cache. Global cursor not found
ORA-23290: This operation may not be combined with any other operation
ORA-06318: IPA: Local maximum number of connections exceeded
NNO-00322: statistic counter dump interval changed to number seconds