AUDIT_ACTIONS

103 SESSION REC I see entries in one of my AUD$ tables with a ACTION = 103 I'd like to know exactly what this action references. I've searched my 8i online doc set but got no hits. I'm willing to RTFM is somebody will point me at which FM I should use in this case. TIA & HAND! -- Charlie Meng

Re: Oracle ODBC On Windows95 (Don't ask) :)

Install the 8.1.7 client on 95. >>> [EMAIL PROTECTED] 04/25/02 10:28AM >>> I need to setup a ODBC connection to an Oracle 8.1.7 database over TCP/IP where the Client PC's are running Windows 95 (Old clunkers) Anyone know what I need to do for this? Can I use the 7.3 ODBC drivers written for Wind

Re: Cronjob

I have the same problem but with our vax/vms machine.. could I submit a job queue on every week or maybe every month... $Submi/Noprin/Notif/Que=Parm_Deplan/log=[diga.digu]dige.log - _$/After = "tomorrow+06:00" - _$sys$geology:[diga.digu]dige.com I usually submit que every day.. but I want to sub

Re: Buffer in Import

I believe that it refers to bytes. --- "Ramon E. Estevez" <[EMAIL PROTECTED]> wrote: > Does the parameter buffer in the import refers to bytes or number of > rows ? > > Kind of confuse. I think it refers to the number of rows. > > buffer=5 ---> is that 5 bytes, or 5 rows >

RE: 9i new features, the saga continues?

Keep 'em coming Joe! -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of JOE TESTASent: 25 April 2002 14:14To: Multiple recipients of list ORACLE-LSubject: 9i new features, the saga continues? Ok life has slowed down some and i've got some fr

DBMS_STATS.gather_database_stats

If you're not supposed to analyze SYS and SYSTEM then can anyone explain why the DBMS_STATS.GATHER_DATABASE_STATS procedure does? We have run into scenarios where the data dictionary becomes almost unusable until SYS gets analyzed again via this procedure. I.e. can't describe v$ views, selec

Re: Oracle ODBC On Windows95 (Don't ask) :)

Why not use 8i ODBC.  I know that 8.1.5 installed on Win95.  My guess is that 8.1.7 should too. If it won't use the 8.1.5 drivers. Rodd On Thu, 2002-04-25 at 09:28, Stefan Jakobsson wrote: I need to setup a ODBC connection to an Oracle 8.1.7 database over TCP/IP where the Client PC'

Re: "Can't Break In" and Securing iAS on NT

Sounds like the only way to secure iAS on NT is not to put it on NT.  You might try LINUX.  It would at least let you use your existing hardware.  And, it's free or relatively cheap depending on distro. Rodd On Thu, 2002-04-25 at 07:53, Boivin, Patrice J wrote: I am reading through O

RE: Curious question about flushing the Pool

Wow, I think that's a brilliant idea. It would be a huge benefit to me, where all of our code is VB, and the developers refuse to use bind variables. My sql area is .5 GB and is 95% garbage. -Original Message- Sent: Thursday, April 25, 2002 9:03 AM To: Multiple recipients of list OR

sql monitor

hi! i am looking for tools to monitor the SQL of an application that connects to oracle to analyse it. whichs tools are available? who has experience with them??? tia & bye daniel -- Daniel Wisser, Mag. ISIS Information Systems Alter Wienerweg 12 A-2344 Ma. Enzersdorf, Austria Phone: +43-2

RE: 9i new features, the saga continues?

Yes! Jack C. ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit, Inc.Austin, Texaswww.iNetProfit.com[EMAIL PROTECTED](512)327-9068 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of JOE TESTASent: T

UNIX Courses

Hi all, What Unix courses/modules would you recommend for a budding Oracle DBA Thanx, --- CSW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: 9i new features, the saga continues?

So those features aren't new any more; they're 6 months old. =) Paging Robert Freeman; Joe is cutting into the sales of your book here!! Grins to all on this sunny afternoon, Mike Hately -Original Message- Sent: Thursday, April 25, 2002 9:14 AM To: Multiple recipients of list ORACLE

RE: 9i new features, the saga continues?

Joe, It took me a while to remember what you were refferring to and a search of my archived mail but I too appreciate the information about 9i that you were sending to us. Thanks for finding the time to spread the knowledge. Ron ROR mª¿ªm -Original Message- Sent: Thursday, April 25, 200

Oracle ODBC On Windows95 (Don't ask) :)

I need to setup a ODBC connection to an Oracle 8.1.7 database over TCP/IP where the Client PC's are running Windows 95 (Old clunkers) Anyone know what I need to do for this? Can I use the 7.3 ODBC drivers written for Windows95 for connection to a 8.1.7? I've never done this before and can't find

RE: Curious question about flushing the Pool

okay, who do you still know inside Oracle who can push this enhancement? sounds eminently reasonable to me! Rachel --- Cary Millsap <[EMAIL PROTECTED]> wrote: > I think an excellent Oracle kernel enhancement would be to bias in > the > LRU scheme against SQL that uses literals, just like the buff

Re: 9i new features, the saga continues?

Joe, You give interesting points and topics. Yes, I am interested in your 9i new features. Thanks for the time you give to help others. Have a great weekend, donita :Date: Thu, 25 Apr 2002 05:13:37 -0800 :To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> :X-Comment: Oracle RDBMS Co

No Rows Deadlock and PCTFREE, INITRANS on 8.1.7.2

We are testing an upgrade of our warehouse from 8.0.4 to 8.1.7.2. While testing our nightly load job that runs in two simultaneous streams (ascending and descending), we have been getting deadlock errors. The trace file shows the the rows waited on are no rows. In response to a TAR I opened w

RE: Number of File systems to use.

Thank you very much Robert Freeman for your opinion. I am half way through your book of 9i new features. It is very good. Could some one else give some opinion on the need to spread IO even when using EMC storage please. --- "Freeman, Robert " <[EMAIL PROTECTED]> wrote: > I'd stick to the id

RE: Is sqlplus too slow to unload data?

Hey Jared, I got quite a few folks waiting for your book now. I am really pushing Perl at the office:-) When is the scheduled release again? -Original Message- Sent: Thursday, April 25, 2002 12:03 AM To: Multiple recipients of list ORACLE-L On Tuesday 23 April 2002 21:53, Bin Wang wr

Re: Anyone using Enterprise Manager?

Check out note 114682.1 on Metalink.

Re: good value for optimizer_index_cost_adj

My 1/2 cents on this... Another way of thinking of scattered -vs- sequential reads is that a scattered read is used when you know up front that you want to read several blocks and know which blocks they are. You can then use a vectored read to do this or farm them all out in parallel using asynch

Buffer in Import

Does the parameter buffer in the import refers to bytes or number of rows ?   Kind of confuse. I think it refers to the number of rows.   buffer=5  ---> is that 5 bytes,  or 5 rows   TIA   Ramon      

RE: Which Server Machine?

IMHO, I would never opt for only 1 cpu. There should be at least 2, if you are going to be using parallel query, then 4 cpus. After 4, on many platforms, there is diminshing return on investment. That's my rule of thumb, and I have nothing to base it on but gut feeling. HTH, Beth -Origi

OLAP Financial Function Calculators for Oracle 9i.

Hi I would like to know if the Oracle Express feature of Financial Function Calculators are available with Oracle enterprise Edition 9.0.1.0.0. If my memory serves me correctly , I think Oracle has incorporated OLAP services as part of the 9i database enterprise edition. But I am not certain

Re: Cronjob

Roland, The crontab fields are defined as: 1 2 3 4 5 "program to execite" 1 = minutes after the hour 0-59 2 = hours of the day 0-23 3 = days of the month 1-31 4 = months of the year 1-12 5 = days of the week 0-6 0=Sunday * = all possible values 0 6 * * 6 job to be run is placed here. States

RE: Anything new from IOUG? + "OWI" Born!! (Anjo/Mogens, please n

Good morning everyone: Since everyone was wondering what the Top 10 things were from IOUG Live!, I went to the source: Ian Abramson, Director of Educational Programming for the IOUG and the person that provided this jocularity. Here they are: Here is the top 10 list: Top 10 Lessons Learned a

Re: Cronjob

Roland, Use the following command from the unix prompt: man crontab It'll tell you everything you need to know about changing the times of jobs scheduled via cron. If you look it up and figure it out yourself, you'll never need to ask about it again. However, if you just cut and paste some

9i new features, the saga continues?

Ok life has slowed down some and i've got some free time to potentially pickup the 9i new features saga i did about 6 months ago.   Anyone still interested?   The next on the list was 9i data guard.   joe  

RE: Any scripts to check the health of the database

You can send e-mails using UTL_TCP and UTL_SMTP, see MetaLink for example. Alternatively you can run crontab for Windows or AT jobs regularly and use something like blat to send alerts when certain conditions occur. You have to maintain the scripts though. Scripting on NT / Win2K is (er...) dis

RE: 9i new features, the saga continues?

Yes, I am *still* interested Joe.   Raj __ Rajendra Jamadagni      MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, b

Re: Curious question about flushing the Pool

Minor correction, cursor_sharing did work in versions under 8.1.7.3 (I used it in 8.1.6) but there was a bug relating to very specific usage. I never encountered it, I know you can look up the details of the bug on Metalink. Having said that, I used cursor_sharing=force instead of flushing the sh

RE: Curious question about flushing the Pool

True - but then you're up for a definition of what constitutes filthy? A query like "select to_char(x,'...'), substr(y,1,3),instr(..)" (ie insert any appropriate Oracle function that could have static numeric/character arguments) and suddenly its "filthy"...Still, I'd like something more drama

"Can't Break In" and Securing iAS on NT

I am reading through O'Reilly's Apache: The Definitive Guide, 1999. On page 42 it says: "In plain English, this means, once again, that Win32 is not an adequate platform for running a Web server that has any need for security." Has anyone been able to get info out of MetaLink on how to secure

Re: Cronjob

0 6 * * 6 /d31/appl/konto/bat/laddabilbo.sh >/d31/appl/konto/log/laddabilbo.log 2>&1 __ www.cichomitiko.cjb.net __ - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, April 25, 2002 1:43 PM > Hallo, > > I would like to have this cronjob

RE: Cronjob

Use vi. -Original Message- Sent: 25 April 2002 12:43 To: Multiple recipients of list ORACLE-L Hallo, I would like to have this cronjob run only in saturday mornings at 6 am. How could I easy change this script? 0 18 * * * /d31/appl/konto/bat/laddabilbo.sh >/d31/appl/konto/log/laddabil

Re: Cronjob

man cron man crontab you really need to do some research on your questions before posting --- [EMAIL PROTECTED] wrote: > Hallo, > > I would like to have this cronjob run only in saturday mornings at 6 > am. How could I easy change this script? > > 0 18 * * * /d31/appl/konto/bat/laddabilbo.sh

Re: Cronjob

0 6 * * 6 /d31/app . Look at man for crontab (on my linux it's man 5 crontab); The time and date fields are: field allowed values - -- minute 0-59 hour 0-23 day of

RE: Anything new from IOUG? + "OWI" Born!! (Anjo/Mogens, please n

hi Mike, Go to my site (www.oracledba.co.uk), then Tuning => Custom Hit Ratio Enjoy! Cheers Connor --- "Vergara, Michael (TEM)" <[EMAIL PROTECTED]> wrote: > Ok...ok...ok...enough talk... can somebody PLEASE > publish a > reference location of this script? > > Thanks, > Mike > > > -Orig

RE: Cronjob

0 06 * * 6 d31/appl/konto/bat/laddabilbo.sh >/d31/appl/konto/log/laddabilbo.log 2>&1 Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018

How to Install oracle 9i on windows cluster.

Hi all I have to install oracle9i on windows 2000 cluster environment. whether i have to install it in cluster or not. and what are all the steps to follow. Rgds Ayyappan.S This communication contains information, whic

Re: good pl/sql coding/debugging tool?

give up windoze, go to linux and use TORA. joe [EMAIL PROTECTED] wrote: > > I would suggest you to use TOAD because the DBA Module of this product > is quiet good. Database Monitor and Unix Monitor could also be used. > Another option is SQL Station from CA. > > > Regards > > M.Emre HANCIOGL

RE: Any scripts to check the health of the database

This is something that I am looking for a way to check on an 8.1.7 database running on NT without me physically having to login myself. Is there some automated way to do this, that maybe can send an email to a computer operator?? Thanks, Dave -Original Message- Sent: Wednesday, April

Which Server Machine?

Hi, What should be the basis of selecting a type of server machine? Single processor, two processor, four processor How many years down the road should one plan for? In web deployment, the web server will have connection(s) with data server and can be configured for connection sharing. What role

Cronjob

Hallo, I would like to have this cronjob run only in saturday mornings at 6 am. How could I easy change this script? 0 18 * * * /d31/appl/konto/bat/laddabilbo.sh >/d31/appl/konto/log/laddabilbo.log 2>&1 Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.co

RE: good pl/sql coding/debugging tool?

Other options would also be PL/SQL Developer from www.allroundautomations.com (though I had heard that they have also been taken over by Quest), and Lecco SQLExpert from www.leccotech.com (also available from yours truly ;P) Mark === Mark Leith

RE: monitoring multiple databases using PL/SQL -- follow-up question

Point 3 sounds correct.. Make sure that you also *monitor the monitor*!! Even if you just set up AT job or something that runs from a DBA desktop every 10-20 minutes, connects to the instance and "select 'OK' from dual;" to test the connection.. If it fails, flag an error through something like "

Re: good pl/sql coding/debugging tool?

I would suggest you to use TOAD because the DBA Module of this product is quiet good. Database Monitor and Unix Monitor could also be used. Another option is SQL Station from CA. Regards M.Emre HANCIOGLU Masterfoods Services GmbH ISI Application Support Tel : +49 2162 500-576 Fax: +49 2162 4149

Anyone using Enterprise Manager?

Hi, I have this problem with starting 9i EM as connected to Management Server After installation and configuration I started with default sysman. And changed the password after first login. It worked fine for that session but after closing and then restarting, EM Console does not seem to be reco

Re: Curious question about flushing the Pool

> Comments? Corrections? Rants? I'll go for rant... I've had long and painful experience with a few pathological applications. One in particular contained hundreds of sets of common SQL statements - varying only in the literal values. Many were executed hundreds of thousands or even millions o

RE: LOG_BUFFER Parameter Question

Thanks to all of you on this issue...   -Original Message-From: Gogala, Mladen [mailto:[EMAIL PROTECTED]]Sent: Wednesday, April 24, 2002 8:12 PMTo: Multiple recipients of list ORACLE-LSubject: RE: LOG_BUFFER Parameter Question Alternatively, you size it until redo_log_spac

Re: Curious question about flushing the Pool

I'll second that suggestion! To extend the analogy, how about a "recycle pool" for them? (So they don't fragment or otherwise clutter up the "keep pool".) How about adaptive "auto-pin" in the "keep pool" based on execution frequency? (Never mind... Probably not really necessary. I'd settle for t

<    1   2