DBA

Free space can be managed automatically inside oracle database segments. You specify automatic segment-space management when you create a locally managed tablespace. The specification then applies to all segments subsequently created in this tablespace. The in-segment free/used space is tracked using bitmaps, as opposed to free lists. Automatic segment-space management ...

An extent is a logical structure of oracle database that comprises of the contigous data blocks. These logical storage units are stored in segments. Oracle allocates a new extent in a segment, when the space in the segment is saturated. When Extents Are Allocated : On creating a table, initial extents ...

Every Oracle process at given given moment is involved in either a request or waiting for event to occur.And when we have a Term "busy" means that the process needs CPU. Take the case of a dedicated server process might be performing some arithmetic operation while executing a PL/SQL block. This ...

Oracle database is comprised of a set of operating system files containing data entered by users or applications and structural information about the database itself called database metadata. Information is stored persistently in these files.Oracle needs to start a set of processes, called background processes, and needs to allocate some ...

Resolving A Slow Client/Server Application By Increasing the array processing size   If A client server application takes several seconds to bring up a certain screen indicates that some thing is slow and the reasons should be explored. Developers gets frustrated because the delay was occurring before the user had any ...

An Oracle database is made up of control files, data files, online redo logs, and archived redo logs which can be collectively called as physical files that make up the logical Oracle database. CONTROL FILES : A control file in oracle database is a physical file (binary) which stores the information ...

Data Blocks are small units of storage space that in the physical datafile of the Oracle database. Oracle manages these storage units in datafiles. When a query is execute to fetch records from the table, then, it can scan many blocks and records returned by the query can be strored ...

Oracle Database is divided into Logical and Physical structure. This article, mainly covers some of the Logical structure or the Logical database that comprises in oracle. These are  Blocks, Extents and segments. Each of these logical structure are related with each other or in a simpler language each of these ...