Prev | Current Page 745 | Next

Rick Greenwald, Robert Stackowiak, Jonathan Stern

"Oracle Essentials: Oracle Database 11g"


Tablespace encryption
You can use Transparent Data Encryption to encrypt entire tablespaces.
Auditing on by default
The default setting for database auditing is ON.
Flashback Data Archive
Gives youa way to see all the changes that have happened to a record over the
course of its lifetime, which is very useful for compliance.
Chapter 7: Oracle Performance
This chapter covers enhancements that provide better performance and performance
analysis in the latest release:
Automatic Database Diagnostic Monitor for clusters
ADDM can now be used with clusters.
SQL Advisor
Combines the SQL Tuning Advisor, SQL Access Advisor, and Partition Advisor
(previously described). Also mentioned in Chapter 4.
Automatic Workload Repository baselines
Can create baselines for AWR to cover specific time periods.
Very large file backups
Backups can now include very large files.
Query results caching
Oracle Database 11g can cache entire result sets, which can improve the performance
of repeated queries.
Automatic profiling
The Oracle database can automatically spot and profile queries that require lots of
resources, and this can improve their performance.


Pages:
733 734 735 736 737 738 739 740 741 742 743 744 745 746 747 748 749 750 751 752 753 754 755 756 757
Dyskusja Nr6 poker wentylacja PokerStars studia podyplomowe logistyka