Toad session browser filters
                                                 Last update (2012-06-22 20:21:15)
                                                                                                                   Date added (2011-05-20 13:39:12)

Summary
The TOAD_SESSBROWFILTERS.INI is located at:
C:/Program Files/Quest Software/Toad for Oracle/User Files

The contents:
[Settings]
FilterCount=23

[Filter1_V$SESSION]
Count=1
Column0=PROGRAM
Condition0=LIKE
Value0='%TOAD%'
Connector0=OR

[Filter1]
Name=ACTIVE
Expression=s.STATUS = 'ACTIVE'
AND s.status='ACTIVE'
session=1
process=0
io=0
Ver=0

[Filter2]
Name=INACTIVE
Expression=s.STATUS = 'INACTIVE'
session=1
process=0
io=0
Ver=0

[Filter3]
Name=REQUESTS
Expression=action = 'Concurrent Request'
session=0
process=0
io=0
Ver=0

[Filter4]
Name=POSTING
Expression=module = 'XXACC_EVENTTRN'
session=0
process=0
io=0
Ver=0

[Filter5]
Name=RMAN
Expression=module like 'backup%'
session=0
process=0
io=0
Ver=0

[Filter6]
Name=LONGOPS
Expression=sid in (select sid from v$session_longops where time_remaining > 0)
session=0
process=0
io=0
Ver=0

[Filter7]
Name=BLOCKED
Expression=sid in (select sid from V$LOCK WHERE lmode = 0)
session=0
process=0
io=0
Ver=0

[Filter8]
Name=BLOCKING
Expression=sid in (select sid from v$lock where block = 1)
session=0
process=0
io=0
Ver=0

[Filter9]
Name=ACTIVE TRANSACTIONS
Expression=status = 'ACTIVE' and saddr in (select ses_addr from v$transaction)
session=0
process=0
io=0
Ver=0

[Filter10]
Name=PARALLEL
Expression=sid in (select sid from V$PX_SESSION)
where QCSERIAL# is null)
session=0
process=0
io=0
Ver=0

[Filter11]
Name=SORT_USAGE
Expression=SADDR in (select session_addr from v$tempseg_usage)
session=0
process=0
io=0
Ver=0

[Filter12]
Name=WAITING EVENTS
Expression=status = 'ACTIVE' and s.SID IN (SELECT DISTINCT(SID) FROM v$session_wait WHERE event NOT IN (SELECT NAME FROM v$event_name WHERE wait_class = 'Idle'))
session=1
process=0
io=0
Ver=0

[Filter13]
Name=JOBS
Expression=SID IN (SELECT s.SID FROM v$session s, v$process d WHERE s.paddr = d.addr and d.program LIKE '%J0%')
session=1
process=0
io=0
Ver=0

[Filter14]
Name=AUTOINVOICE
Expression=module like '%RAX%'
session=0
process=0
io=0
Ver=0

[Filter15]
Name=LOCKBOX
Expression=module like 'XXACC_ARLPLB%'
session=0
process=0
io=0
Ver=0

[Filter16]
Name=CONFIGURATOR
Expression=(s.machine LIKE '%erp' or s.module like '%qot%jsp%' or s.module like 'FNDWFBG%') and s.status='ACTIVE'
session=1
process=0
io=0
Ver=0

[Filter17]
Name=JDBC
Expression=s.module like '%JDBC%' and s.status = 'ACTIVE'
session=1
process=0
io=0
Ver=0

[Filter18]
Name=TRANSFERTOGL
Expression=module = 'XXACC_TRANSFERTOGL'
session=0
process=0
io=0
Ver=0

[Filter19]
Name=SERVICE MANAGEMENT
Expression=s.action = 'Service Management'
session=1
process=0
io=0
Ver=0

[Filter20]
Name=IBM
Expression=module in ('OEOIMP', 'WSHPSGL', 'OEXOEORD') and status = 'ACTIVE'
session=0
process=0
io=0
Ver=0

[Filter21]
Name=PROMITHEAS_PDF
Expression=(module LIKE '%   ?  @PROM-AS% (TNS V1-V3)%' and status = 'ACTIVE')
s.STATUS='ACTIVE'
)
session=0
process=0
io=0
Ver=0

[Filter22]
Name=FULL_TABLE_SCANS
Expression=s.SID IN (SELECT DISTINCT(SID) FROM v$session_wait WHERE event IN ('db file scattered read'))
session=0
process=0
io=0
Ver=0

[Filter23]
Name=JDBC_WAITING
Expression=status = 'ACTIVE' and module like 'JDBC%' and s.SID IN (SELECT DISTINCT(SID) FROM v$session_wait WHERE event NOT IN (SELECT NAME FROM v$event_name WHERE wait_class = 'Idle'))
session=1
process=0
io=0
Ver=0

Reviews
Categories
Oracle DBA-> (147)
  Alertlog (3)
  Archivelog (5)
  Auditing (1)
  Backup - Recovery (19)
  Database files (6)
  Database options (2)
  DB links (2)
  Dependencies (1)
  Dictionary (2)
  Exp-Imp Datapump (6)
  Jobs (2)
  Mview (2)
  Networking (3)
  Objects (7)
  Parameters (2)
  Redologs (6)
  Roles - Grants (2)
  Rollback - Undo (8)
  Segments (3)
  Sequences (2)
  Sessions (14)
  SGA (14)
  Tables (10)
  Tablespaces (10)
  Temp (4)
  Toad (5)
  Transactions (1)
  Upgrade (2)
  Users (3)
Oracle APPS DBA-> (66)
Exadata (1)
Performance Tuning-> (59)
Oracle Real Cases (24)
Oracle Errors (23)
Oracle SQL tricks (32)
Oracle RAC (3)
Oracle Security (8)
Filters
Search