Tuesday, June 9, 2020

How to change SQL prompt to show connected user and database name in 12c +

›
In order to get the Database schema & Database name with include Time on the prompt need to change on the below Original file.   pwd /u0...
1 comment:
Tuesday, June 2, 2020

How To Stabilize the Execution plan using SQL PLAN Baseline

›
How To Stabilize the Execution plan using SQL PLAN Baseline   Each SQL associated with SQL_ID and based on the DBMS_STATS, the Optimiz...
1 comment:
Wednesday, August 26, 2015

Query based export/import using datapump

›
######################################### Query based export/import using datapump ######################################### Here is th...
1 comment:
Monday, March 16, 2015

TOP SEGMENTS OF A ORACLE DATABASE

›
#################################################### TOP 5 LARGE SEGMENT GROWTH(OBJECT GROWTH) ##########################################...
1 comment:

Determine the process which is locking an Oracle account with incorrect password

›
Here is the procedure to Determine the process which is locking an Oracle account with incorrect password, which search from the dba_audit_...
1 comment:

HIGH WATER USAGE (HWM USAGE)

›
############################## HIGH WATER USAGE (HWM USAGE) ############################## To resize any datafile to reclaim some space o...
1 comment:

How to check whether patch is applied via Hotpatch or Not in R12.2.3

›
####################################################### TO CHECK WHETHER PATCH IS APPLIED VIA HOTPATCH OR NOT ###########################...
1 comment:

Logfile Locations in R12.2.3

›
Please find the below logfiles of Admin server/oacore/forms and so on. Admin server - $FMW_HOME/user_projects/domains/EBS_domain_$TWO_TAS...

How to find database growth on a Monthly wise

›
################################### DATABASE GROWTH ON A MONTHLY WISE ################################## select to_char(CREATION_TIME,...
1 comment:
Sunday, February 16, 2014

ORA-29702: ERROR OCCURRED IN CLUSTER GROUP SERVICE OPERATION

›
################################################################# ORA-29702: ERROR OCCURRED IN CLUSTER GROUP SERVICE OPERATION ##########...
1 comment: