About Me

My name is Wei Shan and I am currently based in London. I have more than 6 years of experience in databases, working with multiple relational and non-relational databases. I hold various certifications, focusing on database primarily. My speciality are database high availability and performance benchmark/tuning.

I would like to think of myself as an database guy rather than an Oracle guy. Product is, after all, just an implementation of concepts!

I am definitely still learning and I hope to use this platform to share my knowledge with people. If you have any information that you want to share with me, please feel free to contact me at weishan.ang@gmail.com.

You can also find me on http://www.linkedin.com/in/weishan

5 thoughts on “About Me”

  1. Hi WEI SHAN,

    It will be helpful if you share the steps for 1. To access Solaris 10 x86 installed on (IBMX3850X5 with Raid 5) remotely in LAN and WAN through GUI


  2. Hi Wei

    I am quite impressed by your blog. I was wondering if you could help me solve this challenge:

    I have a client that uses UTL_TCP extensively to make connections to their .NET SOAP servers. So, the UTL_TCP acts as a client to the .NET servers (that are SOAP servers). Recently, they migrated to a new infrastructure and now they face an intermittent timeout problem. I figured that there was a firewall in between that was blacking-out connections after 60 mins of idle-time. The UTL_TCP connections are long-living connections themselves with a transfer timeout of 86400 seconds. The firewall team does not want to disable the idle-timeouts or change firewall settings at all. They suggest us (application team) to introduce a keep-alive mechanism. There is no keep-alive for UTL_TCP connections. In fact, it does not pick the Linux OS kernel parameters to keep the tcp connections alive (this was because Oracle initiates an IPC communication with the OS socket and IPC does not have a keep-alive setting). Please also note that these UTL_TCP connections are being initiated from different sessions and therefore we cannot even persist the UTL_TCP connection globally (even if we could) and send fake keep-alives by sending empty messages.

    Now we are stumped ! Do you know of a way to keep-alive Oracle UTL_TCP connections.

    Thank you for taking time.

    Much appreciated


  3. Hi Wei Shan,

    Completely agree with what you’ve said – “just an implementation of concepts!” – really enjoyed reading your blog. Keep going 🙂

    I’m an Oracle DBA (also based in Singapore) but I’m also interested in digging the PostgreSQL source code to understand how the Postgres guys implemented their optimizer and their recovery mechanism. It’s rare to see a blog that has entries on both.

    1. Thanks Dan. It’s nice to hear that people enjoy reading my blog. If you are keen, we can meetup to discuss about databases. Drop me an email :)))

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s