Oracle Database 12.2 introduces new nice and powerful partitioning features. This post will introduce one of them “Automatic List Partitioning”. We may talk about other features in future posts. Before 12.2, if you have a list partitioned table in specific discrete values, and there is a need to add a new list value, then you … Continue reading Oracle Database 12c R2 Partitioning New Features – Automatic List Partitioning
How do Nologging Operations affect Recovery and Data Guard?
What is Redo Information: Each Oracle Database instance has redo logs, which consists of two or more preallocated files that store all changes made to the database as they occur. Every instance of an Oracle Database has an associated redo log to protect the database in case of an instance failure. What is Nologging: NOLOGGING can be used to prevent bulk operations from … Continue reading How do Nologging Operations affect Recovery and Data Guard?
Protected: Oracle Database Migration to Exadata – Case Study
There is no excerpt because this is a protected post.
sqlcl Multi-Line Paste Issue
What is the issue? I noticed that sometimes when I copy SQL statement from web and paste it on sqlcl , it is copied on many lines and generating errors. For example, when I copied the following statement: And pasted into sqlcl running on the windows command window, it was pasted as follows: So, it … Continue reading sqlcl Multi-Line Paste Issue
Oracle tnsnames.ora Distribution Management System!
What? Does tnsnames.ora file need a Distribution Management System? In our case, the answer is yes. It is a headache to implement our client requirements without some sort of automation. What is tnsnames.ora file? tnsnames.ora is a text file that resides on the ORACLE_HOME/network/admin and contains some simple information about our databases connection information, it … Continue reading Oracle tnsnames.ora Distribution Management System!
Oracle Database 32-bit Funny Migration to 64-bit
Objective: Migrating one 11.1.0.7 32-bit database that resides on an old Windows 2008 (32-bit) (4GB memory) to Windows 2008 64-bit (no upgrade) on a brand new server with 64GB memory. {At 2017 and still there is 11.1.0.7 database ==> yes there is!} Introduction and Background I have a client with the following very old environment: … Continue reading Oracle Database 32-bit Funny Migration to 64-bit
Oracle Data Pump Import Log File Analysis
In most (or all) cases , when you fully import the database using oracle data pump or the old “imp” import utility , you will get some errors. Some of them are expected and could be ignored and some need close attention to investigate and fix. For big databases, the import log file may be … Continue reading Oracle Data Pump Import Log File Analysis
Formatting a Wrapped Execution Plan
If you received or produced an execution plan like the following unreadable one: ---------------------------------------------------------------------------------------------------| Id | Operation | Name | E-Rows | OMem |1Mem | Used-Mem |---------------------------------------------------------------------------------------------------| 0 | SELECT STATEMENT | | | || || 1 | SORT AGGREGATE | | 1 | || ||* 2 | HASH JOIN | | 13 | 1102K|1102K| … Continue reading Formatting a Wrapped Execution Plan
Ahmed AbdelFattah Blog ! 