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…

Oracle Webforms and font mapping

Just a little sample how to bring custom fonts to webforms. In Oracle Webforms you have 2 mappings of a font. The first mapping is done on the Server where you bring the application font name to a logical font name. The second font mapping is done on the client where you convert the logical…

Oracle 11G XE and the 11 gigabyte limit

Hello, I have been often been asked how the Oracle 11G XE database Storage limit works exactly. So I would just post an example here to clarify. Here’s an example: We create a tablespace where the limit exceeds 11 gigabytes and we get an ORA-12953: SQL> create tablespace appdata datafile ‚/u01/app/oracle/oradata/XE/appdata01.dbf‘ size 18G; create tablespace…