Oracle Archives - Page 4 of 30

Better error messages in Oracle 23ai !!

Hey Folks !! With the enhancement in Oracle 23ai features one of the beautiful thing which we can see is to get a descriptive error messages which was not present…

asrblogger August 16, 2024No Comments

Oracle

Enhanced Querying: Eliminating the “FROM DUAL” Clause in Oracle Database 23ai !!

Hey Folks !! Oracle Database 23c, the latest long-term support release, brings over 300 new features, with a focus on three key areas:1. AI for Data2. Dev for Data3. Mission-Critical…

asrblogger August 16, 2024No Comments

Oracle

What is the difference between Prepatch and Postpatch in Oracle Patching !!

Hey Folks !! In Oracle patching, the terms prepatch and postpatch refer to specific sets of tasks or procedures that need to be performed before and after applying a patch…

asrblogger August 14, 2024No Comments

Oracle

How to identify the top Wait Events within a Wait Class in Oracle ??

Each wait event in Oracle belongs to a specific class. Below is a breakdown of the various wait classes and their descriptions:1. Administrative These waits occur due to DBA commands…

asrblogger August 14, 2024No Comments

Oracle

Calculate the necessary disk space for an Oracle EXPORT backup !!

Size of the Data: Determine the size of the database objects you intend to export. This includes tables, indexes, and other database structures. Compression: Decide whether you'll use compression during…

asrblogger August 14, 2024No Comments

Oracle

How To export a table with specific columns in Oracle !!

Hey Folks !! Today I have received a client requirement regarding exporting few columns from a table in Oracle 19c. Here are three methods you can use to achieve this:1.…

asrblogger August 10, 2024No Comments

Oracle

Create Service Request (SR) in My Oracle Support (MOS) !!

Hey Folks !! Today I will guide you towards the process of raising Oracle SR via metalink website or also known as My Oracle Support. There are several reasons why…

asrblogger August 3, 2024No Comments

Oracle

PostgreSQL Interview Question !!

Hey Folks, The objective of this blog post is to guide you through out the questionnaire that is being asked now a day from interviewer regrading Postgres Database. Below are…

asrblogger July 20, 2024No Comments

ASM Core DBA Oracle

ORA-1654: unable to extend index in tablespace

From Alert logs ORA-1654: unable to extend index SCHEMA.IN021S1 by 128 in tablespace TBS_012024-03-23T16:26:11.156475+05:30ORA-1654: unable to extend index SCHEMA.IN021S1 by 128 in tablespace TBS_012024-03-23T16:26:19.194628+05:30 Find the status of tablespace details…

asrblogger July 9, 2024No Comments

Core DBA DataGuard Oracle

Command to Check Archivelog Size

Oracle databases maintain a detailed history of all changes made to the database through archived redo logs, commonly known as archivelogs. These archivelogs are crucial for data recovery and are…