background preloader


Facebook Twitter


MEMORY_TARGET (SGA_TARGET) or HugePages – which to choose? – Ronny Egners Blog. Oracle 10g introduced the SGA_TARGET and SGA_MAX_SIZE parameter which dynamically resized many SGA components on demand.

MEMORY_TARGET (SGA_TARGET) or HugePages – which to choose? – Ronny Egners Blog

With 11g Oracle developed this feature further to include the PGA as well – the feature is now called “Automatic Memory Management” (AMM) which is enabled by setting the parameter MEMORY_TARGET. Automatic Memory Management makes use of the SHMFS – a pseudo file system just like /proc. Every file created in the SHMFS is created in memory. Unfortunately using MEMORY_TARGET or MEMORY_MAX_SIZE together with Huge Pages is not supported. You have to choose either Automatic Memory Management or HugePages. Automatic Memory Management (AMM) AMM – what it is. Oracle Restart – Changing Hostname – Sysadmin and DBA tips. Welcome to another Sysadmin & DBA Tips, in this post I’ll explain how change the hostname of your cloned Oracle 11.2 VMs thats running on ASM with Oracle Restart.

Oracle Restart – Changing Hostname – Sysadmin and DBA tips

Pre-Tasks Before start with the Oracle Restart process you must stop the listener: [root@DB ~]# crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora.DATA.dg ora....up.type ONLINE ONLINE DB ora.FRA.dg ora....up.type ONLINE ONLINE DB ora....ER.lsnr ONLINE ONLINE DB ora.asm ora.asm.type ONLINE ONLINE DB ora....stro.db OFFLINE OFFLINE ora.cssd ora.cssd.type ONLINE ONLINE DB ora.db11g.db ONLINE OFFLINE ora.diskmon ora....on.type ONLINE ONLINE DB. ORACLE-BASE - Tracking Database Feature Usage (DBA_FEATURE_USAGE_STATISTICS) Avoid Licensing Traps. It’s easy to run into licensing issues with the Oracle database.

Avoid Licensing Traps

A “wrong” SQL command – and you’ve used an additional option of the database and you can get in trouble at the next licensing audit. This blog post lists some basic steps that can help to avoid such problems. Disclaimer: the aspects listed here are by no means exhaustive and complete and cannot replace license consulting. The most important information on Oracle database licensing is available in the following documents: The following procedure may help in avoiding licensing issues: ORACLE-BASE - Automatic Diagnostic Repository (ADR) in Oracle Database 11g Release 1 (ADRCI)

Auto Start/Shutdown Oracle Database 11g R2 on Linux. Installing Oracle Database 11g R2 on a Linux Server (you can check my previous post) does not provide the database the possibility to preform an automatic startup/shutdown when the system is starts or shutdown, we need to do it manually!

Auto Start/Shutdown Oracle Database 11g R2 on Linux

So here is a few steps to make it happen automatically. The automatic startup and shutdown of the Oracle database can be achieved with the files dbstart and dbshut both provided by Oracle. These files rely on the existence of the file /etc/oratab to work. The format of the /etc/oratab file is as follows: or in my example: ORCL:/u01/app/oracle/product/11.2.0/dbhome_1:Y To start and stop the database when the machine comes up and goes down by modifying the startup routines for the Linux machine. Note: /etc/init.d is the official location for placing start up scripts and most, but not all distros follow this convention. Firstly, we need to create the script which will run dbshut and dbstart in the /etc/rc.d/init.d directory. . #! Stopping and Starting Oracle Software.

This chapter describes how to identify Oracle Database processes, and provides basic information about how to stop and restart them.

Stopping and Starting Oracle Software

It also describes how to set up automatic startup and shutdown of the Oracle Database. It contains the following sections: Note: When using Oracle Restart, you can use Service Control Utility (SRVCTL), a command-line interface, to manage Oracle processes (database instance, listener, Oracle ASM instance). C Creating Operating System Groups and Users Requirements. The appendix explains what operating system groups and users you need to create and how to create them.

C Creating Operating System Groups and Users Requirements

In particular, this appendix covers the following: What Operating System Groups and Users Are Required? The following operating system group and user are required for all installation types: Options and Packs. This chapter describes the separately licensed Oracle Database options, management packs, and other products you can purchase to enhance the capabilities of Oracle Database in specific application environments.

Options and Packs

This chapter contains the following sections: You may not use the options, packs, or products described below without separately purchased licenses. The fact that these options, packs, or products may be included in product CDs or downloads or described in documentation that you receive does not authorize you to use them without purchasing appropriate licenses. Why Not Consider Oracle Standard Edition? The dramatic price differential between Oracle Standard Edition and Oracle Enterprise Edition creates a compelling case for considering Standard Edition as an alternative to Enterprise Edition.

Why Not Consider Oracle Standard Edition?

With the addition of third-party technology, Oracle Standard Edition can deliver enterprise-class performance at a substantially reduced cost. How does Oracle Standard Edition compare to Enterprise Edition? Oracle promotes Standard Edition as a full-featured Database Management Solution (DBMS). Although Standard Edition contains the same database engine as Oracle’s Enterprise Edition, it omits many of the higher-level features and options, including: Encryption (TDE, backup encryption, network encryption)Fine grained auditingReplicationCompressionUnlimited CPU cores / DBMS deployment ( Standard Edition is limited to four sockets maximum)Performance (Diagnostic Pack and Tuning Pack)