Javed's Oracle DBA Blog

Tuesday, January 13, 2015

Which Session Generating More Redo

SELECT s.sid, s.serial#, s.username,s.osuser, s.machine,s.module, s.program,i.block_changes
FROM v$session s, v$sess_io i
WHERE s.sid = i.sid ORDER BY 5 desc;
Posted by javeddba at 3:27 AM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: DBA Scripts

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Popular Posts

Categories

  • DBA Scripts (13)
  • Oracle DB (13)
  • Oracle Backup & Recovery (4)
  • Linux (3)
  • RAC (2)
  • GoldenGate (1)
Flag Counter

Blog Archive

  • ►  2020 (1)
    • ►  February (1)
  • ►  2016 (3)
    • ►  November (1)
    • ►  July (1)
    • ►  February (1)
  • ▼  2015 (30)
    • ►  October (1)
    • ►  April (2)
    • ►  February (8)
    • ▼  January (19)
      • Displays List of Sequence in Oracle Database
      • Users executing which type of command
      • Useful script to show primary / foreign key relati...
      • UNDO TABLESPACE CORRUPTED
      • Changing Case Sensitive Password In Oracle 11g
      • Viewing the Alert Log
      • RPM commands
      • Index size is more than table size to rebuild
      • Which Session Generating More Redo
      • Oracle Database Size
      • Database started and automatically going down beca...
      • Session blocking
      • Check the Session accessing objects
      • Find UDUMP file through SQL
      • REDO LOG RECOVERY
      • Disable The Iptables Firewall in CentOS/RHEL
      • OCA-01: SQL Plus, iSQL Plus
      • Redo Generated per day
      • Sql Query to know the Oracle Database Uptime

OCP

OCP

Links

  • jtechspot

Hits

Powered by Blogger.