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. SQL> select name,con_id from v$datafile where name like ‘%system%’; NAME CON_ID […]
Articles Tagged: Managing
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 […]
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 […]
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 […]