//
archives

oracle

This tag is associated with 13 posts

Combined Access and Filter Predicates

http://oracle-randolf.blogspot.sg/2015/04/combined-access-and-filter-predicates.html

Advertisements

Dynamic sampling and its impact on the Optimizer (Oracle Optimizer)

via Dynamic sampling and its impact on the Optimizer (Oracle Optimizer)

READ ONLY Tablespace Restore and Recovery « Oracle DBA – Tips and Techniques

Source: READ ONLY Tablespace Restore and Recovery « Oracle DBA – Tips and Techniques

dbms_stats Oracle SQL performance

dbms_stats Oracle SQL performance

Source: dbms_stats Oracle SQL performance

How to Deploy Oracle RAC on Oracle Solaris 11 Zone Clusters

Source: How to Deploy Oracle RAC on Oracle Solaris 11 Zone Clusters

Plan Stability using Sql Profiles and SQL Plan Management | AskDba.org Weblog

ng Index X when you wanted it to use index Y or query performing Nested Loop join when Hash Join would have completed the query much faster.

Source: Plan Stability using Sql Profiles and SQL Plan Management | AskDba.org Weblog

Oracle Database 12c 2-Day DBA Series

https://apexapps.oracle.com/pls/apex/f?p=44785:24:0::NO:24:P24_CONTENT_ID,P24_PREV_PAGE:6282,29

Monkey on Oracle: Installfest: Oracle 11g XE on Amazon Linux Micro Instance

Monkey on Oracle: Installfest: Oracle 11g XE on Amazon Linux Micro Instance.

Auto DOP: Differences of parallel_degree_policy=auto/limited | The Oracle Instructor

SQL> grant dba to adam identified by adam;

via Auto DOP: Differences of parallel_degree_policy=auto/limited | The Oracle Instructor.

Oracle Linux: Oracle ASMLib | Oracle Technology Network | Oracle

ASMLib is an optional support library for the Automatic Storage Management feature of the Oracle Database. Automatic Storage Management (ASM) simplifies database administration and greatly reduces kernel resource usage (e.g. the number of open file descriptors). It eliminates the need for the DBA to directly manage potentially thousands of Oracle database files, requiring only the management of groups of disks allocated to the Oracle Database. ASMLib allows an Oracle Database using ASM more efficient and capable access to the disk groups it is using.

via Oracle Linux: Oracle ASMLib | Oracle Technology Network | Oracle.

Further reading :
http://www.oracle-base.com/articles/10g/asm-using-asmlib-and-raw-devices.php
http://orainternals.wordpress.com/2012/08/29/do-you-need-asmlib/