Download Files: 1. Download and Install pg_profile from github -- https://github.com/zubkov-andrei/pg_profile/tree/master # tar xzf pg_profile--4.3.tar.gz --directory $(pg_config --sharedir)…

Step 1. Create Test Table postgres=# create table t1 (c1 int, c2 varchar(200)); postgres=# insert into t1 values (1, 'TTTTTT'); postgres=# insert into t1 values (2, 'SSSSSS');…

Step 1. Start Windows VM and keep on login screen Step 2. Open Terminal and input prlctl list --all to show running VM % prlctl list --all UUID STATUS …

Step 1. Download dependencis and access internet $ pip download pg_activity -d ~/Downloads Collecting pg_activity Downloading pg_activity-3.4.2-py3-none-any.whl.metadata (13 kB) Collecting …

Problem: Netbackup performs rman backup job on RAC and then outputs error message 2023/12/24 上午 11:04:39 - Info bphdb (pid=1857897) INF - RMAN-03009: failure of backup command on ch00 channel…

Find table type in recyclebin select * from dba_recyclebin where owner = 'USERNAME' and type like '%TABLE%' and droptime > '2023-11-06:06:00:00' order by original…

Drop role output error "cannot be dropped because some objects depend on it" postgres=# drop role apqry ; ERROR: role "apqry" cannot be dropped because some objects depen…

Problem: 執行datapump資料庫匯出到NFS空間，發生ORA-錯誤 $ cat expdp_PST_20231004.par userid=system/password directory=stdump dumpfile=expdp_PST_20231004_%U.dmp logfile=expdp_PST_20231004.log parallel=16 co…

記錄一下處理Oracle測試環境Datafile放在NFS上效能緩慢的問題 Problem: 測試環境Datafile放於NFS上，正式環境放於SAM Storage AP提供問題的SQL，在測試環境跑一天出不來，正式環境則跑5分鐘 SELECT COUNT(1) FROM META_202302 WHERE TO_CHAR(PDATE, 'YYYYMMDD')…

SQL> ALTER TABLE MGR.SAVE_MT ADD PARTITION 2023M04 VALUES LESS THAN (TO_DATE(' 2023-05-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS')); ALTER TABLE MGR.SAVE_MT ADD PARTITION 2023M…

resource busy output message when dropping a table SQL> / DROP TABLE MGR.PFS_CRT_INV_SAVE_DT_C_TMP_202109 PURGE * ERROR at line 1: ORA-00054: resource busy and acquire with …

The customer has a request that they need to change the PGDATA location and then the PostgreSQL tablespace needs to be changed to the new location. Step 1. Stop Postgres [postgres@pdb10a ~]$…

There are two solutions, drop any table or create procedure, the first drop any table contains drop any table and truncate any table, if you don't want drop any table permissions, create tr…

JAVA Keytool Description keytool --help Key and Certificate Management Tool Commands: -certreq Generates a certificate request -changealias Changes an entry's alias …

Problem: Query feback ORA-01775: looping chain of synonyms SQL> SELECT IM.ID,  IM.NAME,  IM.SID,  IM.SNAME,  IM.INUMBER,  to_date(IM.IDATE, 'yyyy/mm/dd…