Lightnews — Scholar-powered news

Daniel Overby Hansen @dohdatabase.com · 21h

Wow - this is super cool! 👍

Daniel Overby Hansen @dohdatabase.com · 22h

Are you going by boat? 😎

1 1

Daniel Overby Hansen @dohdatabase.com · 3d

Just lower the resolution of your slide deck. Then it's even more awesome. Enjoy the conference! 😎

1

Daniel Overby Hansen @dohdatabase.com · 3d

Updating your laptop just days before the big show. You're a brave man 🫣

1 2

Daniel Overby Hansen @dohdatabase.com · 11d

Is that a "football" or a "football" field?

1

Daniel Overby Hansen @dohdatabase.com · 12d

@mikaelfransson.bsky.social Thanks for the input. Have you used rsync with Data Pump dump files before? I'd be interested in knowing your experiences. You can drop me a message in the chat or e-mail (daniel.overby.hansen (a) oracle (dot) com) me.

oracle.com

2 1

Daniel Overby Hansen @dohdatabase.com · 12d

If your migration is tight on time, you can save time by copying the Data Pump dump files before the export completes.

Copy Data Pump Files Before the End of the Export

If your migration is tight on time, you can save time by copying the Data Pump dump files before the export completes.

dohdatabase.com

1 2

Daniel Overby Hansen @dohdatabase.com · 18d

Since I'm hopeless at set theory, I always add way too many parentheses. 😎

2

Daniel Overby Hansen @dohdatabase.com · 19d

If you need to move 100 PDBs to new hardware and upgrade to Oracle Database 23ai, what would you do? AutoUpgrade and Refreshable Clone PDBs sounds like a perfect match.

How To Upgrade 100 PDBs And Move Them To Another Server

If you need to move 100 PDBs to new hardware and upgrade to Oracle Database 23ai, what would you do? AutoUpgrade and Refreshable Clone PDBs sounds like a perfect match.

dohdatabase.com

1

Daniel Overby Hansen @dohdatabase.com · 20d

Let's hope they solve the computer issues at the airports by then 😆

1

Daniel Overby Hansen @dohdatabase.com · 26d

Want to stay updated on Oracle Database upgrades, migrations and patching? Here's a list of sessions at Oracle AI World that'll give you a full update.

Oracle AI World – Come Say Hi!

Want to stay updated on Oracle Database upgrades, migrations and patching? Here's a list of sessions at Oracle AI World that'll give you a full update.

dohdatabase.com

1

Daniel Overby Hansen @dohdatabase.com · Sep 9

You need double that after POUG 🫢

1 1

Daniel Overby Hansen @dohdatabase.com · Sep 9

Wake me up at 02 in the morning and I'll write an AutoUpgrade config file in the dark.
For everyone else, here's a quick way to generate a file for a specific database.

AutoUpgrade New Features: A Very Easy Way To Generate A Config File

Writing a config file is essential for using AutoUpgrade efficiently. There are many parameters to choose from, but here's a really easy way of getting started.

dohdatabase.com

1

Daniel Overby Hansen @dohdatabase.com · Sep 8

What about having a bunch of emojis, all serving as delimiters? Then you could add an emoji to each line of code representing what you think of that specific line 😂
Could be useful in code reviews 😎

1

Daniel Overby Hansen @dohdatabase.com · Sep 6

At least my ears weren't bleeding from the noise and pressurization from the cooling system 😂

1

Daniel Overby Hansen @dohdatabase.com · Sep 6

n00b stuff

2

Daniel Overby Hansen @dohdatabase.com · Sep 2

How much space did you reclaim?

Daniel Overby Hansen @dohdatabase.com · Sep 2

Patching any piece of software is essential. Datapatch is smart and keeps your Oracle Database protected at the cost of space in SYSAUX.
But you can reclaim that space. How much can you save?

Patching Eats Your SYSAUX Tablespace

Patching any piece of software is essential. Datapatch is smart and keeps your Oracle Database protected at the cost of space in SYSAUX. But you can reclaim that space. How much can you save?

dohdatabase.com

1 1

Daniel Overby Hansen @dohdatabase.com · Aug 29

That's a Polish gin isn't it? @royfswonger.bsky.social gave me one after he'd been to POUG last year (or was it the year before)? I liked it... I'll make sure to leave space in my suit case next week...

1

Daniel Overby Hansen @dohdatabase.com · Aug 28

I bought a farm 4 years ago 😂

1 2

Daniel Overby Hansen @dohdatabase.com · Aug 26

Do you also prefer having the patch level as part of the Oracle home path? Let AutoUpgrade worry about that and create your Oracle homes even easier.

AutoUpgrade New Features: Create Oracle Home Path Dynamically

Having the database patch level as part of the Oracle home makes it easy to get an overview of your Oracle homes. AutoUpgrade can include release and patch level in your Oracle home path automatically. This change makes it easier to automate your patching.

dohdatabase.com

2

Reposted by Daniel Overby Hansen

Alex Zaballa @alexzaballa.bsky.social · Aug 19

🚀 Moving to #OracleDatabase 23ai?

✅ Upgrade with refreshable clone PDBs+AutoUpgrade
✅ Boost performance with advanced Data Pump
✅ Automate migrations to Autonomous DB

Minimal downtime.
Maximum efficiency.

reg.rf.oracle.com/flow/oracle/...

@mikedietrichde.com
@dohdatabase.com
@dbarj.com.br

1 2

Daniel Overby Hansen @dohdatabase.com · Aug 19

Although Data Pump is a very versatile and flexible tool, it sometimes won't do what you need. So, let's find a viable workaround.

Data Pump Export Doesn’t Use Schema Name to Exclude a Table

Although Data Pump is a very versatile and flexible tool, it sometimes won't do what you need. So, let's talk about workarounds.

dohdatabase.com

2

Daniel Overby Hansen @dohdatabase.com · Aug 14

Those are some good ones. I won't have time to much all of them - but when time allows you'll find me on the front row.

1

Daniel Overby Hansen @dohdatabase.com · Aug 13

Let's just get rid of Product Managers and let ChatGPT and others decide what gets added based on their hallucinations.

2