In this blog we’re going to discuss some of the most common, user asked, questions related to Hybrid Columnar Compression (HCC), these questions include: How to enable Hybrid Columnar Compression… Read more »
Sensitive data is everywhere in our organization’s systems. Today, organizations are required to protect sensitive data; these requirements come from regulations, laws and the necessity of the organization to protect… Read more »
Oracle 18c : We are now using the latest Oracle database which is 11g version of oracle and Oracle 12c version to do the database operations in day to day… Read more »
Larry Ellison has launched Oracle 18c which is fully autonomous database we can call it as future database has lot of automotive features.Different kind of rumors are spreading in the… Read more »
Killing a session that is creating/rebuilding an index online rebuild your session was killed and you trying to drop the index or re-creat/rebuild you get ORA-08104: this index object #####… Read more »
Index usage tracking in Oracle 12.2 replaces the old index monitoring functionality of previous versions. The database maintains all indexes defined against a table regardless of their usage. Index maintenance… Read more »
Prior to Oracle 12c, there were two ways to do ‘top-n’ queries: use rownum after sorting rows with “order by” use row_number() over (order by) Top-n queries are usually required… Read more »
The Unified Audit Trail has become too big, you cannot directly delete or truncate the table. You must call the dbms_audit_mgmt.clean_audit_trail. But then you want to know if it will… Read more »
I just finished reading the Oracle database 12.2 new features manual. I have postponed looking at 12.2 until now because for a long time 12.2 was not available for download… Read more »
The expdp and impdp utilities are command-line driven, but when starting them from the OS-prompt, one does not notice it. When you want to kill, cancel, start or resume a… Read more »