Re: OT: What about creating a repository of scripts of oracle-l
- From: Jeremy Schneider <jeremy.schneider@xxxxxxxxxxxxxx>
- To: Juan Carlos Reyes Pacheco <jcdrpllist@xxxxxxxxx>
- Date: Wed, 11 Jun 2014 06:56:44 -0500
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@xxxxxxxxx>
> 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@xxxxxxxxxxxxxx>:
>> 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:
>> //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@xxxxxxxxx> 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@xxxxxxxxx>:
>>>
>>>> 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@xxxxxxxxx> wrote:
>>>>
>>>>
>>>>
>>>> On Thu, Jun 5, 2014 at 4:45 PM, Juan Carlos Reyes Pacheco
>>>> <jcdrpllist@xxxxxxxxx> 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
>
Other related posts:
