What is Oracle Table Fragmentation?If a table is only subject to inserts, there will not be any fragmentation.Fragmentation comes with when we update/delete data in…
View More TABLE FRAGMENTATION IN ORACLE DATABASE
Category: Oracle
Oracle
How to configure HugePages for Oracle Database Server
Hugepages and Large Pages If you run a Oracle Database on a Linux Server with more than 16 GB physical memory and your System Global…
View More How to configure HugePages for Oracle Database Server
Alert Log file and Listener Log file in AWS RDS Oracle
In AWS RDS Oracle we can use Listenerlog and Alertlog data dictionary views to check errors and other related information. in sqlplus you can use…
View More Alert Log file and Listener Log file in AWS RDS Oracle
Guide to Java Versions and Features
Background Information First, let’s have a look at some common, practical questions that people have when trying to choose the right Java version for their…
View More Guide to Java Versions and Features
Index Skip Scanning
Index Skip Scanning In previous releases a composite index could only be used if the first column, the leading edge, of the index was referenced…
View More Index Skip Scanning
Cloning a PDB with Encrypted Data in a CDB
Ensure that the software keystore of the PDB that you plan to clone is open.You can query the STATUS column of the V$ENCRYPTION_WALLET view to…
View More Cloning a PDB with Encrypted Data in a CDB
Setup Unified auditing in Oracle 19c
The following auditing modes are available for Oracle Database 12c, 18c, 19c: Unified Auditing—Recommended. See the following Oracle technical article for detailed instructions on how…
View More Setup Unified auditing in Oracle 19c
Creating a Pluggable Database Release 19
Techniques for Creating a PDB Technique Description More Information Create a PDB from scratch Create a PDB in a CDB using the files of the…
View More Creating a Pluggable Database Release 19
Setup TDE Encryption In Oracle 19c Database
Transparent Data Encryption (TDE) enables you to encrypt sensitive data that you store in tables and tablespaces. After the data is encrypted, this data is…
View More Setup TDE Encryption In Oracle 19c Database
Unplug and Plugin Pluggable database (PDB)
Oracle has introduced new Multitenant Option from Oracle 12cR1 and this option allows a single container database (CDB) to host multiple pluggable databases. One of the most powerful feature…
View More Unplug and Plugin Pluggable database (PDB)