Memory Diagnostics – Part 2
Well I had this post ready to publish today and did last check on google to find some additional resources and it turned out that Tanel got this one just day before.It seems that memory is popular topic these days. I am not going to repeat it since he covered this topic pretty good. Here … Read more
Memory Diagnostics – PGA Part 1
Second and very short post related to Oracle memory structures.This time I will focus on PGA . Oracle offers many diffrents tools ( views, tables, dumps etc.. ) to gather information about these structures.This time I will introduce hidden oradebug options. Reading these files is not difficult. There are also heap analyzers out there on … Read more
Memory Annotations and Oradebug
Annotations can help to detect leaks and other problems with allocations of memory. I will again use “old friend “ ORADEBUG There are two hidden options related to memory annotations: MEMANOTEND <shared|private> – Record end-state mem annotations MEMANOTDUMP <shared|private> <level> - Dump memory annotations and four undocumented parameters : _mem_annotation_pr_lev private memory annotation collection level … Read more
Oracle diagnostic events Part 5
I know I already did four blogs on events but there is more to cover. This short post will focus on some of the trace option and it’s components. trace[target ]<components> In previous post I have used example something like: alter session set events ‘trace[sql_mon] memory=high,get_time=highres’; where sql_mon is target of interest Just for reference … Read more
