Thanks Jared,
and also thanks to Stefan. It turned out we did not need to analyze the trace
as detailed after all.
Well, it was quite nice to do something outside my usual borders. I am a
software guy and OS is not usually my playground.
Regards
Lothar
----Ursprüngliche Nachricht----
Von : jkstill@xxxxxxxxx
Datum : 09/10/2018 - 01:30 (GMT)
An : contact@xxxxxxxx
Cc : oracle-l@xxxxxxxxxxxxx, l.flatz@xxxxxxxxxx
Betreff : Re: Stack trace interpretation
I've just spent the day playing with stack traces.
Stefan, your paper and presentation are outstanding!
Of particular interest was the wait_even["event name"] syntax that allows
dumping stack traces in a 10046 trace file.
Somehow I had missed learning about that, very cool.
Should anyone be interested in this topic, here is my reading list for the day.
Note: of course there is Perl :)
https://manybutfinite.com/post/journey-to-the-stack/
Journey to the Stack, Part I
https://manybutfinite.com/post/anatomy-of-a-program-in-memory/
Anatomy of a Program in Memory
https://manybutfinite.com/post/how-the-kernel-manages-your-memory/
How The Kernel Manages Your Memory
If you are interested in dumping the values from little endian words
http://perldoc.perl.org/perlpacktut.html
Perl pack tutor
Leading up to:
Paper:
http://www.soocs.de/public/talk/151118_DOAG2015_Identifying_Performance_Issues_Beyond_The_Oracle_Wait_Interface_PDF.pdf
Identifying performance issues beyond the Oracle wait interface
Presentation:
http://www.soocs.de/public/talk/160616_DOAG_Regio_NUE_Identifying_Performance_Issues_Beyond_The_Oracle_Wait_Interface_PPT.pdf
Troubleshooting Oracle performance issues beyond the Oracle wait interface
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Principal Consultant at Pythian
Pythian Blog http://www.pythian.com/blog/author/still/
Github: https://github.com/jkstill
On Wed, Aug 1, 2018 at 6:08 AM Stefan Koehler <contact@xxxxxxxx> wrote:
Hello Lothar,
the numbers are described on slide 10
(http://www.soocs.de/public/talk/160616_DOAG_Regio_NUE_Identifying_Performance_Issues_Beyond_The_Oracle_Wait_Interface_PPT.pdf)
or on page 5
(http://www.soocs.de/public/talk/151118_DOAG2015_Identifying_Performance_Issues_Beyond_The_Oracle_Wait_Interface_PDF.pdf).
Best Regards
Stefan Koehler
Independent Oracle performance consultant and researcher
Website: http://www.soocs.de
Twitter: @OracleSK
"l.flatz@xxxxxxxxxx" <l.flatz@xxxxxxxxxx> hat am 1. August 2018 um 14:11--
geschrieben:
Hi,
I like to know what the numbers marked in red mean.I guess it is something
like wait time in milliseconds.
sgipcwWait()+880<-gipcWaitOsd()+396<-gipcInternalWait()+20104<-gipcWaitF()
I am also wondering about the moduls called.
E.g. gipcWaitF. My guess is that g somewhat stands for cluster and ipc might
refer to network communication. These are waits related to the ocssd.
Regards
Lothar
