dbms_stats Oracle SQL performance
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.
SQL> grant dba to adam identified by adam;
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.