ORACLE DBA- Page 4 of 4 - Compitionpoint

Archives for ORACLE DBA - Page 4

Find Plan Hash Values from SQLID

compitionpoint September 29, 2020 Find Plan Hash Values from SQLID2020-09-12T11:30:31+00:00 Oracle database No Comment

SET PAUSE ON SET PAUSE 'Press Return to Continue' SET PAGESIZE 60 SET LINESIZE 300 SELECT DISTINCT sql_id, plan_hash_value FROM dba_hist_sqlstat q, ( SELECT /*+ NO_MERGE */ MIN(snap_id) min_snap,…

SET PASSWORD LIFE TIME TO UNLIMITED

compitionpoint September 27, 2020 SET PASSWORD LIFE TIME TO UNLIMITED2020-09-12T11:30:39+00:00 Oracle database No Comment

Set the password life time to unlimited for DEFAULT profile. SQL> SELECT resource_name,limit FROM dba_profiles WHERE profile=’DEFAULT’; RESOURCE_NAME LIMIT ——————————– —————————– COMPOSITE_LIMIT UNLIMITED SESSIONS_PER_USER UNLIMITED CPU_PER_SESSION UNLIMITED CPU_PER_CALL UNLIMITED LOGICAL_READS_PER_SESSION…

Clone/Refresh Database using RMAN

compitionpoint September 23, 2020 Clone/Refresh Database using RMAN2020-09-12T11:29:24+00:00 RMAN No Comment

For our understanding Source Database: PRIM (It would be TARGET in case of RMAN Terminology) Auxiliary/Clone Database: TEST 1) Take FULL backup on source database using RMAN: Verify Source database…

AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora

compitionpoint September 11, 2020 AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora2020-09-11T11:10:58+00:00 Oracle database No Comment

ERROR: Export: Release – Production on Wednesday, 08 August, 2007 10:12:50 Copyright (c) 2003, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release – Production With…

1 2 34