What this warning means `Required tables DBMSHP_FUNCTION_INFO,DBMSHP_PARENT_CHILD_INFO,DBMSHP_RUNS missing`
Recently we upgraded from oracle 12c to 19c. Now I'm testing if everything works fine, but I came acrross to some functions that have under the profiles in the SQL DEVELOPER this warning
Required tables DBMSHP_FUNCTION_INFO,DBMSHP_PARENT_CHILD_INFO,DBMSHP_RUNS missing
When I at looked at the other instance that currently is using oracle 12c - I see the same warning.
I havent worked on this data for that long and I'm not sure what is for what yet. I was wondering if there are some explanations regarding this warning.
Any help? I'm just trying to understand.
Thanks
It means the tables required to use the PL/SQL Hierarchical Profiler are missing.
I talk about this feature in SQL Developer here
If you're not using the feature, it's not a problem. If you want to use the feature, then SQL Developer will help you create the objects via the GUI when you go to use the Profiler on a PL/SQL code editor.
- How to restrict RLS on certain column(s) in PostgreSQL/Supabase?
- How to use stored procedure parameters as dynamic content in copy activity using ADF
- NLOG Database Target can't connect
- SQL Database in restoring mode
- Add PRIMARY KEY constraint to existing table
- How to debug a database query for performance
- LocalDB is not supported on this Platform
- Store images in a MongoDB database
- How to pass stored procedure parameters as dynamic content in copy activity using ADF
- Normalization of vehicle data
- sqlite's fetchall returns None instead of an empty list
- How do I join 2 SQL tables in python based on their (non-unique) ID and closest values in years?
- connect superset to postgresql in a docker container - The port is closed
- Is there a way to get a list of column names in sqlite?
- What happens when you insert rows in a SERIAL column with existing values?
- Relational Algebra Intersection Properties
- MySQL insert country iso or country id from another table
- Error: supabaseUrl is required (supabase) postgresql
- How do I alter the position of a column in a PostgreSQL database table?
- Utilizing Sqlite `no such table` error in Go?
- What this warning means `Required tables DBMSHP_FUNCTION_INFO,DBMSHP_PARENT_CHILD_INFO,DBMSHP_RUNS missing`
- Superset: command not found
- How do you interpret a query's explain plan?
- What is the difference between the different BerkeleyDB versions, and which should I choose?
- How to select bottom most rows?
- How to open file maker .fp3 files without file maker installed?
- Export and Import all MySQL databases at once
- Postgres - How to check if date doesn't exist in result table and if so set data to zero
- General error : 'mysqldump' is not recognized as an internal or external command
- Node.js Sequelize: Cannot delete property 'meta' of [object Array]