If so, you’re in luck. You may have ALTER SESSION privileges in your database, but when you enable a 10053 trace and run your query,
Tag: oracle
Oracle Exadata Offloading Anomalies: How Much is DML a Factor?
I was testing a few of the functions identified in V$SQLFN_METADATA to see if some of the REGEXP-related functions were offloadable (they are!) and the
Can Exadata take you Beyond “Infinity and Beyond” with Non-Numbers?
Let me clarify… in a previous post, I showed some of the arithmetic around some of Oracle’s floating point literals and how that arithmetic didn’t
In “Case” you missed it: Part 1
And you probably didn’t miss it, since I just posted it. A question came up a couple times recently, “Do WHERE clauses with CASE expressions
An Oracle Data Dictionary Anomaly: VARCHAR2, CLOB, and Exadata
A.K.A. The Serendipitous Nature of Debugging ORA- Errors There is usually an Exadata angle to my posts, and this one won’t disappoint. It started out