Hit Ratio

2003-12-19 Thread jkstill
-- -- - --- --- JKSTILL15 jkstill 24548 252 18 1 92.86 SAP_MV 7 jkstill 24073 925,9381,074,497 50,011 -16.04 2 rows selected. ;) -- Please see the official ORACLE-L

Re: Triggers - How expensive when set on heavily loaded tables ?

2003-07-24 Thread jkstill
Brian, Were those row level or statement level triggers? Jared On Wed, 23 Jul 2003 [EMAIL PROTECTED] wrote: I did some trigger timings about a year ago on v8.1.7.4. I did the testing using a trigger with only 1 statement in it, and that statements was null;. I found that my transaction

Re: Union quries: INTERSECT, MINUS, etc

2003-07-24 Thread jkstill
Jonathan, I've used MINUS heavily in sql scripts and pl/sql to determine the differences in schemas: both structure and data. Of interest to DBA's and developers, and least when I did it it was for the developers. Jared On Thu, 24 Jul 2003, Jonathan Gennick wrote: I'm doing research for

RMAN/Veritas duplicate db article

2003-07-23 Thread jkstill
: http://www.cybcon.com/~jkstill/Alternate%20Client%20Restore%20With%20Veritas%20NetBackup%20and%20Oracle%20RMAN.doc It's kinda rough, so suggestions, comments, criticisms are welcome. Thanks, Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL

Joys of having an intern

2002-05-10 Thread jkstill
I hope you will all forgive this slightly off topic post. You may find it a bit interesting. There's also a punch line for all the codgers among us. ;) Jared - Joys of having an intern If you have ever had the privilege of having a fresh faced intern at

Re: Oracle start/stop scripts on AIX

2001-04-05 Thread jkstill
I have worked on 4.3.3 AIX boxes recently, and none had /etc/rc.d installed. Jared On Wed, 4 Apr 2001, Ram Kumar wrote: AIX had started using the /etc/rc.d setup since 4.3.3. I think AIX 5L may incorporate most of the UNIX/LINUX generic features missing from its previous versions. Ram

Re: Linux ver and Oracle

2001-04-04 Thread jkstill
I'll be installing Suse 7.1 with Oracle this week. I'll let ya'll know how it goes. Jared On Mon, 2 Apr 2001, Ron Rogers wrote: List, I am playing with the idea of loading my PC with Linux and Oracle for test purposes( We have to migrate from Novell in the near future). What have you

Re: Recovery Manager vs. SQL Back Track

2001-04-04 Thread jkstill
SQL-Backtrack was a good product at one time. In theory it still is. Here's the problem though. When Data Tools sold SQL-Backtrack to BMC, it seems that anyone that knew anything about the product left. There is no one in tech support that can help you beyond the menu items. There is no one

Re: Re: bFILES Recovery Manager

2001-04-04 Thread jkstill
On 4 Apr 2001, Cyril Thankappan wrote: Hello! Does recovery MANAGER support bfiles? if so any idea when Oracle plans to support them? THanx I don't know, but I doubt it. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED]

RE: Metalink Again

2001-04-04 Thread jkstill
On Wed, 4 Apr 2001, Kevin Kostyszyn wrote: Suprisingly, I just logged on and it took only a second. Amazing!! They must have gotten that other Tandy computer running again. Ahem... As a former Tandy Computer Repair Technician, I take umbrage at that remark. And scotch, beer, ibuprofen

Re: Unix memory used

2001-04-04 Thread jkstill
Mike, The amount of memory available as shown by 'top' is of little use, as Solaris gobbles up nearly all of it leaving little free, regardless of how much you have. Use vmstat to determine the paging rate. I can't think of a good number at the moment, and my Solaris books are currently

Re: Oracle start/stop scripts on AIX

2001-04-02 Thread jkstill
On Mon, 2 Apr 2001, Gene Sais wrote: Who said unix is unix, not me. I have worked w/ HPUX, Digital Unix, Linux, and Solaris. All of these support some form of automatic shutdown/startup scripts found in rc.d directorires, etc. I can not believe IBM AIX uses the /etc/inittab for the

Re: How to use Perl / DBI on NT

