The pattern-matching conditions compare character data. LIKE Condition * The LIKE conditions specify a test involving pattern matching. Whereas the equality operator (=) exactly matches one character value to another. * The LIKE conditions match a portion of one character value to another by searching the first value for the pattern specified by the second. … Read more
The database control file is a small binary file associated with only one database. Each database has one unique control file, although multiple identical copies are permitted. Use of Control Files Oracle Database uses the control file to locate database files and to manage the state of the database generally. A control file contains information … Read more
If you flush the shared pool, all the statements in cursor will be flushed. Sometimes it is required to flush the bad SQL_PLAN from shared_pool so that new (or old) better execution plan can be picked by SQL_ID So if you want a SQL query to do hard parsing, then you can flush the particular … Read more
A checkpoint is a crucial mechanism in consistent database shutdowns, instance recovery, and Oracle Database operation generally. The term has the following related meanings: • A data structure that indicates the checkpoint position, which is the SCN in the redo stream where instance recovery must begin. The checkpoint position is determined by the oldest dirty … Read more