This post will discuss How to check encrypted tablespace in the Database. This question will be useful when you are checking the security of the database. What is a TDE wallet? Transparent Data Encryption (TDE) is a feature available in Oracle Database for securing sensitive data at the storage level. The TDE Wallet is a […]
How To Export -Import TDE Master Encryption Key
We need to export/import the TDE Master Encryption key when we are migrating TDE encrypted NON-CDB to the CDB database or migrating encrypted PDB to another CDB database. How To Export TDE Master Encryption Key When you are migrating PDB from one database to another and the source PDB is encrypted, then you need to […]
How to monitor the progress of refresh of Materialized views
Here in this post, we will find out how to monitor Materialized views refresh What is a materialized view? A materialized view in Oracle is a database object that contains the results of a query. They are local copies of data located remotely or are used to create summary tables based on aggregations of a […]
How to drop the sql baseline in Oracle
You can drop a SQL Plan Baseline in Oracle using the DBMS_SPM.DROP_SQL_PLAN_BASELINE function. DBMS_SPM.DROP_SQL_PLAN_BASELINE ( sql_handle IN VARCHAR2 := NULL, plan_name IN VARCHAR2 := NULL) RETURN PLS_INTEGER; Syntax To drop all the plans of the sql statement DECLARE l_result INTEGER; BEGIN l_result := DBMS_SPM.drop_sql_plan_baseline(sql_handle => ‘&SQL_HANDLE’); END; / To drop a particular plan of the […]
how to find file based on size in linux
While managing the space on the filesystem in Linux, We often have a question about how to find file based on the size in Linux. This can be quickly done using the find command. The general syntax is find . -type f -size +<size> -exec ls -al {} \; Here are the suffixes available for […]
How to check automatic statistics collection in Oracle in 11g
Automatic statistics collection is a new feature starting 10g. Oracle has done a lot of changes to it starting with 11g. In this article, we will see How to check automatic statistics collection in Oracle, How to enable automatic statistics collection in Oracle What is automatic statistics collection? Automatic statistics jobs automatically gather Missing and […]