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
  • 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
  • Script to Find Last time and Objects was Analyzed 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
  • Oracle Script to list the Memory Allocation Per User/Process

    The script will provide important information about the Memory Allocation on your database present session.

    SET PAGESIZE 9999
    COLUMN sid FORMAT 999 HEADING 'SID'
    COLUMN oracle_username FORMAT a12 HEADING 'Oracle User' JUSTIFY right
    COLUMN os_username FORMAT a9 HEADING 'O/S User' JUSTIFY right
    COLUMN session_program FORMAT a18 HEADING 'Session Program' TRUNC
    COLUMN session_machine FORMAT a8 HEADING 'Machine' JUSTIFY right TRUNC
    COLUMN session_pga_memory FORMAT 9,999,999,999 HEADING 'PGA Memory'
    COLUMN session_pga_memory_max FORMAT 9,999,999,999 HEADING 'PGA Memory Max'
    COLUMN session_uga_memory FORMAT 9,999,999,999 HEADING 'UGA Memory'
    COLUMN session_uga_memory_max FORMAT 9,999,999,999 HEADING 'UGA Memory MAX'
    SELECT s.sid sid,
           lpad(s.username, 12) oracle_username,
           lpad(s.osuser, 9) os_username,
           s.program session_program,
           lpad(s.machine, 8) session_machine,
           (select round(sum(ss.value / 1024 / 1024))
              from v$sesstat ss, v$statname sn
             where ss.sid = s.sid
               and sn.statistic# = ss.statistic#
               and sn.name = 'session pga memory') session_pga_memory,
           (select round(sum(ss.value / 1024 / 1024))
              from v$sesstat ss, v$statname sn
             where ss.sid = s.sid
               and sn.statistic# = ss.statistic#
               and sn.name = 'session pga memory max') session_pga_memory_max,
           (select round(sum(ss.value / 1024 / 1024))
              from v$sesstat ss, v$statname sn
             where ss.sid = s.sid
               and sn.statistic# = ss.statistic#
               and sn.name = 'session uga memory') session_uga_memory,
           (select round(sum(ss.value / 1024 / 1024))
              from v$sesstat ss, v$statname sn
             where ss.sid = s.sid
               and sn.statistic# = ss.statistic#
               and sn.name = 'session uga memory max') session_uga_memory_max
      FROM v$session s
     ORDER BY session_pga_memory DESC
    /


    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