Question : I’m trying to understand the definition of data catalog and data schema. After several articles I read, I’m […]
Tag: data-dictionary
InnoDB Data Dictionary Cleanup for a Non-Existent Database Named “tmp”?
Question : I have a number of error messages like this in my error.log file referencing different files that can’t […]
what oracle data dictionary view can be used to decribe types defined in a plsql package?
Question : What oracle data dictionary view can be used to describe types / subtypes defined in a plsql package? […]
Does increased Data Dictionary size affects performance
Question : As I understand, Data Dictionary Is a collection of tables, part of SYS schema (if not the whole […]
How to identify the ranges over which a postgres table was partitioned?
Question : If I create a table and partitions like this… CREATE TABLE tab1 (a int, b int) PARTITION BY […]
information_schema.columns slow performance
Question : we have system that quite a lot and often asks database about: SELECT TABLE_NAME, TABLE_SCHEMA, COLUMN_NAME, ORDINAL_POSITION, COLUMN_DEFAULT, […]
Does increased Data Dictionary size affects performance
Question : As I understand, Data Dictionary Is a collection of tables, part of SYS schema (if not the whole […]
Data Lake : Data Catalog and Data Schema definitions
Question : I’m trying to understand the definition of data catalog and data schema. After several articles I read, I’m […]
Data Lake : Data Catalog and Data Schema definitions
Question : I’m trying to understand the definition of data catalog and data schema. After several articles I read, I’m […]