Posts

MySQL: to find largest tables

Image
  select table_schema as database_name,        table_name,        round( (data_length + index_length) / 1024 / 1024, 2)  as total_size,        round( (data_length) / 1024 / 1024, 2)  as data_size,        round( (index_length) / 1024 / 1024, 2)  as index_size from information_schema.tables where table_schema not in ('information_schema', 'mysql',                            'performance_schema' ,'sys')       and table_type = 'BASE TABLE'       -- and table_schema = 'your database name' order by total_size desc limit 10;
Post a Comment
Read more

OEM URL

  https://oem15db601.tmw.com:7803/em sysman / oms_newLife3
Post a Comment
Read more

To bounce OEM

 oracle-tmwoem01:oemprod:/usr/opt/app/oracle/bea/oms11g/opmn>cd $OMS_HOME oracle-tmwoem01:oemprod:/usr/opt/app/oracle/bea/oms11g>cd bin To get a status: >./emctl status oms -details Oracle Enterprise Manager Cloud Control 12c Release 5 Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved. Enter Enterprise Manager Root (SYSMAN) Password : Console Server Host : oem12tstdb601 HTTP Console Port : 7788 HTTPS Console Port : 7802 HTTP Upload Port : 4889 HTTPS Upload Port : 4903 EM Instance Home : /usr/opt/app/oracle/product/gc_inst/em/EMGC_OMS1 OMS Log Directory Location : /usr/opt/app/oracle/product/gc_inst/em/EMGC_OMS1/sysman/log OMS is not configured with SLB or virtual hostname Agent Upload is locked. OMS Console is locked. Active CA ID: 1 Console URL: https://oem12tstdb601:7802/em Upload URL: https://oem12tstdb601:4903/empbs/upload WLS Domain Information Domain Name : GCDomain Admin Server Host : oem12tstdb601 Admin Server HTTPS Port: 7102 Admin Server is RUNNING...
Post a Comment
Read more

PeopleSoft: To change message size for intergration broker

Image
 Go to the PeopleTools Options page:  
Post a Comment
Read more

MySQL: To check multiple variables or parameters

  To check multiple variables at once: Sql Copy code WHERE gv.VARIABLE_NAME IN ( 'sql_mode' , 'max_connections' , 'time_zone' ); To search by pattern: Sql Copy code WHERE gv.VARIABLE_NAME LIKE 'innodb%' ;
Post a Comment
Read more

MySQL: To see GLOBAL and SESSION variables side by side

  here’s a single MySQL query that shows a system parameter’s GLOBAL and SESSION values side-by-side. You just replace 'sql_mode' with the variable you want to check. Sql Copy code SELECT gv.VARIABLE_NAME, gv.VARIABLE_VALUE AS GLOBAL_VALUE, sv.VARIABLE_VALUE AS SESSION_VALUE FROM performance_schema.global_variables gv JOIN performance_schema.session_variables sv ON gv.VARIABLE_NAME = sv.VARIABLE_NAME WHERE gv.VARIABLE_NAME = 'sql_mode' ;
Post a Comment
Read more

MySQL: To see database parameters

  In MySQL, you can view system parameters (also called system variables ) using the SHOW VARIABLES statement or by querying the performance_schema tables. Here are the main ways: 1. Show all system parameters Sql Copy code SHOW VARIABLES; This lists every system variable and its current value for your session. 2. Show specific parameters by name pattern Sql Copy code SHOW VARIABLES LIKE 'max_connections' ; SHOW VARIABLES LIKE 'innodb%' ; % is a wildcard for matching multiple variables. 3. Show global vs session values Sql Copy code -- Global values (affect all connections) SHOW GLOBAL VARIABLES; -- Session values (specific to your current connection) SHOW SESSION VARIABLES; 4. Using performance_schema Sql Copy code SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME LIKE 'max_connections' ; This is useful for more complex filtering or joining with other metadata. ✅ Tip: If you want to see both the current session ...
Post a Comment
Read more