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...

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

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...

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...

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...