A data dictionary is a reference for the tables, columns, data types, and other metadata in a data system. Supplying it to an AI chatbot gives the chatbot the schema context needed to write more accurate queries, especially when the system is unfamiliar or poorly represented in its training data. section 10.5 section 10.6.2
Use a data dictionary when asking for database queries:
- Provide the table and column definitions, or supply equivalent DDL. section 10.6.2
- Add a basic query or sample output when the desired result is difficult to describe. section 10.6.2
- Review generated SQL carefully; without schema information, a chatbot may invent tables and columns that do not exist. section 10.5
Memory-configuration query
Give the chatbot the inventory schema and request a query that identifies improper Oracle memory configurations. A supplied view can expose server name, database name, memory targets, and physical memory; the generated SQL can then convert values such as 6G and 2000M into comparable megabytes. section 10.6.2
