How to see it?

RE: Re[2]: sequence numbers

We were asked, not too long ago, to create one Oracle8i database with only *one* table with some 700+ columns. While at it, the consultant (hired by end user dept) also suggested that we make it an IOT using an LMT, and since the table will never grow over 1GB, asked if there was a way to put it

Re: [Q] ORACLE 9.2 and different version of client?

In theory all three clients will work with 9iRelease2. However, we have encountered a problem where the client is 8.0.6, connects to a 9.2 database which has a database link to an 8.1.7 database -- queries across the db-link result in an ORA-3120 error. The analyst closed the TAR has 8.0.6 is

RE: CPU WAIT I/O statistic

Pablo What does your I/O look like while %wio is high? Specifically, I would suggest: - Look at the disk subsystem I/O, is it experiencing a high rate of I/O? - Run STATSPACK and see which tablespaces are hot. - Are a lot of table scans being executed? Dennis Williams DBA Lifetouch, Inc.

RE: [Q] ORACLE 9.2 and different version of client?

Using clients 9 be ready for a question from someone that connect internal works with 9i too! :-) One day a developer came to me and said that contrary to what I had told him he was able to connect as internal into a 9iR2 test DB, and he showed me. Later I figured out that he was using 8.0.5

RE: Re[2]: sequence numbers

it's all in the buzzwords, obviously :) --- Deshpande, Kirti [EMAIL PROTECTED] wrote: We were asked, not too long ago, to create one Oracle8i database with only *one* table with some 700+ columns. While at it, the consultant (hired by end user dept) also suggested that we make it an IOT

RE: Oracle list for developers ??

Forgot the smiley ;-) - it was a rough day. Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Thursday, October 10, 2002 7:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle list for

RE: Controlling Users Logons

They can come in from various 'machines'. - Kirti -Original Message- Sent: Friday, October 11, 2002 9:39 AM To: Multiple recipients of list ORACLE-L Could you use machine from v$session? [EMAIL PROTECTED] 10/11/02 09:48AM Hello Listers, I was asked by a co-worker if there was a

Re: Controlling Users Logons

Try this: --create_LOGON_MULTIPLE_CHECK.sql CREATE OR REPLACE TRIGGER LOGON_MULTIPLE_CHECK AFTER logon ON DATABASE DECLARE client_info_str V$SESSION.CLIENT_INFO%TYPE; var_usernameV$SESSION.USERNAME%TYPE := null; kill_Login EXCEPTION; PRAGMA EXCEPTION_INIT( kill_Login, -20997

RE: Thanks - Oracle list for developers ??

Thanks to all who responded helpfully. SY. ^^ Hey Scott, I think he was excluding you... :-) -Original Message- Sent: Friday, October 11, 2002 8:34 AM To: Multiple recipients of list ORACLE-L Thanks to all who responded helpfully. SY.

RE: Re[2]: sequence numbers

But the DOCUMENTATION says 8-0 April Wells Oracle DBA Keep yourself well oiled with life, laughter, new ideas and action. Otherwise you will rust out. _Anonymous -Original Message- Sent: Friday, October 11, 2002 10:20 AM To: Multiple recipients of list ORACLE-L it's all in the

RE: CodeNotes for Oracle9i...

I have an odd question about these on-line books. Can I copy-and-paste the text? Like many of you, I seem to end up with long commutes (why are the best jobs never in your neighborhood?). I find listening to books on CD to be a better use of time than reading bumper stickers. Nobody ever

RE: How to see it?

You're right... How can I see it? -Original Message-From: hukangang [mailto:[EMAIL PROTECTED]]Sent: Friday, October 11, 2002 3:38 AMTo: Multiple recipients of list ORACLE-LSubject: How to see it?

RE: CodeNotes for Oracle9i...OT

It still seems to be restrictive and pricey to me. The 30 books-a-month at a one time yearly fee is $300. At the end of the year, what do you have? Another $300 bill for the next year. And how many books do you have access too, if you don't dish out another $300, ZERO. With bookpool.com, for

