Managing Tablespace in Multi-Tenant Environment Part – I

In this article, we will see how tablespaces are managed in a Multi-tenant architecture. Mainly we have 4 types of tablespaces System Tablespace. User permanent tablespace. Temporary tablespace. Undo tablespace. System tablespace must be created while creating a database using either DBCA or manually.

We can see in above output system tablespace is created […]

Read More

Understanding and managing client connectivity

While managing Data Guard Standby databases in our environment one of the key responsibility of DBA is End-user connectivity to a proper database or we can say clients connect to the correct database even in case of failover. To know Oracle DataGuard Oracle Dataguard Architecture   Your client connectivity should be managed in such a […]

Read More

Managing Remote Archived Log File Retention

In the previous article of Automatic deletion of archived redo log, we have seen automatic deletion is enabled by default in the Logical Standby database. Automatic Deletion of Redo Log Files by SQL Apply LOG_AUTO_DEL_RETENTION_TARGET parameter is responsible for this. It has default value 1440 minutes. However, we can manage this parameter and set retention […]

Read More

Managing Role in Oracle

Today we are going to have look at Role in Oracle database. It is the most important part of Oracle database. User Privileges and Roles is the most common task that is performed by Oracle DBA. With roles and privileges, we can easily point out which user has what responsibilities in databases.     Let’s […]

Read More