Oracle Point, Oracle Life.

I got a chance to read a white paper “Oracle Database 11g Architecture on Windows” today. The abstract of this white paper tell us:

“The Oracle database is certified for 32-bit and 64-bit Windows operating systems. 32-bit Oracle database is supported on 32-bit Windows with standard x86 hardware, including Windows Vista. This paper describes the architecture of the Oracle database on Windows and how it differs from its counterparts on UNIX and Linux. ‘” 

Actually, it contains much more helpful information about oracle database on windows platform. And most of points listed are key to understand how oracle database works on windows. Here, I’d like to make a summary about those points.

• Thread Model (well-known windows distinction)
• Services – Oracle database is a windows service
• Scalability Enhancements – as many 23-node RAC deployed successfully on windows
• 4GB RAM Tuning (4GT) – Oracle support 4GB RAM Tuning since version 7.3.4
• Very Large Memory (VLM) – database instance can now have access up to 64GB of database buffer
• Large Page – good for case when the buffer cache is several gigabytes in size
• Affinity and Priority Settings – Oracle 11g introduces resetting of priority and affinity with registry setting ORACLE_PRIORITY AND ORACLE_AFFINITY to increase performance in certain cases. What oracle can do is to change job priority of CPU and assign process to particular CPU
• File I/O Enhancements – 64-bit File I/O means there are no 2GB or 4GB file size limitation and the limitation is significantly increased to 64GB

Just give myself a summary on this white paper and leave it as note.

Popularity: 3% [?]

This is a case study to solve exporting problem by using errorstack event. It’s original published at http://blog.csdn.net/kamus/archive/2004/12/21/224835.aspx in Chinese. If you are unable TO read Chinese, please try “Windows Live Translator” at bottom of my blog page.

The author figured out the exporting problem by setting errorstack event, which results a trace file in udump directory. The trace file clearly shows that the user who was running exporting has no privilege of “resumable”. It’s sort of DBA privilege, not for developer. But, if the activity happened on oracle 9i onwards, doing such job requires that privilege if
needed.

By the way, I’m trying to identify the description of “errorsstack” through Google searching and found the generic search didn’t return the result I want. Instead, the Google Custom Search on OraclePoint hit the result I want. This custom search does searching within around 20 proven good oracle-related websites.
Please see below for screenshots by using two search methods.

Normal Google Search:

OraclePoint Custom Search:

Popularity: 5% [?]