Re: Oracle vs Mysql
On Tue, 20 Jan 2004, Mladen Gogala wrote: > I have a book devoted to PostgresSQL at home. When I come home, I'll > post the information. O'Reilly has "Practical Postgresql", the full text of which is also available online: http://www.commandprompt.com/ppbook/ I know there are a couple of others floating around as well. But you're right, MySQL (sadly, IMO) has the mindshare. -- Dan ======== Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks 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).
Re: Spool to Excel File
If you're keen on Perl, the Spreadsheet-WriteExcel module is very handy: http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-0.42/ With that you could slurp data out via DBI, and then build a customized spreadsheet based on the data. But I'd agree with what others have said. Dumping to csv, or some other delimited format and then importing into Excel would probably be the easiest way to go. -- Dan On Mon, 19 Jan 2004, Mudhalvan, Moovarkku wrote: > Dear Friends, > > I am trying to send output from SQLPlus to Excel file. If any > one did the same before please let me know. > > Thank You > > Mudhalvan M.M > ======== Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks 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).
Re: Oracle vs Mysql
On Wed, 14 Jan 2004, eric king wrote: > I think he is talking about 100GB database. Can PostgreSQL and MySQL handle > that size? We used MySQL in some of the web projects, but it just stores > small set of operational data and later on those data are moved to Oracle as > a permenant store. For small set of data, MySQL is quite good, but it lacks > features such as foreign key constraints, triggers etc. I seem to recall reports of Monty (the creator of MySQL) supporting terabyte size databases with earlier versions of MySQL. Not sure what types of storage systems were used to achieve that, though. And to be fair, MySQL _does_ offer foreign key constraints (it used to not, though), but only (iirc) if you use the 'Innodb' table type. Now whether or not a database allowing some tables to have FK support and others not is a good proposition you'll have to judge for yourself. I still prefer Pg to MySQL. Fwiw, -- Dan ======== Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks 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).
Re: A free sql analysis tool
On Thu, 8 Jan 2004, Jared Still wrote: > interesting. > > you might want to hack it for time slices being in uS > on 9i, otherwise you get some rather interesting results. > > Jared > Ah. Yeah. Still using 8i here. *sigh*. I've updated the script to allow you to set a variable to determine the resolution. It'll also now try and figure out the Oracle version on its own if it can. I also tried the script on the sample 9i trace that comes with Oracle::Trace, and it croaks. Looks like I expect a PARSE line immediately following the END OF STMT line closing each PARSING IN CURSOR section. I'll have to fix that. Can anybody shed any light on why there are no PARSE lines after END OF STMT in the following two trace sections: = PARSING IN CURSOR #1 len=32 dep=0 uid=63 oct=42 lid=63 tim=1046586568955488 hv=4220954983 ad='55afb3bc' alter session set sql_trace true END OF STMT EXEC #1:c=16000,e=50842,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=1046586568924750 *** 2003-12-17 15:44:32.818 = PARSING IN CURSOR #1 len=24 dep=0 uid=63 oct=3 lid=63 tim=1046586594549056 hv=4113743782 ad='55b0eef4' select sysdate from dual END OF STMT dep=0,og=4,tim=1046586594548851 EXEC #1:c=3000,e=19436,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1046586594577246 FETCH #1:c=1000,e=1235,p=0,cr=3,cu=0,mis=0,r=1,dep=0,og=4,tim=1046586594583271 FETCH #1:c=0,e=13,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,tim=1046586594615367 *** 2003-12-17 15:44:50.253 Looking at Cary/Jeff's book, this is probably the answer: (page 104) "The kernel did not emit information about the parse of the ALTER SESSION command, because tracking wasn't enabled until after the parse had completed." That explains the first absence, but what about it not being there for the select statement? And what about that line beginning with "dep=0"...Is that normal? I looked through a cople of dozen of trace files I have (8i) and don't see any lines like that...Should I ignore such lines? Thanks for any input, -- Dan Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division ======== -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks 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).
Re: A free sql analysis tool
Doh! Nothing like Google telling the world about something you put on your website. :-). The script on the link given is something I put together after reading through Cary and Jeff's book. It's currently pretty simple, and doesn't (yet) handle recursive calls (patches are welcome :-). But for simpler traces, it does a decent job of letting you know where the time in your trace is going. I'd appreciate any feedback, bug reports, etc. I'd like to see a robust, featureful open-source 10046 trace analyzer developed. (Competition is a good thing, right Cary? :-). -- Dan On Thu, 8 Jan 2004, Hatzistavrou John wrote: > Dear All, > > > > I have found this Perl script that makes an analysis of 10046 SQL trace > > > > http://brainshed.com/software/ > > > > Kind Regards, > > > > > > Hatzistavrou Yannis > > > > -- Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division ======== -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks 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).
Progress of an index rebuild
Is there any way to check on the progress of an index rebuild? (Oracle 8i). I.e., it would be nice to get some indicator as to how far an index rebuild has gone, something like "75% done...". As a rough indicator, I've noticed when rebuilding/moving an index to a different tablespace, Oracle will allocate temporary extents in the tablespace to which the index is being moved. So, in theory, I suppose I could see how big (in terms of extents) the index is before moving it and use that as a rough indicator to see how far along the rebuild is by counting the number of temporary extents allocated in the new tablespace (taking into account the extent size in the new tablespace). Are there better ways to see the progress of an index rebuild? Thanks for any help. -- Dan ==== Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks 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).
RE: Finding the most actively DML'd table
Is there any significant overhead to leaving tables in monitoring mode? For example, if I left them as such for a few days or two, and then gathered the stats on them? Thanks again, -- Dan On Fri, 19 Dec 2003, Goulet, Dick wrote: > Alter table monitoring; > > then look in DBA_TAB_MODIFICATIONS > > Dick Goulet > Senior Oracle DBA > Oracle Certified 8i DBA > > -Original Message- > Sent: Friday, December 19, 2003 3:04 PM > To: Multiple recipients of list ORACLE-L > > > Is it possible to find how many DML operations have ocurred on a given table in > a given time period? I'd like to be able to rank the tables in a database based > on the number of DML actions performed on them in a given time period. It would > be interesting to see which are the 'hot spots' so to speak, and either a) tune > access to those tables accordingly, or b) put out the fires. > > Granted, this strays somewhat from the Millsapian/Holtian doctrine of focusing > on the user action with the largest business impact, but I still think it would > be interesting to see. > > Thanks for any help, > > -- Dan > >Daniel Hanks - Systems/Database Administrator >About Inc., Web Services Division > ==== > -- Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division ======== -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks 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).
Finding the most actively DML'd table
Is it possible to find how many DML operations have ocurred on a given table in a given time period? I'd like to be able to rank the tables in a database based on the number of DML actions performed on them in a given time period. It would be interesting to see which are the 'hot spots' so to speak, and either a) tune access to those tables accordingly, or b) put out the fires. Granted, this strays somewhat from the Millsapian/Holtian doctrine of focusing on the user action with the largest business impact, but I still think it would be interesting to see. Thanks for any help, -- Dan ==== Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks 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).
Re: Career Advice
On Wed, 17 Dec 2003, Viktor wrote:
> Let's take this topic into a more concrete scenario. New boss, company
> reorg, cross-training is enforced and now DBA'S's are going to be split
> into development groups. Need to learn Perl(looking forward to it
> actually!!!) and Java. Books, web sites, docs - all these material is
> great. But what if you're expected to learn fast and I can learn
> quickly, but still, do you guys have some advice on how can one
> "express" teach himself.
>
> Managing expectation is one thing I need to talk with boss about. Surely
> I would not't want to be overwhelmed with stuff at the beginning. But
> at the same time I am kinda excited about picking up on Java and Perl.
> The questions is what are the tricks and tips for learning on a fast
> track?
For Perl, hang out a lot at perlmonks.org. Ok, that's just one more thing for you to
read, but there's some good wisdom to be found there, some very smart Perl folks
there, akin to the caliber of Oracle gurus found in this group.
As for fast track, aint no learnin' like doin'. If I were in your situation, here's
what I would be doing:
Devour a good tutorial book, working through the examples. For Perl, O'Reilly's
Learning Perl. For Java, O'Reilly's Head First Java ("Don't let the pictures fool
you...") HFJ is really quite good. When I first saw it I thought, Oh no, O'Reilly has
stooped to the "for Dummies" level, but such was not the case at all. Emphasis here on
'working through the examples'. Also, as I mentioned above, hang out at 'guru' spots
like this list, or perlmonks.org. (Not sure where the real guru spots are for Java...)
Looking back on my own learning experience with Perl, I've read a lot of stuff, but it
wasn't until I really started getting my hands dirty with it on a couple of bigger
projects that it started to become more natural to me. If you have the free time and
resources, set up a home-lab with Apache/mod_perl and write a Perl application to do
something useful for you. Then write the same thing in Java (maybe with Tomcat).
HTH,
-- Dan
Daniel Hanks - Systems/Database Administrator
About Inc., Web Services Division
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Daniel Hanks
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).
Re: SQL*Plus with readline
On Wed, 17 Dec 2003, Carel-Jan Engel wrote: > > > On Tue, 16 Dec 2003, Carel-Jan Engel wrote: > >> Does this tool have the same 'functionality'? So, be carefull, or take > >> advantage of it ;-). > > > > Nope, the only history it stores are the commands you type once the > > program it execs is fired up. Now, if you connect scott/tiger from within > > sqlplus, you're on thin ice, but I usually specify which user/db I'm > > connecting to on the command-line and let SQL*Plus ask me for my password. > > So, what happens when SQL*Plus asks for your password? Doesn't that entry > get recorded as well? Nope. It appears the program is smart enough to ignore that line. -- Dan Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division ======== -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks 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).
Re: SQL*Plus with readline
On Tue, 16 Dec 2003, Carel-Jan Engel wrote: > Don't know this particular one, but ran into a shell on HP-UX with similar > capabilities. I was a developer those days, and the feature I liked most > was its capability to unveil sys/system passwords. Just get this shell > running and ask the DBA to do something from your terminal. After that, the > non-echoed password will be perfectly visible in command-line history > (after the DBA left the scene, of course). They never found out how we were > able to discover their passwords. I think it's now safe to spread the > knowledge around. > Heh. Yeah, there's something on Linux called 'script' that would do that. Basically spawns a shell and sends all the output from that session to a file. > Does this tool have the same 'functionality'? So, be carefull, or take > advantage of it ;-). Nope, the only history it stores are the commands you type once the program it execs is fired up. Now, if you connect scott/tiger from within sqlplus, you're on thin ice, but I usually specify which user/db I'm connecting to on the command-line and let SQL*Plus ask me for my password. -- Dan ==== Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division ==== -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks 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).
SQL*Plus with readline
I know there's a lot of folks who grumble about the spartan-ness of SQL*Plus, but the only real feature I wish it had was GNU readline capability for command history and editing. I've looked at some wrappers (yasql, gasql), as well as replacements (henplus, which is quite nice, actually), but today I found something that seems to do exactly what I really want--SQL*Plus behavior, augmented with readline support (So I can still do stuff like output formatting, spooling, etc., etc.,). Yes, I actually dig SQL*Plus, just wish it had readline. So today I found a little utility called uniread: http://sourceforge.net/projects/uniread/ It's a Perl program that "adds full readline support (command editing, history, etc.) to any existing interactive command-line program. Common examples are Oracle's sqlplus or jython. uniread will work on any POSIX platform with Perl." I tried it out with SQL*plus, and so far seems to work beautifully. Just thought I'd share. -- Dan ======== Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks 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).
RE: Performance tuning in complex environment
On Fri, 12 Dec 2003 [EMAIL PROTECTED] wrote: > I will try to get the output of v$system_event and will send it you guys. In the > mean time I have more question.. > > I am reading Cary's 'Optimizing Oracle Performance Book'. I am half way thru and > over looked rest of the chapters but didnt find an easy way to analyze thousands of > lines trace file. I am not very good in analyzing big trace files and wondering how > you guys analyze do that. Do you do it manually or use any tool to get summarized > report. I didnt see anything in that book. I am also planning to take class from > HotSos in Feb, 2004 in Seattle to see if that will help. I really appreciate all of > your input. I brewed up my own (still semi-baked) profiler in Perl. The tricky part is sorting out the recursive dependencies between db calls, but the rest is pretty straightforward, and Perl makes chewing up the trace file a snap. Currently it works 'well enough' for basic traces (w/o a lot of recursive calls) to give me a decent picture of what a session is doing. -- Dan ======== Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks 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).
Re: Fedora (pink hat)
On Fri, 12 Dec 2003, Mladen Gogala wrote: I haven't but I've got a machine up and running with Fedora (fedora.redhat.com for the person who asked previously) and would be willing to give an install a shot. Latest 9i I assume? Any particulars you'd like me to look for? > Has anyone actually installed Oracle on Fedora? I don't want to be the first one. > > Mladen Gogala > Oracle DBA > -- Dan ======== Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks 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).
Re: RE: Little competition
On Thu, 11 Dec 2003 [EMAIL PROTECTED] wrote: > oracle literature is really lacking in entry level docs anyway. The concepts > document is way too large to be digestable by someone new to the topic. > > What we really need is: > > simple SQL book for newbies - O'Reilly's Mastering Oracle SQL? (It starts out from the basics, and moves at a rapid pace, but it's very well done, IMO. 312 pages) > simple PL/SQL book for newbies - O'Reilly's Learning Oracle PL/SQL? (Not quite as imposing as Oracle PL/SQL Programming, and just a bit over 400 pages.) > Architecture book - O'Reilly's Oracle Essentials: Oracle9i, Oracle8i & Oracle8? (381 pages) > automatic features - Not sure...might be covered a bit in the previous title. I guess altogether that's pushing 1000 pages, but between those three books, there's probably a lot of good information. (I'm a major O'Reilly fan, if you couldn't tell...). Once they've digested these, Milsap & Holt would be next in the list of course ;-). > > Beginning Oracle Programming by Kyte, et all took a stab at this but they included > WAY too much information and some sections are unreadable(the pl/sql chapters are > terrible). > > Any newbie book should be 400 pages maximum. People get intimidated by large books > when they are new. For most of these 'simple' databases though, do people really need to get into PL/SQL? Or would SQL itself be enough for most of these tasks? If so you could drop the PL/SQL book off the list and you're down 400 pages. -- Dan Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division ======== -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks 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).
Re: Documenting databases
On Tue, 9 Dec 2003 [EMAIL PROTECTED] wrote: > Recently our database manager has asked us to do the unthinkable > document our databases! To make matters worse, and without our input, he > went ahead and created a schema and put it in an Access database (using > tables to make it look like a speadsheet). Either we use his idea or come > up with something else. > So, I thought I'd ask everyone on the list how you do it. Text files? > In a database (oracle, or other)? Spreadsheets? What are the pros and > cons? Etc > How about in each database itself. COMMENT ON TABLE|COLUMN tab|tab.col IS '...' comes to mind. It's simplistic, yes, but at least you don't have to remember where you put your documentation... HTH, -- Dan ==== Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks 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).
RE: PERL?
On Tue, 9 Dec 2003, Yong Huang wrote: > Speaking of Perl versus shell, Perl may still be quite primitive in supporting > two-way communication with an external program e.g. sqlplus. (I have an example > at www.stormloader.com/yonghuang/computer/OracleAndPerl.html#2waytosqlplus > using IPC::Open2). But I think a KornShell coprocess (not a here document) does > it nicely, i.e. piping a SQL command in and reading the result back, piping > another command in, reading again, without exiting your sqlplus session. If you > use Perl DBI (or the old OraPerl), Jared may know this but I'm not sure if you > can send any arbitary SQL command such as explain plan, shutdown... and read > its output. I think Perl with Expect.pm could likely do this without much effort. Expect allows you to interact with just about anything that uses a terminal. One fun case comes to mind. We have this LED sign (think large rectangular array of LEDs), with an undocumented serial interface protocol. All that came with it to control it was this old DOS program which would talk to the sign over a serial port. So I whipped up a Perl script which used Expect to interact with dosemu (a Linux DOS emulator) to run the program, which interacted with the sign, all running on Linux. Works pretty good. Expect.pm is also nice to interact with network hardware that offers telnet/shell command interfaces. Interacting with sqlplus via Expect.pm would be pretty easy as well, I would think. It basically works like this: - Spawn the program you want to interact with - Expect a particular regex of output from the spawned process - Act based on that output (send commands, run processes, annoy the NT admin with net send packets, etc) - Wash, rinse, repeat. -- Dan ==== Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks 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).
Oracle, GPG, PGP, Java...
Hi folks, I'm looking for some kind of library or such that would allow me to decrypt PGP/GnuPG encrypted content from SQL. Something allowing me to do something like this: SELECT decrypt([private key passed in from application code], field) from ... The current solution we have (in Perl) is something like this: - Select out the encrypted value - Exec() the gpg command-line utility, supplying the private key - Do something with the decrypoted data. We use the GnuPG.pm module, which is really just a wrapper around an exec() (yuk). I'd like to be able to eliminate all the exec madness, and use something a little closer to the database. I was glancing at Chapter 22 in Feuerstein's "Oracle PL/SQL Programming" (3rd. ed.), and thought it might not be too hard to find an existing Java library that can manage the decryption, and call the Java library from PL/SQL, as discussed in that chapter. Has anybody else done anything like this? Any Java libraries that can manage PGP decryption? I found one here: http://www.cryptix.org/products/openpgp/index.html#download but wanted to ask the list's opinion to see if there was anything else out there. I would assume I could also call native C libraries from PL/SQL via some voodoo which I haven't explored yet, and if needed would be open to something like that as well, but though Java might be a gentler path to start with. Thanks for any help, -- Dan ======== Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks 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).
Re: Oracle 9i on Fedora
On Wed, 3 Dec 2003, Joe Frohne wrote: > Hi, > > I am running into a problem installing Oracle 9i on Fedora. I get > the following error when starting the Oracle installer. > > error while loading shared libraries: libstdc++-libc6.1-1.so.2: > cannot open shared object file: No such file or directory > > I figured I would ask if anybody has worked through a solution > before I start pounding away on the same wheel. I haven't installed Oracle 9i on Fedora, but it appears the installer can't find the shared library indicated. Perhaps this will help: On my Fedora Core Release 1 laptop, /usr/lib/libstdc++-libc6.1-1.so.2 is a symlink that points to /usr/lib/libstdc++-2-libc6.1-1-2.9.0.so, which is installed by the compat-libstdc++-7.3-2.96.118 package. Make sure you have that installed (should come with Fedora) and see if that fixes the problem. rpm -q compat-libstdc++-7.3-2.96.118 should tell you whether it's installed or not. -- Dan > > Thanks much, > > -- > Joe Frohne > Rawson Oaks Consulting, Remote Oracle Admins > http://www.rawsonoaks.com > [EMAIL PROTECTED] or [EMAIL PROTECTED] > Oak Creek, WI, USA > > -- ==== Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division ==== -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks 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).
Re: Oracle websites
Make sure you also allow destination port 53 UDP/TCP for DNS requests. Even if you can talk HTTP[S] on ports 80 and 443, you won't get very far if you can't lookup an IP address for a domain name. -- Dan Hanks On Tue, 2 Dec 2003, Jonathan Lewis wrote: > > I've just bought a new Windows XP machine, > Got all the latest downloads on the O/S. > Installed a firewall. > Got Norton Anti-virus loaded and up to date. > > Which bit of code is stopping me from getting > to Metalink and the Oracle websites ? The > pages no longer exist according to my M/S IE. > > Regards > > Jonathan Lewis > http://www.jlcomp.demon.co.uk > > The educated person is not the person > who can answer the questions, but the > person who can question the answers -- T. Schick Jr > > > One-day tutorials: > http://www.jlcomp.demon.co.uk/tutorial.html > > > Three-day seminar: > see http://www.jlcomp.demon.co.uk/seminar.html > > > The Co-operative Oracle Users' FAQ > http://www.jlcomp.demon.co.uk/faq/ind_faq.html > > -- Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division ======== -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks 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).
Re: Where are my trace files going?
Here's something that may or may not be happening. It's something I ran into when working with traces. Have you mv'd or rm'd any of your trace files? The reason I ask, is because while doing some tracing of a certain session on Solaris recently, I began the tracing, turned it off, and then mv'd the file somewhere's so I could analyze it. As this was a long-running session (an XML gateway process), I wanted to try and trace another run, so I turned tracing back on, expecting Oracle to generate a new trace file for me, but no such luck. After a few frustrating hours of investigation, I finally realized what was happening. The OS process keeps the filehandle of the trace file open, even after you tell Oracle to turn off tracing (or at least that's what I gathered), so once I mv'd the file, all bets were off as to where Oracle would write to once I started tracing the process again. A combination of truss'ing the process and inspecting /proc info told me that Oracle had the root! dir of the filesystem on which the trace file had been now open as the trace filehandle, which was very confusing. It wasn't until I restarted the session, and got a new OS pid, that I got another trace file generated. At any rate, this may or may not be what you're up against, but from what I found, if you mv/rm the trace file associated with a given PID, you'll probably need to get a new Oracle session / OS pid going to get a new tracefile. HTH, -- Dan Hanks On Mon, 1 Dec 2003, Thomas A. La Porte wrote: > Environment: Oracle 8.1.7.4 on RedHat AS2.1 > > > I'm in the process of preparing to convert a 90M row table from > heap-organized to index organized. I think I've pretty well got a > formula for doing the actual table conversion. It's a very basic > table, four NUMBER columns, with a PK on the first two. I'm > planning to extract the data to a sorted, comma-delimited flat > file, then using SQL Loader with direct path to do the import. > On a 2.8GHz 2-way Linux box, that process is taking me about 30 > minutes. > > Building two additional indexes on that table after the data has > been loaded is taking anywhere from 30 minutes up to three hours. > I'm trying to determine why there is a wide variation in the > performance of the index build operation by tracing the session, > however, I can't seem to generate a trace file! I can run the > 'alter session' to get a 100046 trace, but no file is created in > my user_dump_dest (nor, for that matter, is it being created in > my background_dump_dest, core_dump_dest, or any place else on the > local machine as best as I can tell). > > I've run these traces before in other instances on the same > machine, and I don't believe that there is a file ownership or > permissions problem anywhere in the mix. Does anyone have any > thoughts on where my trace file is going, if it is going > anywhere? Or how to determine why I'm not generating a trace > file? > > Any thoughts or pointers are greatly appreciated. > > -- Tom > > Thomas A. La Porte, DreamWorks SKG > <mailto:[EMAIL PROTECTED]> > > > -- Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks 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).
Re: pl/sql question and owa_pattern question
d a way to speed it up. I don't have experiience in > > > owa_pattern, but I thought there might be a way to do it here: > > > > > > > > > str := "This will be a long string with length upto 300 characters, it > > > may contain some invisible characters'; > > > newstr := str; > > > pos := 1; > > > while pos != 0 loop > > > pos := owa_pattern.amatch(newstr, 1, '\W');-- how can I mask out > > > these '-.,/<*>_' ??? > > > word := substr(newstr, 1, pos-1); > > > -- do some processing to variable word ! > > > if pos != 0 then > > > newstr := substr(newstr, pos+1); > > > end if; > > > end loop; > > > -- > > > > > > My simple tests showed that owa_pattern call is much slower than direct > > > string manupilation. But I would like to try it in this case if I could > > > easily get the "wrods" from the string. Any suggestions? > > > > > > TIA. > > > > > > Guang > > > > > > > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > -- > > > Author: Guang Mei > > > 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). > > > > > > > -- > > Mladen Gogala > > Oracle DBA > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Mladen Gogala > > 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: Guang Mei > > 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). > > > > Mladen Gogala > Oracle DBA > > > > Note: > This message is for the named person's use only. It may contain confidential, > proprietary or legally privileged information. No confidentiality or privilege is > waived or lost by any mistransmission. If you receive this message in error, please > immediately delete it and all copies of it from your system, destroy any hard copies > of it and notify the sender. You must not, directly or indirectly, use, disclose, > distribute, print, or copy any part of this message if you are not the intended > recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to > monitor all e-mail communications through its networks. > Any views expressed in this message are those of the individual sender, except where > the message states otherwise and the sender is authorized to state them to be the > views of any such entity. > > -- Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks 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).
Re: RE: Any articles/books that take relational theory and make it
Well, Pascal has this to say about it: http://www.dbdebunk.com/page/page/622521.htm (This also links to some comments by Date on some articles by Ralph Kimball). What it comes down to for me is this, the relational model provides a way (by being based on set theory and predicate logic) to ensure that your query results are mathematically sound, and thus you can trust your data. To paraphrase Pascal, a database is simply a set of axioms, which we can use (via queries) to form proofs about various aspects of our enterprise. If we ensure our data is normalized, and ensure that appropriate constraints are in place, we can trust that the axioms we store in the database are valid, and that our 'proofs' are also accurate, and ultiumately we can trust the information we are getting out of the database. Again, I'd recommend Pascal's book, 'Practical issues...' as he explains these things more clearly than I can. Granted our bosses/managers/clients, etc., may not be interested in hearing about normalization and predicate logic, but I think they do put value in having accurate data with which to pursure business interests. Being aware of the theoretical issues associated with the relational model can only help in our position as 'guardians of the data'. Fwiw, -- Dan On Thu, 20 Nov 2003 [EMAIL PROTECTED] wrote: > how does dimensional modelling used by datawarehousing fit into relational theory? > > > > From: Daniel Hanks <[EMAIL PROTECTED]> > > Date: 2003/11/19 Wed PM 04:35:03 EST > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > Subject: RE: Any articles/books that take relational theory and make it > > > > Agreed. And I think you'll admit it's better to be familiar with and aware of the > > theory, even if current db products don't live up to the model 100%, so you know > > to bring up the kinds of issues you mention in the first place. In that sense, I > > think the knowledge to be gained from Date, Darwen, Pascal, etc., can be very > > practical. > > > > -- Dan > > > > On Wed, 19 Nov 2003, Niall Litchfield wrote: > > > > > I obviously can't speak for the list, but I find Fabian Pascal to be > > > very interesting, but quite academic. What I *think* that I mean by this > > > is that a lot of what he says seems to make theoretical sense, but I'm > > > unsure how applicable it is to practice. IOW the general feel that I get > > > from Fabian (and indeed Date) is that if something doesn't meet > > > relational theory then it is flawed. This may well be a good default > > > position to have, but I'm unprepared to say to folk who pay my wages > > > 'sorry your data model isn't in 3NF' or 'you shall not use a > > > materialized view'. I *will* quite happily say 'so how will you ensure > > > data integrity?' 'what happens if another program uses the same data' or > > > 'why did you use computed summaries?' > > > > > > Niall > > > > -Original Message- > > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > > > > Behalf Of Daniel Hanks > > > > Sent: 19 November 2003 16:25 > > > > To: Multiple recipients of list ORACLE-L > > > > Subject: Re: Any articles/books that take relational theory > > > > and make it > > > > > > > > > > > > On Wed, 19 Nov 2003 [EMAIL PROTECTED] wrote: > > > > > > > > > I swapped emails with a member of the list and Im having trouble > > > > > seeing how you can take 3NF, BCNF, etc... and turn that into DBA > > > > > speak. One of the guys told me that BCNF essentially means > > > > you have a > > > > > key that you can put a unique constraint on. Well that > > > > makes this much > > > > > easier to understand. > > > > > > > > > > > > > Hrm, I thought a key, by definition, implied a unique constraint... > > > > > > > > > All my theory books just discuss theory. Anyone know some > > > > that split > > > > > the difference. IE, not Codd, not CJ Date, Not the academic > > > > textbooks. > > > > > > > > > > > > > I'm not sure what the opinion on Fabian Pascal is here on the > > > > list, but I found his "Practical issues in Database > > > > Management" to be very good. It's subtitled "A reference for > > > > the thinkin
RE: Any articles/books that take relational theory and make it
Agreed. And I think you'll admit it's better to be familiar with and aware of the theory, even if current db products don't live up to the model 100%, so you know to bring up the kinds of issues you mention in the first place. In that sense, I think the knowledge to be gained from Date, Darwen, Pascal, etc., can be very practical. -- Dan On Wed, 19 Nov 2003, Niall Litchfield wrote: > I obviously can't speak for the list, but I find Fabian Pascal to be > very interesting, but quite academic. What I *think* that I mean by this > is that a lot of what he says seems to make theoretical sense, but I'm > unsure how applicable it is to practice. IOW the general feel that I get > from Fabian (and indeed Date) is that if something doesn't meet > relational theory then it is flawed. This may well be a good default > position to have, but I'm unprepared to say to folk who pay my wages > 'sorry your data model isn't in 3NF' or 'you shall not use a > materialized view'. I *will* quite happily say 'so how will you ensure > data integrity?' 'what happens if another program uses the same data' or > 'why did you use computed summaries?' > > Niall > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > > Behalf Of Daniel Hanks > > Sent: 19 November 2003 16:25 > > To: Multiple recipients of list ORACLE-L > > Subject: Re: Any articles/books that take relational theory > > and make it > > > > > > On Wed, 19 Nov 2003 [EMAIL PROTECTED] wrote: > > > > > I swapped emails with a member of the list and Im having trouble > > > seeing how you can take 3NF, BCNF, etc... and turn that into DBA > > > speak. One of the guys told me that BCNF essentially means > > you have a > > > key that you can put a unique constraint on. Well that > > makes this much > > > easier to understand. > > > > > > > Hrm, I thought a key, by definition, implied a unique constraint... > > > > > All my theory books just discuss theory. Anyone know some > > that split > > > the difference. IE, not Codd, not CJ Date, Not the academic > > textbooks. > > > > > > > I'm not sure what the opinion on Fabian Pascal is here on the > > list, but I found his "Practical issues in Database > > Management" to be very good. It's subtitled "A reference for > > the thinking practitioner". It's not a textbook, but it does > > make you use your brain a bit. It might be what you're > > looking for. It has helped to clarify the relational model > > for me, but might put some people off as it's critical > > (without naming specific products) of most current > > implementations of 'relational' databases. > > > > > Thanks. > > > > > > > > > > -- Dan > > == > > == > >Daniel Hanks - Systems/Database Administrator > >About Inc., Web Services Division > > == > > == > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Daniel Hanks > > 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). > > > > -- Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks 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).
Re: Any articles/books that take relational theory and make it
On Wed, 19 Nov 2003 [EMAIL PROTECTED] wrote: > I swapped emails with a member of the list and Im having trouble seeing how you can > take 3NF, BCNF, etc... and turn that into DBA speak. One of the guys told me that > BCNF essentially means you have a key that you can put a unique constraint on. Well > that makes this much easier to understand. > Hrm, I thought a key, by definition, implied a unique constraint... > All my theory books just discuss theory. Anyone know some that split the difference. > IE, not Codd, not CJ Date, Not the academic textbooks. > I'm not sure what the opinion on Fabian Pascal is here on the list, but I found his "Practical issues in Database Management" to be very good. It's subtitled "A reference for the thinking practitioner". It's not a textbook, but it does make you use your brain a bit. It might be what you're looking for. It has helped to clarify the relational model for me, but might put some people off as it's critical (without naming specific products) of most current implementations of 'relational' databases. > Thanks. > > -- Dan Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division ==== -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks 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).
Re: Oracle docs and permanent kernel settings
any mistransmission. If you receive this message in error, please > immediately delete it and all copies of it from your system, destroy any hard copies > of it and notify the sender. You must not, directly or indirectly, use, disclose, > distribute, print, or copy any part of this message if you are not the intended > recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to > monitor all e-mail communications through its networks. > Any views expressed in this message are those of the individual sender, except where > the message states otherwise and the sender is authorized to state them to be the > views of any such entity. > > FWIW, -- Dan Hanks Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks 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).
Re: Oracle docs and permanent kernel settings
On Tue, 18 Nov 2003, Jesse, Rich wrote: > Hey all, > > Just dumped my primary Windohs desktop at work in favor of Gentoo (yay!), > and am installing O9iR2. As I'm browsing thru the Install docs as I am want > to do prior to installs, I see that they recommend using: > > echo "somevalue" >/proc/sys/kernel/someparm > > ...in the startup to set kernel values. Anyone know why Oracle wouldn't > recommend just populating /etc/sysctl.conf (or /etc/sysconfig/* or whatever > is available for your flavor of Linux). I used this on the RH installs I've > done, and it works well. The echo method is a hack that just doesn't seem > to be good practice to me. I'm not sure why Oracle recommends such in their docs, as such changes aren't persistent through a reboot. The sysctl command which is used to process /etc/sysctl.conf does essentially the same thing as "echo somevalue > /proc/sys/...", so from a functional standpoint it's the same operation, but with sysctl you get the benefit of not having to worry about your changes disappearing after a reboot. You would think that with 'official' support for Oracle on RedHat, the docs would recommend setting values in /etc/sysctl.conf, instead. -- Dan Hanks > > Just wondering... > > Rich > > [stoopid signatures not in MS sExchange profile] > -- Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division ======== -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks 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).
Re: Geometric mean
On Thu, 13 Nov 2003, Robson, Peter wrote: > > Has anyone any code (SQL, PL/SQL) that will permit the calculation of the > geometric mean of 'n' values? > > appreciated... > > peter > edinburgh > > > ps - yes I know Perl will do it, but that is not the answer... But possibly could be an answer using extproc_perl. But that may or may not be a satisfactory solution, depending on your needs. I'd be curious (as one new to the list) if anyone else is using extproc_perl? It's been useful for us to provide a regex capability to queries on occasion. Also to allow querying of MySQL databases from Oracle. -- Dan Hanks ======== Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks 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).
