Skip to content

All Kinds of Exadata Stuff

If you want the rainbow, you have to put up with the rain.

  • Home
  • Oracle SQL Scripts
  • Cool Links
  • About

Tag: oracle

Want 10053 traces? Can you query GV$ views?

August 16, 2022 Bob Bryla

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,

Continue reading

Oracle Exadata Offloading Anomalies: How Much is DML a Factor?

April 21, 2022 Bob Bryla

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

Continue reading

Can Exadata take you Beyond “Infinity and Beyond” with Non-Numbers?

March 22, 2021 Bob Bryla

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

Continue reading

In “Case” you missed it: Part 1

July 10, 2020 Bob Bryla

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

Continue reading

An Oracle Data Dictionary Anomaly: VARCHAR2, CLOB, and Exadata

October 1, 2019 Bob Bryla

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

Continue reading

Recent Posts

  • Are IOTs Relevant in the Exadata World? Part 1
  • Oracle “Always Free” Autonomous Database: A Free Slice of Exadata?
  • Oracle Compression Syntax: Read the Freakin’ Manual?
  • Want 10053 traces? Can you query GV$ views?
  • Hidden Parameter Bug Fixes That Don’t Always Fix the ORA-00600 Bug

Recent Comments

Bob Bryla on Oracle “Always Free…
SO on Oracle “Always Free…
Bob Bryla on Hidden Parameter Bug Fixes Tha…
Dom Brooks on Hidden Parameter Bug Fixes Tha…
Exadata In-Memory Co… on Exadata In-Memory Column Store…

Archives

  • January 2023
  • November 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • September 2021
  • August 2021
  • April 2021
  • March 2021
  • December 2020
  • September 2020
  • July 2020
  • May 2020
  • April 2020
  • March 2020
  • January 2020
  • November 2019
  • October 2019
  • June 2019
  • May 2019
  • March 2019
  • February 2019

Categories

  • Uncategorized

Meta

  • Register
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.com
Website Powered by WordPress.com.
  • Follow Following
    • All Kinds of Exadata Stuff
    • Already have a WordPress.com account? Log in now.
    • All Kinds of Exadata Stuff
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar