Oracle JRockit JVM

• Oracle JRockit JVM

The Oracle JRockit JVM is the industry's highest performing Java Virtual Machine now built into Oracle Fusion Middleware. It brings industry leading real time infrastructure capabilities with JRockit Real Time and unparallelled JVM diagnostics with JRockit Mission Control.
http://www.oracle.com/technetwork/middleware/jrockit/overview/index.html

Oracle Exadata Database Machine

The Oracle Exadata Database Machine is engineered to be the highest performing and most available platform for running the Oracle Database. Oracle Exadata runs all types of database workloads including Online Transaction Processing (OLTP), Data Warehousing (DW) and consolidation of mixed workloads. Simple and fast to implement, the Oracle Exadata Database Machine powers and protects your most important databases and is the ideal foundation for a consolidated database cloud.
http://www.oracle.com/us/products/database/exadata/overview/index.html

toad 9.1 toad 9.5 problem with oracle 11g client

toad 9.1 toad 9.5 problem with oracle 11g client

I logged a support ticket at Quest. The support over there is really quick and helpful. In less than a day I got a message back that they were going to try it themselves, it went even to the technical people (development team) and after a few mails of back and for I got this final message: "Unfortunately, it was confirmed by our team's technical lead that Toad version 9.5 only support Oracle server 11g and not Oracle client 11g. My only suggestion for you is to install another client on your machine that is 10gR2 version or lower."

http://dgielis.blogspot.com/2007/11/quest-toad-on-oracle-11g-not-supported.html

ORACLE_HOME

ORACLE_HOME refers to either:

    a directory where the Oracle software is installed; or
    an environment variable pointing to the directory where the Oracle software is installed.


Windows

Check current value:

echo The current ORACLE_HOME is %ORACLE_HOME%

Set the ORACLE_HOME environment variable:

set ORACLE_HOME=C:\oracle\ora10.2

On Windows the ORACLE_HOME may also be stored in the registry:

    HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
    HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEID
    HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ALL_HOMES
    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services

http://www.orafaq.com/wiki/ORACLE_HOME

The Oracle System ID (SID)

The Oracle System ID (SID) is used to uniquely identify a particular database on a system. For this reason, one cannot have more than one database with the same SID on a computer system.
When using RAC, all instances belonging to the same database must have unique SID's.

http://www.orafaq.com/wiki/ORACLE_SID

Oracle Spatial and Graph

• Oracle Spatial and Graph

Oracle Spatial and Graph, formerly Oracle Spatial, forms a separately-licensed option component of the Oracle Database. The spatial features in Oracle Spatial and Graph aid users in managing geographic and location-data in a native type within an Oracle database, potentially supporting a wide range of applications — from automated mapping/facilities-management and geographic information systems (GIS), to wireless location services and location-enabled e-business
http://en.wikipedia.org/wiki/Oracle_Spatial_and_Graph

• Oracle Spatial and Graph

The Oracle Spatial and Graph option for Oracle Database 11g includes full 3-D and Web services support to manage all geospatial data including vector and raster data, topology, and network models. Oracle Spatial and Graph works in tandem with Oracle Locator, a feature included with every Oracle Database edition that provides mapping capabilities needed to location-enable many business applications.
http://www.oracle.com/us/products/database/options/spatial/overview/index.html?origref=http://www.oracle.com/us/products/database/options/spatial/overview/index.htm

NULLIF Function

NULLIF Function
In Oracle/PLSQL, the NULLIF function compares expr1 and expr2. If expr1 and expr2 are equal, the NULLIF function returns NULL. Otherwise, it returns expr1.
http://www.techonthenet.com/oracle/functions/nullif.php

NVL Function

NVL Function
In Oracle/PLSQL, the NVL function lets you substitute a value when a null value is encountered.
http://www.techonthenet.com/oracle/functions/nvl.php

The Oracle DUAL table

The Oracle DUAL table
dual is a table which is created by oracle along with the data dictionary. It consists of exactly one column whose name is dummy and one record. The value of that record is X.
http://www.adp-gmbh.ch/ora/misc/dual.html

What are the difference between DDL, DML and DCL commands ?

