tpt-oracle

tpt-oracle copied to clipboard

Hello Tanel, I've added the INST_ID new column to dashtop.sql and tested it on my production DB (Oracle Database 19c Enterprise Edition 19.13.0.0.0). Seems that it works :). I hope...

ds83x

Dashtop Running long time

1

Hi Tanel, Thank you for the mind blowing scripts. When i run dashtop in one of our 19c database it runs for long time so i cancelled it and checked...

balaoracle2021

New script to create SQL baseline from AWR and some changes in the hint.sql

4

tomasz-sroka

question about the ash_wait_chains script

1

Hi Tanel, I have a question about the ash_wait_chains script. https://drive.google.com/file/d/1hkvCbWN-5ofCv04rFubc_uISiCF4dWma/view?usp=sharing - the full output that it returned, and the picture there is as follows: session 433 has blocked many...

slavadba

Hi Tanel, as discussed, here a pull request where fcha.sql has an extra query added to search in fixed sga/x$ksmfsv

FritsHoogland

v$active_session_history and v$sql_plan are not aged out in a coordinated way. Multiple times I had to join to dba_hist_sql_plan.

PMichie

Hello, i have two instance on the same database server (hub and img). My database version in 19.8 For some reason i am getting these error when i execute the...

Ricx24

I want to collect information of a over-all wait event, such as "parallel log write", How could I do it? sincerely Yours Scott Yao China

scott-yao2018

Tree output in wait chain sql

1

Hi Tanel, Would it be possible to have tree-like output in wait chain scripts? below link has an implementation idea - https://github.com/hyee/dbcli/blob/master/oracle/ora/ash/ashchain.sql Sample Output: ============== Leaf Pct AAS EXECS AAS...

ghost

It's just a small change making the scripts compatible with SQLcl or from SQL Developer. Will still work with SQL*Plus.

PhilippSalvisberg