Monthly Archives: giugno 2013

Sequence in RAC
  • 26
    Giu

Sequence in RAC

Problem: I created a sequence of a DB in rac: SQL> CREATE SEQUENCE PROVA_SEQ_OBJ START WITH 2001 INCREMENT BY 1 MAXVALUE 9999999999999999999999999999 MINVALUE 1 NOCYCLE CACHE 20; Values ​​are not disconnected in sequence in the two nodes of the recommendations: instance two:   SQL> SELECT USERENV('INSTANCE') FROM DUAL; USERENV('INSTANCE') ------------------- 2 SQL> SELECT PROVA_SEQ_OBJ .nextval from dual; NEXTVAL...

Read More
Create Database Link
  • 19
    Giu

Create Database Link

Use the CREATE DATABASE LINK statement to create a database link. A database link is a schema object in one database that enables you to access objects on another database. The other database need not be an Oracle Database system. However, to access non-Oracle systems you must use Oracle Heterogeneous Services. After you have created a database link,...

Read More
Retrive sqldata through shell script
  • 17
    Giu

Retrive sqldata through shell script

It could be useful get data from DB by a  bash script Linux. Using a shell Bash is possible to create the following query: dir_in=`sqlplus -s $PMS_CONN_STRING <<EOF SET PAGESIZE 0 FEEDBACK OFF VERIFY OFF HEADING OFF ECHO OFF select directory_path FROM all_directories WHERE directory_name = 'GARBAGE_SFTP_AREA'; exit EOF Analyze this script. The query above, very simple, extracts...

Read More
Create Oracle SQL Profile For Tuning
  • 12
    Giu

Create Oracle SQL Profile For Tuning

Looking for how to tune a SQL statement by creating a SQL Profile? The query optimizer can sometimes produce inaccurate estimates about an attribute of a statement due to lack of information, leading to poor execution plans. Automatic SQL Tuning deals with this problem with its SQL Profiling capability. The Automatic Tuning Optimizer creates a profile of the...

Read More