Diana Robete

database advise, step by step guides, how to emails

Real-time Stats in Action

Published: Fri, 12/18/20

The last 2 articles I wrote covered the online stats vs real-time stats at a higher level, and then I went into details on online stats. Today is the…

Join Now The Ultimate SQL Tuning Formula

Published: Sun, 11/29/20

What makes a great DBA? Knowing how to approach and solve performance problems is one of the vital skills. if you want to be a great DBA, you must…

Online Stats in Action

Published: Thu, 11/26/20

In my last blog post I introduced you to Online Stats and Real Time Stats. Today I will show you, in action, with e amples, how the Online Stats work,…

Online Stats vs Real-time Stats

Published: Thu, 11/12/20

Are you aware of these new terminologies, real-time stats and online stats? Or are these new to you? Maybe you thought they are the same thing, just…

Can an inactive session block other sessions?

Published: Tue, 11/03/20

Can an inactive sessions block other sessions? Can a session that shows no SQL_ID in v$session, block other sessions? YES! It can! And as a matter of…

Learn Something New About Alter Table Move

Published: Thu, 10/22/20

Imagine that you have a large table, let’s say 500GB in size and 500 million rows in it. You need to get rid of 95% of the data in the table. How…

19c LISTAGG Can Do Distinct

Published: Thu, 10/15/20

Do you use analytic functions in Oracle? I do not use them as much as I’d like to, but I love analytic functions, as they really transform the…

Things To Know About PGA_AGGREGATE_LIMIT

Published: Fri, 09/25/20

This week I got a great surprise from one of my readers, Kaley. When I got my mail yesterday, there was a package with my name on it, and inside the…

<< First < Previous Next >