Administration | Vinicius DBA

Effective Management of $ORACLE_HOME/.patch_storage: Cleanup and Archive Strategies

Hi all, Hope you’re doing good! I had a call with one of our clients, long story short, they would like to cleanup some space under $ORACLE_HOME/.patch_storage directory. There are a lot of options to accomplish this. I will talk a little bit here about…

Vinicius, 3 months ago 0 17 min read

Administration, Database

Automating Bulk Data Loads into Oracle Database with Shell Script and SQL*Loader

Hey everyone, Hope you’re doing good! Recently, a client approached me with an urgent issue: they needed to load 456 files into an Oracle Database table to resolve an integration problem. These files were compressed in ZIP format and contained data in fixed-position records with…

Vinicius, 3 months ago 0 8 min read

Administration, Database

How to Calculate Database Uptime Querying the Oracle Enterprise Manager Views

Hi everyone, Hope you’re doing good! Ensuring high availability of your Oracle databases is crucial for maintaining optimal performance and meeting Service Level Agreements (SLAs). Oracle Enterprise Manager (OEM) provides a comprehensive way for monitoring and managing database uptime. With that said, I received a…

Vinicius, 3 months ago 0 4 min read

Administration, Database

Why is the INSERT Statement Slow? Understanding ‘db file sequential read’ Waits

Some weeks ago, a client called complaining about a slowness during its load in a table. The scenario it was pretty simple: They are loading the table using the INSERT statement for each agency (agency_id), with thousands of records for each agency. They complained that…

Vinicius, 4 months ago 0 9 min read

Administration, Database

How to Efficiently Export a Large List of Tables with DataPump

Hi everyone, hope you’re doing good! I’m a member of a WhatsApp Group in Brazil for DBAs (not only Oracle), and one of the members asked about how to export a large list of tables with DataPump. This question may sound a little bit basic,…

Vinicius, 4 months ago 0 3 min read

Administration, Database

Disk failed even using Multipath. How? Why?

Hi everyone, hope you’re doing good. In my last post I explained some basic concepts about Multipath and the importance to use it. You can read more here: Device Mapper Multipath – How this works? Why as a DBA I should concern about it? On…

Vinicius, 7 months ago 0 8 min read

Administration, Database

Device Mapper Multipath – How this works? Why as a DBA I should concern about it?

Hi everyone, hope you’re doing good. On this blog post, I’ll discuss about DM Multipath and why this is so important when we are talking about Databases. OK, let’s first understand about how the disks interacts with the databases and/or vice-versa. If we think about…

Vinicius, 7 months ago 0 8 min read

Administration, Database

Scheduler Job does not exist (not visible) in Snapshot Standby Database

Hi everyone! Hope you are doing good! I got a call from a client during their DR test. We do know that usually DR test means when the entire workload is moved to DR site. Some clients never execute DR test. 🙂 For this specific…

Vinicius, 11 months ago 0 5 min read

Category: Administration

Effective Management of $ORACLE_HOME/.patch_storage: Cleanup and Archive Strategies

Automating Bulk Data Loads into Oracle Database with Shell Script and SQL*Loader

How to Calculate Database Uptime Querying the Oracle Enterprise Manager Views

Why is the INSERT Statement Slow? Understanding ‘db file sequential read’ Waits

How to Efficiently Export a Large List of Tables with DataPump

Disk failed even using Multipath. How? Why?

Device Mapper Multipath – How this works? Why as a DBA I should concern about it?

Scheduler Job does not exist (not visible) in Snapshot Standby Database

About

Blog recognized by:

Disclaimer

Find

Archive

Blogroll Internacional

Blogroll Nacional

Links

Visitors