Hi,
We recently upgraded a database to Oracle 10g from Oracle 9i, and we are
experiencing performance problems. On a box, with no other users, queries
that took 20 seconds are now taking 4 minutes, and is chewing up to 17%
of the CPU. I have trussed the oracle, and are seeing a high number of preads.
I am new to dtrace, and I am trying to use dtrace to see what is being read.
The output of uname -v is Generic_118833-36. My script contains the followng
statement:
/*
* Syscall count by syscall
*/
syscall::pread:entry
/ pid == 11695 /
{
@fds[fds[arg0].fi_pathname] = count();
}
The output is:
[i][b]/ora10g/infrastructure/Apache/Apache/libexec/libperl.so/security/audit_logs/inittech_Oracle_scooter_DBA_080324_220000_INITTECHLIVE.csv.Z/mime.types/caps_files/HIST/080121.FIL/disco_dsc_smi.jar/INITTECH_sml01.dbf/default/dms/INITTECH_med_idx02.dbf
112
/INITTECHLIVE/data01/INITTECH_med_idx01.dbf 135
/oracle/10g/infrastructure/sysman/jlib/INITTECH146503.ARC/inittech_Auth_Users_scooter_DBA_080507_220000_INITTECHLIVE.csv.Z/libzip.so/admin/AFM/Helvetica-Bold/pt_BR
282
/INITTECHLIVE/data03/INITTECH_lge04.dbf 374
/fjsdba/oracle/INITTECHLIVE/bdump/INITTECHlive_j000_15901.trc/applications/dms0.war/fmx/smformm.mmx/myejo/ssaname.so/infrastructure/cdata
457
/fjsapps/INITTECHLIVE/fee_interface/nacred_20080501.txt/INITTECH147386.ARC/pbni_extract/EXTPBNI_PSR_140508.ftp
554
/ora10g/infrastructure/j2ee/OC4J_SECURITY/applications/oiddas/ui/oracle/ldap/das/user/DASDeleteUserInfoAdmin.uix/logs/ons.log/dsv2.jar/ora_18157.aud/classes/infratool.jar/orapwINITTECHLIVE/inittech_Auth_Users_scooter_DBA_080503_221000_OCPLIVE.csv.Z/servle
612
/ora10g/infrastructure/Apache/Apache/libexec/libperl.so/logs/cred_update.log/database/dbstatus.log/fee_interface/bankcred_20080423.ftp/fmb/SAOMOLF.fmb/applications/discoverer/discoverer/WEB-INF/web.xml/icons
1499
/ora10g/infrastructure/j2ee/home/default-web-app/tab_files/asyltrb.gif/reports/conf/repocplive.conf/javavm/lib/EJO175714.ARC/INITTECHDUN.txt/5.6.1/sun4-solaris/EXTLSCS_150807.ftp/OC4J_SECURITY/applications/oiddas/ui/oracle/ldap/das/Images/refresh.gif
1504
/INITTECHLIVE/data01/INITTECH_lge01.dbf 1534
/ora10g/infrastructure/j2ee/home/default-web-app/tab_files/asyltrb.gif/reports/conf/repocplive.conf/javavm/lib/EJO175714.ARC/INITTECHDUN.txt/5.6.1/sun4-solaris/EXTLSCS_150807.ftp/OC4J_SECURITY/applications/oiddas/ui/oracle/ldap/das/group/AppCreateGroupInf
1743[/b][/i]
While the pathname to the dbf files are correct,others are not. They seem to be
concatentations of multiple file names. For example, the final line is:
/ora10g/infrastructure/j2ee/home/default-web-app/tab_files/asyltrb.gif/reports/conf/repocplive.conf/javavm/lib/EJO175714.ARC/INITTECHDUN.txt/5.6.1/sun4-solaris/EXTLSCS_150807.ftp/OC4J_SECURITY/applications/oiddas/ui/oracle/ldap/das/group/AppCreateGroupInf
The file /ora10g/infrastructure/j2ee/home/default-web-app/tab_files/asyltrb.gif
exists, but the /reports/conf/repocplive.conf is found under
/oracle10g/appserver
Is my approach to capturing the pathname correct, or have I missed something?
Regards,
Darren
--
This message posted from opensolaris.org