2001-04-02 Thread jkstill
On Mon, 2 Apr 2001, Babette wrote: I typically use Apache with mod_perl, perl perl DBD, perl DBI on Linux. I would like to set-up a similar environment on my laptop for a demo I am giving. Has anyone set this up? If so, what is the best approach to do so Oracle 9iAS (does it even come

Re: *.dbf, *.ctl, redo*.log access rite

2001-04-02 Thread jkstill
On Sun, 1 Apr 2001, Sinardy Xing wrote: Hi guys, Can you tell me what is your access rite for those files in unix solaris 7 oracle 8.1.6, my current access rite are: rwxrwxr-x for all of them. Sinardy Regardless of what they are, they should be set to 0640. This allows r/w for Oracle,

Re: Oracle start/stop scripts on AIX

2001-04-02 Thread jkstill
On Mon, 2 Apr 2001, Raghu Kota wrote: AIX has same startup and shudwon scripts like Solaris. No, it doesn't. On Solaris you will find the familiar /etc/rc.d setup. AIX does not use this, but rather relies exclusively on inittab and a single klunky shell script. Jared -- Please see the

RE: Solaris ODBC drivers

2001-03-30 Thread jkstill
On Thu, 29 Mar 2001, Vadim Gorbounov wrote: Hi Bill, You may check www.merant.com. This will cost something, but as far as I know there is no free ODBC drivers on Solaris. rgds vadim gorbounov Oracle DBA There are open source unix ODBC drivers available at: www.unixodbc.org

Re: Source Code about Java Classes

2001-03-28 Thread jkstill
Sergio, It doesn't seem to likely that Oracle will provide the source for their products. Jraed Who is this guy? Can't even spell his own name... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services--

RE: Why is there air?

2001-03-26 Thread jkstill
On Thu, 22 Mar 2001, Maser, Donna (SEA) wrote: Jared, I am still waiting/hoping for an answer... Why IS there air? - Donna It's to dilute the output from grain eating methane dispensers. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET:

Re: do you use SQLJ ?

2001-03-26 Thread jkstill
Oracle has repeatedly stated that PL/SQL is not going away. One good reason for this is that PL/SQL is highly optimized for DML in the database. Java is not, and will not likely ever be as efficient PL/SQL for manipulating large amounts of data. At least IMO. OOP has many benefits, but large

Re: Source Code about Java Classes

2001-03-26 Thread jkstill
Sergio, It doesn't seem to likely that Oracle will provide the source for their products. Jraed On Mon, 26 Mar 2001, Sergio Boix Moriano wrote: Hi all, Does anyody knows how to find the source code about Forms java classes (oracle.forms.ui), i've looked for it at OTN, Technet

RE: EMC TimeFinder, and EMC TimeFinder vs Hot Standby

2001-03-22 Thread jkstill
BCV = Business Continuation Volume Geez, this was obviously the work of some marketing drone so it would sound impressive to clueless clients. I know the concept, but have never heard it called by his acronym. Thanks all fro the explanations. Jared On Thu, 22 Mar 2001, Tim Sawmiller wrote:

Re: Why is there air?

2001-03-22 Thread jkstill
On Thu, 22 Mar 2001 [EMAIL PROTECTED] wrote: Maybe I wasn't clear? And I've always considered my articulate. :) ^^ Guess my assumption was incorrect. :) Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City

Re: Find special characters in the database

2001-03-21 Thread jkstill
On Wed, 21 Mar 2001, Shakeel Qureshi wrote: Hi Jared, Its Oracle 8i and just need to do this operation on a small table, using SQL and PL/SQL. I would appreciate if you could guide me a. As to how to find out the special characters b. Change values Looking forward to your help.

Why is there air?

2001-03-21 Thread jkstill
Subject line got your attention didn't it? Some may recognize that line from a Bill Cosby routine. I thought it might be an attention grabber. -- the real purpose of this post Lest we all forget the purpose of the this forum and others like it, I am posting some comments that were sent to

Re: dbms_obfuscation package

2001-03-21 Thread jkstill
with DBMS_OBFUSCATION_TOOLKIT. Ahem... Yours truly has an article on Oracle and encryption which includes using DBMS_OBFUSCATION_TOOLKIT. Complete with code. www.cybcon.com/~jkstill/util Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat

RE: EMC TimeFinder, and EMC TimeFinder vs Hot Standby

