Oracle Scheduler Concepts

Oracle provides advances scheduler capabilities through the database Scheduler. To simplyfy management tasks, as well as offering a high rich set of functionality for complex scheduling needs, Oracle provides a collection of functions and procedures in the DBMS_SCHEDULER package. Collectively, these functions are called the Scheduler, and they are callable from any PL/SQL program.

What can the Scheduler Do ?

The Scheduler provide complex enterprise scheduling functionality, which you can use to:

1. Schedule job execution based on time.

2. Reuse existing programs and schedules

3. Schedule job processing in a way that models your business requirements

4. Manage and monitor jobs

5. Execute and manage jobs in a clustered environment

Thanks/

A.F.MD.IQBAL

Sr. Programmer

STANDARD GROUP

Database Security-1

Oracle Transparent Data Encryption (TDE)


#) Oracle Transparent Data Encryption addresses the encryption problem by deeply embedding encryption in the Oracle database.

#) Oracle database automatically encrypts the data before writing the information to disk. Subsequent select operations will have the data transparently decrypted so the application will continue to work normally.

#) Encryption works by passing clear text data along with a secret, known as the key, into an encryption program. The encryption program encrypts the clear text data using the supplied key and returns the data encrypted.

#) Oracle Wallet, uses certificates from a Certificate Authority, by which Administrator initialize DB master key.


#) TDE uses the External Security Module (ESM) to generate encryption keys, to provide functions for encryption and decryption, and to store encryption keys securely inside and outside the database.

->** When a table contains encrypted columns, a single column key is used regardless of the number of encrypted columns in that table. The keys for all tables containing encrypted columns are stored in a single column in a dictionary table in the database. That column is encrypted with the database server’s master key, preventing any use of those keys through unauthorized access. The master key is stored in a wallet outside the database. The wallet is created using Oracle Wallet Manager, and the master key is generated by the ESM.