DBA Paradise

The place where DBAs grow

  • Home
  • Database
    • Oracle
    • SQL Server
    • Certification
  • My Courses
  • Personal Growth
  • About
  • Contact
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

Things To Know About PGA_AGGREGATE_LIMIT

Things To Know About PGA_AGGREGATE_LIMIT

Database Oracle Oracle
By dianarobete September 24, 2020 1

This week I got a great surprise from one of my readers, Kaley. When I got my mail yesterday, there… Continue Reading

Scripts to Upgrade DB using Export/Import Datapump – Part 2

Scripts to Upgrade DB using Export/Import Datapump – Part 2

Database Oracle Oracle
By dianarobete September 17, 2020 0

Imagine upgrading your database with the export-import method, and getting hundreds of errors on the import. Why would that happen?… Continue Reading

Scripts to Upgrade DB using Export/Import Datapump – Part 1

Scripts to Upgrade DB using Export/Import Datapump – Part 1

Database Oracle Oracle
By dianarobete September 8, 2020 0

In my last blog post, I was showing you one way to upgrade a database to 19c (or to any… Continue Reading

Upgrade Your Database To 19c With Export-Import Datapump

Upgrade Your Database To 19c With Export-Import Datapump

Database Oracle Oracle
By dianarobete August 26, 2020 2

Upgrading the Oracle database to 19c is a very hot topic nowadays! I am not going to give you a… Continue Reading

Does SQLNET.ALLOWED_LOGON_VERSION_SERVER Parameter Affect the Password Version?

Does SQLNET.ALLOWED_LOGON_VERSION_SERVER Parameter Affect the Password Version?

Database Oracle Oracle
By dianarobete August 20, 2020 1

That is a great question! But before answering it, let’s look at what the password version is, and what the… Continue Reading

Posts navigation

Previous 1 2 3 … 19 Next

Recent posts

Remote PDB Clone: ORA-65180

Remote PDB Clone: ORA-65180

April 3, 2021 0
When to use MAX_PDBS parameter

When to use MAX_PDBS parameter

March 16, 2021 0
FILE_NAME_CONVERT vs PDB_FILE_NAME_CONVERT

FILE_NAME_CONVERT vs PDB_FILE_NAME_CONVERT

March 3, 2021 0
What Is A Refreshable Clone PDB?

What Is A Refreshable Clone PDB?

February 20, 2021 0
What Is Local Undo Mode

What Is Local Undo Mode

January 31, 2021 0
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

Proudly powered by WordPress | Theme: Balanced Blog