Home » Oracle » Oracle Database » Page 16

Oracle Database

An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. A database server is the key to solving the problems of information management.Many companies has implemented their data in Oracle. Most of them are mission critical. So Oracle database concept need to be very clear to manage these mission critical things. At the same time Oracle database needs to deliver high performance also. A database server also prevents unauthorized access and provides efficient solutions for failure recovery.

Below section I have tried to present all the important features in Oracle Database management

How to find segment name from file id and block number in Oracle

In Oracle, if you have a file ID (file number) and block number, and you want to find the corresponding segment name (such as a table or index name), you can use the DBA_EXTENTS data dictionary view. This view maps extents (which consist of continuous blocks) to segments. The below query can be used for …

How to find segment name from file id and block number in Oracle Read More »

Oracle tkprof utility

We saw how to enable trace in an earlier post. The trace files obtained from the method is in raw  form which can be converted into a more readable format using the tkprof utility  in Oracle (Transient Kernel PROFile  utility) tkprof utility in Oracle TKPROF is a tool for producing formatted reports from SQL Trace …

Oracle tkprof utility Read More »

What is Skew in Database?

What is Data Skew Data skew primarily refers to a non-uniform distribution in a data set. A non-uniform distribution might impact the system if the proper execution plan is not selected depending on the data values. Data is generally said to be skewed if there is presence of significant popular values in the column. But it …

What is Skew in Database? Read More »

Scroll to Top