anbob @zhangweizhao

Blog: https://t.co/a7mHMRG4rC , Oracle ACE pro, Focus on the Oracle database Troubleshoot Performance, SQL turning, ... anbob.com CHINA, BeiJing Joined January 2012

Tweets

145
Followers

89
Following

177
Likes

71

anbob @zhangweizhao

3 months ago

#postgresql HighGOdb sys% CPU 90%+ tuning anbob.com/archives/8976.… anbob.com/archives/8951.… newfstatat()

0 0 1 30 0

anbob @zhangweizhao

10 months ago

#migrate from studying Oracle to studying other databases, such as Postgresql,HighgoDB, GaussDB,Kingbase,openGauss;MySQL,GoldenDB;Oceanbase; Dameng DB; I am going crazy 😩🤬

0 0 1 51 0

#postgresql Does anyone know in PG, SQL 'select * from tab a join view (contain the func）b where a.ctim>v.ctim-30 and a.nam=b.nam'， when modify a function ‘volatile’ to 'immutable‘, hash join change to nested loop with index. function volatile affect predicate push ?

0 0 1 43 0

anbob @zhangweizhao

a year ago

Cows and horses yearn for grasslands, while camels yearn for deserts

0 0 1 34 0

Download Image

anbob @zhangweizhao

a year ago

#oracle Does anyone know how to create a sql profile in oracle without affecting other users, different table objects(schema) and data, even if it is the same SQL, same table and index structure?

1 0 3 147 0

anbob @zhangweizhao

2 years ago

#oracle What's 0x400000000000000000 of tab$.PROPERTY ? Normal table Exp fail with EXP-00064: xx is an inner nested table and cannot be exported. anbob.com/archives/7737.…

0 0 1 36 0

anbob @zhangweizhao

2 years ago

还记得你何时加入 X 吗？我知道！#我的X周年纪念日

0 0 0 12 0

Download Image

anbob @zhangweizhao

2 years ago

When cursor_sharing=FORCE, you may encounter an unknown BUG ORA-7445 [kkocsMarkBindFroCB] on oracle 11.2.0.4 #oracle

0 0 0 42 0

anbob @zhangweizhao

3 years ago

#hugepage The oracle db alert log always shows a size of 2M, even if the hugepagesize of 1M(default) is configured on IBM Linuxone machine.

0 1 1 662 0

Download Image

anbob @zhangweizhao

3 years ago

anbob.com/archives/7043.… Oracle迁移到PostgreSQL注意事项: to_date

0 0 0 29 0

anbob @zhangweizhao

3 years ago

还记得你何时加入 Twitter 吗？我知道！#我的Twitter周年纪念日

0 0 0 27 0

Download Image

anbob @zhangweizhao

3 years ago

#PostgreSQL haha

0 0 0 0 0

Download Image

anbob @zhangweizhao

4 years ago

#oracle Interesting , a SQL 2 child_cursor has same plan but differenct Plan_hash_value, (BHW no contain “TEMP TABLE TRANSFORMATION” )

0 0 1 0 0

Download Image

anbob @zhangweizhao

4 years ago

#oracle #ora4030 Oracle 19.13 when OS parameter /proc/sys/vm/max_map_count=65530 _realfree_heap_pagesize=65536 , which parameter limit 32G per process?