PROCESS column in V$SESSION

For folks connecting to the DB server from another Unix box the PROCESS field is the Process ID on the host named in the MACHINE field. For folks connecting to the DB server from a PC the values are in the form of : So what do signify? WENDYC

RE: Oracle9i upgrade exam - Recommended books/material? (Borderin

Thanks a bunch! I'm Looking forward to 10i!! Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you.  

RE: Verrrry interesting article at MetaLink

Allegedly, even cars will have ctrl-alt-del buttons. I leave the automotive implementation of BSOD to your imagination. I can envision people bragging about their brand new cars: I have one, I forgot the maker, but it has 64GB of RAM, 4.8 GHZ CPU and the latest WheelBlaster+ with MS 2007

RE: Controlling Users Logons

Title: RE: Controlling Users Logons Kirti ... you can still use the logon trigger ... if total_user_logons max_allowed then raise_application_error ('-20001','You seem to have exceeded your quota,' || 'Please come to the DBA group with a Banker''s Check.' || We no longer accept

RE: Controlling Users Logons

Kirti, I used this to control users not to connect using SQLPLUS, TOAD, NAVIGATOR, etc. Try it to check if it works for you. -- Start of DDL Script for Trigger SYS.LOGON_AUDIT_T -- Generated 20-May-2002 05:31:48 p.m. from U20188@PROD CREATE OR REPLACE TRIGGER sys.logon_audit_t after logon on

Re: How to see it?

me too :-) Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: Johnston, Tim To: Multiple recipients of list ORACLE-L Sent: Friday, October 11, 2002 11:44 AM Subject: RE: How to see it? You're right... How can I see it?

Re: 9.2 on Red Hat 8.0

On Wed, Oct 09, 2002 at 10:53:57AM -0800, Gogala, Mladen wrote: May I subscribe to the results of your undertaking? My home email is mailto:[EMAIL PROTECTED] May the force be with you. Went great! Well, sort of... I didn't even read the install guide (and the results will show below). I

RE: Verrrry interesting article at MetaLink

(shaking my head) You guys are killing me. Since Microslop is going to include SQL Server Enterprise edition with every copy of Windows, Windows CE, Windows Mobile, etc, Oracle will lose considerable market share. Dozens of lawsuits will be filed, but since MS has paid off all the judges, the

RE: Controlling Users Logons

Hi Thomas, Thanks a lot for the code. Looks like we can do something very similar. - Kirti -Original Message- Sent: Friday, October 11, 2002 10:24 AM To: Multiple recipients of list ORACLE-L Try this: --create_LOGON_MULTIPLE_CHECK.sql CREATE OR REPLACE TRIGGER LOGON_MULTIPLE_CHECK

RE: Oracle9i RMAN Backup and Recovery

Thanks Jared! RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you.   -Original Message-

RE: CodeNotes for Oracle9i...OT

Yes, that's 30 books a month -- up to 360 books a year. How often do you reference that Oracle DBA Handbook 7.3 Edition now? How many people can use your current book simultaneously? How many books are covered in coffee (or Jr's peanut butter sandwich)? Who borrowed the book and never brought

Re:RE: Re[2]: sequence numbers

Let's see, 1 table with 700+ columns that can grow to ~1GB that you want to iot and have in the keep pool. What are you smoking! That's one consultant that I'd HAVE to laugh in his/her face. And he/she would NOT get away with it. Dick Goulet Reply

Re: Database Trigger not fireing In Delete Mode

Naba, I think you need something like this CREATE OR REPLACE TRIGGER triggername AFTER INSERT OR UPDATE OR DELETE ON tablename FOR EACH ROW WHEN (NVL(new.fldname1,old.fldname1)is not null and NVL(new.fldname2,old.fldname2)is not null) DECLARE BEGIN processing goes here END; hth, Chaim

RE: How to see it?

