Create Oracle Database 12c
Below are described installation step of Oracle Database Database 12c on Oracle Enterprise Linux 6. New Pluggable Database Features is chosen below. Install_Oracle_database12c
Install Oracle 12c
The description for the installation of Oracle Database software on 12c Oracle Enterprise Linux 6 in the attached document: Install_Oracle12c
Access problem NOT IN query using db link on db 9i:select id_bda
from anag_li where id_bda not in (select idanag from prova@bdlink); Access plan: ———————————————————————————— | Id | Operation | Name | Rows | Bytes | Cost | Inst |IN-OUT| ———————————————————————————— | 0 | SELECT STATEMENT | | 37490 | 585K| 978K| | | |* 1 | FILTER | | | | | | | | 2…
Leggi tutto
A new feature in Oracle 11g: ACTIVE DUPLICATE
Very often we need to make copies of the production database in test environments to be able to perform functional tests which can then be issued on production. To make a copy of the database there are several methods. Some of these are: • Export / import mode (which uses the utility expdp / impdp…
Leggi tutto
Oracle Database 12c
Was presented the new Oracle Database 12 c. It took 5 years of development, 500 new features and 3000 systems used in doing the test, 1 million daily test and 1.2 million hours of stress test. The new Oracle Database 12c is designed for the new paradigm of cloud compuntig. http://www.oracle.com/us/corporate/features/database-12c/index.html
Oracle Views in Oracle Forms: optimize data retrieval from a view avoiding the upstream filter in Oracle Forms
Oracle Views are useful tools for query multiple tables or get aggregate result; Oracle Forms can use views and display view data like a normal data table. In high cardinality data tables this artifact produce a lack in query time result, if we needs to add “ default_where “ condition to our block. We can…
Leggi tutto
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…
Leggi tutto
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…
Leggi tutto
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,…
Leggi tutto
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…
Leggi tutto
Commenti recenti