home.social

#oracledatabase — Public Fediverse posts

Live and recent posts from across the Fediverse tagged #oracledatabase, aggregated by home.social.

  1. Bob Bryla @[email protected] ·

    #OracleDatabase 23ai for on-premises #Exadata, offloading AI vector searches, and 17 microsecond latencies... OH MY. I am living in the future.
    blogs.oracle.com/exadata/post/

    #exadata #oracledatabase
  2. Bob Bryla @[email protected] ·

    This may be big. Just as I was getting bored...
    #OracleDatabase #Exadata
    blogs.oracle.com/database/post

    #exadata #oracledatabase
  3. Bob Bryla @[email protected] ·

    Storage performance with #OracleDatabase on #Exadata can be mysterious, confounding, and outstanding especially when you have both DBRM and IORM active with multiple databases. Having a CDB-level Global AWR can give you all the deets on both layers to see what may and may not be happening. This new whitepaper from Oracle tells you more.
    oracle.com/docs/tech/database/

    #exadata #oracledatabase
  4. Bob Bryla @[email protected] ·

    George Boole is finally vindicated in Oracle Database 23c!
    #OracleDatabase #Exadata
    exadatadba.blog/2023/07/03/ora

    #exadata #oracledatabase
  5. Bob Bryla @[email protected] ·

    Even on #Exadata, it will take a while to read 30+ TB from 3 tables. I think there is probably a way to optimize this query from an #OracleDatabase perspective. 🤨

    #oracledatabase #exadata
  6. Bob Bryla @[email protected] ·

    Sometimes #OracleDatabase can seem too fast on #Exadata that you don't think there is a problem:
    exadatadba.blog/2023/06/07/on-

    #exadata #oracledatabase
  7. Bob Bryla @[email protected] ·

    Really, Bard? At least tell me you're being aspirational or telling me what I want to hear. AFAIK there have never been nor can I find any reference to these #OracleDatabase parameters that could indirectly control behavior on #Exadata. 🙄

    #exadata #oracledatabase
  8. Bob Bryla @[email protected] ·

    Each day that goes by when I'm running queries on #OracleDatabase #Exadata, I hope that I will actually run into a case of "Delayed Block Cleanout" that I can confirm wrecks the performance of my query. 🤨

    #exadata #oracledatabase
  9. Bob Bryla @[email protected] ·

    Bloom filters on #OracleDatabase #Exadata can be offloaded IF the datasets are "small enough". What is "small enough"? And what about those ~10 hidden parameters that control bloom filters? Even my biggest Exadata customers can't get a clue from Oracle Development, and it's really ticking me off. 🤬

    #exadata #oracledatabase