Solaris OS Solutions to 32-bit stdio's 256 File Descriptors Limitation

.. technical article is up on Sun Developer Network (SDN) web site at http://developers.sun.com/solaris/articles/stdio_256.html. In order to comply with the SDN guidelines, the copy-editor at Sun made quite a number of changes to the original draft. But I still like the original draft "as is". I'm reproducing the draft that I submitted, in this blog post.Sun Solaris Solution to 32-bit stdio's 256 File Descriptors LimitationThe following discussion...

Read More

Oracle HOW-TO: Get the Table/View Definition, Indexed Columns

Q#1: Given a view name, how do we get the definition of the view? i.e., how to get the corresponding SQL statement stored in the database in the system tablespace?A: Query the TEXT column of table DBA_VIEWS.Syntax:SQL> set long 10000SQL> select TEXT 2 FROM DBA_VIEWS 3 where OWNER = '<owner_name>' 4 and VIEW_NAME = '<view_name>';Here is an example:% sqlplus fs890/fs890@fs890SQL> create table PERSON ( 2 SSN VARCHAR2(12),...

Read More

Patches to get extendedFILE solution on Solaris 10

The issue is discussed in the blog post Solaris: Workaround to stdio's 255 open file descriptors limitation.If the system is running any existing major customer releases of Solaris 10 i.e., Solaris 10 3/05 through Solaris 10 11/06, extended FILE facility can be installed on these systems by applying the kernel patch, 125100-04 or later & libc patch, 120473-05 or later.Systems running Solaris Express (SX) or any OpenSolaris distribution after...

Read More