Flavio Sarcos's Avatar

Flavio Sarcos

@fsarcos.bsky.social

Oracle ACE | Database Specialist ๐Ÿ“‚ Managing databases so you donโ€™t have to. ๐ŸŽฎ Gamer at heart, but my backlog is winning. ๐Ÿ“บ Anime fan on a tech journey. ๐Ÿ’ป Blogging: https://database-verse.com/

77 Followers  |  192 Following  |  14 Posts  |  Joined: 26.11.2024  |  1.5977

Latest posts by fsarcos.bsky.social on Bluesky

Thanks Dani!

20.10.2025 15:13 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Preview
ExaDB-D vs ExaDB-XS in OCI: Architecture, Pricing, and When to Choose Each When people hear Exadata in OCI, the first reaction is usually โ€œso itโ€™s all the same thing, right?โ€ Not quite. Oracle actually offers several flavors of Exadata in the cloud. Thereโ€™s ExaDB-D, the dโ€ฆ

๐Ÿ”ฅ New blog on DatabaseVerse!
ExaDB-D vs ExaDB-XS in OCI: two Exadata models, two philosophies.
Architecture, pricing, scaling, and when each one fits best.

Read here ๐Ÿ‘‰ database-verse.com/2025/10/06/e...

#Oracle #Exadata #OCI #ExaDBXS #ExaDBD #23ai #DatabaseVerse #OracleACE

07.10.2025 07:53 โ€” ๐Ÿ‘ 1    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Preview
OCI Local Peering explained: A Step-by-Step guide with Demo I usually write about Oracle databases and Oracle Engineering Systems, but not much about OCI. The funny thing is, I use OCI quite often. Iโ€™m not a DevOps expert, I just know the basics, but whenevโ€ฆ

Blog link here: database-verse.com/2025/09/15/o...

15.09.2025 08:12 โ€” ๐Ÿ‘ 1    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0

New blog: setting up ๐ฅ๐จ๐œ๐š๐ฅ ๐ฉ๐ž๐ž๐ซ๐ข๐ง๐  in ๐Ž๐‚๐ˆ! Walkthrough of connecting ๐ฉ๐ฎ๐›๐ฅ๐ข๐œ โ†’ ๐ฉ๐ซ๐ข๐ฏ๐š๐ญ๐ž subnets across ๐•๐‚๐๐ฌ. Includes screenshots, routing tips, and ๐๐’๐† gotchas. Blog link in comments.

15.09.2025 08:12 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 1    ๐Ÿ“Œ 0
Preview
Thin Cloning with Oracle Exascale: What You Need to Know Last week I wrote about Exascale. If you missed it, you can check it out here: Exploring Oracle Exascale: Architecture, Storage Changes, and Why It Matters Exascale is impressive in many ways, but โ€ฆ

Oracle Exascale takes cloning to the next level.
๐—ฆ๐—ฝ๐—ฎ๐—ฟ๐˜€๐—ฒ clones? Read only.
๐—”๐—–๐—™๐—ฆ clones? Performance pain.
Now you get ๐—ถ๐—ป๐˜€๐˜๐—ฎ๐—ป๐˜, ๐˜๐—ต๐—ถ๐—ป, ๐—ฝ๐—ฟ๐—ผ๐—ฑ๐˜‚๐—ฐ๐˜๐—ถ๐—ผ๐—ป-๐—ฟ๐—ฒ๐—ฎ๐—ฑ๐˜† clones.

Check it out latest post about thin clonning with Oracle Exascale

Cheers,
FS

#Oracle #Exascale #Oracle23ai #PDBCloning #OracleACE

