RE: Little competition
Good points Jonathan, The 'box' as far as I'm concerned was accomodated by v7.3.4. That had 95% of the features anyone could want for most environments. After that we've had a succession of 'nice to have' features. Don't get me wrong, some environments absolutely demand these new features and there's a living to be made in understanding all of the new bells and whistles but I agree that most people don't use more than a tiny subset of the available toys. Mike Hately PS Yes, I'm aware that there will follow a list of post-7.3.4 features that people consider absolutely vital. =) -Original Message- Sent: 11 December 2003 13:25 To: Multiple recipients of list ORACLE-L Maybe I'm wrong here, but I don't believe Oracle has put together the simplified DBA manual yet, and perhaps maybe they should. What do you think? Should Oracle define the box and write a manual for customers who want to live within that box? Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to inv
Clive, during the upgrade has the global_names parameter somehow been changed from false to true? This would cause the connection to be refused if the link name does not match the global_name for the target database. Cheers, Mike Hately -Original Message- On Behalf Of Hybart, Clive Sent: 10 December 2003 10:39 To: Multiple recipients of list ORACLE-L Since upgrading our mainframe database to 9.2.0.1.0.25 a dblink between a Unix box (8.1.7.0) and the mainframe fails. However sqlplus using the same connection syntax Connect username/[EMAIL PROTECTED] is fine. Any ideas, peeps ? E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: java package to run OS command
One I've used in the past was supplied by Tom Kyte : http://asktom.oracle.com/pls/ask/f?p=4950:8:4723489521562622951::NO::F4950_P 8_DISPLAYID,F4950_P8_CRITERIA:952229840241, Cheers, Mike Hately -Original Message- Sent: 04 December 2003 13:49 To: Multiple recipients of list ORACLE-L I need a java package that will allow me to run OS commands(Unix) from a stored procedure. Anyone got one? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: when do you use v$statname?
Agreed. Tongue firmly in cheek there. -Original Message- Sent: 26 November 2003 19:04 To: Multiple recipients of list ORACLE-L :) Btw, I advise against memorizing statistic numbers, because they change over versions... Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 26, 2003 3:34 PM v$statname is a lookup table for the statistic# that appears in v$sesstat and v$sysstat. You use it in most queries on those tables unless you're named Tanel and have memorised the statistic numbers. =) Cheers, Mike Hately -Original Message- Sent: 26 November 2003 13:24 To: Multiple recipients of list ORACLE-L This view seems to be a smaller subset of v$sysstat? When is it useful? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: when do you use v$statname?
v$statname is a lookup table for the statistic# that appears in v$sesstat and v$sysstat. You use it in most queries on those tables unless you're named Tanel and have memorised the statistic numbers. =) Cheers, Mike Hately -Original Message- Sent: 26 November 2003 13:24 To: Multiple recipients of list ORACLE-L This view seems to be a smaller subset of v$sysstat? When is it useful? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: when do you use v$statname?
Good point. I'd forgotten that. Just a lookup for v$sesstat then. Cheers, Mike -Original Message- Sent: 26 November 2003 13:39 To: Multiple recipients of list ORACLE-L both store that info SQL desc v$statname Name Null?Type - STATISTIC# NUMBER NAME VARCHAR2(64) CLASS NUMBER SQL desc v$sysstat Name Null?Type - STATISTIC# NUMBER NAME VARCHAR2(64) CLASS NUMBER VALUE NUMBER E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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[2]: redhat/oracle
RHAS Developer Edition, £40 a pop for download. Best money I've spent this year. Mike Hately -Original Message- Sent: 04 November 2003 15:45 To: Multiple recipients of list ORACLE-L Tuesday, November 4, 2003, 10:14:25 AM, you wrote: JT What I dont like about Suse is no ISOs unless you're willing to pay for JT the software. maybe i'll just buy the WS version and write it off on my JT taxes to run oracle on., hmm This is something I'm struggling with. I want to run Oracle on my lab systems, but I can't really afford to part with the $1500 or so that RH Enterprise costs. Oracle nicely makes their software free for learning, etc. Red Hat, unfortunately, does not. I think Red Hat's strategy makes a certain amount of sense though. They've identified a niche that will pay handsomely, compared to what your average consumer will pay, for Linux. Why not focus on that market? Best regards, E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
WHERE 1 = 1 (any info on this)
Morning folks, the developers here are looking at a view with a where clause which specifies : WHERE 1=1 AND ... AND ... etc. I'd seen this used before as a way of tweaking the RBO into certain behaviours but it was years ago and my recollection is very hazy. The only explanation I've found so far is : the 1=1 is in there to avoid doing repetitive index scans for single rowids, when the app knows the result set is going to be manipulated rowid's for a large subset of the table. I would guess your DUAL/CBO example had some similar effect. Is anyone familiar enough with this tweak to explain it ? Cheers, Mike PS Maybe it'll head off some replies if I make it clear that this view hasn't been generated by code so the 1=1 isn't an accidental artifact It was custom written and is definitely supposed to have exactly this structure. E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Cache a table
Hi, I'm sure you know this but you had some finger trouble there. Just to clarify it for others; Tables with the CACHE option are placed at the Most Recently Used end of the LRU list. Cheers, Mike Hately -Original Message- Sent: 21 October 2003 12:21 To: Multiple recipients of list ORACLE-L Never. Altering the table to cache does not gurantee that it will be always be available in the cache. It simply means the table will be placed in the Least recently used end of the LRU list and it will age away as time goes by, just like any other table. A better approach is to use KEEP pool and place teh table (and all other tables that are accessed frequently) there. This is particualrly true for datawarehouses wherethe lookup tables or small dimension tables can be placed in KEEP pool. Ah, come tho think about it, actually there is one situation where I will consider the CACHE option, when I restart the instance and want the hit ratio to look good :) HTH. Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 3:39 AM Hi all, when you would consider to put a table a cache... rgds gb E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: WHERE 1 = 1 (any info on this)
OK, here's the interesting thing. At 8.1.6.3 with optimizer_mode=rule the statement I'm looking at returns very different explain plans depending on whether the 1=1 clause is included. It's a complicated join and the explain plans are over 300 lines so it's not easy to see what's happening. I'll try with a simpler join. And yes, I know the RBO is ancient technology these days. =) Cheers, Mike -Original Message- Sent: 21 October 2003 12:05 To: Multiple recipients of list ORACLE-L I'm pretty sure the optimizer can pick up 1=1 anyway and ignore it as an always-true condition - so you get no benefit. The most common cause I've seen for 1=1 is so when developers are building dynamic where-clause, they don't need to worry about adding 'where' versus 'and' to the sql string being constructed. hth connor --- Hately, Mike (LogicaCMG) [EMAIL PROTECTED] wrote: Morning folks, the developers here are looking at a view with a where clause which specifies : WHERE 1=1 AND ... AND ... etc. I'd seen this used before as a way of tweaking the RBO into certain behaviours but it was years ago and my recollection is very hazy. The only explanation I've found so far is : the 1=1 is in there to avoid doing repetitive index scans for single rowids, when the app knows the result set is going to be manipulated rowid's for a large subset of the table. I would guess your DUAL/CBO example had some similar effect. Is anyone familiar enough with this tweak to explain it ? Cheers, Mike PS Maybe it'll head off some replies if I make it clear that this view hasn't been generated by code so the 1=1 isn't an accidental artifact It was custom written and is definitely supposed to have exactly this structure. E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://mail.messenger.yahoo.co.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538
RE: re Rebuilding Indexes in Oracle Apps -- was RE: RE: Separate
E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 Rebuilding Indexes in Oracle Apps -- was RE: RE: Separate
Correction. Paragraph 4 should begin, I agree though that index rebuilds are often unnecessary. Mike -Original Message- Sent: 16 October 2003 15:20 To: '[EMAIL PROTECTED]' All of that is fair enough but the number of rows and the values you've chosen fit the point you wished to prove. The value 5 conveniently fits the range for an existing leaf block with empty space. The facts as I understand them are this : Index space freed by deleted entries can be reused ( by subsequent transactions ) so long as the indexed value 'belongs' in the leaf block which has free space. Index leaf blocks are only placed back on the free list when they are empty of entries. This means that given a constantly incrementing index value no free space will be reused unless whole index blocks are emptied by deletes. This is fine for working tables which are constantly filled and (totally) emptied but it can lead to large indexes for tables which preserve small amounts os data across the range of keys. Such monotonically increasing key values are pretty common in my experience. I agree though that index rebuilds are often necessary. For a while now we've had useful commands like coalesce that could combine logically adjacent, sparsely populated leaf blocks at far less cost than a rebuild. Regards, Mike Hately -Original Message- Sent: 16 October 2003 14:29 To: Multiple recipients of list ORACLE-L Hi Rafiq, I haven't been receiving all the mail from this list so I don't know the full thread and it doesn't appear a mail I sent a few days ago regarding all this ever made it so I could be wasting my time again. But everytime I see comments as in the above, a voice in my head says do something, do something. So I'll try again. Having lots of deletes and inserts of course doesn't necessarily mean fragmentation. These so-called holes are fully re-usable and in the vast majority of cases results in no substantial issues. Having lots of deletes, inserts and updates rarely requires the index to be rebuilt. Simple little demo for any newbies or those force-fed Oracle myths since child birth ... demo snipped on space grounds - Mike Hately With few exceptions (the key is picking those rare cases), index rebuilds are redundant, wasteful and can actually be detrimental to performance. Cheers Richard E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Where can I download 10g ?
Best plan at the moment is : 1) Wait patiently for between 3 and 10 months (anyone got an accurate rumour for a release date?). 2) Download from Technet. Regards, Mike Hately -Original Message- Sent: 16 October 2003 16:49 To: Multiple recipients of list ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Financials and APPS password
I could be missing something here. If you set the profile option Utilities:Diagnostics to YES users are allowed to enable trace on a session without having to provied the APPS password. Cheers, Mike Hately -Original Message- Sent: 15 October 2003 14:29 To: Multiple recipients of list ORACLE-L April, We lost this battle with our developers - they have the password, along with strict instructions to behave. Nobody else should have the password to any of the schemas (APPS, GL, INV, etc.). We create logins for users that need them and grant the necessary rights to objects. As you know, APPS can do just about anything in the database, so you're asking for trouble if you let the whole company in there. Chances are you already have some objects in that schema like MICROSOFTDTPROPERTIES. Jay [EMAIL PROTECTED] 10/15/03 08:39AM Okay, anyone using Financials... E-Business suite... Oracle 11i... whatever you want to call it... I am trying to apply SOME kind of security to my databases. It appears that it is critical for everyone to be able to access production using the APPS id Finance and accounting people, developers, everyone. What does everyone else do in their setups? The newest reason is the need to run the new Mass Additions Trace which apparently requires that you use the apps id. We have found a way to set up any user with a read only version of what APPS has (since they have to be able to compile reports in production and access production data live rather than a month old clone), but Oracle says that you need to run Mass Additions Trace as apps. Does anyone let the entire company have the production apps user's password? April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \ \ \ Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Financials and APPS password
I thought it must be that. You know I've looked at the script and I'll be damned if I can see why you neeed to be connected as APPS. The argument seems to be that of the schema owners associated with Oracle Applications only APPS can be guaranteed to have select access on the DBA_* views. Note 155669.1 reads Please be sure to log in as the APPS user as this trace will not work correctly without access to DBA tables. To my mind this would run fine from a 'cloned' user. Cheers, Mike Hately Ana Ng and I are getting old And we still haven't walked in the glow of each other's majestic presence -Original Message- Sent: 15 October 2003 16:15 To: Multiple recipients of list ORACLE-L sorry... my bad. The script in question is apparently a trace generation script that is to be run from sqlplus April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \ \ \ Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- Sent: Wednesday, October 15, 2003 10:14 AM To: Multiple recipients of list ORACLE-L E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Cary's Book - new topic
But what !? Wedding bells? Mike -Original Message- Sent: 09 October 2003 12:59 To: Multiple recipients of list ORACLE-L This comment coming from Mladen means something ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Thursday, October 09, 2003 7:59 AM To: Multiple recipients of list ORACLE-L Connor, you're the best! 5 E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Unintentional Humor ( aka Robert's Book )
Without wishing to start another Cary's Fabled Book thread, I've got my copy of 10G Features on order. BTW I should mention I found Cary's book in Leeds at the weekend and it is, as trailed in this very group, a beauty. Cheers, Mike -Original Message- Sent: 07 October 2003 21:39 To: Multiple recipients of list ORACLE-L Oracle10g New Features is coming to a book store near you soon!! he he he E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: x$ constructs and memory
As I understand it, the X$ information is largely a window onto the control structures in shared memory rather than a summary, aggregation or abstraction. I may be wrong here but that's the way I've always understood it to work. So the structures 'occupy' the same space as the data they're supposed to reflect. If I'm wrong I'd be interested to know the true story. Cheers, Mike HAtely -Original Message- Sent: 29 September 2003 15:10 To: Multiple recipients of list ORACLE-L I was sitting on a mountain here in Colorado, pondering Oracle optimization and an interesting scenario crossed my feeble mind. As I began to ponder this (I asked the resident marmot, but he must be a SQL*Server expert...), I came up with several questions. Where in memory (sga or other) do the x$ constructs reside? Some of them are 'populated' by reading file-based structures (control file, datafile headers, undo segments). Does this information reside in memory or is it loaded each time the x$ construct is accessed? What happens when these x$constructs begin to consume large amounts of memory? Is there an upper bound? Daniel Fink E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 Re: RE: What is a large database?
Hmm, applied Feng Shui for Oracle Performance. For optimum throughput storage should be coloured red and white in alternating bands of colour. It's called disk-striping. Badummp-k !! I'll get me coat ... and back on topic. Mike -Original Message- Sent: 12 September 2003 11:14 To: Multiple recipients of list ORACLE-L LOL, Mauve is a shade of the colour Purple. And of course, everybody knows that purple databases run faster! ;) Personally, I've always preferred Electric Blue databases, funky, fast, and FAR easier to manage! E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 11i
Heh, notice the phrase next to nothing. I didn't get it free but I got it for about 28 pounds plus postage and handling. Compared to the price of ordering up a standard product that's a fairly reasonable price. Sorry if I wasn't very clear on that point. Regards, Mike -Original Message- Sent: 10 September 2003 16:05 To: Multiple recipients of list ORACLE-L Thanks, Mike. It still asks me to provide billing info when I tried to order the CD Packs. How did you get it for free? Nancy From: Hately, Mike (LogicaCMG) [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Oracle 11i Date: Wed, 10 Sep 2003 01:24:24 -0800 Nancy, look in the Oracle Store. You can buy it for next to nothing. Click the CD Packs tab, choose the platform you want, select 11i Release 9. Cheers, Mike Hately -Original Message- Sent: 10 September 2003 02:24 To: Multiple recipients of list ORACLE-L I would like to evaluate Oracle 11i. Could any body let me know what are pros and cons between Oracle 11i and Oracle Collaboration Suite? Is there any place where I can download Oracle 11i and related documents for trial? I can not find them on Oracle web site. Thanks for any inputs in advance. Nancy _ *** * E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 *** * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). _ Try MSN Messenger 6.0 with integrated webcam functionality! http://www.msnmessenger-download.com/tracking/reach_webcam -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anna Li INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE
RE: 9.2.0.4 anyone
It's available as a patch from Metalink. Cheers, Mike -Original Message- Sent: 11 September 2003 10:59 To: Multiple recipients of list ORACLE-L Where? I can only see 9.2.0.2 on the otn download site.. -Original Message- [EMAIL PROTECTED] Sent: 11 September 2003 01:20 To: Multiple recipients of list ORACLE-L Yeah, been out for some time now actually. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/10/2003 04:25 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: 9.2.0.4 anyone What? 9.2.0.4 is out now? RWB Reginald W. Bailey IBM Global Services - ETS SW GDSD - Database Management Your Friendly Neighborhood DBA 713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager) [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: 9.2.0.4 anyone ity.com 09/10/2003 05:24 PM Please respond to ORACLE-L Anyone have any negative experiences with 9.2.0.4 yet? Robert E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 can I see which database I am logged into without
Hi,
this statement returns the GLOBAL_NAME value rather than the database name.
Admittedly the 2 should usually be the same but often (following a database
clone for instance) it is not correctly set.
Regards,
Mike Hately
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 11, 2003 4:59 AM
How about SELECT ORA_DATABASE_NAME FROM DUAL;
HTH
GovindanK
select sys_context('USERENV','DB_NAME') from anytable;
At 10:49 AM 9/10/2003 -0800, you wrote:
hi.
I think there was a dbms package to get some of
the environment variables for a session, but I can't
remember anyhting specific. If someone know what I'm
talking about and has any details, please Email me or
post here
thanks
Gene
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com
E mail Disclaimer
You agree that you have read and understood this disclaimer and you agree to be bound
by its terms.
The information contained in this e-mail and any files transmitted with it (if any)
are confidential and intended for the addressee only. If you have received this
e-mail in error please notify the originator.
This e-mail and any attachments have been scanned for certain viruses prior to sending
but CE Electric UK Funding Company nor any of its associated companies from whom this
e-mail originates shall be liable for any losses as a result of any viruses being
passed on.
No warranty of any kind is given in respect of any information contained in this
e-mail and you should be aware that that it might be incomplete, out of date or
incorrect. It is therefore essential that you verify all such information with us
before placing any reliance upon it.
CE Electric UK Funding Company
Lloyds Court
78 Grey Street
Newcastle upon Tyne
NE1 6AF
Registered in England and Wales: Number 3476201
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hately, Mike (LogicaCMG)
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 11i
Tanel, the 11.5.9 docs ask you to get in touch if you're interested in a DVD release. It doesn't sound like it's actually available but they must be gauging interest for future releases. Cheers, Mike -Original Message- Sent: 10 September 2003 02:50 To: Multiple recipients of list ORACLE-L snipped for clarity - apologies You can't download 11i, you can order it for evaluation from Oracle, it's about 50 CD (when the heck will they put it on DVD?), Cheers, Tanel. E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 11i
Nancy, look in the Oracle Store. You can buy it for next to nothing. Click the CD Packs tab, choose the platform you want, select 11i Release 9. Cheers, Mike Hately -Original Message- Sent: 10 September 2003 02:24 To: Multiple recipients of list ORACLE-L I would like to evaluate Oracle 11i. Could any body let me know what are pros and cons between Oracle 11i and Oracle Collaboration Suite? Is there any place where I can download Oracle 11i and related documents for trial? I can not find them on Oracle web site. Thanks for any inputs in advance. Nancy _ E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 11i
I think they're available on most hardware platforms now. I don't know how many sites would back-order parts to replace CD drives but it's probably worth specifying them for new kit. I'd be interested in DVDs even if it's just for piloting new releases on Linux at home. For the record I think that a couple of the newer Sun boxes here have DVD drives. Mike. -Original Message- Sent: 10 September 2003 13:29 To: Multiple recipients of list ORACLE-L Just wondering... How many UNIX servers can read DVDs? Patrice. E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 11i
Ha! Tell me about it. I'm at the tail end of an upgrade. Just applying the unified driver to bring all of the products bang up to date. Just when you think you're on the home straight. A driver file with 920,000 lines that starts 71,000 scripts. It's enough to start me drinking! Mike -Original Message- Sent: 10 September 2003 14:49 To: Multiple recipients of list ORACLE-L Both 11.5.8 and 11.5.9 are 22 CDs, totalling about 12Gb. If you start with 11.5.8 or below, you'd also want to download the 11.5.9 patch anyway, which is a further 2.5Gb or so... on 9/10/03 2:19 AM, Hately, Mike (LogicaCMG) at [EMAIL PROTECTED] wrote: Tanel, the 11.5.9 docs ask you to get in touch if you're interested in a DVD release. It doesn't sound like it's actually available but they must be gauging interest for future releases. Cheers, Mike -Original Message- Sent: 10 September 2003 02:50 To: Multiple recipients of list ORACLE-L snipped for clarity - apologies You can't download 11i, you can order it for evaluation from Oracle, it's about 50 CD (when the heck will they put it on DVD?), Cheers, Tanel. ** ** E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 ** ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 11i
April, Nothing disastrous has happened actually (touch wood!) which was a surprise. We're going from 11.0.3 so I've seen things that no man should ever have to see. =) Mostly small data fixes specific to us. I'll let you know if we get a fix to this current problem. Feel free to get in touch if you hit any problems. I'll trawl through my issues folder and forward anything that I think you may hit. Cheers, Mike Hately -Original Message- Sent: 10 September 2003 15:39 To: Multiple recipients of list ORACLE-L Anything break badly? We are going to be starting in about a month down the 11.5.8 - 11.5.9 road. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \ \ \ Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Wednesday, September 10, 2003 10:29 AM To: Multiple recipients of list ORACLE-L Ha! Tell me about it. I'm at the tail end of an upgrade. Just applying the unified driver to bring all of the products bang up to date. Just when you think you're on the home straight. A driver file with 920,000 lines that starts 71,000 scripts. It's enough to start me drinking! Mike E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: what is a materialized view ?
may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 Masters exam
Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Friday at the coding face...
My score : 10/10 Your liver is safe =) What worries me most is that I named the majority of the serial killers but didn't recognise any coders. Maybe I'm in the wrong job. regards, Mike -Original Message- Sent: 29 August 2003 16:34 To: Multiple recipients of list ORACLE-L This week a game was brought to the attention of the Round-Up which perfectly sums up the image crisis besieging IT. Can you tell which of these mugshots are programmers and which are serial killers? http://www.malevole.com/mv/misc/killerquiz/ It's actually quite difficult (not to mention scary to realise there is very little to choose between mass murderers and techies). ( hope this 'off topic' is acceptable within the spirit of Friday afternoons!) peter * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. .http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: SGA
http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: dbca and finish button
John, are you seeing any java errors in the window you used to start the DBCA? There's a problem where the installer can stick at this point. It's described in Tech. Note 131761.1 on MetaLink. Effectively there's a problem in the listener.ora (an ADDRESS entry with no HOST entry) that causes DBCA to choke. kind of an old error but you never know! Regards, Mike Hately John Dunn john.dunn To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @sefas.co.ukcc: Sent by: Subject: dbca and finish button ml-errors Have just installed Oracle 9.2 and am trying to use dbca to create a database. Even though I select to create a database it just displays the template with the option to save as HTML, but does not create the database! Am I missing something here? John E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: ORA-3113
Unfortunately he's rebooted so the box is probably clean. Did all of your products relink successfully? Are there any errors in the OS system logs? Would any of the patches have changed you kernel settings for shared memory or semaphores? Can you run the HP equivalent of truss (I believe it's tusc) to see what calls the oracle process is making? Cheers, Mike -Original Message- Sent: 06 August 2003 17:10 To: Multiple recipients of list ORACLE-L left over memory segments/shared memory/semaphores? ipcs is your friend, oh and its destructive brother ipcrm :) joe [EMAIL PROTECTED] wrote: E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: ORA-3113
Any log file output? Mike -Original Message- [mailto:[EMAIL PROTECTED] Sent: 06 August 2003 16:29 To: Multiple recipients of list ORACLE-L Applied 250 OS patches on HP-UX 11.11 server and after that getting ORA-3113 error message every time I do svrmgrl or sqlplus /nolog connect /as sysdba. This database holds RMAN catalog for more than 30 databases and really very critical. Please share your ideas. I already tried to relink and rebooting the server. Database is 816 64bit on HP-UX 11.11 DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 -- Boston Globe job listings
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.net -- Author: KENNETH JANUSZ INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Question on views
Stephen, Traditional views don't go stale though they can be made invalid if the underlying objects change. This shouldn't really be happening on a regular basis unless the schema is changing rapidly. He may be using a materialized view. These can go stale. Before going any further ask him which of these is the cause and get the name of the view. I'd have thought that if a materialized view was created by his application then it's his responsibility. Cheers, Mike Hately, Consultant DBA -Original Message- [mailto:[EMAIL PROTECTED] Sent: 12 August 2003 13:40 To: Multiple recipients of list ORACLE-L I just had a contractor tell me that the problem with my Diabetic detection and Listing 'feature' in their product (Integrated Clinical Database, ICDB) is because the 'view' crafted for that detection is going 'stale'. I admit that most my SQL design experience is in MSSQL's T-SQL although I'm starting to come up to speed on SQL*Plus, anyway, the above explanation provided to be from the TriCare guy seems bogus. Simply put there are four or five good Lab Chemistry parameters one could use in a SQL select statement to determine if a patient is diabetic or a diabetic candidate without having specific ICD9 diagnosis coding that declares the patient diabetic. A select statement returns a cursor of data that meets the selection criteria and on MSSQL is a static snapshot of what is in the database at the time the query was executed. Thus, if a patient had parameters that met diabetic conditions stored in the database over the past year, how can a view go 'stale'? Is this just a Oracle peculiarity or am I getting a smoke screen as I suspect? v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Capacity Planning Methods?
Come on Brad, this is the guy's wife you're talking about !! =) Mike -Original Message- Sent: 12 August 2003 15:14 To: Multiple recipients of list ORACLE-L EWWAH! Morgan FairchildYUK! -Original Message- Sent: Tuesday, August 12, 2003 9:44 AM To: Multiple recipients of list ORACLE-L blush Let's just say it's the same as Jared's...Yeah, that's it! The very same! And my wife, Morgan Fairchild, whom I've seen naked. sigh When you don't update those old scripts with newer versions of Oracle they really look old and convoluted. Rich E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: UNDO Tablespace
The answer for this from our vendor is to increase the size of the UNDO based on their DBAs statement that UNDO is consumed rapidly because every query makes a physical copy of all tables and holds on to them for the retention period. Sherrie, In my considered opinion: Woohoohoohoo. That's a ridiculous thing for a DBA to say. I hope he was misinterpreted somewhere down the line because otherwise he's got a very flimsy grasp of the read-consistency model. In very simple terms Undo is used to hold a copy of any changed data (not the whole table!) which has not been committed and flushed to the datafiles. While it's there the data for an update transaction is available a) to the 'owning' transaction in case it has to ROLLBACK the updates it's made. b) to any other transactions which need to reconstruct the data as it was before the update began. On a more positive note I agree that we need the text of the error message in order to give some help. Cheers, Mike - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 4:39 PM I have a 2gb UNDO tablespace. A third-party application continually runs out of UNDO when it joins two tables to produce a result table. Our retention time is set to 15 minutes, the NoSpaceErrCnt in V$UNDOSTAT is always zero. The answer for this from our vendor is to increase the size of the UNDO based on their DBAs statement that UNDO is consumed rapidly because every query makes a physical copy of all tables and holds on to them for the retention period. I can find nothing that discusses exactly how UNDO physically works, and am not sure that this can be true. That would mean that every user querying our database would have copies of the tables in the UNDO, and I'd need about a gazillion gb to handle that. Does anyone have any insights on how the UNDO physically works? --- Sherrie Kubis Southwest Florida Water Management District 2379 Broad Street Brooksville FL 34604-6899 E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: [stupid] vi question
Type : (to get the command prompt at the bottom of the screen) Then type %s/^M// and press enter. Note that you get ^M by pressing Ctl/V followed by Ctl/M. Regards, Mike Hately -Original Message- Sent: 06 August 2003 17:09 To: Multiple recipients of list ORACLE-L Suddenly my vi editor is showing ^M at the end of each line. How do I get rid of it? Thanks in advance, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Move selected tables
something like ... set feed off set echo off set pages 0 select 'alter table '||table_name||' move tablespace NEW_TS;' from user_tables where table_name like 'ABC_%' spool move_tables.sql / spool off would generate you a script to move your tables. Cheers, Mike PS That's off the top of my head so exercise care when running it. -Original Message- Sent: 04 August 2003 16:14 To: Multiple recipients of list ORACLE-L I need to move selected tables from one schema to another schema within the same database. The tables I need to move all start with the same prefix (abc_sometablename). Say there are 200 tables out of 1000 that I want to move. Is there an easy way to do this? Thanks! Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Move selected tables
Bugger. I missed the schema bit didn't I. Never mind, back to the drawing board ... Mike -Original Message- Sent: 04 August 2003 16:14 To: Multiple recipients of list ORACLE-L I need to move selected tables from one schema to another schema within the same database. The tables I need to move all start with the same prefix (abc_sometablename). Say there are 200 tables out of 1000 that I want to move. Is there an easy way to do this? Thanks! Ron E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: 9i - Dynamic SGA - SGA_MAX_SIZE
it is stupid. Why grab the memory from the os but never use it. stephen. [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 01, 2003 12:54 PM Hi, does anybody have any experience with setting the SGA_MAX_SIZE in 9i. I assumed the purpose of this parameter was that SGA would grow as requested to that limit. Example: You could configure your SGA to be 80M Set the SGA_MAX_SIZE to be 250M. I would have expected oracle to acquire 80M of memory from the UNIX machine. In fact using ipcs you can see that oracle will always acquire the value of SGA_MAX_SIZE. It acquires the extra space in the Variable Size of the SGA Figures snipped for brevity - Mike Hately I have raised a lengthy call on Metalink and the consultants are convinced this is normal behaviour and what you would expect. Do people agree with the metalink consultants? Maybe my expectations were to high but I thought a dynamic sga would mean I could change the amount of memory acquired by the UNIX box. All opinions welcome. I am on tru64 platform - 9.2.0.3.0 Thanks, Stephen E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Redo Logs Problem
Hi, you may be able to identify the sessions that are generating a lot of redo by running this query. It will list the amount of redo generated by eash session. select s.sid,s.value from v$sesstat s where s.statistic#=99 and s.value!=0 Cheers, Mike Hately -Original Message- Sent: 01 August 2003 10:34 To: Multiple recipients of list ORACLE-L Hi Listers, One of my remote Clients is facing a problem with Redo Logs. The Redo Logs and the Archive logs in turn have suddenly started to generate at an alarming Rate. This has suddenly started from the last 1 week without any changes to Database Configuration or any other system settings (as per client). Can anyone please help me and let me know all the reasons that could be responsible for this behavior. Any Help from u will be appreciated. Regards Munish Bajaj E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Imort Parameter File Question
Had a couple of minutes so ... The syntax you need is (cryptically enough) : # Comment Cheers, Mike Hately -Original Message- Sent: 31 July 2003 16:50 To: Multiple recipients of list ORACLE-L Jay - I don't think the exp and imp parameter files have provision for a comment. But you could try common comment formats and see if you find one that works. The person who wrote the parser might have added that but it didn't end up in the documentation. I notice testing is a habit of the more expert members of this list. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, July 31, 2003 11:34 AM To: Multiple recipients of list ORACLE-L Hello: Does anyone know if you can create a comment in a import parameter file? If so could you provide a sample of the syntax. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Sizing Indexes - URGENT
The voice of reason! Thanks Dan. How many times have I been asked for an estimate of an index size (including every tiny overhead and spare byte) without knowing how many rows will be inserted. So they need an exact calculation based on a very rough estimate. As a result my calculation method has evolved into: - calculate the average index entry size. - multiply by the estimated number of rows. - factor in the PCTFREE setting. - add up to half as much again depending on the faith you have in the figures you've been given. Then use the time saved to get on with better value work. Your mileage may vary. Mike Hately -Original Message- Sent: 17 March 2003 14:14 To: Multiple recipients of list ORACLE-L Jai, The formula you are using is reasonably accurate, but not very useful. One of the main problems I have found with this approach is that the number of rows is not usually known. The business side and designers might have an idea of data sizes, but the reality is that most times they are not accurate. This makes a fine-grained sizing approach ultimately innacurate. Use locally managed tablespaces and create estimated sizes. Add in enough space for variances and keep an eye on them. When in doubt, err on the side of overallocation. -- Daniel W. Fink http://www.optimaldba.com http://www.optimaldba.com IOUG-A Live! April 27 - May 1, 2003 Orlando, FL Sunday, April 27 8:30am - 4:30pm - Problem Solving with Oracle 9i SQL Wednesday, May 1 1:00pm - 2:00pm - Automatic Undo Internals [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Dear All, I have a task on hand to size a database for our application. I have used the Oracle rule to find out the rowsize of rows in a table. 1.Space available for the data (SAD) = data block size - block header size = db_block_size - kcbh - ub4 - ktbbh - (initrans -1)* ktbit - kdbh 2.Available Data Space (ADS) = ceil(SAD * (1-pctfree/100)) - kdbt 3.Space used per row (SPR) = (Total size of the columns data length) + (1 byte per column with length 250 )+ (3 * 1 byte per column with length = 250) 4.Row Size (ROWSZ) = 3 * ub1 + SPR 5.Space used per row(SPROW) = max(ub1 * 3 + ub4 + sb2, ROWSZ) + sb2 6.Total Size of the table = Expected Number of records * SPROW I hope this formula is correct. How can I do the sizing of indexes. Shouldn't I take into account the 10 bytes consumed by the ROWID pseudocolumn apart from the column(s) that are indexed ? TIA for all your help. Best Regards Jai ** The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it. If you have received this e-mail in error, please notify [EMAIL PROTECTED] (UK 01384 275454) and delete it immediately from your system. ** ** The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it. If you have received this e-mail in error, please notify [EMAIL PROTECTED] (UK 01384 275454) and delete it immediately from your system. Neither Npower nor any of the other companies in the Innogy group from whom this e-mail originates accept any responsibility for losses or damage as a result of any viruses and it is your responsibility to check attachments (if any) for viruses. Npower Limited Registered office: Windmill Hill Business Park, Whitehill Way, Swindon SN5 6PB. Registered in England and Wales: number 3653277. This e-mail may be sent on behalf of a member of the Innogy group of companies. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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
RE: How to start with Oracle Financial?
To be honest if you can't download manuals, books or software you don't leave yourself many options. It's not clear whether you've been unable to download manuals or won't. The manuals are all available at http://download-uk.oracle.com/docs/cd/A99488_01/html/erpdoc.html. You can't download Oracle Financials but you can order Oracle Financials from the Oracle Store? It's pretty cheap (look under CD Packs). Cheers, Mike -Original Message- Sent: 28 February 2003 10:29 To: Multiple recipients of list ORACLE-L Hello List, Have the one question from subj please. I'd like to get some initial experience with Oracle Financial. What is the best way to do so? I couldn't download this package or manuals/books from OTN for practise... But I need to have some knowledge of it to get new job. Thank you for your help. -- Best regards, Alex ** The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it. If you have received this e-mail in error, please notify [EMAIL PROTECTED] (UK 01384 275454) and delete it immediately from your system. Neither Npower nor any of the other companies in the Innogy group from whom this e-mail originates accept any responsibility for losses or damage as a result of any viruses and it is your responsibility to check attachments (if any) for viruses. Npower Limited Registered office: Windmill Hill Business Park, Whitehill Way, Swindon SN5 6PB. Registered in England and Wales: number 3653277. This e-mail may be sent on behalf of a member of the Innogy group of companies. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 start with Oracle Financial?
Alternatively, rather than playing the E-Bay lottery you can go to the Oracle store and buy the same for 39.95 USD. Theoretically you should also order a trial license but these are free so what's the point. Anyone? Am I missing something here? Cheers, Mike -Original Message- Sent: 28 February 2003 12:49 To: Multiple recipients of list ORACLE-L Alex, from time to time offers for OraApps are appearing for sale on www.ebay.com For 90-100USD you can buy 50 CDs with a lot a (OraApps more )stuff there... These CDs are for educational pusposes only and are not time-constrant (at least the sellers state so ;)) HTH. Milen -Ursprüngliche Nachricht- Von: Hately, Mike (NESL-IT) [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 28. Februar 2003 12:49 An: Multiple recipients of list ORACLE-L Betreff: RE: How to start with Oracle Financial? To be honest if you can't download manuals, books or software you don't leave yourself many options. It's not clear whether you've been unable to download manuals or won't. The manuals are all available at http://download-uk.oracle.com/docs/cd/A99488_01/html/erpdoc.html. You can't download Oracle Financials but you can order Oracle Financials from the Oracle Store? It's pretty cheap (look under CD Packs). Cheers, Mike -Original Message- Sent: 28 February 2003 10:29 To: Multiple recipients of list ORACLE-L Hello List, Have the one question from subj please. I'd like to get some initial experience with Oracle Financial. What is the best way to do so? I couldn't download this package or manuals/books from OTN for practise... But I need to have some knowledge of it to get new job. Thank you for your help. -- Best regards, Alex ** The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it. If you have received this e-mail in error, please notify [EMAIL PROTECTED] (UK 01384 275454) and delete it immediately from your system. Neither Npower nor any of the other companies in the Innogy group from whom this e-mail originates accept any responsibility for losses or damage as a result of any viruses and it is your responsibility to check attachments (if any) for viruses. Npower Limited Registered office: Windmill Hill Business Park, Whitehill Way, Swindon SN5 6PB. Registered in England and Wales: number 3653277. This e-mail may be sent on behalf of a member of the Innogy group of companies. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: OFF TOPIC: Jedis, etc - was Top 10....
And there is no such thing as an 'unofficial' religion. It's just whether people recognise it or not. Damn funny! I agree that there's no such thing as an unofficial religion but surely there is nobody (excepting the heavily medicated and chronically deluded) who truly believes that they are a jedi knight. They must be as much fun as the guys with Klingon dictionaries and transporter rooms in their loft. Mike PS I can feel the take this off-list bar lowering even as I speak. -Original Message- Sent: 25 February 2003 11:20 To: Multiple recipients of list ORACLE-L Actually Peter, This came under the category of No Religion which had 9+ million people in it (15.5% of respondents, see below). About sixteen per cent of the UK population stated that they had no religion. This category included agnostics, atheists, heathens and those who wrote Jedi Knight. And there is no such thing as an 'unofficial' religion. It's just whether people recognise it or not. DarthK. ** The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it. If you have received this e-mail in error, please notify [EMAIL PROTECTED] (UK 01384 275454) and delete it immediately from your system. Neither Npower nor any of the other companies in the Innogy group from whom this e-mail originates accept any responsibility for losses or damage as a result of any viruses and it is your responsibility to check attachments (if any) for viruses. Npower Limited Registered office: Windmill Hill Business Park, Whitehill Way, Swindon SN5 6PB. Registered in England and Wales: number 3653277. This e-mail may be sent on behalf of a member of the Innogy group of companies. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Installing Oracle Apps 11i on Linux
Dale, thanks for sharing, this is going to be pretty useful in the future. I read the warnings and had a copy of Suse 7.0 at home so I've only ever installed it onto the recommended platform. Armed with your summary I may have a shot at installing it on 8.1. Cheers, Mike -Original Message- Sent: 21 February 2003 10:34 To: Multiple recipients of list ORACLE-L Hello All The link below contains a summary of my experiences in installing Oracle Apps 11i (11.5.7) on Linux (Redhat 8.0 and SUSE 8.1 Professional). I'm posting it because I would really have appreciated being able to read something like this prior to starting my installation :-) http://databee.com/apps11i_install.htm Regards - Dale - Need databases for development and test? You need DataBee - the low-hassle way to create, maintain and refresh test and development databases. http://www.DataBee.com ** The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it. If you have received this e-mail in error, please notify [EMAIL PROTECTED] (UK 01384 275454) and delete it immediately from your system. ** ** The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it. If you have received this e-mail in error, please notify [EMAIL PROTECTED] (UK 01384 275454) and delete it immediately from your system. Neither Npower nor any of the other companies in the Innogy group from whom this e-mail originates accept any responsibility for losses or damage as a result of any viruses and it is your responsibility to check attachments (if any) for viruses. Npower Limited Registered office: Windmill Hill Business Park, Whitehill Way, Swindon SN5 6PB. Registered in England and Wales: number 3653277. This e-mail may be sent on behalf of a member of the Innogy group of companies. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: [new info] Redhat Advanced Server Dev Edition - RAC
Advanced Server (developer's edition) seems to be much easier than the standard edition simply in terms of getting OCFS to work so that's the way I've gone. I've tried Suse 8.0 and RedHat 8.0 and I could load the OCFS module but it wasn't stable and frankly I didn't trust it much. Also using the AS product is a convenient way to evaluate it for the future. Right now I have RHAS and OCFS working on one box apparently sharing a firewire disk. I'll install 9iR2 tonight and see if I can build the 2nd node tonight. There seem to be 4 different sets of instructions for firewire RAC and I haven't followed any of them exclusively. Regards, Mike -Original Message- Sent: 10 February 2003 16:34 To: Multiple recipients of list ORACLE-L Are you going to use RH AS or the plain version? Thanks Waleed -Original Message- Sent: Monday, February 10, 2003 10:19 AM To: Multiple recipients of list ORACLE-L I'm setting this up now. Still not exactly smooth. I currently have 4 different sets of instructions on how to set this up and I'm working through them with increasingly high stress levels =) Perhaps it's time to cut back the coffee intake and have lunch. Cheers, Mike Hately -Original Message- Sent: 10 February 2003 14:04 To: Multiple recipients of list ORACLE-L This is great! So how can we get a RAC configuration running for less 1000 dollars? :) Waleed ** The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it. If you have received this e-mail in error, please notify [EMAIL PROTECTED] (UK 01384 275454) and delete it immediately from your system. Neither Npower nor any of the other companies in the Innogy group from whom this e-mail originates accept any responsibility for losses or damage as a result of any viruses and it is your responsibility to check attachments (if any) for viruses. Npower Limited Registered office: Windmill Hill Business Park, Whitehill Way, Swindon SN5 6PB. Registered in England and Wales: number 3653277 This e-mail may be sent on behalf of a member of the Innogy group of companies. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: [new info] Redhat Advanced Server Dev Edition - RAC
yep I must know this by heart now. Also see Metalink Tech notes, 183408.1 and 220178.1 and http://www.dbasupport.com/oracle/ora9i/RacLinuxFirewire1.shtml regards, Mike -Original Message- Sent: 11 February 2003 14:40 To: Multiple recipients of list ORACLE-L I was doing some research on firewire disks when saw this article: http://technet.oracle.com/oramag/webcolumns/2002/opinion/coekaerts_linux01.h tml Regards, Waleed -Original Message- Sent: Tuesday, February 11, 2003 4:09 AM To: Multiple recipients of list ORACLE-L Advanced Server (developer's edition) seems to be much easier than the standard edition simply in terms of getting OCFS to work so that's the way I've gone. I've tried Suse 8.0 and RedHat 8.0 and I could load the OCFS module but it wasn't stable and frankly I didn't trust it much. Also using the AS product is a convenient way to evaluate it for the future. Right now I have RHAS and OCFS working on one box apparently sharing a firewire disk. I'll install 9iR2 tonight and see if I can build the 2nd node tonight. There seem to be 4 different sets of instructions for firewire RAC and I haven't followed any of them exclusively. Regards, Mike -Original Message- Sent: 10 February 2003 16:34 To: Multiple recipients of list ORACLE-L Are you going to use RH AS or the plain version? Thanks Waleed -Original Message- Sent: Monday, February 10, 2003 10:19 AM To: Multiple recipients of list ORACLE-L I'm setting this up now. Still not exactly smooth. I currently have 4 different sets of instructions on how to set this up and I'm working through them with increasingly high stress levels =) Perhaps it's time to cut back the coffee intake and have lunch. Cheers, Mike Hately -Original Message- Sent: 10 February 2003 14:04 To: Multiple recipients of list ORACLE-L This is great! So how can we get a RAC configuration running for less 1000 dollars? :) Waleed ** The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it. If you have received this e-mail in error, please notify [EMAIL PROTECTED] (UK 01384 275454) and delete it immediately from your system. Neither Npower nor any of the other companies in the Innogy group from whom this e-mail originates accept any responsibility for losses or damage as a result of any viruses and it is your responsibility to check attachments (if any) for viruses. Npower Limited Registered office: Windmill Hill Business Park, Whitehill Way, Swindon SN5 6PB. Registered in England and Wales: number 3653277 This e-mail may be sent on behalf of a member of the Innogy group of companies. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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
RE: Breaking down values in a large table
Hi John, the FILESIZE parameter would certainly work but if you don't know how big your export file will be then it won't help you to split it accurately into 4. This query should get you the 25%, 50% and 75% marks. The 100% is easy. select * from (select rownum rnum,a.* from (select log_no from table_name order by log_no asc ) a ) where rnum in (3125,6200,9375); Hope that helps, Mike Another quality solution by your neighbourhood 9i OCP DBA - heh heh ! -Original Message- Sent: 11 February 2003 14:19 To: Multiple recipients of list ORACLE-L Listers, I have a table of 125M rows (not partitioned) which I am exporting. I want to break the export into 4 dmp files using the query command on the pk column. I am looking at how the best way of finding the values of the PK (number) which are at 25%, 50% and 75% ish for the table so that I can get 4 evenly sized exports My query line in the parameter file will be along the lines of where 1) log_no xx 2) log_no = xx and yy 3) log_no = yy and zz 4) log_no = zz I am thinking of a sql something like the following Select /*+ index ffs(table_name index_name) */ Log_no , floor(log_no / 4), count(*) From table_name group by floor(log_no / 4), log_no Version is 8.1.7.1 Can anybody help please Thanks John ** The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it. If you have received this e-mail in error, please notify [EMAIL PROTECTED] (UK 01384 275454) and delete it immediately from your system. ** ** The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it. If you have received this e-mail in error, please notify [EMAIL PROTECTED] (UK 01384 275454) and delete it immediately from your system. Neither Npower nor any of the other companies in the Innogy group from whom this e-mail originates accept any responsibility for losses or damage as a result of any viruses and it is your responsibility to check attachments (if any) for viruses. Npower Limited Registered office: Windmill Hill Business Park, Whitehill Way, Swindon SN5 6PB. Registered in England and Wales: number 3653277 This e-mail may be sent on behalf of a member of the Innogy group of companies. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: [new info] Redhat Advanced Server Dev Edition - RAC
I don't know anyone who needs it but Oracle is behind it and that means that sooner or later they'll start to shift licenses. I'd be foolish to ignore the chance to experiment with RAC at home for £150 (I had a lot of the kit already) rather than pay Oracle £1158 for a 3 day RAC course (plus the loss of 3 days income). Add on to that the amount I've learned about the linux kernel and the fact that frankly a firewire disk is just generally useful to have around (backups/temporary storage for video or music) and I think I'd be a mug to do otherwise. So no, I don't work for a company that needs this but in the near future I may. Cheers, Mike -Original Message- Sent: 11 February 2003 16:30 To: Multiple recipients of list ORACLE-L This is all cool technology, and fun stuff to play with. It all begs the questions, How many of us work for a business that actually need this? Are they willing to pay $400/user $20k/CPU above the cost of Oracle 9i EE to use it? Are they willing to pay the extra overhead required to maintain it? I'm not sure the ROI is there for many of us. Though downtime at our business is somewhat expensive, I think that a failover system or even standby database will provide adequate coverage for us, which is indeed a hot topic here right now, after our Dell SAN put us out of business for 36 hours. RAC wouldn't have helped much there. Niether would a cluster for that matter. Standby DB would have been perfect. This whole push of RAC by Oracle reminds me very much of the mlife phone campaign by ATT. Do you really need to take pictures with your phone? And what is the point of sending text messages to someone elses phone when you could just call them? ATT needs you to buy this stuff, because they have it for sale. I see RAC in a similar light. Do you need RAC? Oracle needs you to 'need' it, because they need some reason for you to spend more money on their product. Jared ** The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it. If you have received this e-mail in error, please notify [EMAIL PROTECTED] (UK 01384 275454) and delete it immediately from your system. Neither Npower nor any of the other companies in the Innogy group from whom this e-mail originates accept any responsibility for losses or damage as a result of any viruses and it is your responsibility to check attachments (if any) for viruses. Npower Limited Registered office: Windmill Hill Business Park, Whitehill Way, Swindon SN5 6PB. Registered in England and Wales: number 3653277 This e-mail may be sent on behalf of a member of the Innogy group of companies. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Error in Rownum Select
Stefan, The original query returns the 6th highest value so the ORDER BY is crucial. At least if I read it correctly. Cheers, Mike -Original Message- Sent: 11 February 2003 16:24 To: Multiple recipients of list ORACLE-L Hi Maybe I miss the point, but I don't really see the need for an order by here ? Can't you just dismiss it ? Regards, Stefan Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto: [EMAIL PROTECTED] Please remove nospam to contact me via email. visit our website: http://www.bov.de http://www.bov.de/ subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp http://www.bov.de/presse/newsletter.asp Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen! Weitere Informationen unter +49 201/45 13-240 oder E-Mail an mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] . Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. ** The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it. If you have received this e-mail in error, please notify [EMAIL PROTECTED] (UK 01384 275454) and delete it immediately from your system. Neither Npower nor any of the other companies in the Innogy group from whom this e-mail originates accept any responsibility for losses or damage as a result of any viruses and it is your responsibility to check attachments (if any) for viruses. Npower Limited Registered office: Windmill Hill Business Park, Whitehill Way, Swindon SN5 6PB. Registered in England and Wales: number 3653277 This e-mail may be sent on behalf of a member of the Innogy group of companies. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: [new info] Redhat Advanced Server Dev Edition - RAC
I'm setting this up now. Still not exactly smooth. I currently have 4 different sets of instructions on how to set this up and I'm working through them with increasingly high stress levels =) Perhaps it's time to cut back the coffee intake and have lunch. Cheers, Mike Hately -Original Message- Sent: 10 February 2003 14:04 To: Multiple recipients of list ORACLE-L This is great! So how can we get a RAC configuration running for less 1000 dollars? :) Waleed -Original Message- Sent: Sunday, February 09, 2003 12:24 AM To: Multiple recipients of list ORACLE-L To those who are interested in running RAC on Linux. I know we have been talking about RAC on linux lately. This is great news Redhat has made a special developer's edition for their Advanced Server which only costs $60! So we don't have to shell out $699 for a copy of RHAS 2.1 to play with RAC. http://www.redhat.com/software/advancedserver/developer/ Have fun. Richard Ji -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). ** The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it. If you have received this e-mail in error, please notify [EMAIL PROTECTED] (UK 01384 275454) and delete it immediately from your system. ** ** The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it. If you have received this e-mail in error, please notify [EMAIL PROTECTED] (UK 01384 275454) and delete it immediately from your system. Neither Npower nor any of the other companies in the Innogy group from whom this e-mail originates accept any responsibility for losses or damage as a result of any viruses and it is your responsibility to check attachments (if any) for viruses. Npower Limited Registered office: Windmill Hill Business Park, Whitehill Way, Swindon SN5 6PB. Registered in England and Wales: number 3653277 This e-mail may be sent on behalf of a member of the Innogy group of companies. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: [new info] Redhat Advanced Server Dev Edition - RAC
OCFS I'm afraid. The RHAS install goes quickly and without incident. The problem I have is that having installed the firewire kernel and the OCFS tools, my disk (which I can happily format as ext2) refuses to be formatted as an OCFS filesystem. The format command completes immediately with no errors but does nothing. Pretty annoying stuff. Mind you, I spent most of last week trying to get this to work with Suse 8.0. It would have worked (as would RHAS2.1) if I used raw devices instead of OCFS but that would feel like a job half done. I'll get there in the end but any pointers from folks who've got this working would be appreciated. Cheers, Mike -Original Message- Sent: 10 February 2003 16:29 To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Are you pulling your hair out over the RHAS or RAC installs? Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA ** The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it. If you have received this e-mail in error, please notify [EMAIL PROTECTED] (UK 01384 275454) and delete it immediately from your system. Neither Npower nor any of the other companies in the Innogy group from whom this e-mail originates accept any responsibility for losses or damage as a result of any viruses and it is your responsibility to check attachments (if any) for viruses. Npower Limited Registered office: Windmill Hill Business Park, Whitehill Way, Swindon SN5 6PB. Registered in England and Wales: number 3653277 This e-mail may be sent on behalf of a member of the Innogy group of companies. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: [new info] Redhat Advanced Server Dev Edition - RAC
Ah, got it! As with all things it doesn't really work until you tick the box that says FORCE. Cheers, Mike -Original Message- Sent: 10 February 2003 16:38 To: 'Jesse, Rich'; '[EMAIL PROTECTED]' Cc: Hately, Mike (NESL-IT) OCFS I'm afraid. The RHAS install goes quickly and without incident. The problem I have is that having installed the firewire kernel and the OCFS tools, my disk (which I can happily format as ext2) refuses to be formatted as an OCFS filesystem. The format command completes immediately with no errors but does nothing. Pretty annoying stuff. Mind you, I spent most of last week trying to get this to work with Suse 8.0. It would have worked (as would RHAS2.1) if I used raw devices instead of OCFS but that would feel like a job half done. I'll get there in the end but any pointers from folks who've got this working would be appreciated. Cheers, Mike -Original Message- Sent: 10 February 2003 16:29 To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Are you pulling your hair out over the RHAS or RAC installs? Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA ** The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it. If you have received this e-mail in error, please notify [EMAIL PROTECTED] (UK 01384 275454) and delete it immediately from your system. Neither Npower nor any of the other companies in the Innogy group from whom this e-mail originates accept any responsibility for losses or damage as a result of any viruses and it is your responsibility to check attachments (if any) for viruses. Npower Limited Registered office: Windmill Hill Business Park, Whitehill Way, Swindon SN5 6PB. Registered in England and Wales: number 3653277 This e-mail may be sent on behalf of a member of the Innogy group of companies. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: [new info] Redhat Advanced Server Dev Edition - RAC
Rich, I was just about to go the SCSI route when the firewire patch came out and I have 2 machines available with firewire and 500MB RAM each. Once I get this up and running I might try the NBD method that Brian Hengen suggested last week. Someone on site here is talking about building a Tru64 cluster soon so I may have the chance to play with shared SCSI at someone else's expense. We can only hope. In the meantime the past fortnight has taught me a heck of a lot about the linux kernel. I just got my disk formatted so I have 80GB to share with my other box when I get home. The RAC part is going to be easy after this. I should think that a document will come out this in the hope that it helps someone somewhere down the line. Mike -Original Message- Sent: 10 February 2003 17:08 To: 'Hately, Mike (NESL-IT)'; '[EMAIL PROTECTED]' Ayou're using Wim Coekaerts' Firewire mod. I wonder if that's what's giving you grief and not OCFS? Please? We should be able to test RAC with a dual-ended SCSI or SAN. prayHopefully we won't have those problems!/pray Keep us informed of your progress! GL! Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA ** The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it. If you have received this e-mail in error, please notify [EMAIL PROTECTED] (UK 01384 275454) and delete it immediately from your system. Neither Npower nor any of the other companies in the Innogy group from whom this e-mail originates accept any responsibility for losses or damage as a result of any viruses and it is your responsibility to check attachments (if any) for viruses. Npower Limited Registered office: Windmill Hill Business Park, Whitehill Way, Swindon SN5 6PB. Registered in England and Wales: number 3653277 This e-mail may be sent on behalf of a member of the Innogy group of companies. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: undo tablespace
Breno, There's no way to do this because it's the central pillar of Oracle's read consistency mechanism. It's possible to minimise or suppress redo but undo is out of your control. regards, Mike Hately -Original Message- Sent: 29 January 2003 11:39 To: Multiple recipients of list ORACLE-L I have a high procedure (many INSERT's and UPDATE´s). This procedure generate insert's in UNDO TableSpace for rollback. I want to know if exists any way for don´t generate insert´s in UNDO Tablespace. Oracle 9i / NT Thanks. -- Breno A. K. Magnago mailto:[EMAIL PROTECTED] Mercantil de Alimentos Soares -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Breno A. K. Magnago INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). ** The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it. If you have received this e-mail in error, please notify [EMAIL PROTECTED] (UK 01384 275454) and delete it immediately from your system. ** ** The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it. If you have received this e-mail in error, please notify [EMAIL PROTECTED] (UK 01384 275454) and delete it immediately from your system. Neither Npower nor any of the other companies in the Innogy group from whom this e-mail originates accept any responsibility for losses or damage as a result of any viruses and it is your responsibility to check attachments (if any) for viruses. Npower Limited Registered office: Windmill Hill Business Park, Whitehill Way, Swindon SN5 6PB. Registered in England and Wales: number 3653277 This e-mail may be sent on behalf of a member of the Innogy group of companies. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Perl
Hi, the issue of database access from python is addressed here : http://www.python.org/topics/database/ http://www.python.org/topics/database/ with specific modules (incliuding Oracle) listed here : http://www.python.org/topics/database/modules.html http://www.python.org/topics/database/modules.html I've only used ODBC from python unfortunately so I'm not well placed to offer a recommendation. Regards, Mike Hately -Original Message- Sent: 29 January 2003 14:04 To: Multiple recipients of list ORACLE-L Okay ... a question from a colleague ... How do you get python to work with Oracle ... for perl there DBD: and DBI: anything similar in Python? My knowledge of Perl is as good as my knowledge of Python ... /dev/null 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- mailto:[EMAIL PROTECTED] ] Sent: Tuesday, January 28, 2003 5:17 PM To: Multiple recipients of list ORACLE-L I tinkered with Perl, but could never really get used to the syntax. I basically gave up (still maintain familiarity since Perl is very common) and started using Python. I've grown to enjoy coding in Python and use it now for all of the system maintenance and monitoring scripts I write as well as for my web programming work. I'm not qualified to compare the two languages, but I will say that Perl's Oracle support is better developed and the CPAN archives are a very useful thing. In my opinion, Python is a better designed language and it is perfectly viable for production-level applications in an Oracle environment. ** The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it. If you have received this e-mail in error, please notify [EMAIL PROTECTED] (UK 01384 275454) and delete it immediately from your system. ** ** The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it. If you have received this e-mail in error, please notify [EMAIL PROTECTED] (UK 01384 275454) and delete it immediately from your system. Neither Npower nor any of the other companies in the Innogy group from whom this e-mail originates accept any responsibility for losses or damage as a result of any viruses and it is your responsibility to check attachments (if any) for viruses. Npower Limited Registered office: Windmill Hill Business Park, Whitehill Way, Swindon SN5 6PB. Registered in England and Wales: number 3653277 This e-mail may be sent on behalf of a member of the Innogy group of companies. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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[2]: undo tablespace
You're correct in saying that your undo blocks are protected by your redo files. What type of operation are you performing on your table? I ask because only a small subset of commands support the NOLOGGING feature; the remainder will generate redo as usual. If you're not using a syntax that supports NOLOGGING maybe you could adapt your job to adopt one. Alternatively you may find that you just need to optimise your redo log placement in order to handle the load. Regards, Mike Hately -Original Message- Sent: 29 January 2003 14:10 To: Multiple recipients of list ORACLE-L Mike, I asked it because I have a problem. Any insert data in UNDO tablespace generate insert in REDO Files. Is is correct ? When I execute a high procedure, many inserts in UNDO tablespace ocurres, so many inserts in REDO´s are genereate. I want to avoid this REDO´s generation. My tables and indexes are in NOLOGGING, but I high value of REDO are generate (100 MB each 20 minutes). It is desnecessary. Oracle 9i / NT -- Breno A. K. Magnago mailto:[EMAIL PROTECTED] Mercantil de Alimentos Soares Wednesday, January 29, 2003, 10:29:15 AM, you wrote: HMNI Breno, HMNI There's no way to do this because it's the central pillar of Oracle's read HMNI consistency mechanism. HMNI It's possible to minimise or suppress redo but undo is out of your control. HMNI regards, HMNI Mike Hately HMNI -Original Message- HMNI Sent: 29 January 2003 11:39 HMNI To: Multiple recipients of list ORACLE-L HMNI I have a high procedure (many INSERT's and UPDATE´s). HMNI This procedure generate insert's in UNDO TableSpace for rollback. HMNI I want to know if exists any way for don´t generate insert´s in UNDO HMNI Tablespace. HMNI Oracle 9i / NT HMNI Thanks. ** The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it. If you have received this e-mail in error, please notify [EMAIL PROTECTED] (UK 01384 275454) and delete it immediately from your system. Neither Npower nor any of the other companies in the Innogy group from whom this e-mail originates accept any responsibility for losses or damage as a result of any viruses and it is your responsibility to check attachments (if any) for viruses. Npower Limited Registered office: Windmill Hill Business Park, Whitehill Way, Swindon SN5 6PB. Registered in England and Wales: number 3653277 This e-mail may be sent on behalf of a member of the Innogy group of companies. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Perl - Was Unix time conversion function
Perl kind of makes sense but I haven't reached the point where it clicks and becomes natural. I still need to think about it very hard when I'm writing it. Hence, a lot of the time I fall back on shell scripts supplemented by pre-written (some would say shamelessly ripped off) perl code for the stuff that would get really messy is ksh. Regards, Mike Hately -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Tuesday, January 28, 2003 1:40 AM To: Multiple recipients of list ORACLE-L Cary I once thought I wanted to do some Perl coding... So I bought a book and started to play with it. It made my head bleed... literally I had little droplets of blood emerging from my head They rushed me to the hospital and put me in the Perl ward where I languished for days on IV's of Mountain Dew and pulverized Ritz crackers. it was close. In my mind there is nothing obvious about Perl, this coming from and old C coder who did pointers and linked lists in his sleep years ago. I don't know, maybe I was having a bad day and it's time to get my learning Perl book out again Anyone else feel that way about Perl or am I a lone wolf in a Perl world? RF ** The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it. If you have received this e-mail in error, please notify [EMAIL PROTECTED] (UK 01384 275454) and delete it immediately from your system. Neither Npower nor any of the other companies in the Innogy group from whom this e-mail originates accept any responsibility for losses or damage as a result of any viruses and it is your responsibility to check attachments (if any) for viruses. Npower Limited Registered office: Windmill Hill Business Park, Whitehill Way, Swindon SN5 6PB. Registered in England and Wales: number 3653277 This e-mail may be sent on behalf of a member of the Innogy group of companies. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: senior oracle dba
Senior isn't an absolute term. A senior DBA in a small development house could be the guy who knows how to add a tablespace. A senior DBA in a large company may have to combine a good level of technical ability with a good deal of management and business skills. The term also seems to be used to imply a high level of experience and/or length of service. I have to admit it does sound better than 'old and cynical'. Regards, Mike Hately -Original Message- Sent: 23 January 2003 13:14 To: Multiple recipients of list ORACLE-L Very good point. I know where I work, HR classifies DBA as an analyst for pay reasons. The Senior DBA position, is more of a management-type role. More money, more management responsibilities but less actual DBA work. -D- -- Dwayne Cox Oracle Database Administrator Info Tech, Inc. 5700 SW 34th Street, Suite 1235 Gainesville, FL 32608 email: [EMAIL PROTECTED] phone: 352.381.4521 fax: 352.381. On Wed, 22 Jan 2003 11:08:07 -0800 DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Bp, Often where the term Senior DBA comes up is with company HR departments. It isn't usual for we DBAs to greet each other with Hi, I'm a senior DBA. I agree with Mark's comments, but just wanted to point out this other aspect to the issue. Sometimes HR people use this as a method for categorizing people in terms of making sense out of salaries. HR criteria may have nothing to do with what you are thinking of. Personally I often can't understand HR criteria. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] ** The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it. If you have received this e-mail in error, please notify [EMAIL PROTECTED] (UK 01384 275454) and delete it immediately from your system. Neither Npower nor any of the other companies in the Innogy group from whom this e-mail originates accept any responsibility for losses or damage as a result of any viruses and it is your responsibility to check attachments (if any) for viruses. Npower Limited Registered office: Windmill Hill Business Park, Whitehill Way, Swindon SN5 6PB. Registered in England and Wales: number 3653277 This e-mail may be sent on behalf of a member of the Innogy group of companies. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: create tablespace problem
Where's the challenge when you have the facts? =) Mike -Original Message- Sent: 22 January 2003 15:05 To: Multiple recipients of list ORACLE-L RANT_CONTINUED Well while we are ranting how about always including the version of the database, and the platform you are running on too! /RANT_CONTINUED RF Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (it's everywhere that I am!) Author of several books you can find on Amazon.com! ** The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it. If you have received this e-mail in error, please notify [EMAIL PROTECTED] (UK 01384 275454) and delete it immediately from your system. Neither Npower nor any of the other companies in the Innogy group from whom this e-mail originates accept any responsibility for losses or damage as a result of any viruses and it is your responsibility to check attachments (if any) for viruses. Npower Limited Registered office: Windmill Hill Business Park, Whitehill Way, Swindon SN5 6PB. Registered in England and Wales: number 3653277 This e-mail may be sent on behalf of a member of the Innogy group of companies. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: filemon
Oh well that's tomorrow taken care of. I'll have a lot of fun with that and the related utilities on that site. Thanks for the info, Mike -Original Message- Sent: 21 January 2003 17:09 To: Multiple recipients of list ORACLE-L This may be a useful utility for those of you working with Oracle and NT. Found it while trying to diagnose issues on an AIX box which also has a program called filemon. http://www.sysinternals.com/ntw2k/source/filemon.shtml http://www.sysinternals.com/ntw2k/source/filemon.shtml ** The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it. If you have received this e-mail in error, please notify [EMAIL PROTECTED] (UK 01384 275454) and delete it immediately from your system. Neither Npower nor any of the other companies in the Innogy group from whom this e-mail originates accept any responsibility for losses or damage as a result of any viruses and it is your responsibility to check attachments (if any) for viruses. Npower Limited Registered office: Windmill Hill Business Park, Whitehill Way, Swindon SN5 6PB. Registered in England and Wales: number 3653277 This e-mail may be sent on behalf of a member of the Innogy group of companies. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: 9iAS if you want list
Ron, there's not much choice in what you install in 9iAS. You pretty much select a pre-defined type of install. If you choose an option that includes Portal you should be fine. regards, Mike Hately -Original Message- Sent: 15 January 2003 20:35 To: Multiple recipients of list ORACLE-L List, i have access to a server that has 1 GIG memory and I will be loading Linux on as the OS. I would like to load 9iAS and allow the developers the ability to start learning to use Portal to create a browser based database access method. Is there a list that will cross reference from If you want to do this you need to install this option when you install Oracle 9iAS? I feel that the more you install that you do NOT need the more you complicate everything. I have searched the Oracle site and read the majority of the docs that i could find but I still am not clear what has to be installed on the 9iAS and database to accomplish what I would like. Thanks, Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Limits
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.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: =?iso-8859-1?Q?Fl=E1vio_Reis?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: bitmapped indexes
It's from a paper called Bitmap Indexing in Oracle7.3 and 8.0 which is available at http://www.newagetraining.com/library/ora_dev/sql_plsql/script/BitmapIndexes .pdf http://www.newagetraining.com/library/ora_dev/sql_plsql/script/BitmapIndexe s.pdf The theory is true in relation to data loads rather than OLTP operations. This quote from Tech Note 70067.1 outlines a benefit of bitmap indexes : - Very efficient parallel DML and loads: Bitmap indexes benefit data warehousing applications but they are not appropriate for OLTP applications with a heavy load of concurrent INSERTs, UPDATEs, and DELETEs. In a data warehousing environment, data is usually maintained by way of bulk inserts and updates. Index maintenance is deferred until the end of each DML operation. For example, if you insert 1000 rows, the inserted rows are placed into a sort buffer and then the updates of all 1000 index entries are batched. (This is why SORT_AREA_SIZE must be set properly for good performance with inserts and updates on bitmap indexes.) Thus, each bitmap segment is updated only once per DML operation, even if more than one row in that segment changes. Regards, Mike Hately -Original Message- Sent: 14 January 2003 12:54 To: Multiple recipients of list ORACLE-L It was filtered by Listguru ... where did you get it from? Maybe we can pick it up at the source ... 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- mailto:[EMAIL PROTECTED] ] Sent: Tuesday, January 14, 2003 5:49 AM To: Multiple recipients of list ORACLE-L Hi ! I don't remember where I got the paper, but I am attaching it. Cheers. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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_TABLESPACES has more rows than DBA_TABLESPACES
Keith, yes, it's regular behaviour that the TS$ entry remains but the discrepancy between those 2 views is a bug which is fixed in 8.0.6. Basically, DBA_TABLESPACES excludes 'INVALID' tablespaces but USER_TABLESPACES doesn't. There are duplicates for the bug. The numbers are 284887, 553723 and 546913. regards, Mike Hately -Original Message- Sent: 14 January 2003 15:34 To: Multiple recipients of list ORACLE-L I'm still confused. They are not in DBA_TABLESPACES, only USER_TABLESPACES. Keith - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Sent: Monday, January 13, 2003 1:34 PM Keith Moore wrote: Has anyone else seen this or can you explain it? I have 7 tablespaces in USER_TABLESPACES that don't exist in DBA_TABLESPACES. These have been dropped, but somehow did not disappear from USER_TABLESPACES. They have a status of INVALID. The database is version 8.0.5 (Yeah, I know, we'll be going to 9i real soon now) Keith Regular behaviour. Rows are never deleted from sys.ts$ (on which DBA_TABLESPACES is based). -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] mailto:[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.net -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Some of you may find this useful
Ron, that's a bit of a puzzle because it should have been available since 7.3.2. Which user are you using to query it? Also, anyone, I know what x$kglrd does but anyone have any idea what the RD in the table name means? Read? Row? Data? Dependency? I'm open to suggestions. Regards, Mike Hately -Original Message- Sent: 10 January 2003 15:50 To: Multiple recipients of list ORACLE-L Stephane, My creativity has been stumulated, simulated, and mutated. What version of Oracle are you using? x$kglrd ...table or view does no exist on 8.1.7 rel 3 Ron [EMAIL PROTECTED] 01/10/03 05:03AM break on proc column QUERY format A40 word_wrapped select substr(KGLNAOWN || '.' || KGLNACNM, 1, 35) proc, KGLNADNM QUERY from x$kglrd where KGLNAOWN != 'SYS' order by 1, kgldepno / If it doesn't stimulate your creativity I can do nothing for you :-). Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Unix for oracle dba -- Suggest a book ?
If you want to understand how Oracle uses Unix get a copy of James Morle's Scaling Oracle. It's not a beginner's Unix book but it's accurate and detailed. regards, Mike Hately -Original Message- Sent: 06 January 2003 15:59 To: Multiple recipients of list ORACLE-L Doesn't anyone read the manuals any more?! Oracle9i Installation Guide - Unix http://download-east.oracle.com/docs/html/A96167_01/toc.htm Oracle9i Administrator's Reference - Unix http://download-east.oracle.com/docs/html/A97297_01/toc.htm James Damiano [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .nh.us cc: Sent by: Subject: Re: Unix for oracle dba -- Suggest a book ? [EMAIL PROTECTED] 01/06/03 06:28 AM Please respond to ORACLE-L I've found a wonderful resource in the following book: Oracle DBA on Unix and Linux by Michael Wessler http://www.samspublishing.com It covers some of the differences in features between 8i and 9i as well as handling the specifics of administrating Oracle specifically on Unix platforms. Highly recommended (at least by me). Jim Damiano Guys, i know a bit of Linux.and not completely a newbie to Unix. Can u suggest me a good/best book for Unix ? ..Unix for oracle DBA. i.e,tuning unix for good performance of oracle. any such book available ? kindly let me know guys. TIA. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James Damiano INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: log file sync Wait
Yes, the lessons I took from that presentation were to use a shorter piece of string and buy larger bottles of gin though I'm willing to admit that I may have got the wrong end of the stick. =) Cheers, Mike -Original Message- Sent: 02 January 2003 09:24 To: Multiple recipients of list ORACLE-L First of all I'd like to have the full picture of your performance: Log file sync might be 57% of the wait time, but how much of the response time is wait time? Second, Log File Sync means Commit; So if your system is waiting a lot for commits there are two things you can do: Fewer commits (changes to applications) or faster commits (hardware striping, etc.). No changes to the log buffer will help here (except perhaps making it smaller, as Connor McDonald so brilliantly showed during the funniest presentation I've ever seen in my life at UKOUG in Birmingham). If the log buffer is being flushed constantly, it's better to make it small so that it doesn't have to go through the whole thing every time. Mogens VIVEK_SHARMA wrote: What ALL may be Done to Address the Following ? Any /etc/system , init.ora parameter Changes too ? Moving the Online Redo Logfiles onto RAID 1 NOT possible as that may warrant Additional Hardware . Moreover T3+ does NOT Support RAID 1 (Only RAID 1+ ) Concurrent Oracle processes = 1500 Approx. Statspack Taken during Mostly OLTP Operations :- Top 5 Wait Events ~ Wait % Total Event Waits Time (cs) Wt Time --- log file sync 970,5632,597,831 57.46 log file parallel write 831,141 484,948 10.73 log_buffer = 2MB Online Redo Logfiles Exist on RAID 1+ Storage Box is T3+ File System = UFS Application = Banking (Hybrid ) Oracle 8.1.7.4 Solaris 8 Machine Box = SF6800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: log file sync Wait
I was sensible enough to sit in the front row so I was soon distracted. Cheers Mike -Original Message- Sent: 02 January 2003 12:29 To: Multiple recipients of list ORACLE-L Obviously you weren't listening attentively enough. The main thing you should have gleaned from the presentation was that if you bash an ugly squirrel with a hammer hard enough, then ... its still an ugly squirrel :-) Cheers Connor --- Hately, Mike (NESL-IT) [EMAIL PROTECTED] wrote: Yes, the lessons I took from that presentation were to use a shorter piece of string and buy larger bottles of gin though I'm willing to admit that I may have got the wrong end of the stick. =) Cheers, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: RMAN and cron
Ron
try altering test.sh to read
. /alphaprd/profile [ notice the extra space ]
That should set the environment in your current shell which isn't happenijng
at the moment.
Regards,
Mike Hately
Oracle DBA
-Original Message-
Sent: 23 December 2002 14:24
To: Multiple recipients of list ORACLE-L
list,
Cron server os RedHat 7.2
Database server os OpenVMS 7.3-1
Database Oracle 8.1.7 rel 3
Rman server os OpenVMS 7.3-1
Rman Oracle 8.1.7 rel 3
On the Cron server I have created a script that will backup the
database server and catalog the action on the rman server. When I try to
have cron perform the backup sctipt I get
RMAN-571 and LEM-00031, and LEM-00033 error message. According to
Metalink it is an environmental error that the oracle variables are not
set. I have set up my environment as follows:
file: /alphaprd/profile
ORACLE_HOME = cron server ORACLE_HOME
ORACLE_BASE =cron server ORACLE_BASE
LD_LIBRARY_PATH = cron server LD_LIBRARY_PATH
TNS_ADMIN = cron server TNS_ADMIN
export ORACLE_HOME ORACLE_BASE LD_LIBRARY_PATH TNS_ADMIN
Script to backup the database controlfile: test.sh
./alphaprd/profile
echo start backup: /alphaprd/rman_test.log
/home/oracle/OraHome1/bin/rman EOF /alphaprd/rman_test.log
connect target sys/password@database server
connect catalog rman/rman@rman server
run {
allocate channel di type disk;
backup format
'orabck:[backups]control_%U.bus'
(current controlfile);
}
EOF
Crontab entry as ROOT:
10 01 * * 1 su oracle -c /alphaprd/test.sh -u
OR
Crontab entry as ORACLE
10 01 * * 1 /alphaprd/test.sh
The script functions properly if I run it from the command line as
oracle but fails with
RMAN-571 and LEM-00031 and LEM-00033 errors when run from cron.
I don't see how it could be Oracle environmentals when I am running it
as an Oracle cron and the target and catalog are on a different server
that the cron server.
Can you point me in the direction where I can get this resovled?
Thanks,
Ron
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ron Rogers
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
--
Author: Hately, Mike (NESL-IT)
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Happy Holidays
But what you can start doing is painting, plastering, levelling concrete and laying floors. 2 months in and the race is on to finish for Christmas. When all of that's done I can start looking for my wife's Christmas present. Hell, maybe I'll tell her that IS her present. All the best for the holidays folks, Mike -Original Message- Sent: 19 December 2002 21:17 To: Multiple recipients of list ORACLE-L you're a man. Genetically you can't start shopping until at LEAST 6 PM on Christmas Eve. --- Orr, Steve [EMAIL PROTECTED] wrote: Merry Christmas and/or Holly Happy-days to all. Man... I haven't even started my Christmas shopping yet. Sigh... Steve Orr, Still needing snow for a white Christmas (and skiing) in Montana... -Original Message- Sent: Thursday, December 19, 2002 1:31 PM To: Multiple recipients of list ORACLE-L Kevin, Thanks to you (and also to Lisa) for offering to share your scripts. Every little bit helps. Cherie Machler - close to leaving for vacation Oracle DBA Gelco Information Network -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Footprint of 9i
I couldn't even get 9iAS R2 running on it's own with 500M. Of course it installs its own database so that doesn't help. My sympathies. Mike -Original Message- Sent: 19 December 2002 16:50 To: Multiple recipients of list ORACLE-L My issue is with memory requirements... try running iAS 9i R2 on 700M of RAM, with a local db. Ugh! Pat. -Original Message- Sent: Thursday, December 19, 2002 12:25 PM To: Multiple recipients of list ORACLE-L Oracle 9.2.0.1 on NT: Demo files 80MB. Starter databases - 300MB Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 19, 2002 5:09 PM -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bob Metelsky Sent: Thursday, December 19, 2002 13:49 To: Multiple recipients of list ORACLE-L Subject: Footprint of 9i All I'm about to consider rolling out 9i here and I'm wondering what type of footprint most people are seeing. In other words how large of an install is a database administrators (enterprise edition)? I've installed 9i at home on WINNT server, Win XP Pro and Suse Linux 8 all were about 2G. I also noticed that even if I tried to remove some components I did not think I needed that the installation size/footprint was not really affected Also a worthwhile note is that my current (enterprise edition) install of 8 17 on win2k server is about 1G This issue is we all run the same size drives here and really cant afford to loose 2G 1G maybe So is it true that overall installing the Enterprise edition of 9i that one could not expect to be much below 2G?? If not, we may have to add a drive for the dba's which is not going to go over big. thanks Bob Bob, No surprises, you're not alone. The easiest 400MB to 500MB to remove are the templates and demo files for the starter instances and schemas. Try deleting %ORACLE_HOME%\assistants\dbca\templates\* to free up 300MB (these are the 'OLTP' and 'Data warehouse' templates used by the dbassist tool - if you don't use them for creating instances, get rid of them), and %ORACLE_HOME%\demo\schema\* to free up 100MB of the scripts used to create the sample schemas - again if you don't use them. There might be more that can be removed ... doco and the like ... but that's a start. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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
RE: Function-based Index
Cherie Oracle doesn't allow you to use aggregate functions in function-based indexes but that's fine as you should be OK if you just specify a standard b*tree index with the columns you mentioned. Regards, Mike Hately -Original Message- Sent: 11 December 2002 21:09 To: Multiple recipients of list ORACLE-L I have the following statement that I would like to create a function-based index for: SELECT MIN(tran_dt) FROM ach_tran WHERE cnfr_no = :b1 I'd like the index to include columns cnfr_no and tran_dt (in that order). The examples I've seen are just single-column indexes. Is it possible to have this additional column in a function-based index that is not involved in the actual function? If yes, what would the index creation statement look like? This is version 9.2.0.1 on Sun Solaris 2.6. Thanks in advance for any assistance. Cherie Machler Gelco DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.0.1 and 9.2
Stefan, The move to 9.2 from 9.0.1 requires a migration rather than a simple update. Whether you want to go through that is your choice really. If I had the disk to burn I'd go for the fresh install but then I like to have a version of everything available. Regards, Mike Hately -Original Message- Sent: 05 December 2002 08:29 To: Multiple recipients of list ORACLE-L Hi everybody I've got 9.0.1 and 8.1.7 running on one laptop (to test stuff). Now I want to upgrade the 9.0.1 to 9.2. Does it make sense to just install the 9.2 to a new Oracle home or would it be better to get rid of 9.0.1 and do a fresh install of 9.2 ? Can 9.2 generally be seen as a minor update like 8.1.5 - 8.1.6 or more like 8.0.5 to 8.1.x, which would be a different major version ? Regards, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.0.1 and 9.2
Hi Kevin, In the 9i R2 Migration Guide (p 321), Step 10 of the upgrade process specifies that you should open the database using STARTUP MIGRATE. This option sets the status of the database to 'OPEN MIGRATE' in V$INSTANCE. That makes it a migration. Hence the discussion we had a few months ago along the lines of Yes, 9i Release 1 was really only 8.2 and this is the real 9i Did you use the Database Upgrade Assistant? That may explain why you didn't see the migrate step. I think my phrasing implied that migrating to release 2 was far harder than upgrading to a new version. Thanks to improvements in the process this is no longer the case. Regards, Mike Hately -Original Message- Sent: 05 December 2002 12:34 To: Multiple recipients of list ORACLE-L The move to 9.2 from 9.0.1 requires a migration rather than a simple update. Can you explain this? I've upgraded multiple databases (Solaris) from 9.0.1 to 9.2.0 by doing a simple upgrade. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Import Table from Full Backup
Hi, you can recover a tablespace to a point in time. That's the only option you would have using RMAN. Regards, Mike Hately -Original Message- Sent: 04 December 2002 11:54 To: Multiple recipients of list ORACLE-L I think that SQLBackTrack from Precise can restore a table from a backup. Of course you will need to backup with it, not Rman. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, November 30, 2002 12:39 AM Hi Listers, Is it true that I can do an import of a table from a full backup that was done with RMAN? That was a comment I heard today and doesn't make sense to me, any comments? Saludos, Veronica Levin Enriquez Compañía Cervecera de Nicaragua -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Veronica Levin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Import Table from Full Backup
I'd agree that you can achieve the same result. I think I'd argue that it's not a feature of RMAN though. I can also take that restored table, spool it a text file and edit it using MS Word but I wouldn't claim that RMAN can generate Word files. Mind you, this is probably word class pedantry on my part =) Cheers, Mike -Original Message- Sent: 04 December 2002 13:34 To: Multiple recipients of list ORACLE-L In order to use rman to restore a single table you have to restore the tablespace to a clone and then export the table you need and import it to the 'real' database. So yes, it can be done! Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, November 30, 2002 12:39 AM Hi Listers, Is it true that I can do an import of a table from a full backup that was done with RMAN? That was a comment I heard today and doesn't make sense to me, any comments? Saludos, Veronica Levin Enriquez Compañía Cervecera de Nicaragua -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: UKOUG Meet.
Mark, yes, I'll be there and Monday night is fine. I don't know the area at all so can't suggest venues but I'm not choosy regarding food so anywhere should do for me. Cheers, Mike -Original Message- Sent: 03 December 2002 09:59 To: Multiple recipients of list ORACLE-L Hi All, I remember that a number of people were all for getting together on the Monday night at the UKOUG. I *don't* remember us actually arranging a place/time.. ;) Is there any chance of another show of hands so that we can see if we'll need to book a table or not. And has *anybody* had any thoughts on a place at all? See you all soon! Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Apps 11i on Red Hat 8.0
Dale, I installed 11.5.5 on Suse 7.0 and it went absolutely fine. I went with that O/S because I'd heard it was the most trouble free combination. I believe that the 11.5.7 release is 11.5.5 plus extra CDs containg the 11.5.6 and 11.5.7 maintenance packs. I ran it as a single tier install and everything went just like it says on the box. This was in 500MB RAM / 800MB swap and (roughly) 45 GB of disk. A colleague installed it on RedHat 7.1 and it's working. I'm not sure how much tweaking it required to get there. Regards, Mike Hately [EMAIL PROTECTED] 12/02/02 21:16 PM Anyone care to share any experiences installing Apps 11i release 7 on RH 8.0? I'm about to give it a go in the next couple of days - and would appreciate hearing about your experiences. I note that SUSE 7.1 seems to be the only officially certified distro. H. Oracle Trivia Question: If you order the Oracle Apps 11i Release 7 suite from Oracle how many CD's do you get? Answer: 54 (yes thats right, fifty four CD's) - the mind boggles. No wonder they don't let you download the thing :-) Regards Dale Edgar Net 2000 Ltd. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 9i installation - Basic Qs
Agreed Jared. I was playing the percentages for the sake of a quick, clear answer. In my experience most of the time it's going to be root. Cheers, Mike -Original Message- Sent: 26 November 2002 17:44 To: Multiple recipients of list ORACLE-L Mike, Not necessarily. It depends on who started the Xsession. I regularly run 'xhost' on my workstation as a non-root user. Root is unable to do so on the same machine. Jared Hately, Mike (NESL-IT) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/26/2002 07:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle 9i installation - Basic Qs Hi, you'll need to be signed in as root in order to run the xhost + command. The rest of that looks fine so : as root : xhost + as oracle_user : export DISPLAY=PC Client IP address:0.0 xclock(to test yopur X config) NB Exceed has its own array of bugs when used with the Oracle installer. Good luck and I hope the 9i instaler handles Exceed better. regards, Mike Hately -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 9i installation - Basic Qs
Hi, you'll need to be signed in as root in order to run the xhost + command. The rest of that looks fine so : as root : xhost + as oracle_user : export DISPLAY=PC Client IP address:0.0 xclock(to test yopur X config) NB Exceed has its own array of bugs when used with the Oracle installer. Good luck and I hope the 9i instaler handles Exceed better. regards, Mike Hately -Original Message- Sent: 26 November 2002 14:39 To: Multiple recipients of list ORACLE-L Oracle 9i installation on Solaris being attempted # xhost + Message - unable to open display : export DISPLAY=PC Client IP address:0.0 # xhost + Xlib : connection to client refused PC Client IP Address Xlib : cannot set display to PC Client IP Address NOTE - Installation being initiated from a laptop using Exceed Hummingbird software to simulate Xwindows Console Any Solutions ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: find the system process for an oracle session
Ruth, select vp.spid from v$process vp, v$session vs where vp.addr=vs.paddr and vs.sid=1 regards, Mike Hately -Original Message- Sent: 22 November 2002 14:54 To: Multiple recipients of list ORACLE-L Good morning, Can anyone send my the sql to find the system process being used by an oracle session. I know this has been out here before, but I can't find it in my saved stuff. Thanks in advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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-L at UKOUG
That suits me. Mark, I'd like to say how much I enjoyed reading the phrase plenty of booze to go around. Mike -Original Message- Sent: 21 November 2002 15:34 To: Multiple recipients of list ORACLE-L Monday night sounds great. -Original Message- Sent: Wednesday, November 20, 2002 10:08 AM To: Multiple recipients of list ORACLE-L The best time is most probably Monday evening. There is always a gala evening on the Tuesday night that a lot of people attend (and speakers always get free tickets for this as well so..). Monday night, there is always the reception with plenty of booze to go around - so going for a beer and some food after this sounds like a natural progression :) Wednesday everyone just wants to leave after being hung over all day from the previous gala evening.. lol.. -Original Message- Sent: 20 November 2002 16:19 To: Multiple recipients of list ORACLE-L I will be arriving on Sunday and am open to a get together that evening. For those who have attended previously, what are good times? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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-L at UKOUG
I'll be attending and it would be nice to put faces to some of the names on this list. Mike -Original Message- Sent: 20 November 2002 07:28 To: Multiple recipients of list ORACLE-L I will be at UKOUG and so will be another of other people of the Oaktable network. Anjo. -Original Message- Sent: Tuesday, November 19, 2002 9:19 PM To: Multiple recipients of list ORACLE-L Anyone interested in an Oracle-L get together at UKOUG for those of us poor souls who were not able to attend Oracle World? OW attendees welcome also! Dan Fink -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: [Q] ORACLE 9i fast_start_mttr_target and log_checkpoint_inte
Heh, naw it was an early morning pre-coffee reply. So probably nothing to write home about =) Mike -Original Message- Sorry Mike. I was going from memory. I'm sure your reply was better than mine, not hard to do. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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-L at UKOUG
Connor, I see you're presenting this year. I'll try to catch those sessions. Assuming that you know the format of the event better than I do (not difficult) have you any suggestions for good meeting places/times? Mike -Original Message- Sent: 20 November 2002 11:19 To: Multiple recipients of list ORACLE-L I'm in - when you consider the wealth of nightlife in Birmingham (yeah right!) then I'm sure we can find somewhere to go :-) --- Mark Leith [EMAIL PROTECTED] wrote: I'm interested! It IS always nice to put names to faces.. Any ideas for when/where? Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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-L at UKOUG
It'd be good to grab something to eat and wind down after the 'rigours' of the day. Needn't be anything flash as I'll probably be in more dire need of a beer than anything else. Mike -Original Message- Sent: 20 November 2002 12:19 To: Multiple recipients of list ORACLE-L I would suggest anywhere along Broad Street (opposite the front of the ICC), or anywhere in Brindly Place (across the canal at the back of the ICC). There are numerous bars/cafes/restaurants around the Broad Street area.. I suppose the question is - do we want to have a meal, or just get together for a beer? M. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: [Q] ORACLE 9i fast_start_mttr_target and log_checkpoint_inte
://www.orafaq.com -- Author: dist cash INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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 offic! ! ial ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat Ci! ! ty Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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! Web Hosting - Let the expert host your site -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services! ! - 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! http://rd.yahoo.com/hosting/mailsig/*http://webhosting.yahoo.com Web Hosting - Let the expert host your site -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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-L at UKOUG
I'm driving down on Monday morning. Should be OK because the traffic system round Brum is fairly quiet and easy to navigate during rush hour isn't it? =) Mike -Original Message- Sent: 20 November 2002 16:19 To: Multiple recipients of list ORACLE-L I will be arriving on Sunday and am open to a get together that evening. For those who have attended previously, what are good times? -Original Message- Sent: Wednesday, November 20, 2002 8:50 AM To: Multiple recipients of list ORACLE-L IIRC (and it's been at least 3 years), there was a restaurant/pub on the island near the conference center that was nice. Large, decent food and excellent beer of course, if you just want the sugar/caffeine rush, you can always go visit the Cadbury factory --- Connor McDonald [EMAIL PROTECTED] wrote: I'm in - when you consider the wealth of nightlife in Birmingham (yeah right!) then I'm sure we can find somewhere to go :-) --- Mark Leith [EMAIL PROTECTED] wrote: I'm interested! It IS always nice to put names to faces.. Any ideas for when/where? Mark -Original Message- Mike (NESL-IT) Sent: 20 November 2002 09:13 To: Multiple recipients of list ORACLE-L I'll be attending and it would be nice to put faces to some of the names on this list. Mike -Original Message- Sent: 20 November 2002 07:28 To: Multiple recipients of list ORACLE-L I will be at UKOUG and so will be another of other people of the Oaktable network. Anjo. -Original Message- Sent: Tuesday, November 19, 2002 9:19 PM To: Multiple recipients of list ORACLE-L Anyone interested in an Oracle-L get together at UKOUG for those of us poor souls who were not able to attend Oracle World? OW attendees welcome also! Dan Fink -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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! Web Hosting - Let the expert host your site http://webhosting.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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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
RE: [Q] ORACLE 9i fast_start_mttr_target and log_checkpoint_inte
Dist - Since nobody seems to have responded I take offence at that =) Obviously not everyone got my reply. Or I'm on you spam list Dennis. Cheers, Mike -Original Message- Sent: 19 November 2002 13:59 To: Multiple recipients of list ORACLE-L log_checkpoint_inte Dist - Since nobody seems to have responded, I'll take a crack at it. The Oracle9i documentation specifically says (in the Oracle9i Database Reference) that either FAST_START_IO_TARGET or LOG_CHECKPOINT_INTERVAL will override FAST_START_MTTR_TARGET. I would tend to believe them. In the Oracle9i Performance Tuning Guide, Oracle contains a note that you should disable or remove the FAST_START_IO_TARGET, LOG_CHECKPOINT_INTERVAL, and LOG_CHECKPOINT_TIMEOUT parameters when using FAST_START_MTTR_TARGET. Setting these parameters interferes with FAST_START_MTTR_TARGET. I don't see where LOG_CHECKPOINTS_TO_ALERT would cause a problem, but if you are suspicious, you might check metalink. As I understand it, the big advantage of FAST_START_MTTR_TARGET is its ease and accuracy. Your management provides a goal for how long your Oracle database can take to recover in the situation where it crashes. You simply convert that number to seconds and set FAST_START_MTTR_TARGET. With the LOG_CHECKPOINT parameters, the settings are derived more indirectly. Of course, there is no free lunch. Setting a shorter recovery time may interfere with performance. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 18, 2002 11:04 AM To: Multiple recipients of list ORACLE-L log_checkpoint_interval parameter? I saw a document mention if log_checkpoint_interval define on ORACLE 9i, the fast_start_mttr_target parameter will be ignore. My question is: 1. we have following on init.ora file: log_checkpoint_interval = 1 log_checkpoint_timeout = 1800 log_checkpoints_to_alert = true fast_start_mttr_target=300 Do I need remove all the log_checkpoint* on init.ora file? 2. what kind of benefit that fast_start_mttr_target better than log_checkpoint* ? Thanks _ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dist cash INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 10i features
9iAS R2 is a terrible install. A complicated process further confused by poor instructions. Mike -Original Message- Sent: Wednesday, November 13, 2002 7:33 PM To: Multiple recipients of list ORACLE-L No, installing 9iAS is a 250 mph breeze. One definition of a tornado is a very strong breeze. -Original Message- Sent: Wednesday, November 13, 2002 8:03 AM To: Multiple recipients of list ORACLE-L Only if they make installing 9iAs a breeze ... I have heard stories that 9iAS installation is not a picnic ... Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Space management failures on autoextend datafiles
, California-- Mailing list and web hosting services - 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: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Space management failures on autoextend datafiles
Hi Ron, you're quite right and I'm pointing out that this functionality (auto-extension of a file to accomodate a tempoary segment) works fine for me. That suggests that (bugs aside) temporary segments are quite capable of forcing a datafile to extend. The thrust of your earlier mail seemed to be that this was a deliberate design choice on the part of Oracle rather than a bug. Apologies if I misundestood your intention. Regards, Mike -Original Message- Sent: Friday, November 08, 2002 3:59 PM To: Multiple recipients of list ORACLE-L Mike, In the previous discussion on this thread the problem was that the autoextent would not work for a temp segment created during the index creation and the problem was solved by extending the tablespace to handle the temp segments. Ron [EMAIL PROTECTED] 11/08/02 09:18AM Ron, I don't believe all of that to be true. In your example idx2 should be created and the tablespace should extend. Otherwise what would be the point of having AUTOEXTEND on any tablespace which held only indexes? I agree that Oracle will use a temporary segment to hold the index data until it is fully created but Oracle will extend the datafile regardless. In fact, when I tested this at 8.1.7.3 and 9.2 even an index rebuild extended the datfile in order to accomodate the new index. regards, Mike Hately -Original Message- Sent: Friday, November 08, 2002 12:39 PM To: Multiple recipients of list ORACLE-L Let's think about this for a minute. You create and index called idx1 using a designated tablespace that has sufficient space to hold the complete index. You create a new index idx2 on the table using the same tablespace and you think that it should autoextend to hold the permanent index. The system generates the index and starts placing the temporary index named something like 123.123 in the tablespace. This index is a temporary index until the system has completed creating the entire index. Then it will make the index name permanent as idx2 and use the space accordingly with the required extents and autoextend. Oracle does not know that the index will complete, be aborted, crash, etc so it can not make any permanent assignment to the extents( that is why it is called temporary) . Oracle would permanently extent tablespaces for each temporary function then the database could artificially expand when the functions were only temporary in nature and the compounded effect could cause a ripple effect. The backup size would expand, search functions could take longer because of the increased size, disk space would be wasted. Just a few thoughts and ideas. Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: SPIN_COUNT - 8i obsolete? What now?
Eva, the spin_count parameter became _spin_count in 8i. I believe that because it's a hidden parameter it's now not possible to change it using ALTER SYSTEM. Regards, Mike Hately -Original Message- Sent: Thursday, November 07, 2002 11:33 AM To: Multiple recipients of list ORACLE-L Hello Guru's I have run a script which indicates that of the three redo log latches two had occurences of sleeps. To overcome this usually you increase SPIN_COUNT by 50% or so. When trying to ALTER SYSTEM SET SPIN_COUNT = 3000; Present system is set as 2000. I get the following error. * ERROR at line 1: ORA-25138: SPIN_COUNT initialization parameter has been made obsolete Now what? what can I do to overcome the sleeps issues? Regards Denham Eva Oracle DBA UNIX is basically a simple operating system, but you have to be a genius to understand the simplicity. Dennis Ritchie. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: SPIN_COUNT - 8i obsolete? What now?
Eva, just to correct myself from my earlier post it's entirely possible to set _spin_count using ALTER SYSTEM. It may be a sensible measure to try if you're having serious contention issues. Steve Adams has some 'spin_count' scripts that you might find useful at http://www.ixora.com.au/scripts/latches.htm http://www.ixora.com.au/scripts/latches.htm Regards, Mike Hately -Original Message- Sent: Thursday, November 07, 2002 1:29 PM To: Multiple recipients of list ORACLE-L Already running on 100% caffeine_level saturation :) Maybe your right, the contention could be elsewhere, the other issue I have been investigating is LGWR process? With increasing the LOG_BUFFER from 512 to a Meg in size, as I have at times very high redo log switch, however they average about 3-4 an hour? Anyway the idea is to keep investigating. Regards Denham -Original Message- mailto:sfaroult;oriole.com ] Sent: Thursday, November 07, 2002 1:59 PM To: Multiple recipients of list ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Space management failures on autoextend datafiles
Dan, is your datafile approaching (or past) the maxsize setting? AUTOEXTEND functionality won't grow a file beyond this but I believe it's possible to manuallly resize the file beyond the MAXSIZE figure. That would explain the apparent anomaly. regards, Mike Hately -Original Message- Sent: Thursday, November 07, 2002 3:39 PM To: Multiple recipients of list ORACLE-L I have a 9.2 database running on Solaris 8. I'm creating some test tables with indexes. The USER_INDX tablespace's datafile is set to autoextend (as are TEMP and USER_DATA). When the system attempts to create indexes, instead of auotextending the datafile (there is plenty of space on the device), it throws an ORA-01652: unable to extend temp segment by 128 in tablespace USER_INDX error. If I manually resize the datafile and rerun it, no problems. Anyone else heard of this behavior? I can't find anything on Metalink that fits the problem definition. Dan Fink -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