he used white text on a white background -Original Message-From: Johnston, Tim [mailto:[EMAIL PROTECTED]]Sent: Friday, October 11, 2002 11:45 AMTo: Multiple recipients of list ORACLE-LSubject: RE: How to see it? You're right... How can I see it? -Original

RE: Thanks - Oracle list for developers ??

Who'd a thunk it? LOL! Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Johnston, Tim [SMTP:[EMAIL PROTECTED]] Sent: Friday, October 11, 2002 10:39 AM To: Multiple recipients of list ORACLE-L Subject: RE: Thanks - Oracle list for developers ?? Thanks

RE: Advice needed on move to Sun 15K (losing spindles)

I obviously left out a lot of information :). We would be using server partitioning, with seperate ORACLE_HOMES for each database (necessary since we have a variety of versions running). The box would be running 1+0, the Sun reps suggest striping across all disks (my first red flag). I hadn't

RE: Controlling Users Logons

Ramon, Thanks a lot. My problem in using logon trigger turned out to be the 8.1.7.2 version of the database. Raising appl error is just dumping a trace file without killing the session. It does work fine with 8.1.7.4 databases. - Kirti -Original Message- Sent: Friday, October 11,

RE: RE: Re[2]: sequence numbers

I wanted to take a picture with him. .. and take him out to lunch to learn from his experience ... ;-) but it turned out he lasted only for less than a week... ;) (Some developers he was working with knew a bit more Oracle than him) - Kirti -Original Message- Sent: Friday,

RE: Advice needed on move to Sun 15K (losing spindles)

I suggest reviewing James Morle's paper 'Sane SAN' at http://www.oraperf.com/whitepapers.html. - Kirti -Original Message- Sent: Friday, October 11, 2002 11:15 AM To: Multiple recipients of list ORACLE-L I obviously left out a lot of information :). We would be using server

RE: 9.2 on Red Hat 8.0

Cool. Now we can run Oracle on a Microsoft Xbox. http://www.itworld.com/Comp/2362/021011xboxlinux/ Mark Stahlke Denver Newspaper Agency -Original Message- Sent: Friday, October 11, 2002 10:09 AM To: Multiple recipients of list ORACLE-L Subject:Re: 9.2 on Red Hat 8.0 On

RE: Advice needed on move to Sun 15K (losing spindles)

Why does management trust a salesman over their own IT professionals? Miller, Jay

RE: CodeNotes for Oracle9i...OT

And 0 books at the end of year, if you don't renew. I always check my Oracle 3.1 book, just before I log in... Zero, I don't want anyone messing with my books. And developers don't touch my books because their full of coffee, and peanut butter AND jelly stains... So Rich when you sign up

RE: PROCESS column in V$SESSION

Charlie, = NT Domain = Machine Name Hope this helps. PS - do I get a Home Depot Discount Card for this? :) Tom Mercadante Oracle Certified Professional -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Friday, October 11, 2002 11:59 AM To: Multiple recipients of list

RE: Advice needed on move to Sun 15K (losing spindles)

Salesmen/Saleswomen tell them what they want to hear! - Kirti -Original Message- Sent: Friday, October 11, 2002 12:54 PM To: Multiple recipients of list ORACLE-L Why does management trust a salesman over their own IT professionals? Miller, Jay

8.1.7.2 or 8.1.7.4

Which patch is recommended? Which is more stable? Obvious answer from Oracle Support was 8.1.7.4 for the reason that it was latest. But some of my friends have advised 8.1.7.2 Any opinions? Thanks, -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna

O/T - Disk IOs

Can anyone direct me to a method or tool for checking I/O on filesystems. the problem lies with matching up device names given by iostat to filesystem mount point names given by df. I.e. iostat -xdn extended device statistics r/s w/s kr/s kw/s wait

RE: Making a tablespace read-only - identifying blocking tx

First, I ommitted the ;) when replying to Rachel's post. I was just funnin... Second, in this case TTS will not work. While we can 99.99% guarantee that there will be no tx against the tablespace, there will be active tx in the database and we cannot guarantee that they will not cause the RO