2001-03-21 Thread jkstill
Ok, does someone one to define SRDF and BCV for those of us that don't have any idea what you're talking about? Jared On Wed, 21 Mar 2001, Koivu, Lisa wrote: Hi Yosi, how are you? I can't exactly clarify your fish vs. potatoes, er, timefinder vs. SRDF question but I can tell you that we

Re: Insert without telling column names

2001-03-20 Thread jkstill
On Tue, 20 Mar 2001 [EMAIL PROTECTED] wrote: Hallo, How can I create an insert statement without telling all the names of the columns? Give an example, please. Roland Sköldblom Roland, You can omit column names only if you are inserting into all columns of the table, in the same order

Re: your mail

2001-03-20 Thread jkstill
On Tue, 20 Mar 2001, Ginger Mejia wrote: IS IT POSSIBLE TO LIST JOB OPPORTUNITIES TO THIS LIST IF ONE BECOMES AVAILABLE? -- Yes, but please don't abuse the privilege. Don't post a position more than once a week; if you have several, please send them in a single message. And thanks for

Re: Find special characters in the database

2001-03-20 Thread jkstill
First off, do you have Perl and DBD::Oracle or Java? Those would be the preferred methods to do something like this, in this order. PL/SQL sould be a distant third place as it is not very fast for this kind of wholesale string operation. PL/SQL may be a good choice though, if your requirements

Re: Free Oracle DBA tests on the web

2001-03-20 Thread jkstill
Audrey, Try researching and answering at least one post a day on this forum. That will get you further than training tests. :) Jared On Tue, 20 Mar 2001, andrey wrote: Hi DBAs ! I'm looking for some FREE Oracle DBA / developer resources on the web : self-tests , OCP preparations

Re: Free Oracle DBA tests on the web

2001-03-20 Thread jkstill
Sorry, I misspelled your name as 'Audrey' in my previous reply. Jared On Tue, 20 Mar 2001, andrey wrote: Hi DBAs ! I'm looking for some FREE Oracle DBA / developer resources on the web : self-tests , OCP preparations materials , articles , books , etc ... Please share your resources !

RE: Insert without telling column names

2001-03-20 Thread jkstill
Well of course it's a bad idea, I thought that was obvious. ;) Jared On Tue, 20 Mar 2001, Jacques Kilchoer wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] How can I create an insert statement without telling all the names of the columns? Give

Re: SUN vs. HP

2001-03-20 Thread jkstill
You will get patches and new versions of software sooner on Solaris than you will on HP. Jared On Tue, 20 Mar 2001, Alex Apostolopoulos wrote: Hi, we are currently in the process of evaluating a high availiability cluster for our production database. The final two solutions are:

Re: sqlplus hanging on exit

2001-03-20 Thread jkstill
Louis, Yep, old bug. :) I seem to recall that removing the files is enough; best check on MetaLink though. Do you have access? I can find it for you tomorrow if you don't. ( gotta get to bed now, the eyelids won't stay up :) Jared On Wed, 21 Mar 2001, Louis Avrami wrote: Jared,

RE: FK Constraints

2001-03-19 Thread jkstill
I'll have to disagree with this. I've seen to many programs break when the constraints were enabled. Developers generally don't have a clue how to maintain integrity in the application data. This is not to impugn all developers, just about 90% of them. The database knows how to enforce

RE: FK Constraints

2001-03-19 Thread jkstill
Joins do not require the presence of FK's in order to work properly. Jared On Mon, 19 Mar 2001 [EMAIL PROTECTED] wrote: Hi, I'm a beginner too, but without a table FK (relation) how you make a join statements ? Do you normalize your tables ? The relation model is concerned with logical

Re: FK Constraints (fwd)

2001-03-19 Thread jkstill
-- Forwarded message -- Date: Mon, 19 Mar 2001 18:29:42 -0800 (PST) To: Rodd Holman [EMAIL PROTECTED] Rodd, I understand completely. Third party apps often do their best to complicate a DBA's life. Sorry for jumping in with both feet. :) Jared On Mon, 19 Mar 2001, Rodd

RE: FK Constraints

2001-03-19 Thread jkstill
OK, let me rephrase. The DBA is not responsible for the *content* of the data. The DBA *is* responsible for the safety, recoverability and integrity ( where possible ) of the data. The DBA is ont resposible for the data's content, except where the DBA is responsible for constraints that place

