Oracle Architecture

Oracle architecture questions

<<Previous  Next>>

Describe Oracle architecture in brief. The Oracle database has: - Logical layer: The components of the logical layer map the data to these physical components........... Read answer What is the function of SMON?   The SMON background process performs all system monitoring functions on the oracle database............... Read answer Explain different types of segment. Data segment, Index segment, Rollback segment and temporary segment.  There are four types of segments used in Oracle databases: - data segments - index segments - rollback segments - temporary segments..................  Read answer Explain SGA memory structures: Shared Pool, Database buffer Cache, Redo log Cache, Large Pool Java Pool. SGA (System Global Area) is a dynamic memory area of an Oracle Server. In SGA,the allocation is done in granuels. The size of the SGA is dependent on SGA_MAX_SIZE parameter.................... Read answer What is SQL Loader? Explain the files used by SQL Loader to load file. i.e Loader control file, Input datafile, Log File, Bad File, Discard file. SQL*Loader is a bulk loader utility used for moving data from external files into the Oracle database. SQL*Loader supports various load formats, selective loading, and multi-table loads...................... Read answer Explain the methods provided by SQL Loader. Conventional Path Load, Direct Path Load...................... Read answer What is the physical and logical structure of oracle? Logical Database structures : Logical structures include tablespaces, schema objects, data blocks, extents and segments......................     Read answer <<Previous  Next>> Also read Business Process Execution Language (BPEL) What is Business Process Execution Language (BPEL)? BPEL vs. workflow foundation Role of BPEL Explain about BPEL Orchestration and Choreography................ Oracle Backup and Recovery What is configure command and recovery catalog?, What are different types of backup? (Hot, Cold, logical, Physical)?, Whats the Concept of Flashback Query in Oracle (10g in particular) and how is it beneficial?............... Oracle DBA How do you increase the performance of %LIKE operator?, What is a standby database? Difference between Physical and logical standby databases, What is Cache Fusion Technology?, What is simple replication and advance replication?............. How are extents allocated to a segment? An extent is stored some specific information. This information is stored using specific number of adjoining data blocks. A collection of extent is called as a segment stored in the same tablespace............. Oracle optimizer Explain how oracle optimizer works, Describe optimization methods, i.e. cost-based approach and role-based optimization........ What are layers in Oracle Architecture? The Oracle database has a logical layer and a physical layer. The physical layer consists of the files that reside on the disk and logical layer map the data to these files of physical.......... What are the kinds of roles in oracle? Connect: This role allows access to the table belonging to other users. It allows using Select, Insert, Update and Delete command......... What are the privilege types? The privileges can be of system or object level. SYSTEM level privileges can be assigned by the DBA and the object level privileges are assigned by the owner of the particular object...............