Groovy DBA

  Hello How to check the patching backup files Check what patches OPatch thinks are installed:   $ORACLE_HOME /OPatch/opatch lsinventory $ORACLE_HOME /OPatch/opatch lsinventory  -detail   Oracle documents  lsinventory  as the standard way to verify applied patches and Oracle home inventory state. Check whether rollback files exist under  .patch_storage :   cd   $ORACLE_HOME ls   -ld  .patch_storage find  .patch_storage  -maxdepth   2   -type  d |  sort du  -sh  .patch_storage   If the patch was applied normally, you should see patch-related content there, because OPatch saves the replaced files in  $ORACLE_HOME/.patch_storage  during installation. Check OPatch logs and history:   ls   -ltr   $ORACLE_HOME /cfgtoollogs/opatch tail  -100   $ORACLE_HOME /cfgtoollogs/opatch/history.txt   Regards Martin Gomez 

  select ACTION,ACTION_TIME,PATCH_ID,PATCH_UID,STATUS,DESCRIPTION from dba_registry_sqlpatch order by 2;   I also check for INVALIDs:-   select COMP_ID, COMP_NAME, VERSION, STATUS from dba_registry; select OWNER, OBJECT_NAME, OBJECT_TYPE, STATUS from dba_objects where STATUS = 'INVALID';  

 Legacy comunication mode - crpto - PGP rhel 5 ,  backward compatibility

 revoke create on schema cpnadmin from cpnadmin; In  PostgreSQL , there is  no specific privilege called  CREATE PARTITION  that you can directly  GRANT  or  REVOKE  on a table. Partition creation is  not a standalone privilege  — it is tied to  table ownership . Only: The  table owner  (or a role that is a member of the owning role) A  superuser can create partitions for a partitioned table. This means: If a role can create partitions, it’s because it  owns the table  (or is a member of the owner role). To  remove  that ability, you must  change the table’s ownership  or remove the role from the owner group — not by  REVOKE .

 [prd1ins1@db2prd601  ~] $ db2 " grant connect on database to user ccpa_db2_prd_user" DB20000I  The SQL command completed successfully. [prd1ins1@db2prd601  ~] $ db2 "grant role db2read to user ccpa_db2_prd_user" DB20000I  The SQL command completed successfully. [prd1ins1@db2prd601  ~] [tst2ins2@db2tst601  ~] $ db2 "grant connect on database to user ccpa_db2_tst_user" DB20000I  The SQL command completed successfully. [tst2ins2@db2tst601  ~] $ db2 " grant role db2read to user ccpa_db2_tst_user" DB20000I  The SQL command completed successfully. [tst2ins2@db2tst601  ~] $ Welcome@12345  ccpa_db2_tst_user /   SfYn##+[+m1  ccpa_db2_prd_user /  aIuyM~?ozp1

  reindex index CONCURRENTLY <indexname> ;

 SELECT current_database(), nspname AS schemaname, tblname, idxname, bs*(relpages)::bigint AS real_size,   bs*(relpages-est_pages)::bigint AS extra_size,   100 * (relpages-est_pages)::float / relpages AS extra_pct,   fillfactor,   CASE WHEN relpages > est_pages_ff     THEN bs*(relpages-est_pages_ff)     ELSE 0   END AS bloat_size,   100 * (relpages-est_pages_ff)::float / relpages AS bloat_pct,   is_na   -- , 100-(pst).avg_leaf_density AS pst_avg_bloat, est_pages, index_tuple_hdr_bm, maxalign, pagehdr, nulldatawidth, nulldatahdrwidth, reltuples, relpages -- (DEBUG INFO) FROM (   SELECT coalesce(1 +          ceil(reltuples/floor((bs-pageopqdata-pagehdr)/(4+nulldatahdrwidth)::float)), 0 -- ItemIdData size + computed avg size of a tuple (nulldatahdrwidth)       ) AS est_pages,       coalesce(1 +  ...