Re: OT: What about creating a repository of scripts of oracle-l
Date: Tue, 10 Jun 2014 19:52:55 -0400
Message-ID: <CAGYrQytqMqw=msbcfcrbT07=i4TRPGPVo-Yyq6u8bpEZ8V8PMQ_at_mail.gmail.com>
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-lReceived on Wed Jun 11 2014 - 01:52:55 CEST