Re: Offtopic:DBA Math, Beer and OEM

2001-03-16 Thread jkstill
On Fri, 16 Mar 2001, Dave Morgan wrote: Create a reporting schema, install perl DBI, (not on the db server, on a client somewhere) gnu-plot or a similar graphing package (anyone know a good perl one?) and within a week you have graphical historical reports. Check out DBD::Chart

RE: RE: change unix user when running external procedure

2001-03-16 Thread jkstill
On Fri, 16 Mar 2001, John Dunn wrote: Apparently the way to do this is to set up a seperate external procedure listener to run as the appropriate user. Unfortunately utl_file still seems to run as oracle John John, If you are having problems with access to files created by Oracle via

Re: sqlplus hanging on exit

2001-03-16 Thread jkstill
You may want to check v$session_wait while the session is exiting and see if it's waiting on a resource in the the database. If that doesn't reveal anything, you may want to try truss on the server process and see what is going on there. ( assuming you aren't using MTS ) Jared On Fri, 16 Mar

Re:RE: RE: Oracle DBA evolution path - please share your opi

2001-03-16 Thread jkstill
Dick, We should formalize this rant and post it and a web page and publicize it. Almost without exception, databases for 3rd party software are designed in the dark by drunken monkeys. In the past I've toyed with the idea of offering a service of ERD and database design to 3rd party

Re: Offtopic: Canada and America

2001-03-15 Thread jkstill
On Thu, 15 Mar 2001, Dave Morgan wrote: Fact: The longest undefended border in the world is between Canada and the US. ( 7000 miles) Granted this reflects better on the US than Canada, as we could put the whole Canadian population along the border and still couldn't hold hands.

RE: 8.1.7

2001-03-14 Thread jkstill
It seems like you should just be able to modify your CLASSPATH and PATH to deal with this problem. Jared On Tue, 13 Mar 2001, Kevin Kostyszyn wrote: RE: 8.1.7Check this out, this is a known bug with Pentium 4 processors and Netware. However, after tredging through Metaslink I found

RE: AW: Script for reversing a string?

2001-03-14 Thread jkstill
My apologies for the RTFM. I guess it isn't documented, even though it has been around for several years. Jared On Tue, 13 Mar 2001, Jack C. Applewhite wrote: Jared, Well, I've RTFM for 8.1.6 and the SQL Reference doesn't mention a Reverse() function. However, there is a supplied

Re: HELP ,Oracle error.

2001-03-14 Thread jkstill
There should be another error message with this. What other messages do you see? Jared On Tue, 13 Mar 2001, Dash, Saroj (CAP,CEF) wrote: Hello All, I got an Oracle error ORA-6512. I am unable to understand this problem. No PL/SQL error . Please help me. Saroj. -- Please see the

RE: Advanced Korn Question

2001-03-14 Thread jkstill
On Tue, 13 Mar 2001, hp wrote: can you tell mne what the difference is between: $log 21 and 21 $log if tried both ways and the std err and std out go to the log both ways. Probably not, unless you have some strange variant of ksh. When you redirect STDOUT with " $log", STDOUT is

Re: Oracle JDBC driver

2001-03-14 Thread jkstill
Take a look at the JDBC manual, it's on the doc CD. Just adding d:\jdbc\lib to your classpath isn't good enough. The needed classes are not in a jar file, they are in a zip file. Include d:\jdbc\lib\classes12.zip in your CLASSPATH. Jared On Tue, 13 Mar 2001, mai huynh wrote: when I unzip

Re: Order of table_name resolution

2001-03-14 Thread jkstill
Here's more than you wanted to know about name resolution: http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev.817/a77069/d_names.htm#3693 Jared On Wed, 14 Mar 2001, Cale, Rick T (Richard) wrote: Hi DBAs, Can someone clarify/confirm on how Oracle determines what

Re: Oracle JDBC driver

2001-03-14 Thread jkstill
You will need to set your PATH to include the location of the required DLL's. Jared On Wed, 14 Mar 2001, mai huynh wrote: I set the classpath point to the zip file. Now, in java file, when run the following line, I get the error: the dynamic link library ORA805.dll could not be found in

Re: Oratab and ORACLE_HOME.

2001-03-13 Thread jkstill
Well, I'm confused. Why and how is Designer installed on your unix box? There is no unix version of Designer. CASE 5 was the last unix version of Oracle Design tools. Jared On Tue, 13 Mar 2001, Jenner Mike wrote: Hi, Here's a question that's been bugging me.. If I've got Oracle

Re: AW: Script for reversing a string?

2001-03-13 Thread jkstill
But this is so much easier: select reverse('reverse') from dual; A little RTFM goes a long way :) Jared On Mon, 12 Mar 2001, Haunschmidt Andreas VASL/FAS wrote: Hi! Here's the function: -- snip - create or

