top of page
Search
Hanh Nguyen
Oct 31, 20155 min read
How to Diagnose Slow TNS Listener / Connection Performance
Questions to ask 1. Is the problem intermittent or happening all the time? 2. When did the problem start to happen and what was changed...
0 views0 comments
Hanh Nguyen
Oct 31, 20152 min read
Tuning SGA_TARGET Using V$SGA_TARGET_ADVICE
What is the view V$SGA_TARGET_ADVICE The V$SGA_TARGET_ADVICE view provides information that helps you decide on a value for SGA_TARGET....
0 views0 comments
Hanh Nguyen
Oct 31, 20151 min read
Script To Monitor RDBMS Session UGA and PGA Current And Maximum Usage Over Time
set echo off; set feedback off; set heading off; set linesize 128; set show off; set pagesize 55; set trimspool on; set verify off;...
0 views0 comments
Hanh Nguyen
Oct 31, 20153 min read
Script To Monitor Memory Usage By Database Sessions
REM Setting environment variables SET LINESIZE 200 SET PAGESIZE 500 SET FEEDBACK OFF SET VERIFY OFF SET...
0 views0 comments
bottom of page