Cron is named after Greek word “Chronos” that is used for time. It is a system process that will automatically perform tasks as per the specific schedule. Cron is a unix utility that allows tasks to be automatically run in the background at regular intervals by the cron daemon often termed as cron jobs. It … Read more
File Permissions The “umask” command can be used to read or set default file permissions for the current user. The umask value is subtracted from the default permissions (666) to give the final permission: 666 : Default permission 022 : – umask value 644 : final permission The “chmod” command is used to alter file … Read more
File and Directory The “pwd” command displays the current directory: The “ls” command lists all files and directories in the specified directory. If no location is defined it acts on the current directory. The “-a” flag lists hidden “.” files. The “-l” flag lists file details. ls -al | pg Full directory listing and prompt . ls | wc … Read more
ADRCI is a command-line tool that is part of the fault diagnosability infrastructure introduced in Oracle Database 11g. ADRCI enables you to: View diagnostic data within the Automatic Diagnostic Repository (ADR) View Health Monitor reports. Diagnostic data includes incident and problem descriptions, trace files, dumps, health monitor reports, alert log entries, and more. ShortPolicy and … Read more
with PGA_GB as (SELECT VALUE/(1024*1024*1024) PGA_GBFROM V$PARAMETER WHERE NAME = ‘pga_aggregate_target’),subpools as (SELECT COALESCE(SUM(VALUE/(1)), NULL) subpoolsFROM V$PARAMETER WHERE NAME = ‘_kghdsidx_count’),SGA_GB as (select (trunc(sum(value)/1024/1024/1024,2)) SGA_GBfrom v$sga),SHARED_POOL_GB as (SELECT VALUE/(1024*1024*1024) SHARED_POOL_GBFROM V$PARAMETER WHERE NAME = ‘shared_pool_size’),DB_CACHE_SIZE as (SELECT VALUE/(1024*1024*1024) DB_CACHE_GBFROM V$PARAMETER WHERE NAME = ‘db_cache_size’)select PGA_GB, SGA_GB, DB_CACHE_GB,SHARED_POOL_GB,(trunc(SHARED_POOL_GB/DB_CACHE_GB*100,2)) as PERCENT,subpoolsfrom SHARED_POOL_GB, DB_CACHE_SIZE, SGA_GB,PGA_GB,subpools; PGA_GB … Read more