The ODF Comparison utility(ADODFCMP) compares the data model of a customer’s data to a standard set of data model files from the current Oracle Application release. It can optionally modify the database to match the standard data model. Each application consists of certain building blocks. An object descriptor file (ODF) describes the oracle tables, 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 »
When a user issues a sql query to the Oracle engine, the below illustration is worked out Here is how this works (1) Users issue SQL statements via your client tool SQL*Plus or SQL Developer(2) If the statement has been previously executed and parsed, then Oracle simply executes the stored execution plan.(3) If the statement
How the sql query is executed in Oracle Read More »
Introduction to Sql Tuning Sql statements are written to retrieve /fetch data from the database. We want our sql statement to run fast(sql tuning) and provide the results in secs. A poorly designed sql could slow down the entire database operation and bring the entire operation to halt. It is much harder to write efficient
How to do sql query tuning in Oracle Read More »
10053 trace is the optimizer trace. It externalizes most of the information that the optimizer uses in generating a plan for a query. In this post, we will check out How to enable 10053 trace in Oracle How to enable 10053 trace in Oracle in your own session You can turn on the optimizer trace
How to enable 10053 trace in Oracle Read More »
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 »
