SQLT ORA-06598: insufficient INHERIT PRIVILEGES privilege
Hi, faced with this error while generate report to Oracle support: solution is:
Upload csv files to postgresql database
here is my drafts of how-to automate upload a lot of csv files to database ( use text fieds because there is no need to mach all types of columns in this case )
postgresql script to find excess indexes
here how excess indexes can be found, excess mean that there is a single column index which is covered by first value of complex index
oracle how to get disk event waits estimates
base took from ASH Architecture and Advanced Usage — RMOUG
postgresql configure separate directory for config files
first of all we need to create directory for config files outside $PGDATA: in my case this is /u01/postgres/9.5/main/conf/ next we need to modify service and add option with path of postgresql.conf in config file we modify location of other config files:
postgresql query to find duplicate indexes
sample output also usefull to look at usage stat on this indexes