Без рубрики
how-to download Oracle Java from console
this link you may change to other version:
oracle TM lock, how-to find who forgot index on FK ?
Lets do TM lock and find out what object should be indexed sess 1 sess 2 I use Tanel Poder sripts in this example this one ( ashtop.sql ) and this one result : or use this scipt to find nonindexed foreing keys:
postgresql top 10 tables by io operations
helps to keep focus on «hot» tables top 10 tables by sum of io operatoins: top 10 tables by index scans:
ORA-00600: internal error code, arguments: [smboPut:fixedlen2]
while import full dump from AIX machine to X86 faced this error: helped to set this parameter: ps: version is 11.2.0.4.5
postgresql pgpool-II autofailover and failback
Hello, try to find a good material about how-to configure pgpool and found nothing, so I’ve decide to write my own article =)) I’m recommend to read previous articles: How to install postgres How to configure repmgr to manage standby databases because I use those config in this scenario So, lets start =) First of … Читать далее
How to add em graph to ZABBIX
add to crontab: script: modify /etc/zabbix/zabbix_agentd.conf add and here is zabbix template with correct colors : The result is: Short variant: Thx to Vladimir Mukin for material
SQLT ORA-06598: insufficient INHERIT PRIVILEGES privilege
Hi, faced with this error while generate report to Oracle support: solution is: