Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Chris Saxon

    Statistics Gathering using older version feature

    Hello Connor/Chris, I am in the middle of troubleshooting a slow-running application maintenance job for a database that has been migrated/upgraded from on-premise 12.1.0.2 on linux x64 to Exadata Cloud @ Customer setup. Many of the "Top SQLs" that have regressed are internal SQL...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Generate java code in SQL/PLUS

    Hi, Tom, How are you. I have below source code: create or replace and compile java source named "Something" as import oracle.sql.*; public class Something { ............... } When i wrote above java source file under SQLPLUS, I got the following errors: ERROR at line 1: OR
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Questions on Locking

    Hi Tom, Here are the few questions on Locking. 1)How do I use v$lock to figure out lock details ? Details like whos has locked,on which table,who else is waiting, and what type of locking (shared or exlusive ?), since when it is locked. 2)Why and when exclusive/shared locks are u...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Materalized Hint.

    Hi Tom, when we use materalized hint in with clause that data is stored in GTT(Global temporary table). In GTT data is release either when commit happens or when session ends. I also read in one of your page that suppose 100 users are using the query that contains with clause, qu...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    How to improve timings of query executed on a DB link?

    Hello Team, First of all, thanks for all the good work you are doing. It would be great if you can help us understand how we can improve timings of query executed on a DB link. Consider an Oracle instance (DB1) that can talk with another oracle instance (DB2) via DB Link. A selec...
    #MISC#
    #ACTIONS#

Upcoming Office Hours

Upcoming Office Hours report