Effective partition management is a game-changer for Oracle databases, especially when dealing with large volumes of data. It not only simplifies maintenance but also boosts performance by organizing data into manageable chunks. In this guide, we’ll walk through the practical steps oracledbhelp used to implement partitioning, automate routine tasks, and ensure the database remains efficient and scalable.
Learn DBA : A Life Long Learning Experience
Sharing knowledge is the ultimate key to gaining knowledge..
The only two things that stay with you for life
are you & your knowledge !
Live while you can!
Teach & inspire while you could &
Smile while you have the teeth.. 😉
-
ASM
- Creating ASM Instance and diskgroups manually without DBCA
- 20 ASM Realtime | Interview Questions
- How to make a cold backup for database running on ASM ( using RMAN )
- Moving a Single Datafile from File System to ASM System (METHOD 1)
- Moving a Single Datafile from File System to ASM System (METHOD 2)
- Things to consider while adding new disk/ Rebalancing existing Disk Group
-
Dataguard
- Dataguard Modes
- Dataguard Modes - II
- Oracle DataGuard Setup
- invalid archived log deletion policy
- recover from the Loss of a Datafile on a Standby Database ?
- MRP terminated with ORA-00600: internal error code, arguments
- Recover archive gaps in standby database - using 2 methodss
- Gap Resolution in Dataguard
- Convert Physical Standby to Snapshot Standby and Vice Versa
- Re-create Redo-logs on Standby/ Primary
- Pre-check for DataGuard switchover Process
- ORA-19815: WARNING: db_recovery_file_dest_size
- How do you purge old archivelogs which are applied on Standby DB
- Pre-check For SWITCHOVER using DG Broker
- https://oracle-dba-help.blogspot.com/2016/03/data-guard-modes.html
- ORA-01274 : RENAME THE UNKNOW FILE IN THE STANDBY DATABASE
- Database Creation in Easy 6 Steps
- Oracle Networking
- Tablespace management
- Housekeep : Quick Tips for DBA
- Health check for DB
- ORA-12537 While Connecting To Database Via Listener
- How to identify the applied patche-set of your Oracle Home
- Accessing a schema without knowing the password
- ORA-12505: TNS:listener does not currently know of SID given in connect descriptor
- Session Related Scripts
- How to check ORA Error on DB Server – Beginner Tip
- Working with Redo Logs
- Decommission of Oracle Database
- Roles in Oracle - Managing Users
- Oracle Release Number Format
- Troubleshooting Handy-Guide
- Understanding the Upgradation Process
- Query to find the session creating more redo
- Audit in Oracle
- Troubleshooting Internal Errors and Error-Look-up Tool on MOS
- Troubleshooting Issues with Undo Tablespace
- User Management
- User Management - II
- Data Pump Gets Better
- MEMORY_TARGET Parameter
- Oracle 21c: INCLUDE and EXCLUDE in Data Pump
- Behind the Scenes of COMMIT
- Data Guard Redo Transport Encryption
- Oracle 19C with ADG DML Redirection
- 19c PDB Refreshable Clones
- Solving the Mysterious Database Connection Timeouts
- How to identify the applied patche-set of your Oracle Home
- Topic need to get clear to become expert in Oracle DBA
- Working with Redo Logs
- Oracle Database Block corruption
- What happens during Instance Recovery
- Oracle Datapump Scenarios
- Troubleshooting Issues with Undo Tablespace
- General Tips to Prepare for an Oracle DBA Job Interview
- RMAN Questions
- Installing PostgreSQL Server on CentOS, RHEL 6 / 7 Systems
- Creating a database in Postgres
- Initialize multiple Postgres instance on the same RHEL server
- How to stop starting of clusters while starting up services
- Setup a streaming replication
- Switchover- master server and warm standby (with streaming replication)
- All About Physical Replication and Log shipping
- PostgreSQL Upgrade and troubleshooting
- Timeline Switch issue
- Query to identify the lag in replication
- Drop table : ERROR: must be owner of relation table_name
- PgBadger
- PgCenter
- PgTune
- Internals of Toast Table
- Influencing Query Execution Plan
- Create Extension ERROR
- Find Uptime in PostgreSQL
- Set DB Timezone
- Clear RAM Cache, Buffer
- Read-Only User in Postgres
- Everything you need to know about Streaming Replication
- Ora2Pg Migrate Oracle to Postgres
- Total Page Cost
- PostgreSQL 13 - Everything you need to know
- Startup Failure - .conf file
- All About Postgres Upgrade
- Basic Guide
- Session Related Scripts
- AWR :: Beginners Guide
- All About ASH - Active Session History
- Wait Events : checkpoint busy waits or archiver busy waits
- Find sessions performing sort operations : TEMP Tablespace occupants
- Generate ADDM task and generate its report for Tuning
- Database Performance Tuning Scripts -Keep Handy
- Buffer Busy Wait
- Simulating the Deadlock
- Latches
- Steps to Schedule any RMAN Jobs In Windows Server
- ORA-01194: file 1 needs more recovery to be consistent
- Loss of Current Online Redo-Log
- RMAN "baby Steps"
- Recovery of ControlFiles
- Loss of Datafile
- Recovery from complete loss of all online redo log files
- Block Change Tracking
- RMAN Questions
- Instance Recovery
- Redundancy and Recovery window in RMAN
- Cold Backup
- Database Cloning
- Contact
- Drop Database using RMAN
- PITR to older Incarnation
Monday, 28 July 2025
Sunday, 6 July 2025
Effortless Database Maintenance with Oracle Fleet Patching and Provisioning
Oracle Fleet Patching and Provisioning (FPP), previously known as Rapid Home Provisioning (RHP), is a powerful feature introduced in Oracle 19c designed to streamline and automate the software lifecycle management process. FPP simplifies the mass deployment, patching, and upgrading of Oracle software, offering a centralized approach to managing Oracle Homes, databases, and clusters. Whether you're handling Oracle Grid Infrastructure (GI) or databases from version 11g onwards, FPP provides the tools to efficiently manage these environments.
Core Features of Oracle FPP
- Zero-Downtime Oracle GI Patching: For RAC databases with two or more nodes, FPP allows patching to be performed with zero downtime, ensuring continuous availability during maintenance operations.
- Automated PDB Relocation: This feature optimizes patching by enabling individual Pluggable Databases (PDBs) to be relocated and patched more efficiently, reducing the overall impact on the system.
- Support for Oracle Restart: Starting with Oracle 19c, FPP facilitates patching and upgrading operations for Oracle Restart configurations, enhancing its versatility across different Oracle setups.
- Direct Transfer Method: From version 19c onwards, FPP eliminates the need for temporary NFS mount points for software home transfers, making the process more straightforward and reducing setup complexity.
- Local Mode Automation: Introduced in Oracle 18c, FPP enables the automation of database and GI home updates in a local mode, removing the necessity for an FPP server or client within the architecture.
- Zero-Downtime Upgrades: By automating the entire upgrade process, FPP minimizes the effort, risk, and application downtime traditionally associated with database upgrades.
Modes of Operation
Oracle FPP operates in two primary modes:
- Central Server Mode: In this mode, the FPP server acts as a central repository for "gold images"—standardized and tested versions of Oracle software. These images can be deployed across multiple nodes in a data center to create new clusters and databases, or to patch, upgrade, and scale existing installations.
- FPP Client Mode: Built into Oracle GI (12c and later), FPP clients can retrieve and apply gold images from the FPP server. This mode supports the automated application of maintenance operations, ensuring that each client remains consistent with the centrally managed standards.
Comprehensive Provisioning Capabilities
Oracle FPP supports the provisioning of Oracle Database Homes for versions 11g and later. After provisioning, a single FPP command can initiate the creation of various database configurations:
Oracle RAC One Node or multi-node clusters
- Single instance databases with or without GI or Oracle Restart
- Multitenant container databases
- Admin or policy-managed databases
Patching and Upgrade Strategies
FPP promotes "out-of-place" patching as the best practice. This method involves creating a patched environment in a new directory, allowing the database home to be seamlessly switched to the updated version. In the event of any issues post-upgrade, rollback is simple since the old home remains intact and available.
Conclusion
Oracle Fleet Patching and Provisioning is an essential tool for any organization looking to simplify and automate the management of Oracle database environments. With features like zero-downtime patching, automated PDB relocation, and direct transfer methods, FPP significantly reduces the operational overhead and risks associated with database maintenance. Whether you're managing a single database or an entire fleet, FPP ensures your Oracle infrastructure remains secure, up-to-date, and highly available.
Sunday, 29 June 2025
Oracle Autonomous Database: Streamline Your Performance with Automatic Indexing
In the ever-evolving landscape of database management, Oracle's Autonomous Database stands out for its advanced automation capabilities. One of its standout features is Automatic Indexing, which streamlines index management, a traditionally complex and manual task. Here’s an in-depth look at how Automatic Indexing works and how you can harness its power.
What is Automatic Indexing?
Automatic Indexing is designed to automate the creation, maintenance, and management of database indexes. This feature is particularly valuable for optimizing performance without the need for manual intervention. Although Automatic Indexing is disabled by default, once activated, Oracle Autonomous Database continuously monitors your application workload, creating and managing indexes as needed to enhance query performance.
Enabling Automatic Indexing
To enable Automatic Indexing, you’ll use the DBMS_AUTO_INDEX.CONFIGURE procedure. This simple command sets up the system to create and manage indexes automatically:
EXEC DBMS_AUTO_INDEX.CONFIGURE('AUTO_INDEX_MODE','IMPLEMENT');
When Automatic Indexing is enabled, any new indexes created are visible, allowing them to be used in SQL statements. Additionally, index compression for these auto-generated indexes is enabled by default, optimizing storage and performance.
Disabling Automatic Indexing
If you need to disable Automatic Indexing, you can do so with the following command:
EXEC DBMS_AUTO_INDEX.CONFIGURE('AUTO_INDEX_MODE','OFF');
This command halts the creation of new auto indexes, but any existing indexes remain in place and operational.
Considerations and Restrictions
While Automatic Indexing offers significant benefits, there are some restrictions to be aware of:
- SODA Compatibility: Automatic Indexing does not support SQL/PL/SQL code that uses the SQL/JSON function json_exists.
- Query-by-Example (QBE): Automatic Indexing is also not supported for SODA query-by-example operations.
These constraints are essential to consider when planning your database indexing strategy, particularly if your applications rely on these specific features.
Benefits of Automatic Indexing
- Efficiency: Automates index management, reducing the need for manual intervention and freeing up administrative time.
- Performance: Continuously adapts to workload changes, ensuring that indexes are optimized for current query patterns.
- Cost-Effective: Reduces administrative overhead and minimizes the risk of performance bottlenecks due to manual index management.
In summary, Oracle’s Automatic Indexing in the Autonomous Database is a powerful tool that simplifies index management, enhances performance, and ensures that your database operates at peak efficiency with minimal manual intervention.
Sunday, 15 June 2025
Oracle Exadata on Exascale Infrastructure: Redefining Database Performance and Flexibility
Oracle Exadata's integration with Exascale infrastructure ushers in a new era of database management, combining unprecedented scalability, performance, and cost efficiency. Discover how this advanced platform is transforming database operations and setting new standards in the industry.
Monday, 19 May 2025
Oracle TDE (Part II): Advanced Encryption and Storage Considerations
Oracle TDE provides flexible encryption options for both database and tablespace levels. The default encryption standard for database and tablespace encryption is AES128, while AES192 is used for column-level encryption. For added security, a random string, known as SALT, is appended to plaintext before encryption in column-level encryption. SALT enhances security but cannot be applied to indexed columns.
Sunday, 18 May 2025
Oracle TDE (Part I) : A Comprehensive Overview of Transparent Data Encryption
Oracle's Transparent Data Encryption (TDE) is a pivotal feature for securing sensitive information in your database. It offers robust encryption for data stored in tables, tablespaces, and backups, ensuring that unauthorized users cannot access your critical data. TDE relies on external security modules, known as TDE wallets or keystores, to manage and protect encryption keys.
Sunday, 4 May 2025
Unlocking New Capabilities in Oracle RAC 19c
Oracle 19c brings a host of new features and enhancements to Real Application Cluster (RAC), significantly improving resource management, cluster flexibility, and overall performance. Here’s a breakdown of the key updates:
Sunday, 20 April 2025
Exploring Oracle 19c: New Features in Data Guard, RMAN, and Backup & Recovery
Oracle 19c introduces several powerful features that enhance Data Guard, RMAN, and backup and recovery capabilities. These updates streamline database management, improve performance, and provide more robust disaster recovery options. Let’s take a closer look at the highlights.
Sunday, 6 April 2025
Oracle 23ai: Modernizing Database Auditing with Unified Records
In my previous blogpost, we delved into the complete details on Unified auditing. With the release of Oracle 23ai, there's a significant shift in the way Oracle handles auditing. Building on the foundation laid by Unified Auditing introduced in Oracle 12c, Oracle 23ai marks a crucial milestone: the deprecation of traditional auditing in favor of a more streamlined, robust auditing mechanism. Here's an in-depth look at what this transition entails and how it impacts your database management.
Monday, 31 March 2025
Deep Dive into Oracle Undo Tablespace Management in 19c
As we discussed some undo-related aspects in my previous blog post , I’ll continue the conversation here with more details about undo tablespaces and the common challenges you might encounter with them in Oracle 19c. Understanding and optimizing undo management is critical to ensuring data consistency, supporting recovery operations, and maintaining peak database performance.
Sunday, 16 March 2025
A Deep Dive into Oracle Key Vault Features
In the world of database and application security, managing encryption keys and other sensitive credentials is paramount. Enter Oracle Key Vault (OKV)—a robust solution designed to securely store and manage encryption keys, Oracle Wallets, Java KeyStores, SSH Key pairs, and other critical secrets. Whether deployed in the Oracle Cloud Infrastructure (OCI), Azure, AWS, or on-premises, OKV offers a scalable and fault-tolerant solution for key management across various environments.
Monday, 3 March 2025
Elevate Your Oracle Database Security with Oracle Data Safe
Ensuring robust database security and compliance is a critical concern for organizations, especially when dealing with sensitive data and regulatory requirements. Oracle Data Safe provides a unified control center designed to streamline security management and compliance tasks across various environments—whether on-premises, in Oracle Cloud Infrastructure (OCI), at Cloud@Customer, or on other cloud platforms.
Saturday, 1 March 2025
Building a Kind and Effective Leadership Style: 10 Essential Traits
Monday, 24 February 2025
Guide to Managing Database During Rapid Growth: Key Strategies for Scalability and Efficiency
As your database expands, ensuring peak performance becomes increasingly complex. Whether you’re dealing with a sudden surge in transactions or expanding workloads, proactive measures are essential to maintain efficiency. Below are some key strategies to help you optimize performance and scale smoothly during rapid growth.
Sunday, 16 February 2025
From Setup to Purging: Managing Oracle's Unified Audit Trail with Ease
In the realm of Oracle database management, maintaining an effective audit trail is crucial for ensuring data integrity and security. Oracle's approach to auditing has evolved, with unified audit records now taking center stage. Here’s an in-depth look at how Oracle handles audit trails and how you can manage them effectively.
Saturday, 15 February 2025
10 Common Oracle Performance Mistakes and How to Avoid Them
Sunday, 2 February 2025
Oracle TDE Demystified: Safeguarding Sensitive Data in Your Database
Sunday, 26 January 2025
A Step-by-Step Guide to Identifying and Resolving Performance Bottlenecks
Sunday, 19 January 2025
Navigating Human Struggles: A Tale of Empathy in the Workplace
In the bustling world of office dynamics and performance evaluations, there lies a crucial juncture where empathy meets professionalism. Recently, I found myself at such a crossroads during a candid 1:1 performance review with one of my employees. What transpired during this encounter not only reinforced the essence of our organizational culture but also underscored the importance of extending compassion beyond the confines of the workplace.
Sunday, 5 January 2025
Mastering SQL Performance with SQL Plan Management
In my previous blogpost, we delved into the complete details on loading a SQL Plan with its Plan Hash Value. SQL Plan Management (SPM) is a powerful feature designed to ensure consistent and optimized SQL performance by managing execution plans proactively. By leveraging SQL Plan Baselines, SPM helps maintain query efficiency and reliability, making it an essential tool for database administrators. Here's a closer look at how SPM works, its benefits, and its role in maintaining SQL performance.
Saturday, 21 December 2024
Transforming Database Operations with Oracle Autonomous Database: A Comprehensive Overview
Oracle Autonomous Database is revolutionizing database management by introducing a suite of advanced features designed to simplify operations, enhance performance, and provide unmatched reliability. Here’s a closer look at the key features that make Oracle Autonomous Database a game-changer in the world of data management.
Monday, 16 December 2024
Vector Databases Explained: A New Era for Unstructured Data Handling
In the evolving landscape of data management, vector databases have emerged as a revolutionary tool for storing and retrieving complex data objects. Unlike traditional databases that rely on structured data and keyword-based search, vector databases operate in a completely different paradigm, utilizing numerical representations known as vector embeddings. This innovative approach opens up new possibilities for handling unstructured and semi-structured data like images, text, and sensor data, making vector databases an essential component in modern AI-driven applications.
Sunday, 1 December 2024
Addressing Query Slowness in PostgreSQL: A Comprehensive Guide
Monday, 25 November 2024
How to Check CPU Core Count in Oracle: Essential Queries for Performance Tuning
Saturday, 23 November 2024
Exploring the Key Differences Between pglogical and Native Logical Replication in PostgreSQL
Hey, PostgreSQL enthusiasts! 🌟 Ready to dive into the fascinating world of logical replication?