Database Tutorials

How To Check If There Is a Dictionary-Managed Tablespace On Oracle Database(Extent Management Control)

Extent Management Control can be LOCAL or Dictionary Based. If local, the information in the bitmaps in the datafile

I find OLA HALLENGREN’s maintenance script very successful and practical. In this article I will tell you where to download

In some cases, you may need to move the TEMP tablespace to another diskgroup if there is no space left

With the flashback database we can use the restore point to return the database to a time in the

You can configure SQL Server with sp_configure at instance level. In this article I want to explain most important

In this article I will share a few scripts in postgres databases that I think will help you manage

In PostgreSQL, when a user forgets a password, you can change the user’s password with an authorized user using

Using the FLASHBACK database, we can return the database to a time or a SCN number in the past.

I have described to create linked server to connect to oracle from sql server in my article titled “How

We find the bin directory of PostgreSQL using the command below.

ps -ef |grep postgres

1	ps -ef \|grep postgres

You can see this directory in the