check dataguard broker status show lag on Node Standby 1 , but Node Standby 2 is normal DGMGRL> show database dbdg1 Database - DBDG1 Role: PHYSICAL STANDBY Intended Sta…

Open Terminal and execute command % brew install podman Initial Machine % podman machine init When we execute this line of command, Podman will check whether there is the latest FCOS in o…

執行Container # podman run --name pgadmin4 -p 8080:80/tcp -v /etc/localtime:/etc/localtime -e "PGADMIN_DEFAULT_EMAIL=admin" -e "PGADMIN_DEFAULT_PASSWORD=12qwaszx" -d --restart…

瞭解DRM（Dynamic Resource Remastering 講DRM（Dynamic Resource Remastering），首先一定說說cache fusion的機制，cache fusion是在8i OPS中引入，解決的目的是原來在OPS中，instance A讀某個block，instance B也要讀時，instance A必須把該block寫入到磁碟，然後…

Oracle Doc defind describes the columns Column: DATA_LENGTH Datatype: NUMBER Description: Length of the column (in bytes) Column: CHAR_LENGTH Datatype: NUMBER Description: Di…

URL字元轉義 + URL 中+號表示空格 %2B 空格 URL中的空格可以用+號或者編碼 %20 / 分隔目錄和子目錄 %2F ? 分隔實際的URL和引數 %3F % 指定特殊字元 %25 # 表示書籤 %23 & URL 中指定的引數間的分隔符 %26 = URL 中指定引數的值 %3D…

Step 1. Click HACS and Choose Integrations Step 2. Click Explore & download repositories Step 3. Search Xiaomi MioT Step 4. Click Download

Introduction the Oracle MERGE statement MERGE INTO [target_table] A USING [source_table/sql] B ON ([conditional expression] and [...]...) 　　WHEN MATCHED THEN 　　　　[UPDATE/INSERT/DELETE st…

1. Download TrueNAS vmdk from home-assistant.io You can download from here https://www.home-assistant.io/installation/linux 2. SCP/SFTP the vmdk to TrueNAS, if you don't have VMs/src path…

Get ospid from sid set lines 150 col username for a15 col osuser for a10 col machine for a15 col program for a20 select b.spid, a.username, a.program, a.osuser, a.machine, a.sid, a.ser…

Problem: ORA-01686 error was encountered when adding files to a tablespace. Is there a way to add new data files to this tablespace? SQL> begin for i in 1..96 loop execute immediate '…

1. Check backup controlfile, this case need restore to 2022-11-04 08:00:00, choose backup controlfile Tag TAG20221104T113557 is best, the backup time is 2022-11-04 11:35:57, and remember dbid n…

Check Tablespace Utilization -- https://www.support.dbagenesis.com/post/tablespace-utilization-in-oracle set colsep | set linesize 100 pages 100 trimspool on numwidth 14 col name format a25 …

1. query running SQL or history SQL then get SQL_ID select sql_id, status, sql_text from v$sql_monitor where username = 'SYS' and sql_text like '%TAA%'; -- or select…

Check Partition Rows column table_name format a20 column partition_name format a20 column subpartition_name format a20 select table_name, partition_name, num_rows from …