Re: function index concepts - urgh

2001-03-10 Thread jkstill
Dennis, This should do it. select * from holder where last_name = upper('Taylor') and first_name = upper('Dennis'); And no it's not Friday, it is now Saturday. ;) Jared On Fri, 9 Mar 2001, Dennis Taylor wrote: create index HOLDER_NAME_IDX on HOLDER (UPPER(LAST_NAME||' '||FIRST_NAME));

Re: Product for Field level security

2001-03-06 Thread jkstill
Check out www.teleran.com I believe their product(s) will do what you ask. Jared On Tue, 6 Mar 2001, Mandar Ghosalkar wrote: Hi Guys, I am in need of solutions and ideas. We are developing a Datawarehouse and need to implement "Field level security". Read not Fine grained access

Re: Oracle Author in People Magazine

2001-03-03 Thread jkstill
On Wed, 28 Feb 2001, Ari D Kaplan wrote: Now we know from the article that he is 44 years old ;) Take care, Ari, If we go by the picture he frequently uses, I would say he's actually only about 35. ;) Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

Re: anyone interested in XML

2001-02-27 Thread jkstill
If you are doing XML and Oracle, this book is a *must* have. It will help you tremendously. It explains XML, Oracle's XML tools, and how to tie it all together. I'm working through it now, and it's much better than trying to piece it all together from various sources of Oracle docs.

Re: Jared's Web Site

2001-02-27 Thread jkstill
Hi Matt, My web site has moved: www.cybcon.com/~jkstill/util Jared PS. you planning to be at IOUG? On Tue, 27 Feb 2001, Adams, Matthew (GEA, 088130) wrote: I've misplaced my URL for Jared's Web Site. Can someone be so kind as to provide it? thanks matt R. Matt Adams - GE

RE: process parameter

2001-02-27 Thread jkstill
SMITTY is the AIX system administration tool. type 'smitty' at the shell prompt. Anyone can run it, though you're likely to be very limited as to what you can do with it unless you have an ID zero account. Jared On Mon, 26 Feb 2001, rammohan wrote: hi, what exactly is smitty utility?

RE: process parameter

2001-02-27 Thread jkstill
Christian, Do you know of a good article on the web to explain the workings of post wait drivers? Thanks Jared On Tue, 27 Feb 2001, Trassens, Christian wrote: AIX doesn't use semaphores. You must run the script rootpre.sh to create the /etc/loadext This is because AIX uses post-wait

Re: Informatica on Solaris

2001-02-23 Thread jkstill
I have some experience with Ardent ETL tools, but not Informatica. The reason I even mention it is that they both have one thing in common, they are memory hungry. Put as much RAM as you possibly can in the box running Informatica. 6 Gigs would be a start. Jared On Fri, 23 Feb 2001, Seley,

RE: An Apology

2001-02-20 Thread jkstill
*IF* you had been paying attention, you would have noticed that this was a tirade against duhvelopers, *not* developers. Jared ;) On Fri, 16 Feb 2001 [EMAIL PROTECTED] wrote: Actually, as a developer, I found the entire thing offensive. :-) -Original Message- From: Mark Leith

Re: [Doubt] - Returning Type Table

2001-02-20 Thread jkstill
scott VARIABLE rtc REFCURSOR scott EXECUTE :rtc := rtc_dept begin :rtc := rtc_dept; end; The first thing I notice is that the code above is assinging an 'index by table' to a ref cursor. You might start there. Jared On Mon, 19 Feb 2001, Eriovaldo do Carmo Andrietta wrote: Hi Friends :

Re: help:how to change screen resolution in solaris6?

