Hi guys,since a mounth i`ve learnt about solaris DTrace and its D scripts and tried to look for probes for administrating oracle database but til now,nothing!so my question,does there DTrace probes for oracle application ?i really need it now,that`s my project:tracing oracle with DTrace in solaris 10 SPARC!anyone can help me pleaaase!!!
Hey!!of course that's a great site but U know,i've already visit it and it doesn't talk about probes for oracle!!howeiver i thought about another option,how do u think about exploiting oracle instance...i mean,do u think it's possible to monitoring oracle processes (LWGR,PMON,DBWR,SMON,...) with DTrace by using providers?like fbt or io,i don't know much!!remember,the aim is monitoring oracle database performance !!
There are not any probes for the oracle database.
As I don't use dtrace at the moment, I don't know if it is feasible to use the probes to monitor the oracles processes directly.
if you have performance issues, the Glenn Fawcett's blog "http://blogs.sun.com/glennf/entry/oracle_analysis_101_begining_analysis" may help.