Archives for Oracle database - Page 3
DATABASE SCHEMA SIZE from the database
set linesize 150 set pagesize 5000 col owner for a155 select OWNER,sum(bytes)/1024/1024/1000 “SIZE_IN_GB” from dba_segments group by owner order by owner; Thank you !!
Find Plan Hash Values from SQLID
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
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…
AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora
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…