RE: Advice needed on move to Sun 15K (losing spindles)

Thanks Kirti! I loved the line The first thing to do, regardless of platform or claims by the vendor, is to completely forget the existence of a cache Any similar references will be greatly appreciated. The more ammunition I have the likelier I am to kill something :) Jay -Original

RE: O/T - Disk IOs

Check options -m , -p Waleed -Original Message- Sent: Friday, October 11, 2002 2:08 PM To: Multiple recipients of list ORACLE-L Can anyone direct me to a method or tool for checking I/O on filesystems. the problem lies with matching up device names given by iostat to filesystem mount

RE: 9.2 on Red Hat 8.0

Thanks, Ray! Well, this is excellent! -Original Message- From: Ray Stell [mailto:[EMAIL PROTECTED]] Sent: Friday, October 11, 2002 12:09 PM To: Multiple recipients of list ORACLE-L Subject: Re: 9.2 on Red Hat 8.0 On Wed, Oct 09, 2002 at 10:53:57AM -0800, Gogala, Mladen wrote:

RE: Advice needed on move to Sun 15K (losing spindles)

I've cussed and discussed the topic of one big stripe versus multiple small stripes with different people and have yet to come across anyone who has conducted a real test of various scenarios. If you stripe across all disks, then you have the advantage of guaranteed, perfectly balance I/O --

RE: 8.1.7.2 or 8.1.7.4

Title: RE: 8.1.7.2 or 8.1.7.4 Vaidya I'm running 8.1.7.2 on all instances when I go to upgrade it will probably be 9iR2 starting with a test db, then from there, onto the least important db upwards. Of course I'm stalling to let all the venturous customers test thease new realeases (and

RE: Making a tablespace read-only - identifying blocking tx

thanks :) it sort of makes sense that you can offline a tablespace with an active transaction in it. You can offline a rollback segment with an active transaction in it, no new transactions can start in that rbs but the one(s) there will finish. With the tablespace, if I remember what I read in

RE: 8.1.7.2 or 8.1.7.4

Title: RE: 8.1.7.2 or 8.1.7.4 I agree with Richard. If you are running 8.1.7.2, and you are not experiencing a bug that has been corrected in 8.1.7.4, then stay where you are. Wait until 9R2 is stable and then move only when Oracle starts threatening desupport of 8i. let sleeping (content)

RE: 8.1.7.2 or 8.1.7.4

I'm investigating an 8.1.7 upgrade also. My impression is that the stability may vary by platform, so it might be helpful to specify the platform that is involved. I'm on HP/Compaq Tru64 myself. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday,

RE: Advice needed on move to Sun 15K (losing spindles)

Jay - Will your server partitioning protect the OLTP users from the DW queries? In the normal situation, a company first adds their DW to an existing system. Then they find that the DW doesn't make a good neighbor and buy a separate server. The DW typically does a LOT of full-table scans, so if

RE: 8.1.7.2 or 8.1.7.4

8.1.7.4 on TRU64 introduced a listener problem (bug 2462125 / 1426414). I am testing the one-off patch 1426414 now. It looks like the problem is fixed. -Original Message- Sent: Friday, October 11, 2002 3:12 PM To: Multiple recipients of list ORACLE-L I'm investigating an 8.1.7 upgrade

