Oracle 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 CommentCategory: Database Basics
The 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 CommentOracle Exadata is a high-performance database machine that combines the power of Oracle Database software with the speed and scalability of industry-standard x86 servers, InfiniBand…
Leave a CommentBelow are some interesting conceptual points regarding Oracle Multitenant CD-PDB Architecture which can prove useful for DBA who is new to Oracle multi-tenant architecture. This…
Leave a CommentBelow are some of the frequently used commands related to Transparent Data Encryption (TDE)
— TO FIND WHICH ALL TABLESPACES ARE ENCRYPTED
SQL> select * from dba_tablespaces where encrypted='YES';
OR
SQL> select * from V$ENCRYPTED_TABLESPACES;Leave a Comment
Keeping data secure is one of the primary job of DBA. Oracle’s Transparent Data Encryption Tablespace Encryption option of Oracle Database 11g Enterprise Edition provides an excellent method to encrypt data at rest. This option works perfectly with Oracle EBS R12.
The TDE Tablespace Encryption option can be used to encrypt the tablespaces that store the content of your E-Business Suite application so you can encrypt the database files and any backups of these files. Good thing about TDE is you do not have to change any of your existing code as TDE is transparent to application.
3 CommentsA well-planned methodology is the key to success in performance tuning. Without a proper diagnosis of the issue any troubleshooting step taken will further delay the resolution. Example, a DBA can not just blindly start tracing/tuning a SQL/Sessions when all symptoms on careful analysis points towards issues with DIsk/Memory/Network etc.
2 CommentsHistogram helps Oracle Optimizer in generating a better execution plan specially when the data is highly skewed in the table. You can say a histogram is an optional special type of column statistic data that provides more detailed information about the actual data distribution in a table column.
Before going into Oracle Histograms details, let us understand what it Histogram in simple language.
2 Comments