Advanced Index Compression
Advanced Index Compression works well on all supported indexes, including those indexes that are not good candidates for the existing prefix compression feature; including indexes with no, or few, duplicate…
Read MoreAbout Incidents in OEM
An incident is a single occurrence of a problem. When a problem (critical error) occurs multiple times, an incident is created for each occurrence. Incidents are timestamped and tracked in the Automatic…
Read MoreDatabase Smart Flash Cache
If your database is running on Solaris or Oracle Linux, you can optionally add another memory component: Database Smart Flash Cache. Database Smart Flash Cache is an extension of the…
Read Morecheck the load average in Solaris platform
Commands to check the load average in Solaris platform The following commands are present by…
Read MoreOATM Migration Appears to Have Hung. How Can I Monitor It’s Progress?
OATM Migration Appears to Have Hung. How Can I Monitor It’s Progress? The Oracle Applications Tablespace Model was another long awaited feature that…
Read MoreAlert Log: Shutdown Waiting for Active Calls to Complete.
Alert Log: Shutdown Waiting for Active Calls to Complete. Error: You are attempting to shut down the database and the database hangs.…
Read MoreExporting Views as Tables in 12c datapump
Oracle 12c introduces the possibility to export VIEWS as TABLES using the expdp parameter VIEWS_AS_TABLES: VIEWS_AS_TABLES=[schema_name.]view_name[:table_name], … For example impdp directory=exam_dir dumpfile=ocp.dmp logfile=impdp_ocp.log views_as_tables=view1 remap_table:view1:table1
Read MoreLOG TIME in 12c datapump
Data Pump – LOGGING. This command-line parameter can have four values: NONE: No timestamp information is displayed. (This is the default.) STATUS: Timestamp messages on status are displayed. LOGFILE: Same…
Read MoreCompress/Uncompressed Data During Import in 12c
COMPRESSION options is COMPRESSION_ALGORITHM=[BASIC | LOW | MEDIUM | HIGH] BASIC offers the most efficient usage of CPU and effective compression ratio; it is deemed to be applicable to most…
Read MoreData Pump Enhancements in Oracle Database 12c Release 1 (expdp, impdp)
New parameters of DataPump: LOGGING DISABLE_ARCHIVE_LOGGING (part of the TRANSFORM parameter) ENCRYPTION_PWD_PROMPT COMPRESSION_ALGORITHM
Read More