Hello, Ask Tom Team. I have a two-nodes RAC database running 18.4.0 and I'm running a load test (lots of inserts). Basically, two tables are being hit. These tables are using identity column and have a relationship (fk). I'm checking OEM 13c and there is a high cluster wait (gc b...

Hi, I tried to learn PIVOT concept to Pivot the Rows to Columns, but i could not understand how it works internally and how it identify which rows should get turn into Columns. So would you Explain How it Makes Rows as Columns.

Hi Tom ! As there is put a restriction on GTTs: Distributed transactions are not supported for temporary tables does that mean that inline views in a query, i.e. using WITH clause, but those with MATERIALIZED hint will not work properly? If there is neither MATERIALIZED nor INLI...

Hi, There is a SELECT statement which returns columns (around no of coloums are 25). I suppose to apply LISTAGG function on 16 columns (with delimiter as ',') whenever those columns has distinct values during group by one another column. For example, I have below data. col_1 col_...

hi tom i have a databse with 125 tables. i can find the total number of tables of the database by the sql select * from tab; now i would like to know the number of rows in each table of my database with out executing select count(*) from...; each time. please help me sincerely ra...