Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: db file sequential read [WAS:wait event puzzler]

RE: db file sequential read [WAS:wait event puzzler]

From: Jamadagni, Rajendra <>
Date: Fri, 13 Jun 2003 11:37:04 -0700
Message-ID: <>

A Wild guess ... are those people who want more than thirtycharacternamesfortablecolumn by any chance used to work with JAVA or VB?

One of our developer complained here that the limit of 30 characters on procedure name was too small (he had landed in an Oracle shop from MS shop), so we gently hinted to him that "a column name is a column name, we have Microsoft Word installed to write position papers and technical memos" ... he was a good sport though .. that helped.


Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !

-----Original Message-----

From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]] Sent: Friday, June 13, 2003 2:40 PM
To: Multiple recipients of list ORACLE-L Subject: RE: db file sequential read [WAS:wait event puzzler]

1 - has been shown to be impossible.
2 - Most people on the list disagree with this. Even if someone wants to try it for testing it won't help you in production.

3 - Was a JOKE!
4 - True.
5 - True.
6 - True.
7 - True. Dangerous advice should always be accompanied by a ton of caveats.
8 - was a JOKE!
9 - good advice. Read The Fine Manual.

Summary - updating the data dictionary directly means that Oracle will not support your database. Unless you're not paying for any support, nothing you do is worth that risk.

Why is the limit 30 characters? It has always been that way. Who decided 30 characters when Oracle was first built? The answer is probably lost in the mists of time. Why is it still 30 characters? I am guessing because changing that size would cause millions of lines of code (Oracle software, third-party software, customer homegrown software) to have to be modified and there is not enough demand for Oracle to make that change.

*********************************************************************This e-mail 
message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank
Received on Fri Jun 13 2003 - 13:37:04 CDT

Original text of this message