DBA Text Search – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Database Administration · all Database Administration reports
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*,
Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.
Report Parameters
Code Text contains, Multi Line Regex 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 ORDS Configuration Validation, Blitz Report Custom Reports Converter, DBA Profiler Data, DBA Hierarchical Profiler Data
Running This SQL Without Blitz Report
The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | DBA Text Search 11-May-2017 125907.xlsx |
| Blitz Report™ XML Import | DBA_Text_Search.xml |
| SQL Source | DBA Text Search.sql |
| Full Report 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
© Enginatics GmbH