Automatic Workload Repository (AWR) is a licensed feature that allows information to be recorded on a database for multiple purposes including detection and elimination of performance issues. AWR reports are an extremely useful diagnostic tool for the determination of the potential cause of database wide performance issues. Typically when a performance issue is detected, you … Read more
The SEC_CASE_SENSITIVE_LOGON parameter is deprecated. It is retained for backward compatibility only. SEC_CASE_SENSITIVE_LOGON enables or disables password case sensitivity in the database. true: Database logon passwords are case sensitive. false: Database logon passwords are not case sensitive. Only users who have the ALTER SYSTEM privilege can set the SEC_CASE_SENSITIVE_LOGON parameter. You should ensure that this parameter is set to TRUE so that case sensitivity … Read more
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
There is no excerpt because this is a protected post.
Overview: The ORA-01652 error concerns a failure in allocating the extent for the temp segment in the tablespace. The temp segment refers to a temporary tablespace used internally by the Oracle database for the function of certain operations, such as joins. The primary solution to an ORA-01652 error revolves around increasing the size of the … Read more
Create user Drop user Alter user Backup user Failed logins See failed logins (keep in mind this resets every time a successful login occurs) How to get the last password changed time for a oracle user CTIME Indicates – Creation TimePTIME Indicates – Password Change TimeThis is the query the metric is executing. An incident … Read more