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_at_soocs.de> 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: _at_OracleSK
>
> > "l.flatz_at_bluewin.ch" <l.flatz_at_bluewin.ch> 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
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l