Paginas

2014-08-20

Recreando el repositorio AWR

A continuación el procedimiento para re-crear el repo de AWR:

1. Disable AWR statistics gathering by setting the statistics level to basic as follows:

Check settings for parameters as follows:
sqlplus /nolog
connect / as sysdba
show parameter cluster_database
show parameter statistics_level
show parameter sga_target

Or save the spfile before modifying:
create pfile='/home/oracle/admin/dbs/init@.ora.20140122' from spfile;
In 10g and 11g , if sga_target is not 0, then in pfile or spfile set the following parameters:
The example below refers to spfile:
alter system set shared_pool_size = 200m scope = spfile;
alter system set db_cache_size = 300m scope = spfile;
alter system set java_pool_size = 100 scope = spfile;
alter system set large_pool_size = 50 scope = spfile;
alter system reset sga_target scope= spfile;
alter system reset memory_target scope= spfile;
alter system reset memory_max_target scope=spfile;
alter system set statistics_level=basic scope=spfile;

2014-08-19

Oracle Label Security with Oracle Database 12c (White Paper)

Oracle White Paper
Oracle Label Security with Oracle Database 12c

Introduction
The need for more sophisticated controls on access to sensitive data is becoming increasingly important as organizations address emerging security requirements around data consolidation, privacy and compliance. Maintaining separate databases for highly sensitive customer data is costly and creates unnecessary administrative overhead. However, consolidating databases sometimes means combining sensitive customer data with confidential customer data.
Oracle Label Security provides the ability to tag data with a data label or a data classification. This capability allows the database to inherently know what data is sensitive and allows the sensitive data to be combined in the same table as the larger data set without compromising security. 

https://www.oracle.com/assets/label-security-wp-12c-1896140.pdf


2014-08-12

Oracle Database 12c: Real Application Testing Overview (White Paper)

Oracle White Paper
Oracle Database 12c: Real Application Testing Overview

Introduction
The Oracle database is the market-leader and the preferred database for hundreds of thousands of enterprises as well as application developers and database administrators worldwide. Over the years, enterprises have come to rely on the Oracle database to provide unparalleled performance and reliability. 
Oracle continues to raise the bar with Oracle Database 12c with extensive support for consolidation. Designed for data center environments that are rapidly evolving and changing to keep up with the demands of the business, Oracle Database 12c allows businesses to adopt new technologies quickly while minimizing risk.