Reading the previous article posted on June 3 about enabling auditing in an Oracle Database, I’d like to add some other useful information. Oracle stores all the audit results in the SYS.AUD$ table, as stated in the previous article. But the bad news are that the table is by default in the SYSTEM tablespace: SELECT…
Leggi tutto
We happened recently to solve a problem of this type: we had a structure in which, for each category (shown in a table A) had a number of items of detail (in a table B) numeric values (the latter given in a table C that implemented them a one to many relationship between A and…
Leggi tutto
The Oracle RDBMS provides various control functions of the system security. Among these, there is also a function of AUDIT TRAIL that lets you record any activity carried out on the database of interest. The control possibilities are very sophisticated and flexible, but it is necessary to avoid excessive control to avoid needlessly heavy and…
Leggi tutto
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…
Leggi tutto
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…
Leggi tutto
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…
Leggi tutto
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…
Leggi tutto
The Cloud not only allows you to reduce IT costs, but free resources and time that can reasonably be reinvested. This emerges from a study commissioned by Rackspace to research company Vanson Bourne, which involved 1,300 companies located in England and the United States, of which about 300 over a thousand employees, and 1,000 small…
Leggi tutto
Incremental statistics maintenance was introduced in Oracle Database 11g to improve the performance of gathering statistics on large partitioned table. When incremental statistics maintenance is enabled for a partitioned table, oracle accurately generated global level statistics by aggregating partition level statistics. Incremental statistics maintenance is supposed to yield the same statistics as gathering…
Leggi tutto
Commenti recenti