2001-02-20 Thread jkstill
On Sun, 18 Feb 2001, chaoping wrote: You would likely get more replies if you didn't send mail in HTML format. Read the man page for 'ffbconfig'. To change resolution until the next reboot: From the x11 login window, choose command line login and run ffbconfig. I use 'ffbconfig -res

Re: Any way to catch end of transaction programmatically?

2001-02-16 Thread jkstill
On Fri, 16 Feb 2001, Eskov Anton wrote: Hi Is there any way to get notified when COMMIT/ROLLBACK statement is executed? SY Anton Here's an example. I'll leave making use of this as an exercise for the reader. ;) Jared declare cursor c_trans_count (

Re: Am I too hard on the developper ?

2001-02-16 Thread jkstill
Stay on it. Dropping tables to add columns in development is just plain stupid. Jared On Fri, 16 Feb 2001, [iso-8859-1] paquette stephane wrote: Hi, I do not know if it's friday afternoon or what ? The developpers want me to regenerate the grants in the development environment because

Re: Is this list moderated??

2001-02-16 Thread jkstill
On Fri, 16 Feb 2001, Dasko, Dan wrote: If I wanted to read Clinton apologist views, I'd go to Salon.com, if I wanted to read Clinton basher views, I'd go listen to Rush L. A little off-topic now and then is a good thing, but give it a rest already. You aren't going to convince me of

RE: Am I too hard on the developper ?

2001-02-16 Thread jkstill
On Fri, 16 Feb 2001 [EMAIL PROTECTED] wrote: ... DBAs who seem to look down on developers. There are good and bad developers, but guess what ... there are also good and bad DBAs. We've had both here. True, but bad developers tend to last longer than bad DBA's. ;) Jared -- Please see

Re: How store 1024 bit ?

2001-02-15 Thread jkstill
I would suggest that you start researching PKI ( public key infrastructure ) There is a *lot* of info available. Just use your favorite search engine. Also check out Oracle Advanced Security at technet.oracle.com. This is a very big subject. What are you doing that you plan to have

RE: Off Topic: Row Locking - Row Id

2001-02-15 Thread jkstill
On Wed, 14 Feb 2001, Rachel Carmichael wrote: Oh Jared, no.. Hitchhiker is way different (although also a Britcom) Red Dwarf is total insanity... and it is on my PBS station on Friday nights :) Totally different, but the same insane wacky British humor. :) Jared -- Please see the

Re: Off Topic: Message for you

