Arvind Toorpu

Blog Posts

  • Automating Oracle ADDM Reports via Email Using PL/SQL

    Automating Oracle ADDM Reports via Email Using PL/SQL

    Learn how to automate Oracle ADDM report generation and send it via email using PL/SQL. This guide walks through the process, including necessary configurations and a practical script example.

  • Oracle audting explained

    Oracle audting explained

        Oracle AUDIT Explained: A Comprehensive Guide Oracle Database auditing is a vital feature for tracking database activities, ensuring compliance, and identifying security issues. This guide covers enabling and disabling auditing, audit trail options, cleaning up audit logs, and more. Configuration Options: Enable database auditing with extended information: ALTER SYSTEM SET AUDIT_TRAIL=DB, EXTENDED SCOPE=SPFILE;…

  • DELETE OS AUDIT FILES IN ORACLE

    DELETE OS AUDIT FILES IN ORACLE

    [atoorpu@ORACLE1 adump]$ pwd/u01/app/oracle/admin/ORCL/adump[atoorpu@ORACLE1 adump]$ ls -1 /u01/app/oracle/admin/ORCL/adump | wc -l22273[atoorpu@ORACLE1 adump]$ ls -lrt *aud | wc -l11363[atoorpu@ORACLE1 adump]$ sqlplus /”As sysdba”SQL*Plus: Release 11.2.0.4.0 Production on Mon Feb 9 10:40:58 2015Copyright (c) 1982, 2013, Oracle.  All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application…

  • Extracting Tablespace DDLs in Oracle Database

    Extracting Tablespace DDLs in Oracle Database

    Extracting Tablespace DDLs in Oracle Database Extracting Tablespace DDLs in Oracle Database When creating a new Oracle database similar to an existing one, you might need to replicate the tablespaces from the original database. Instead of manually recreating tablespaces, Oracle provides a simple way to extract the Data Definition Language (DDL) statements for tablespaces using…

  • Understanding and Managing Oracle ASH Emergency Flushes

    Understanding and Managing Oracle ASH Emergency Flushes

    Learn how to diagnose and manage Oracle ASH emergency flushes effectively. This guide provides steps to monitor ASH performance, increase ASH size, and ensure database stability.

Hello,

Arvind Toorpu

I am a Database Admin/Architect with over 14+ years of experience managing multiple DBMS systems

Let’s connect

Join the fun!

Stay updated with our latest tutorials and ideas by joining our newsletter.

Recent posts