Find practical knowledge without the noise.

Search guides, SQL, error codes, and procedures — or browse by topic below.

388 guides · 8 topics

Explore knowledge

Databases Oracle SQL Bootcamp MySQL Bootcamp PL/SQL Bootcamp Oracle Generic SQL Queries ORACLE EBS Oracle Fusion

Popular this week

See all

EBS_Miss

API_to_Update_FND_LOOKUP

API to Update FND_LOOKUP DECLARE l_lookup_type VARCHAR2 (250); l_lookup_code VARCHAR2 (250);...

47 views

Performance & Tuning

Oracle SQL Performance & TuningOracle provides features and tools to analyze and tune query performance.Execution PlansI...

24 views

security-parameters

Business Unit LOV (Non-Procurement) — Security-Filtered Report Parameter

Lists the Business Units the current BI Publisher user has data access to, based on their user role data assignments &md...

21 views

security-parameters

Data Access Set LOV — Security-Filtered Report Parameter

Lists the Data Access Sets (GL access sets) the current user has access to — used as the LOV source for a "Data Ac...

17 views

Organization Details

Organization Details - Organization Details

SELECT IOP.ORGANIZATION_CODE, IOP.ORGANIZATION_ID, IOP.INVENTORY_FLAG, (SELECT NAME FROM...

15 views

Recently added

See all

security-parameters

Data Access Set LOV — Security-Filtered Report Parameter

Lists the Data Access Sets (GL access sets) the current user has access to — used as the LOV source for a "Data Ac...

Updated Oct 13, 2026

security-parameters

Business Unit LOV (Non-Procurement) — Security-Filtered Report Parameter

Lists the Business Units the current BI Publisher user has data access to, based on their user role data assignments &md...

Updated Oct 10, 2026

security-parameters

Business Unit LOV (Procurement) — Security-Filtered Report Parameter

Lists the Business Units the current user has procurement agent access to, via their PO agent assignment — used as...

Updated Oct 12, 2026

security-parameters

Ledger LOV — Security-Filtered Report Parameter

Lists the Ledgers the current user has direct data access to — used as the LOV source for a "Ledger" report parame...

Updated Oct 06, 2026

security-parameters

Fixed Asset Book LOV — Security-Filtered Report Parameter

Lists the Fixed Asset Books the current user has data access to — used as the LOV source for a Fixed Assets report...

Updated Oct 03, 2026

security-parameters

Intercompany Organization LOV — Security-Filtered Report Parameter

Lists the Intercompany Organizations the current user has data access to — used as the LOV source for an intercomp...

Updated Oct 03, 2026

Performance & Tuning

Guides filed under this topic.

Showing 4 technical documents Folder: Performance & Tuning

Filtering…

Performance & Tuning Highly consulted

Performance & Tuning

Oracle SQL Performance & TuningOracle provides features and tools to analyze and tune query performance.Execution PlansI...

Sai Sree Ram Gundepudi Updated Sep 30, 2026 24 views

Read guide

EXPLAIN PLAN & AUTOTRACE

EXPLAIN PLANDisplays the execution plan of a SQL statement.EXPLAIN PLAN FOR SELECT * FROM employees WHERE department_id...

Sai Sree Ram Gundepudi Updated Sep 07, 2026 2 views

Read guide

Hints and Bind Variables

Hints and Bind VariablesHintsUsed to override default optimizer behavior.SELECT /*+ INDEX(employees emp_idx) */ * FROM e...

Sai Sree Ram Gundepudi Updated Oct 13, 2026 4 views

Read guide

Statistics & Cost Estimation

Statistics & Cost EstimationThe optimizer uses statistics to choose the best query plan.EXEC DBMS_STATS.GATHER_TABLE_STA...

Sai Sree Ram Gundepudi Updated Sep 11, 2026 3 views

Read guide