cassandra -f [start commads] ./nodetool status [checking status] ./nodetool ring [depicts of the state of nodes] ./nodetool -h 192.168.0.101 clean [cleanup of keys that no longer belong to a particular node] ./nodetool -h 192.168.0.101 info [gives information token,disk storage, generation number,uptime seconds,heap] ./nodetool -h 192.168.0.101 compact [immediate compaction on the entire node,key space,column family level] … Read more
PROCESSES specifies the maximum number of operating system user processes that can simultaneously connect to Oracle. Its value should allow for all background processes such as locks, job queue processes, and parallel execution processes. The default values of the SESSIONS and TRANSACTIONS parameters are derived from this parameter. Therefore, if you change the value of PROCESSES, you should evaluate whether to … Read more
To identify the number of diskgroup ,status from below query. Size of ASM Diskgroup Check Diskgroup online/offline Status from OS Prompt Check Datafile, Controlfile, Logfile existence in respective Diskgroup. Check the compatibility version for below diskgroup. Change ASM Compatibility to 18.0.0.0.0. ASM_DISKSTRING Validate Unused Disk To identify the free allocation units for each lun based … Read more
DB_NAME On a primary database, specify the name used when the database was created. On a physical standby database, use the DB_NAME of the primary database. DB_UNIQUE_NAME Specify a unique name for each database. This name stays with the database and does not change, even if the primary and standby databases reverse roles. LOG_ARCHIVE_CONFIG The … Read more
Oracle hangs only when he is waiting for a resource. It might be a software resource (a latch or lock), or you could be hung waiting for server resources (CPU, RAM). There are several ways to find the root cause of an Oracle hanging issue: oradebug – See below for complete steps for diagnosing a … Read more