Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Connor McDonald

    Cluster Waits Rac database

    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...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    How does PIVOT work?

    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.
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    With clause in distributed transactions

    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...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Listagg function in Oracle

    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_...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Finding the number of rows in each table by a single sql

    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...
    #MISC#
    #ACTIONS#

Upcoming Office Hours

Upcoming Office Hours Cards

Free training, how-tos and Q&A with Oracle experts, every month! Learn more