2001-02-15 Thread jkstill
OK Magesh, back to work! You obviously have too much time on your hands. ;) Jared On Wed, 14 Feb 2001, magesh wrote: Dear All Execute the statement on a SEQUEL prompt and see the message for you. SELECT TRANSLATE('_9(8.-.=5*;.81^^;.=1@5$)9$5.41;', '1234567890!@#$%^*()-=_+;,.',

RE: Off Topic: Row Locking - Row Id

2001-02-15 Thread jkstill
And a 1000 for Rachel as well! Jared On Wed, 14 Feb 2001, Rachel Carmichael wrote: British Comedy Red Dwarf -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

Re: LogMiner and Auditing

2001-02-15 Thread jkstill
No finger pointing here. I have not met any duhvelopers at this company. (yet) Plenty at the previous job. This is a fictional scenario. Jared On Thu, 15 Feb 2001, Thater, William wrote: [EMAIL PROTECTED] wrote: Seriously, has anyone successfully used LogMiner for auditing in a

Excessive IO problem after index partition split/rebuild

2001-02-15 Thread jkstill
Dear List, Here's a problem that a fellow DBA is experiencing, and for which I have not been much help. :( This is the situation: A session is started and the following query is issued: select log_record, raw_log_data_id from raw_log_data where status = 'U' and

RE: Off Topic: Row Locking - Row Id

2001-02-14 Thread jkstill
-- run this part from session A: drop table lock_test; create table lock_test ( name varchar2(10) not null ); insert into lock_test values ( 'nebula'); insert into lock_test values ( 'quasar'); insert into lock_test values ( 'pulsar'); insert into lock_test values ( 'red dwarf');

LogMiner and Auditing

2001-02-14 Thread jkstill
FYI: Resent with a different subject - I've seen a few posts on the list lately suggesting the use of LogMiner as an auditing tool. I have serious doubts about it's use in this capacity. Imagine the following scenario. Duhveloper: 'We just discovered that someone dropped a

RE: Renaming a column

2001-02-14 Thread jkstill
Been there, done it. It's dangerous. Don't ever do it. I was lucky and was able to reverse the changes. I know and Oracle instructor who was not so lucky and lost a database. I've heard of other people doing this and it worked properly. It's usually a bad idea to mess with the data

Re: rollback after 0 rows affected

2001-02-14 Thread jkstill
The default Oracle DB behavior is for a transaction to be committed when the session exits. This may be overridden in an application ( such as SQLPLUS ) so that the default behavior is a rollback. I would explicitly commit or rollback were I writing an app. Jared On Wed, 14 Feb 2001,

RE: Off Topic: Row Locking - Row Id

2001-02-14 Thread jkstill
Quite a few don't get it apparently. It's a British SciFi comedy. Think 'Hithhikers Guide to the Galaxy'. Jared On Wed, 14 Feb 2001, Paul Baumgartel wrote: Now can you enlighten the rest of us? Or am I the only one who doesn't get it? Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED]

RE: Off Topic: Row Locking - Row Id

2001-02-13 Thread jkstill
Depending on your application design, you may find a locking scheme useful. Below is an example that uses rowid to take out a lock. Note that this is not a lock on an object, but simply a lock identified by a rowid. As the demo is setup, the locks are automatically released on rollback or

RE: MINUS VS NOT IN

2001-02-09 Thread jkstill
On Fri, 9 Feb 2001, MacGregor, Ian A. wrote: A few questions for Peter Hazelton Why the use of distinct in the set operation in query one when dupicates will be tossed by it? What's the purpose of the distinct in the subquery of query two? For Jared, have you tried using a hash

Re: Decimal to Hex conversion

2001-02-08 Thread jkstill
On Thu, 8 Feb 2001, Deepak Sharma wrote: There probably is a package called base_convert. I haven't used it but it showed up on Metalink, try it out. -- Deepak Here's a modified version of one from Tom Kyte. He had separate functions, I prefer a package. Jared -- ** some test code

Re: COPY command dieing - help

2001-02-02 Thread jkstill
On Thu, 1 Feb 2001, Shaw, John B wrote: I am attempting to copy a table from a 8.1.6 db to 8.1.7. Most of the tables have come across successfully. One table is having a problem. The command: copy from v55/v55@int to user/pwd@frog create DMF using select * from DMF@int; This table gives

Re: Netapp

2001-02-02 Thread jkstill
On Fri, 2 Feb 2001, alex wrote: Working with autoraids I have always been suspicious about their ability to decide on witch raid level is best. ^ Some kind of wierd Freudian slip here Alex? ;) Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

Re: Inserting into Long

2001-02-01 Thread jkstill
Please use 'perldoc DBD::Oracle' from the command line. This documentation will tell you how to deal with longs. Jared On Thu, 1 Feb 2001, Gary Chauhan wrote: Hi, I am loading data into Oracle table using a perl program. Table structure is ( Col1 Varchar2,

RE: OT ? for people who know other databases besides Oracle

2001-02-01 Thread jkstill
On Wed, 31 Jan 2001, Seley, Linda wrote: OK. So we want to avoid procedures, functions, triggers, etc. unless we want to build some sort of wrapper. What about long datatypes, blobs, clobs, outer joins, distincts, using nextval to grab sequences, etc. Does anyone know where I can find

Re: Init.ora .. OPTIMIZER parm: optimizer_index_cost_adj

2001-01-31 Thread jkstill
I've used this in an attempt to make the optimizer prefer a hash join over a nested loops join. The desired results were not achieved. Jared On Tue, 30 Jan 2001 [EMAIL PROTECTED] wrote: Has any one messed with optimizer_index_cost_adj on 8.1.7 ?? The default is 100, but my boss

Re: Index Usage Monitoring

2001-01-31 Thread jkstill
Pine Cone Systems has software to do this. There is also another company that has software to do this, but I can't recall their name at the moment. If you talk to Pine Cone, ask them who their competitors are. Be forewarned, this stuff is very expensive. Jared On Tue, 30 Jan 2001, PRINCE,