http://netvouz.com/MondoTofu/tag/database?feed=rss&pg=1 MondoTofu's bookmarks tagged "database" on Netvouz http://www.oracle.com/pls/db112/homepage PDF - Latest Oracle > DB 11g MondoTofu Fri, 05 Apr 2013 01:03:21 GMT http://www.oracle-base.com/articles/11g/resource-manager-enhancements-11gr1.php Resource Manager Enhancements in Oracle Database 11g Release 1 Oracle MondoTofu Thu, 17 Apr 2014 18:13:11 GMT https://oracle-base.com/articles/11g/automatic-diagnostics-repository-11gr1 Automatic Diagnostic Repository (ADR) in Oracle Database 11g Release 1 (ADRCI) Oracle > Oracle Tips MondoTofu Mon, 09 Apr 2018 14:31:19 GMT http://oracle-base.com/articles/11g/temporary-tablespace-enhancements-11gr1.php Temporary Tablespace Enhancements in Oracle Database 11g Release 1 Oracle > DB 11g MondoTofu Thu, 07 May 2015 17:42:01 GMT http://www.oracle.com/technetwork/articles/index-087388.html Oracle > Security MondoTofu Sun, 12 Dec 2010 17:32:08 GMT https://access.redhat.com/site/documentation/en-US/Red_Hat_Enterprise_Linux/5/html-single/Tuning_and_Optimizing_Red_Hat_Enterprise_Linux_for_Oracle_9i_and_10g_Databases/#sect-Oracle_9i_and_10g_Tuning_Guide-Memory_Usage_and_Page_Cache-Tuning_the_Page_Cache In Red Hat Enterprise Linux 4 and 5, it is strongly recommended to use the “setall” parameter for ext2, ext3, GFS, NFS and OCFS file systems. Oracle MondoTofu Thu, 17 Apr 2014 18:22:58 GMT http://www.oracle.com/technetwork/database/manageability/sqlpa-094776.html SQL Performance Analyzer (SPA), a key feature of the Real Application Testing option introduced in Oracle Database 11g, can predict and quantify SQL performance improvements and regressions caused by system changes such as upgrading a database, adding new indexes, changing database parameters, collecting optimizer statistics, etc. SQL Performance Analyzer provides a granular view of the impact of changes on SQL execution plans and execution statistics by running the SQL statements on a production or test system in isolation before and after a change. SPA compares the SQL execution result, before and after the change, and generates a report outlining the net benefit on the SQL workload due the change as well as the set of regressed SQL statements. For regres Oracle > DB 11g MondoTofu Thu, 28 Aug 2014 13:36:49 GMT http://www.oracle.com/technetwork/database/manageability/sqlmonitor-084401.html Oracle Database 11g: Real-Time SQL Monitoring Real-Time SQL Monitoring, introduced in Oracle Database 11g, provides a very effective way to identify run-time performance problems with resource intensive long-running and parallel SQL statements. Interactive Enterprise Manager screens display details of SQL execution using new, fine-grained SQL statistic that are tracked out-of-the-box with no performance penalty to production systems. Statistics at each step of the execution plan are tracked by key performance metrics, including elapsed time, CPU time, number of reads and writes, I/O wait time and various other wait times. This allows DBAs to analyze SQL execution more deeply than pre Oracle > DB 11g MondoTofu Thu, 28 Aug 2014 13:26:40 GMT https://aws.amazon.com/blogs/database/testing-amazon-rds-for-oracle-plotting-latency-and-iops-for-oltp-io-pattern/ Plotting Latency and IOPS for OLTP I/O Pattern | AWS Database Blog Kevin Clossen SLOB AWS MondoTofu Thu, 19 Apr 2018 20:07:40 GMT http://docs.oracle.com/cd/E11882_01/olap.112/e23381/row_functions102.htm shows how offset can vary depending upon daylight savings time Oracle > DB 11g MondoTofu Thu, 07 Mar 2013 19:53:47 GMT