Skip to content

DBA Text Search

Directory actions

More options

Directory actions

More options

Latest commit

 

History

History

DBA Text Search

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
DBA Text Search.sql
DBA Text Search.sql
 
 
DESCRIPTION.md
DESCRIPTION.md
 
 
README.md
README.md
 
 

README.md

layout default
title DBA Text Search | Oracle EBS SQL Report
description Full text search through database source code objects such as packages, procedures, functions, triggers etc. The search can also be done using regular…
keywords Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, DBA, Text, Search, dba_source
permalink /DBA%20Text%20Search/

DBA Text Search – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Full text search through database source code objects such as packages, procedures, functions, triggers etc. The search can also be done using regular expressions. To retrieve incorrect custom code such as a frequent performance issue calling the fnd_concurrent.wait_for_request\s function with a zero interval time, for example, use parameter 'Multi Line Regex search' with the following value: fnd_concurrent.wait_for_request\s*(\srequest_id\s=>\s*\w+\s*,\sinterval\s=>\s0\s,

Report Parameters

Code Text contains, Multi Line Regex search, Cote Text Regexp search, Multi Line window size, Object Name starts with, FND Message Text, Object Type, Schema, Line Number From, Line Number To

Oracle EBS Tables Used

dba_source

Report Categories

Enginatics

Related Reports

XLA Distribution Links Summary, DBA Object Access Privileges, DBA Profiler Data, DBA Hierarchical Profiler Data, DBA SGA+PGA Memory Configuration, DBA AWR Active Session History, DBA Tablespace Usage, DBA AWR Blocking Session Summary

Running This SQL Without Blitz Report

Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.

Download & Import Options

Resource Link
Excel Example Output DBA Text Search 11-May-2017 125907.xlsx
Blitz Report™ XML Import DBA_Text_Search.xml
Full SQL on Enginatics www.enginatics.com/reports/dba-text-search/

Case Study & Technical Analysis

Abstract

The DBA Text Search report is a powerful code analysis tool that performs full-text searches across the database's stored procedures, functions, packages, and triggers. Unlike simple string matching, this report supports Regular Expressions (Regex), enabling sophisticated pattern matching to find complex coding structures, deprecated API calls, or hard-coded values.

Technical Analysis

Core Features

  • Regex Support: Allows for patterns like fnd_concurrent\.wait_for_request\s*\(.*interval\s*=>\s*0 to find specific dangerous function calls regardless of whitespace formatting.
  • Context: Can return lines of code surrounding the match (window size), providing immediate context for the developer.
  • Scope: Searches DBA_SOURCE, covering all PL/SQL code in the database.

Key View

  • DBA_SOURCE: The text of the stored objects.

Operational Use Cases

  • Impact Analysis: Finding all custom code that calls a specific Oracle API before applying a patch that changes that API.
  • Code Quality: Scanning for forbidden patterns (e.g., GRANT DBA, hardcoded passwords, or SELECT *).
  • Refactoring: Locating all usages of a table or column within PL/SQL logic.

Useful Links

© 2026 Enginatics