Oracle Database Memory Management Memory management – focus is to maintain optimal sizes for memory structures. Memory is managed based on memory-related initialization parameters. These values are stored in the init.ora file for each database. Three basic options for memory management are as follows: Automatic memory management: DBA specifies the target size for instance memory. The…
SQL Statements are processed differently depending on whether the statement is a query, data manipulation language (DML) to update, insert, or delete a row, or data definition language (DDL) to write information to the data dictionary. Processing a query: Parse: Search for identical statement in the Shared SQL Area. Check syntax, object names,…
Oracle server: An Oracle server includes an Oracle Instance and an Oracle database. An Oracle database includes several different types of files: datafiles, control files, redo log files and archive redo log files. The Oracle server also accesses parameter files and password files. This set of files has several purposes. One is to enable system users to…
Oracle Virtual Private Database (VPD) enables you to create security policies to control database access at the row and column level. Essentially, Oracle Virtual Private Database adds a dynamic WHERE clause to a SQL statement that is issued against the table, view, or synonym to which an Oracle Virtual Private Database security policy was…
A) Start Oracle Apps Process 1. Login to the Linux server system with the login credentials specified whilst installation of Oracle Apps server. e.g. In this case, user logged in with “Oracle” user. 2. Check the network connectivity. 3. Check the filesystem for space available and required in future. 4. Refer to the last session stop log file…
Oracle 9i Oracle10g Oracle11g RAC Introduced – Providing High avaliability RAC Improvements – improved clusterware – Introduction of VIP’s for RAC Further RAC Improvements – Faster failover of services – Grid Plug&Play allowing seamless additions/removal of nodes DataGuard enhancements – Detection of gasps and automatic resolution DataGuard improvements – Realtime apply and log compressions – Fast start…