Monthly Archives: maggio 2013

IOT Table
  • 29
    Mag

IOT Table

An IOT keeps its data stored according to the primary key column values for the table.IOTs store the data as if the entire table was stored in an index.  Anormal index only stores the indexed columns in the index; an IOT stores all of the table's columns in the index As the table's data is stored as an...

Read More
Overview of an interesting bug
  • 28
    Mag

Overview of an interesting bug

 Often you may need to load data to the database under a different schema and different tablespace. With Oracle Data Pump all this is possible in a very simple way. Among the various options of the routine impdp you can find:   REMAP_SCHEMA REMAP_TABLESPACE   REMAP_SCHEMA allows us to load the exported objects under a different scheme; REMAP_TABLESPACE...

Read More
Jobs Automatic For The calculation of statistics
  • 28
    Mag

Jobs Automatic For The calculation of statistics

First you have checked the size of each diagram so that you can understand how they guide the work of collecting statistics in order to make improvements on the performance of database Owner                               Objects      size MB ------------------------------ ------------ ------------ USER_BIG                              386       74,516 PR2K                                    211        8,424 SAST                                     31          152 ASINT                                    28           85 APEX_030200                           2,561           78 MDSYS                                 1,973           66...

Read More
A KPMG survey on adoption projects.
  • 21
    Mag

A KPMG survey on adoption projects.

What is the real level of adoption of Cloud in the public sector? What are the challenges to adopt it? To these questions he sought to answer the study "Exploring the Cloud" by KPMG, dedicated to the government sector, developed on the basis of a survey involving 430 public managers in 10 countries. The study shows how the...

Read More