Nevermind I think it was how I transferred the zip file. I think it is
working now
On Tue, Apr 13, 2021 at 10:52 AM Jeff Chirco <backseatdba@xxxxxxxxx> wrote:
Thanks for this. However I am getting Permission denied errors even though
I captured and running the perf script all as root
# perf script | ./stackcollapse-perf.pl | ./flamegraph.pl > TT.svg
bash: ./stackcollapse-perf.pl: Permission denied
bash: ./flamegraph.pl: Permission denied
On Tue, Apr 13, 2021 at 9:50 AM Laurentiu Oprea <
laurentiu.oprea06@xxxxxxxxx> wrote:
Hello Jeff,
Yes you can kill the TT process and oracle will spawn a new one. But
before doing that try this to see what is doing on CPU:
perf record -g -F 99 --pid pid_number
-> this will generate a perf.data file (let it run few minutes and hit
ctrl-c)
get : https://github.com/brendangregg/FlameGraph
and run:
perf script | ./FlameGraph-master/stackcollapse-perf.pl |
./FlameGraph-master/flamegraph.pl > TT.svg
You can send the resultate flamegraph
În mar., 13 apr. 2021 la 18:38, Jeff Chirco <backseatdba@xxxxxxxxx> a
scris:
Thanks for those Doc IDs. Those look like they have a symptom of high
PGA usage. For me PGA is looking fine but this process is consuming high
CPU.
Would anything happen if I killed that session? Would another respawn?
On Sun, Apr 11, 2021 at 9:10 PM Leng Burgess <lkaing@xxxxxxxxx> wrote:
Hi Jeff,
Check out these bugs:
Bug 28831971 - PGA Memory Leak On Background Processes Such As MMNL
TT00 Or +APX (Doc ID 28831971.8)
Bug 30719327 - PGA memory leak in TT00, MMNL, and other background
process with patch 28831971 APPLIED (Doc ID 30719327.8)
HTH,
Leng.
On 10 Apr 2021, at 6:08 am, Jeff Chirco <backseatdba@xxxxxxxxx>wrote:
of list consistently (sorting by CPU), I mean it is at the top steadily. I
I am running TOP and I am seeing ora_tt00 backroom process at the top
understand that this has something to do with Redo Transport but I am not
sure in what regards and if there is anything I can or should do about it.
I have 2 databases on this same server both running Data Guard but this
process is showing for only one of the databases. I think both databases
are kind of equal on activity.
Anything else I should be looking at?
Thanks,
Jeff