Pages

▼
Monday, March 25, 2024

Oracle Locks; Locks in Oracle

›
V$LOCKED_OBJECT SELECT LO.session_id, LO.oracle_username, LO.os_user_name,         OBJ.object_name , OBJ.owner   FROM V$LOCKED_OBJECT LO,   ...

ORA-01873: the leading precision of the interval is too small

›
SELECT * FROM USER_JOBS ORA-01873: the leading precision of the interval is too small SELECT * FROM DBA_SCHEDULER_JOBS ORA-01882: timezone r...
Thursday, March 7, 2024

Oracle Patch types

›
Oracle Patch types Interim patches - contain a single bug fix or a collection of bug fixes provided as required Diagnostic patches - inten...
Monday, March 4, 2024

ORA-12034: materialized view log on "SCHEMA"."MY_SERVICE" younger than last refresh

›
Issue: Refresh Materialized View is giving this error: ERROR at line 1: ORA-12034: materialized view log on "SCHEMA"."MY_MVI...
Thursday, February 22, 2024

Code by example: expdp from schema + scp to a backup server

›
exp_ schema .sh #!/bin/bash RUN_DATE=`date +"%Y%m%d"` EXP_DIR=/starhome/iu/workarea/ora_exp EXP_NAME_PREFIX=exp_schema EXP_DIR_BAC...
Monday, February 12, 2024

SQL Tuning II DBMS_XPLAN, V$SQL_PLAN

›
SQL Tuning II ============================= Contents ============================= V$SQL_PLAN  and other tables DBMS_XPLAN =========...
Wednesday, February 7, 2024

Upgrade to Oracle 19.12 from Oracle 19.x by example

›
Upgrade to Oracle 19.12 from Oracle 19.x by example Minimum  space required: 6Gb for p33494256 and p6880880 patches 16Gb for /software/oracl...