oracle-rac Archives

Query not showing in dba_hist_active_sess_history

By adminPosted on March 17, 2023

Question : The application team claims there was a statement that took about 30s to execute at about a certain […]

By adminPosted on February 23, 2023

Question : Best practices for Oracle 11gR2 Data Guard implies that the primary and standby databases should have the same […]

By adminPosted on November 2, 2022

Question : The following query returns no results, yet it seems like it should. SELECT * FROM gv$session where SID […]

By adminPosted on October 23, 2022

Question : The application team claims there was a statement that took about 30s to execute at about a certain […]

By adminPosted on August 17, 2022

Question : A unit test requires a dbms_scheduler job to run on the same RAC node as the unit test […]

By adminPosted on June 12, 2022

Question : How can this information be found? Answer : My Oracle Support has a certify tab which lists current […]

By adminPosted on May 23, 2022

Question : Is it viable to set a very high undo retention, as to allow flashback queries several weeks back […]

By adminPosted on January 30, 2022

Question : Where does SYSTIMESTAMP come from in multi-server Oracle RAC environment? I’m hoping that the SYSTIMESTAMP derives from a […]

By adminPosted on October 30, 2021

Question : The application team claims there was a statement that took about 30s to execute at about a certain […]