Monthly Archives: luglio 2013

  • 31
    Lug

How to solve ORA-00257 archiver error

In order to solve the above error the solutions are (considering database 10g and above.) 1.) Increase the free space where archiver archives the archivelog. The location where archiver archives the log is determined by parameter file pfile or spfile. This can be determined by loging into sqlplus and issuing SQL> show parameter log_archive_dest If archive destination is...

Read More
Windows Server 2008 R2 – Tool da riga di comando
  • 29
    Lug

Windows Server 2008 R2 – Tool da riga di comando

Microsoft fornisce dei tool per effettuare operazioni da riga di comando. I più famosi sono Robocopy.exe (per la copia e la sincronizzazione di file e cartelle), Calcs.exe (gestione permessi di file e cartelle), Dnscrmd.exe (aggiunta/rimozione record DNS), ecc... Diversamente dalle versioni precedenti, se si ha necessità di usare questi strumenti non è necessario copiare i file .exe nella...

Read More
  • 25
    Lug

Partitioning Table MS-SQL Server 2008.

Starting of 2005 version, was introduced the concept of table partitioning (as in Oracle.) At the time of choosing the type of partitioning, you have to be careful about the choice: LEFT or RIGHT. From my experience I would recommend to use the partitioning Left, or with values ​​less than the value of partitioning. This must be done...

Read More
Amministrazione di Oracle Real Application Clusters
  • 22
    Lug

Amministrazione di Oracle Real Application Clusters

Le utility Server Control (SRVCTL) consentono di avviare e stoppare database e istanze, gestire informazioni di configurazione, muovere o rimuovere istanze e servizi. Consentono di riallocare un servizio da una istanza denominata ad un altra; il servizio riallocato è temporaneo fino a che non viene modificata la configurazione. Un esempio: Problema: Abbiano bisogno di ridistribuire servizi esistenti. Soluzione:...

Read More
  • 18
    Lug

Create Oracle Database 12c

Normal 0 14 false false false IT X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Tabella normale"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Tabella normale"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0cm...

Read More
  • 15
    Lug

Install Oracle 12c

The description for the installation of Oracle Database software on 12c Oracle Enterprise Linux 6 in the attached document: Install_Oracle12c  

Read More
  • 10
    Lug

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

Read More
  • 8
    Lug

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 made available to...

Read More
  • 4
    Lug

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

Read More
  • 1
    Lug

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 find the cause...

Read More