How to trace oracle database session
The purpose of this blog is to assist DBAs encountering performance issues in locating the problematic query by taking a trace of the session. The steps shared here will help…
Read MoreQuery to get CPU and Memory usage from OEM database
Please use the below query for a period. SELECT to_char(rollup_timestamp,’DD-MON-YY HH24′) “Date”, average “CPU Usage %” FROM sysman.MGMT\$METRIC_HOURLY WHERE target_name like ‘%servername%’ AND metric_name = ‘Load’ AND metric_column =…
Read MoreMICROSOFT WINDOWS 19C DATABASE CREATION
STEPS TO CREATE 19C DATABASE IN MICROSOFT WINDOWS STEP…
Read MoreScript to create trace at database schema level by using trigger
Please create the below and disable or drop the trigger once completed. create or replace trigger set_trace after logon on database begin if user not in (‘SYS’,’SYSTEM’,’SYSMAN’,’OLAPSYS’) then execute…
Read MoreMigrate to Oracle Cloud Database within “1-Click”
Introduction: Oracle provide a tool called MV2OCI(Move to Oracle Cloud Database) and it is a new tool is permitting the load data and migration from “on premises” to Oracle Cloud…
Read More11G to 19c autoupgrade failled with ORA-00904 Error
Introduction: During 11.2.0.4 database upgrade to 19c, Autoupgrade fails with error – NVL(bundle_series,’0′)||’#’|| * ERROR at line 3: ORA-00904: “BUNDLE_SERIES”: invalid identifier ] [ORCL] – ExecuteSql$SQLClient.run NVL(TO_CHAR(action_time, ‘DD-MM-YYYY HH24:MI:SS’),’0′) ||’#’|| NVL(action,’0′)||’#’||…
Read MoreTXK Delta 13 failed due to missing files
TXK Delta 13(32392507) plus critical TXK patches 33550674, 33535778 failed because of missing files adsign.txt and adkeystore.dat under $APPL_TOP_NE/ad/admin The Solution: The apply phase failed twice, once when looking for…
Read MoreAdop Phase=cutover Failing With AutoPatch – AidafoGetFileDbVersion: INFO: ORA-01403: No Data Found
AutoPatch – aidafoGetFileDbVersion: INFO: ORA-01403: no data found when apply adop phase=cutover failing with AutoPatch Please follow below steps to overcome this issue Confirm that value for READ_ONLY_FLAG and ENABLED_FLAG…
Read MoreCost estimate with AWS Pricing Calculator
How to create a cost estimate with the AWS Pricing Calculator? Concepts: Create a logical pricing group. Create weekly, monthly, and yearly estimates for Amazon EC2 instances. Step 1: …
Read MoreWonders in AWS RDS – Good Deployment techniques
Introduction Amazon Web Service offers a diverse range of products and services to clients across the globe and shapes. Amazon RDS is one of the most popular and notable services…
Read More