Posts

MySQL: To show GRANTs on a trigger

  SELECT      TRIGGER_SCHEMA,      TRIGGER_NAME,      EVENT_OBJECT_TABLE AS 'TABLE_NAME',      DEFINER  FROM information_schema.TRIGGERS  WHERE TRIGGER_NAME = 'after_mao_inventory_insert'; SELECT      TRIGGER_SCHEMA,      TRIGGER_NAME,      DEFINER  FROM information_schema.TRIGGERS  WHERE TRIGGER_NAME = 'after_mao_inventory_insert';
Post a Comment
Read more

MySQL: To show GRANTs for a table

 SELECT GRANTEE, TABLE_SCHEMA, TABLE_NAME, PRIVILEGE_TYPE  FROM INFORMATION_SCHEMA.TABLE_PRIVILEGES  WHERE TABLE_NAME = 'MAO_INVENTORY_TRACKING';
Post a Comment
Read more

WIN: To check AD group of a user

 > net user /domain username   H:\>net user /domain gm15 The request will be processed at a domain controller for domain tmw.com. User name                    GM15 Full Name                    Murugappan, Gillian  (GM15) Comment User's comment Country/region code          000 (System Default) Account active               Yes Account expires              Never Password last set            5/25/2026 7:27:09 PM Password expires             8/23/2026 7:27:09 PM Password changeable          5/26/2026 7:27:09 PM Password required            Yes User may change password     Yes Workstations allowed         All Logon scr...
Post a Comment
Read more

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