Fluffy Boy

 









Comments

Post a Comment

Popular posts from this blog

HANA certification questions

Here are 100 **SAP HANA Cloud Administration** certification questions with answers to help you prepare for the **C_HANACLOUD_2022** exam. --- ## **SAP HANA Cloud Administration – Practice Questions and Answers** ### **Section 1: HANA Cloud Architecture and Provisioning** 1. **What is SAP HANA Cloud?** - A fully managed in-memory database-as-a-service (DBaaS) running in **SAP Business Technology Platform (BTP)**. 2. **Which tool is used to provision an SAP HANA Cloud instance?** - **SAP BTP Cockpit**. 3. **What are the key components of SAP HANA Cloud?** - **HANA Database, Data Lake, and Data Lake Relational Engine**. 4. **How do you access SAP HANA Cloud after provisioning?** - Through the **SAP BTP Cockpit** or **SAP HANA Cloud Central**. 5. **Which deployment model is used in SAP HANA Cloud?** - **Cloud-only**, provided as a **managed service** by SAP. 6. **Can you install SAP HANA Cloud on-premise?** - No, SAP HANA Cloud is a **fully managed ser...
Read more

Troubleshoot Oracle performance issue

  Identifying performance issues in an Oracle Database 19c environment requires a structured approach to pinpoint bottlenecks and optimize the system. Below is a step-by-step guide to help you identify and resolve performance issues: Step 1: Gather Baseline Information Understand the Symptoms: Is the database slow for all users or specific applications? Are there specific queries or processes that are slow? When did the performance degradation start? Check the Alert Log: Review the alert log ( alert_<SID>.log ) for errors or warnings. Locatio n:  $ORACLE_BASE/diag/rdbms/<DB_NAME>/<SID>/trace/alert_<SID>.log . Check Recent Changes: Were there any recent changes (e.g., schema changes, parameter changes, patches)? Query  DBA_REGISTRY_HISTORY  for recent updates. Step 2: Monitor Database Activity Check Active Sessions: Identify active sessions and their wait events: sql Copy SELECT sid , serial #, username, sql_id, event, blocking_session FROM ...
Read more
Oracle EBS DBA 12.2 Command Worksheet 1. Checking EBS Version sh sqlplus apps/apps@<DB_SID> SELECT release_name FROM apps.fnd_product_groups; 2. Start/Stop EBS Services Start Services sh $ADMIN_SCRIPTS_HOME/adstrtal.sh apps/apps_pwd Stop Services sh $ADMIN_SCRIPTS_HOME/adstpall.sh apps/apps_pwd Start Only Web Services sh $ADMIN_SCRIPTS_HOME/adapcctl.sh start Start Only Forms Services sh $ADMIN_SCRIPTS_HOME/adformsctl.sh start Start Concurrent Manager sh $ADMIN_SCRIPTS_HOME/adcmctl.sh start apps/apps_pwd 3. Checking EBS Services Status sh $ADMIN_SCRIPTS_HOME/adstpall.sh status 4. Start/Stop Database sh sqlplus / as sysdba shutdown immediate; startup; 5. Checking EBS Log Files Application Logs $LOG_HOME/ora/10.1.3/Apache/logs/error_log $LOG_HOME/ora/10.1.3/Apache/logs/access_log $LOG_HOME/ora/10.1.3/opmn/logs/default_group~oacore~default_group~1.log Concurrent Manager Logs sh $APPLCSF/$APPLLOG/ Database Alert Log sh $ORACLE_BASE/diag/rdbms/$ORACLE_SID/$ORACLE_SID/alert.log 6. Defau...
Read more