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-20 ]
[ 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
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.
http://www.oracle.com/technetwork/database/manageability/real-application-testing-wp-12c-1896131.pdf
Suscribirse a:
Entradas (Atom)