How to Add User to OSDBA Group
OSDBA Group In the previous post, we have talked about how to enable an user other than administrator (Windows) or oracle (Linux) to use SQL*Plus… Read More »How to Add User to OSDBA Group
How to Check Group of OSDBA
OSDBA or OSOPER OSDBA and OSOPER are just a symbol name defined by Oracle database, users belonged to either group are natively granted to use… Read More »How to Check Group of OSDBA
How to Change Session Time Zone
TIME_ZONE In the previous post, we have checked the time zone in the current session. Now the question is, how to change it? if it… Read More »How to Change Session Time Zone
How to Check Session Time Zone
SESSIONTIMEZONE While DBTIMEZONE is to check the database time zone, the built-in function SESSIONTIMEZONE is to check the exact time zone in the current session.… Read More »How to Check Session Time Zone
Derive Timestamp from SYSTIMESTAMP
SYSTIMESTAMP To have a timestamp as of now, we can use the function SYSTIMESTAMP. SQL> select systimestamp from dual; SYSTIMESTAMP --------------------------------------------------------------------------- 09-AUG-23 04.36.54.934270 PM -04:00… Read More »Derive Timestamp from SYSTIMESTAMP
How to Check Database Time Zone
DBTIMEZONE There're 2 ways to check the time zone of a database. Database Property Since DBTIMEZONE is actually a property of database, we may query… Read More »How to Check Database Time Zone
DATABASE_PROPERTIES, How and Why
DATABASE_PROPERTIES DATABASE_PROPERTIES is a data dictionary view which is able to describe the nature of a database by collecting its permanent properties Let's see standard… Read More »DATABASE_PROPERTIES, How and Why
How to Resolve ORA-00600: [kdu_array_buf non-zero delta]
kdu_array_buf non-zero delta An user reported ORA-00600 when updating a table. For example: SQL> update pay_hist set is_paid = 'Y' where ow is null; ...… Read More »How to Resolve ORA-00600: [kdu_array_buf non-zero delta]
How to Enable AutoTask
DBMS_AUTO_TASK_ADMIN.ENABLE To enable AUTOTASK back to work, we just revert the process of disabling AUTOTASK jobs. Let's see the steps. Check AutoTask Here we query… Read More »How to Enable AutoTask
How to Disable AutoTask
DBMS_AUTO_TASK_ADMIN.DISABLE In the previous post, we've talked about how to modify the starting time and duration of maintenance windows to make the scheduled AUTOTASK work… Read More »How to Disable AutoTask