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 check encrypted tablespace in the Database Read More »
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 …
In this post, we will learn about what is cursor in oracle, the types of cursors, how to fetch the row, and how to close the cursor. I hope you will like this What is a cursor in oracle? Oracle Uses a work area called Private SQL areas to execute SQL Statements and store information. …
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 monitor the progress of refresh of Materialized views Read More »
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 …
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 find file based on size in linux Read More »
