More on Oracle Articles

(We marked visited pages blue)
  • How to install Oracle Database 12c Step by Step
  • How to fix Oracle ORA-00904 Error Message
  • How to Start and Stop an Oracle Database
  • How to extract an user definition in Oracle
  • Complete Oracle Cold database Restore Routine
  • Complete Oracle Cold Backup Routine
  • How to find and Recompile Invalid Objects in Oracle
  • How to Fix ORA-01031 insufficient privileges - sqlplus / as sysdba
  • Unable to lock Central Inventory - OPatch will attempt to re-lock
  • Solution for Different Oracle Archive Log Sequence on Primary to Standby
  • Steps to Stop and Start Oracle Standby Database
  • How to Extract any object definition in Oracle
  • Script to Clone an Oracle User
  • Como redefinir a senha de um usu├írio bloqueado no Oracle
  • Como multiplexar arquivos de controle no Oracle
  • Script to generate Statistics script in Oracle
  • Script to find who is using UNDO space in Oracle
  • Script to find used Buffer Cache Block per Object
  • Script to find optimal UNDO retention size in Oracle
  • How to open an Oracle Standby database for READ ONLY mode
  • Oracle Script to list who is using the undo space
  • Oracle Script to list the Memory Allocation Per User/Process
  • How to Move the Flash Recovery Area location in Oracle
  • Oracle Fix for "NID-00137 All datafiles that..." Error
  • Oracle script to find undo generated by session
  • Simplified Oracle Database 12c and 11g Installation
  • How to recompile all objects in Oracle
  • How Oracle Database Redo and Archived Logs function
  • Oracle Database Processes definition and purposes
  • How to use Oracle Database oratop utility
  • What are the components of the Oracle Database Memory Architecture
  • Oracle Backup Metadata Only with Expdp
  • Move Oracle from file system storage to ASM storage.
  • Extract Metadata from Oracle Full Dump with IMPDP
  • How to Enable ARCHIVELOG Mode in Oracle
  • How to drop an Oracle database using SQL Plus commands
  • How to customize your SQLPLUS utility
  • How to clone an Oracle Database Home
  • How to alter the control file name or alter it's file path in Oracle
  • Fix for ORA-01103 database name 'DB01' in control file is not 'DBDG'
  • Script to show SQL by HASH value in Oracle
  • Script to find Total wait time by resource types in Oracle
  • How to Find Stale Materialized Views in Oracle
  • How to Find duplicate executed Sql Statements in Oracle
  • Extract Procedure,Package,Package Body,Function in Oracle
  • How to find the Wait time spent by Type in Oracle Database
  • How to find Hit Ratio Buffer Cache in Oracle Database
  • How to see the Oracle database Disk Balancing Report Script
  • How to Generate Oracle Create Trigger Script
  • Script to Find Last time and Objects was Analyzed in Oracle

    This script will list details of last analyzed time and object name. There are several object type to be analyzed so there are several scripts type.

    prompt ======================================
    prompt ANALYZE - DATE - REGULAR TABLES
    prompt ======================================
    
    col owner format a20
    prompt
    select owner,'Tables',trunc(LAST_ANALYZED),count(*)
    from dba_tables
    where owner not in ('SYS','SYSTEM')
    group by owner,'Tables',trunc(LAST_ANALYZED)
    /
    prompt
    prompt ======================================
    prompt ANALYZE - DATE - PARTITINED TABLES
    prompt ======================================
    prompt
    select table_owner, 'Partitioned Tables',trunc(last_analyzed), count(*)
    from dba_tab_partitions
    where table_owner not in ('SYS','SYSTEM')
    group by table_owner, 'Partitioned Tables',trunc(last_analyzed)
    /
    prompt
    prompt ======================================
    prompt ANALYZE - DATE - REGULAR INDEXES
    prompt ======================================
    prompt
    select owner, 'Regular Indexes', trunc(last_analyzed), count(*)
    from dba_indexes
    where owner not in ('SYS','SYSTEM')
    group by  owner, 'Regular Indexes', trunc(last_analyzed)
    /
    prompt
    prompt ======================================
    prompt ANALYZE - DATE - PARTITINED INDEXES
    prompt ======================================
    prompt
    select index_owner, 'Partitioned Indexes',trunc(last_analyzed), count(*)
    from dba_ind_partitions
    where index_owner not in ('SYS','SYSTEM')
    group by  index_owner, 'Partitioned Indexes',trunc(last_analyzed)
    /


    Leave a comment or a question in the comment area bellow if you fell like


    Be a sport and

    Search

    Loading... Please wait

    Subscribe to our Newsletter

    Be a sport and

    x