RE: Oracle9i upgrade exam - Recommended books/material? (Borderin

Excellent idea but try to cover more for OCP candidates for 10i upgrade.. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 11 Oct 2002 07:53:42 -0800 Thanks a bunch! I'm Looking forward to 10i!! Robert G. Freeman - Oracle OCP

RE: [Q] ORACLE 9.2 and different version of client?

It also depends on the character set being used on the database server. With 9i, there are a few new character sets. Older client will probably not be able to deal with these new character sets. I think there is a patch for the 8i client to handle new character sets, however. HTH, Gerardo

Re: 8.1.7.2 or 8.1.7.4

On Fri, Oct 11, 2002 at 11:12:10AM -0800, DENNIS WILLIAMS wrote: I'm investigating an 8.1.7 upgrade also. My impression is that the stability may vary by platform, so it might be helpful to specify the platform that is involved. I'm on HP/Compaq Tru64 myself. My dec unix 4.0f would not stay

RE: Advice needed on move to Sun 15K (losing spindles)

Title: RE: Advice needed on move to Sun 15K (losing spindles) Lets say a guy only has one finger on each hand to tie his shoe (mirroring). If he had five fingers (striping) he can accomplish the job quite a bit faster. Now give him 1000 shoes to tie and listen to him bitch about how he could

Session Data Unit and tcp.nodelay

We have third party CAD application called VPM which we are using to organize 3d engineering models. It uses an Oracle database to store some information on locations of models and relationships between parts. We are having some performance problems which seem to point to the database access.

RE: Oracle9i upgrade exam - Recommended books/material? (Borderin

Actually there were some specific reasons we *didn't* cover all the OCP stuff in that book. It's a long story RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah,

Re: 8.1.7.2 or 8.1.7.4

We are running Solaris 6. Currently 8.1.6.3 Planning for 8.1.7 Management is pressing for the patch in the same go due to downtime issues. -Rachna - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 11, 2002 3:12 PM I'm investigating

RE: Session Data Unit and tcp.nodelay

are they similar 1700 sql statements differing by literals. if ur db is 8.x can u use cursor_sharing? hv u tried 10046 tracing? myabe the parse time for these 1700 sql is more than the perceived tcp gain u r trying to achieve. -Original Message- From: Schauss, Peter [mailto:[EMAIL

RE: Oracle9i upgrade exam - Recommended books/material? (Borderin

Thanks...It was just an ideaIf possible then think of it... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 11 Oct 2002 12:09:20 -0800 Actually there were some specific reasons we *didn't* cover all the OCP stuff in that

RE: Advice needed on move to Sun 15K (losing spindles)

Well, there are Gaja's papers : Proactive Storage Management - A Method to Predictable System Performance, and Implementing RAID on Oracle systems available at http://www.quest.com/whitepapers. Scan the page for Title and for not Gaja's name. - Kirti -Original Message- Sent: Friday,

RE: Advice needed on move to Sun 15K (losing spindles)

Check out www.hotsos.com/dnloads/1.Littlefield2000.01.03-Specs.pdf, written a couple of years ago by Jim Littlefield of Real Networks. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Oct 15-17 Dallas, Dec 9-11 Honolulu - 2003 Hotsos Symposium on

RE: Advice needed on move to Sun 15K (losing spindles)

Yes, it's entirely separate CPUs and disks. If I can believe the Sun rep (ehem) there should be no interference. -Original Message- Sent: Friday, October 11, 2002 3:30 PM To: Multiple recipients of list ORACLE-L Jay - Will your server partitioning protect the OLTP users from the DW

Re:Session Data Unit and tcp.nodelay

Peter, I've messed with TDU and SDU over the years with mixed and often unpredictable results. TCP.NODELAY has caused some very quirky problems with applications especially when mixed with large values for TDU/SDU. If you do set TDU/SDU set them equal to each other, doing otherwise has

RE: Advice needed on move to Sun 15K (losing spindles)

Thanks, I'm reading the first one now. Jay -Original Message- Sent: Friday, October 11, 2002 3:19 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Well, there are Gaja's papers : Proactive Storage Management - A Method to Predictable System Performance, and Implementing RAID on Oracle

Re: Session Data Unit and tcp.nodelay

Yes, Please do so ! Later versions of Oracle have this already enabled by default I believe. Depending on the delay, the savings/improvements can be great ! First set tcp.nodelay = true, then worry about the SDU/TDU settings. The thing to remember here is that the server and the client need

RE: Advice needed on move to Sun 15K (losing spindles)

One thing that should be made clear: Never, ever, stripe with parity (i.e. RAID 5, etc.) unless you are force, at gunpoint, to do it. That is BAD. Your database will run faster on an abacus ... well ... maybe a slide rule. -Original Message- Yes, it's entirely separate CPUs and

RE: Help on ORA-03113 error and 7445 in the trace file.

Title: RE: Win2000/8.1.7.3.0/SQL Update ... we dont see this problem if we rlogin to the server via a Sun Solaris client box. -Original Message-From: Johnson, Michael Sent: Friday, October 11, 2002 10:38 AMTo: '[EMAIL PROTECTED]'Subject: Help on ORA-03113 error and 7445 in

Re: Session Data Unit and tcp.nodelay

Peter, You'll probably get best results by continuing down the path you've begun. You had SQL-traced a process -- have you used TKPROF to aggregate the information into something useful? Reading a .trc file from SQL trace for performance is like reading a person's genome to find their gender;

Help on ORA-03113 error and 7445 in the trace file.

Title: RE: Win2000/8.1.7.3.0/SQL We are getting a intermittent problem that happens both from a SQL prompt or if we execute off of a package. We can telnet in or go through the TNS side of things. It doesnt seem to matter. Sun Solaris 2.8 Oracle 8.1.7.4 Here is the scenario

RE: Oracle list for developers ??

There is the ODTUG list, it is intended for paying members but you may be able to subscribe anyway. Developer List Server: ODTUG-DEV2K-L In order to make changes to your subscription, unsubscribe from the list or change your subscription characteristics, send E-mail to: [EMAIL PROTECTED]--

Thanks - Oracle list for developers ??

Thanks to all who responded helpfully. SY. -Original Message- From: [EMAIL PROTECTED] [mailto:Jared.Still;radisys.com] Sent: Thursday, October 10, 2002 7:08 PM To: [EMAIL PROTECTED] Cc: [EMAIL

RE: Database Trigger not fireing In Delete Mode

Title: RE: Avoding Mutation of Table trigger This can be simply solved byeliminating the WHEN condition on the trigger and encapsulating that condition as part of a If .. THEN ... END IF statement. Raj __ Rajendra Jamadagni MIS, ESPN

Re: Unix script to stop pwd-protected listener

Hi, we have lsnrctl with 750 and listener.ora with 600 permissions and everything runs fine. For job stopping process you can then use the encrypted password wirtten in listener.ora. HTH, Mike [EMAIL PROTECTED] wrote: Hi, Solaris 8, Oracle 9i listener It seems that anyone who

RE: Re[2]: sequence numbers

Mark... If this were the MOST serious design flaw in the whole mess, I wouldn't care so much. There is a point where you just shut up (gee, I have been TOLD to do that in meetings) and wait till it breaks (or worse, one of our clients buys it and we have to TRY to implement). I am the funny

Re: OT: IBM Ultrium tape drive for AIX

We have LTO 3580 on IBM P660 server. The backup speed normally between 9 Mb - 13 Mb/per second. From: Rahul [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: OT: IBM Ultrium tape drive for AIX Date: Thu, 10 Oct 2002 22:43:21 -0800

RE: Oracle list for developers ??

Harry, did you look in Technet.oracle.com? There is a Forum area for asking questions, answered by Oracle staff. Not as good as a Listserv like this, but at least it is something. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, October 10, 2002 6:44 PM

trigger and stored procedure

Hi, Can someone pls help me with the following problem? thanks harsh Requirement: Whenever a row is deleted from a database table, the client application shall get the deletion details. Based on the studies done the following approach is thought to be more appropriate. 1. Create a trigger

Controlling Users Logons

Hello Listers, I was asked by a co-worker if there was a way in Oracle to prevent users from connecting to the databases if the same OSUSER has already a created a specified number of sessions to a particular instance. We discussed profiles and resource limits etc. However, the requirement is

trigger and stored procedure related

Hi, Can someone pls help me with the following problem? thanks harsh Requirement: Whenever a row is deleted from a database table, the client application shall get the deletion details. Based on the studies done the following approach is thought to be more appropriate. 1. Create a trigger

RE: Re[2]: sequence numbers

April, What can I say? Ouch! I feel your pain. I've been trapped in some pretty ridiculous situations too. (Though, I think you have me beat! A 37 column primary key?? Really??) Well, you at least seem to have the proper attitude. ;-) Without a sense of humor, I'm afraid you'd go insane in

[Q] ORACLE 9.2 and different version of client?

we plan to upfrade our database from ORACLE 8.1.7 to 9.2. The database on SUn Solaris server. My question are: 1. will following version of ORACLE client(on PC) work with ORACLE 9.2 server? 7.3.4 client 8.0.5 client 8.1.6 client 2. can ORACLE

Re: Controlling Users Logons

Could you use machine from v$session? [EMAIL PROTECTED] 10/11/02 09:48AM Hello Listers, I was asked by a co-worker if there was a way in Oracle to prevent users from connecting to the databases if the same OSUSER has already a created a specified number of sessions to a particular instance.

Re: How to see it?

The light? The light at the end of the tunnel? The forest for the trees? The ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

Re: O/T - Disk IOs

vxprint can be used to determine which drives make up a filesystem. Jared Jenner Mike [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/11/2002 11:08 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:

RE: 8.1.7.2 or 8.1.7.4

Title: Message There is a new listener bug detailed in security alert 42 which allows someone to execute a Denial of Service attack by crashing or hanging the listener. For Oracle 8i I only see patches at the 8.1.7.4 level. Interestingly, the 8.0 database listener is notvulnerable. Ian

RE: How to see it?

You must have faith grasshopper... the substance of things hoped for, the evidence of things not seen. -Original Message- Sent: Friday, October 11, 2002 3:49 PM To: Multiple recipients of list ORACLE-L Importance: High The light? The light at the end of the tunnel? The forest for the

RE: Advice needed on move to Sun 15K (losing spindles)

Thank you very much! I can tell what I'll be reading this weekend :). With highlighter in hand... Jay -Original Message- Sent: Friday, October 11, 2002 4:31 PM To: Multiple recipients of list ORACLE-L Check out www.hotsos.com/dnloads/1.Littlefield2000.01.03-Specs.pdf, written a

RE: Advice needed on move to Sun 15K (losing spindles)

Fortunately my SA believes that so we were able to present a united front at the presentation (and yes, the Sun rep said that with a large enough cache RAID 5 works just as well as 1+0 - which is what we would be using). Jay Miller -Original Message- Sent: Friday, October 11, 2002 4:54

RE: O/T - Disk IOs

Jared - Which system is that? I tried it on Solaris and Tru64, but it wasn't there. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, October 11, 2002 4:54 PM To: Multiple recipients of list ORACLE-L vxprint can be used to determine which drives

Re: 8.1.7.2 or 8.1.7.4

On Fri, Oct 11, 2002 at 12:09:21PM -0800, Rachna Vaidya wrote: We are running Solaris 6. Currently 8.1.6.3 Planning for 8.1.7 Management is pressing for the patch in the same go due to downtime issues. My solaris 5.8/8.1.7.4 is a dream. Up since 7/1/2002 without a burp. A little slow wrt

RE: O/T - Disk IOs

It's part of Veritas volume manager. DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/11/2002 03:48 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: O/T - Disk IOs Jared - Which

RE: O/T - Disk IOs

vxprint comes with Veritas. -Original Message- Sent: Friday, October 11, 2002 6:49 PM To: Multiple recipients of list ORACLE-L Jared - Which system is that? I tried it on Solaris and Tru64, but it wasn't there. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original

RE: [Q] ORACLE 9.2 and different version of client?

How were you able to connect INTERNAL or SYS AS SYSDBA from a remote ORACLE_HOME ? INTERNAL from the same O_H didn't require a passsword, per the default behaviour. SYS AS SYSDBA from a remote O_H requires a Password from the password file. Does your developer has the SYS password ? Hemant At