RE: Unix Max Extent Script

My favorite is when people go nutty checking every possible variable in their scripts before getting to the thing the script was actually written for i.e...

Check to see if database sid is valid, check to see if user name is valid, check to see if time zone on server is set, what is ambient temperature of server room, log every bit of meaninless info to a log file yada yada yada

-----Original Message-----
Sent: Thursday, January 16, 2003 3:40 PM To: Multiple recipients of list ORACLE-L

"Post, Ethan" wrote:
>
> Or perhaps this...
>
> Write a program that will manually allocate extents to each object until
you
> run out of space, then capture error and number of extents and write to a
> flat file using UTL_FILE package. Then export object, truncate table and
> import to recover the space you allocated during each test. Then use SQL
> loader to bring the data from the flat file into the database and write
> queries against the X$ constructs to see if you are approaching too many
> extents. Use a minimum of 5 .sh scripts and 8 control files to accomplish
> this task. From what I have seen this will qualify you for numerous jobs
as
> a Senior Oracle DBA.
>
> DISLAIMER: THE ABOVE WAS A JOKE BUT DOES REFLECT THE TYPES OF THINGS I
HAVE
> SEEN IN THE PAST.
>
> :)

Reminds me of something which I have seen which basically was a spool to a file of a SELECT * on the various views in the dictionary, wrapped into a shell script and followed by a number of greps ... Why use SELECT when you can grep with regular expressions ?

-- 
Regards,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriole.com

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: ListGuru_at_fatcity.com (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: Post, Ethan
  INET: Ethan.Post_at_ps.net

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: ListGuru_at_fatcity.com (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).