Home 2021 October

Monthly Archives: October 2021

white ruled notebook

LIKE Operator : Pattern-matching Conditions

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...
a red xbox game controller and an uno card

Control files in Oracle (Physical Storage)

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...

Flush SQL Statement from Shared Pool

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...
red check mark on box in close up view

Overview of Checkpoints !!

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...