Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Free conference number from http://www.freeconference.com Oracle
  • SCRIPT TO LIST RECURSIVE DEPENDENCY BETWEEN OBJECTS UTLDTREE.sql Oracle
  • USE_NL and INDEX hints example Oracle
  • Jai Shree Ram Oracle
  • How To Limit The Access To The Database So That Only One User Per Schema Are Connected (One Concurrent User Per Schema) Oracle
  • On solaris 10, “S” link is not part of $ORACLE_HOME/bin/oracle as default. ( For 9.2.0.8) Oracle
  • shutdown linux Linux/Unix
  • backspace in SQL Plus not working then..? Linux/Unix
  • Test Case for Inserting Multiple (2.3 Million rows in 26 Seconds) Oracle
  • Find long Running Transaction Linux/Unix
  • Nice notes on wait events Oracle
  • fdisk -l explaination about Primary-Logical-Extended Partitions Linux/Unix
  • Oracle Metalink useful notes Oracle
  • Drop all SPM baselines for SQL handle Oracle
  • proper cpu stats Linux/Unix

cur_sql.sql

Posted on 27-Feb-2006 By Admin No Comments on cur_sql.sql

spool cur_sql

set lines 132

set pages 300

col USR format a14

col PAR heading “Parsing ID” format 9999999

col ELA heading “ELP time(Sec)” format 9999999.0

col HASH heading “Hash Value”

col USR heading “Parsing User”

col T heading “SQL Text having Elapsed time > 1 sec”

break on HASH on USR on ELA skip 1

select a.sql_Text,

a.hash_value “HASH” ,

b.username “USR”, a.executions, rows_processed, a.buffer_gets, a.disk_reads, a.sorts, a.users_executing

from v$sqlarea a,dba_users b

where b.username not in (‘SYS’,’SYSTEM’,’DBSNMP’,’VIVEK’, ‘SYSMAN’)

and a.PARSING_SCHEMA_ID = b.user_id

and a.users_executing > 0;

spool off

Oracle, SQL scripts

Post navigation

Previous Post: avail.sh ( find filesystem spae usage)
Next Post: age_alert.ksh aging out alert.log

Related Posts

  • plan10g.sql good Oracle
  • dbms_job.submit example Oracle
  • TNSNAMES entries details Oracle
  • Oracle Data Direct to TAPE Oracle
  • FRA Information. Oracle
  • find_log_switch.sql Find log switches in graphical manner Oracle

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • Ansible (0)
  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • MYSQL (5)
  • Oracle (392)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (0)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (341)
  • SQL Server (6)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • SQL Server Vs Oracle Architecture difference25-Jul-2025
  • SQL Server: How to see historical transactions25-Jul-2025
  • SQL Server: How to see current transactions or requests25-Jul-2025
  • T-SQL Vs PL/SQL Syntax25-Jul-2025
  • Check SQL Server edition25-Jul-2025
  • Checking SQL Server Version25-Jul-2025
  • Oracle vs MYSQL Architecture differences (For DBAs)24-Jul-2025
  • V$INSTANCE of Oracle in MYSQL24-Jul-2025
  • Day to day MYSQL DBA operations (Compared with Oracle DBA)24-Jul-2025
  • MYSQL and Oracle Comparison for Oracle DBA24-Jul-2025

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • PLSQL Table Syntax 2 Oracle
  • RAC with RHEL4 and 11g Oracle
  • copying/removing directory with all its subdirectory Linux/Unix
  • catall.sh Linux/Unix
  • Consolidated Reference List Of Notes For Migration / Upgrade Service Requests -ID 762540.1 Oracle
  • cold backup scripts to copy locally Linux/Unix
  • scripts to take listener.log backup Linux/Unix
  • database trigger failing Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme