Area Etica srl

Category: Content
Type: Blog Article

Generated 1 day ago

New blog articles detected

  • Binary Search

    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 […]

Area Etica srl

Category: Content
Type: Blog Article

Generated 1 week ago

New blog articles detected

  • Record data type

    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 […]

Area Etica srl

Category: Content
Type: Blog Article

Generated 3 weeks ago

New blog articles detected

  • Nested table

    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 […]

Area Etica srl

Category: Content
Type: Blog Article

Generated 1 month ago

New blog articles detected

  • Oracle 12C – Password File in ASM

    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 […]

Area Etica srl

Category: Content
Type: Blog Article

Generated 1 month ago

New blog articles detected

  • ORACLE: OVMM 3.4.2

    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 […]

  • DB_ULTRA_SAFE parameter

    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_CHECKS...

  • Oracle12C : Database Firewall

    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 ...

  • ORACLE 12C: Data Migration Assistant

    The Database Migration Assistant for Unicode (DMU) provides a good solution for migrating databases from legacy character sets to the Unicode character set. It is shipping with Oracle Database 12c Rel.1 and becomes the officially supported method for migration to the Unicode character set. Database Character Set Scanner (CSSCAN) and CSALTER utilities are removed from […]

  • Oracle: DBMS_COMPARISON package

    An interesting feature for Oracle 11g is DBMS_COMPARISON package which planned to use compare data within two schemas or between database`s schema. To use DBMS_COMPARISON you have to grant. If you connected as SYSDBA you already have had grant to execute. Other users need execute grants on DBMS_COMPARISON and that user will need to be […]

  • Compress table

    Scenery: Mass distribution of rich and multimedia content over the Internet, made possible through advancements in broadband technologies, also contributes to the growth in overall data volume. The enormous growth in the volume of data that needs to be retained online makes storage one of the biggest cost elements of most IT budgets. The compression […]

  • ORACLE – VM 3.4.2

    During Oracle OpenWorld 2016, the company has announced new version (3.4.2) of their virtualization platform Some of the key new features that have been delivered include: Oracle VM Manager support for previous Oracle VM Server releases: – Manage Oracle VM Server for x86 – 3.4.x, 3.3.x or 3.2.10/11 releases. – Manage Oracle VM Server for […]

  • ORACLE: UTL_MAIL

    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 […]

  • Global Temporary Table

    Global Temporary Table (GTT): Data base version: Oracle Database 11g Environment: DWH This kind of table defines a temporary table for the current connection, these tables do not reside in the system catalogues and are not persistent. Temporary tables exist only during the connection that declared them and cannot be referenced outside of that connection. […]

  • ORACLE 12C : Extended Data Type

    With the previous Oracle database release, long characters strings of more then 4000 bytes had to be handled using CLOB or LONG data types. Starting from Oracle 12c was introduced a new system parameter: MAX_STRING_SIZE. This parameter allows string data types to be much larger when the parameter is changed from its default value STANDARD […]

Area Etica srl

Category: Content
Type: Blog Article

Generated 5 months ago

New blog articles detected

  • Oracle 12C Last Login Time

    In the previous releases, to be able to know the last login time of the user, we had to enable “AUDIT SESSION” and then query the AUD$ table. The SYS.USER$ table in Oracle Database 12c includes a column to store the last login time of the user. As part of the increased security features in […]

Area Etica srl

Category: Content
Type: Blog Article

Generated 6 months ago

New blog articles detected

  • 11gR2 RAC installation and the ORA-15014 error

    In 11gr2, we now have to place the Voting Disk and Cluster Registry files on ASM disks and we do not have the option of placing them on OCFS or raw devices as in the case of previous versions. When you run the root.sh script as part of the 11gR2 RAC installation, it will create […]

Area Etica srl

Category: Content
Type: Blog Article

Generated 6 months ago

New blog articles detected

  • Applicate Baseline

    Have you ever been in a situation in which some database queries that used to behave well suddenly started performing poorly? More likely than not, you traced the cause back to a change in the execution plan. Further analysis may have revealed that the performance change was due to newly collected optimizer statistics on the […]

Area Etica srl

Category: Content
Type: Blog Article

Generated 6 months ago

Out-Market Your Competitors?

Get complete competitive insights on over 2.2 million companies to drive your marketing strategy.

Create Free Account Log in

Out-Market Your Competitors

Get complete competitive insights on over 2.2 million companies to drive your marketing strategy.

Create Free Account

Already a user?  Log in