18.08.2025 06:57 โ€” ๐Ÿ‘ 2    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Preview
Exploring Oracle Exascale: Architecture, Storage Changes, and Why Itย Matters Iโ€™m quite familiar with Exadata platforms, having been lucky enough to work on several projects over the past five years helping customers migrate their on-premises database workloads to the cloud. Most of these have been to Exadata Cloud at Customer (ExaDB-C@C) and Exadata on Dedicated Infrastructure (previously ExaCS, now ExaDB-D). When I first heard about Exascale (Oracle Exadata Database Service on Exascale Infrastructure…

๐Ž๐ซ๐š๐œ๐ฅ๐ž ๐„๐ฑ๐š๐ฌ๐œ๐š๐ฅ๐ž is here!
๐๐ž๐ฐ ๐š๐ซ๐œ๐ก๐ข๐ญ๐ž๐œ๐ญ๐ฎ๐ซ๐ž, ๐•๐š๐ฎ๐ฅ๐ญ ๐ฌ๐ญ๐จ๐ซ๐š๐ ๐ž, ๐ง๐จ ๐€๐’๐Œ, and ๐Ÿ๐š๐ฌ๐ญ๐ž๐ซ ๐๐ƒ๐ ๐œ๐ฅ๐จ๐ง๐ข๐ง๐ . I explored what makes it different and why it matters. ๐“๐ก๐ข๐ฌ ๐ข๐ฌ ๐ฃ๐ฎ๐ฌ๐ญ ๐ญ๐ก๐ž ๐›๐ž๐ ๐ข๐ง๐ง๐ข๐ง๐ .

#Exascale #Exadata #OracleACE

12.08.2025 06:33 โ€” ๐Ÿ‘ 2    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Preview
Running Hugging Face models inside Oracle 23ai with ONNX andย OML4Py About a year ago, I published a blog post on vector search in Oracle 23ai. At that time, I wasnโ€™t aware of the ONNX format or how it could be used to bring machine learning models into the database. That realization came later, and ever since, Iโ€™ve been thinking: "I need to write a follow-up post to cover this!" Well... the time has finally come.

A year ago, I explored vector search in Oracle 23ai using external models. Now, it's all happening inside the database.

ONNX + OML4Py + Oracle 23ai = pure magic (with SQL).

New blog is out! let me know what you think!

Cheers,
FS

#Oracle23ai #AI #VectorSearch #EmbeddingModels #OracleACE

05.08.2025 06:17 โ€” ๐Ÿ‘ 2    ๐Ÿ” 1    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Preview
ODCC: The missing piece in your Oracle CPU scalingย strategy Over the past few months, Iโ€™ve been working with Oracle Dynamic Scaling (ODyS) and Oracle Dynamic CPU Count (ODCC) in a customer environment on EXADB-D X9M and X11. These two tools are game changers if you want to allocate only the resources you really need and, more importantly, save some money. ODyS takes care of scaling OCPUs/ECPUs up or down based on actual demand, so your…

Tired of managing cpu_count manually? ODCC takes care of it for you. In my latest blog, I show how ODCC + ODyS can automate scaling and save resources on Exadata.
Check it out

Cheers,
FS
#OracleDatabase #ODCC #ODyS #ExaDB-D #OracleAce

21.07.2025 06:34 โ€” ๐Ÿ‘ 2    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Preview
No more manual KILL: Oracle 23ai handles blocking with Priorityย Transactions If you are a DBA youโ€™ve probably received an urgent call time to time from someone saying my applications is blocked, the query is not ending or you are seeing in the monitoring that blocking session counts is increasing overtime and you are looking for what is going on in the database Good news in 23ai! this is probably going to change (hopefully!)

Kill that session! how many times have we, DBAs, had to do that manually?

Discover how Oracle 23aiโ€™s Priority Transactions feature can resolve blocking automatically by rolling back low-priority sessions, no more manual KILLs

Drop a comment if you've tried this feature
#Oracle23ai #OracleACE

14.07.2025 06:39 โ€” ๐Ÿ‘ 3    ๐Ÿ” 1    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Preview
DGPDB Switchover Failed! Lessons from a Live Demo Disaster (andย Recovery) Itโ€™s been a while since my last blog post life and work kept me busy. But recently, I gave a webinar on Oracle 23ai Per-PDB Data Guard (DGPDB), and letโ€™s just say... the live demo didnโ€™t go as planned ๐Ÿ˜… My goal was to showcase a simple PDB switchover in real-time. I had validated everything. All signs pointed to…

My DGPDB switchover demo failed - live.
And honestly? Iโ€™m glad it did.

What looked like a simple switchover turned into:
* ORA-28098 (password grace period)
* Dropped PDB by mistake with REMOVE PLUGGABLE DATABASE

It was painful, but I learned a lot, check it out!

Cheers,
FS
#Oracle23ai #DGPDB

11.07.2025 09:49 โ€” ๐Ÿ‘ 1    ๐Ÿ” 1    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Preview
Hot Online Patching in Oracle: Benefits andย Pitfalls If you need to patch your database, you want to do it easily, right? why complicate it? As a DBA, I have a choice to avoid interrupting the availability of the database instance. So, why bother stopping the database if you can do something online? In this blog, I want to talk about hot online patching. It is not about RAC rolling patches.

๐Ÿ”ฅ Hot Online Patching: Worth It or Risky?

Zero downtime sounds greatโ€”but at what cost? โš 

โœ… No interruptions
โœ… High availability
โš  Increased memory usage
โš  Not all patches work

When should you use it? Find out in my latest post + decision flowchart as example! ๐Ÿ‘‡

#Oracle #DBA #Patching

17.03.2025 07:11 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Preview
Oracle Online Index Rebuild Failure: How SMON & DBMS_REPAIR Can Save You Imagine running an online index rebuild on an Oracle 19c database, only to have it unexpectedly fail. No rollback in progress, no active session, just an error leaving your index in limbo. Thatโ€™s eโ€ฆ

Ever had an online index rebuild fail unexpectedly? ๐Ÿ˜ฑ ๐™Ž๐™ˆ๐™Š๐™‰ & ๐ƒ๐๐Œ๐’_๐‘๐„๐๐€๐ˆ๐‘.๐Ž๐๐‹๐ˆ๐๐„_๐ˆ๐๐ƒ๐„๐—_๐‚๐‹๐„๐€๐ ensure automatic recovery & database stability. Learn how Oracle self-heals!

Read more in my recent blog post!

#Oracle #Database #DBA #DatabaseRecovery #SMON

10.02.2025 08:09 โ€” ๐Ÿ‘ 4    ๐Ÿ” 1    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Post image

Become part of the Oracle ACE Program LinkedIn group and join the community of tech enthusiasts and experts from all over the world! โ™ ๏ธ

Stay up to date with what the ACEs are doing and see how you can also become an ACE ๐Ÿ‘‰
www.linkedin.com/groups/72183/

31.01.2025 09:26 โ€” ๐Ÿ‘ 5    ๐Ÿ” 3    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Preview
Mastering Metadata with Oracleโ€™s DBMS_DEVELOPER inย 23.7 Oracle has introduced numerous features in 23ai, with a significant focus on developersโ€”donโ€™t you agree? I certainly think so! Letโ€™s take a look at some of the things Oracle has done to enhance the developer experience in this release: AI Vector Search: This feature enables fast similarity searches on both structured and unstructured data by utilizing vectors. It allows developers to integrate AI capabilities into applications without requiring specialized AI expertise.

๐Ÿš€ Explore the power of Oracle DBMS_DEVELOPER in 23.7! Unlock metadata with the GET_METADATA function for faster, simpler JSON-based insights. Dive into my latest blog for examples, use cases, and real-world tips.

#Oracle23ai #Database #23.7

27.01.2025 15:52 โ€” ๐Ÿ‘ 2    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Preview
Step-by-Step Guide to Oracle Key Vault Deployment in OCI: Benefits andย Features In today's world, data security is paramount as organizations face increasing threats to their sensitive information. Oracle Key Vault (OKV) is a secure and standards-compliant key and secrets management appliance that allows you to store, manage, and share your security objects. Oracle Key Vault centralizes key and secrets management across your organization quickly and efficiently. Security objects that you can manage with…

Protect what matters most with Oracle Key Vault! ๐Ÿ”’ Simplify encryption key management, enhance security, and stay compliantโ€”all in one powerful tool. Ready to level up your data protection? Letโ€™s dive in! ๐Ÿš€

#OKV #OracleKeyVault #DataSecurity

Cheers,

07.01.2025 07:13 โ€” ๐Ÿ‘ 1    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0

@fsarcos is following 20 prominent accounts