Soban.dba

If you have many domains running on the same Linux server it can be difficult to see what is running and what is not. I have created a   Bash script   that lists all WebLogic Server and Node Manager processes. I have tested it on Red Hat 5 and 6. Here is an example output. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 ############################################################################## # WebLogic Servers # <owner>  <domain>  <server>  <pid>  <ports> ############################################################################## prism01ora  prism01osb  AdminServer        23738  7011 prism01ora  prism01osb  prism01osbServer1  24018  7890,8011 prism01ora  prism01por  AdminServer        2943   7021 prism01ora  prism01por  prism01porServer1  28665  8021 prism01ora  prism01wls  AdminServer        22510  7001 prism01ora  prism01wls  prism01wlsServer1  22362  800

What is the SQL Tuning Health-Check Script (SQLHC)? The SQL Tuning Health-Check Script is a tool developed by the Oracle Server Technologies Center of Expertise. The tool, also known as SQLHC, is used to check the environment in which a single SQL Statement runs, checking Cost-based Optimizer (CBO) statistics, schema object metadata, configuration parameters and other elements that may influence the performance of the one SQL being analyzed. INSTRUCTIONS Login to the database server and set the environment used by the Database Instance Download the "sqlhc.zip" archive file  and extract the contents to a suitable directory/folder Connect into SQL*Plus as SYS, a DBA account, or a user with access to Data Dictionary views and simply execute the "sqlhc.sql" script. It will request to enter two parameters: Oracle Pack License ( T uning,  D iagnostics or  N one) [T|D|N] (required) If site has both Tuning and Diagnostics licenses then specify  T  (Oracle

/* Formatted on 7/27/2017 4:21:41 PM (QP5 v5.256.13226.35510) */ --- ALL CONCURRENT REQUESTS DETAILS WITH DETAILL TIMES SPENT     SELECT request_id,          parent_request_id,          --fcpt.user_concurrent_program_name Request_Name,          fcpt.user_concurrent_program_name program_name,          DECODE (fcr.phase_code,                  'C', 'Completed',                  'I', 'Incactive',                  'P', 'Pending',                  'R', 'Running')             phase,          DECODE (fcr.status_code,                  'D', 'Cancelled',                  'U', 'Disabled',                  'E', 'Error',                  'M', 'No Manager',                  'R', 'Normal',                  'I', 'Normal',                  'C', 'Normal',                  'H', 'On Hold',