DBA Paradise

The place where DBAs grow

  • Home
  • Database
    • Oracle
    • SQL Server
    • Certification
  • My Courses
  • Personal Growth
  • About
  • Contact
Creating PDBs By Cloning

Creating PDBs By Cloning

Database Oracle Oracle
By dianarobete January 25, 2021 0

Last post we learned to create PDBs from scratch. This week we will look at creating PDBs by cloning other… Continue Reading

How To Create A PDB From Scratch

How To Create A PDB From Scratch

Database Oracle Oracle
By dianarobete January 12, 2021 0

Did you read my last post about the Multitenant Architecture? Today, we are going to go a bit deeper and… Continue Reading

Intro To Multitenant Architecture

Intro To Multitenant Architecture

Database Oracle Oracle
By dianarobete January 2, 2021 1

I hope all of you had a great winter break! Did you spent some time learning something new? I, personally… Continue Reading

Real-time Stats in Action

Real-time Stats in Action

Database Oracle Oracle
By dianarobete December 18, 2020 0

The last 2 articles I wrote covered the online stats vs real-time stats at a higher level, and then I… Continue Reading

Online Stats in Action

Online Stats in Action

Database Oracle Oracle
By dianarobete November 26, 2020 0

In my last blog post I introduced you to Online Stats and Real Time Stats.Today I will show you, in… Continue Reading

Online Stats vs Real-time Stats

Online Stats vs Real-time Stats

Database Oracle Oracle
By dianarobete November 12, 2020 0

Are you aware of these new terminologies, real-time stats and online stats? Or are these new to you? Maybe you… Continue Reading

Can an inactive session block other sessions?

Can an inactive session block other sessions?

Database Oracle Oracle
By dianarobete November 3, 2020 0

Can an inactive sessions block other sessions? Can a session that shows no SQL_ID in v$session, block other sessions? YES!… Continue Reading

Learn Something New About Alter Table Move

Learn Something New About Alter Table Move

Database Oracle Oracle
By dianarobete October 21, 2020 0

Imagine that you have a large table, let’s say 500GB in size and 500 million rows in it. You need… Continue Reading

19c LISTAGG Can Do Distinct

19c LISTAGG Can Do Distinct

Database Oracle Oracle
By dianarobete October 15, 2020 0

Do you use analytic functions in Oracle? I do not use them as much as I’d like to, but I… Continue Reading

The Story Behind The Ultimate SQL Tuning Formula

The Story Behind The Ultimate SQL Tuning Formula

Personal Growth WHY
By dianarobete September 28, 2020 0

Have you ever wondered why I created The Ultimate SQL Tuning Formula? At the beginning of my career, I remember… Continue Reading

Posts navigation

1 2 … 18 Next

Recent posts

Creating PDBs By Cloning

Creating PDBs By Cloning

January 25, 2021 0
How To Create A PDB From Scratch

How To Create A PDB From Scratch

January 12, 2021 0
Intro To Multitenant Architecture

Intro To Multitenant Architecture

January 2, 2021 1
Real-time Stats in Action

Real-time Stats in Action

December 18, 2020 0
Online Stats in Action

Online Stats in Action

November 26, 2020 0
Online Stats vs Real-time Stats

Online Stats vs Real-time Stats

November 12, 2020 0
Can an inactive session block other sessions?

Can an inactive session block other sessions?

November 3, 2020 0
Learn Something New About Alter Table Move

Learn Something New About Alter Table Move

October 21, 2020 0

Proudly powered by WordPress | Theme: Balanced Blog