Oracle
All UxOra articles related to Oracle database 11g/12c and SQL/PLSQL will be published under this category.
- Details
- Written by Michel VONGVILAY
- Category: DBA
This article will show to use UDEV instead of ASMLib on Oracle Linux 7.
If for any reason you cannot or don't want to use ASMLib, then you can use UDEV instead. This is an alternative in order to present disks to ASM and this does not required to install an extra layer.
- Details
- Written by Michel VONGVILAY
- Category: DBA
This article will show to install ASM support with ASMLib for Oracle Linux 7 in command line only.
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.
The Oracle ASMLib kernel driver is now included in the Unbreakable Enterprise Kernel. No driver package needs to be installed when using this kernel.
- Details
- Written by Michel VONGVILAY
- Category: DBA
This article will show how to install Oracle 11gR2 RDBMS software in silent mode ( Command line only, no GUI).
It is usual that you have an shell terminal access to a server without graphical X display.
In that case, it may be usefull to install Oracle in silent mode.
- Details
- Written by Michel VONGVILAY
- Category: DBA
This article will list all errors/issues I encounter during Oracle installation with their fix.
It will be updated with all new errors I will encounter.
- Details
- Written by Michel VONGVILAY
- Category: DBA
Table monitoring is by default activated if STATISTICS_LEVEL
system parameter is set to TYPICAL
(or ALL
).
Oracle keeps table monitoring data in memory, then flush it into the dictionary when DBMS_STATS
. FLUSH_DATABASE_MONITORING_INFO
is called. These datas are mainly used to determine if objects need new statistics.