Wednesday, June 24, 2009

Stats of My Session

for 10g
select name,value 
from v$mystat,v$statname 
where v$mystat.statistic#=v$statname.statistic# 
and v$statname.statistic# in (11,12,50,51,52,53,54,62,134,179);

for 11gR1
select name,value 
from v$mystat,v$statname 
where v$mystat.statistic#=v$statname.statistic# 
and v$statname.statistic# in (11,12,53,54,55,56,57,58,59,60,61,62,64,65,66,68,72,146);

for 11gR2 (11.2.0.1)
select name,value 
from v$mystat,v$statname 
where v$mystat.statistic#=v$statname.statistic# 
and v$statname.statistic# in (13,14,63,64,65,66,67,68,69,70,71,72,75,76,77,79,83,169);

for 11gR2 (11.2.0.2)
select name,value 
from v$mystat,v$statname 
where v$mystat.statistic#=v$statname.statistic# 
and v$statname.statistic# in (15,16,66,67,68,69,70,71,72,73,74,75,78,79,80,82,86,175);

for 11gR2 (11.2.0.3)
select name,value 
from v$mystat,v$statname 
where v$mystat.statistic#=v$statname.statistic# 
and v$statname.statistic# in (16,17,68,69,70,71,72,73,74,75,76,78,81,82,83,85,89,178);

for all versions
select name,value 
from v$mystat,v$statname 
where v$mystat.statistic#=v$statname.statistic# 
and v$statname.name in ('CPU used when call started',
'CPU used by this session',
'db block gets',
'db block gets from cache',
'db block gets from cache (fastpath)',
'db block gets direct',
'consistent gets',
'consistent gets from cache',
'consistent gets from cache (fastpath)',
'consistent gets - examination',
'consistent gets direct',
'physical reads',
'physical reads direct',
'physical read IO requests',
'physical read bytes',
'consistent changes',
'physical writes',
'redo size');


Tuesday, June 23, 2009

ADMon 2.0

ADMon 2.0 2.5 3.1 3.3 3.4 3.5 3.8 new 3.9 (md5sum b925dec809a6d7557d5492fd620348b3, chksum 1632924045 bytes 18755192)
User Guide (md5sum 23c7ccfa44d2f2f6015a52c249bca644, chksum 3726284878 bytes 356797)






What's new on ADMon 3.1

Two outlier detection methods have been added to ADMon. One is the modified Z-Score method and the other is the Box Plot method. Under box plot method it is possible to detect either mild outliers or extreme outliers.

Once an outlier is detected it could be handle in seven different ways. These could be configured under setup -> Outlier Handling.




What's new on ADMon 3.3
One Click Save : Save the output you see on ADMon to a preset file location (Defaults to Desktop on Windows and home directory on Linux).
Table data could be saved to an Excel file (xlsx or xls format).
Graphs could be saved as either PNG or JPG files.
Both table data and graphs saved in single PDF file.
File formats and locations could be changed with setup -> One Click Save



What's new on ADMon 3.8
Remove rows from the table view. Rows will be removed only from the front end view, not from the database table.
Select the rows to be removed and right click to get the remove popup.
Connected database name (given at ADMon connection creation) or SID (if no name is given at ADMon connection creation) is shown next to ADMon title.


What's new on ADMon 3.9
Important : ADMon 3.9 does not include any JDBC libraries (ojdbc*.jar). Please download relevant JDBC library for your database and JDK combination and copy it to the lib folder shipped with ADMon. The JDBC jar files must be one of the following ojdbc[5|6|7|8].jar.
ADMon 3.9 is compiled with JDK8.
Removal of rows now take in to account user sorting (user changing the row ordering).

Wednesday, June 17, 2009

Oracle10gR2 On RHEL 5/OEL 5 (x86_64)

Changes to the packages and pre-req parameters

more on metalink 421308.1

Jan 19, 2009:

1. The required packages this article have been changed from Release Notes because of non-existent names and/or versions given in Release Notes.
a) Packages versions changed
1. compat-db-4.1 to compat-db-4.2
2. glibc-2.3 (i386) to glibc-2.5 (i386)
3. libstdc++-3.4.3-9.EL4 to libstdc++-4.1.1
4. libstdc++-devel-3.4.3-22.1 to libstdc++-devel-4.1.1

b) Package names changed
1. pdksh-5.2 to ksh-20060214-1.4
2. gnome-libs to libgnome-2.16.0 and libgnomeui-2.16.0

c) Packages Added
1. libXp-1.0.0 (i386) due to Bug 7680459

2. Updated kernel parameter net.ipv4.ip_local_port_range as per correction request given by Oracle development team.

Feb 11, 2009:

1. Updated the physical memory required as 1GB

2. Removed swap space requirements when physical memory < 1GB

3. Added information about disabling SELinux
Feb 27, 2009:

1. Removed kernel parameter fs.file-max = 65536 , because the default value 202804 is more than 65536.

2. Corrected typo:
glibc-2.5-12 (i386) to glibc-2.5-12 (i686)

Mar 2, 2009:
Removed kernel parameters net.ipv4.tcp_wmem and net.ipv4.tcp_rmem as they are not required. (Reference: unpublished Bugs 7647281 and 7647303)