Execess redolog generation during hot backup
What happens during tablespace begin backup?
When a tablespace is in backup mode, datafile’s header belonging to the tablespace will be freezed rather than the datafile.So checkpoint happens and update the datafile header with checkpoint SCN and there after it is freezed until we take tablespace out of backup mode.
Since […]
There are many ways to troubleshoot the performance Issues in oracle database. Here you can find some methods to troubleshoot performance Issues.
Scenario 1:
Users are complaining that Application is slow.
DBMS_CRYPTO package provides an interface to encrypt and decrypt stored data. For example, the table CUST_MASTER has three columns ACNO,NAME,BALANCE and you wish to encrypt the column NAME and BALANCE. Using the dbms_crypto.ENCRYPT functions,you can create your function to encrypt data.
Example:
Create a table CUST_MASTER .
