Oracle VM Manager 3.4.2 supports current and previous Oracle VM Server releases. You can use Oracle VM Manager 3.4.2 to manage Oracle VM Server Release 3.4.x, 3.3.x, 3.2.10, or 3.2.11. If Oracle VM environment consists of Oracle VM Manager Release 3.4.2 and one or more instances of Oracle VM Server at a different release, you…
Leggi tutto
The UTL_MAIL database package is used to manage email. It allows you to send an email message directly from the database server, with cc and bcc, and also catering for RAW attachments. This package is not installed by default due to obvious security reasons, but needs to be installed manually via two scripts: utlmain.sql and…
Leggi tutto
Enqueues are locks that coordinate access to database resources. enq: wait eventindicates that the session is waiting for a lock that is held by another session. The amount of wait time associated with this wait event is excessive and can be responsible for performance issues observed in the application. TX enqueue are acquired exclusive when…
Leggi tutto
One of the most interesting algorithms of research is binary search algorithm. This is the fastest algorithm (algorithm of binary trees apart) to search a data inside a group of elements. In fact it runs in a worst log2(x) comparisions before to find (or not) the data. The only prerequisite is : the set of…
Leggi tutto
In Pl Sql exists a lot of data types : varchar2, number, float, double, boolean, etc, but it may happen that you want to use a structure that contains several types of data, we call it Record type. It’s a simply a new data type. Record type is formed by a group of one or…
Leggi tutto
In PL SQL exists an efficient and adaptable collection of data: Nested table. Nested table is similar to one dimensional array but with some differences : An array has declare number of element – Nested table not. The size of nested table can increase using extend method. An array has always consecutive elements – Nested…
Leggi tutto
Prior to Oracle Database 12c, the password file was always located under $ORACLE_HOME/dbs file structure, even for RAC instances and for RAC ASM cluster. For RAC the DBA had to managed to keep the password file in sync on each node. Now , in Oracle 12c, it is possible to store the password file on…
Leggi tutto
PART 1 LINK Oracle VM 3-4-2 Oracle VM Manager 3.4.2 supports current and previous Oracle VM Server releases. Part 2 You can use Oracle VM Manager 3.4.2 to manage Oracle VM Server Release 3.4.x, 3.3.x, 3.2.10, or 3.2.11. If Oracle VM environment consists of Oracle VM Manager Release 3.4.2 and one or more instances of…
Leggi tutto
DB_ULTRA_SAFE is a new parameter introduced in 11g. It provides an integrated mechanism to offer protection from various possible data corruptions. and provides critical high availability benefits for Oracle Database. Setting DB_ULTRA_SAFE initialization parameter will configure the appropriate data protection block checking level in the database. It will control DB_BLOCK_CHECKING, DB_BLOCK_CHECKSUM, and DB_LOST_WRITE_PROTECT. DB_BLOCK_CHECKING controls…
Leggi tutto
The Oracle Database Firewall enables organizations to protect their databases from internal and external attacks. Oracle Database Firewall allows unauthorised SQL traffic on the network to be monitored and blocked before reaching the database. Database Firewall for Security and Compliance Oracle Database Firewall monitors and enforces normal application behavior in order to avoid the increasingly…
Leggi tutto
Commenti recenti