Re: Tuning views
Hi Don't just tune the views but see how they are used by looking in the sql-area views or tracing a session that uses it in the way it's normally used. than tune what you find (if not app created sql this shoud be possible) Jack "Jesse, Rich" RLD.COM> cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: Tuning views [EMAIL PROTECTED] 28-06-2002 21:56 Please respond to ORACLE-L Hey all, We have a multitable view setup on our 8.1.7.2.0 HP/UX 11.0 DB for security, so our users can use MS Ack-sess to query a few columns from some sensitive tables. In other words, the view doesn't filter rows, just columns. The problem is that the author of the view explicitly set the RULE hint and it seems to be causing a few performance problems when joining the view to other tables. So, I'll "fix" the view and be the hero, right?Well, how do you tune a multitable view when you don't know how it's going to be used? After fixing a little join mishap, I added hints for FIRST_ROWS, as well as FULL for the super small 1-block tables. This seems to me to be valid, since the users of the view will (hopefully) filter the rows based on an index of one or more of the tables of the view, but I don't really have any proof other than a pretty-looking explain plan. Anyone have a philosophy or procedure for tackling something like this? Preferrably one that ends in "drink beer"? TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- 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). === De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst & Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and
Re: performance
Ravi, Make sure you have at least 5-10 redo log groups. That's depends on your workload. You also may need to increase their size. Think how much log info your database can generate and size your logs that it would be enough for 10 mins at least. (Of course that would be pretty rough estimation) Also make sure you put redo logs and arcived redo logs on differend disks! So that's for start. After, you may follow advice given in Tim's reply. hth Alexandre - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Saturday, June 29, 2002 9:13 PM > Dear All, > > Can any one please give me some hints or tips when we > move to archive mode? when Our DB is non-archive mode > that was ok,when we moved to Archive, it is dead slow. > > Obviosuly archive mode performance is slow, is there > any other precations to be taken care? > > Thanks for your help. > Cheers, > Ravi > > __ > 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?Nalla=20Ravi?= > 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: Alexandre Gorbatchev 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: exp73 dumpparam for unlimited extents?
Don Granaman wrote: > > With compress=N, you will get essentially the same mish-mash of extents you > had previously - Hmmm, that's hair-splitting, but if you reimport into a tablespace from which all objects have been dropped and that you have coalesced, you will have the same number of extents but they will all be created one after the other - as many 'logical' extents as before, but as far as the 'macroscopic' (i.e. let's forget about how the OS deals with its blocks and what happens on the disk) physical level is concerned there will hardly be any difference with compress=Y immediately after creation. That said, nobody cares much about external fragmentation anyway ... -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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 Performance Tuning steps
Thnx Mike , U saved at least 50-60 bucks of mine. Nyways can anyone tell me few links where I can find good documentation on Oracle Performance Tuning ? (Or books if they are worth byuing .) Thnx in advance -Chetan "Johnson, Michael " <[EMAIL PROTECTED]>wrote: I have seen no other books that deal with Oracle waits the way Gaja and Kirti's book does. After all, the waits are what you are trying to diagnose in a slow system. There are several web sites floating around that have some good technical papers on diagnosing slow systems. IMHO, I find that Oracle Books are like Stock Trading books. There are only a few good ones floating around, but alot of them offer advice that is down right dangerous, so choose wisely. FWIW. Mike -Original Message-From: Chetan [mailto:[EMAIL PROTECTED]]Sent: Friday, June 28, 2002 4:13 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Oracle Performance Tuning steps Thanks , I looked into the database. There r some waits happening on the undo blocks (non-system) but could not figure out whether this could possibly cause such a slowdown of the system. Also there were some indexes newly created on some of the tables which are causing problems. What's the best approch anyways to hunt down the problem in a situation like this ? - Chetan BigP <[EMAIL PROTECTED]>wrote: cheten , find processid of the application , look into database waits , that will give u some hint .Also look into db buffers to find if there are full table scans flushing db buffer . btw Did u ran statistics ? -Bigp - Original Message - From: Chetan To: Multiple recipients of list ORACLE-L Sent: Wednesday, June 26, 2002 3:38 AM Subject: Oracle Performance Tuning steps Hi guys , Need some help. Actually we are looking here at a Oracle 8.1.7 db on HP-UNIX. The application was running fine uptil yesterday. Suddenly a part of the appln is running extremely slow. I can not figure what might be the problem. Wanted to track this down asap. Here is some information about the db. Database size - 20GB Optimizer - CHOOSE Disk Structure - RAID 1+0 No. of processors - 4 Block Size - 8K Archivelog mode : ARCHIVELOG Please tell me what should be the ideal way I should try to trace the problem. I thought of running UTLBSTAT/UTLESTAT or STATSPACK and asked the user to run that part of the appln. Has anybody worked with STATSPACK before ? Can anybody tell me what should accurate and fastest way to hunt down the problem ? I think its something to do with indexes or changes in the queries. Also can someone tell me the ideal backup strategy for this database considering the fact that it's a 24x7 system. Thanks in advance . Chetan Chindarkar Do You Yahoo!?Sign-up for Video Highlights of 2002 FIFA World Cup Do You Yahoo!?Sign-up for Video Highlights of 2002 FIFA World CupDo You Yahoo!? Sign-up for Video Highlights of 2002 FIFA World Cup
RE: RE: exp73 dumpparam for unlimited extents?
And how will it be of help in this export/import issue ? Sorry, I did not follow what you mentioned. - Kirti -Original Message- Sent: Sunday, June 30, 2002 10:48 PM To: Multiple recipients of list ORACLE-L Deshpande, Kirti£¬ hi, check oracle undocumented parameter: _system_trigger_enabled=false. If this is set, then all database event trigger will be disabled. Good luck Good luck! chaos [EMAIL PROTECTED] zhu chao DBA of Eachnet.com 86-021-32174588-667 ÔÚ 2002-06-30 11:58:00 You wrote: >No, you do not have to wait for 8i or 9i >You are almost there to get what you want. >What you need to do prior to import is build all the tables without any >storage cluase in the CREATE TABLLE|INDEX syntax. It will default to the >tablespace settings. And them import with IGNORE=Y option (since tables are >already there). By default, Oracle will use the storage clause from the >import file. You can not tell Oracle to not have it created while exporting. >Pre-building the tables is the only choice. > >In your quick test, you did not specify the storage clause, so it worked! > >You can use the indexfile= option of the import utility, to build >a script to create tables, indexes. Edit the script for storage clauses >(i.e. remove them), and build the tables first. > > >HTH, > >- Kirti > >-Original Message- >Sent: Saturday, June 29, 2002 11:53 PM >To: Multiple recipients of list ORACLE-L > > >Hello, > >Running Oracle 7.3.4.4 on Win2k. >Trying to implement unlimited extents of the same size. (Same size works >for us). >Set the tablespace defaults >Dumped the users >Dropped the users >Imported the users > >Tables still had the same mish-mash of extents and max extents 121 > >Here are my dump params >USERID = system/@** >FILE = c:\dumps\test.dmp >LOG = c:\dumps\test.log >FULL = Y >buffer=100 >consistent=y >compress=n > >That did not work so I tried dumping an individual user >USERID = system/*@*** >FILE = c:\dumps\test.dmp >LOG = c:\dumps\test.log >FULL = N >COMPRESS = N >owner=restek > >Still get mish-mash extents on import. > >The load was always: >USERID = system/**@* >FILE = c:\dumps\test.dmp >LOG = c:\dumps\test.dmprs.implog >FROMUSER = restek >TOUSER = restek > >My quick test of create table tmp_xyz as select * from xyz gives me the >result I want. > >Any suggestions? Do I have to wait until I upgrade to 8i or 9i? > >TIA > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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: exp73 dumpparam for unlimited extents?
For the reported problem, (1) is the only option as (2) is not possible with 7.3.x database. - Kirti -Original Message- Sent: Sunday, June 30, 2002 9:28 PM To: Multiple recipients of list ORACLE-L With compress=N, you will get essentially the same mish-mash of extents you had previously - unless you are importing into a LMT. You have basically two options: 1) Pre-create the objects with a storage clause specifying the extent sizes you want - with initial and next the same size. Then import with ignore=Y. Of course, if you drop the users, you will have to recreate them before pre-creating the objects. This is the only option for dictionary-managed tablespaces to get uniform extents. (Hint: imp ... indexfile=somefilename.sql ..., edit somefilename.sql to (1) uncomment the create table statements and (2) modify storage clauses, then run somefilename.sql. If the export is large, you may wish to split this into two parts - one for the tables and one for the indexes and constraints. (It is a little more complicated than it might seem at first, but isn't too bad. One possible approach is to perform one export with rows=Y indexes=N constraints=N and another with rows=N indexes=Y constraints=Y. Details left as an exercise for the reader ;-) 2) Convert the tablespace(s) to LMT(s) with uniform extents - or drop and recreate them as such - prior to the import. In the vast majority of cases, (2) is preferred. Don Granaman [certifiable OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Saturday, June 29, 2002 11:53 PM Hello, Running Oracle 7.3.4.4 on Win2k. Trying to implement unlimited extents of the same size. (Same size works for us). Set the tablespace defaults Dumped the users Dropped the users Imported the users Tables still had the same mish-mash of extents and max extents 121 Here are my dump params USERID = system/@** FILE = c:\dumps\test.dmp LOG = c:\dumps\test.log FULL = Y buffer=100 consistent=y compress=n That did not work so I tried dumping an individual user USERID = system/*@*** FILE = c:\dumps\test.dmp LOG = c:\dumps\test.log FULL = N COMPRESS = N owner=restek Still get mish-mash extents on import. The load was always: USERID = system/**@* FILE = c:\dumps\test.dmp LOG = c:\dumps\test.dmprs.implog FROMUSER = restek TOUSER = restek My quick test of create table tmp_xyz as select * from xyz gives me the result I want. Any suggestions? Do I have to wait until I upgrade to 8i or 9i? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Monical 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: Don Granaman 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: Deshpande, Kirti 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: RE: exp73 dumpparam for unlimited extents?
Deshpande, Kirti£¬ hi, check oracle undocumented parameter: _system_trigger_enabled=false. If this is set, then all database event trigger will be disabled. Good luck Good luck! chaos [EMAIL PROTECTED] zhu chao DBA of Eachnet.com 86-021-32174588-667 ÔÚ 2002-06-30 11:58:00 You wrote: >No, you do not have to wait for 8i or 9i >You are almost there to get what you want. >What you need to do prior to import is build all the tables without any >storage cluase in the CREATE TABLLE|INDEX syntax. It will default to the >tablespace settings. And them import with IGNORE=Y option (since tables are >already there). By default, Oracle will use the storage clause from the >import file. You can not tell Oracle to not have it created while exporting. >Pre-building the tables is the only choice. > >In your quick test, you did not specify the storage clause, so it worked! > >You can use the indexfile= option of the import utility, to build >a script to create tables, indexes. Edit the script for storage clauses >(i.e. remove them), and build the tables first. > > >HTH, > >- Kirti > >-Original Message- >Sent: Saturday, June 29, 2002 11:53 PM >To: Multiple recipients of list ORACLE-L > > >Hello, > >Running Oracle 7.3.4.4 on Win2k. >Trying to implement unlimited extents of the same size. (Same size works >for us). >Set the tablespace defaults >Dumped the users >Dropped the users >Imported the users > >Tables still had the same mish-mash of extents and max extents 121 > >Here are my dump params >USERID = system/@** >FILE = c:\dumps\test.dmp >LOG = c:\dumps\test.log >FULL = Y >buffer=100 >consistent=y >compress=n > >That did not work so I tried dumping an individual user >USERID = system/*@*** >FILE = c:\dumps\test.dmp >LOG = c:\dumps\test.log >FULL = N >COMPRESS = N >owner=restek > >Still get mish-mash extents on import. > >The load was always: >USERID = system/**@* >FILE = c:\dumps\test.dmp >LOG = c:\dumps\test.dmprs.implog >FROMUSER = restek >TOUSER = restek > >My quick test of create table tmp_xyz as select * from xyz gives me the >result I want. > >Any suggestions? Do I have to wait until I upgrade to 8i or 9i? > >TIA > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Robert Monical > INET: [EMAIL PROTECTED] >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Deshpande, Kirti > 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: chaos 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: exp73 dumpparam for unlimited extents?
With compress=N, you will get essentially the same mish-mash of extents you had previously - unless you are importing into a LMT. You have basically two options: 1) Pre-create the objects with a storage clause specifying the extent sizes you want - with initial and next the same size. Then import with ignore=Y. Of course, if you drop the users, you will have to recreate them before pre-creating the objects. This is the only option for dictionary-managed tablespaces to get uniform extents. (Hint: imp ... indexfile=somefilename.sql ..., edit somefilename.sql to (1) uncomment the create table statements and (2) modify storage clauses, then run somefilename.sql. If the export is large, you may wish to split this into two parts - one for the tables and one for the indexes and constraints. (It is a little more complicated than it might seem at first, but isn't too bad. One possible approach is to perform one export with rows=Y indexes=N constraints=N and another with rows=N indexes=Y constraints=Y. Details left as an exercise for the reader ;-) 2) Convert the tablespace(s) to LMT(s) with uniform extents - or drop and recreate them as such - prior to the import. In the vast majority of cases, (2) is preferred. Don Granaman [certifiable OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Saturday, June 29, 2002 11:53 PM Hello, Running Oracle 7.3.4.4 on Win2k. Trying to implement unlimited extents of the same size. (Same size works for us). Set the tablespace defaults Dumped the users Dropped the users Imported the users Tables still had the same mish-mash of extents and max extents 121 Here are my dump params USERID = system/@** FILE = c:\dumps\test.dmp LOG = c:\dumps\test.log FULL = Y buffer=100 consistent=y compress=n That did not work so I tried dumping an individual user USERID = system/*@*** FILE = c:\dumps\test.dmp LOG = c:\dumps\test.log FULL = N COMPRESS = N owner=restek Still get mish-mash extents on import. The load was always: USERID = system/**@* FILE = c:\dumps\test.dmp LOG = c:\dumps\test.dmprs.implog FROMUSER = restek TOUSER = restek My quick test of create table tmp_xyz as select * from xyz gives me the result I want. Any suggestions? Do I have to wait until I upgrade to 8i or 9i? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Monical 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: Don Granaman 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: Rollback OPTIMAL setting
As far as I know, the jury is still out - I haven't had a chance yet to see if (a) the problems Dan found in 9.0.1.1 are fixed and (2) I like the way it works. Also, it does require 9i and I'm not yet ready to go there with everything. Even with 9i and system managed undo, rule #4 will still be in effect! Don Granaman [certifiable OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Saturday, June 29, 2002 9:38 PM Don, 9i has system managed undo -- you don't think it works yet? Rachel --- Don Granaman <[EMAIL PROTECTED]> wrote: > I prefer to have OPTIMAL set and deal with "long running large > transactions" > another way - setting "OPTIMAL" on the developers! Granted, this > doesn't > work for 3rd party products, but I usually deal with in-house > applications. > Getting this to work requires: (1) having enough rollback segments, > (2) > large enough rollback segments that extends almost never occur, and > (3) NOT > having the "one giant rollback segment for large jobs", and, most > importantly, (4) all "batch-lookin' thingies" have to be reviewed by > the DBA > and optimized, by either the DBA or the developer - or both, until > they pass > muster. Using this, I rarely seen an ORA-01555 or a rollback shrink > (over > six months on the systems I'm working with now) - and when I do, I > know that > it (usually) means that somebody broke rule #(4). When that happens, > I > track it down and work with the developer to fix it. My experience > is that > the vast majority of developers are receptive - they actually like to > have > their code run without problems. > > Of course, this assumes that the "wasted" disk space for (1) and (2) > is not > a significant issue. It rarely is, but I work almost exclusively > with > (essentially) OLTP systems where space is typically less critical > than I/O > throughput capability and reliability. Usually, we have to add disks > for > performance rather than space. The database datafile drives are > typically > 36 GB (less often 18 GB) and are rarely "full", so a GB or two more > for > rollback tablespace is OK. If I had to operate under the space > constraints > that many seem to have, I might not set OPTIMAL either. > > I am looking forward to the day that this "no OPTIMAL" suggestion > fades into > the "myths and folklore" category. Either because of basic policy > changes > (e.g. the extents myth), a better Oracle algorithm (e.g. 10i system > managed > undo???), more intelligently designed batch processes in > applications, or > the trend towards ever-increasing drive size. > > Note: All this doesn't mean that I don't understand why so many use > the > "manual shrink" method. My philosophy differs in that not setting > OPTIMAL > should be a last resort, not a blanket policy. > > Don Granaman > [OraSaurus] > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Thursday, June 27, 2002 10:13 AM > > > One of the constant comments regarding rollback segments is not to > set > optimal. I am wondering why this setting is often discouraged. I have > my own > ideas, but I want to gather more opinions and experiences. > > Daniel W. Fink > Sr. Oracle DBA > MICROMEDEX > 303.486.6456 > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Don Granaman > 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! - Official partner of 2002 FIFA World Cup http://fifaworldcup.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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Publ
Re: rbs oracle data block corrupted
Hi, Normally, you should not have seen an rbs corruption message in startup since Oracle7.3+ doesn't rollback in startup. It's postponed. But, there are some cases that Oracle touches rbs in startup: - Active transactions in the SYSTEM rbs are immediately rolled back. They are not postponed. - Rbs headers are always touched. In other words, your SYSTEM rbs, or an rbs header is corrupted. Identify which object corrupted. Let's know which object is corrupted. If you can recover, do it. If not, As Tim Gorman said in his excellent answer, dump rbs. Then email it to the list and let's interpret it. regards Atul Kumar Srivastav wrote: version : 8.1.6 -Original Message- From: Danisment Gazi Unal (ubTools) [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 30, 2002 12:13 AM To: Multiple recipients of list ORACLE-L Subject: Re: rbs oracle data block corrupted Hi, which version of Oracle are you using ? what are the all error messages ? regards... Atul Kumar Srivastav wrote: Hi All ! We have one problem. We can mount the database but not able to open it. It gives following error while opening: One Oracle Data Block Corrupted. RBS01.dbf (datafile for rollback segment) How can i repair this corruption? Atul -- Danisment Gazi Unal http://www.ubTools.com -- Danisment Gazi Unal http://www.ubTools.com
RE: exp73 dumpparam for unlimited extents?
No, you do not have to wait for 8i or 9i You are almost there to get what you want. What you need to do prior to import is build all the tables without any storage cluase in the CREATE TABLLE|INDEX syntax. It will default to the tablespace settings. And them import with IGNORE=Y option (since tables are already there). By default, Oracle will use the storage clause from the import file. You can not tell Oracle to not have it created while exporting. Pre-building the tables is the only choice. In your quick test, you did not specify the storage clause, so it worked! You can use the indexfile= option of the import utility, to build a script to create tables, indexes. Edit the script for storage clauses (i.e. remove them), and build the tables first. HTH, - Kirti -Original Message- Sent: Saturday, June 29, 2002 11:53 PM To: Multiple recipients of list ORACLE-L Hello, Running Oracle 7.3.4.4 on Win2k. Trying to implement unlimited extents of the same size. (Same size works for us). Set the tablespace defaults Dumped the users Dropped the users Imported the users Tables still had the same mish-mash of extents and max extents 121 Here are my dump params USERID = system/@** FILE = c:\dumps\test.dmp LOG = c:\dumps\test.log FULL = Y buffer=100 consistent=y compress=n That did not work so I tried dumping an individual user USERID = system/*@*** FILE = c:\dumps\test.dmp LOG = c:\dumps\test.log FULL = N COMPRESS = N owner=restek Still get mish-mash extents on import. The load was always: USERID = system/**@* FILE = c:\dumps\test.dmp LOG = c:\dumps\test.dmprs.implog FROMUSER = restek TOUSER = restek My quick test of create table tmp_xyz as select * from xyz gives me the result I want. Any suggestions? Do I have to wait until I upgrade to 8i or 9i? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Monical INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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).
note 200873.1
Oracle Security Alert #36 Dated: 20 June 2002 Security Vulnerability in Apache HTTP Server Affects Oracle9iAS & Oracle Http Server (OHS) Description A potential security vulnerability exists in Apache HTTP Servers up to and including version 1.3.24. A knowledgeable and malicious user can exploit this vulnerability by remotely sending a carefully crafted invalid request to the Apache HTTP server using chunked encoding. Doing so may lead to successful Denial of Service (DoS) attacks on 32-bit Unix operating systems and running of arbitrary code on Windows and 64-bit Unix operating systems. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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).
ORA-27101 Error
ORA-27101 = Shared Memory Realm is not available I have seen references to this error and how to repair it on UNIX systems, but what is to be done on Win2000 when this thing rears its ugly head? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Schruefer 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: rbs oracle data block corrupted
version : 8.1.6 -Original Message-From: Danisment Gazi Unal (ubTools) [mailto:[EMAIL PROTECTED]]Sent: Sunday, June 30, 2002 12:13 AMTo: Multiple recipients of list ORACLE-LSubject: Re: rbs oracle data block corruptedHi, which version of Oracle are you using ? what are the all error messages ? regards... Atul Kumar Srivastav wrote: Hi All ! We have one problem. We can mount the database but not able to open it. It gives following error while opening: One Oracle Data Block Corrupted. RBS01.dbf (datafile for rollback segment) How can i repair this corruption? Atul -- Danisment Gazi Unal http://www.ubTools.com
Re: Re: Re:MTS performance is too bad.
How did you solved it? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Friday, June 28, 2002 4:03 PM > FINALLY , > Everything is good now. > Thank you for your replies. > > Bunyamin > > > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Friday, June 28, 2002 12:33 AM > > > > I suspect that if you are getting 4030s with 50 concurrent users that > > you will get NO benefit from MTS, in fact it will likely cause just the > > problems you are seeing and you will start to get 4030s sooner than you > > would have before. > > > > MTS is not appropriate as a tool to address your 4030 errors if the > > sessions are not inactive for more than a few seconds. If the concurrent > > sessions are very active (check v$session's last_call_et field) and you > > are still running into 4030s than MTS will not help you, and can > > actually cause a performance hit (CPU) that is scary. The key thing to > > remember is that MTS provides SCALABILITY, performance is indirectly > > affected if at all. > > > > If you are running into 4030s there are a number of other approaches you > > can take as well. Application tuning is the best place to start, but > > more often then not, not possible. Then go to the obvious (that others > > have mentioned) like using statspack to get a look at the usage of your > > buffer cache. In your case you may have to reduce the size of your SGA > > to allow for more user space. Don't fall for the buffer cache hit ratio > > needs to be x%. If you are in an application env where most blocks are > > rarely seen in more than one query then you need a different approach to > > buffer cache tuning than hit %. This is a book in and of itself, but > > fairly intuitive. > > > > Given that you are stuck with your current application, the very first > > thing you also will want to look at is the Orastack utility to reduce > > the memory usage of each server process' stack. I have seen DBAs in your > > situation have their 4030s resolved with this alone. > > > > The other is upgrading your OS (or properly setting it) to NT EE or > > Win2k AS. This will allow you to use a 3gb process size. If you haven't > > done this it will surely fix your memory shortage (at least until you > > get another 50 users :)). > > > > You can also scale out by adding more nodes with OPS, although I'd > > strongly suggest that you move to 9i before doing this! Finally, you can > > use OPS/RAC on a single box, a bit of a fancy trick, but it allows you > > to have multiple instances if you have the system memory available. > > > > Ramble, ramble, ramble, for more info you can come to my presenation at > > OpenWorld (or just send more info/questions!) > > > > Regards, > > > > Michael Sale > > Author: Oracle9i for Windows(R) 2000 Tips & Techniques > > http://www.amazon.com/exec/obidos/ASIN/0072194626 > > > > > > -Original Message- > > Karadeniz > > Sent: Thursday, June 27, 2002 8:33 AM > > To: Multiple recipients of list ORACLE-L > > > > > > Michael , > > > > I have tried all of them , but still performance is very bad. When > > switch to dedicated mode I get ora:04030.. Have you ever switched to > > MTS and seen the same performance , I wonder if you are sure about MTS > > performance is good. What ever I did did not give the same performance > > as dedicated connections even not approached. > > > > Bunyamin > > > > - Original Message - > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > Sent: Thursday, June 27, 2002 4:53 PM > > > > > > > You really don't need MTS with no more than 50 concurrent users unless > > > > > you > > are running into ora-4030s or other memory problems. > > > > > > When you say performance is a problem, have you check OS swapping of > > memory to disk? Your SGA might be too big (with AS and the 3GB switch no > > bigger than 3GIG, without the 3GB switch only 2GB) and end up swapping > > out to disk. > > > > > > You also need to make sure that only OLTP users (users with short > > > txns, > > NOT long running batch jobs, big updates, etc) are connecting via MTS. > > All batch/DSS type users should be connecting via dedicated server. You > > can have them specify this in their tnsnames.ora. > > > > > > That said, your MTS config is WAY out of whack given the number of > > concurrent users: > > > > > > You only need ONE dispatcher to start with. Change dispatchers to 1 > > > unless > > you have multiple NICs you are working off of for a particular > > segmentation of users. (50 dispatchers would be appropriate for about > > 12,000 Concurrent > > users) > > > > > > If your total number of concurrent OLTP users is truly 50 set your min > > servers to 60. Max servers is fine. > > > > > > You should also set your large pool instead of a massive shared pool, > > > all > > kinds of reason for doing this!! > > > > > > If you have a chance go to borders or barnes
How to programatically send an email using Lotus Notes from an Oracle Form ?
Hello All: I am using Oracle Forms 6i. I have a Form through which I was sending an email of the data entered in the Form using Microsoft Outlook. I was using OLE to invoke Outlook objects to do this. Now the same is to be done using Lotus Notes. Does anyone know how this can be done ? Please guide me. If possible please send me the code for doing this. Regards, Faiz _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: FAIZ QURESHI 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).
trigger getting disabled.
Title: trigger getting disabled. Is there any condition due to which a database trigger may get disabled on creation (or replace), though the status in dba_objects shows as 'VALID'? In other words, is it possible for a trigger to get disabled, without doing so explicitly? Oracle 8.1.7 rgds amar http://amzone.netfirms.com
Locked rows - finding out
Hello listers By quering V$LOCK or V$LOCKED_OBJECT I may find which tables are locked. How do I see rowids of rows that are locked? And how do I see into what rollback segment is being used by transaction that placed locks on those rows? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac - posao 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).
