• Database Blog
  • GoldenGate 12c
    • Top 50 Oracle Goldengate Interview Questions To Get the Job!
  • Master Oracle 12c DBA
  • Oracle Tutorials
    • Oracle Tips & Tricks
    • Oracle VirtualBox
  • Learn Excel

VitalSoftTech

Database Administration | Oracle | Oracle Training | DBA Support | Oracle 12c DBA | GoldenGate | GoldenGate 12c | DBA Interview Questions | Goldengate Interview Questions | Natik Ameen

  • Digital Marketing
  • Blogging Tutorial and Tips
  • Cool Names
  •   Login

How To Delete Specific Archivelogs and Backups Using RMAN

January 12, 2016 by Imran   /  Oracle 11g

As part of the regular backup file log maintenance, the recovery window and redundancy commands are usually used within backup scripts to define how long the RMAN backups would stay on disk or on tape. For archive log retention, the DELETE ARCHIVELOG command is utilized. DELETE Archive Logs using RMAN To clean-up older archives the […]

Filed Under: Oracle 11g Tagged With: RMAN

Oracle 11g Invisible Indexes

November 4, 2013 by Imran   /  Oracle 11g

While generating execution plans for queries, the optimizer decides at run time which indexes can be used to make query execute faster. The run time cost based optimizer is very efficient in its decisions. However, in the normal day to day operations there may be some situations where you would not like optimizer to use […]

Filed Under: Oracle 11g Tagged With: Oracle Tuning

Database Security – Managing Audit Trail Files

December 28, 2013 by Natik Ameen   /  Oracle Security

Why manage Database Security Audit Trail files? Changing location of Aaudit trails Purging Old Data Automatic Purge Audit Trail Properties Protecting Database Security Audit Trail Enabling Enhanced Auditing Why manage Oracle Database Security Audit Trail files? Oracle Database Security provides numerous ways to audit user actions in database itself. The mere concept that everything a […]

Filed Under: Oracle Security Tagged With: Oracle Security

Relinking Oracle Binaries

April 20, 2015 by Natik Ameen   /  Oracle RAC, oratips

When should Oracle Grid or RDBMS binaries be relinked? Read more ..

Filed Under: Oracle RAC, oratips Tagged With: Grid Infrastructure, Oracle RAC 11g

Exadata: Hybrid Column Compression

December 28, 2013 by Natik Ameen   /  Exadata

Oracle provides different types of Compression for data in the database. The BASIC compression type is the default and allows the data to be compressed while loading the table using direct path loads. This has been available since Oracle 9i. The second type, the OLTP compression, introduced in 11gR1, is part of Oracle Advanced Compression. […]

Filed Under: Exadata Tagged With: Exadata

11g Regular Expression in SQL and PL/SQL

June 28, 2015 by Natik Ameen   /  Oracle 11g

[dropcap1]S[/dropcap1]tring searching is a challenging and important part in any programming language. Regular expression is a well-known tool for string searching and Perl – Language is a renowned language for regular expression for several decades. In the area of computing, a regular expression provides a powerful, concise and flexible set of pattern matching capabilities. In […]

Filed Under: Oracle 11g Tagged With: PL/SQL, SQL

Oracle Secure Files in 11g

March 25, 2015 by Natik Ameen   /  Oracle 11g

• Introduction • What are Secure Files and how to use them • Advantages • Deduplication • Compression • Encryption • Logging and Caching • Managing Secure Files • Moving existing LOBs to Secure Files Introduction There are two ways you can store unstructured data in the Oracle Database which include PDF, XML, Image files. […]

Filed Under: Oracle 11g Tagged With: Oracle Security, Oracle Tuning

  • « Previous Page
  • 1
  • …
  • 26
  • 27
  • 28

Join over 3,000 others My posts. Your Inbox. Beautiful.

Database    GoldenGate

Natik Ameen

About Natik Ameen

Natik Ameen is an Oracle Production DBA, Oracle Certified RAC Expert and a DBA track Certification trainer for over 17 years. He is an Oracle Evangelist and has presented at IOUG & UTOUG conferences. He writes on topics such as Database Administration, RAC, GoldenGate and the Cloud.

Who is Natik Ameen?

Guides

  • My GoldenGate Tutorials
  • Oracle 12c Database Tutorials
  • GoldenGate GGSCI Command Series
  • My OraTips and Tricks

Popular Blogs

  • My GoldenGate Home Page
  • Top 50 Oracle Goldengate Interview Questions To Get the Job!
  • Top 30 RAC Interview Questions That Helped Me. Are You Prepared?
  • Oracle GoldenGate Concepts and Architecture Made Simple!
  • Virtualize Oracle RAC 12c on My Laptop
  • Step by Step Oracle 12c Database Install on Virtual Box

Popular Oracle Articles

Oracle Announces Beta Availability of Oracle Database 12c Release 2
Top 5 Announcements at Oracle Open World
News on Oracle Database STANDARD EDITION 12.1.0.2

Technology Centers

Oracle Business Intelligence and DW
Cloud Computing, SOA, Virtualization
Big data, Java, Linux, PLSQL, Security
Enterprise Architecture, Digital Experience

Oracle Documentation

10g R1, 10g R2, 11g R1, 11g R2, 12c R1
Oracle CPU's, EM 11g, EM 12c
GoldenGate 12c, Oracle VM, VirtualBox

Copyright ©2021

BLOGOracle Tutorials