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
Report Categories
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*0to 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, orSELECT *). - Refactoring: Locating all usages of a table or column within PL/SQL logic.
Useful Links
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© 2026 Enginatics