About Me

author's avatar The Maclean Liumaclean liu

Phone: +86 13764045638

Email & Gtalk:  liu.maclean@gmail.com

Company:ParnassusData Software System Inc.  http://www.parnassusdata.com/

Personal Blog: http://www.askmaclean.com



View maclean liu's profile on LinkedIn

Maclean Liu is



He is very influential person in Oracle Database community in China and Asia-Pacific. He would like to answer Questions Posted on both OTN and other Oracle Forum, till now he had answered about 4000 Oracle Database Questions on internet.

  1. Maclean has been very active with the community and setup a Q&A section on his blog, amazingly 4000+ Oracle RDBMS questions had been answered by him.
  2. Maclean published several introduction videos about Oracle technology to the internet and they are widely watched by Chinese audience.
  3. Active Shanghai Oracle User Group field activities participant and organizer.
  4. A qualified evangelist for Oracle 12c and Exadata products.
  5. Have a special passion on Oracle database related products, eager to share his Oracle knowledge with the community every day.



Oracle-related blog: http://www.askmaclean.com/Ask Maclean Oracle Forum http://t.askmaclean.com/Number of members: 1741
Published white paper(s) and/or article(s)    (include title and link): 《Understanding Oracle SQL Execution Plan》in Chinesehttp://t.askmaclean.com/forum.php?mod=attachment&aid=MjQ4MnxmMjYzODY1MXwxMzk4Nzc2MjAxfDF8MzIzNw%3D%3D《The mystery of Oracle Histogram》in Chinesehttp://www.slideshare.net/liumaclean/maclean-liuoracle-cbohistogram-0321



《Oracle Database tuning: Hawk Eyes on AWR I》http://t.askmaclean.com/forum.php?mod=attachment&aid=MTU2M3w0MWUwMGM4NXwxMzg0MDAyNzUzfDJ8MjA4Ng%3D%3D


《Oracle Database tuning: Hawk Eyes on AWR II》




《Know more about Oracle Latch from 9i》http://www.askmaclean.com/archives/oracle-latch.html


《Oracle Database 12c New Features》http://www.askmaclean.com/archives/12c-new-feature-summary.html


《know more about Oracle Mutex》http://www.slideshare.net/liumaclean/maclean-liuoraclemutex


《Oracle Background Process SMON: Something you don’t know》 http://www.slideshare.net/liumaclean/smon


《Essential oracle security internal for dba》 http://www.slideshare.net/liumaclean/essential-oracle-security-internal-for-dba-13569701


《Oracle SQL tuning Essentials》




《Oracle Tuning: An ADDM DBA》http://t.askmaclean.com/forum.php?mod=attachment&aid=MjAyNHxhNzYxNTU2YXwxMzcyMDYzNTY0fDJ8MjYwNw%3D%3D



《Know more about Enqueue Deadlock Detection》



《MINSCN AND Cache Fusion Read Consistent》http://www.askmaclean.com/archives/minscn%E4%B8%8Ecache-fusion-read-consistent.html


《Index Cluster factor can slowdown your delete》

Who pulls the background process dbwr’s trigger? http://www.askmaclean.com/archives/who-pulls-the-background-process-dbwrs-trigger.html


《Oracle AWR Statistics Explained》


《Something About RAC Brain Split》http://www.slideshare.net/liumaclean/oracle-rac-brain-split-resolution


《11g New Feature: Online Hot Patching》http://www.slideshare.net/liumaclean/11g-online-patching


《Know more about Oracle Critical Patch Update》




Published book(s):  Writing A book
Published sample code:
Oracle (OTN) Discussion Forum User Profile: https://community.oracle.com/people/LiuMaclean(%E5%88%98%E7%9B%B8%E5%85%B5)
Podcasts and/or video ( include title and link): 《How to Learn Oracle Database: Wings of liberty》http://www.tudou.com/programs/view/46S4t6wwaQw/《Install 11gR2 RAC Using VirtualBox Best Practice》http://www.tudou.com/programs/view/xAOpQowNlU0/ 

《Install 10gR2 RAC Using VirtualBox Best Practice》http://t.askmaclean.com/thread-891-1-1.html


《Install RAC Using VirtualBox Best Practice》




《Oracle Database tuning: Hawk Eyes on AWR I》



《Oracle Database tuning: Hawk Eyes on AWR I》





Conference presentation (include Conf. name, date, presentation title and link): SHOUG Forum COLLABORATE 14 : 《Oracle Database 12c New Feature:Information Lifecycle Management ILM and Storage Enhancements》  http://www.askmaclean.com/archives/12c-ilm.htmlSHOUG Forum COLLABORATE 13 : 《Oracle Database 12c New Feature:12c Pluggable Database Container Database》  http://www.askmaclean.com/archives/pluggable-container-db-12c.htmlOracle ACS proseminar: 《Oracle Tuning: An ADDM DBA》http://t.askmaclean.com/forum.php?mod=attachment&aid=MjAyNHxhNzYxNTU2YXwxMzcyMDYzNTY0fDJ8MjYwNw%3D%3D 
Industry-recognized Certification: 10g/11g OCM
Social media profile(s): http://weibo.com/liumaclean


  1. Ankur Garg says:

    Hi Xiang,
    Nice to saw your profile, I am also working as a DBA with TCS from last 2 years.
    Greatly inspired from your tech details.Hope to connect with you soon.
    Hope you will make us out if we fall somewhere in problem related to database.
    Good Day !

  2. Professional Certification is in date order (latest first)and yet job profile is oldest first which is quite unusual.

    I like your AWR summmary post


  3. Chanchal Chatterjee says:

    Hi Liu Maclean,

    Many thanks for sharinf lot of details.

    You’ve mentioned that information about the Global Service options of TNS acan be found in nsi.h and NT protocol characteristics can be found in ti.h. I am not able to find those files. Could you please help me out to find the information. It will be a great help, if you can shere details on Global Service options and NT protocol characteristics of TNS.

    Thanks in Advance.


  4. ricky says:

    你很像我喜欢的明星—林俊杰~~so 卡哇伊~~~

  5. Gavin Green says:

    Hi Maclean Liu
    i want to know you very very mach,can we communicate in QQ?my number is 214707490

  6. ghy1215 says:

    Hi Maclean,

    I want to register your websit ‘Ask Maclean Home’, would u like give me a code for register? thx


  7. Chengrun says:

    Hell Maclean:
    I am working for a web game company. I want to change the job which working with ORACLE. I’ve been Uplooking Beijing last year. I dont know the next step fo my life.
    The graduation day is coming at the end of this year.
    Would you like to give me some ides.


  8. Rekha Sharma says:

    well Experienced Profile touch with all advanced technology like golden gate,RAC and exadata machine

  9. sascha repple says:

    Hi liu,
    can you share something how u can pass so many certifications??it’s amazing!

  10. 能给一个网站的邀请码吗?新手dba寻找资料来到这里(spotlight for rac),急需。 以后会急需关注网站的,希望可以加入学习。谢谢

  11. Marusu says:


  12. T_oracle says:

    Hi ,maclean ,看到你的AWR视频,让我对oracle重拾激情!感谢你的分享~;如果能提供一个网站的注册码,那就更高兴了!

  13. Nice Profile!

  14. 雁过留痕

  15. Very 牛逼

  16. Very 牛逼

  17. 小叶 says:

    very nice profile

  18. 熊神 says:


Speak Your Mind

沪公网安备 31010802001379号

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569