NO_PARALLEL hint as overview

This example will show the use of the NO_PARALLEL hints. SQL> select owner,table_name, degree   1  from dba_tables   2        where table_name in (‚EMPLOYEES‘,’DEPARTMENTS‘) OWNER                   TABLE_NAME              DEGREE —————————— —————————— —————————————- HR                   EMPLOYEES                   1 HR                   DEPARTMENTS                   1 As…

SecureFiles Lobs overview

Secure File LOBs was an Oracle 11g database new feature that provides faster access to unstructured data stored in LOB columns. Securefile Lobs have several benefits than traditional Lobs. In addition, it features data compression, encryption and data deduplication. SecureFiles supports advanced file system features such as: Deduplication – detecting identical securefile data, and storing…

Tablespace Encryption in Oracle 11g

Transparent Data Encryption (TDE) was introduced in Oracle 10G Release 2. Tablespace encryption helps you to secure the complete contents of one Tablespace instead of encrypt column by column. Oracle has also built in support for hardware-based crypto accelaration 11.2.0.2 for Intel XEON 5600 CPUs with AES-NI. Keep in mind that TDE can also be…

ORA-00600 Troubleshooting Tool

Hello, I recently discovered on the My Oracle Support the ORA-00600 lookup tool . This allows  to a corresponding trace file (alertlog, IPS Package or the trace file) and upload to the MOS that you can analyze it. It can certain situations  it can save a lot of time. The ORA-00600 troubleshooting tool can be found…