Re: OT: What about creating a repository of scripts of oracle-l

From: Jeremy Schneider <jeremy.schneider_at_ardentperf.com>
Date: Wed, 11 Jun 2014 06:56:44 -0500
Message-Id: <3A43BE86-014A-470E-AA53-46F2ABB16773_at_ardentperf.com>

How in the world did I forget Morgan's Library? I'll add that once I'm sitting down at a computer!

--
http://about.me/jeremy_schneider
Sent from my iPhone

> On Jun 10, 2014, at 6:52 PM, Juan Carlos Reyes Pacheco <jcdrpllist_at_gmail.com> wrote:
> 
> Very nice Jeremy :), 
> I was thinking in this idea but I'm not sure how reliable it is.
> The idea I was thinking some was about a shared repository, most sites has script in example http://psoug.org/browse.htm?cid=4, but there is not something more ordered.
> In different levels
> 1) common functions
> One example is a package having all numeric functions or date functions oracle hasn't.
> 2) Useful queries
> How to get the sql one session is executing and how to find their bindings
> 3) specific scripts for specific tasks
>   in example how to export in oracle 7 to Oracle 8i from linux to Oracle
> 4) The most important how to get easy to search and get Oracle people use them.
> 
> Maybe this could be only for oracle-l list, some one should have the task to update, but the amount of scripts and task in Oracle are too much.
> But at the same time the fact there are so much task, causes the need of having a library of script, wrote by people with experience.
> 
> In conclusion it is a dilemma :)
> 
> 
> 
> 2014-06-10 10:18 GMT-04:00 Jeremy Schneider <jeremy.schneider_at_ardentperf.com>:
>> I made a list of dba script collections from oracle-l a few months ago, the list was included here:
>> http://ardentperf.com/2014/01/02/novemberdecember-highlights/
>> 
>> That originated from an old thread on this list:
>> http://www.freelists.org/post/oracle-l/best-DBA-script-collection
>> 
>> It would be *great* to get some of this stuff on githhub, if only for the ease of forking and tweaking and merging.  (Tanel are you going to put your stuff on there sometime? <g>)
>> 
>> -Jeremy
>> 
>> 
>> --
>> http://about.me/jeremy_schneider
>> 
>> 
>>> On Mon, Jun 9, 2014 at 6:55 PM, Juan Carlos Reyes Pacheco <jcdrpllist_at_gmail.com> wrote:
>>> I'm not sure about maintenance, I think the idea is to store what you have by database release.
>>> 
>>> This is not only the script is the idea you can do that.
>>> 
>>> The other idea was to create a schema to install, having the basic functionality everyone needs like useres, security, instrumentation ,etc.
>>> 
>>> Thank you for answering.
>>> 
>>> 
>>> 2014-06-06 13:06 GMT-04:00 David Fitzjarrell <oratune_at_yahoo.com>:
>>> 


>>>> This sounds like a good idea in principle; the maintenance of these scripts might be an issue,  however.  

>>>> 

>>>> I do find it helpful to see scripts from other DBAs to see what they've done and see if I can find something I can use without re-inventing the wheel.

>>>>  

>>>> David Fitzjarrell

>>>> Principal author, "Oracle Exadata Survival Guide"

>>>> 

>>>> 

>>>> On Friday, June 6, 2014 10:19 AM, Jared Still <jkstill_at_gmail.com> wrote:

>>>> 

>>>> 

>>>> 

>>>> On Thu, Jun 5, 2014 at 4:45 PM, Juan Carlos Reyes Pacheco <jcdrpllist_at_gmail.com> wrote:

>>>> Of course someone must be on charge of updating. It will be a lot of work but I  think this can be very useful. because there will be stored by Oracle release and edition, and this can be very help full.

>>>> 

>>>> The current best choice for that would probably be a publicly accessible (default) github repo.

>>>> 

>>>> 

>>>> Jared Still

>>>> Certifiable Oracle DBA and Part Time Perl Evangelist

>>>> Sr Oracle DBA at Pythian

>>>> Pythian Blog http://www.pythian.com/blog/author/still/

>>>> Oracle Blog: http://jkstill.blogspot.com

>>>> Home Page: http://jaredstill.com

> 

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jun 11 2014 - 13:56:44 CEST