Pages

▼
Wednesday, July 24, 2024

Change Initial and Next extend size for partitioned table

›
Change Initial and Next extend size for partitioned table. When changing the next and initial extend size for a Partitioned / Sub Partitione...
Monday, June 10, 2024

SQLs for Tuning Instance

›
------------------------------ -- See Memory Allocation ------------------------------ SET PAGESIZE 1000 SET LINESIZE 120 SELECT snap_id, na...
Wednesday, May 29, 2024

crontab to monitor sar

›
crontab -e 59 23 * * * /software/oracle/oracle/.scripts/monitor/sar/sar_monitor.sh sar_monitor.sh WORK_DIR=/software/oracle/oracle/.scripts/...
Tuesday, May 28, 2024

View Partition High value - Avoid ORA-00932: inconsistent datatypes

›
SELECT partition_name, TO_CHAR(high_value)    FROM USER_TAB_PARTITIONS  WHERE table_name = ' SOME_PARTITIONED_TABLE '; ORA-00932: i...
Thursday, April 11, 2024

pcs cluster switch from cluster mode to local mount mode

›
Stop the cluster mode root@rock8-19c-2:~>%  pcs property set maintenance-mode=true root@rock8-19c-2:~>% pcs status Cluster name: igt05...

ORA-12547: TNS:lost contact

›
ERROR: ORA-12547: TNS:lost contact ============================================= Correct permissions should be: ls -l ${ORACLE_HOME}bin/orac...
Wednesday, April 10, 2024

drbd sync SOW with drbdadm and reference

›
A. Activity Overview  1. drdb syncrinization B. Prerequisite and Pre-checks: Steps: 1. On servers BD902G and BD901G pcs status Server which ...