Lost your password?

Blogs about: Vsession_wait

Featured Blog

ALL DBA's Desktop Sql's . (1-Active Session.sql)

Database deki active session sayısını gösteren query. Active Session.sql SELECT username,COUNT(*)  FROM GV$SESSION WHERE USERNAME IS NOT NULL AND USERNAME NOT IN (‘SYS’,'SYSTEM’,'SYS… more →

Startup force !

Script - Sessions Waiting On A Particular Wait Event

Gavin Soorma wrote 6 months ago: SELECT count(*), event FROM v$session_wait WHERE wait_time = 0 AND event NOT IN ('smon timer','pipe … more →

Tags: Performance Tuning, Scripts, Wait Event, Wait Interface

Cardinality feedback to resolve a Cache buffers chains latch contention issue — 3 comments

orainternals wrote 1 year ago: Earlier, I blogged about resolving cache buffers chains latch contention in my earlier entry , in wh … more →

Tags: CBO, EBS11i, Performance Tuning, cache buffers chain, latches, Oracle, Oracle Performance, Performance

ALL DBA's Desktop Sql's . (1-Active Session.sql)

ilknurkoksal wrote 1 year ago: Database deki active session sayısını gösteren query. Active Session.sql SELECT username,COUNT(*)  F … more →

Tags: ALL DBA's Desktop SQL's, active session, Active, Session, Process ID, session id

Tuning latch contention: Cache buffers chain latches — 13 comments

orainternals wrote 1 year ago: Recently, I had an opportunity to tune latch contention for cache buffers chain (CBC) latches. Probl … more →

Tags: Oracle database internals, CBO, Performance Tuning, cache buffers chain, latches, first_rows


Related Tags
All →

Follow this tag via RSS