Most Oracle DBA & Oracle Apps DBAs are already aware that the technology world is moving fast and that is a fact that no one…
Leave a CommentCategory: Database Basics
The parallel hint in Oracle Database is used to specify that a particular query or operation should be executed in parallel mode, using multiple parallel…
1 CommentConverting a database SID from uppercase to lowercase in the Oracle database can be needed sometimes. Below are general steps for converting a database SID…
Leave a CommentSQL Profile and SQL Baseline are both used to optimize the performance of SQL statements in Oracle databases. However, they work in slightly different ways:…
Leave a CommentPL/SQL lock timer wait event in Oracle occurs when a session is waiting for a lock held by another session to be released. This can…
Leave a CommentA Program Global Area (PGA) is a memory region that contains data and control information for a server process. It is non-shared memory created by…
Leave a CommentOracle 19c databases support several different types of indexes, each with its own specific use cases and characteristics. An index in an Oracle database is…
Leave a CommentThe Result Cache is a feature in Oracle 11g and later versions that allow the database to store the results of frequently executed queries in…
Leave a CommentWe have seen “enq: UL – contention” wait event a couple of times in our Oracle Database. It occurs when there is contention for an…
Leave a CommentHigh I/O (Input/Output) activity in an Oracle Database can indicate that the system is under heavy load and this may lead to performance issues. High…
Leave a Comment