October 2021 - ASRblogger

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 character value to another.…

asrblogger October 24, 2021No Comments

Oracle

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 are permitted. Use of Control…

asrblogger October 21, 2021No Comments

Cloud

Protected: Workshop: Generative AI Resources

This content is password protected. To view it please go to the post page and enter the password.

asrblogger October 15, 2021

Oracle RAC

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 shared_pool so that new (or old)…

asrblogger October 10, 2021No Comments

Oracle

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 data structure that indicates…