DDL
Data Definition Language (DDL) statements are used to define the database structure or schema. Some examples:

    CREATE - to create objects in the database
    ALTER - alters the structure of the database
    DROP - delete objects from the database
    TRUNCATE - remove all records from a table, including all spaces allocated for the records are removed
    COMMENT - add comments to the data dictionary
    RENAME - rename an object

DML
Data Manipulation Language (DML) statements are used for managing data within schema objects. Some examples:

    SELECT - retrieve data from the a database
    INSERT - insert data into a table
    UPDATE - updates existing data within a table
    DELETE - deletes all records from a table, the space for the records remain
    MERGE - UPSERT operation (insert or update)
    CALL - call a PL/SQL or Java subprogram
    EXPLAIN PLAN - explain access path to data
    LOCK TABLE - control concurrency


DCL
Data Control Language (DCL) statements. Some examples:

    GRANT - gives user's access privileges to database
    REVOKE - withdraw access privileges given with the GRANT command

TCL
Transaction Control (TCL) statements are used to manage the changes made by DML statements. It allows statements to be grouped together into logical transactions.

    COMMIT - save work done
    SAVEPOINT - identify a point in a transaction to which you can later roll back
    ROLLBACK - restore database to original since the last COMMIT
    SET TRANSACTION - Change transaction options like isolation level and what rollback segment to use

http://www.orafaq.com/faq/what_are_the_difference_between_ddl_dml_and_dcl_commands

Oracle Communications ASAP

Converged Activation of Network and IT Services
Utilize a configurable, extensible converged activation system to rapidly activate consumer and business services in an automated manner on network and IT applications across multiple fixed and mobile domains.

http://www.oracle.com/us/products/applications/communications/service-fulfillment/asap/overview/index.html

Oracle Access Management

Delivers risk-aware end-to-end user authentication, single sign-on, and authorization protection, enabling enterprises to secure access from mobile devices and seamlessly integrate social identities with applications.
http://www.oracle.com/us/products/middleware/identity-management/access-management/overview/index.html

Oracle Identity Management

Oracle Identity Management enables organizations to effectively manage the end-to-end lifecycle of user identities across all enterprise resources, both within and beyond the firewall and into the cloud. The Oracle Identity Management platform delivers scalable solutions for identity governance, access management and directory services
http://www.oracle.com/technetwork/middleware/id-mgmt/overview/index.html

oracle 11g new features

Pivot queries involve transposing rows into columns (pivot) or columns into rows (unpivot) to generate results in crosstab format

http://www.oracle-developer.net/display.php?id=506

Oracle WebCenter Content

Oracle WebCenter Content provides organizations with a unified repository to house unstructured content, and deliver it to business users in the proper format, and within context of familiar applications to fit the way they work.
http://www.oracle.com/us/products/middleware/webcenter/content/overview/index.html

Oracle Fusion Middleware

Oracle Fusion Middleware 11g's hot-pluggable architecture allows you to make the most of your current investments in applications and technology, while also taking advantage of modern hardware and software architectures. The goal of this release is to maximize your efficiency in both IT and business processes to give you the agility to adapt and innovate

http://www.oracle.com/technetwork/middleware/fusion-middleware/overview/index.html?origref=http://www.google.com/search?q=Oracle+Fusion&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a

Oracle GoldenGate

Oracle GoldenGate is a comprehensive software package for enabling the replication of data in heterogeneous data environments.
The product set enables high availability solutions, real-time data integration, transactional change data capture, data replication, transformations, and verification between operational and analytical enterprise systems

http://www.oracle.com/technetwork/middleware/goldengate/overview/index.html

SharePlex for Oracle

If you’ve tested Oracle GoldenGate and found it too complex and expensive, tried Streams only to discover it’s slow and nearing its EOL, or need more availability than Data Guard can provide, it’s time to check out a better solution.

SharePlex® for Oracle is a mature, high-performance, high-availability technology that offers a low-cost alternative to other Oracle replication tools.

This Oracle replication solution ensures business continuity while meeting your database operational goals.
It provides a real-time copy of production data – without impacting your OLTP system’s performance and availability.