Re: Monitoring occurence of snaphot too old
Well, 1555 happens when the query is unable to construct a read consistent version because rollback segment blocks have been reused by other transactions. The only solution is to a) have sufficiently large rollback segments so that a transaction can get unused rollback segment space without reusing recently allocated space. b) NOT have very long running queries. Conceptually, in my opinion, the infamous "snapshot too old" comes from mixing DW and OLTP functions in the same database. A good practice is to have a "reporting database" as a separate instance and populate it in some way (replication, SRDF, standby, self written programs). The reporting database can then be re-indexed with bitmap indexes and used for reports only. Things like that are (now this is for DW purists) called ODS or opeational data stores and are populated approximately once a week. Only very small daily reports are run against the main OLTP database. If you separate your functions like that, ora-1555 will become a distant memory. On 2002.08.02 19:23 [EMAIL PROTECTED] wrote: > Hi, > > Yes, it is 8i..I was more interested in catching snapshot too old > before it > happens..does not seem possible.. > > But, my thanks to everyone who responded.. > > Mohammed Ahsanuddin > Oracle DBA > > > > -Original Message- > Sent: Friday, August 02, 2002 2:19 PM > To: Multiple recipients of list ORACLE-L > > > Yes. I didn't see the version it the other guy's post. > Was it 8i? > > > -Original Message- > > From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]] > > Sent: Friday, August 02, 2002 1:54 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: Monitoring occurence of snaphot too old > > > > > > Isn't the UNDO_RETENTION parameter a new one for 9i and does > > not exist in 8.x and lower. > > > > Thanks, > > > > Dave > > > > -Original Message- > > Sent: Friday, August 02, 2002 12:05 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Just set the UNDO_RETENTION parameter to 4 hours and forget > > about the 'snapshot too old'. It's no longer happening. > > > > > -Original Message- > > > From: [EMAIL PROTECTED] > > > [mailto:[EMAIL PROTECTED]] > > > Sent: Friday, August 02, 2002 12:14 PM > > > To: Multiple recipients of list ORACLE-L > > > Subject: Monitoring occurence of snaphot too old > > > > > > > > > Dear List members, > > > > > > I was wondering if there is a way to monitor the database and > > > tell if there > > > is a possiblility of snapshot too old error occurence. > > > > > > Any input is highly appreciated.. > > > > > > Thanks > > > > > > Mohammed Ahsanuddin > > > Oracle DBA > > > > > > -- > > > 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 Diego, California-- Public Internet access / > > Mailing Lists > > > > > > > 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.com > > -- > > Author: Gogala, Mladen > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing > Lists > > > > 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.com > > -- > > Author: Farnsworth, Dave > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing > Lists > > > > 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.com > -- > Author: Gogala, Mladen > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (8
Re: LINUX and Oracle Corp.
RH 2.7 with Oracle 8 and 9 wow!!! where did you get these beasts to work together? How come Dell Intels outperform Suns. I don't get it? ltiu On Friday 02 August 2002 20:03, you wrote: > Mladen and all, > > I have a Dell 2500 with 2 1GHZ Pentium III's, 2 Gig of RAM > and 3 30 Gig RAID1 disk on SCSI. > > It performs rather well, and will run circles around a lightly loaded > 2 CPU Sun 220R we use in production. > > This is my own personal little DBA playground, running RH 2.7, Oracle > 8.1.7 and 9.2. :) > > Jared > > On Thursday 01 August 2002 09:03, Gogala, Mladen wrote: > > Yes and no. If you put in a decent new Adaptec (AHA) SCSI III adapter, > > it will be capable of working with a 133MHZ or better motherboard and IO > > will be fast, even faster then on an expensive SUN 4xx servers. Of > > course, we must be aware that people are putting sound, webcams, game > > ports and TV cards into their PCs ant that is never a good idea for a > > database server. Personally, I think that a big SMP PC with a few gigs of > > RAM and decent SCSI or FC/AL disk farm can easily service 2 or 3 hundred > > users. One would still need approximately $10,000 to assemble a piece > > like that, but before that, the prices used to have more zeroes. Of > > course, there is that little added cost of Oracle RDBMS which will be 2 > > times as expensive as the HW it's > > running on and that is really what people don't like. > > > > > -Original Message- > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > > Sent: Thursday, August 01, 2002 6:33 AM > > > To: Multiple recipients of list ORACLE-L > > > Subject: RE: LINUX and Oracle Corp. > > > > > > > > > > > > > > > -- "Cabansay, Yoyong" <[EMAIL PROTECTED]> on 08/01/02 > > > 02:19:10 -0800 > > > > > > > regarding the above topic but on a different note, anyone > > > > > > here on the > > > > > > > list that is on an Oracle/HP-UX OS platform for backend and > > > > > > 9iAS/Linux > > > > > > > on the middle tier? problems encountered? gotchas? stories > > > > > > to tell. we > > > > > > > are looking at this configuration right now for our Oracle Apps 11i. > > > > > > Main issue w/ most linux boxes is hardware: PC's stink at > > > I/O due to the Intel motherboard design. The net result > > > tends to be a transfer bottleneck. > > > > > > -- > > > Steven Lembark 2930 W. Palmer > > > Workhorse Computing Chicago, IL 60647 > > >+1 800 762 1582 > > > -- > > > 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 Diego, California-- Public Internet access / Mailing Lists > > > > > > 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.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Live Webcast: The death of the buffer cache hit ratio
Well no Jacques, here's your chance to see what the competition is up to. :) Jared On Friday 02 August 2002 15:59, Jacques Kilchoer wrote: > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > > > Ok, everybody, let's show up in support of Anjo. > > > > This should be a great presentation. > > > > Sorry if someone has already posted this to the list today, I > > just haven't > > had time to read it yet today. > > But he's the competition! :) Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1" Content-Transfer-Encoding: 7bit Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: List archives on line?
On Thursday 01 August 2002 17:23, Reardon, Bruce (CALBBAY) wrote: > Try the following: > http://www.fatcity.com/ListGuru/my.php > http://www.mail-archive.com/oracle-l%40fatcity.com/<-- this has them > threaded http://faqchest.dynhost.com/prgm/oracle-l/ > > Jared - maybe we could get these 3 added to the mail signatures or added to > a section at orafaq? Not a bad idea. I'll see if I can remember how to do it this weekend. :) Jared > > Regards, > Bruce Reardon > > -Original Message- > Sent: Friday, 2 August 2002 6:51 > > Hi, > > Are there any list archives online ? Alot of some interesting threads > are coming throught to me blank (probably my server is blocking > content) but I still want to read them. > > Please let me know. > > Thanks, > > Hannah -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: LINUX and Oracle Corp.
Mladen and all, I have a Dell 2500 with 2 1GHZ Pentium III's, 2 Gig of RAM and 3 30 Gig RAID1 disk on SCSI. It performs rather well, and will run circles around a lightly loaded 2 CPU Sun 220R we use in production. This is my own personal little DBA playground, running RH 2.7, Oracle 8.1.7 and 9.2. :) Jared On Thursday 01 August 2002 09:03, Gogala, Mladen wrote: > Yes and no. If you put in a decent new Adaptec (AHA) SCSI III adapter, > it will be capable of working with a 133MHZ or better motherboard and IO > will be fast, even faster then on an expensive SUN 4xx servers. Of course, > we must be aware that people are putting sound, webcams, game ports and TV > cards into their PCs ant that is never a good idea for a database server. > Personally, I think that a big SMP PC with a few gigs of RAM and decent > SCSI or FC/AL disk farm can easily service 2 or 3 hundred users. One would > still need approximately $10,000 to assemble a piece like that, but before > that, the prices used to have more zeroes. Of course, there is that little > added cost of Oracle RDBMS which will be 2 times as expensive as the HW > it's > running on and that is really what people don't like. > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, August 01, 2002 6:33 AM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: LINUX and Oracle Corp. > > > > > > > > > > -- "Cabansay, Yoyong" <[EMAIL PROTECTED]> on 08/01/02 > > 02:19:10 -0800 > > > > > regarding the above topic but on a different note, anyone > > > > here on the > > > > > list that is on an Oracle/HP-UX OS platform for backend and > > > > 9iAS/Linux > > > > > on the middle tier? problems encountered? gotchas? stories > > > > to tell. we > > > > > are looking at this configuration right now for our Oracle Apps 11i. > > > > Main issue w/ most linux boxes is hardware: PC's stink at > > I/O due to the Intel motherboard design. The net result > > tends to be a transfer bottleneck. > > > > -- > > Steven Lembark 2930 W. Palmer > > Workhorse Computing Chicago, IL 60647 > >+1 800 762 1582 > > -- > > 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 Diego, California-- Public Internet access / Mailing Lists > > > > 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.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: OT: Windows 2000 SP3 License Agreement
I hope PostgresSQL and MySQL will catch up before that happens On Friday 02 August 2002 17:58, you wrote: > I wouldn't be one bit surprised if Oracle came out with something similar. > > Ian MacGregor (X3528) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA
Dan, you as someone who figures out how things work? Nah :) I'm STILL trying to understand the deep detail you went into on the undo segments. Okay my two cents on this. Tools are great IF you know their limitations. And the only way to know the limitations is to know how to do it manually. For years I supported production systems. While in the office, I had the advantage of many of the monitoring tools. If there was a problem in the middle of the night, the dial-up line didn't really support my running the tool I also don't always have the luxury of time to invent that wheel. Too few DBAs with too many projects means I'll take whatever tools I can get. On the other hand, I have a developer here, senior person, who moans and whines when she can't use SQL Navigator or PL/SQL Debugger to write code and test it. I mean, you CAN use SQL*Plus to do this but you'd think we were putting her on the rack when she has to. Rachel --- "Fink, Dan" <[EMAIL PROTECTED]> wrote: > Jared, > I agree with your advantages. I am a big believer in the last point. > If you don't know how stuff works, you are helpless in the absence of > the > tool (I'm dealing with this frustration right now...not me, but > someone else > who can't live without a certain tool). I am a big believer in > figuring out > how things work (a few on the list can vouch for me on that one...), > but it > is not always the most economical method to manage many systems. > There comes > a point where you don't need to reinvent the wheel and update it for > each > new release. I don't have access to the advance releases and all > platforms > of the oracle server, so I am limited in what I can do, even if I had > the > time. > Any tool, whether it is GUI or TUI (like a shell script that runs in > a cron and emails), can cause disconnect. The fault lies not in the > tool, > but in the user. Tools don't cause disconnects, People do... > > Dan "Waiting for Perl for Oracle DBA's to hit the shelves at SoftPro" > Fink > > -Original Message- > Sent: Friday, August 02, 2002 11:00 AM > To: Multiple recipients of list ORACLE-L > > > On Thursday 01 August 2002 09:45, Fink, Dan wrote: > > Case in point, many databases with > > few dbas. Logging in each morning to each database and checking > status and > > metrics is very inefficient. By the time all the databases are > checked, > the > > day is over. This leaves no time to diagnose and repair problems. > Scheduled > > jobs (cron/AT/dbms_job) that query the database/logs and send email > is > more > > effecient. At this point you have a tool. A monitoring tool, > properly > > architected and configured, can assist greatly by allowing the dbas > to > > focus on preventing problems and not wasting time determining that > there > is > > nothing to worry about. > > > > Dan, > > Advantages of rolling your own: > > * they do what you want, and only what you want > * if your needs change, you can modify them > * you don't have to deal with tech support to fix your tools > * you have to learn how stuff works to monitor it > > Well, that last bullet point seems to be temporary with me, I > seem to forget stuff after not being close to it for awhile. > > That also serves to point out what a disconnect GUI tools are. > > > > You want some tools? Reserve your copy of "Perl for Oracle DBA's". > :) > > > > Jared > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jared Still > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > 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.com > -- > Author: Fink, Dan > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > 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). __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECT
OT: Windows 2000 SP3 License Agreement
I'm informed it contains the following: "You acknowledge and agree that Microsoft may automatically check the version of the OS Product and/or its components that you are utilizing and may provide upgrades or fixes to the OS Product that will be automatically downloaded to your computer." Well I guess we won't need as many Windows SA's I'm right at ease at having my desktop communicate with the mothership at anytime. After all Microsoft so narrowly defines "OS Product". I wouldn't be one bit surprised if Oracle came out with something similar. Ian MacGregor (X3528) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA
SoftPro doesn't seem to know about it yet. However, Bookpool.com, Amazon.com, Powells.com and of course, Ora.com all seem to know about it. Jared "Fink, Dan" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/02/2002 02:28 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA Jared, I agree with your advantages. I am a big believer in the last point. If you don't know how stuff works, you are helpless in the absence of the tool (I'm dealing with this frustration right now...not me, but someone else who can't live without a certain tool). I am a big believer in figuring out how things work (a few on the list can vouch for me on that one...), but it is not always the most economical method to manage many systems. There comes a point where you don't need to reinvent the wheel and update it for each new release. I don't have access to the advance releases and all platforms of the oracle server, so I am limited in what I can do, even if I had the time. Any tool, whether it is GUI or TUI (like a shell script that runs in a cron and emails), can cause disconnect. The fault lies not in the tool, but in the user. Tools don't cause disconnects, People do... Dan "Waiting for Perl for Oracle DBA's to hit the shelves at SoftPro" Fink -Original Message- Sent: Friday, August 02, 2002 11:00 AM To: Multiple recipients of list ORACLE-L On Thursday 01 August 2002 09:45, Fink, Dan wrote: > Case in point, many databases with > few dbas. Logging in each morning to each database and checking status and > metrics is very inefficient. By the time all the databases are checked, the > day is over. This leaves no time to diagnose and repair problems. Scheduled > jobs (cron/AT/dbms_job) that query the database/logs and send email is more > effecient. At this point you have a tool. A monitoring tool, properly > architected and configured, can assist greatly by allowing the dbas to > focus on preventing problems and not wasting time determining that there is > nothing to worry about. > Dan, Advantages of rolling your own: * they do what you want, and only what you want * if your needs change, you can modify them * you don't have to deal with tech support to fix your tools * you have to learn how stuff works to monitor it Well, that last bullet point seems to be temporary with me, I seem to forget stuff after not being close to it for awhile. That also serves to point out what a disconnect GUI tools are. You want some tools? Reserve your copy of "Perl for Oracle DBA's". :) Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: DUAL revisited
Sorry brain dead. Been working day and night for 5 days. Not much sleep. Makes perfect sense now. Kathy -Original Message- Sent: Friday, August 02, 2002 4:38 PM To: Multiple recipients of list ORACLE-L Correct. DUAL is a table owned by SYS for which SELECT permissions have been granted to PUBLIC. V$DUAL is a view on a special "fixed" table named X$DUAL. The SELECT permissions here are granted on the *view*; they cannot be granted on a fixed table (i.e. X$ table). So, you're queries succeed because they are querying the view, which is able to query the fixed table because the view belongs to SYS and inherits the permissions of SYS (i.e. definer's rights). However, EXPLAIN PLAN tries to access the underlying table and fails, because you are running EXPLAIN PLAN as a user other than SYS... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, August 02, 2002 3:03 PM > But I don't get this error when I query from dual just from the new v$dual. > > Kathy > > -Original Message- > Sent: Friday, August 02, 2002 12:54 PM > To: Multiple recipients of list ORACLE-L > > > ..if you're going to query from an account other than SYS, then please SET > AUTOTRACE TRACEONLY STATISTICS (instead of SET AUTOTRACE ON) so it doesn't > try to do an EXPLAIN PLAN. You cannot grant SELECT on X$ tables to anyone > other than SYS, which affects EXPLAIN PLAN also... > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Friday, August 02, 2002 11:15 AM > > > > I followed the instructions but I get the error below. I do not get the > same error when I select from dual. And yes I did to the public grant. And > other clues? DB 8.1.7.3 > > > > Thanks Kathy > > > > Execution Plan > > -- > > ERROR: > > ORA-01039: insufficient privileges on underlying objects of the view > > > > > > SP2-0612: Error generating AUTOTRACE EXPLAIN report > > > > Statistics > > -- > > 0 recursive calls > > 0 db block gets > > 0 consistent gets > > 0 physical reads > > 0 redo size > > 371 bytes sent via SQL*Net to client > > 426 bytes received via SQL*Net from client > > 2 SQL*Net roundtrips to/from client > > 0 sorts (memory) > > 0 sorts (disk) > > 1 rows processed > > -Original Message- > > Sent: Friday, August 02, 2002 8:13 AM > > To: Multiple recipients of list ORACLE-L > > > > > > I've been reading the thread on DUAL vs X$DUAL, read the referenced > article > > and tried some testing on our system. I do a simple select from DUAL and I > > get the same statistics as were in the article, but sometimes I also get 1 > > memory sort. Does anyone know why this would be? And if this is true, that > > really makes me want to change over to X$DUAL. Also, what is the consensus > > about creating a view for DUAL that references X$DUAL? I'm running the > > Oracle Application and cannot change all of their code to use something > > other than DUAL, and there is a lot of it. > > > > Here are the statistics on the select. Notice the difference between the > > first vs repeat of the same seelct. > > > > Connected to: > > Oracle8i Enterprise Edition Release 8.1.7.1.1 - Production > > With the Partitioning option > > JServer Release 8.1.7.1.1 - Production > > > > SQL> set autotrace traceonly > > SQL> select 'y' from dual; > > > > Execution Plan > > -- > >0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1) > >10 TABLE ACCESS (FULL) OF 'DUAL' (Cost=2 Card=1) > > > > Statistics > > -- > > 0 recursive calls > > 4 db block gets > > 1 consistent gets > > 0 physical reads > > 0 redo size > > 361 bytes sent via SQL*Net to client > > 425 bytes received via SQL*Net from client > > 2 SQL*Net roundtrips to/from client > > 1 sorts (memory) > > 0 sorts (disk) > > 1 rows processed > > SQL> / > > > > Execution Plan > > -- > >0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1) > >10 TABLE ACCESS (FULL) OF 'DUAL' (Cost=2 Card=1) > > > > Statistics > > -- > > 0 recursive calls > > 4 db block gets > > 1 consistent gets > > 0 physical reads > > 0 redo size > > 361 bytes sent via SQL*Net to client > > 425 bytes received via SQL*Net from client > > 2 SQL*Net roundtrips to/from client > > 0 sorts (memory) > > 0 sorts (disk) > > 1 rows processed >
Re: parse to execute ration
Looks like you found another booboo in the docs. The docs also tell you things like 'the database must be in nomount state to rename datafiles'. When renaming datafiles in a closed database, the control file must be mounted. There's probably more... Jared "BigP" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/01/2002 02:53 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:parse to execute ration Parse/Execution Ratio Number of parses divided by the number executions per statement. Individual number of parses. Number of executions. The count of parses to executions should be as close to one as possible. If there are a high number of parses per execution then the statement has been needlessly reparsed. This could indicate the lack of use of bind variables in SQL statements or poor cursor reuse. Hi list , In oracle doc it says parse to execute ratio is to be close to one . I dont understand that . I thought there should be more executes per parse . So it should be close to 0. am I wrong ? Thanks , bp -- 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 Diego, California-- Public Internet access / Mailing Lists 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: Monitoring occurence of snaphot too old
There is always a chance of ORA-1555 if duhvelopers are involved. Seriously, this error is mostly caused by bad programming practice, and lack of knowledge of how the database works. See "Cats, Dogs and ORA-1555" at http://www.evdbt.com/papers.htm Jared, the Daft [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/02/2002 09:13 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Monitoring occurence of snaphot too old Dear List members, I was wondering if there is a way to monitor the database and tell if there is a possiblility of snapshot too old error occurence. Any input is highly appreciated.. Thanks Mohammed Ahsanuddin Oracle DBA -- 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 Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Massive update troubles
Don, The biggest problem you have is you are working with duhvelopers. There are ways to write your code to allow testing without ridiculous actions like 'alter system kill session' every time your program doesn't do what you want during development. Such as: * Using a variable commit point that is set differently for development than for production. * Using a 'Development flag' for critical section of the code that allow you to check for actions to take. For instance, you may have a one row table that contains instructions such as 'STOP RIGHT NOW!', that are only checked when the development flag is on. Coupled with a lower commit point in devekopment, this makes stopping your program somewhat simpler, and is a bit more elegant than 'alter system kill session'. * Outputting diagnostic information to a DBMS PIPE when the DEBUG_FLAG is set, so that realtime diagnostics can be read from another process reading the pipe. etc, etc, etc. Get your company to buy them the following books, and make them read them: Code Complete http://www.amazon.com/exec/obidos/ASIN/1556154844 This is written for C, but is full of good habits for any language. Writing Solid Code: http://www.amazon.com/exec/obidos/ASIN/1556155514 Ignore the reviews on Amazon for this book. It's not as good as Code Complete, but still pretty good. Oracle PL/SQL Programming http://www.amazon.com/exec/obidos/ASIN/1565923359 Jared PS. I'm not being cynical, really I'm not. :) Don Jerman <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/01/2002 02:14 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Massive update troubles I have a data conversion team working on our financial data, prepping it for load into SAP. My concept for the conversion process was to download the flat files, run programs written in C or Perl to transform the data, then use SQL*Loader to load them into relational tables for constraint testing and general analysis, prior to export to the SAP system. At some point early on I lost control, and this mutated into: download the flat files, load them into Oracle, run stored procedures to transform the data through 2 or 3 stages to a new schema for SAP. Still ok, you're thinking. But -- now we're running more than a couple hundred thousand rows at the time, and the developers are still tweaking the process (because the SAP requirements are slowly mutating -- another issue). Frequently the developers will stop a long running query with ALTER SESSION KILL -- this is working but often takes a very long time to roll back. Well, there's the rub -- this is a PC system, and the developers frequently want to make a tweak to their program and re-run it. This puts a tremendous load on what the PC isn't good at -- I/O. So I wind up with a frantic developer on the phone "the Oracle server's locked up!" and sure enough, he's right -- there's so much going on in there you can't do anything that requires a disk access. The evolved response is shutdown abort, startup mount, recover, open. This always works and always takes about 3 minutes. Naturally, I've moved them to their Very Own server, so that this doesn't disrupt other work. Can anyone turn their diagonstic eyes on this situation and suggest a better method for me to either limit the damage or recover from the problem? Or even a good method for analyzing the problem, given that we haven't the downtime to wait for all processes to complete (once in this state, a weekend can pass without successfully ending whatever the database is doing). djerman.vcf Description: Binary data
Re: DUAL revisited
Correct. DUAL is a table owned by SYS for which SELECT permissions have been granted to PUBLIC. V$DUAL is a view on a special "fixed" table named X$DUAL. The SELECT permissions here are granted on the *view*; they cannot be granted on a fixed table (i.e. X$ table). So, you're queries succeed because they are querying the view, which is able to query the fixed table because the view belongs to SYS and inherits the permissions of SYS (i.e. definer's rights). However, EXPLAIN PLAN tries to access the underlying table and fails, because you are running EXPLAIN PLAN as a user other than SYS... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, August 02, 2002 3:03 PM > But I don't get this error when I query from dual just from the new v$dual. > > Kathy > > -Original Message- > Sent: Friday, August 02, 2002 12:54 PM > To: Multiple recipients of list ORACLE-L > > > ..if you're going to query from an account other than SYS, then please SET > AUTOTRACE TRACEONLY STATISTICS (instead of SET AUTOTRACE ON) so it doesn't > try to do an EXPLAIN PLAN. You cannot grant SELECT on X$ tables to anyone > other than SYS, which affects EXPLAIN PLAN also... > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Friday, August 02, 2002 11:15 AM > > > > I followed the instructions but I get the error below. I do not get the > same error when I select from dual. And yes I did to the public grant. And > other clues? DB 8.1.7.3 > > > > Thanks Kathy > > > > Execution Plan > > -- > > ERROR: > > ORA-01039: insufficient privileges on underlying objects of the view > > > > > > SP2-0612: Error generating AUTOTRACE EXPLAIN report > > > > Statistics > > -- > > 0 recursive calls > > 0 db block gets > > 0 consistent gets > > 0 physical reads > > 0 redo size > > 371 bytes sent via SQL*Net to client > > 426 bytes received via SQL*Net from client > > 2 SQL*Net roundtrips to/from client > > 0 sorts (memory) > > 0 sorts (disk) > > 1 rows processed > > -Original Message- > > Sent: Friday, August 02, 2002 8:13 AM > > To: Multiple recipients of list ORACLE-L > > > > > > I've been reading the thread on DUAL vs X$DUAL, read the referenced > article > > and tried some testing on our system. I do a simple select from DUAL and I > > get the same statistics as were in the article, but sometimes I also get 1 > > memory sort. Does anyone know why this would be? And if this is true, that > > really makes me want to change over to X$DUAL. Also, what is the consensus > > about creating a view for DUAL that references X$DUAL? I'm running the > > Oracle Application and cannot change all of their code to use something > > other than DUAL, and there is a lot of it. > > > > Here are the statistics on the select. Notice the difference between the > > first vs repeat of the same seelct. > > > > Connected to: > > Oracle8i Enterprise Edition Release 8.1.7.1.1 - Production > > With the Partitioning option > > JServer Release 8.1.7.1.1 - Production > > > > SQL> set autotrace traceonly > > SQL> select 'y' from dual; > > > > Execution Plan > > -- > >0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1) > >10 TABLE ACCESS (FULL) OF 'DUAL' (Cost=2 Card=1) > > > > Statistics > > -- > > 0 recursive calls > > 4 db block gets > > 1 consistent gets > > 0 physical reads > > 0 redo size > > 361 bytes sent via SQL*Net to client > > 425 bytes received via SQL*Net from client > > 2 SQL*Net roundtrips to/from client > > 1 sorts (memory) > > 0 sorts (disk) > > 1 rows processed > > SQL> / > > > > Execution Plan > > -- > >0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1) > >10 TABLE ACCESS (FULL) OF 'DUAL' (Cost=2 Card=1) > > > > Statistics > > -- > > 0 recursive calls > > 4 db block gets > > 1 consistent gets > > 0 physical reads > > 0 redo size > > 361 bytes sent via SQL*Net to client > > 425 bytes received via SQL*Net from client > > 2 SQL*Net roundtrips to/from client > > 0 sorts (memory) > > 0 sorts (disk) > > 1 rows processed > > SQL> > > > > Thanks for your input. > > > > > > John Zoltak > > North American Mfg Co > > 4455 East 71st Street > > Cleveland Ohio 44105 > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > >
Re: List archives on line?
Try www.fatcity.com. :) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/01/2002 01:51 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:List archives on line? Hi, Are there any list archives online ? Alot of some interesting threads are coming throught to me blank (probably my server is blocking content) but I still want to read them. Please let me know. Thanks, Hannah -- 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 Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Difficulty compiling forms ported from NT to UNIX
Yes, I've had a similar experience implementing OAS. Move from NT to Solaris. I did it all by hand. No utilities that I'm aware of to correct it. Have you checked MetaLink? Jared "Cohen, Erik" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/02/2002 09:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Difficulty compiling forms ported from NT to UNIX Please forgive the post (and cross-post) to DBA forums, but due to firewall upgrades, I am no longer able to access the newsgroups. If anyone has had similar experiences to the one described below, I would appreciate any guidance in finding a utility work-around. TIA. Designer generated Forms (FMBs) are moved to UNIX platform along with the attached libraries (llbs). FMBs are not compiling successfully on UNIX. (Note: They all work fine on windows platform). This is to serve the Designer generated Forms using Forms Server 6i installed on UNIX. The UNIX machine is Compaq Alpha Server running Compaq Tru64 UNIX V5.1A (Rev. 1885). The Developer software on UNIX is Developer 6i patchset 10. One of the attached library OFGTEL.llb is referencing OFGMES.llb in an Initcap case format. After making OFGMES.llb to Ofgmes.llb, OFGTEL.llb compiled alright. At this point all attached libraries are moved to UNIX and compiled successfully. But, the FMB is not compiling successfully as it is not attaching the libraries properly no matter what case we use for libraries and its compiled versions. All upper case and all lower case filenames did not work. We noticed that an error message did refre to the refreenced filename as Initcap format, so we changed all attached filename to Initcap format. Then we have to convert .fmb file to .fmt and edit it to convert external filename references to Initcap. Then convert the fmt back to .fmb format. This version of .fmb compiled successfully with all attached library files being Initcap. Editing Designer generated .fmb by converting to .fmt (text format) is tedious and error prone. We are trying to find if Oracle has a patch/utility for this bug. Has anyone had a similar experience? Erik Cohen SAIC Falls Church, VA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cohen, Erik INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Monitoring occurence of snaphot too old
Hi, Yes, it is 8i..I was more interested in catching snapshot too old before it happens..does not seem possible.. But, my thanks to everyone who responded.. Mohammed Ahsanuddin Oracle DBA -Original Message- Sent: Friday, August 02, 2002 2:19 PM To: Multiple recipients of list ORACLE-L Yes. I didn't see the version it the other guy's post. Was it 8i? > -Original Message- > From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 02, 2002 1:54 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Monitoring occurence of snaphot too old > > > Isn't the UNDO_RETENTION parameter a new one for 9i and does > not exist in 8.x and lower. > > Thanks, > > Dave > > -Original Message- > Sent: Friday, August 02, 2002 12:05 PM > To: Multiple recipients of list ORACLE-L > > > Just set the UNDO_RETENTION parameter to 4 hours and forget > about the 'snapshot too old'. It's no longer happening. > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED]] > > Sent: Friday, August 02, 2002 12:14 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Monitoring occurence of snaphot too old > > > > > > Dear List members, > > > > I was wondering if there is a way to monitor the database and > > tell if there > > is a possiblility of snapshot too old error occurence. > > > > Any input is highly appreciated.. > > > > Thanks > > > > Mohammed Ahsanuddin > > Oracle DBA > > > > -- > > 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 Diego, California-- Public Internet access / > Mailing Lists > > > > 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.com > -- > Author: Gogala, Mladen > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com > -- > Author: Farnsworth, Dave > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Live Webcast: The death of the buffer cache hit ratio
Title: RE: Live Webcast: The death of the buffer cache hit ratio > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > Ok, everybody, let's show up in support of Anjo. > > This should be a great presentation. > > Sorry if someone has already posted this to the list today, I > just haven't > had time to read it yet today. But he's the competition! :)
RE: DUAL revisited
Title: RE: DUAL revisited > -Original Message- > From: Kathy Duret [mailto:[EMAIL PROTECTED]] > > But I don't get this error when I query from dual just from > the new v$dual. That's because your v$dual view is assessing a SYS.X$ "table". To do an explain plan on a SYS.X$ "table" you have to be signed on as SYS. A more knowledgeable person may be able to tell you why.
Live Webcast: The death of the buffer cache hit ratio
Ok, everybody, let's show up in support of Anjo. This should be a great presentation. Sorry if someone has already posted this to the list today, I just haven't had time to read it yet today. Jared - SearchEBusiness invites you to this Vendor Connection Webcast: * TOPIC: The death of the buffer cache hit ratio WHEN:Wednesday, August 7 at 11:00 a.m. EDT (15:00 GMT) SPEAKER: Anjo Kolk, Chief Oracle Technologist, Precise Software and renowned Oracle performance author SPONSOR: Precise Software PRE-REGISTER FOR THIS WEBCAST TODAY: http://searchEBusiness.com/webcasts * -- About this Webcast -- Join Anjo Kolk, Chief Oracle Technologist at Precise Software and renowned Oracle performance author, for his views on Oracle performance tuning. Anjo will discuss how conventional tuning approaches rely too heavily on checking the buffer cache hit ratio. Many DBAs do their best to get a 99% or better hit ratio but discover that the performance of their database isn't really improving when the hit ratio gets better. Anjo will discuss these points and others: * If the hit ratio was tuned to 99% or better, why is end user response time still bad? * If tuning the hit ratio is not the answer to end-user response time, what is? * Why does a hit ratio do exactly the opposite of what you would think? * Logical I/Os -- The myths dispelled. * How to calculate the cost of a logical I/O. * How to use the response time model in Oracle to find performance problems. If database performance is important to you, click here to pre-register for this Webcast: http://searchEBusiness.com/webcasts * -- Sponsored By: Precise Software Solutions -* Precise Software Solutions (Nasdaq: PRSE) headquartered in Westwood, MA, delivers Precise i3, a comprehensive solution for Application Performance Management that focuses directly on the end-user experience and delivers a rapid return on technology investments. Precise i3 proactively detects and corrects the root causes of performance degradation before they affect response times. Visit us at http://www.precise.com. * -- Invite a colleague -- If you think this event topic would be interesting to a colleague, invite them to this Vendor Connection Webcast. All you need to do is forward this e-mail. Unsubscribe from 'Updates on upcoming online events' - Simply Reply to this Email with REMOVE within the Body or Subject > or - Go to: http://searchEBusiness.techtarget.com/register - Log in to edit your profile. - Click on the link to Edit email subscriptions. - Uncheck the box next to the newsletter you wish to unsubscribe from. - When finished, click "Save Changes to My Profile." -- 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 Diego, California-- Public Internet access / Mailing Lists 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).
DBA_ERRORS timestamp
Title: Message Has anyone ever tried loggin the contents of dba_errors, but with a time stamp? It's not a critical thing, but I keep wondering why Oracle didn't put a time stamp in that view. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED]
RE: DUAL revisited
But I don't get this error when I query from dual just from the new v$dual. Kathy -Original Message- Sent: Friday, August 02, 2002 12:54 PM To: Multiple recipients of list ORACLE-L ...if you're going to query from an account other than SYS, then please SET AUTOTRACE TRACEONLY STATISTICS (instead of SET AUTOTRACE ON) so it doesn't try to do an EXPLAIN PLAN. You cannot grant SELECT on X$ tables to anyone other than SYS, which affects EXPLAIN PLAN also... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, August 02, 2002 11:15 AM > I followed the instructions but I get the error below. I do not get the same error when I select from dual. And yes I did to the public grant. And other clues? DB 8.1.7.3 > > Thanks Kathy > > Execution Plan > -- > ERROR: > ORA-01039: insufficient privileges on underlying objects of the view > > > SP2-0612: Error generating AUTOTRACE EXPLAIN report > > Statistics > -- > 0 recursive calls > 0 db block gets > 0 consistent gets > 0 physical reads > 0 redo size > 371 bytes sent via SQL*Net to client > 426 bytes received via SQL*Net from client > 2 SQL*Net roundtrips to/from client > 0 sorts (memory) > 0 sorts (disk) > 1 rows processed > -Original Message- > Sent: Friday, August 02, 2002 8:13 AM > To: Multiple recipients of list ORACLE-L > > > I've been reading the thread on DUAL vs X$DUAL, read the referenced article > and tried some testing on our system. I do a simple select from DUAL and I > get the same statistics as were in the article, but sometimes I also get 1 > memory sort. Does anyone know why this would be? And if this is true, that > really makes me want to change over to X$DUAL. Also, what is the consensus > about creating a view for DUAL that references X$DUAL? I'm running the > Oracle Application and cannot change all of their code to use something > other than DUAL, and there is a lot of it. > > Here are the statistics on the select. Notice the difference between the > first vs repeat of the same seelct. > > Connected to: > Oracle8i Enterprise Edition Release 8.1.7.1.1 - Production > With the Partitioning option > JServer Release 8.1.7.1.1 - Production > > SQL> set autotrace traceonly > SQL> select 'y' from dual; > > Execution Plan > -- >0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1) >10 TABLE ACCESS (FULL) OF 'DUAL' (Cost=2 Card=1) > > Statistics > -- > 0 recursive calls > 4 db block gets > 1 consistent gets > 0 physical reads > 0 redo size > 361 bytes sent via SQL*Net to client > 425 bytes received via SQL*Net from client > 2 SQL*Net roundtrips to/from client > 1 sorts (memory) > 0 sorts (disk) > 1 rows processed > SQL> / > > Execution Plan > -- >0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1) >10 TABLE ACCESS (FULL) OF 'DUAL' (Cost=2 Card=1) > > Statistics > -- > 0 recursive calls > 4 db block gets > 1 consistent gets > 0 physical reads > 0 redo size > 361 bytes sent via SQL*Net to client > 425 bytes received via SQL*Net from client > 2 SQL*Net roundtrips to/from client > 0 sorts (memory) > 0 sorts (disk) > 1 rows processed > SQL> > > Thanks for your input. > > > John Zoltak > North American Mfg Co > 4455 East 71st Street > Cleveland Ohio 44105 > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: John Zoltak > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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). > > Confidential > This e-mail and any files transmitted with it are the property > of Belkin Components and/or its affiliates, are confidential, > and are intended solely for the use of the individual or > entity to whom this e-mail is addressed. If you are not one > of the named recipients or otherwise have reason to believe > that you have received this e-m
RE: soft parse
We had a detailed discussion about this very thing a little over one week ago. Check the archives for messages with the subject, "Cursor Sharing| Soft Parse." Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message-From: BigP [mailto:[EMAIL PROTECTED]]Sent: Friday, August 02, 2002 1:13 PMTo: Multiple recipients of list ORACLE-LSubject: soft parse How is it possible to avoid soft parse ? When I open a cursor it is hard parsed and soft parsed first time . If I reuse the same cursor it still needs to go soft parsing ( which is privilage checking ) ..cuz what if privilages change during the first time and second time . I was thinking no way one can avoid soft parse . am I wrong ? TIA Bp
RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA
Jared, I agree with your advantages. I am a big believer in the last point. If you don't know how stuff works, you are helpless in the absence of the tool (I'm dealing with this frustration right now...not me, but someone else who can't live without a certain tool). I am a big believer in figuring out how things work (a few on the list can vouch for me on that one...), but it is not always the most economical method to manage many systems. There comes a point where you don't need to reinvent the wheel and update it for each new release. I don't have access to the advance releases and all platforms of the oracle server, so I am limited in what I can do, even if I had the time. Any tool, whether it is GUI or TUI (like a shell script that runs in a cron and emails), can cause disconnect. The fault lies not in the tool, but in the user. Tools don't cause disconnects, People do... Dan "Waiting for Perl for Oracle DBA's to hit the shelves at SoftPro" Fink -Original Message- Sent: Friday, August 02, 2002 11:00 AM To: Multiple recipients of list ORACLE-L On Thursday 01 August 2002 09:45, Fink, Dan wrote: > Case in point, many databases with > few dbas. Logging in each morning to each database and checking status and > metrics is very inefficient. By the time all the databases are checked, the > day is over. This leaves no time to diagnose and repair problems. Scheduled > jobs (cron/AT/dbms_job) that query the database/logs and send email is more > effecient. At this point you have a tool. A monitoring tool, properly > architected and configured, can assist greatly by allowing the dbas to > focus on preventing problems and not wasting time determining that there is > nothing to worry about. > Dan, Advantages of rolling your own: * they do what you want, and only what you want * if your needs change, you can modify them * you don't have to deal with tech support to fix your tools * you have to learn how stuff works to monitor it Well, that last bullet point seems to be temporary with me, I seem to forget stuff after not being close to it for awhile. That also serves to point out what a disconnect GUI tools are. You want some tools? Reserve your copy of "Perl for Oracle DBA's". :) Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: soft parse
nope, you're right on... - Original Message - From: BigP To: Multiple recipients of list ORACLE-L Sent: Friday, August 02, 2002 2:13 PM Subject: soft parse How is it possible to avoid soft parse ? When I open a cursor it is hard parsed and soft parsed first time . If I reuse the same cursor it still needs to go soft parsing ( which is privilage checking ) ..cuz what if privilages change during the first time and second time . I was thinking no way one can avoid soft parse . am I wrong ? TIA Bp
RE: soft parse
The way to avoid it is to write your application so that it doesn’t ever issue the parse call. The ability to share open cursors across end users is one of the motives for 3-tier architectures. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - NCOAUG Training Day, Aug 16 Chicago - Miracle Database Forum, Sep 20–22 Middlefart Denmark - 2003 Hotsos Symposium on Oracle® System Performance, Feb 9–12 Dallas -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of BigP Sent: Friday, August 02, 2002 3:13 PM To: Multiple recipients of list ORACLE-L Subject: soft parse How is it possible to avoid soft parse ? When I open a cursor it is hard parsed and soft parsed first time . If I reuse the same cursor it still needs to go soft parsing ( which is privilage checking ) ..cuz what if privilages change during the first time and second time . I was thinking no way one can avoid soft parse . am I wrong ? TIA Bp
Re: Replication
At a previous job, I've tested the first version of Oracle Lite in 1996 if I remember correctly. The concept of user did not exist, I do not know if it has changed. In my case, several users will connect to the same database. So I guess I'll need the Workgroup version. --- Don Jerman <[EMAIL PROTECTED]> a écrit : > Yes that's how it works, although the volume for 2-3 > months might be > excessive, if the deltas get large. Light uses > Advanced Replication to > manage the deltas so the resolution process might > take a while. > > paquette stephane wrote: > > > Hi, > > > > Oracle Lite would not be good for us as when I > said > > users are working with a deployable version, I > mean a > > bunch of users go away with their server/database > and > > come back 2-3 months after, then they synchronized > the > > master database. > > > > --- Don Jerman <[EMAIL PROTECTED]> a écrit > : > > > Oracle Lite is designed to do this -- the > > > content-deployment part for > > > standalone applications is a little buggy, but > the > > > data deployment and > > > web-app deployment seems to work. We're > instituting > > > a couple of > > > applications with this now, and data sync seems > to > > > be working fine. > > > Application sync has been getting most of the > > > attention so far, though, as > > > we try to get the programs deployed properly > without > > > by-hand intervention. > > > > > > paquette stephane wrote: > > > > > > > Hi, > > > > > > > > We will develop a new system that has a > central > > > > database (817/win2000). > > > > >From times to times, some users will worked > with > > > a > > > > deployable version of the application in a > region > > > > without network connection. > > > > When the users are back, there should be able > to > > > > synchronize with the centralized database. The > > > data > > > > goes from the deployable version to the > > > centralized > > > > database only. > > > > > > > > What strategies can be considered ? > > > > > > > > = > > > > Stéphane Paquette > > > > DBA Oracle, consultant entrepôt de données > > > > Oracle DBA, datawarehouse consultant > > > > [EMAIL PROTECTED] > > > > > > > > > > > > > > ___ > > > > Do You Yahoo!? -- Une adresse @yahoo.fr > gratuite > > > et en français ! > > > > Yahoo! Mail : http://fr.mail.yahoo.com > > > > -- > > > > Please see the official ORACLE-L FAQ: > > > http://www.orafaq.com > > > > -- > > > > Author: =?iso-8859-1?q?paquette=20stephane?= > > > > INET: [EMAIL PROTECTED] > > > > > > > > Fat City Network Services-- (858) 538-5051 > > > FAX: (858) 538-5051 > > > > San Diego, California-- Public > Internet > > > access / Mailing Lists > > > > > > > > > > > > > > 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). > > > > begin:vcard > > > n:Jerman;Don > > > tel;work:919.508.1886 > > > x-mozilla-html:TRUE > > > org:Database Management Service,Information > > > Technology > > > version:2.1 > > > email;internet:[EMAIL PROTECTED] > > > title:Database Administrator > > > adr;quoted-printable:;;Database Management > > > Service,Information Technology=0D=0A104 > Fayetteville > > > Street Mall;Raleigh;NC;27699-1521;USA > > > x-mozilla-cpt:;-9536 > > > fn:Don Jerman > > > end:vcard > > > > > > > = > > Stéphane Paquette > > DBA Oracle, consultant entrepôt de données > > Oracle DBA, datawarehouse consultant > > [EMAIL PROTECTED] > > > > > ___ > > Do You Yahoo!? -- Une adresse @yahoo.fr gratuite > et en français ! > > Yahoo! Mail : http://fr.mail.yahoo.com > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > -- > > Author: =?iso-8859-1?q?paquette=20stephane?= > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 > FAX: (858) 538-5051 > > San Diego, California-- Public Internet > access / Mailing Lists > > > > > 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). > > begin:vcard > n:Jerman;Don > tel;work:919.508.1886 > x-mozilla-html:TRUE > org:Database Management Service,Information > Technology > version:2.1 > email;internet:[EMAIL PROTECTED] > title:Database Administrator > adr
Re: Replication
Light works with a 9ias application (part of the Light package) to establish the mobile database and application on the mobile client. Once the application and database are downloaded, the database uses Advanced Replication to sync with the master when the clients are brought back to the network. While mobile, Light emulates the oracle server (and potentially the 9ias server) for a single user. You have a master database server connected to the mobile data server (9ias) which handles the interface to the mobile clients (laptops, desktops, what-have-you). Up to 64 mobile clients per mobile server, if I remember the marketing speil right, but we're still at the 4-client dev/test phase. We have staff working on it, with assistance from an Oracle consultant brought in for the purpose. I just deal with the master database. Since we're doing stand-alone, we have to hand-jar the java applications (the jar wizard with Oracle Developer doesn't fit the bill somehow) so application deployment is the sticking point at the moment. We might get an answer this month, but the dev manager is doing the schedule and application details. My understanding is that if you deploy a JSP web app using 9ias, the app can be downloaded and run on the mobile client against the Lite database, and that sort of deployment appears to run smoothly (the examples work). But we're not doing that in this case so I have no real-world experience there. "Ramon E. Estevez" wrote: > Don, > > What are you using for deploy the applications ?? > > I am interested in this topic too. > > Ramon > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Friday, August 02, 2002 10:33 AM > > Oracle Lite is designed to do this -- the content-deployment part for > standalone applications is a little buggy, but the data deployment and > web-app deployment seems to work. We're instituting a couple of > applications with this now, and data sync seems to be working fine. > Application sync has been getting most of the attention so far, though, as > we try to get the programs deployed properly without by-hand intervention. > > paquette stephane wrote: > > > Hi, > > > > We will develop a new system that has a central > > database (817/win2000). > > >From times to times, some users will worked with a > > deployable version of the application in a region > > without network connection. > > When the users are back, there should be able to > > synchronize with the centralized database. The data > > goes from the deployable version to the centralized > > database only. > > > > What strategies can be considered ? > > > > = > > Stéphane Paquette > > DBA Oracle, consultant entrepôt de données > > Oracle DBA, datawarehouse consultant > > [EMAIL PROTECTED] > > > > ___ > > Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! > > Yahoo! Mail : http://fr.mail.yahoo.com > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: =?iso-8859-1?q?paquette=20stephane?= > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > 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.com > -- > Author: Ramon E. Estevez > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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). begin:vcard n:Jerman;Don tel;work:919.508.1886 x-mozilla-html:TRUE org:Database Management Service,Information Technology version:2.1 email;internet:[EMAIL PROTECTED] title:Database Administrator adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA x-mozilla-cpt:;-9536 fn:Don Jerman end:vcard
RE: soft parse
We just had this discussion... it's a matter of definition. You can avoid a "soft parse" with another kind of parse called appropriately a "softer parse." This phrase was coined in a recent article from Tom Kyte. Here's the link: http://www.oramag.com/oramag/oracle/02-jul/index.html?o42asktom.html -Original Message-From: BigP [mailto:[EMAIL PROTECTED]]Sent: Friday, August 02, 2002 2:13 PMTo: Multiple recipients of list ORACLE-LSubject: soft parse How is it possible to avoid soft parse ? When I open a cursor it is hard parsed and soft parsed first time . If I reuse the same cursor it still needs to go soft parsing ( which is privilage checking ) ..cuz what if privilages change during the first time and second time . I was thinking no way one can avoid soft parse . am I wrong ? TIA Bp
Re: Replication
Yes that's how it works, although the volume for 2-3 months might be excessive, if the deltas get large. Light uses Advanced Replication to manage the deltas so the resolution process might take a while. paquette stephane wrote: > Hi, > > Oracle Lite would not be good for us as when I said > users are working with a deployable version, I mean a > bunch of users go away with their server/database and > come back 2-3 months after, then they synchronized the > master database. > > --- Don Jerman <[EMAIL PROTECTED]> a écrit : > > Oracle Lite is designed to do this -- the > > content-deployment part for > > standalone applications is a little buggy, but the > > data deployment and > > web-app deployment seems to work. We're instituting > > a couple of > > applications with this now, and data sync seems to > > be working fine. > > Application sync has been getting most of the > > attention so far, though, as > > we try to get the programs deployed properly without > > by-hand intervention. > > > > paquette stephane wrote: > > > > > Hi, > > > > > > We will develop a new system that has a central > > > database (817/win2000). > > > >From times to times, some users will worked with > > a > > > deployable version of the application in a region > > > without network connection. > > > When the users are back, there should be able to > > > synchronize with the centralized database. The > > data > > > goes from the deployable version to the > > centralized > > > database only. > > > > > > What strategies can be considered ? > > > > > > = > > > Stéphane Paquette > > > DBA Oracle, consultant entrepôt de données > > > Oracle DBA, datawarehouse consultant > > > [EMAIL PROTECTED] > > > > > > > > > ___ > > > Do You Yahoo!? -- Une adresse @yahoo.fr gratuite > > et en français ! > > > Yahoo! Mail : http://fr.mail.yahoo.com > > > -- > > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > > -- > > > Author: =?iso-8859-1?q?paquette=20stephane?= > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- (858) 538-5051 > > FAX: (858) 538-5051 > > > San Diego, California-- Public Internet > > access / Mailing Lists > > > > > > > > > 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). > > > begin:vcard > > n:Jerman;Don > > tel;work:919.508.1886 > > x-mozilla-html:TRUE > > org:Database Management Service,Information > > Technology > > version:2.1 > > email;internet:[EMAIL PROTECTED] > > title:Database Administrator > > adr;quoted-printable:;;Database Management > > Service,Information Technology=0D=0A104 Fayetteville > > Street Mall;Raleigh;NC;27699-1521;USA > > x-mozilla-cpt:;-9536 > > fn:Don Jerman > > end:vcard > > > > = > Stéphane Paquette > DBA Oracle, consultant entrepôt de données > Oracle DBA, datawarehouse consultant > [EMAIL PROTECTED] > > ___ > Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! > Yahoo! Mail : http://fr.mail.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: =?iso-8859-1?q?paquette=20stephane?= > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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). begin:vcard n:Jerman;Don tel;work:919.508.1886 x-mozilla-html:TRUE org:Database Management Service,Information Technology version:2.1 email;internet:[EMAIL PROTECTED] title:Database Administrator adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA x-mozilla-cpt:;-9536 fn:Don Jerman end:vcard
soft parse
How is it possible to avoid soft parse ? When I open a cursor it is hard parsed and soft parsed first time . If I reuse the same cursor it still needs to go soft parsing ( which is privilage checking ) ..cuz what if privilages change during the first time and second time . I was thinking no way one can avoid soft parse . am I wrong ? TIA Bp
Re: DUAL revisited
...if you're going to query from an account other than SYS, then please SET AUTOTRACE TRACEONLY STATISTICS (instead of SET AUTOTRACE ON) so it doesn't try to do an EXPLAIN PLAN. You cannot grant SELECT on X$ tables to anyone other than SYS, which affects EXPLAIN PLAN also... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, August 02, 2002 11:15 AM > I followed the instructions but I get the error below. I do not get the same error when I select from dual. And yes I did to the public grant. And other clues? DB 8.1.7.3 > > Thanks Kathy > > Execution Plan > -- > ERROR: > ORA-01039: insufficient privileges on underlying objects of the view > > > SP2-0612: Error generating AUTOTRACE EXPLAIN report > > Statistics > -- > 0 recursive calls > 0 db block gets > 0 consistent gets > 0 physical reads > 0 redo size > 371 bytes sent via SQL*Net to client > 426 bytes received via SQL*Net from client > 2 SQL*Net roundtrips to/from client > 0 sorts (memory) > 0 sorts (disk) > 1 rows processed > -Original Message- > Sent: Friday, August 02, 2002 8:13 AM > To: Multiple recipients of list ORACLE-L > > > I've been reading the thread on DUAL vs X$DUAL, read the referenced article > and tried some testing on our system. I do a simple select from DUAL and I > get the same statistics as were in the article, but sometimes I also get 1 > memory sort. Does anyone know why this would be? And if this is true, that > really makes me want to change over to X$DUAL. Also, what is the consensus > about creating a view for DUAL that references X$DUAL? I'm running the > Oracle Application and cannot change all of their code to use something > other than DUAL, and there is a lot of it. > > Here are the statistics on the select. Notice the difference between the > first vs repeat of the same seelct. > > Connected to: > Oracle8i Enterprise Edition Release 8.1.7.1.1 - Production > With the Partitioning option > JServer Release 8.1.7.1.1 - Production > > SQL> set autotrace traceonly > SQL> select 'y' from dual; > > Execution Plan > -- >0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1) >10 TABLE ACCESS (FULL) OF 'DUAL' (Cost=2 Card=1) > > Statistics > -- > 0 recursive calls > 4 db block gets > 1 consistent gets > 0 physical reads > 0 redo size > 361 bytes sent via SQL*Net to client > 425 bytes received via SQL*Net from client > 2 SQL*Net roundtrips to/from client > 1 sorts (memory) > 0 sorts (disk) > 1 rows processed > SQL> / > > Execution Plan > -- >0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1) >10 TABLE ACCESS (FULL) OF 'DUAL' (Cost=2 Card=1) > > Statistics > -- > 0 recursive calls > 4 db block gets > 1 consistent gets > 0 physical reads > 0 redo size > 361 bytes sent via SQL*Net to client > 425 bytes received via SQL*Net from client > 2 SQL*Net roundtrips to/from client > 0 sorts (memory) > 0 sorts (disk) > 1 rows processed > SQL> > > Thanks for your input. > > > John Zoltak > North American Mfg Co > 4455 East 71st Street > Cleveland Ohio 44105 > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: John Zoltak > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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). > > Confidential > This e-mail and any files transmitted with it are the property > of Belkin Components and/or its affiliates, are confidential, > and are intended solely for the use of the individual or > entity to whom this e-mail is addressed. If you are not one > of the named recipients or otherwise have reason to believe > that you have received this e-mail in error, please notify the > sender and delete this message immediately from your computer. > Any other use, retention, dissemination, forwarding, printing > or copying of this e-mail is s
RE: Monitoring occurence of snaphot too old
Use a SERVERERROR trigger to capture the ORA-01555 event and log it somewhere, I find the alert log is easiest. I have a script that picks up custom events written to the alert log and notifies me about them. Other than that follow the advice in other posts and try to avoid them all together. If you are below 9i then get rid of OPTIMAL on all your rollback segments so they never shrink and monitor them. Shrink them manually when system use is very low. create or replace trigger tk$servererror after servererror on database declare mysession v$session%rowtype; begin -- Some errors are not logged... --1 - Key violation. -- 1004 - Default user feature not supported. -- 1013 - Use canceled operation. -- 1017 - Invalid User Name/Password -- 1400 - Can not insert null. -- 1418 - Index does not exist. -- 1722 - Invalid number. -- 1747 - Invalid column name. -- 1839 - Date not valid. -- 4043 - Object does not exist. -- 6550 - PL/SQL Complilation Failure -- if ora_server_error(1) not between 900 and 999 then if ora_server_error(1) not in (1,1004,1013,1017,1400,1418,1722,1747,1839,4043,6550) then select * into mysession from v$session where sid = (select distinct sid from v$mystat); sys.dbms_system.ksdind(0); sys.dbms_system.ksdwrt(2,'SERVERERROR[' || ora_server_error(1) || '] SESSION ' || mysession.sid || ',' || mysession.serial# || ' USER ' || mysession.username || ',' || mysession.osuser || ' PROGRAM ' || mysession.program || ',' || mysession.machine || ' CLIENT INFO ' || mysession.client_info); end if; end if; exception when others then dbms_output.put_line(dbms_utility.format_error_stack); end; Ethan Post perotdba (AIM), epost1 (Yahoo) -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Friday, August 02, 2002 11:14 AM To: Multiple recipients of list ORACLE-L Dear List members, I was wondering if there is a way to monitor the database and tell if there is a possiblility of snapshot too old error occurence. Any input is highly appreciated.. Thanks Mohammed Ahsanuddin Oracle DBA -- 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 Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Free ware databases: which are worth the money?
We have used MySQL in a small in-house project. It works OK for what we want it to do, but it's far from having Oracle's functionnality. --- DENNIS WILLIAMS <[EMAIL PROTECTED]> a écrit : > Mark >Eweek recently did a head-to-head performance > test of major databases and > included MySQL. You might look it up to see the > strengths and weaknesses of > this type of database. Unless the simple memory > cache in MySQL works for > you, Oracle left all of them in the dust, including > SQL Server. Some people > here use MySQL for small applications and report > that it works fine for > their purpose. > > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -Original Message- > Sent: Friday, August 02, 2002 5:33 AM > To: Multiple recipients of list ORACLE-L > > > Hi, > we are investigating some freeware databases for > deployment on systems that > dont justify the cost of an oracle license, on > linux. What databases out > these can cope with a OLTP load, all transaction > based, with some > reporting? Uncomplicated databases, with mid size > volumes of transactions > (say low millions) and some reporting queries? I > guess reliability is the > primary concern, if something can be built as > solidly as an oracle > instance, with whatever OS protection this would > need, then its a starting > point for making a non oracle freeware enterprise > database. > Anyone have any suggestions on what I should > download first? > > Thanks! > Mark Teehan > Singapore > ERG Group > -- > The contents of this email and any attachments are > confidential > and may only be read by the intended recipient. > - > > ERG Group > -- > The contents of this email and any attachments are > confidential > and may only be read by the intended recipient. > - > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Mark Teehan > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > 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.com > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > 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). > = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 9 Standard/Enterprise Diffs
http://technet.oracle.com/products/oracle9i/pdf/9idb_rel2_prod_fam.pdf Near the end of this white paper. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, August 02, 2002 1:45 PM To: Multiple recipients of list ORACLE-L Anyone got a link to the guide with the features matrix for SE and EE? I can find it for 8i in the "Getting to Know Oracle 8i" but I can not find a "Getting to Know Oracle 9i" http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/nav/docind ex.htm Thanks, Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Good basic hardware cource
Hi. Can someone recommend a good basic hardware course for a DBA. I'm looking for something dealing with both the general concepts (raw devices vs filesystems, logical volumes, partitioning etc) and somewhat hands-on application preferably on IBM servers (that's what ewe are currently on). any ideas? thanks Gene __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 9 Standard/Enterprise Diffs
Anyone got a link to the guide with the features matrix for SE and EE? I can find it for 8i in the "Getting to Know Oracle 8i" but I can not find a "Getting to Know Oracle 9i" http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/nav/docind ex.htm Thanks, Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Execute oexec(): ORA-01467: sort key too long
disregard the first SELECT sent. was given the wrong query. *this* ugly query is the one that fails both in the reporting tool and in sqlplus (makes sense now): SELECT FORM_CD, SUBMIT_DT, MAX(DISTINCT DECODE(Name, '01_First_Name', Value, NULL)) First_Name, MAX(DISTINCT DECODE(Name, '02_Last_Name', Value, NULL)) Last_Name, MAX(DISTINCT DECODE(Name, '03_Street_Address', Value, NULL)) Street_Address, MAX(DISTINCT DECODE(Name, '04_City', Value, NULL)) City, MAX(DISTINCT DECODE(Name, '05_State', Value, NULL)) State, MAX(DISTINCT DECODE(Name, '06_Zip_Code', Value, NULL)) Zip_Code, MAX(DISTINCT DECODE(Name, '07_Email', Value, NULL)) Email, MAX(DISTINCT DECODE(Name, '08_REF', Value, NULL)) Referred_By, MAX(DISTINCT DECODE(Name, '09_Newsletter', Value, NULL)) Newsletter, MAX(DISTINCT DECODE(Name, '10_Q1', Value, NULL)) Q1, MAX(DISTINCT DECODE(Name, '11_Q2', Value, NULL)) Q2, MAX(DISTINCT DECODE(Name, '12_Q3', Value, NULL)) Q3, MAX(DISTINCT DECODE(Name, '13_Q4', Value, NULL)) Q4, MAX(DISTINCT DECODE(Name, '14_Q5', Value, NULL)) Q5, MAX(DISTINCT DECODE(Name, '15_Q6', Value, NULL)) Q6, MAX(DISTINCT DECODE(Name, '16_Q7', Value, NULL)) Q7, MAX(DISTINCT DECODE(Name, '17_Q8', Value, NULL)) Q8, MAX(DISTINCT DECODE(Name, '18_Q9', Value, NULL)) Q9, MAX(DISTINCT DECODE(Name, '19_Q10', Value, NULL)) Q10, MAX(DISTINCT DECODE(Name, '20_Q11', Value, NULL)) Q11, MAX(DISTINCT DECODE(Name, '21_Q12', Value, NULL)) Q12, MAX(DISTINCT DECODE(Name, '22_Q13', Value, NULL)) Q13, MAX(DISTINCT DECODE(Name, '23_Q14', Value, NULL)) Q14, MAX(DISTINCT DECODE(Name, '24_Q15', Value, NULL)) Q15, MAX(DISTINCT DECODE(Name, '25_Q16', Value, NULL)) Q16, MAX(DISTINCT DECODE(Name, '26_Q17', Value, NULL)) Q17, MAX(DISTINCT DECODE(Name, '27_Q18', Value, NULL)) Q18, MAX(DISTINCT DECODE(Name, '28_Q19', Value, NULL)) Q19, MAX(DISTINCT DECODE(Name, '29_Q20', Value, NULL)) Q20, MAX(DISTINCT DECODE(Name, '30_Q21', Value, NULL)) Q21, MAX(DISTINCT DECODE(Name, '31_Q22', Value, NULL)) Q22 FROM value, entry WHEREvalue.entry_id = entry.entry_id AND entry.form_cd = 'allure_beautyballot2002_mps' GROUP BY FORM_CD, SUBMIT_DT, value.entry_id / SQL> @run_for_robert.sql FROM value, entry * ERROR at line 35: ORA-01467: sort key too long terrible query. i know. i found this on metalink: 64K Restriction ~~~ The 64K restriction is a maximum internal buffer size for sort keys. This can affect any sort operation, including join keys used in sort-merge-join operations. For example, if a statement joins on a number of VARCHAR2(4000) columns , or group by on a number of VARCHAR2(4000) columns then this limit can be hit. In most cases the limit is hit at run time and so is data dependent, but some operations do use a maximum data size. is there any solutions out there? thanks! kris On Fri, 2 Aug 2002, Kris Austin-Murray wrote: > > hi > > this error is being generated in an admin report tool. the query is the > following: > > SQL> SELECT value.name, value.value, entry.submit_dt > 2 FROM value, entry WHERE value.entry_id = entry.entry_id AND > 3 entry.form_cd = 'glamour_injeanious_mps'; > > > here are the global settings for sqlplus: > > SQL> show maxdata > maxdata 6000 > SQL> show arraysize > arraysize 1 > > this began occuring when we change one field from 2000 characters, to > 4000: > > SQL> desc value > Name Null?Type > - > ENTRY_ID NOT NULL NUMBER(10) > NAME NOT NULL VARCHAR2(100) > VALUE VARCHAR2(4000) > > the total # of records in value: > > SQL> select count(*) from value; > > COUNT(*) > -- > 16408559 > > i've played with setting the arraysize, maxdata without luck. this query > does return results from within sqlplus, but not for the reporting tool, > which sits on sun solaris 2.5 box with 4 GIG of memory. > > we're running Oracle8i Enterprise Edition Release 8.1.6.0.0 on sun solaris > 2.6 > > i've searched metalink and found a doc (Note:1012366.6) that explains the > ORA-1467 error. still i am without a solution. > > any help out there? > > thank you! > kris > > > +-+--+-+--+-+-+-+--+--+--+-+ > kris austin-murray ... senior database manager, ocp ... advance internet >www.advance.net ... [EMAIL PROTECTED] ... 201-459-2805 > +-+--+-+--+-+-+-+--+--+--+-+ > "Darkness cannot drive out darkness; only light can do that. Hate > cannot drive out hate; only love can do that." - Martin Luther King, Jr. > > > +-+--+-+--+-+-+-+--+--+--+-+ kris austin-murray ... senior database manager, ocp ... advance internet www.advance.net ... [EMAIL PROTECTED] ... 201-459-2805 +-+--+-+--+---
Re: Compatibility martix on Metalink - Thanks
Thanks you, Dennis, Stephen and Chandesh. I found it. Gene --- Gurelei <[EMAIL PROTECTED]> wrote: > Hi, > > I remember being able to find a compatibility matrix > on Oracle MEtalink with the info of which Oracle > version is running under which OS. LAtely, I haven't > been able to locate it. Can someone point me to > correct page? > > thanks > > __ > Do You Yahoo!? > Yahoo! Health - Feel better, live better > http://health.yahoo.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Gurelei > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > 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). __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA
Hey Jared, When the book is coming out, I am waiting with my credit card on hand ... 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, but having an opinion is an art! -Original Message- Sent: Friday, August 02, 2002 1:00 PM To: Multiple recipients of list ORACLE-L You want some tools? Reserve your copy of "Perl for Oracle DBA's". :) Jared *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
RE: 20 Instances 1 Machine
Good point Dennis - version issues. We create a separate Oracle home for each 3rd party application that we install at our company for this very reason. Jay >>> [EMAIL PROTECTED] 08/02/02 01:05PM >>> Ethan - Now that you have clarified the reason why you want 20 instances, I'll change my advice and say that in your situation, 20 instances may be the better choice. Two other factors you need to consider: 1. An ASP is a lot like the old time-sharing systems. You must have an absolutely bulletproof billing system. This may be easier to accomplish if you have each customer in a separate O.S. username. You might be able to use the O.S. usage reports for billing with separate userids. And you must have good security to keep them from becoming root and giving themselves a discount. 2. Eventually you will need to upgrade Oracle versions. Not all customers will be able to upgrade at the same time due to other constraints on their part. Separate instances will allow you to have different customers on different Oracle versions. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of D&E except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA
If I may add one more... * upgrades (database, OS, "monitoring tool") are virtually painless. Except for a few path changes and/or a few query changes for v$ or DBA_ tables. Good luck upgrading OEM in place on the same machine AND maintinaining all your scheduled jobs without interruption. Which reminds me of another one: * cost Jay >>> [EMAIL PROTECTED] 08/02/02 12:59PM >>> On Thursday 01 August 2002 09:45, Fink, Dan wrote: > Case in point, many databases with > few dbas. Logging in each morning to each database and checking status and > metrics is very inefficient. By the time all the databases are checked, the > day is over. This leaves no time to diagnose and repair problems. Scheduled > jobs (cron/AT/dbms_job) that query the database/logs and send email is more > effecient. At this point you have a tool. A monitoring tool, properly > architected and configured, can assist greatly by allowing the dbas to > focus on preventing problems and not wasting time determining that there is > nothing to worry about. > Dan, Advantages of rolling your own: * they do what you want, and only what you want * if your needs change, you can modify them * you don't have to deal with tech support to fix your tools * you have to learn how stuff works to monitor it Well, that last bullet point seems to be temporary with me, I seem to forget stuff after not being close to it for awhile. That also serves to point out what a disconnect GUI tools are. You want some tools? Reserve your copy of "Perl for Oracle DBA's". :) Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of D&E except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Compatibility martix on Metalink
Gurelei At the opening page, along the left side, click on the tab titled "Certify & Availability". Then select option 2, "View Certifications by Platforms". Then just keep making selections and eventually you get the matrix that you want. I agree, Oracle keeps moving this stuff around. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, August 02, 2002 12:25 PM To: Multiple recipients of list ORACLE-L Hi, I remember being able to find a compatibility matrix on Oracle MEtalink with the info of which Oracle version is running under which OS. LAtely, I haven't been able to locate it. Can someone point me to correct page? thanks __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Monitoring occurence of snaphot too old
Yes. I didn't see the version it the other guy's post. Was it 8i? > -Original Message- > From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 02, 2002 1:54 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Monitoring occurence of snaphot too old > > > Isn't the UNDO_RETENTION parameter a new one for 9i and does > not exist in 8.x and lower. > > Thanks, > > Dave > > -Original Message- > Sent: Friday, August 02, 2002 12:05 PM > To: Multiple recipients of list ORACLE-L > > > Just set the UNDO_RETENTION parameter to 4 hours and forget > about the 'snapshot too old'. It's no longer happening. > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED]] > > Sent: Friday, August 02, 2002 12:14 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Monitoring occurence of snaphot too old > > > > > > Dear List members, > > > > I was wondering if there is a way to monitor the database and > > tell if there > > is a possiblility of snapshot too old error occurence. > > > > Any input is highly appreciated.. > > > > Thanks > > > > Mohammed Ahsanuddin > > Oracle DBA > > > > -- > > 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 Diego, California-- Public Internet access / > Mailing Lists > > > > 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.com > -- > Author: Gogala, Mladen > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com > -- > Author: Farnsworth, Dave > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
MetaLink glitch?
Could be just my PC, but I just access MetaLink and the button bar does not appear, I see the beginnings (left side) of a Page Not Found message. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Execute oexec(): ORA-01467: sort key too long
hi this error is being generated in an admin report tool. the query is the following: SQL> SELECT value.name, value.value, entry.submit_dt 2 FROM value, entry WHERE value.entry_id = entry.entry_id AND 3 entry.form_cd = 'glamour_injeanious_mps'; here are the global settings for sqlplus: SQL> show maxdata maxdata 6000 SQL> show arraysize arraysize 1 this began occuring when we change one field from 2000 characters, to 4000: SQL> desc value Name Null?Type - ENTRY_ID NOT NULL NUMBER(10) NAME NOT NULL VARCHAR2(100) VALUE VARCHAR2(4000) the total # of records in value: SQL> select count(*) from value; COUNT(*) -- 16408559 i've played with setting the arraysize, maxdata without luck. this query does return results from within sqlplus, but not for the reporting tool, which sits on sun solaris 2.5 box with 4 GIG of memory. we're running Oracle8i Enterprise Edition Release 8.1.6.0.0 on sun solaris 2.6 i've searched metalink and found a doc (Note:1012366.6) that explains the ORA-1467 error. still i am without a solution. any help out there? thank you! kris +-+--+-+--+-+-+-+--+--+--+-+ kris austin-murray ... senior database manager, ocp ... advance internet www.advance.net ... [EMAIL PROTECTED] ... 201-459-2805 +-+--+-+--+-+-+-+--+--+--+-+ "Darkness cannot drive out darkness; only light can do that. Hate cannot drive out hate; only love can do that." - Martin Luther King, Jr. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kris Austin-Murray INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: MetaLink glitch? -- gone
I refreshed the page, the buttons show up now. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Friday, August 02, 2002 1:51 PM To: '[EMAIL PROTECTED]' Subject:MetaLink glitch? Could be just my PC, but I just access MetaLink and the button bar does not appear, I see the beginnings (left side) of a Page Not Found message. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: DUAL revisited
Just wondering here but has anyone tried doing that select from something like v$database; Statistics -- 0 recursive calls 0 db block gets 0 consistent gets 0 physical reads 0 redo size 187 bytes sent via SQL*Net to client 248 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed that looks pretty good to me!! -Original Message- Sent: Friday, August 02, 2002 11:13 AM To: Multiple recipients of list ORACLE-L I've been reading the thread on DUAL vs X$DUAL, read the referenced article and tried some testing on our system. I do a simple select from DUAL and I get the same statistics as were in the article, but sometimes I also get 1 memory sort. Does anyone know why this would be? And if this is true, that really makes me want to change over to X$DUAL. Also, what is the consensus about creating a view for DUAL that references X$DUAL? I'm running the Oracle Application and cannot change all of their code to use something other than DUAL, and there is a lot of it. Here are the statistics on the select. Notice the difference between the first vs repeat of the same seelct. Connected to: Oracle8i Enterprise Edition Release 8.1.7.1.1 - Production With the Partitioning option JServer Release 8.1.7.1.1 - Production SQL> set autotrace traceonly SQL> select 'y' from dual; Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1) 10 TABLE ACCESS (FULL) OF 'DUAL' (Cost=2 Card=1) Statistics -- 0 recursive calls 4 db block gets 1 consistent gets 0 physical reads 0 redo size 361 bytes sent via SQL*Net to client 425 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 1 sorts (memory) 0 sorts (disk) 1 rows processed SQL> / Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1) 10 TABLE ACCESS (FULL) OF 'DUAL' (Cost=2 Card=1) Statistics -- 0 recursive calls 4 db block gets 1 consistent gets 0 physical reads 0 redo size 361 bytes sent via SQL*Net to client 425 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed SQL> Thanks for your input. John Zoltak North American Mfg Co 4455 East 71st Street Cleveland Ohio 44105 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Zoltak INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: david hill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: User with less privileges...
why does it matter if they see the public synonyms? they won't have access to the underlying objects in any case. also, remember that pretty much the only way they can see the synonyms is by accessing the data dictionary (all_synonyms, etc.) bill -Original Message- Sent: Friday, August 02, 2002 1:00 PM To: Multiple recipients of list ORACLE-L Iulian - Been there, done that. It is easy when a system starts to be a little lax, assuming that meets the needs. Then things ramp up and it is painful to go back and change things the way they should have been to start with. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, August 02, 2002 2:53 AM To: Multiple recipients of list ORACLE-L Thanks guys. OK, I can control the access to public synonyms but, I also don't want them to be seen by that new user (the intruder). So, I guess in order to avoid public synonyms, I still have to create all the synonyms for every aplication's users. It seems that I'm a lazy person. Regards iulian ilies -Original Message- Sent: Friday, August 02, 2002 9:08 AM To: Multiple recipients of list ORACLE-L ** This email has been tested for viruses by F-Secure Antivirus administered by IT Network Department. ** I agree on the use of roles - it is the best way to go. However, beware that object privileges granted via a role are NOT in effect inside a definer's rights procedure/package (the default type). This *may* require some investigation and, perhaps, some changes to the application, the privileges of the package owner, the owner of the package, or the package authid, or ... I disagree about granting CONNECT to everyone - grant "create session" instead. CONNECT is actually a pre-defined role with a number of system privileges that most application users do NOT need (alter session, create table, create cluster, create database link, etc.) in addition to the "create session" system privilege. Likewise, I would grant explicit tablespace quotas. Granting RESOURCE is again overkill. Most application users don't need tablespace quotas and even if they do it is usually something trivial (e.g. 1-10 MB) in USERS. The system privilege "unlimited tablespace" (included in the RESOURCE role) is especially dangerous as it includes the SYSTEM tablespace. The "easy way" out is to just grant *everything* to PUBLIC, but it is a very poor choice from any rational security perspective - as you are now discovering. (Oracle preaches this, but doesn't actually practice it themselves!) You will need to do as Bill suggested: 1) Create a set of application-specific functional roles (e.g. CUST_SVC_REP, CUST_SVC_SUPR, CUST_SVC_ADMIN, ...). 2) Grant privileges to roles as appropriate 3) Grant roles to users as appropriate 4) Revoke all (most?) of the application object privileges (and perhaps some others) from PUBLIC The public synonyms are another issue. The don't carry any intrinsic privilege - SELECT, INSERT, etc. still have to be granted to the user or to a role granted to the user. However, public synonyms can be a performance issue and *may* be undesirable for other reasons. Don Granaman [OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, August 01, 2002 11:28 AM try this: rather than granting specific privs to PUBLIC, create specific roles for the different types of users you have, and grant appropriate object privs to each role (granting connect also helps :-). then for each user you add, just give that user whatever role is relevent and you're set . . . they will still be able to access public synonyms. only issue with this is that you'll still need to specify TS quotas to the specific users, as they don't inherit these from the roles (unless you grant RESOURCE to the role, which has UNLIMITED TABLESPACE). using roles is easy to maintain, document and manage -bill -Original Message- Sent: Thursday, August 01, 2002 11:18 AM To: Multiple recipients of list ORACLE-L Hi guys. Can you give some ideeas about this problem. I have a schema which contains all the objects for the application. The user owner of the schema is also the application administrator and having more privilleges. The other users can have access to these objects by beeing granted with some special privilleges (like select/update/insert/delete for tables, execute for functions&procedures) Because the user are deleted or added from time to time, the application author decided to grant the above kind of privilleges to the public and also create some public synonyms with the same names as the originals. BUT, my problem is that now I need to create an user (he does not have any relations with the ordinary application users) which I don't want to have any access to the hrowner objects,
RE: Monitoring occurence of snaphot too old
Isn't the UNDO_RETENTION parameter a new one for 9i and does not exist in 8.x and lower. Thanks, Dave -Original Message- Sent: Friday, August 02, 2002 12:05 PM To: Multiple recipients of list ORACLE-L Just set the UNDO_RETENTION parameter to 4 hours and forget about the 'snapshot too old'. It's no longer happening. > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 02, 2002 12:14 PM > To: Multiple recipients of list ORACLE-L > Subject: Monitoring occurence of snaphot too old > > > Dear List members, > > I was wondering if there is a way to monitor the database and > tell if there > is a possiblility of snapshot too old error occurence. > > Any input is highly appreciated.. > > Thanks > > Mohammed Ahsanuddin > Oracle DBA > > -- > 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 Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Monitoring occurence of snaphot too old
not quite true... if Oracle needs the space, it WILL overwrite the undo segment. So you can get the "snapshot too old", just less likely --- "Gogala, Mladen" <[EMAIL PROTECTED]> wrote: > Just set the UNDO_RETENTION parameter to 4 hours and forget > about the 'snapshot too old'. It's no longer happening. > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED]] > > Sent: Friday, August 02, 2002 12:14 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Monitoring occurence of snaphot too old > > > > > > Dear List members, > > > > I was wondering if there is a way to monitor the database and > > tell if there > > is a possiblility of snapshot too old error occurence. > > > > Any input is highly appreciated.. > > > > Thanks > > > > Mohammed Ahsanuddin > > Oracle DBA > > > > -- > > 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 Diego, California-- Public Internet access / Mailing > Lists > > > > > 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.com > -- > Author: Gogala, Mladen > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > 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). __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: 20 Instances 1 Machine
On Solaris (even 32-bit Solaris, i.e. 2.5.1 or 2.6) the shared memory limits are per process, not system-wide. We had 64 GB systems running 2.5.1 that could support instances using as much of that 64 GB as wanted for shared memory. With the 64-bit OS (Solaris 7, 8 or 9) the same is true. A single 32-bit application can only map to 4 GB of address space of which you can dedicate about 3.9 GB for shared memory if you want. You may need to relink the Oracle binary to get above 2 GB (see the installation guide about genksms). Dave Miller >X-Unix-From: [EMAIL PROTECTED] Thu Aug 1 20:54:24 2002 >Date: Thu, 01 Aug 2002 18:23:21 -0800 >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >X-Comment: Oracle RDBMS Community Forum >X-Sender: "James J. Morrow" <[EMAIL PROTECTED]> >From: "James J. Morrow" <[EMAIL PROTECTED]> >Subject: Re: 20 Instances 1 Machine >X-ListServer: v1.0g, build 71; ListGuru (c) 1996-2001 Bruce A. Bergman >Mime-Version: 1.0 >Content-Transfer-Encoding: 7bit > >Your biggest problem is not going to be physical RAM or disk space (either of >those could simply be purchased large enough). However, you *will* encounter a >problem with "Shared Memory". > >32-bit (and even 64-bit) operating systems have a finite amount of "shared >memory" addressable for use by 32-bit applications (namely the RDBMS shipped >with the Oracle Applications). This number is 1.7GBytes on HP/UX and, I think, >2GBytes on Solaris. This "Shared Memory" limitation is systemwide. The Oracle >RDBMS uses shared memory heavily for major components of the SGA. As a result, >if you're running a 32-bit version of Oracle, this number represents the sum of >all SGA's running on that machine at the time. (So, at 500M/instance, you'll >run out somewhere between 3 and 4 instances). > >Possible solutions would be: >1) Use a 64-bit version of the Oracle RDBMS as certified for your platform. >A 64-bit version of Oracle would address shared memory from a much larger >total pool (most likely an absurdly large number), thus avoiding this 32-bit >"Shared Memory" problem. >2) Consider using something like Sun's "System Domains" to partition a big box >into multiple "virtual machines". Each of these Domains would have it's own >shared memory pool. >3) Consider using seperate machines. > >Personally, I'd vote for seperate machines. I tend to prefer only one >production system exist on any given host as it tends to eliminate much of the >performance-oriented fingerpointing that is bound to come up. Additionally, >running a large number of production instances on a single host can be alot like >putting all of your eggs into one basket. It may be cheaper, but if something >happens to that basket, everything's hosed. > >As far as hardware: > Lots of disk, plenty of I/O channels, and plenty of CPUs. Without actually >knowing the nature of your applications, I'd say you're probably looking in the >SunFire 6800 or SunFire 15k range (if you're looking at Sun equipment). > >Post, Ethan wrote: >> I got a request to spec out a machine that could handle 20 separate Oracle >> instances on a single UNIX server. SGA should total about 500 MB per >> instance. We have some hosts here with 6-8 instances but never tried 20 >> before. Wondering what types of things I should be worried about, obviously >> having enough memory but are there any other limitations I can expect? >> Anyone had to do this? >> >> Thanks, >> Ethan > > >-- James > >James J. Morrow E-Mail: [EMAIL PROTECTED] >Senior Principal Consultant >Tenure Systems, Inc. >McKinney, TX, USA > >"The reasonable man adapts himself to the world: the unreasonable man > persists in trying to adapt the world to himself. Therefore all progress >depends on the unreasonable man." -- George Bernard Shaw > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: James J. Morrow > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >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.com -- Author: David Miller INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an
Compatibility martix on Metalink
Hi, I remember being able to find a compatibility matrix on Oracle MEtalink with the info of which Oracle version is running under which OS. LAtely, I haven't been able to locate it. Can someone point me to correct page? thanks __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: DUAL revisited
I followed the instructions but I get the error below. I do not get the same error when I select from dual. And yes I did to the public grant. And other clues? DB 8.1.7.3 Thanks Kathy Execution Plan -- ERROR: ORA-01039: insufficient privileges on underlying objects of the view SP2-0612: Error generating AUTOTRACE EXPLAIN report Statistics -- 0 recursive calls 0 db block gets 0 consistent gets 0 physical reads 0 redo size 371 bytes sent via SQL*Net to client 426 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed -Original Message- Sent: Friday, August 02, 2002 8:13 AM To: Multiple recipients of list ORACLE-L I've been reading the thread on DUAL vs X$DUAL, read the referenced article and tried some testing on our system. I do a simple select from DUAL and I get the same statistics as were in the article, but sometimes I also get 1 memory sort. Does anyone know why this would be? And if this is true, that really makes me want to change over to X$DUAL. Also, what is the consensus about creating a view for DUAL that references X$DUAL? I'm running the Oracle Application and cannot change all of their code to use something other than DUAL, and there is a lot of it. Here are the statistics on the select. Notice the difference between the first vs repeat of the same seelct. Connected to: Oracle8i Enterprise Edition Release 8.1.7.1.1 - Production With the Partitioning option JServer Release 8.1.7.1.1 - Production SQL> set autotrace traceonly SQL> select 'y' from dual; Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1) 10 TABLE ACCESS (FULL) OF 'DUAL' (Cost=2 Card=1) Statistics -- 0 recursive calls 4 db block gets 1 consistent gets 0 physical reads 0 redo size 361 bytes sent via SQL*Net to client 425 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 1 sorts (memory) 0 sorts (disk) 1 rows processed SQL> / Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1) 10 TABLE ACCESS (FULL) OF 'DUAL' (Cost=2 Card=1) Statistics -- 0 recursive calls 4 db block gets 1 consistent gets 0 physical reads 0 redo size 361 bytes sent via SQL*Net to client 425 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed SQL> Thanks for your input. John Zoltak North American Mfg Co 4455 East 71st Street Cleveland Ohio 44105 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Zoltak INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). Confidential This e-mail and any files transmitted with it are the property of Belkin Components and/or its affiliates, are confidential, and are int
RE: Monitoring occurence of snaphot too old
Just set the UNDO_RETENTION parameter to 4 hours and forget about the 'snapshot too old'. It's no longer happening. > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 02, 2002 12:14 PM > To: Multiple recipients of list ORACLE-L > Subject: Monitoring occurence of snaphot too old > > > Dear List members, > > I was wondering if there is a way to monitor the database and > tell if there > is a possiblility of snapshot too old error occurence. > > Any input is highly appreciated.. > > Thanks > > Mohammed Ahsanuddin > Oracle DBA > > -- > 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 Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Free ware databases: which are worth the money?
Mark Eweek recently did a head-to-head performance test of major databases and included MySQL. You might look it up to see the strengths and weaknesses of this type of database. Unless the simple memory cache in MySQL works for you, Oracle left all of them in the dust, including SQL Server. Some people here use MySQL for small applications and report that it works fine for their purpose. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, August 02, 2002 5:33 AM To: Multiple recipients of list ORACLE-L Hi, we are investigating some freeware databases for deployment on systems that dont justify the cost of an oracle license, on linux. What databases out these can cope with a OLTP load, all transaction based, with some reporting? Uncomplicated databases, with mid size volumes of transactions (say low millions) and some reporting queries? I guess reliability is the primary concern, if something can be built as solidly as an oracle instance, with whatever OS protection this would need, then its a starting point for making a non oracle freeware enterprise database. Anyone have any suggestions on what I should download first? Thanks! Mark Teehan Singapore ERG Group -- The contents of this email and any attachments are confidential and may only be read by the intended recipient. - ERG Group -- The contents of this email and any attachments are confidential and may only be read by the intended recipient. - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Teehan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA
On Thursday 01 August 2002 09:45, Fink, Dan wrote: > Case in point, many databases with > few dbas. Logging in each morning to each database and checking status and > metrics is very inefficient. By the time all the databases are checked, the > day is over. This leaves no time to diagnose and repair problems. Scheduled > jobs (cron/AT/dbms_job) that query the database/logs and send email is more > effecient. At this point you have a tool. A monitoring tool, properly > architected and configured, can assist greatly by allowing the dbas to > focus on preventing problems and not wasting time determining that there is > nothing to worry about. > Dan, Advantages of rolling your own: * they do what you want, and only what you want * if your needs change, you can modify them * you don't have to deal with tech support to fix your tools * you have to learn how stuff works to monitor it Well, that last bullet point seems to be temporary with me, I seem to forget stuff after not being close to it for awhile. That also serves to point out what a disconnect GUI tools are. You want some tools? Reserve your copy of "Perl for Oracle DBA's". :) Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Replication
tks - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, August 02, 2002 11:39 AM > The application will be developped in ASP, the > deployed version would juste be a lighter version of > the main application. > > > > --- "Ramon E. Estevez" <[EMAIL PROTECTED]> > a écrit : > Don, > > > > What are you using for deploy the applications ?? > > > > I am interested in this topic too. > > > > Ramon > > > > - Original Message - > > To: "Multiple recipients of list ORACLE-L" > > <[EMAIL PROTECTED]> > > Sent: Friday, August 02, 2002 10:33 AM > > > > > > Oracle Lite is designed to do this -- the > > content-deployment part for > > standalone applications is a little buggy, but the > > data deployment and > > web-app deployment seems to work. We're instituting > > a couple of > > applications with this now, and data sync seems to > > be working fine. > > Application sync has been getting most of the > > attention so far, though, as > > we try to get the programs deployed properly without > > by-hand intervention. > > > > paquette stephane wrote: > > > > > Hi, > > > > > > We will develop a new system that has a central > > > database (817/win2000). > > > >From times to times, some users will worked with > > a > > > deployable version of the application in a region > > > without network connection. > > > When the users are back, there should be able to > > > synchronize with the centralized database. The > > data > > > goes from the deployable version to the > > centralized > > > database only. > > > > > > What strategies can be considered ? > > > > > > = > > > Stéphane Paquette > > > DBA Oracle, consultant entrepôt de données > > > Oracle DBA, datawarehouse consultant > > > [EMAIL PROTECTED] > > > > > > > > > ___ > > > Do You Yahoo!? -- Une adresse @yahoo.fr gratuite > > et en français ! > > > Yahoo! Mail : http://fr.mail.yahoo.com > > > -- > > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > > -- > > > Author: =?iso-8859-1?q?paquette=20stephane?= > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- (858) 538-5051 > > FAX: (858) 538-5051 > > > San Diego, California-- Public Internet > > access / Mailing Lists > > > > > > > > > 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.com > > -- > > Author: Ramon E. Estevez > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: > > (858) 538-5051 > > San Diego, California-- Public Internet > > access / Mailing Lists > > > > > 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). > > > > > > = > Stéphane Paquette > DBA Oracle, consultant entrepôt de données > Oracle DBA, datawarehouse consultant > [EMAIL PROTECTED] > > ___ > Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! > Yahoo! Mail : http://fr.mail.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: =?iso-8859-1?q?paquette=20stephane?= > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
Difficulty compiling forms ported from NT to UNIX
Please forgive the post (and cross-post) to DBA forums, but due to firewall upgrades, I am no longer able to access the newsgroups. If anyone has had similar experiences to the one described below, I would appreciate any guidance in finding a utility work-around. TIA. Designer generated Forms (FMBs) are moved to UNIX platform along with the attached libraries (llbs). FMBs are not compiling successfully on UNIX. (Note: They all work fine on windows platform). This is to serve the Designer generated Forms using Forms Server 6i installed on UNIX. The UNIX machine is Compaq Alpha Server running Compaq Tru64 UNIX V5.1A (Rev. 1885). The Developer software on UNIX is Developer 6i patchset 10. One of the attached library OFGTEL.llb is referencing OFGMES.llb in an Initcap case format. After making OFGMES.llb to Ofgmes.llb, OFGTEL.llb compiled alright. At this point all attached libraries are moved to UNIX and compiled successfully. But, the FMB is not compiling successfully as it is not attaching the libraries properly no matter what case we use for libraries and its compiled versions. All upper case and all lower case filenames did not work. We noticed that an error message did refre to the refreenced filename as Initcap format, so we changed all attached filename to Initcap format. Then we have to convert .fmb file to .fmt and edit it to convert external filename references to Initcap. Then convert the fmt back to .fmb format. This version of .fmb compiled successfully with all attached library files being Initcap. Editing Designer generated .fmb by converting to .fmt (text format) is tedious and error prone. We are trying to find if Oracle has a patch/utility for this bug. Has anyone had a similar experience? Erik Cohen SAIC Falls Church, VA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cohen, Erik INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: 20 Instances 1 Machine
Ethan - Now that you have clarified the reason why you want 20 instances, I'll change my advice and say that in your situation, 20 instances may be the better choice. Two other factors you need to consider: 1. An ASP is a lot like the old time-sharing systems. You must have an absolutely bulletproof billing system. This may be easier to accomplish if you have each customer in a separate O.S. username. You might be able to use the O.S. usage reports for billing with separate userids. And you must have good security to keep them from becoming root and giving themselves a discount. 2. Eventually you will need to upgrade Oracle versions. Not all customers will be able to upgrade at the same time due to other constraints on their part. Separate instances will allow you to have different customers on different Oracle versions. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, August 01, 2002 5:44 PM To: Multiple recipients of list ORACLE-L I am going to reply to this myself before I get flamed. I found a recent discussion on usenet regarding this topic. http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=3d1091af %240%2428006%24afc38c87%40news.optusnet.com.au&rnum=15&prev=/groups%3Fq%3Dto o%2Bmany%2Binstances%2Bgroup:comp.databases.oracle.server%26hl%3Den%26lr%3D% 26ie%3DUTF-8%26oe%3DUTF-8%26start%3D10%26sa%3DN Basically everyone is against this idea. However no actual technical details are provided to explain why this could not be done in a production environment with the right sized machine. The scenario presented in which one would want 20 instances on a machine is in a class room setting. However, my scenario would be acting as an ASP. Each instance would support a different customer. My fear with splitting customers up into different schemas on the same instance is that I don't want to interupt other customers if recovery is required. This would have to be a tablespace point in time reco since we would only want to reco one customers data. Perhaps this isn't as big an issue if we go with RMAN? Ethan Post (972) 577-6552 [EMAIL PROTECTED] perotdba (AIM), epost1 (Yahoo) -Original Message- Sent: Thursday, August 01, 2002 4:58 PM To: Multiple recipients of list ORACLE-L I got a request to spec out a machine that could handle 20 separate Oracle instances on a single UNIX server. SGA should total about 500 MB per instance. We have some hosts here with 6-8 instances but never tried 20 before. Wondering what types of things I should be worried about, obviously having enough memory but are there any other limitations I can expect? Anyone had to do this? Thanks, Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: User with less privileges...
Iulian - Been there, done that. It is easy when a system starts to be a little lax, assuming that meets the needs. Then things ramp up and it is painful to go back and change things the way they should have been to start with. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, August 02, 2002 2:53 AM To: Multiple recipients of list ORACLE-L Thanks guys. OK, I can control the access to public synonyms but, I also don't want them to be seen by that new user (the intruder). So, I guess in order to avoid public synonyms, I still have to create all the synonyms for every aplication's users. It seems that I'm a lazy person. Regards iulian ilies -Original Message- Sent: Friday, August 02, 2002 9:08 AM To: Multiple recipients of list ORACLE-L ** This email has been tested for viruses by F-Secure Antivirus administered by IT Network Department. ** I agree on the use of roles - it is the best way to go. However, beware that object privileges granted via a role are NOT in effect inside a definer's rights procedure/package (the default type). This *may* require some investigation and, perhaps, some changes to the application, the privileges of the package owner, the owner of the package, or the package authid, or ... I disagree about granting CONNECT to everyone - grant "create session" instead. CONNECT is actually a pre-defined role with a number of system privileges that most application users do NOT need (alter session, create table, create cluster, create database link, etc.) in addition to the "create session" system privilege. Likewise, I would grant explicit tablespace quotas. Granting RESOURCE is again overkill. Most application users don't need tablespace quotas and even if they do it is usually something trivial (e.g. 1-10 MB) in USERS. The system privilege "unlimited tablespace" (included in the RESOURCE role) is especially dangerous as it includes the SYSTEM tablespace. The "easy way" out is to just grant *everything* to PUBLIC, but it is a very poor choice from any rational security perspective - as you are now discovering. (Oracle preaches this, but doesn't actually practice it themselves!) You will need to do as Bill suggested: 1) Create a set of application-specific functional roles (e.g. CUST_SVC_REP, CUST_SVC_SUPR, CUST_SVC_ADMIN, ...). 2) Grant privileges to roles as appropriate 3) Grant roles to users as appropriate 4) Revoke all (most?) of the application object privileges (and perhaps some others) from PUBLIC The public synonyms are another issue. The don't carry any intrinsic privilege - SELECT, INSERT, etc. still have to be granted to the user or to a role granted to the user. However, public synonyms can be a performance issue and *may* be undesirable for other reasons. Don Granaman [OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, August 01, 2002 11:28 AM try this: rather than granting specific privs to PUBLIC, create specific roles for the different types of users you have, and grant appropriate object privs to each role (granting connect also helps :-). then for each user you add, just give that user whatever role is relevent and you're set . . . they will still be able to access public synonyms. only issue with this is that you'll still need to specify TS quotas to the specific users, as they don't inherit these from the roles (unless you grant RESOURCE to the role, which has UNLIMITED TABLESPACE). using roles is easy to maintain, document and manage -bill -Original Message- Sent: Thursday, August 01, 2002 11:18 AM To: Multiple recipients of list ORACLE-L Hi guys. Can you give some ideeas about this problem. I have a schema which contains all the objects for the application. The user owner of the schema is also the application administrator and having more privilleges. The other users can have access to these objects by beeing granted with some special privilleges (like select/update/insert/delete for tables, execute for functions&procedures) Because the user are deleted or added from time to time, the application author decided to grant the above kind of privilleges to the public and also create some public synonyms with the same names as the originals. BUT, my problem is that now I need to create an user (he does not have any relations with the ordinary application users) which I don't want to have any access to the hrowner objects, or just on few. Is this doable working only on this new user or I have to re-create all those synonyms and grant privilleges to every application user and revoke'em from public? Thank in advance! iulian ** The information contained in this communication is confidential and ma
RE: Oracle Corp. move to India
Title: RE: Oracle Corp. move to India Nothing like the language of the upper Midwest. :o) -Original Message-From: Godlewski, Melissa [mailto:[EMAIL PROTECTED]]Sent: Friday, August 02, 2002 11:30 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle Corp. move to India Actually it's ya, hey dare, you betcha -Original Message- From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 01, 2002 11:29 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Corp. move to India ya, hey , you betcha -Original Message- Sent: Thursday, August 01, 2002 9:38 AM To: Multiple recipients of list ORACLE-L One of these days large multi-national software companies will discover that exotic, far-off place with lower pay scales, an eager work force, a strong work ethic and lot's of talent... The Great American Midwest. You know, places like Iowa. Of course language and cultural barriers will be a challenge. :-) Steve Orr Silicon Valley Refugee in Montana -Original Message- Sent: Wednesday, July 31, 2002 2:56 PM To: Multiple recipients of list ORACLE-L I would not treat this snip of news in such a light-hearted manner. Comparing to couple of years ago, the IT job market has slumped completely from a sellers market to a buyer's market. I am not a greedy person by any means and all I asking for is a decent salary and some job security. But if this trend of massive exports of IT jobs overseas continues, I am not sure how many of us will be able to have that. BTW, before firing the slingshots at this E-mail, please note that I am pro-globalization and have heard the arguments about fair market/competition etc. But bear in mind that we are standing on uneven grounds when competing with third world programmers because of the huge housing and living expense differences. Dennis Meng Database Administrator Focal Communications Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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: Replication
Stephane - Have you considered transportable tablespaces? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, August 02, 2002 11:19 AM To: Multiple recipients of list ORACLE-L Hi, Oracle Lite would not be good for us as when I said users are working with a deployable version, I mean a bunch of users go away with their server/database and come back 2-3 months after, then they synchronized the master database. --- Don Jerman <[EMAIL PROTECTED]> a écrit : > Oracle Lite is designed to do this -- the > content-deployment part for > standalone applications is a little buggy, but the > data deployment and > web-app deployment seems to work. We're instituting > a couple of > applications with this now, and data sync seems to > be working fine. > Application sync has been getting most of the > attention so far, though, as > we try to get the programs deployed properly without > by-hand intervention. > > paquette stephane wrote: > > > Hi, > > > > We will develop a new system that has a central > > database (817/win2000). > > >From times to times, some users will worked with > a > > deployable version of the application in a region > > without network connection. > > When the users are back, there should be able to > > synchronize with the centralized database. The > data > > goes from the deployable version to the > centralized > > database only. > > > > What strategies can be considered ? > > > > = > > Stéphane Paquette > > DBA Oracle, consultant entrepôt de données > > Oracle DBA, datawarehouse consultant > > [EMAIL PROTECTED] > > > > > ___ > > Do You Yahoo!? -- Une adresse @yahoo.fr gratuite > et en français ! > > Yahoo! Mail : http://fr.mail.yahoo.com > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > -- > > Author: =?iso-8859-1?q?paquette=20stephane?= > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 > FAX: (858) 538-5051 > > San Diego, California-- Public Internet > access / Mailing Lists > > > > > 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). > > begin:vcard > n:Jerman;Don > tel;work:919.508.1886 > x-mozilla-html:TRUE > org:Database Management Service,Information > Technology > version:2.1 > email;internet:[EMAIL PROTECTED] > title:Database Administrator > adr;quoted-printable:;;Database Management > Service,Information Technology=0D=0A104 Fayetteville > Street Mall;Raleigh;NC;27699-1521;USA > x-mozilla-cpt:;-9536 > fn:Don Jerman > end:vcard > = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: extremely high number of executions
Are you setting setting_cached_cursors? This may be helpful if your app is using bind variables at all. Given the amount of parsing going on, it doesn't seem likely. Jared On Friday 02 August 2002 08:33, Johnson Poovathummoottil wrote: > Jared, > > Thanks for the reply. > The parse to execute ratio is between 7% to 15%. > > Output of your script to show parse time. is below. > > EVENT PARSE_TIME C_PARSE_TIME > Total Parse Time Wait Seconds 31923 3192300 > > > Although parsing may be an issue. I believe the bigger > problem is the high executions. With just 50 or 60 > users we do see 1500 to 2000 executions per sec. > > The "SQL*Net brak/reset to client" may be cused by > snipping sessions. We were seeing arround 100 sessions > per day were beeing snipped. Application people have > not yet figured out why or how this happens. We have a > job which runs every 20 minutes to kill sessions which > have been snipped. > > --- [EMAIL PROTECTED] wrote: > > Your database has spent 4x more time waiting on > > latch free than > > on direct path reads and writes. That's a little > > unusual. More than > > half of the waits for latches have timed out. > > > > direct path write 666089 0 747.64 > > .1122432587837361073370075170134921909835 > > direct path read663888 0 801.73 > > .1207628395150989323500349456534837201456 > > SQL*Net break/ > > reset to client 3236571 0 1633.02 > > .0504552503251125960159687521145063710946 > > latch free 2798240 1694678 2658.02 > > 0949889930813654296986677340042312310595 > > > > > > The "SQL*Net brak/reset to client" number seems a > > little unusual also. It > > would appear > > that in addition to your other performance issues, > > their is some kind of > > issue with the > > client software. I've not seen this wait before, so > > I don't know what it > > is. > > > > MetaLink is your friend. :) > > > > Anjo has already stated that he thinks parsing is > > the culprit. > > > > You might try this script to see how much time your > > database spends in > > parsing. > > > > > > > > col event format a40 head 'EVENT NAME' > > col parse_time format a10 head "TIME IN|SECONDS" > > > > col c_parse_time noprint new_value u_parse_time > > > > --col c_parse_time print > > --col c_cpu_time print > > > > set feed off > > > > select > >--'Total DB File Wait Seconds' event, > >-- why 'DB File Wait'? > >-- I dunno > >'Total Parse Time Wait Seconds' event, > >lpad(to_char(round(sum(value)/100,0)),10) > > parse_time > >,sum(value) c_parse_time > > from v$sysstat > > where name like 'parse time%' > > / > > > > set pages 0 head off > > > > @cputime > > > > set head on pages 60 feed on > > > > col db_pct format a10 head "PCT OF CPU" > > > > select > >--&&u_parse_time "DB WAIT", &&u_cpu_time "CPU > > TIME", > >'SQL Parse Time as PCT of Total CPU Time' event, > >lpad(to_char( round(&&u_parse_time / &&u_cpu_time > > * 100,0)) || '%' > > ,10) db_pct > > from dual > > / > > > > > > > > Steve Adams site www.ixora.com.au has a number of > > scripts that > > can be used to display the actual latch statistics. > > > > In addition, see if you can catch some sessions in > > the act of waiting on a > > latch. > > Given your statistics, that shouldn't be too hard. > > > > select > >s.username username, > >e.event event, > >s.sid, > >e.p1text, > >e.p1, > >e.p2text, > >e.p2, > >e.wait_time, > >e.seconds_in_wait, > >e.state > > from v$session s, v$session_wait e > > where s.username is not null > >and s.sid = e.sid > >-- skip sqlnet idle session messages > >and e.event not like '%message%client' > > order by s.username, upper(e.event) > > / > > > > > > Appendix A of the Oracle Reference manual will tell > > you how to decode the > > p1-p3 columns. > > > > HTH, > > > > Jared > > > > > > > > > > > > > > > > Johnson Poovathummoottil <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 07/31/2002 02:50 PM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > > cc: > > Subject:Re: extremely high number of > > executions > > > > > > This is the result of the query you send. Hope the > > out > > put is readable > > > > EVENTTOTAL_WAITS > > TOTAL_TIMEOUTS TIME_WAITED > > AVERAGE_WAIT > > buffer deadlock 3 3 > > 0 0 > > instance state change2 0 > > 0 0 > > library cache lock 6 0 > > .04 > > .6667 > > local write wait 21 0 > > .06 > > 2857142857142857142857142857142857142857 > > log file single write96 0 > > .09 > > .09375 > > db file single write 136 0 > >
Re: Replication
The application will be developped in ASP, the deployed version would juste be a lighter version of the main application. --- "Ramon E. Estevez" <[EMAIL PROTECTED]> a écrit : > Don, > > What are you using for deploy the applications ?? > > I am interested in this topic too. > > Ramon > > - Original Message - > To: "Multiple recipients of list ORACLE-L" > <[EMAIL PROTECTED]> > Sent: Friday, August 02, 2002 10:33 AM > > > Oracle Lite is designed to do this -- the > content-deployment part for > standalone applications is a little buggy, but the > data deployment and > web-app deployment seems to work. We're instituting > a couple of > applications with this now, and data sync seems to > be working fine. > Application sync has been getting most of the > attention so far, though, as > we try to get the programs deployed properly without > by-hand intervention. > > paquette stephane wrote: > > > Hi, > > > > We will develop a new system that has a central > > database (817/win2000). > > >From times to times, some users will worked with > a > > deployable version of the application in a region > > without network connection. > > When the users are back, there should be able to > > synchronize with the centralized database. The > data > > goes from the deployable version to the > centralized > > database only. > > > > What strategies can be considered ? > > > > = > > Stéphane Paquette > > DBA Oracle, consultant entrepôt de données > > Oracle DBA, datawarehouse consultant > > [EMAIL PROTECTED] > > > > > ___ > > Do You Yahoo!? -- Une adresse @yahoo.fr gratuite > et en français ! > > Yahoo! Mail : http://fr.mail.yahoo.com > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > -- > > Author: =?iso-8859-1?q?paquette=20stephane?= > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 > FAX: (858) 538-5051 > > San Diego, California-- Public Internet > access / Mailing Lists > > > > > 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.com > -- > Author: Ramon E. Estevez > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > 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). > > = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: data modeling question - child table with multiple parents
On a system that you expect to have heavy inserts and/or deletes, prototyping this and testing it would be a good idea. I haven't done that myself. If it ever caused me a problem. I was blissfully ignorant. :) Jared On Thursday 01 August 2002 11:18, Magaliff, Bill wrote: > jared: > > any thoughts on the point at which this becomes a potential performance > bottleneck? pretty simple if there are two potential fk's as in your > example - but what about 4 or 5 fk id's? > > -biill > > -Original Message- > Sent: Thursday, August 01, 2002 1:48 PM > To: Multiple recipients of list ORACLE-L > > > btw, in your first solution, how are you going to implement mutual > > exclusiveness of EMPLOYEE_ID and SUPLIER_ID? trigger? - not very > > elegant. > > Actually quite simple and elegant: > > alter table add constraint only_one > ( check ( > ( employee_id is null and supplier_id is not null ) > or > ( supplier_id is null and employee_id is not null ) > ) > ) > > Jared > > > > > > > "Igor Neyman" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 07/31/2002 02:20 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject:Re: data modeling question - child table with > multiple parents > > > yet, another solution: > > add another table, called i.e. "ACTOR" (actor_id, actor_type); > sub-entity tables "EMPLOYEE", "SUPLLIER", "CONTRACTOR" will store > sub-entity > specific information, and their PK (employee_id, supplier_id, ...) will be > foreign keys to actor_id in "ACTOR" table; > table "ADDRESS" will reference "ACTOR" table (not multiple sub-entities), > and you can enforce this relationship in the database; > thus, adding new sub_entity (like "VENDOR") will not require any changes > in > existing tables; > also, you can implement "TELEPHONE" table the same way (referencing > "ACTOR" > table). > > btw, in your first solution, how are you going to implement mutual > exclusiveness of EMPLOYEE_ID and SUPLIER_ID? trigger? - not very elegant. > > Igor Neyman, OCP DBA > [EMAIL PROTECTED] > > > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Wednesday, July 31, 2002 4:43 PM > > > Good day, all: > > > > Am curious to hear opinions on how to model a child table that has > > multiple > > > parent tables (i.e., foreign key to multiple parents) > > > > Example: > > There's a table that stores Addresses (table ADDRESS) for both employees > > (table EMPLOYEE) and suppliers (table SUPPLIER). > > > > Each of these tables has a Primary Key field called ID. > > > > One way to set this up would be for the ADDRESS table to have 2 fields, > > EMPLOYEE_ID and SUPPLIER_ID, which would be mutually exclusive (i.e., > > one > or > > > the other, to indicate the parent record of the address). > > > > Another solutions if for the ADDRESS table to have two fields to > > indicate > > > the parent table name and parent table pk value. > > > > The first method enables me (the dba) to create foreign keys from the > > address table to each of the parent tables to validate data. The second > > method does not enable me to create such foreign keys (leaving it to the > > developers to validate date and insure referential integrity) but would > > also > > > easily facilitate the addition of other parent tables (e.g., CONTRACTOR, > > VENDOR, etc.) without altering the ADDRESS table itself. > > > > Any and all thoughts, comments, opinions, experiences are most welcome. > > > > Thanks! > > bill magaliff > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Magaliff, Bill > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > 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.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
OWB 9.0.3.x on NT4
Hi, Is anyone running OWB 9.0.3.33.0 or 9.0.3.35.0 on NT 4? I'm having some problems and would like to compare configurations with anyone that has it working. Thanks Beth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 Corp. move to India
Title: RE: Oracle Corp. move to India Actually it's ya, hey dare, you betcha -Original Message- From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 01, 2002 11:29 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Corp. move to India ya, hey , you betcha -Original Message- Sent: Thursday, August 01, 2002 9:38 AM To: Multiple recipients of list ORACLE-L One of these days large multi-national software companies will discover that exotic, far-off place with lower pay scales, an eager work force, a strong work ethic and lot's of talent... The Great American Midwest. You know, places like Iowa. Of course language and cultural barriers will be a challenge. :-) Steve Orr Silicon Valley Refugee in Montana -Original Message- Sent: Wednesday, July 31, 2002 2:56 PM To: Multiple recipients of list ORACLE-L I would not treat this snip of news in such a light-hearted manner. Comparing to couple of years ago, the IT job market has slumped completely from a sellers market to a buyer's market. I am not a greedy person by any means and all I asking for is a decent salary and some job security. But if this trend of massive exports of IT jobs overseas continues, I am not sure how many of us will be able to have that. BTW, before firing the slingshots at this E-mail, please note that I am pro-globalization and have heard the arguments about fair market/competition etc. But bear in mind that we are standing on uneven grounds when competing with third world programmers because of the huge housing and living expense differences. Dennis Meng Database Administrator Focal Communications Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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: User with less privileges...
Or, you can use a logon trigger to alter the user's schema to the application schema they need access to. Here's some code for that. For each user, insert the user_name and schema_name they need access to. Rem Rem NAME: db_logon_trigger.sql BY: lvordos Rem Rem DESCRIPTION: Creates table & trigger to set the current_schema at Rem logon time as defined for users in system.default_schema. This Rem script must be run as a DBA user. Rem Rem Concept cloned from http://www.ixora.com.au (Steve Adams) with Rem modifications. Rem set echo on verify off feedback on whenever sqlerror exit sql.sqlcode ; spool /tmp/db_logon_trigger.txt CREATE TABLE system.default_schema ( user_namevarchar2(30), schema_name varchar2(30) ) TABLESPACE tools ; ALTER TABLE system.default_schema ADD CONSTRAINT pk_default_schema PRIMARY KEY (user_name) USING INDEX TABLESPACE tools ; CREATE OR REPLACE trigger system.set_current_schema AFTER LOGON on database DECLARE default_schema varchar2(30); nodata boolean := FALSE; BEGIN BEGIN SELECT schema_name into default_schema FROM system.default_schema where user_name = user; EXCEPTION WHEN NO_DATA_FOUND THEN nodata := TRUE; END; IF nodata = FALSE THEN execute immediate 'alter session set current_schema = ' ||default_schema ; END IF ; END ; / spool off [EMAIL PROTECTED] wrote: > > Thanks guys. > OK, I can control the access to public synonyms but, I also don't want them > to be seen by that new user (the intruder). So, I guess in order to avoid > public synonyms, I still have to create all the synonyms for every > aplication's users. > It seems that I'm a lazy person. > > Regards > iulian ilies > > -Original Message- > Sent: Friday, August 02, 2002 9:08 AM > To: Multiple recipients of list ORACLE-L > > ** > This email has been tested for viruses by F-Secure Antivirus > administered by IT Network Department. > ** > > I agree on the use of roles - it is the best way to go. However, beware > that object privileges granted via a role are NOT in effect inside a > definer's rights procedure/package (the default type). This *may* require > some investigation and, perhaps, some changes to the application, the > privileges of the package owner, the owner of the package, or the package > authid, or ... > > I disagree about granting CONNECT to everyone - grant "create session" > instead. CONNECT is actually a pre-defined role with a number of system > privileges that most application users do NOT need (alter session, create > table, create cluster, create database link, etc.) in addition to the > "create session" system privilege. > > Likewise, I would grant explicit tablespace quotas. Granting RESOURCE is > again overkill. Most application users don't need tablespace quotas and > even if they do it is usually something trivial (e.g. 1-10 MB) in USERS. > The system privilege "unlimited tablespace" (included in the RESOURCE role) > is especially dangerous as it includes the SYSTEM tablespace. > > The "easy way" out is to just grant *everything* to PUBLIC, but it is a very > poor choice from any rational security perspective - as you are now > discovering. (Oracle preaches this, but doesn't actually practice it > themselves!) > > You will need to do as Bill suggested: > > 1) Create a set of application-specific functional roles (e.g. CUST_SVC_REP, > CUST_SVC_SUPR, CUST_SVC_ADMIN, ...). > 2) Grant privileges to roles as appropriate > 3) Grant roles to users as appropriate > 4) Revoke all (most?) of the application object privileges (and perhaps some > others) from PUBLIC > > The public synonyms are another issue. The don't carry any intrinsic > privilege - SELECT, INSERT, etc. still have to be granted to the user or to > a role granted to the user. However, public synonyms can be a performance > issue and *may* be undesirable for other reasons. > > Don Granaman > [OraSaurus] > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Thursday, August 01, 2002 11:28 AM > > try this: > > rather than granting specific privs to PUBLIC, create specific roles for the > different types of users you have, and grant appropriate object privs to > each role (granting connect also helps :-). then for each user you add, > just give that user whatever role is relevent and you're set . . . they will > still be able to access public synonyms. only issue with this is that > you'll still need to specify TS quotas to the specific users, as they don't > inherit these from the roles (unless you grant RESOURCE to the role, which > has UNLIMITED TABLESPACE). >
Re: Replication
Hi, Oracle Lite would not be good for us as when I said users are working with a deployable version, I mean a bunch of users go away with their server/database and come back 2-3 months after, then they synchronized the master database. --- Don Jerman <[EMAIL PROTECTED]> a écrit : > Oracle Lite is designed to do this -- the > content-deployment part for > standalone applications is a little buggy, but the > data deployment and > web-app deployment seems to work. We're instituting > a couple of > applications with this now, and data sync seems to > be working fine. > Application sync has been getting most of the > attention so far, though, as > we try to get the programs deployed properly without > by-hand intervention. > > paquette stephane wrote: > > > Hi, > > > > We will develop a new system that has a central > > database (817/win2000). > > >From times to times, some users will worked with > a > > deployable version of the application in a region > > without network connection. > > When the users are back, there should be able to > > synchronize with the centralized database. The > data > > goes from the deployable version to the > centralized > > database only. > > > > What strategies can be considered ? > > > > = > > Stéphane Paquette > > DBA Oracle, consultant entrepôt de données > > Oracle DBA, datawarehouse consultant > > [EMAIL PROTECTED] > > > > > ___ > > Do You Yahoo!? -- Une adresse @yahoo.fr gratuite > et en français ! > > Yahoo! Mail : http://fr.mail.yahoo.com > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > -- > > Author: =?iso-8859-1?q?paquette=20stephane?= > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 > FAX: (858) 538-5051 > > San Diego, California-- Public Internet > access / Mailing Lists > > > > > 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). > > begin:vcard > n:Jerman;Don > tel;work:919.508.1886 > x-mozilla-html:TRUE > org:Database Management Service,Information > Technology > version:2.1 > email;internet:[EMAIL PROTECTED] > title:Database Administrator > adr;quoted-printable:;;Database Management > Service,Information Technology=0D=0A104 Fayetteville > Street Mall;Raleigh;NC;27699-1521;USA > x-mozilla-cpt:;-9536 > fn:Don Jerman > end:vcard > = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: SOLVED: IFILE in node-specific init file in VMS
Hi Bruce, Here is the quote from Oracle support: "I can't nail down the bug number right now, but I remember a problem with empty lines in the init.ora." I haven't found anything on Metalink that references this bug. In any case, removing the blank lines worked for me. YMMV. Mark -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 01, 2002 10:53 PM To: Multiple recipients of list ORACLE-L Subject:RE: SOLVED: IFILE in node-specific init file in VMS Mark, I'm glad you got it solved. Maybe it is platform specific? We don't have OPS but do use ifile notation We have lots of blank lines in addition to a number of comment lines beginning with "#" and we haven't had any problems, that I know of :-). We're running 81714 under NT4 SP6a. Did support give a reference to a Metalink note describing issues with blank lines in init files? Thanks, Bruce Reardon -Original Message- Sent: Friday, 2 August 2002 10:33 Blank lines in your init.ora are a very bad thing. Oracle support and Metalink get beat up quite often on this list but I must say they solved this problem very quickly. Thanks to everyone who replied. Mark -Original Message- Sent: Thursday, August 01, 2002 9:38 AM Is the logical defined as /system/exec? If so and doesn't work, I would open a tar b/c it must be something in your env. I am running Oracle 8.1.7.3 OpenVMS 7.2 and have no problem. I do put the ifile stmt 1st line in initSID.ora file so I can easily override any parameter. Gene >>> [EMAIL PROTECTED] 07/31/02 06:30PM >>> Hi Gene, I've tried using both a logical (ora_system) and the full path. It doesn't work either way. Tom - I'm tempted but I would like the simplicity of maintaining a single init.ora. Mark -Original Message- Sent: Wednesday, July 31, 2002 3:34 PM I use ifile w/out a problem in OpenVMS. Do you reference it w/ full path or logical? I don't like using init...ora and config...ora. I use an instance specific initSID.ora that ifile's a common init.ora file into each db. Its nice to put a change in 1 file and its applied to all dbs. Gene >>> [EMAIL PROTECTED] 07/31/02 05:04PM >>> Mark, throw away the IFILE thingy. it is not worth the trouble! create instance specific init.ora files. solves your problem. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, July 31, 2002 4:49 PM Greetings elitist *nix bigots, I'm starting to upgrade our OPS databases on OpenVMS from 7.3 to 8.1.7.3 and I've run into a problem with the IFILE parameter in the node specific init file. It appears Oracle is not reading the generic init.ora specified in the IFILE parameter in the node specific init file. Only parameters defined in the node specific init file are effective. Has anyone "been there, done that"? Thanks, Mark Stahlke Elitist VMS Bigot Denver Newspaper Agency -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Stahlke, Mark INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Replication
Don, What are you using for deploy the applications ?? I am interested in this topic too. Ramon - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, August 02, 2002 10:33 AM Oracle Lite is designed to do this -- the content-deployment part for standalone applications is a little buggy, but the data deployment and web-app deployment seems to work. We're instituting a couple of applications with this now, and data sync seems to be working fine. Application sync has been getting most of the attention so far, though, as we try to get the programs deployed properly without by-hand intervention. paquette stephane wrote: > Hi, > > We will develop a new system that has a central > database (817/win2000). > >From times to times, some users will worked with a > deployable version of the application in a region > without network connection. > When the users are back, there should be able to > synchronize with the centralized database. The data > goes from the deployable version to the centralized > database only. > > What strategies can be considered ? > > = > Stéphane Paquette > DBA Oracle, consultant entrepôt de données > Oracle DBA, datawarehouse consultant > [EMAIL PROTECTED] > > ___ > Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! > Yahoo! Mail : http://fr.mail.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: =?iso-8859-1?q?paquette=20stephane?= > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Monitoring occurence of snaphot too old
Dear List members, I was wondering if there is a way to monitor the database and tell if there is a possiblility of snapshot too old error occurence. Any input is highly appreciated.. Thanks Mohammed Ahsanuddin Oracle DBA -- 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 Diego, California-- Public Internet access / Mailing Lists 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: Free ware databases: which are worth the money?
Mark, My recommendation is Interbase, very good DB. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, August 02, 2002 5:33 AM > Hi, > we are investigating some freeware databases for deployment on systems that > dont justify the cost of an oracle license, on linux. What databases out > these can cope with a OLTP load, all transaction based, with some > reporting? Uncomplicated databases, with mid size volumes of transactions > (say low millions) and some reporting queries? I guess reliability is the > primary concern, if something can be built as solidly as an oracle > instance, with whatever OS protection this would need, then its a starting > point for making a non oracle freeware enterprise database. > Anyone have any suggestions on what I should download first? > > Thanks! > Mark Teehan > Singapore > ERG Group -- > The contents of this email and any attachments are confidential > and may only be read by the intended recipient. > - > > ERG Group -- > The contents of this email and any attachments are confidential > and may only be read by the intended recipient. > - > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mark Teehan > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: 20 Instances 1 Machine
Thanks for the comments, all were good and James makes some good points (your right up the road from me by the way). I personally like the blade systems. I have only seen Egenera's Linux based system but I guess HP and others have some systems out. How does the cost on these systems look? Anyone seen anything they think is something worth looking at? Ethan Post perotdba (AIM), epost1 (Yahoo) -Original Message- Sent: Thursday, August 01, 2002 9:23 PM To: Multiple recipients of list ORACLE-L Your biggest problem is not going to be physical RAM or disk space (either of those could simply be purchased large enough). However, you *will* encounter a problem with "Shared Memory". 32-bit (and even 64-bit) operating systems have a finite amount of "shared memory" addressable for use by 32-bit applications (namely the RDBMS shipped with the Oracle Applications). This number is 1.7GBytes on HP/UX and, I think, 2GBytes on Solaris. This "Shared Memory" limitation is systemwide. The Oracle RDBMS uses shared memory heavily for major components of the SGA. As a result, if you're running a 32-bit version of Oracle, this number represents the sum of all SGA's running on that machine at the time. (So, at 500M/instance, you'll run out somewhere between 3 and 4 instances). Possible solutions would be: 1) Use a 64-bit version of the Oracle RDBMS as certified for your platform. A 64-bit version of Oracle would address shared memory from a much larger total pool (most likely an absurdly large number), thus avoiding this 32-bit "Shared Memory" problem. 2) Consider using something like Sun's "System Domains" to partition a big box into multiple "virtual machines". Each of these Domains would have it's own shared memory pool. 3) Consider using seperate machines. Personally, I'd vote for seperate machines. I tend to prefer only one production system exist on any given host as it tends to eliminate much of the performance-oriented fingerpointing that is bound to come up. Additionally, running a large number of production instances on a single host can be alot like putting all of your eggs into one basket. It may be cheaper, but if something happens to that basket, everything's hosed. As far as hardware: Lots of disk, plenty of I/O channels, and plenty of CPUs. Without actually knowing the nature of your applications, I'd say you're probably looking in the SunFire 6800 or SunFire 15k range (if you're looking at Sun equipment). Post, Ethan wrote: > I got a request to spec out a machine that could handle 20 separate Oracle > instances on a single UNIX server. SGA should total about 500 MB per > instance. We have some hosts here with 6-8 instances but never tried 20 > before. Wondering what types of things I should be worried about, obviously > having enough memory but are there any other limitations I can expect? > Anyone had to do this? > > Thanks, > Ethan -- James James J. Morrow E-Mail: [EMAIL PROTECTED] Senior Principal Consultant Tenure Systems, Inc. McKinney, TX, USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Bad Sql From SYS
Hi Everyone, I ran a query looking for bad SQL (high disk I/O or very large number of buffer gets) and found that the userid of some of the SQL is SYS. A sample of the SQL is : SELECT OWNER, TNAME, ROWNER, RTNAME, CNAME, CNO, RCNO, ACTION, ENABLED, DEFER, OBJID, PROPERTY , REFTYPE FROM SYS.EXU8REF WHERE OWNERID=:1 This SQL was executed does no I/O, but does 378,765 buffers gets per execution and was executed 572 times in one day on our system (8.1.6). Any ideas on what is causing this? Is it a problem? There are other SQL executions that have what I think are unusually high buffer gets also. Thanks, Bill Whitaker Westinghouse -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Whitaker, William M. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: SOLVED: IFILE in node-specific init file in VMS
Interesting find. In my VMS env, I do not have blank lines but I do in Unix init.ora's. It must be a VMS thing, since it doesn't like blank lines in DCL scripts either :) Gene >>> [EMAIL PROTECTED] 08/02/02 12:53AM >>> Mark, I'm glad you got it solved. Maybe it is platform specific? We don't have OPS but do use ifile notation We have lots of blank lines in addition to a number of comment lines beginning with "#" and we haven't had any problems, that I know of :-). We're running 81714 under NT4 SP6a. Did support give a reference to a Metalink note describing issues with blank lines in init files? Thanks, Bruce Reardon -Original Message- Sent: Friday, 2 August 2002 10:33 Blank lines in your init.ora are a very bad thing. Oracle support and Metalink get beat up quite often on this list but I must say they solved this problem very quickly. Thanks to everyone who replied. Mark -Original Message- Sent: Thursday, August 01, 2002 9:38 AM Is the logical defined as /system/exec? If so and doesn't work, I would open a tar b/c it must be something in your env. I am running Oracle 8.1.7.3 OpenVMS 7.2 and have no problem. I do put the ifile stmt 1st line in initSID.ora file so I can easily override any parameter. Gene >>> [EMAIL PROTECTED] 07/31/02 06:30PM >>> Hi Gene, I've tried using both a logical (ora_system) and the full path. It doesn't work either way. Tom - I'm tempted but I would like the simplicity of maintaining a single init.ora. Mark -Original Message- Sent: Wednesday, July 31, 2002 3:34 PM I use ifile w/out a problem in OpenVMS. Do you reference it w/ full path or logical? I don't like using init...ora and config...ora. I use an instance specific initSID.ora that ifile's a common init.ora file into each db. Its nice to put a change in 1 file and its applied to all dbs. Gene >>> [EMAIL PROTECTED] 07/31/02 05:04PM >>> Mark, throw away the IFILE thingy. it is not worth the trouble! create instance specific init.ora files. solves your problem. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, July 31, 2002 4:49 PM Greetings elitist *nix bigots, I'm starting to upgrade our OPS databases on OpenVMS from 7.3 to 8.1.7.3 and I've run into a problem with the IFILE parameter in the node specific init file. It appears Oracle is not reading the generic init.ora specified in the IFILE parameter in the node specific init file. Only parameters defined in the node specific init file are effective. Has anyone "been there, done that"? Thanks, Mark Stahlke Elitist VMS Bigot Denver Newspaper Agency -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Replication
Oracle Lite is designed to do this -- the content-deployment part for standalone applications is a little buggy, but the data deployment and web-app deployment seems to work. We're instituting a couple of applications with this now, and data sync seems to be working fine. Application sync has been getting most of the attention so far, though, as we try to get the programs deployed properly without by-hand intervention. paquette stephane wrote: > Hi, > > We will develop a new system that has a central > database (817/win2000). > >From times to times, some users will worked with a > deployable version of the application in a region > without network connection. > When the users are back, there should be able to > synchronize with the centralized database. The data > goes from the deployable version to the centralized > database only. > > What strategies can be considered ? > > = > Stéphane Paquette > DBA Oracle, consultant entrepôt de données > Oracle DBA, datawarehouse consultant > [EMAIL PROTECTED] > > ___ > Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! > Yahoo! Mail : http://fr.mail.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: =?iso-8859-1?q?paquette=20stephane?= > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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). begin:vcard n:Jerman;Don tel;work:919.508.1886 x-mozilla-html:TRUE org:Database Management Service,Information Technology version:2.1 email;internet:[EMAIL PROTECTED] title:Database Administrator adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA x-mozilla-cpt:;-9536 fn:Don Jerman end:vcard
Re: extremely high number of executions
Jared, Thanks for the reply. The parse to execute ratio is between 7% to 15%. Output of your script to show parse time. is below. EVENTPARSE_TIME C_PARSE_TIME Total Parse Time Wait Seconds 31923 3192300 Although parsing may be an issue. I believe the bigger problem is the high executions. With just 50 or 60 users we do see 1500 to 2000 executions per sec. The "SQL*Net brak/reset to client" may be cused by snipping sessions. We were seeing arround 100 sessions per day were beeing snipped. Application people have not yet figured out why or how this happens. We have a job which runs every 20 minutes to kill sessions which have been snipped. --- [EMAIL PROTECTED] wrote: > Your database has spent 4x more time waiting on > latch free than > on direct path reads and writes. That's a little > unusual. More than > half of the waits for latches have timed out. > > direct path write 666089 0 747.64 > .1122432587837361073370075170134921909835 > direct path read663888 0 801.73 > .1207628395150989323500349456534837201456 > SQL*Net break/ > reset to client 3236571 0 1633.02 > .0504552503251125960159687521145063710946 > latch free 2798240 1694678 2658.02 > 0949889930813654296986677340042312310595 > > > The "SQL*Net brak/reset to client" number seems a > little unusual also. It > would appear > that in addition to your other performance issues, > their is some kind of > issue with the > client software. I've not seen this wait before, so > I don't know what it > is. > > MetaLink is your friend. :) > > Anjo has already stated that he thinks parsing is > the culprit. > > You might try this script to see how much time your > database spends in > parsing. > > > > col event format a40 head 'EVENT NAME' > col parse_time format a10 head "TIME IN|SECONDS" > > col c_parse_time noprint new_value u_parse_time > > --col c_parse_time print > --col c_cpu_time print > > set feed off > > select >--'Total DB File Wait Seconds' event, >-- why 'DB File Wait'? >-- I dunno >'Total Parse Time Wait Seconds' event, >lpad(to_char(round(sum(value)/100,0)),10) > parse_time >,sum(value) c_parse_time > from v$sysstat > where name like 'parse time%' > / > > set pages 0 head off > > @cputime > > set head on pages 60 feed on > > col db_pct format a10 head "PCT OF CPU" > > select >--&&u_parse_time "DB WAIT", &&u_cpu_time "CPU > TIME", >'SQL Parse Time as PCT of Total CPU Time' event, >lpad(to_char( round(&&u_parse_time / &&u_cpu_time > * 100,0)) || '%' > ,10) db_pct > from dual > / > > > > Steve Adams site www.ixora.com.au has a number of > scripts that > can be used to display the actual latch statistics. > > In addition, see if you can catch some sessions in > the act of waiting on a > latch. > Given your statistics, that shouldn't be too hard. > > select >s.username username, >e.event event, >s.sid, >e.p1text, >e.p1, >e.p2text, >e.p2, >e.wait_time, >e.seconds_in_wait, >e.state > from v$session s, v$session_wait e > where s.username is not null >and s.sid = e.sid >-- skip sqlnet idle session messages >and e.event not like '%message%client' > order by s.username, upper(e.event) > / > > > Appendix A of the Oracle Reference manual will tell > you how to decode the > p1-p3 columns. > > HTH, > > Jared > > > > > > > > Johnson Poovathummoottil <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 07/31/2002 02:50 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:Re: extremely high number of > executions > > > This is the result of the query you send. Hope the > out > put is readable > > EVENTTOTAL_WAITS > TOTAL_TIMEOUTS TIME_WAITED > AVERAGE_WAIT > buffer deadlock 3 3 > 0 0 > instance state change2 0 > 0 0 > library cache lock 6 0 > .04 > .6667 > local write wait 21 0 > .06 > 2857142857142857142857142857142857142857 > log file single write96 0 > .09 > .09375 > db file single write 136 0 > .12 > .0882352941176470588235294117647058823529 > switch logfile command 3 0 > .16 > 5.33 > single-task message 8 0 > .2 2.5 > checkpoint completed 1 0 > .22 22 > LGWR wait for redo copy 802 4 > .25 > .0311720698254364089775561097256857855362 > row cache lock 340 0 > .31
_sqlexec_progression_cost
_sqlexec_progression_cost=0 is a required setting for Oracle Applications 11i, running the Cost-Based optimizer. Would it make sense to use it with the Rule-based optimizer (e.g. in Oracle Applications 11.0) ? I don't think that the parameter applies only with the Cost-based optimizer but also with the Rule-based optimizer. The performance impact of the default value (1000) for this parameter in 8i relates to using timed_statistics=TRUE and SQL_TRACE=TRUE. I do have timed_statistics set and the developers still have a number of programs where sql_trace=TRUE (or when an analyst runs a report from the Applications, he enables tracing on the report). So, should I set it to 0, in Oracle applications 11.0, Rule-Based on 8.1.7.2 ? Per note 62143.1 on "Understanding and Tuning the Shared Pool in Oracle7, Oracle8 and Oracle8i" : "SQLEXEC_PROGRESSION_COST parameter (8.1.5 onwards) This is a hidden parameter which was introduced in Oracle 8.1.5. The parameter is included here as the default setting has caused some problems with SQL sharability. Setting this parameter to 0 can avoid these issues which result in multiple versions statements in the shared pool. Eg: Add the following to the init.ora file # _SQLEXEC_PROGRESSION_COST is set to ZERO to avoid SQL sharing issues # See Note:62143.1 for details _sqlexec_progression_cost=0 Note that a side effect of setting this to '0' is that the V$SESSION_LONGOPS view is not populated by long running queries. See for more details of this parameter. " Also, note 68955.1 recommends setting it to 0 to resolve "some cursor sharing bugs in Oracle8i". I don't query V$SESSION_LONGOPS so it doesn't matter to me if this view doesn't get updated. Hemant K Chitale Now using Eudora Email. Try it ! My home page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Massive update troubles
"should" being the operative wordthey "should" be doing the transforms prior to or during load (in my opinion), since they're file-filter or file-merge operations mostly. Bart Cortenbach wrote: > "...the SAP requirements are slowly mutating...", > "...the developers are still tweaking the process..." > > If the developpers are still tweaking the process, and the requirements > still evolving, it means that they are still in a test phase. > If they are still in a test phase, they shouldn't use production files but > test files...smaller files. > > Don Jerman <[EMAIL PROTECTED]>@fatcity.com on 2002-08-01 17:14:40 > > Please respond to [EMAIL PROTECTED] > > Sent by:[EMAIL PROTECTED] > > To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > > I have a data conversion team working on our financial data, > prepping it for load into SAP. My concept for the conversion > process was to download the flat files, run programs written in C > or Perl to transform the data, then use SQL*Loader to load them > into relational tables for constraint testing and general > analysis, prior to export to the SAP system. > > At some point early on I lost control, and this mutated into: > download the flat files, load them into Oracle, run stored > procedures to transform the data through 2 or 3 stages to a new > schema for SAP. Still ok, you're thinking. > > But -- now we're running more than a couple hundred thousand rows > at the time, and the developers are still tweaking the process > (because the SAP requirements are slowly mutating -- another > issue). Frequently the developers will stop a long running query > with ALTER SESSION KILL -- this is working but often takes a very > long time to roll back. Well, there's the rub -- this is a PC > system, and the developers frequently want to make a tweak to > their program and re-run it. This puts a tremendous load on what > the PC isn't good at -- I/O. > > So I wind up with a frantic developer on the phone "the Oracle > server's locked up!" and sure enough, he's right -- there's so > much going on in there you can't do anything that requires a disk > access. The evolved response is shutdown abort, startup > mount, recover, open. This always works and always takes about 3 > minutes. Naturally, I've moved them to their Very Own server, so > that this doesn't disrupt other work. > > Can anyone turn their diagonstic eyes on this situation and > suggest a better method for me to either limit the damage or > recover from the problem? Or even a good method for analyzing > the problem, given that we haven't the downtime to wait for all > processes to complete (once in this state, a weekend can pass > without successfully ending whatever the database is doing). > > (See attached file: djerman.vcf) begin:vcard n:Jerman;Don tel;work:919.508.1886 x-mozilla-html:TRUE org:Database Management Service,Information Technology version:2.1 email;internet:[EMAIL PROTECTED] title:Database Administrator adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA x-mozilla-cpt:;-9536 fn:Don Jerman end:vcard
Re: Free ware databases: which are worth the money?
hi, we're using postgres extensively. it's cheaper than oracle, and requires little management. but that's what i don't like about it. the data dictionary tables are scarce and cryptic, and with little documentation available (the interactive docs online are useless for most of my inquiries... have to slog through tons of pages to find what i'm looking for.) for instance, *where* do i find a list of all foreign key constraints? and if you create databases to mimic tablespaces in oracle, it doesn't work bc you can select from objects across databases. good luck! kris kaustin=# select version(); version - PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC egcs-2.91.66 (1 row) On Fri, 2 Aug 2002, Daniel Wisser wrote: > hi! > > i can strongly recommend PostgreSQL. i have worked with it modelling > data for a java application and perl cgis using it. > > it supports transactions, functions in pure sql, a procedural > language similar to PL/SQL etc. etc. and is very robust. > > the only thing i miss is handling tablespaces as on oracle. > > i have sofar only used it on debian, but it should also be fine > on other linuxes and some elitist bigots work with it on sun. > > there is also good literature and a very good o'reilly book on > it. on the web htpp://www.postgresql.org > > regards > > > Mark Teehan wrote: > > > > Hi, > > we are investigating some freeware databases for deployment on systems that > > dont justify the cost of an oracle license, on linux. What databases out > > these can cope with a OLTP load, all transaction based, with some > > reporting? Uncomplicated databases, with mid size volumes of transactions > > (say low millions) and some reporting queries? I guess reliability is the > > primary concern, if something can be built as solidly as an oracle > > instance, with whatever OS protection this would need, then its a starting > > point for making a non oracle freeware enterprise database. > > Anyone have any suggestions on what I should download first? > > > > Thanks! > > Mark Teehan > > Singapore > > ERG Group -- > > The contents of this email and any attachments are confidential > > and may only be read by the intended recipient. > > - > > > > ERG Group -- > > The contents of this email and any attachments are confidential > > and may only be read by the intended recipient. > > - > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Mark Teehan > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > 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). > > +-+--+-+--+-+-+-+--+--+--+-+ kris austin-murray ... senior database manager, ocp ... advance internet www.advance.net ... [EMAIL PROTECTED] ... 201-459-2805 +-+--+-+--+-+-+-+--+--+--+-+ "Darkness cannot drive out darkness; only light can do that. Hate cannot drive out hate; only love can do that." - Martin Luther King, Jr. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kris Austin-Murray INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
DUAL revisited
I've been reading the thread on DUAL vs X$DUAL, read the referenced article and tried some testing on our system. I do a simple select from DUAL and I get the same statistics as were in the article, but sometimes I also get 1 memory sort. Does anyone know why this would be? And if this is true, that really makes me want to change over to X$DUAL. Also, what is the consensus about creating a view for DUAL that references X$DUAL? I'm running the Oracle Application and cannot change all of their code to use something other than DUAL, and there is a lot of it. Here are the statistics on the select. Notice the difference between the first vs repeat of the same seelct. Connected to: Oracle8i Enterprise Edition Release 8.1.7.1.1 - Production With the Partitioning option JServer Release 8.1.7.1.1 - Production SQL> set autotrace traceonly SQL> select 'y' from dual; Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1) 10 TABLE ACCESS (FULL) OF 'DUAL' (Cost=2 Card=1) Statistics -- 0 recursive calls 4 db block gets 1 consistent gets 0 physical reads 0 redo size 361 bytes sent via SQL*Net to client 425 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 1 sorts (memory) 0 sorts (disk) 1 rows processed SQL> / Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1) 10 TABLE ACCESS (FULL) OF 'DUAL' (Cost=2 Card=1) Statistics -- 0 recursive calls 4 db block gets 1 consistent gets 0 physical reads 0 redo size 361 bytes sent via SQL*Net to client 425 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed SQL> Thanks for your input. John Zoltak North American Mfg Co 4455 East 71st Street Cleveland Ohio 44105 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Zoltak INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: 20 Instances 1 Machine
I would recommend a Sun E-15k. The best option would be to domain it into separate virtual boxes so that each instance has it's own space. Or, you could go the other route and buy a bunch of Ultra-2 machines and give each database its own box. Or, maybe a blade for each instance? -Original Message- Sent: Friday, August 02, 2002 5:23 AM To: Multiple recipients of list ORACLE-L You also have to consider the OS overhead. Putting 20 instances means hundreds of processes. Just managing all this at the system level can be resource consuming. Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenkins, Michael-EDS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Free ware databases: which are worth the money?
Title: RE: Free ware databases: which are worth the money? hi! is PostgreeSQL also available on the windows platform and are there supported (commercial) versions around? thank you -Original Message- From: Daniel Wisser [mailto:[EMAIL PROTECTED]] Sent: Friday, August 02, 2002 14:58 To: Multiple recipients of list ORACLE-L Subject: Re: Free ware databases: which are worth the money? hi! i can strongly recommend PostgreSQL. i have worked with it modelling data for a java application and perl cgis using it. it supports transactions, functions in pure sql, a procedural language similar to PL/SQL etc. etc. and is very robust. the only thing i miss is handling tablespaces as on oracle. i have sofar only used it on debian, but it should also be fine on other linuxes and some elitist bigots work with it on sun. there is also good literature and a very good o'reilly book on it. on the web htpp://www.postgresql.org regards Mark Teehan wrote: > > Hi, > we are investigating some freeware databases for deployment on systems that > dont justify the cost of an oracle license, on linux. What databases out > these can cope with a OLTP load, all transaction based, with some > reporting? Uncomplicated databases, with mid size volumes of transactions > (say low millions) and some reporting queries? I guess reliability is the > primary concern, if something can be built as solidly as an oracle > instance, with whatever OS protection this would need, then its a starting > point for making a non oracle freeware enterprise database. > Anyone have any suggestions on what I should download first? > > Thanks! > Mark Teehan > Singapore > ERG Group -- > The contents of this email and any attachments are confidential > and may only be read by the intended recipient. > - > > ERG Group -- > The contents of this email and any attachments are confidential > and may only be read by the intended recipient. > - > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mark Teehan > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > > 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 Wisser, Mag. Papyrus Quality Assurance DB Team ISIS Information Systems Alter Wienerweg 12 A-2344 Ma. Enzersdorf, Austria Phone: +43-2236-27551-149 Fax: +43-2236-21081 E-mail: [EMAIL PROTECTED] Hotline: +43-2236-27551-111 Visit the ISIS Website: http://www.isis-papyrus.com --- This e-mail is only intended for the recipient and not legally binding. Unauthorised use, publication, reproduction or disclosure of the content of this e-mail is not permitted. --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daniel Wisser INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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: How to hook up x$dual
Title: Message
Thanks
alot, that worked perfectly!
thank
you
bob
> You'd need to do something
like this under the SYS account:
SQL> create view v_$dual
2 as
3 select dummy
4 from x$dual
5 where inst_id =
userenv('INSTANCE');
View created.
SQL> grant select on v_$dual to
public;
Permission granted.
SQL> create public synonym v$dual for
v_$dual;
Synonym created.
This would leave you with a publicly
available view called V$DUAL...
Hope this helps...
- Original Message -
From: "Bob Metelsky" <[EMAIL PROTECTED]>
To: "Multiple recipients of list ORACLE-L"
<[EMAIL PROTECTED]>
Sent: Thursday, August 01, 2002 4:13
PM
Subject: How to hook up x$dual
Hello AllIm looking to experiment with using x$dual opposed to
dual.from my readinghttp://www.optimaldba.com/internals/oraint_dual.htmlWhich refers to using the memort structure of
X$DUALif I SQL>desc x$dualORA-04043: object x$dual does
not existSo how do I hook up x$dual??Ive searched orafaq,
google, and comp.os.oracle.databases with no availI recall this was a
topic here a while back but nothing on how to createx$dual if it dosnt
exist??its not in this selectselect table_name from dba_tables
where owner = 'SYS';Is this suposed to be an actual created table or a
"memory object" andhow can I create/use in it place of
dual
Re: Free ware databases: which are worth the money?
Hi, I've been hearing some good things about FrontBase: http://www.frontbase.com However, I haven't had time to experiment with it myself. It is runs on Windoze, *nix and Mac OS X. -- Alan Davey [EMAIL PROTECTED] 212-604-0200 x106 On 8/2/2002 8:58 AM, Daniel Wisser <[EMAIL PROTECTED]> wrote: >hi! > >i can strongly recommend PostgreSQL. i have worked with it modelling >data for a java application and perl cgis using it. > >it supports transactions, functions in pure sql, a procedural >language similar to PL/SQL etc. etc. and is very robust. > >the only thing i miss is handling tablespaces as on oracle. > >i have sofar only used it on debian, but it should also be fine >on other linuxes and some elitist bigots work with it on sun. > >there is also good literature and a very good o'reilly book on >it. on the web htpp://www.postgresql.org > >regards > > >Mark Teehan wrote: >> >> Hi, >> we are investigating some freeware databases for deployment on >systems that >> dont justify the cost of an oracle license, on linux. What databases >out >> these can cope with a OLTP load, all transaction based, with some >> reporting? Uncomplicated databases, with mid size volumes of transactions >> (say low millions) and some reporting queries? I guess reliability >is the >> primary concern, if something can be built as solidly as an oracle >> instance, with whatever OS protection this would need, then its >a starting >> point for making a non oracle freeware enterprise database. >> Anyone have any suggestions on what I should download first? >> >> Thanks! >> Mark Teehan >> Singapore >> ERG Group -- >> The contents of this email and any attachments are confidential >> and may only be read by the intended recipient. >> - >> >> ERG Group -- >> The contents of this email and any attachments are confidential >> and may only be read by the intended recipient. >> - >> >> -- >> Please see the official ORACLE-L FAQ: http://www.orafaq.com >> -- >> Author: Mark Teehan >> INET: [EMAIL PROTECTED] >> >> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >> San Diego, California-- Public Internet access / Mailing >Lists >> >> 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 Wisser, Mag. >Papyrus Quality Assurance >DB Team > >ISIS Information Systems >Alter Wienerweg 12 >A-2344 Ma. Enzersdorf, Austria > >Phone: +43-2236-27551-149 >Fax: +43-2236-21081 >E-mail: [EMAIL PROTECTED] > >Hotline: +43-2236-27551-111 > >Visit the ISIS Website: http://www.isis-papyrus.com > >--- >This e-mail is only intended for the recipient and not legally >binding. Unauthorised use, publication, reproduction or >disclosure of the content of this e-mail is not permitted. >--- >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Daniel Wisser > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing >Lists > >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.com -- Author: Alan Davey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Free ware databases: which are worth the money?
Yahoo runs on MySQL using a mix of MyISAM and InnoDB table types along with heavy use of replication to multiple slaves. The MySQL InnoDB table type supports transations and versioning, (Oracle-style consistent non-locking reads). See http://www.mysql.com/doc/I/n/InnoDB_overview.html And http://jeremy.zawodny.com/mysql/managing-mysql-replication.html (there are more presentations in that directory) PostgreSQL is also worth trying, especially if you need stored procedures (MySQL doesn't have them yet). Tim. On Fri, Aug 02, 2002 at 02:33:29AM -0800, Mark Teehan wrote: > Hi, > we are investigating some freeware databases for deployment on systems that > dont justify the cost of an oracle license, on linux. What databases out > these can cope with a OLTP load, all transaction based, with some > reporting? Uncomplicated databases, with mid size volumes of transactions > (say low millions) and some reporting queries? I guess reliability is the > primary concern, if something can be built as solidly as an oracle > instance, with whatever OS protection this would need, then its a starting > point for making a non oracle freeware enterprise database. > Anyone have any suggestions on what I should download first? > > Thanks! > Mark Teehan > Singapore > ERG Group -- > The contents of this email and any attachments are confidential > and may only be read by the intended recipient. > - > > ERG Group -- > The contents of this email and any attachments are confidential > and may only be read by the intended recipient. > - > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mark Teehan > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Tim Bunce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Free ware databases: which are worth the money?
hi! i can strongly recommend PostgreSQL. i have worked with it modelling data for a java application and perl cgis using it. it supports transactions, functions in pure sql, a procedural language similar to PL/SQL etc. etc. and is very robust. the only thing i miss is handling tablespaces as on oracle. i have sofar only used it on debian, but it should also be fine on other linuxes and some elitist bigots work with it on sun. there is also good literature and a very good o'reilly book on it. on the web htpp://www.postgresql.org regards Mark Teehan wrote: > > Hi, > we are investigating some freeware databases for deployment on systems that > dont justify the cost of an oracle license, on linux. What databases out > these can cope with a OLTP load, all transaction based, with some > reporting? Uncomplicated databases, with mid size volumes of transactions > (say low millions) and some reporting queries? I guess reliability is the > primary concern, if something can be built as solidly as an oracle > instance, with whatever OS protection this would need, then its a starting > point for making a non oracle freeware enterprise database. > Anyone have any suggestions on what I should download first? > > Thanks! > Mark Teehan > Singapore > ERG Group -- > The contents of this email and any attachments are confidential > and may only be read by the intended recipient. > - > > ERG Group -- > The contents of this email and any attachments are confidential > and may only be read by the intended recipient. > - > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mark Teehan > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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 Wisser, Mag. Papyrus Quality Assurance DB Team ISIS Information Systems Alter Wienerweg 12 A-2344 Ma. Enzersdorf, Austria Phone: +43-2236-27551-149 Fax: +43-2236-21081 E-mail: [EMAIL PROTECTED] Hotline: +43-2236-27551-111 Visit the ISIS Website: http://www.isis-papyrus.com --- This e-mail is only intended for the recipient and not legally binding. Unauthorised use, publication, reproduction or disclosure of the content of this e-mail is not permitted. --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daniel Wisser INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Subject: List archives on line?
Hi, there is a Geman server offering a list archive http://www.doag.org/orafaq/afl-oral.htm they have a lot more links on http://www.doag.org/orafaq/faq2.htm Regards, Antje Sackwitz -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sackwitz, Antje INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Free ware databases: which are worth the money?
We're using PostgreSQL. Great DB RDBMS with very good performance. Others I know are SAP DB Interbase Look at http://freshmeat.net/ and try to search for RDBMS. Best regards Jan Pruner On Friday 02 August 2002 12:33, you wrote: > Hi, > we are investigating some freeware databases for deployment on systems that > dont justify the cost of an oracle license, on linux. What databases out > these can cope with a OLTP load, all transaction based, with some > reporting? Uncomplicated databases, with mid size volumes of transactions > (say low millions) and some reporting queries? I guess reliability is the > primary concern, if something can be built as solidly as an oracle > instance, with whatever OS protection this would need, then its a starting > point for making a non oracle freeware enterprise database. > Anyone have any suggestions on what I should download first? > > Thanks! > Mark Teehan > Singapore > ERG Group -- > The contents of this email and any attachments are confidential > and may only be read by the intended recipient. > - > > ERG Group -- > The contents of this email and any attachments are confidential > and may only be read by the intended recipient. > - -- Pruner Jan [EMAIL PROTECTED] http://jan.pruner.cz/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Free ware databases: which are worth the money?
Hi, we are investigating some freeware databases for deployment on systems that dont justify the cost of an oracle license, on linux. What databases out these can cope with a OLTP load, all transaction based, with some reporting? Uncomplicated databases, with mid size volumes of transactions (say low millions) and some reporting queries? I guess reliability is the primary concern, if something can be built as solidly as an oracle instance, with whatever OS protection this would need, then its a starting point for making a non oracle freeware enterprise database. Anyone have any suggestions on what I should download first? Thanks! Mark Teehan Singapore ERG Group -- The contents of this email and any attachments are confidential and may only be read by the intended recipient. - ERG Group -- The contents of this email and any attachments are confidential and may only be read by the intended recipient. - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Teehan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: MS win2k SP3 available
Use OEM Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, August 01, 2002 3:08 AM >-Isn't that an admin's dream? Having all desktops and servers administer themselves? My dumn ass NT admins don't need this, they are worthless all by themselves. I have been asking for two weeks now to get a job scheduler software loaded to replace the crappy 'AT' program for my backup and maintenance jobs and it still is not done. -Original Message- Sent: Wednesday, July 31, 2002 4:29 PM To: Multiple recipients of list ORACLE-L And if it isn't broken yet, SP3 can automatically download patches and upgrades for you, so it can break even more on it's own now. Isn't that an admin's dream? Having all desktops and servers administer themselves? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -Original Message- > From: Kevin Lange [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 31, 2002 3:35 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: MS win2k SP3 available > > > Thanks. My win2k server has been having a problem lately. > I wonder if any > of their fixes might patch a hole that I think someone came > thru. I believe > the server is currently compromised . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Microsoft Txn Server / Locking issues
Check out if the program do updates and commit all in one enter. If the program updates some central table and then ask the user to commit or rollback and he is out for a smoke then the rows will stay locked until he returns. Here we stress the importance of doing update+commit at once without user input between them. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, August 01, 2002 12:41 AM > Anybody have any experience with Microsoft Txn Server? I am running into > issues with a few Windows2000 servers running Microsoft Txn Servers that are > connecting to my 8.1.7.4 HP-UX database. There are several concurrent txns > running that do a lot of inserting and data loading. Most of the time it > runs okay, but 3 or 4 times a day, I get several txns stuck waiting on > enqueues. I can easily see what session is holding up all the others, and > it always is an apparent idle session (wait event = SQL*Net waiting from > client"), that is coming from one of these windows2000 servers. Once I kill > that session, all the other enqueues go away. I have taken systemstate > dumps and have been working with Oracle Support, but they are starting to > say that it is an App issue - and it may be, but I just can't see how an > idle session can be causing 30+ sessions to wait for it. And most times, > the last statement run in this idle session is a SELECT. > > I have also increased my initrans for the tables and indexes and made sure > the FKs are indexed. > > Any ideas? > > TIA > > > > > John Fedock > "K" Line America, Inc. > www.kline.com > * [EMAIL PROTECTED] > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Fedock, John (KAM.RHQ) > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: FORMS - text_io - dynamic formating
Csv is a text file. The attributes that you ask for are implemented in the tool that reads and display the data. You can research this tool and add the necessary tags/format chars so the tool will display the results as you want them. I once used this method to format a report from a clipper (once upon a time) application that inserted control characters into the output stream. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, August 01, 2002 7:38 PM > Hi > I have used Text_io to export a datablock to csv, is > there a way i can automatically set the text once in > csv to Bold, or even change the colour? > > __ > Do You Yahoo!? > Yahoo! Health - Feel better, live better > http://health.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Imran Ashraf > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: User with less privileges...
No, Use a role. Grant the privileges to the role and grant the role to the app users. This way you only grant the bulk once and one grant per user. Jack Iulian.ILIES@oran ge.roTo: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) [EMAIL PROTECTED] Subject: RE: User with less privileges... 02-08-2002 09:53 Please respond to ORACLE-L Thanks guys. OK, I can control the access to public synonyms but, I also don't want them to be seen by that new user (the intruder). So, I guess in order to avoid public synonyms, I still have to create all the synonyms for every aplication's users. It seems that I'm a lazy person. Regards iulian ilies -Original Message- Sent: Friday, August 02, 2002 9:08 AM To: Multiple recipients of list ORACLE-L ** This email has been tested for viruses by F-Secure Antivirus administered by IT Network Department. ** I agree on the use of roles - it is the best way to go. However, beware that object privileges granted via a role are NOT in effect inside a definer's rights procedure/package (the default type). This *may* require some investigation and, perhaps, some changes to the application, the privileges of the package owner, the owner of the package, or the package authid, or ... I disagree about granting CONNECT to everyone - grant "create session" instead. CONNECT is actually a pre-defined role with a number of system privileges that most application users do NOT need (alter session, create table, create cluster, create database link, etc.) in addition to the "create session" system privilege. Likewise, I would grant explicit tablespace quotas. Granting RESOURCE is again overkill. Most application users don't need tablespace quotas and even if they do it is usually something trivial (e.g. 1-10 MB) in USERS. The system privilege "unlimited tablespace" (included in the RESOURCE role) is especially dangerous as it includes the SYSTEM tablespace. The "easy way" out is to just grant *everything* to PUBLIC, but it is a very poor choice from any rational security perspective - as you are now discovering. (Oracle preaches this, but doesn't actually practice it themselves!) You will need to do as Bill suggested: 1) Create a set of application-specific functional roles (e.g. CUST_SVC_REP, CUST_SVC_SUPR, CUST_SVC_ADMIN, ...). 2) Grant privileges to roles as appropriate 3) Grant roles to users as appropriate 4) Revoke all (most?) of the application object privileges (and perhaps some others) from PUBLIC The public synonyms are another issue. The don't carry any intrinsic privilege - SELECT, INSERT, etc. still have to be granted to the user or to a role granted to the user. However, public synonyms can be a performance issue and *may* be undesirable for other reasons. Don Granaman [OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, August 01, 2002 11:28 AM try this: rather than granting specific privs to PUBLIC, create specific roles for the different types of users you have, and grant appropriate object privs to each role (granting connect also helps :-). then for each user you add, just give that user whatever role is relevent and you're set . . . they will still be able to access public synonyms. only issue with this is that you'll still need to specify TS quotas to the specific users, as they don't inherit these from th
Re: 20 Instances 1 Machine
You also have to consider the OS overhead. Putting 20 instances means hundreds of processes. Just managing all this at the system level can be resource consuming. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Friday, August 02, 2002 5:43 AM > I have not heard about such limitation for shared memory size on Solaris. > > Even if such limitation exists it will be on the process level. > > This means 2GB or 4GB for each database instance. > > Regards, > > Waleed > > -Original Message- > To: Multiple recipients of list ORACLE-L > Sent: 8/1/02 9:23 PM > > Your biggest problem is not going to be physical RAM or disk space > (either of > those could simply be purchased large enough). However, you *will* > encounter a > problem with "Shared Memory". > > 32-bit (and even 64-bit) operating systems have a finite amount of > "shared > memory" addressable for use by 32-bit applications (namely the RDBMS > shipped > with the Oracle Applications). This number is 1.7GBytes on HP/UX and, I > think, > 2GBytes on Solaris. This "Shared Memory" limitation is systemwide. The > Oracle > RDBMS uses shared memory heavily for major components of the SGA. As a > result, > if you're running a 32-bit version of Oracle, this number represents the > sum of > all SGA's running on that machine at the time. (So, at 500M/instance, > you'll > run out somewhere between 3 and 4 instances). > > Possible solutions would be: > 1) Use a 64-bit version of the Oracle RDBMS as certified for your > platform. > A 64-bit version of Oracle would address shared memory from a much > larger > total pool (most likely an absurdly large number), thus avoiding > this 32-bit > "Shared Memory" problem. > 2) Consider using something like Sun's "System Domains" to partition a > big box > into multiple "virtual machines". Each of these Domains would have > it's own > shared memory pool. > 3) Consider using seperate machines. > > Personally, I'd vote for seperate machines. I tend to prefer only one > production system exist on any given host as it tends to eliminate much > of the > performance-oriented fingerpointing that is bound to come up. > Additionally, > running a large number of production instances on a single host can be > alot like > putting all of your eggs into one basket. It may be cheaper, but if > something > happens to that basket, everything's hosed. > > As far as hardware: > Lots of disk, plenty of I/O channels, and plenty of CPUs. > Without actually > knowing the nature of your applications, I'd say you're probably looking > in the > SunFire 6800 or SunFire 15k range (if you're looking at Sun equipment). > > Post, Ethan wrote: > > I got a request to spec out a machine that could handle 20 separate > Oracle > > instances on a single UNIX server. SGA should total about 500 MB per > > instance. We have some hosts here with 6-8 instances but never tried > 20 > > before. Wondering what types of things I should be worried about, > obviously > > having enough memory but are there any other limitations I can expect? > > Anyone had to do this? > > > > Thanks, > > Ethan > > > -- James > > > James J. Morrow E-Mail: > [EMAIL PROTECTED] > Senior Principal Consultant > Tenure Systems, Inc. > McKinney, TX, USA > > "The reasonable man adapts himself to the world: the unreasonable man >persists in trying to adapt the world to himself. Therefore all > progress > depends on the unreasonable man." -- George Bernard Shaw > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: James J. Morrow > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com > -- > Author: Khedr, Waleed > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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
RE: Performance Problem after Migration
Scott, I don't understand " I have tried to capture a session, but I need to get a repository up to look at the trace that was generated. " No mention of Oracle versions or even O/S levels but I am sure you have Statspack available which should give you a good start. So have an overall view of the system then focus on a specific user, trace a session and check what events are being waited on. Has the EMC array been configured properly by experienced SAs or was this a first attempt by someone? John -Original Message- Sent: 01 August 2002 22:28 To: Multiple recipients of list ORACLE-L I have an interesting problem. I recently migrated a database from a Digital Unix system to a Sun Solaris system, with an EMC disk array. Since I was going to be migrating the database, I decided to double the block size from 4k to 8k. I also created the tablespaces on the new box as locally managed, with fixed extent sizes. Then I did a full database export, ftp'd the file, and imported it. It went well, or so I thought. The application works, but it is much slower than it was on the original (Digital) system. One side effect was that I didn't change the db_block_buffers, so that part of the SGA essentially doubled in size. The library cache hit rate was always around 99%, but the data cache hit rate used to only be about 85%, now it is 95 - 99%. All of the sorts are being done in memory, with memory to spare (52G yesterday, not used). According to the statistics, the database should be screaming. But the users are complaining that the online screens are taking much longer to come up. They say that the screens used to come up in 1 - 2 seconds, now it's taking about 10. Just for fun, I tried deleting the statistics and changing the optimizer_mode from choose to rule. That made things worse, which was what I expected, but it was worth a try. I have tried to capture a session, but I need to get a repository up to look at the trace that was generated. Until then, I'm pretty baffled. I'd appreciate any ideas that anyone has on this. Thank you. -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Replication
Oracle has "basic" replication and "advanced" replication. The basic allows read-only copies of data whilst advanced can give multiple updaters at different locations and can get as complicated as you like. IMHO, the key to a good replication environment is in the planning. Determining up front whether conflicts will occur (when the data is resync'd back in to the central store) and possibly architecting parts of the database to avoid some/all conflicts is key. If you're new to replication, using the gui replication manager is a good way to get up and running relatively quickly, but I'd advise having a good study of the replication manuals to see all the possibile issues that need to be considered. Oracle were touting an architecture called "Oracle-to-go" or "Web-to-go" some time ago which (claimed) to simplify all of this - but I've heard nothing recently. hth connor --- paquette stephane <[EMAIL PROTECTED]> wrote: > Hi, > > I've never had experiences in replication > environments. > > We will develop a new system that has a central > database (817/win2000). > From times to times, some users will worked with a > deployable version of the application in a region > without network connection. > When the users are back, they're should be able to > synchronize with the centralized database. The data > goes from the deployable version to the centralized > database only. > > What strategies can be considered ? > > > > = > Stéphane Paquette > DBA Oracle, consultant entrepôt de données > Oracle DBA, datawarehouse consultant > [EMAIL PROTECTED] > > ___ > Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et > en français ! > Yahoo! Mail : http://fr.mail.yahoo.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: =?iso-8859-1?q?paquette=20stephane?= > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > 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). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "Remember amateurs built the ark - Professionals built the Titanic" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Replication
Use the KISS principle. Define asynchronous replications on their machines and when they come back and connect to the network the updates will be applied. TEST TEST TEST Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Friday, August 02, 2002 2:33 AM > Hi, > > I've never had experiences in replication > environments. > > We will develop a new system that has a central > database (817/win2000). > From times to times, some users will worked with a > deployable version of the application in a region > without network connection. > When the users are back, they're should be able to > synchronize with the centralized database. The data > goes from the deployable version to the centralized > database only. > > What strategies can be considered ? > > > > = > Stéphane Paquette > DBA Oracle, consultant entrepôt de données > Oracle DBA, datawarehouse consultant > [EMAIL PROTECTED] > > ___ > Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! > Yahoo! Mail : http://fr.mail.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: =?iso-8859-1?q?paquette=20stephane?= > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
