Transparent Data Encryption In Oracle 11g (11.2.0.4) RAC Database

Transparent Data Encryption In Oracle 11g (11.2.0.4) RAC Database

Transparent Data Encryption In Oracle: In this article we will discuss about configuring and enabling Transparent Data Encryption In Oracle 11g (11.2.0.4) RAC Database. Let’s see steps how to configure TDE. Take full database RMAN backup: Take full database RMAN backup before starting the TDE implementation activity. Use below script to take full Database RMAN … Read more

How to kill a session in Oracle

How to kill a session in Oracle

How to find and kill a session in Oracle: During this article we are going to discuss the way to find and kill Oracle sessions. Many times we are facing issue in Database Level, then we would to check and find out sessions details, how much there are active/inactive/killed sessions and might killed some sessions. … Read more

ESTIMATE required diskspace for EXPORT backup

ESTIMATE required diskspace for EXPORT backup

ESTIMATE required diskspace for EXPORT backup: During this article we are going to discuss about ESTIMATE required diskspace for EXPORT backup using ESTIMATE_ONLY parameter in Oracle Database. Here we’ll do that activity on Oracle 19c Database. ESTIMATE_ONLY parameter in Oracle Database: ESTIMATE_ONLY parameter is utilized in EXPDP command, to estimate the disc space required for … Read more

How to generate tablespace ddl in Oracle

How to generate tablespace ddl in Oracle

How to generate tablespace ddl in Oracle: In this article we will see How to generate tablespace ddl in Oracle for one tablespace and all tablespaces. Generate one tablespace’s ddl By this below query you can generate tablespace ddl for a specified tablespace. After run this query it will ask you to provide the tablespace_name. … Read more

How to Drop And Recreate Temp Tablespace In Oracle

How To Drop And Recreate Temp Tablespace In Oracle

Drop And Recreate Temp Tablespace In Oracle : During this article we’ll see how to Drop And Recreate temp tablespace In Oracle Database. Note :- While doing this activity, existing temporary tablespace may have existing live sessions, due to same oracle won’t let us to drop existing temporary tablespace. Resulting, we need to kill existing … Read more

Changing the Database Archiving Mode In Oracle

Changing the Database Archiving Mode In Oracle

Changing the Database Archiving Mode In Oracle: In this article we will discuss how Changing the Database Archiving Mode In Oracle. There are 2 types of logging mode in oracle database: Archivelog mode : In this mode, after the online redo logs are filled , it will move to archive location. Noarchivelog mode : In … Read more

Managing Datafiles in Oracle Database

Managing Datafiles in Oracle Database

Managing Datafiles in Oracle Database: In this article we will discuss about Managing Datafiles in Oracle Database. Guidelines for Managing Datafiles: Datafiles are physical files of the operating system that store the data of all logical structures in the database. They must be explicitly created for each tablespace. Oracle Database assigns each datafile two associated … Read more