to this day i wish I'd kept that trace file.
joe
[EMAIL PROTECTED] wrote:
SQL.BSQ file that creates the data dictionary is neat. Its good for getting into arguments. Since alot of DBAs like to correct you when you say 'v$ view', they insist 'v$ table', you open sql.bsq and its 'create or replace view v_$'
There is alot of neat stuff in sql.bsq. Notes that were placed in years ago. Nothing insanely useful(though I havent exactly scoured it).
The Standard package in sql.bsq is interesting because you see how oracle overloads the operatings like 'is not null'. Fairly similiar to how its done in 'C'.
catalog scripts for creating the data dictionary views were boring and already well documented. I didnt find anything in there that I cant get off of the data dictionary doc on OTN or out of the source in DBA_VIEWS.
Catproc files were somewhat useful. Though most of what is in the headers are on OTN. I heard that before Oracle 7.0, Oracle didnt encrypt the PL/SQL packages and you could actually read all the source code.
anyone have a copy of that source code lying around? Id like a copy.
From: DENNIS WILLIAMS <[EMAIL PROTECTED]> Date: 2003/09/05 Fri AM 11:24:29 EDT To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: Oracle Script Documentation
Jay Here is your chance to join the big league and become an expert in your
own area. One thing I've noticed in tracing the scripts is that many of the
scripts call each other. Something like catproc must call dozens of the
other scripts. Not that much need to understand every low-level script. But
then there are probably some overlooked gems that we aren't aware of.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message----- Sent: Friday, September 05, 2003 9:45 AM To: Multiple recipients of list ORACLE-L
Hi Jay,
I know this is obvious but each script generally has a short description at the top of each file. Some of these are pretty short one liners bear in mind but it is a start!.
If you do find a complete list let us know it sounds like it could be useful to know where a list for the future.
hth
kind regards
Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
