RE: Strange behavior with dbms_stats...
Um...the PL/SQL script at the bottom of your e-mail doesn't
DO anything other than output a line. Do you use this
in a subsequent command file?
Cheers,
Mike
-Original Message-
Sent: Thursday, December 11, 2003 8:09 AM
To: Multiple recipients of list ORACLE-L
List...
SunOS 5.8, Oracle 8.1.6 (and 8.1.7 too).
I use the proc at the bottom to generate statistics.
It seems to work, but if I check statistics with:
select owner, table_name, num_rows, blocks,
av_row_len,
to_char(last_analyzed, 'MM/DD/ HH24:MI:SS')
from dba_tables;
the tables have the OLD last_analyzed time!
but... If I execute ONE by ONE:
exec dbms_stats.gather_schema_stats(ownname =>
'PERFSTAT', cascade => TRUE);
it works fine!!...
So, am I doing something wrong?
Any help?
TIA
JL
create or replace procedure get_statistics as
cursor get_users_list is
select username
from dba_users
where username != 'SYS'
and username != 'SYSTEM';
begin
for i in get_users_list
loop
dbms_output.put_line('exec
dbms_stats.gather_schema_stats(ownname =>
'||chr(39)||i.username||chr(39)||', cascade =>
TRUE);');
end loop;
end;
/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vergara, Michael (TEM)
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: Who Wrote ...
Thank You. -Original Message- Sent: Wednesday, November 26, 2003 4:24 PM To: Multiple recipients of list ORACLE-L Kevin Loney. And you can find the same information in the first version of the DBA Handbook --- "Vergara, Michael (TEM)" <[EMAIL PROTECTED]> wrote: > I remember seeing a paper delivered at an IOUG wa back, that > spoke > of the 22-disk solution. I know it's old and outdated, but I'd like > to > find a copy. Does anyone remember who wrote and presented this > paper? > > Thanks, and Happy Thanksgiving! > Mike > > --- > === > Michael P. Vergara > Oracle DBA > Guidant Corporation > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Vergara, Michael (TEM) > 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!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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: UNSUB ORACLE-L (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: Vergara, Michael (TEM) 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).
OT: Who Wrote ...
I remember seeing a paper delivered at an IOUG wa back, that spoke of the 22-disk solution. I know it's old and outdated, but I'd like to find a copy. Does anyone remember who wrote and presented this paper? Thanks, and Happy Thanksgiving! Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) 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 send messages to other users
If your users are part of your local network, you can use the Windoze "NET SEND" command. I have recently found that to be useful. UNIX/Linux utilities like 'wall' only send a message to users who are telnet'ed or rlogin'ed to the system. To send a message to a browser is not something I know how to do. However, if it can be done by pop-up windows from folks like X-10, I'm sure it can be done for a useful purpose as well. You need to talk to a web programmer for that, though, not Oracle DBAs. Cheers, Mike -Original Message- Sent: Tuesday, November 25, 2003 5:49 PM To: Multiple recipients of list ORACLE-L hi, I need to send messages like 'system shutting down in 1 min' to all users currently login. How can i do this in oracle or a third party software that i can use? users are connected using web browser. Messages are send over the wan. thanks. -- 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: Vergara, Michael (TEM) 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: Query temp segments blank
Well, you could try... select view_name from all_views where view_name like '%TEMP%'; ..and see what you get. I have lots of views that give me information about the TEMP tablespace. YMMV, but it's a place to start. Cheers, Mike -Original Message- Sent: Wednesday, November 26, 2003 6:00 AM To: Multiple recipients of list ORACLE-L It appears one database I can not query the temp tablespace. It's local, unform extents, but nothing shows up in dba_segments or any where I have found thus far. Has this progressed to a "trust me" type of situation? Even TOAD gives me nothing but blanks on objects in TEMP yet on other databases will show me a "temp" segment. Database is: Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production Platform is HP: HP-UX xx016xxx B.11.11 U 9000/800 86714596 unlimited-user license -- 13308 Thornridge Ct Midlothian, VA 23112 804-744-1545 -- 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: Vergara, Michael (TEM) 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: Changing character set
There's a whole spread of stuff on MetalLink about changing character sets. There is even a utility program called 'csscan' that scans the DB to find potential trouble spots. In short, though, if this DB only has 7-bit ASCII characters in in, then a switch to UTF-8 will have no immediate effect. Cheers, Mike -Original Message- Sent: Wednesday, November 19, 2003 12:35 PM To: Multiple recipients of list ORACLE-L Anyone change character sets recently? I've got a cust that wants to take a small database from US7ASCII to UTF8 I believe it was. It sounds like they have all the steps down pat and are pretty much ready to go, but are there any "gotchas" they may have missed? Will this affect the RMAN backups they get nightly? I've told them to do a cold file backup first, then try on test, and if all is cool they can proceed... 20 years working with Oracle and this is a first time for me. Web interface on this note, so I hope it comes out okay... -- 13308 Thornridge Ct Midlothian, VA 23112 804-744-1545 -- 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: Vergara, Michael (TEM) 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: How do you genrate primary keys?
t used a separate > >sequence for each automatically generated primary key. I > >worked on another app, a smaller one, that used the same > >sequence for more than one table. The only issue that I > >recall is that sometimes numbers would be skipped. But end > >users really didn't care, or even notice. > > > >* The SYS_GUID approach. I've never used SYS_GUID as a > >primary key generator. I wonder, was that Oracle's > >motivation for creating the function? Has anyone used it for > >primary keys in a production app? What's the real reason > >Oracle created this function? > > > >* Similar to SYS_GUID, I once worked on an obituary-tracking > >application that built up a primary key from, as best I can > >recall now: date of death, part of surname, part of first > >name, and a sequence number used only to resolve collisions, > >of which there were few. The approached worked well, > >actually, because whatever fields we munged together to > >generate a primary key gave us a unique key the vast > >majority of the time. > > > >The SYS_GUID approach is interesting, but if you need an ID > >number that users will see, and that users might type in > >themselves (e.g. social security number), is SYS_GUID really > >all that viable? > > > >Best regards, > > > >Jonathan Gennick --- Brighten the corner where you are > >http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] > > > >Join the Oracle-article list and receive one > >article on Oracle technologies per month by > >email. To join, visit > >http://four.pairlist.net/mailman/listinfo/oracle-article, > >or send email to [EMAIL PROTECTED] and > >include the word "subscribe" in either the subject or body. > > > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.net > >-- > >Author: Jonathan Gennick > > 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). > > Hemant K Chitale > Oracle 9i Database Administrator Certified Professional > My personal web site is : http://hkchital.tripod.com > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Hemant K Chitale > 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: Cary Millsap > 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: <[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 sen
RE: UNIX OT: deleting file starting with --
We just had one like this. Our UNIX SA said to use the fully-qualified path to the file, as in rm -i /this/is/the/path/to/--cart HTH, Mike -Original Message- Sent: Thursday, October 30, 2003 8:44 PM To: Multiple recipients of list ORACLE-L Hi, How do I delete a file named --cart ? Thanks, Ross -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ross Collado 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: Vergara, Michael (TEM) 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: DBA Support Database
We recently signed a corporate agreement with Oracle that basically gave us a named-user license for every person in the company. Now, we have databases sprouting like rabbits. Our four-dba team now is supporting SAP, two different Siebels, a data warehouse, and myriad other projects - over 200 databases so far. I have recently been tasked with a similar project, so I am also very interested in knowing if this has been done before. In-house, purchased, anything? Thanks, Mike -Original Message- Sent: Thursday, October 30, 2003 8:09 AM To: Multiple recipients of list ORACLE-L Ron: I have heard of this being done especially in large companies that have many, many databases. It is difficult to keep track of all the little details that are spread out all over the company. Having a central data mart for this information I thing would be very helpful. The only problem I see is keeping it up to date. Ken Janusz, CPIM - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, October 30, 2003 9:29 AM > I was thinking about putting together a database that contains a list of > DBAs, servers, databases, and applications. The database would be used > by the Helpdesk and Management to see who is responsible for a given > application or database when problems occur. > > I thought I would check first and see if anyone has already designed > such a database and might be willing to share it. > > Thanks! > Ron Smith > -- > 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). -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) 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: Do not connect Oracle DB to the Internet. Oracle Alert #59
Tony: I did not receive the attachment clearly. Can you re-send it or cite the source? Thanks, Mike -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Thursday, October 23, 2003 6:25 AMTo: Multiple recipients of list ORACLE-LSubject: Do not connect Oracle DB to the Internet. Oracle Alert #59Important: Please read the following Oracle Alert.We strongly recommend that you do not connect the Oracle Databasedirectly to the Internet.Got your attention? That is what is in the Alert. These alerts are beginning to come all too often. Sounds just like Microsoft's software, yeah?Buffer Overflow in Oracle Database Server BinariesThis is with the Oracle kernel/binary itself ie 'oracle' or 'oracleO' filein $ORACLE_HOME/bin.DescriptionA potential buffer overflow has been discovered in the "oracle" and "oracleO" (the letter O) binariesof the Oracle Database. A knowledgeable and malicious local user can exploit this buffer overflowto execute code on the operating system hosting the Oracle Database server.Products Affected· Oracle 9i Database Release 2, Version 9.2.x· Oracle 9i Database Release 1, Version 9.0.xPlatforms AffectedAll supported UNIX and Linux operating system variants.Patch only available for Linux right now. So who found out this vulnerability? David Litchfield? Aaron Newman?I know it is a bit silly to ask but does anyone know how to exploit this vulnerability? Send it to me directly if you dont want to reply publiclytatony
RE: Tools to Execute Stored Procedures in Debug Mode !
I have used SQL-Programmer for several years. It was developed by Sylvain-Faust, but they were bought out by BMC. It used to be reasonably priced, but now BMC wants a ton of gold for it. Good tool, but now overpriced. We have also evaluated the "SQL Navigator", Quest Software's PL/SQL development tool, but I much preferred SQL-Programmer. HTH, Mike -Original Message- Sent: Monday, October 13, 2003 10:19 AM To: Multiple recipients of list ORACLE-L Hi List, I am looking for a tool to debug the sql procedures. I tried with TOAD, but at times this is not working.. Any suggestions on any other tools would be great help.. Shreekanth -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rama, Shreekantha (K.) 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: Vergara, Michael (TEM) 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).
HP-UX 11i/Oracle 9.2.0.4/(Semi)Intelligent Agent
Hi List: I have a server with multiple network interfaces. When this server does an IP address lookup, the address returned is the private backbone between the database and application servers. The IA starts, and is listening on this address. I am trying to query the agent from the public network interface and it's failing. Here's an example: This is the private network interface: gpdb20:oraprd> tnsping "(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.179.20)(PORT=1748))" TNS Ping Utility for HPUX: Version 9.2.0.4.0 - Production on 13-OCT-2003 11:39:20 Copyright (c) 1997 Oracle Corporation. All rights reserved. Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.179.20)(PORT=1748)) OK (720 msec) gpdb20:oraprd> This is the public network interface gpdb20:oraprd> tnsping "(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.173.20)(PORT=1748))" TNS Ping Utility for HPUX: Version 9.2.0.4.0 - Production on 13-OCT-2003 11:39:42 Copyright (c) 1997 Oracle Corporation. All rights reserved. Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.173.20)(PORT=1748)) TNS-12541: TNS:no listener gpdb20:oraprd> How can I tell the Agent to listen on the 173 address? The Oracle database listener works just fine, but the (not no) intelligent agent does not. Any suggestions? Cheers, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) 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: Strange Request
Works like a champ, and didn't bring down the DB. Thanks, Mike -Original Message- Sent: Wednesday, October 08, 2003 1:25 AM To: Multiple recipients of list ORACLE-L How about... declare ora600 exception; pragma exception_init(ora600, -600); begin raise ora600; end; / show errors; HTH -- David Lord > -Original Message- > From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED] > Sent: 08 October 2003 02:14 > To: Multiple recipients of list ORACLE-L > Subject: Strange Request > > > Ok...strange request time. I want to test a script that I found > on the DBA Village web site. It's supposed to capture some > information whenever there's a DB error. > > Does anybody know how to trigger a 'benign' ORA-600 so I can test > this functionality? > > Thanks, > Mike > > > --- > == > = > Michael P. Vergara > Oracle DBA > Guidant Corporation > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Vergara, Michael (TEM) > 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). > *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** This e-mail and its attachments are intended for the author's addressee only and may be confidential. If they have come to you in error you must take no action based on them, nor must you copy or show them to anyone; please reply to this e-mail and highlight the error. Please note that this e-mail has been created in the knowledge that Internet e-mail is not a 100% secure communications medium. We advise that you understand and observe this lack of security when e-mailing us. Steps have been taken to ensure this e-mail and attachments are free from any virus, but advise the recipient to ensure they are actually virus free. The views, opinions and judgments expressed in this message are solely those of the author. The message contents have not been reviewed or approved by Iron Mountain. *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lord David 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: Vergara, Michael (TEM) 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: Strange Request
I want the DB to see and act on an ORA-00600, not just record one in the alertSID.log Thanks, Mike -Original Message- Sent: Tuesday, October 07, 2003 6:54 PM To: Multiple recipients of list ORACLE-L did you just want to see it in an alert.log? or are you working with a dump? joe Vergara, Michael (TEM) wrote: >Ok...strange request time. I want to test a script that I found >on the DBA Village web site. It's supposed to capture some >information whenever there's a DB error. > >Does anybody know how to trigger a 'benign' ORA-600 so I can test >this functionality? > >Thanks, >Mike > > >--- >=== >Michael P. Vergara >Oracle DBA >Guidant Corporation > > > -- Joseph S Testa Chief Technology Officer Data Management Consulting 614-791-9000 It's all about the "CACHE" -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa 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: Vergara, Michael (TEM) 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).
Strange Request
Ok...strange request time. I want to test a script that I found on the DBA Village web site. It's supposed to capture some information whenever there's a DB error. Does anybody know how to trigger a 'benign' ORA-600 so I can test this functionality? Thanks, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) 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).
Oracle analog to xp_fixeddrives
Hi Everyone! I recently read an article about a SQL-Server stored procedure called 'xp_fixeddrives'. What it does is return a structure to the database user that contains relevant information about specific disks. I was wondering if anyone has ever seen, dreamed about, written, borrowed, bought or stolen a utility like this for Oracle. I know it's easier for SQL-Server because it's only gotta work on one platform, where Oracle is much broader, but I could sure imagine some usefulness around that sort of thing. Curious, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) 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: Unintentional Humor
Hey...I don't have a "tnsping0"! Heck, I don't have "agtctl0" or any of the other "*0" programs! How do I install them? Where is the hidden $ORACLE_HOME/bin? If my management finds out that I bungled the install of 9i I could be in deep doo-doo. ...or not... -Original Message-From: Stephane Paquette [mailto:[EMAIL PROTECTED]Sent: Monday, October 06, 2003 12:19 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Unintentional Humor You mean the hidden $ORACLE_HOME/bin directory Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Daniel FinkSent: Monday, October 06, 2003 3:04 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Unintentional HumorI see what you mean. Too funny! Hmm...I guess I've been wrong all these years. And all that time I wasted reading the official documentation on such "undocumented" and "hidden" programs like export/import, sql*loader, tkprof... [EMAIL PROTECTED] wrote: OK, well I thought it was funny. Doing a google search on some Oracle stuff, I found the following page. http://www.dba-oracle.com/bp/bp_book6_utils.htm Scroll down a bit? Do you see the funny part? Jared
HP-UX 11/9iR2/dbv
Hi All! This is a question for the script gurus out there. I am running an SAP system. Recently, during a DR test, we found several files with corruption. These were found originally with an ORA-600 [12700], and confirmed with dbv. So now they want me to run dbv's on the database files during the maintenance window. Now, I can create a script that will scan all the files, but it's linear and will take for-flipping-ever. So, has anyone out there created a script (csh, ksh, sh, perl, whatever) that can take a parameter list of files, and keep several child processes running at a time? What I want to do is create a list of all database files. This list would be input to a script that would keep 'n' child processes running (running 'dbv') until the list was exhausted. Say that 'n' was six. This process would keep 6 dbv's running. When one child dbv process finished, the next in line would be started. Anybody done something like this, or am I just an ambitious dreamer? Thanks, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) 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: archive old data
Nancy: It's the standard answer: "It Depends". We are running SAP, and SAP has it's own flavor of archiving, and each transaction type has it's own archiving rules. Archived data is stored in special files that SAP can read, so that even though the data is no longer in the Oracle database, it is available through the application. Our Data Warehouse uses a rolling 90-day window on some data, and a 2-year window on some others. Data that falls outside the window is deleted. You have several options. You can create export files, you can dump the data to SQL 'insert' statements, or you can delete it outright. "It depends" on your application and your users. Cheers, Mike -Original Message- Sent: Friday, September 12, 2003 9:50 AM To: Multiple recipients of list ORACLE-L We have some tables that have data for many years. We are going to archive the data that are older than 3 years. I would like to find out how you guys usually do this or a best way to do this. Thanks for any inputs in advance. Nancy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) 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 ?
Re: > PS Personally I think that the discontinuation of paper manuals was a > disaster. I used to take concepts manuals when I went in the bath. A great > place to learn. No kids, no TV. Absolutely! I still have several of my old v6 and v7 manuals just because of the little schnibbles of information I have scribbled in the margins. Much has changed, but not everything. Just my 2¢ worth... Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) 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).
HTML Report Question
Hi DBAs! I am trying to generate an HTML report, and send it through the mail in HTML format. Only one problem...Outlook thinks it's text not html, even though the first line of the report is "". I'm generating the report with... sqlplus -silent -markup "HTML ON" ...and then using mailx to send the output to my client mailbox. Any suggestions as to how I can make the mail come in as HTML? Thanks, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) 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 keep "root" out?
Well, first of all, root should not be in your dba group... -Original Message-From: Walter K [mailto:[EMAIL PROTECTED]Sent: Thursday, August 28, 2003 8:34 AMTo: Multiple recipients of list ORACLE-LSubject: How to keep "root" out? Just for grins, I'll ask this question... Is there any way to keep the Unix "root" user from logging into the database (i.e. connect internal or / as sysdba)? Currently using 8.1.7.4 on Solaris 8 here. We have a couple people in our Unix admin group that feel the need to "help" by writing their own DB monitoring scripts. Of course, they don't know what they're talking about. They do not have formal logins for the database, but since they are root users they are connecting via "connect internal". This is not only counterproductive but actually a potential security issue--just because someone has root doesn't necessarily entitle them to see the data in the database. What if it is a payroll database? So, I'm curious, is there any way to prevent access via "connect internal" or "/ as sysdba"? Thanks in advance. W
HP-UX 11/9iR2/Processes
Hi Everyone: I've noticed a new type of background process in my 9iR2 databases. It's name is ora_j00n_. Does anyone know what this process is? Any links to Docs? Thanks, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) 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: Urgent! Is it safe to apply patch Windows2000-KB823980?
Luis: We're patching like crazy, too. So far, none of our systems has experienced any issues. We're running mostly 8 and 8i, with a couple 9i machines in there too, on NT4 and Win2k. Cheers, Mike -Original Message- Sent: Tuesday, August 19, 2003 10:39 AM To: Multiple recipients of list ORACLE-L Has anybody applied Windows2000-KB823980-x86-ENU on their boxes hosting the Database? We are running 9i 9.0.1.1.1 on an Windows 2000 advanced server and our network group is patching all the systems. Is there anything that I need to watch for? We are also runing 9iAS ver 1.0.2.2.0 on Windows 200 advanced server, anything to be aware here? Any information is very welcomed. TIA Luis Octavio de Urioste -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) 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).
Multiple DBs - Balancing Act
This question is for folks who are part of a team that manages multiple databases and multiple platforms. How do you balance the load among your team? We're struggling with this concept right now as we're about to add another DBA to the group. We've considered such things as quantity (how many DBs does each DBA handle), importance (to the company - each DBA has 'n' databases, load (this DB is used 'n' times as much as another one, experience (of the DBA...do we put a UNIX-familiar person in charge of DBs on Windows?) and on and on. But then we stumble on quantifying the terms - importance, load, etc. And we have had some DBs that we considered 'small' become a major PITA when we weren't looking! We just signed a deal making Oracle our DB of choice for the next several years, so we could see an explosion of stuff. So I'm asking...how do you do it? Thanks, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) 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: dba age
...and young enough to go ahead and do it anyway! Woooh! -Original Message- Sent: Wednesday, July 23, 2003 9:30 AM To: Multiple recipients of list ORACLE-L simple answer: old enough to know better :) --- "Goulet, Dick" <[EMAIL PROTECTED]> wrote: > Now that's a LOADED question which I'm sure many a individual on this > list will resist answering. > > > Dick Goulet > Senior Oracle DBA > Oracle Certified 8i DBA > > -Original Message- > Sent: Wednesday, July 23, 2003 11:55 AM > To: Multiple recipients of list ORACLE-L > > > Now this one is difficult folks .. > > what is average age of an experienced oracle dba ? > > -ak > > __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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: UNSUB ORACLE-L (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: Vergara, Michael (TEM) 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: HP-UX 11i/9.2.0.3/Strange Executions
Ok you guys... Here's the latest on the 'real' subject of this thread. You know what an explain plan looks like, right? On our production DB, it looked like SELECT STATEMENT CHOOSE SORT GROUP BY TABLE ACCESS BY INDEX ROWID INDEX RANGE SCAN Ok...so far so what, right? Well, on our stage server, it looked like this... 32 SELECT STATEMENT CHOOSE 31 SORT GROUP BY 30 CONCATENATION 3 INLIST ITERATOR 2 TABLE ACCESS BY INDEX ROWID 1 INDEX RANGE SCAN 5 TABLE ACCESS BY INDEX ROWID 4 INDEX RANGE SCAN 7 TABLE ACCESS BY INDEX ROWID 6 INDEX RANGE SCAN 9 TABLE ACCESS BY INDEX ROWID 8 INDEX RANGE SCAN ... 29 TABLE ACCESS BY INDEX ROWID 28 INDEX RANGE SCAN In each case of Table Access...Index Range Scan, the WHERE clauses were the same. I had never seen anything like this. Have you? And these plans are for the same SQL. However...this was an artifact, not the problem. We found the problem. It was an Oracle Patch. Yep. If you have Oracle 9.2.0.3, take my advice and DO NOT INSTALL MERGE FIX 2871468. I accidentally missed installing this patch on the STG server, and the report in question worked there. In PRD, there was no joy. When I applied the patch to STG, it failed there, and worked again when the patch was removed. (There's a vote for 'opatch'!). So...my problem is resolved, the problem was an Oracle patch. Thanks to all for your help and suggestions. Cheers, Mike -Original Message- Sent: Tuesday, July 22, 2003 12:54 PM To: Multiple recipients of list ORACLE-L Color may be irrelevant, depending on amount. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) 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: HP-UX 11i/9.2.0.3/Strange Executions
Ron: According to the ABAP programmers, the code 'variant' is identical. The generated SQL 'looks' the same, but the execution plans are radically different. Thanks, Mike -Original Message- Sent: Monday, July 21, 2003 2:44 PM To: Multiple recipients of list ORACLE-L Is or are ALL of the SAP form identical on both servers? It could be the SAP is different on the servers and be the cause of the problem. Ron >>> [EMAIL PROTECTED] 07/21/03 05:34PM >>> He needs to contact oracle support, because the dump came from the oracle server process. If he's lucky, the one-off patch is already published and he only needs to download it from Metalink and apply it. If not, then he has to wait for oracle 9BF (BF = Bug Free) Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Monday, July 21, 2003 5:20 PM To: Multiple recipients of list ORACLE-L SIGSEGV = Segment Violation = invalid address = bad code Sounds like you need to contact SAP and/or Oracle support. Jared "Vergara, Michael (TEM)" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 07/21/2003 02:04 PM Please respond to ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) 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: HP-UX 11i/9.2.0.3/Strange Executions
Oh no! I have to wait for 9iBF? I'll be retired by then, and I'm only ... well ... never mind how old I am. I don't wanna wait that long. Cheers, Mike -Original Message- Sent: Monday, July 21, 2003 2:35 PM To: Multiple recipients of list ORACLE-L He needs to contact oracle support, because the dump came from the oracle server process. If he's lucky, the one-off patch is already published and he only needs to download it from Metalink and apply it. If not, then he has to wait for oracle 9BF (BF = Bug Free) Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Monday, July 21, 2003 5:20 PM To: Multiple recipients of list ORACLE-L SIGSEGV = Segment Violation = invalid address = bad code Sounds like you need to contact SAP and/or Oracle support. Jared "Vergara, Michael (TEM)" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 07/21/2003 02:04 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:HP-UX 11i/9.2.0.3/Strange Executions Hi Everyone! HELP! I upgraded my SAP *PRODUCTION* instance to 9.2.0.3 over the weekend. Everything up until now has been OK. However, I now have some SAP Transactions (read: data entry forms) that are abending unexpectedly. What's strange is that when we run the transaction on our Stage server the explain plan is different, and the query succeeds. In PRD, the query is a single-step, and in stage it gets broken out into sub-queries and executed there. I created a report of all the database parameters. There is no difference that cannot be explained by the difference in CPUs, database name, or application paths. They are fundamentally identical. But the query aborts on PRD. I am attaching the top few lines of a typical trace file. ANY help, RTFM references, suggestions, incantations, incense, or holy water will be appreciated. Thanks, Mike *** 2003-07-21 14:52:06.921 *** SESSION ID:(326.5957) 2003-07-21 14:52:06.886 Exception signal: 11 (SIGSEGV), code: 0 (unknown code), addr: 0x80016ede9f30, PC: [0x41331c0c, kghfrmrg()+596] Registers: r1: 8001d9e8 r22: 6e6178d8 sr4: 7df0c00 rp:0 arg3: 80016ede9f28 sr0: 67c9c00 r3: 413319b8 arg2: c0006e615fa0 sr1: d7db000 r4:0 arg1: 6e615fa0 sr2: 0 r5:0 arg0: c0b38f001131 sr3: 0 r6: 7ffcdp: 8001000ca608 sr5: 693 r7:0 ret0:0 sr6: a814c00 r8: 8001007d3798 ret1: 800 sr7: 67c9c00 r9: 8001007d3780sp: 83ffbfff6880 cr0: 0 r10:0 r31:6 cr8: 77f6368 r11:0 sar: 38 cr9: 77f6378 r12:0 pcoqh: 41331c0f ccr: 0 r13:1 pcsqh: 693 cr12: 494c008 r14: 83ffbfff48c0 pcoqt: 41331a93 cr13: 4a2b008 r15: 83ffbfff48c8 pcsqt: 693 cr24: 4a2c808 r16: 403f85d0 eiem: cr25: 4a2a808 r17: af0 iir: 72f50010 cr26: 4a2c808 r18:0 isr: a814c00 mpsfu_hi: 8001000e36c8 r19: 8001d9e8 ior: 80016ede9f30 mpsfu_lo: 0 r20:0 ipsw: ff080cff1f mpsfu_ov: 41 r21: 8001007d2650 goto:97f68 pad: 0 *** 2003-07-21 14:52:07.811 ksedmp: internal or fatal error ORA-07445: exception encountered: core dump [kghfrmrg()+596] [SIGSEGV] [unknown code] [0x80016EDE9F30] [] [] Current SQL statement for this session: SELECT T_00 . "MATNR" , T_00 . "PRDHA" , T_01 . "MAKTX" FROM "MARA" T_00 , "MAKT" T_01 WHERE ( T_01 . "MANDT" = :A0 AND T_01 . "MATNR" = T_00 . "MA TNR" ) AND T_00 . "MANDT" = :A1 AND ( ( T_00 . "MATNR" BETWEEN :A2 AND :A3 OR T_00 . "MATNR" BETWEEN :A4 AND :A5 OR T_00 . "MATNR" BETWEEN :A6 AND :A7 OR T_00 . "MATNR" BETWEEN :A8 AND :A9 OR T_00 . "MATNR" BETWEEN :A10 AND :A11 OR T_00 . "MATNR" BETWEEN :A12 AND :A13 OR T_00 . "MATNR" BETWEEN :A14 AND :A15 OR T_00 . "MATNR" BETWEEN :A16 AND :A17 OR T_00 . "MATNR" BETWEEN :A18 AND :A19 ) OR T_00 . "MATNR" IN ( :A20 , :A21 , :A22 , :A23 , :A24 , :A25 , :A26 , :A27 , :A28 , :A29 , :A30 , :A31 , :A32 , :A33 , :A34 , :A35 , :A36 , :A37 , :A38 , :A39 , :A40 , :A41 , :A42 , :A43 , :A44 , :A45 , :A46 , :A47 , :A48 , :A49 , :A50 , :A51 , :A52 , :A53 , :A54 , :A55 , :A56 , :A57 , :A58 , :A59 , :A60 , :A61 , :A62 , :A63 , :A64 , :A65 , :A
RE: HP-UX 11i/9.2.0.3/Strange Executions
Title: RE: HP-UX 11i/9.2.0.3/Strange Executions Raj: Is OWS 'Oracle Worldwide Support'? Our Oracle support comes directly from SAP, and they're on the case, but are as flummoxed as I am. Right now they're trying to convince me that the problem is in the NLS parameters. However, these values are identical on both machines, and the report *works* on Stage. Thanks, Mike -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Monday, July 21, 2003 2:25 PMTo: Multiple recipients of list ORACLE-LSubject: RE: HP-UX 11i/9.2.0.3/Strange Executions Most likely some thing to do with OS library. contact OWS. 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----- From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]] Sent: Monday, July 21, 2003 5:05 PM To: Multiple recipients of list ORACLE-L Subject: HP-UX 11i/9.2.0.3/Strange Executions
RE: HP-UX 11i/9.2.0.3/Strange Executions
Jared: I am in contact with SAP support, but they're scratching their collective heads, too. I was hoping that maybe a SAP-savvy lister would be able to say "We had that...here's the fix". What's strange is that the report runs to completion on our Stage server. Thanks, Mike -Original Message- Sent: Monday, July 21, 2003 1:21 PM To: [EMAIL PROTECTED] Cc: Vergara, Michael (TEM) Importance: High SIGSEGV = Segment Violation = invalid address = bad code Sounds like you need to contact SAP and/or Oracle support. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) 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).
HP-UX 11i/9.2.0.3/Strange Executions
, :A188 , :A189 , :A190 , :A191 , :A192 , :A193 , :A194 , :A195 , :A196 , :A197 , :A198 , :A199 , :A200 , :A201 , :A202 , :A203 , :A204 , :A205 , :A206 , :A207 , :A208 , :A209 , :A210 , :A211 , :A212 , :A213 , :A214 , :A215 , :A216 , : A217 , :A218 , :A219 , :A220 , :A221 , :A222 , :A223 , :A224 , :A225 , :A226 , :A227 , :A228 , :A229 , :A230 , :A231 , :A232 , :A233 , :A234 , :A23 5 , :A236 , :A237 , :A238 , :A239 , :A240 , :A241 , :A242 , :A243 , :A244 , :A245 , :A246 , :A247 , :A248 , :A249 , :A250 , :A251 , :A252 , :A253 , :A254 , :A255 , :A256 , :A257 , :A258 , :A259 , :A260 , :A261 ) ) AND T_01 . "SPRAS" = :A262 - Call Stack Trace - --- =========== Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) 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-600 errors for X_$KCBCBH & x_$kcbrbh
Roy: This is a cut-and-paste from the Oracle TAR. HTH, Mike *** For the x_$ view not able to recompile successfully: - issue the following query and note the object_id: SQL> select object_id, object_name from dba_objects where object_name='X$' and owner='SYS'; - issue SQL> delete from dependency$ where d_obj# in (); - drop the view using the DROP command - flush the shared pool - bounce the instance with shutdown abort, startup, shutdown immediate and startup. In a test, use the X_$KCBCBH view and apply this process. Report back results before proceeding with other views. Thanks, ~ Stefan. *** -Original Message- Sent: Thursday, July 17, 2003 6:59 PM To: Vergara, Michael (TEM) Hi, I have this problem and would be interested in seeing the solution from the tar. Thank you for your help. Roy Armstrong [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) 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 & SQL Backtrack
Title: Message Ron: I don't know SQL Backtrack, but two things popped into my head as I read your message. One, RMAN does not have a media interface layer. It depends on a utility such as Legato (also currently included with Oracle) or Netbackup or OmniBack. Two, EMC just bought Legato. This tool may not be included in future releases. Cheers, Mike -Original Message-From: Smith, Ron L. [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 16, 2003 7:59 AMTo: Multiple recipients of list ORACLE-LSubject: RMAN & SQL Backtrack We have been using SQL Backtrack for backup and recovery for about 6 years now. We are being pressured to start using RMAN because it is free. Makes sense but I am wondering about reliability, complexity, learning curve, etc... Has anyone had experience with both products or anyone new to RMAN that can give me an idea of what to expect? Thanks!
RE: Register vs. Load of JDBC driver
Mladen: I can't help you with your question, but FatCity also supports a list called the ODTUG-JAVA-L list. Those folks might be able to help. HTH, Mike -Original Message- Sent: Thursday, June 26, 2003 12:35 PM To: Multiple recipients of list ORACLE-L Hi List! I'm not a Java programer so please, forgive me my (blissful) ignorance. My developers are experiencing wild differences when connecting using driverManager.registerDriver vs. Class.forName (dynamic loading). Does anybody have any clue why is that? Any articles about registering vs. loading? Thanks! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) 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).
WARNING: Re: [suse-oracle] AIO trouble
FYI - When this message came in to me it had the PE_BUGBEAR.B virus. Mike -Original Message- Sent: Thursday, June 05, 2003 11:07 AM To: undisclosed-recipients Michael Hasenstein wrote: > Which SuSE Linux? SLES 8 > > > Which kernel (run "rpm -q k_smp")? k_smp-2.4.19-195 > > > What hardware? 2 Processor Xeon 2GHz 2 Gb RAM a this time cat /proc/cpuinfo processor : 0 vendor_id : GenuineIntel cpu family : 15 model : 2 model -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) 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: Schedule Analyze using DBMS_STATS ???
I would like to scedule the process of analyzing tables/indexes using DBMS_STATS ? Hope someone of u would have a script for the same. can u share with me please ?! BTW,Which is advisable : ANALYZE or DBMS_STATS ? there was a discussion about the same on the list also. but not found any conclusion yet. anu suggestions !!! the ENV is oracle 9.2.0.1/Win2K. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) 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).
OT: Peoplesoft buys JDEdwards
And in today's news... > http://biz.yahoo.com/rb/030602/tech_jdedwards_peoplesoft_6.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) 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: dbshut script - shutdown or shutdown immediate
Peter: One of the first things we do after installing Oracle is to modify dbshut to 'shutdown immediate'. We have had no side-effects from this change. Cheers, Mike -Original Message- Sent: Wednesday, April 02, 2003 7:04 AM To: Multiple recipients of list ORACLE-L I have one Oracle instance which supports an application server which always maintains a database connection. The UNIX system administrator tells me that this instance always hangs when she tries to shut down the system. The other instances, which do not support a 24x7 process shut down properly. Looking at $ORACLE_HOME/bin/dbshut, I notice that the input to sqlplus is connect internal shutdown Should I modify the script to "shutdown immediate" so that it kills any connections? Environment is Oracle 8.1.7 /AIX 4.3.3. Thanks, Peter Schauss Northrop Grumman Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) 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: Database character set for Webshpere access
Title: Database character set for Webshpere access Melissa: I've done US7ASCII to WE8ISO8859 with no trouble. I think that since the UTF character set is a superset of ASCII there should be no problems, but I'd try it on a sandbox first. Cheers, Mike -Original Message-From: Godlewski, Melissa [mailto:[EMAIL PROTECTED]Sent: Tuesday, April 01, 2003 5:49 PMTo: Multiple recipients of list ORACLE-LSubject: Database character set for Webshpere access list, I've searched the faq list and metalink. It appears the database character set for java etc should be al32utf8 and nls_character set of al16utf16 for a 9i R2 database. Has anyone altered a database from US7ASCII to al32utf8 and al16utf16? Any problems?
RE: Solaris/8.1.7/LOBSEGMENT
Title: RE: Solaris/8.1.7/LOBSEGMENT Thanks! I found a note on MetaLink, and got your message at about the same time. I figured it out, and applied the change. Cheers, Mike -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]Sent: Monday, March 31, 2003 10:25 AMTo: '[EMAIL PROTECTED]'Cc: Vergara, Michael (TEM)Subject: RE: Solaris/8.1.7/LOBSEGMENT > -Original Message- > From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]] > > I'm getting a report that a LOBSEGMENT has reached MAXEXTENTS. > How do I modify this? ALTER LOBSEGMENT doesn't work. I'm still > R'ing the FMs, but I thought I'd ask the list too. alter table owner.table_name modify lob (lob_name) (storage (maxextents N)) ;
RE: alert log file
When I see a humungous file like that, I build a little
ksh
script that hasn't failed me yet.
suffix=`date +%y%m%d`
cp -p alertSID.log alertSID_${suffix}.log
> alertSID.log
The only thing that might happen is if Oracle is updating
the
log file at EXACTLY the moment you execute this script then
that
log line may be lost. As I said, it hasn't happened - yet -
that
I know of - but YMMV.
Cheers,
Mike
-Original Message-From: AK
[mailto:[EMAIL PROTECTED]Sent: Monday, March 31, 2003 7:54
AMTo: Multiple recipients of list ORACLE-LSubject: alert
log file
for one of the db over here alert log
is biggg .Looks like its never been truncated or backup .
Is it a problem if i just move this alert log
file to another directory , will oracle create a new alert log file
?
Do I need to bounce db ?
btw its 8.1.6 ( hp-ux )
-ak
Solaris/8.1.7/LOBSEGMENT
Hi all! I'm getting a report that a LOBSEGMENT has reached MAXEXTENTS. How do I modify this? ALTER LOBSEGMENT doesn't work. I'm still R'ing the FMs, but I thought I'd ask the list too. Thanks, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) 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: HP-UX 11i/8.1.7.4/login.sql
That I can do... -- variable sqlpmpt varchar2(30); set termout off pause off verify off declare username varchar2(30); instname varchar2(30); begin begin select substr(global_name, 1, instr(global_name||'.', '.')-1) into instname from global_name; exception when OTHERS then instname := 'UNK'; end; begin select user into username from dual; exception when OTHERS then username := 'SQL'; end; :sqlpmpt := instname||'-'||username||'> '; exception when OTHERS then :sqlpmpt := 'SQL> '; end; / select :sqlpmpt sqlp from dual; set sqlprompt '&sqlp_var' column sqlp clear undefine sqlp_var undefine sqlpmpt define _editor=vi set trimspoolon set pagesize 24 set tab off set serveroutput on set termout on -Original Message- Sent: Tuesday, March 25, 2003 10:35 AM To: Multiple recipients of list ORACLE-L Perhaps you could send the contents of your LOGIN.SQL -Original Message- Sent: Tuesday, March 25, 2003 12:29 PM To: Multiple recipients of list ORACLE-L Greetings Everyone! I have a LOGIN.SQL script that I've customized to fit my preferences. However, when I use SQLPLUS /NOLOG, it fails miserably since there is no connection to the database. Is there a way - other than undefining ORACLE_PATH - that the LOGIN.SQL script can be skipped or ignored when using the /NOLOG parameter? Thanks, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) 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).
HP-UX 11i/8.1.7.4/login.sql
Greetings Everyone! I have a LOGIN.SQL script that I've customized to fit my preferences. However, when I use SQLPLUS /NOLOG, it fails miserably since there is no connection to the database. Is there a way - other than undefining ORACLE_PATH - that the LOGIN.SQL script can be skipped or ignored when using the /NOLOG parameter? Thanks, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) 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: Borderline OT - Unix for Oracle at home
Dan: I am running RedHat 7.3 on a Gateway G6-266 in my home LAN. It connects to the web just fine, and my intent is to make it a lightweight web and DB server. I am running Oracle 9iR2. It's slow, but it runs. Cheers, Mike -Original Message-From: Fink, Dan [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 30, 2003 7:14 AMTo: Multiple recipients of list ORACLE-LSubject: Borderline OT - Unix for Oracle at home I am looking to add a unix box to my collection of wintel machines at home. It will be used solely for running/testing Oracle, so I don't need bells & whistles. My thoughts are either Linux/intel or Sun Ultra workstation. While it would be convenient to be able to network it into a DSL configuration, it is not essential. My original thought was a Linux desktop, but I can also get Ultra 5 or 10 workstations on ebay for less than $500. Anyone having experience good/bad/ugly for this type of task? All tips, challenges, things to consider are greatly appreciated. Dan Fink
RE: Oracle, Siebel and rule-based optimization
Michael: Would you please post a summary of findings here on the list? I too have a Siebel implementation going on, and we are experiencing performance issues, and have set all the Siebel-specified initSID.ora parameters. I am in California, and the database is 'across the pond' in Europe, so I am doing this remotely, and about 8 hours out of phase with my users. Any knowledge transfer will be appreciated. Thanks Mike -Original Message-From: Michael Fontana [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 30, 2003 7:41 AMTo: Multiple recipients of list ORACLE-LSubject: Oracle, Siebel and rule-based optimizationI would like to ask a question of this esteemed and knowledgeable audience about runningSIEBEL applications on Oracle. Siebel insists that their CRM application will only run withacceptable performance if rule-based optimization is chosen, yet, as we all know, there aredocumented examples of poor performance, and strong recommendations to the contrary from Oracle.At one point, I recall reading an article from a knowledgeable consultant describing what must be doneto get Siebel to run with optimizer_mode=choose. Any assistance in reaching this goal, or comments, would be more than appreciated. We're still in the implementation phase, and are already receiving poor performance on certain processes, even using the recommended rule based optimization. I predict it will only get worse!
HP-UX 11i/8.1.7/DB Link Question
Hi Everyone! I have been tasked with finding out how often connections are made between databases using DB links. Does anyone know of a tracking or auditing tool, or perhaps a audit methodology, that would provide this information? Thanks, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) 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: AUTORAID and VA7100 disk arrays for rp7400
I'm not sure what a VA7100 is, so I don't want to tell you to avoid it. The AutoRaid I used just said "AutoRaid" on the front. It had 12 disks...I think they were 9G or 18G each. It had only 96M of cache, not expandable. Only 2 SCSI channels - not expandable. What happened was that our whole database was on this array. Yes, even on-line and archived redo logs. The array did so much internal thrashing that the disk response times were abysmal. The boss got it cause he didn't want to pay the extra $$$ for a 'real' array from EMC, Hitachi, or IBM. It had the magic word 'Raid' in the name so he went for it, and then was all over me because the system was so slow. I should'a known what was up when a JBOD D-370 2-way did stuff faster than our K570 6-way and the AutoRaid. Take my advice - don't go with an AutoRaid. Cheers, Mike -Original Message- Sent: Thursday, January 23, 2003 12:45 PM To: Multiple recipients of list ORACLE-L Michael, a dumb question. does this stops me from using VA7100 with 0+1 or are u talking about going some other disk array product? Thanks Mandar > -Original Message- > From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]] > Sent: Thursday, January 23, 2003 12:00 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: AUTORAID and VA7100 disk arrays for rp7400 > > > Apologies to all for shouting, but ... > > DO NOT USE AUTORAID! > ** *** *** * > > I used an AutoRaid system when I was at Petco. Performance was > el-sucko. There was more I/Os happening in the disk array > (by observing the disk lights) than was being caused by the > application and database. > > Plus, when the AR system Raid 0+1/5 mode, where some blocks are > kept in a RAID 0+1 area and some are kept in a RAID 5 area, the > array got so busy swapping one for another that it was virtually > useless. > > Fiber channel (FC-10) works ok, Clariion (by EMC) works Ok, > heck, even JBOD works better than AutoRaid. > > Just my 2¢ worth. > > Cheers, > Mike > > > -Original Message- > Sent: Thursday, January 23, 2003 11:35 AM > To: Multiple recipients of list ORACLE-L > > > Hi, > > i am in the process of defining the specs for a rp7400. a lil > overwhelmed by the storage offerings from HP. > i wanted to know if any of ull hv any inputs regarding a disk array. > we currently hv a Model 30/FC disk array with 9gig drives. > I am looking for a similar or the next higher configuration > disk array from HP. > > Any inputs regarding VA7100 disk array or corresponding > competetive disk aray from HP/competitor? > > cache size 256/512/1024 MB? dont know which to go. > thinking of going for 18GB 15k rpm rather than 36GB 15K rpm. > faster smaller drives. > > the va7100 product specs on HP site mention more about > AutoRAID (which is dynamic 0+1 or 5 configuration on the fly). > any inputs on AutoRAID for Oracle database files. > hv ull used 0+1 h/w configuration on VA7100? am i talking sense? > > a good article to read, especially page 4 > http://www.hp.com/products1/storage/products/disk_arrays/infol ibrary/hp_va_and_san_virtualization.pdf any inputs related to configuring a rp7400 are invited. my initial specs based on my current k570 is below. current k570 (7.3.4) 4 * 200Mhz 2 gn ram specs for rp7400 (8i/9i) 4 * 550MHz 6 Gb ram and i thought it was easy. take a few procs add ram add few disks, (Baaam!) make sound and license and u hv a server. but look into a detailed partlist and configuration options at https://www.e-solutions.hp.com/shop/cgi-bin/sweetspot.cgi Thanks Mandar -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) 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: Mandar A. Ghosalkar 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, in
RE: AUTORAID and VA7100 disk arrays for rp7400
Apologies to all for shouting, but ... DO NOT USE AUTORAID! ** *** *** * I used an AutoRaid system when I was at Petco. Performance was el-sucko. There was more I/Os happening in the disk array (by observing the disk lights) than was being caused by the application and database. Plus, when the AR system Raid 0+1/5 mode, where some blocks are kept in a RAID 0+1 area and some are kept in a RAID 5 area, the array got so busy swapping one for another that it was virtually useless. Fiber channel (FC-10) works ok, Clariion (by EMC) works Ok, heck, even JBOD works better than AutoRaid. Just my 2¢ worth. Cheers, Mike -Original Message- Sent: Thursday, January 23, 2003 11:35 AM To: Multiple recipients of list ORACLE-L Hi, i am in the process of defining the specs for a rp7400. a lil overwhelmed by the storage offerings from HP. i wanted to know if any of ull hv any inputs regarding a disk array. we currently hv a Model 30/FC disk array with 9gig drives. I am looking for a similar or the next higher configuration disk array from HP. Any inputs regarding VA7100 disk array or corresponding competetive disk aray from HP/competitor? cache size 256/512/1024 MB? dont know which to go. thinking of going for 18GB 15k rpm rather than 36GB 15K rpm. faster smaller drives. the va7100 product specs on HP site mention more about AutoRAID (which is dynamic 0+1 or 5 configuration on the fly). any inputs on AutoRAID for Oracle database files. hv ull used 0+1 h/w configuration on VA7100? am i talking sense? a good article to read, especially page 4 http://www.hp.com/products1/storage/products/disk_arrays/infolibrary/hp_va_and_san_virtualization.pdf any inputs related to configuring a rp7400 are invited. my initial specs based on my current k570 is below. current k570 (7.3.4) 4 * 200Mhz 2 gn ram specs for rp7400 (8i/9i) 4 * 550MHz 6 Gb ram and i thought it was easy. take a few procs add ram add few disks, (Baaam!) make sound and license and u hv a server. but look into a detailed partlist and configuration options at https://www.e-solutions.hp.com/shop/cgi-bin/sweetspot.cgi Thanks Mandar -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) 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: Statspack recomendations.
Get Don Burleson's book - I think it's called "Oracle 9i High Performance Tuning with STATSPACK". -Original Message- Sent: Thursday, January 23, 2003 6:44 AM To: Multiple recipients of list ORACLE-L List, I am looking for a recommendation on a book or web site covering statspack and it's use. A moderate level usage rather than an expert level literature is desired. Any recommendations please. 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: Vergara, Michael (TEM) 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: Win2k/8.1.7/SQL Question
Title: RE: Win2k/8.1.7/SQL Question I looked at our copy of the 9i Docs, and did some hunting around on the web, and this code definitely looks like 9i SQL. However, the Siebel instance is 8.1.7.3 (or 4...I don't exactly remember). How can they be running this SQL? Thanks, Mike -Original Message-From: Orr, Steve [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 14, 2003 5:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Win2k/8.1.7/SQL Question Well that looks like ANSI compatible SQL that should run under Oracle9i. Take a look and the 9i docs to develop a strategy for the "retrofit." This is so weird for me... having to unlearn Oracle syntax in order to write ANSI SQL. Sigh... -Original Message- From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 14, 2003 4:54 PM To: Multiple recipients of list ORACLE-L Subject: Win2k/8.1.7/SQL Question My European customers are trying to optimize some SQL that is used in their Siebel implementation. It uses a syntax that I am unfamiliar with. The SQL looks like: SELECT ... FROM SIEBEL.S_PARTY T1 INNER JOIN SIEBEL.S_ORG_EXT T2 ON T1.ROW_ID = T2.PAR_ROW_ID INNER JOIN SIEBEL.S_ORG_EXT T3 ON T2.MASTER_OU_ID = T3.PAR_ROW_ID INNER JOIN SIEBEL.S_ACCNT_POSTN T4 ON (T4.POSITION_ID = '1-6M10' 0.05) AND T2.ROW_ID = T4 INNER JOIN SIEBEL.S_PARTY T5 ON (T5.ROW_ID = T4.POSITION_ID, 0.05) LEFT OUTER JOIN SIEBEL.S_ORG_EXT T6 ON T2.PAR_OU_ID = T6.PAR_ROW_ID LEFT OUTER JOIN SIEBEL.S_ACCNT_POSTN T7 ON T1.ROW_ID = T7.OU_EXT_ID LEFT OUTER JOIN SIEBEL.S_ORG_PROMOPRFL T8 ON T2.ROW_ID = T8.ACCNT_ID AND T2.PR_PRFL_ID = ... WHERE ((T2.INT_ORG_FLG != 'Y' OR T2.PRTNR_FLG != 'N') AND T2.ACCNT_FLG != 'N') ORDER BY T2.PRTNR_SALES_RANK I did a cut-and-paste, so if there is missing punctuation I don't know that either. Can anyone tell me how this is supposed to work, or how I can translate into Oracle-compatible SQL? Thanks, Mike
Win2k/8.1.7/SQL Question
My European customers are trying to optimize some SQL that is used in their Siebel implementation. It uses a syntax that I am unfamiliar with. The SQL looks like: SELECT ... FROM SIEBEL.S_PARTY T1 INNER JOIN SIEBEL.S_ORG_EXT T2 ON T1.ROW_ID = T2.PAR_ROW_ID INNER JOIN SIEBEL.S_ORG_EXT T3 ON T2.MASTER_OU_ID = T3.PAR_ROW_ID INNER JOIN SIEBEL.S_ACCNT_POSTN T4 ON (T4.POSITION_ID = '1-6M10' 0.05) AND T2.ROW_ID = T4 INNER JOIN SIEBEL.S_PARTY T5 ON (T5.ROW_ID = T4.POSITION_ID, 0.05) LEFT OUTER JOIN SIEBEL.S_ORG_EXT T6 ON T2.PAR_OU_ID = T6.PAR_ROW_ID LEFT OUTER JOIN SIEBEL.S_ACCNT_POSTN T7 ON T1.ROW_ID = T7.OU_EXT_ID LEFT OUTER JOIN SIEBEL.S_ORG_PROMOPRFL T8 ON T2.ROW_ID = T8.ACCNT_ID AND T2.PR_PRFL_ID = ... WHERE ((T2.INT_ORG_FLG != 'Y' OR T2.PRTNR_FLG != 'N') AND T2.ACCNT_FLG != 'N') ORDER BY T2.PRTNR_SALES_RANK I did a cut-and-paste, so if there is missing punctuation I don't know that either. Can anyone tell me how this is supposed to work, or how I can translate into Oracle-compatible SQL? Thanks, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) 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).
Oracle 8i/HP-UX,Solaris,Windows/Active Directory Question
Happy Holidays Everyone! I have been hacking around the MetalLink site looking for how to move from using a TNSNAMES.ORA file to Active Directory. We use a mixed environment of HP-UX, Solaris, and Windows, with versions of Oracle from 7.3.4 (really!) to 9iR2. All the notes and docs I can find seem to be only for a Windows environment. Any pointers to docs or tips would be appreciated. Thanks, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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 course for 9i - Dumps/Crashes from Oracle University
Title: RE: New course for 9i - Dumps/Crashes from Oracle University I took this seminar set last year for Oracle 8i. It's really very good, but only a little was able to really soak in. I'm trying to convince manglement to let us go again. I had a professor in college who's first lesson was that he - despite speaking 8 languages, having 2 or 3 doctoral degrees in languages and such, and having many years of teaching experience - was more ignorant than we students. His lesson was "The more you know, the more you know you don't know". I am now more ignorant of Oracle than I was a year ago, and I think I could learn more this time. So far, it's not flying, but I haven't given up! Cheers, Mike -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Monday, December 16, 2002 12:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: New course for 9i - Dumps/Crashes from Oracle University Oracle Corporation is conducting these 3 highly technical seminars. Each one of them is a full day class at a cost of $500 per class. http://education.oracle.com/web_prod-plq-dad/plsql/show_desc.redirect?dc=D12856GC10 http://education.oracle.com/web_prod-plq-dad/plsql/show_desc.redirect?dc=D12858GC10 http://education.oracle.com/web_prod-plq-dad/plsql/show_desc.redirect?dc=D12860GC10 -Original Message-From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]]Sent: Monday, December 16, 2002 12:05 PMTo: Multiple recipients of list ORACLE-LSubject: RE: New course for 9i - Dumps/Crashes from Oracle University There will probably be others in the series... Looks like one of the 8i Internals seminars has made it to 9i! Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Monday, December 16, 2002 11:54 AMTo: Multiple recipients of list ORACLE-LSubject: RE: New course for 9i - Dumps/Crashes from Oracle University What is the world coming to? -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]Sent: Friday, December 13, 2002 5:44 PMTo: Multiple recipients of list ORACLE-LSubject: RE: New course for 9i - Dumps/Crashes from Oracle University hmmm ... http://education.oracle.com/web_prod-plq-dad/plsql/cdesc?dc=D12856GC10&p_org_id=1001&lang=US 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! also send the HELP command for other information (like subscribing).
RE: SQLPLUS spool file question
D'Oh! I saw Mark's original message say '^L', and my brain read that as '^M'! The '^L' comes from the value of NEWPAGE. "Set NEWPAGE 0" is what adds the '^L'; "set newpage n" makes SQL*Plus throw 'n' linefeeds between pages. Sorry 'bout any confusion! Mike -Original Message- Sent: Wednesday, December 11, 2002 8:54 AM To: Multiple recipients of list ORACLE-L Mark - A control-L is an ASCII form feed, if that helps. You could use the Unix command "tr" to remove them. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -Original Message- Sent: Wednesday, December 11, 2002 10:04 AM To: Multiple recipients of list ORACLE-L I'm creating a spool file of SQL commands based on several "select...from" statements. When I "vi" my output file, I see a "^L" character as the first character after each of my select statements. I remember a solution being presented a few years ago that allowed you to eliminate the "^L" on this list but I've managed to loose it. I seem to remember that you must use silent mode (-s) and the proper setting of several of the SQLPlus environment variables. Any help would be appreciated Mark Willett Sunnen Products Company -- 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: Vergara, Michael (TEM) 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: SQLPLUS spool file question
Title: SQLPLUS spool file question
Mark:
Here is what I usually set in a SQL*Plus script where I
will
want to spool the output:
set echo off pause off termout on feedback
on set pagesize 55 linesize 95 tab off trimspool on
I rarely use 'sqlplus -s', and I do not get the '^L'
character in my spool files. I also have a shell script
that I use to trim off excess spaces and ^L
characters
from other folk's scripts. Here it is:
#!/usr/bin/ksh
# This is for HP-UX ksh.
mv ${1} trim.tempif [ $? != 0 ] ; then echo
'' echo Error opening ${1} for move echo
Aborting... echo '' exitfi#/ /' | sed '1,$s/
*$//g' > ${1}rm trim.temp
# #EOF#
HTH,
Mike
-Original Message-From: Willett, Mark
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 11, 2002 8:04
AMTo: Multiple recipients of list ORACLE-LSubject:
SQLPLUS spool file question
I'm creating a spool file of SQL commands based on several
"select...from" statements. When I "vi" my output file, I see a "^L"
character as the first character after each of my select statements. I
remember a solution being presented a few years ago that allowed you to
eliminate the "^L" on this list but I've managed to loose it. I seem to
remember that you must use silent mode (-s) and the proper setting of several
of the SQLPlus environment variables. Any help would be
appreciated
Mark WillettSunnen Products
Company
RE: Win2k/8.1.7.3/Optimizer Weirdness
I forgot to mention - there are no statistics on any SYS or SYSTEM objects - per the FMs. Anybody know why this happens? -Original Message- Sent: Tuesday, November 19, 2002 10:50 AM To: Multiple recipients of list ORACLE-L I was able to duplicate this on my 9.0.1.1.1 database running on Win2K. -Original Message- Sent: Tuesday, November 19, 2002 1:17 PM To: Multiple recipients of list ORACLE-L Hi Listers: Has anyone ever seen something like this before? Can somebody explain it to me? Thanks, Mike SQL> SQL> select file_name from dba_temp_files; File Name - E:\ORANT\ORADATA\ECRMP\TEMP01.DBF 1 row selected. SQL> select /*+ RULE */ file_name from dba_temp_files; no rows selected SQL> --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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: Clark, Tommy R 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: Vergara, Michael (TEM) 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).
Win2k/8.1.7.3/Optimizer Weirdness
Hi Listers: Has anyone ever seen something like this before? Can somebody explain it to me? Thanks, Mike SQL> SQL> select file_name from dba_temp_files; File Name - E:\ORANT\ORADATA\ECRMP\TEMP01.DBF 1 row selected. SQL> select /*+ RULE */ file_name from dba_temp_files; no rows selected SQL> --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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).
Solaris 2.7/8.1.6.3/Listener
Hi Everyone: I currently have two instances on a machine. Since one is used little if at all, I want to roll the active schema into the other instance, which is used more. Is there a way that I can fool the listener so that when a connection request comes in for the DB I want to shut down it will connect to the other one? If you have an RTFM suggestion, please indicate the FM to R. Thanks, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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: database link tuning
I did some similar experimenting. I was doing a join of two local tables, and then pushing the result set out a database link to a remote table. Took for-flipping-ever. Then I did a local join to a temporary table, and pushed from there. Ran less than a minute for the same result. The moral is "do it local". Just my 2¢ worth on a rainy Friday. Mike -Original Message- Sent: Friday, November 08, 2002 11:43 AM To: Multiple recipients of list ORACLE-L Paula I was hoping someone with more specific experience in this area. Here is a quote from Oracle Performance Tuning 101: Be particularly when joining a local table to a remote table. My vote if you only have 60 rows would be to populate a local table with those rows before running your query. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, November 08, 2002 11:40 AM To: Multiple recipients of list ORACLE-L BTW, Was doing join of views pointing to tables through 2 database links and gateway. Just wondering - faster to move the tables then perform join locally esp. if I can do CTAS each time - h. -Original Message- Sent: Friday, November 08, 2002 12:34 PM To: '[EMAIL PROTECTED]' Trying to bring over 60 rows with database link and write to table using CTAS. It is taking forever - going through Oracle - going through another Oracle that is hooked up with a gateway to Informix - yuck!! The waits are: Event Waits Waits/sec % total Wait Time (ms) Wait Time/sec % totalAverage Wait SQL*Net more data from dblink 1352 80.870917573872599.120234604105614250 852.374685967221 0 0 Any ideas how to speed up other than getting another gateway, creating ascii file and using direct load. Is there a way to tune related to Net8, database links? Thanks, Paula -- 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: Vergara, Michael (TEM) 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: RAID5+
Russ: We're using EMC Clariion disk arrays. These are using EMC's version of RAID-5; they call it RAID-S. There is 2GB of cache if front of the disks. They claim that the cache is write guaranteed so that we'll never lose an update. So far, so good, and the performance has been acceptable, except (you knew this was coming, huh?) when we do large file moves from one tray to another, or when doing a refresh of our SAP stage system. This activity kinda buries the internal bus as well as the fiber, so that other users suffer. I guess to make a short answer even longer, this RAID-S technology seems to work a lot better than RAID-5 used to. Remember, though, YMMV. Cheers, Mike -Original Message- Sent: Monday, October 28, 2002 5:24 PM To: Multiple recipients of list ORACLE-L Hi, I just got forwarded a whitepaper from Hitachi and Oracle, that compairs raid 5+ and raid 1 using the TPC-C benchmark test suite. The claim is that raid 5 is as fast or faster. While I'm waiting for a comparison or raid 5+ with raid 0+1, I thought I'd take a poll with the list. The benchmark is using the Hitachi 7700E. Has anyone heard other recommendations attributed to Oracle that are pushing raid 5+ as the configuraton for "unrivaled performance"? Has new disk technology changed the general conception that raid 0 or 0+1 provides better performance than other raid levels? Thanks, Russ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brooks, Russ 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: Vergara, Michael (TEM) 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).
HP-UX 11i/8.1.7/USERENV Question...I guess...
I am trying to insert data into a remote table through a database link. This is the SQL and the error. 'dba_checks' is a synonym for the remote table. Two prior inserts in the script work just fine. MAILER is the name of the remote database. I'm puzzled. Any suggestions? Thanks, Mike SQL> l 1 insert into dba_checks (sid, check_date, check_condition, check_status) 2 select 'DBNAME', trunc(sysdate), 'Days since hot backup', 3 to_char(round(max(sysdate - VB.time))) 4* from V$BACKUP VB SQL> / insert into dba_checks (sid, check_date, check_condition, check_status) * ERROR at line 1: ORA-02070: database MAILER does not support operator USERENV in this context SQL> SQL> desc dba_checks NameNull?Type --- SID NOT NULL VARCHAR2(8) CHECK_DATE NOT NULL DATE CHECK_CONDITION NOT NULL VARCHAR2(30) CHECK_STATUS VARCHAR2(80) CHECK_REPORT LONG SQL> --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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).
HP-UX 11i/8.1.7/SAP
Hey Gang... If you have a SAP instance, what is your listener port? Our SAP systems listen on 1527. All six of them. Yesterday, one of the SAP/R3 admins asked us why we use 1527 instead of 1521. I told her I thought it was a SAP requirement because it pre-dates my working here. None of the other DBAs have a clue either. Is this a SAP requirement or do you think somebody back in the forgotten ages SWAG'ed a port? Thanks, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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: auditing CREATE DATABASE
Um... wasn't this... > Then you go and publicly execute that > person by beating him to the pulp with a baseball bat (so called "Soprano > method") ...the Al Capone method in "The Untouchables"? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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).
HP-UX11/Oracle 8.1.6/Constraint Question
This is something I'm not sure can be done. Can somebody help me out? I have a single table with a DEVICE_TYPE field, and four views - one for each valid device type. DEVICE_TYPE is a NOT NULL field. The views are defined like create view mytype_vw as select col1, col2, col3 from table where device_type = 'MYTYPE'; DEVICE_TYPE is not displayed, it is inferred from the view. If I want to insert a row through the view, how can I populate the DEVICE_TYPE field? TIA, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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-01115 after datafile autoexetend from 3.9 GB to 4.1 GB
Title: Message This is interesting. I had a vendor do an install on one of our NT servers, and they set the files to autoextend to 8GB. When I modified that limit down to 2GB (our company standard) they clouded up and rained all over me! They said there was no physical reason to limit the file size since it was on a RAID array blah blah blah. I read the note and it talks about extending to a 4GB or 8GB boundary. Is that kinda like the speed of light...where some physicists have theorized that you can travel below the speed of light or above the speed of light, but not AT the speed of light? Gosh! Who knew? Cheers, Mike -Original Message-From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 10, 2002 8:29 AMTo: Multiple recipients of list ORACLE-LSubject: RE: ora-01115 after datafile autoexetend from 3.9 GB to 4.1 GB Note # 148894.1 on Metalink has a possible solution... NT has a limit of 4GB for the file size :( - Kirti
RE: Space... confusion
April: I'm just guessing here, but is it a journaling file system? Could the journal be eating up your available space? HTH, Mike -Original Message- Sent: Thursday, October 10, 2002 8:14 AM To: Multiple recipients of list ORACLE-L Please forgive the cross postings, but I am hoping that someone in all of the sets of eyes that see this might have an idea I haven't thought of. *** Facts ** aix 4.3.3 oracle 9.0.1.3 new instance, up for 2 weeks locally managed tablespaces nothing with autoextend on file system at 7:01 am was at 98% 12:00 altered index tablespaces to nologging (but this did not change the file sizes... checked) 12:30 users (it is not a transactional instance... it is strictly reporting) started getting Ora-01114 errors corresponding (roughly) to when the file system hit 100% The only thing in the file system are database files Nothing "could" have changed at OS level in that time..to my knowledge ITAR open, not much progress (re... "that can't happen") DID happen... now trying desperately to find out WHY it happened. The 'problem' effected our biggest client. I need to find out what happened so it doesn't happen again... File system now at 92%, but will need to add dasd in the near future for growth one interesting finding found in the digging 9i created files of 2000m are 2097168384 k at os level 8i created and upgraded to 9i files of 2000m are 2097156096 at os level... Anybody have any ideas how something that can't happen, did? Anyone ever seen this kind of weirdness before? April Wells Oracle DBA Keep yourself well oiled with life, laughter, new ideas and action. Otherwise you will rust out. _Anonymous -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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: Is it possible to copy one db to another if the SID is different
Dear New Bee: We do this all the time, and the problem you're having is the one that I tripped over my first time, too. There is an important word missing from your command. It's not... CREATE CONTROLFILE REUSE DATABASE "TEST" RESETLOGS ARCHIVELOG ...it is ... CREATE CONTROLFILE REUSE SET DATABASE "TEST" RESETLOGS ARCHIVELOG ^^^ And when you ALTER DATABASE OPEN you'll also need to say RESETLOGS. HTH, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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: Table Scans
I am curious about something in your query. > SELECT distinct(o.object_name),o.object_type,o.owner > FROM dba_objects o,x$bh x > WHERE x.obj=o.object_id > AND o.object_type='TABLE' > AND standard.bitand(x.flag,524288)>0 > AND o.owner<>'SYS'; Where did you learn of the correct pattern for the "AND standard.bitand(x.flag,524288)>0" clause? Thanks, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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: Why do I receive the mails late?
Oh...I dunno...it breaks up my day to figure out the order of some of the posts. I just figure it's an artifact of mailing over the internet, with propagation delays and traffic and whatnot, and our own mail server doing it's intrusion and virus detection 'thing'. I suppose if you switch to digest mode the messages would be in order...maybe? Just my 2¢... -Original Message- Sent: Thursday, October 03, 2002 9:53 AM To: Multiple recipients of list ORACLE-L Yes. This is very normal for me as well. Naveen Nahata wrote: > I receive the mails of this late after a long delay approx 1-2 hours. Is this > common? > > Sometimes i get the reply first and then i get the question > > Regards > Naveen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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: Utl_file and OPENVMS
Utl_File.Put (L_Par_File_Hand,'Errors=50'); End If; Utl_File.New_Line(L_Par_File_Hand); Utl_File.Put (L_Par_File_Hand,'Control='||P_Load_Control_File_Dir||'/'||P_Current_Table_N ame||'.CTL'); Utl_File.New_Line(L_Par_File_Hand); Utl_File.Put (L_Par_File_Hand,'Log='||P_Load_Log_File_Dir||'/'||P_Current_Table_Name||to_ char(P_Run_Date,'mmdd')||'.LOG'); Utl_File.New_Line(L_Par_File_Hand); Utl_File.Put (L_Par_File_Hand,'Bad='||P_Load_Bad_File_Dir||'/'||P_Current_Table_Name||to_ char(P_Run_Date,'mmdd')||'.BAD'); Utl_File.New_Line(L_Par_File_Hand); Utl_File.Put (L_Par_File_Hand,'Discard='||P_Load_Discard_File_Dir||'/'||P_Current_Table_N ame||to_char(P_Run_Date,'mmdd')||'.DSC'); as Utl_File.New_Line(L_Par_File_Hand); Utl_File.Put (L_Par_File_Hand,'Data='||P_Load_Data_File_Dir||'/'||P_Current_Table_Name||' /'|| P_Current_Table_Name||to_char(P_Run_Date,'mmdd')||'.DAT'); -- Close the file after printing. Utl_File.Fclose(L_Par_File_Hand); Exception When Others then Dbms_Output.Put_line(to_char(sqlcode)||'-'||SQLERRM); End; Thanks, Any assistance would be appreciated. I am just getting in to the OPENVMS OS. Ron ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing 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: Vergara, Michael (TEM) 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: logon trigger
In looking at this and thinking about it...doesn't any DDL statement do an implied COMMIT? If so, the first "EXECUTE IMMEDIATE" will fire, commit, the SET TRANSACTION will be released, and the user will not be assured of using that rollback segment. Shouldn't the SET TRANSACTION be the last statement in the trigger? And if Siebel wants RBO, doesn't changing the optimizer at the session level mean that all that session's queries will be performed using CBO? Is Siebel OK with that? Cheers, Mike -Original Message- Sent: Wednesday, October 02, 2002 8:43 AM To: Multiple recipients of list ORACLE-L "Alter session ..." is not DML, so I think you need to use dynamic SQL: create or replace trigger smload.logon after logon on database begin SET TRANSACTION USE ROLLBACK SEGMENT RBBIG01; EXECUTE IMMEDIATE "Alter session enable parallel query"; EXECUTE IMMEDIATE "Alter session set SORT_AREA_SIZE = 10485760"; EXECUTE IMMEDIATE "Alter session set OPTIMIZER_MODE = choose"; end; / Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, October 02, 2002 11:23 AM > Hi guys > > I am trying to create the following trigger. > > The user in question is logging in using siebel application and siebel does > not allow multiple SQL statements during login so we through this might > solve the problem. My problem now is though, the set rollback works but the > alter session statements does not seem to want to work. > > The server needs to be in RBO since this is the only mode supported by > siebel. > > Help appreciated. > > create or replace trigger smload.logon after logon on database > begin > SET TRANSACTION USE ROLLBACK SEGMENT RBBIG01; > Alter session enable parallel query; > Alter session set SORT_AREA_SIZE = 10485760; > Alter session set OPTIMIZER_MODE = choose; > end; > / > > George > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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: 8.1.6 to 8.1.7 upgrade
I also found that I had to use SVRMGRL instead of SQLPLUS when doing the Java install. Dunno why. HP-UX 11.0 and 11i. I think it takes so long because it is reloading and revalidating the whole entire Java library. I guessing. My 2¢ worth... Mike -Original Message- Sent: Tuesday, October 01, 2002 10:56 AM To: Multiple recipients of list ORACLE-L If you have java installed be aware that there are a lot of changes with 8.1.7. If you have problems with the upgrade you *cannot* simply run rmjvm.sql and initjvm.sql There are two documents on removing and installing java which are must reads (I don't have the numbers handy, sorry). Allow a lot of time for the java upgrade. In the end I found it easier to remove java and do a fresh install (it helped that we weren't actually using it outside of development at the time). Good luck! Jay Miller -Original Message- Sent: Tuesday, October 01, 2002 11:49 AM To: Multiple recipients of list ORACLE-L Gurus! Any docs / URLs / do's don'ts / tips for 8.1.6 to 8.1.7 upgrade? I have gone throught the metalink docs and Oracle Documentation. Thanks, -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya 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: Miller, Jay 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: Vergara, Michael (TEM) 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).
Oracle 8.1.6.2/HP-UX 11i/Reorg IOT
Hi Gang! Is there any trick, or any gotchas, for re-orging IOT-style tables? I have one that's growing, and the initial builder put PCTINCREASE at 100 and I cannot change it with an ALTER TABLE. Any suggestions? Docos? Magic potions? Thanks, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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).
HP-UX 11i/8.1.7.x/Oracle-to-AD
Does anyone know of white papers or other documentation that shows how to read an Active Directory server from within Oracle using the supplied procedures? Thanks, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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: Cannot start database (already running)
Follow your instincts. Use ipcrm and clear out those shared memory segments. Then it should start OK. -Original Message- Sent: Wednesday, August 21, 2002 11:34 AM To: Multiple recipients of list ORACLE-L Oracle 8.0.5 Solaris 2.6 HA Cluster 2.1 This is wacky. Any ideas on this one (other than reboot the box)??? I cannot start up this database (claims it's already running). Clearly it is not. No background processes for this instance. The only process I see even remotely related to this database is the oracledesi process. (I don't know what that process is.) I do have a semaphore set for oracle. Should I remove it? (I normally have other databases on this box, but I've shut them all down.) This database worked fine till a network device was ripped out from under it, and the HA stuff kicked in and failed it over. Any ideas? Thanks for any help Barb -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Win2000/8.1.7.3.0/SQL
Now you've piqued my curiosity again, too. I'm running it without the hints and with a 10053 and we'll see what it says. Tomorrow. At the plantation... No...no...that's a movie... Cheers, Mike -Original Message- Sent: Tuesday, August 20, 2002 5:09 PM To: Multiple recipients of list ORACLE-L Mike, Just one more thing to check before you close this: Can you run a 10053 trace? This is a 'CBO trace' and should provide some interesting reading. There was an excellent paper from Wolfgang Breitling on the 10053 at the recent IOUG and should be available somewhere... Inquiring minds want to know! John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Disappointments are inevitable in Life, but discouragement is optional. You decide! ** The opinions and statements above are entirely my own and not those of my employer or clients ** > -----Original Message----- > From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, August 20, 2002 4:34 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Win2000/8.1.7.3.0/SQL > > > John: > > That makes perfect sense in view of the fact that only the > /*+ RULE */ hint makes the query run. I'm not gonna try and > find the root cause any more; I've modified my queries and > I get answers again. > > My Thanks to all who have helped me with this issue. > > Cheers, > Mike > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Win2000/8.1.7.3.0/SQL
John: That makes perfect sense in view of the fact that only the /*+ RULE */ hint makes the query run. I'm not gonna try and find the root cause any more; I've modified my queries and I get answers again. My Thanks to all who have helped me with this issue. Cheers, Mike -Original Message- Sent: Tuesday, August 20, 2002 1:24 PM To: Multiple recipients of list ORACLE-L Mike, > Ok...this is strange. The optimizer_mode is set to RULE, but if > I put a RULE hint into the SQL it runs OK. I tried increasing This is almost clearly a case of the CBO being forced for whatever reason. And there are many :( Cut and paste from the Fine Manual (Oracle 8i Designing and Tuning for Performance). See the last 'Note:' :) The Optimizer 4-19 Features that Require the CBO The use of any of the following features requires the use of the CBO: n Partitioned tables n Index-organized tables n Reverse key indexes n Function-based indexes n SAMPLE clauses in a SELECT statement n Parallel execution and parallel DML n Star transformations n Star joins n Extensible optimizer n Query rewrite (materialized views) n Progress meter n Hash joins n Bitmap indexes n Partition views (release 7.3) Note: Even if the parameter OPTIMIZER_MODE is set to RULE, the use of these features enables the CBO. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Win2000/8.1.7.3.0/SQL
John: I checked it out with this... SQL> select owner, trunc(last_analyzed), count(*) 2 from dba_tab_columns 3 group by owner, trunc(last_analyzed); OWNER TRUNC(LAS COUNT(*) -- - -- AURORA$JIS$UTILITY$ 69 OSE$HTTP$ADMIN 16 OUTLN21 PERFSTAT293 SIEBEL 12-JUL-02 17737 SIEBEL71877 SYS 15831 SYSTEM 172 8 rows selected. SQL> ...and it looks like there's nothing here, either! Thanks, Mike -Original Message- Sent: Tuesday, August 20, 2002 2:48 PM To: Multiple recipients of list ORACLE-L Mike, Just a thought - could you check DBA_TAB_COLUMNS too for LAST_ANALYZED in the SYS schema? John > 1 select owner, trunc(last_analyzed), count(*) > 2 from dba_tables > 3* group by owner, trunc(last_analyzed) > SQL> / > So I'm confident it's not analyzed SYS objects. But then I > wondered what else Siebel may have done...so I did this... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Win2000/8.1.7.3.0/SQL
Jared: I validated that there were no stats with this query: SQL> SQL> l 1 select owner, trunc(last_analyzed), count(*) 2 from dba_tables 3* group by owner, trunc(last_analyzed) SQL> / OWNER TRUNC(LAS COUNT(*) -- - -- AURORA$JIS$UTILITY$ 14 OSE$HTTP$ADMIN3 OUTLN 2 PERFSTAT 28 SIEBEL 12-JUL-02 2357 SYS 219 SYSTEM 15 7 rows selected. SQL> So I'm confident it's not analyzed SYS objects. But then I wondered what else Siebel may have done...so I did this... SQL> 1 select name, value from v$parameter 2* where name like '%opt%' SQL> / NAMEVALUE --- optimizer_features_enable 8.1.7 optimizer_mode RULE optimizer_max_permutations 8 optimizer_index_cost_adj100 optimizer_index_caching 0 optimizer_percent_parallel 0 object_cache_optimal_size 102400 7 rows selected. SQL> I confess to not knowing what the 'optimizer_features_enable' parameter does, so I'll have to look that up. Thanks, Mike -Original Message- Sent: Tuesday, August 20, 2002 10:49 AM To: Multiple recipients of list ORACLE-L Mike, The message I replied to didn't include the SQL. So, I found your original message and actually looked at the SQL. :) Make sure that your system tables have not been analyzed, as the kernel still relies on RBO. You can't change the degree on x$ tables, as they are not actually tables. They are memory structures with a SQL interface. You might want to investigate using the ORDERED hint and changing the order of your driving tables. If your execution plan is using NESTED LOOPS, put the expensive one first ( driving table ). HTH Jared "Vergara, Michael (TEM)" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/20/2002 09:38 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Win2000/8.1.7.3.0/SQL Jared: The query is selecting from DBA_xxx views. The tables under these views are some of the X$ tables, and tables like user$, ts$, seg$, etc. I can verify that everything but the X$ tables have a degree of 1. How can I check those X$ tables...or should I decide to be content with a resolution? Thanks, Mike -Original Message- Sent: Monday, August 19, 2002 7:38 PM To: Multiple recipients of list ORACLE-L Mike, Is the DEGREEE on the table > 1? You can see this in DBA_TABLES. If the degree of parallelism is > 1 then CBO will be used regardless of OPTIMIZER_MODE or OPTIMIZER_GOAL. Using a RULE hint will override the optimizer settings. I'm guessing that degree is > 1 and you have old statistics. Jared On Monday 19 August 2002 17:58, Vergara, Michael (TEM) wrote: > Ok...this is strange. The optimizer_mode is set to RULE, but if > I put a RULE hint into the SQL it runs OK. I tried increasing > the sort_area_size, but no joy. The segment with the largest > number of extents is the silly TEMP segment with 985. After that > is IDL_UB1$ with 739, and it tapers off quickly after that. > On the other hand, this query runs fine on our SAP system, and > it has thousands of tables and lots of extents. > > Well, the RULE hint in a RULE system seems to have worked. > Weird. I never woulda tried that. > > Thanks, > Mike > > -Original Message- > [mailto:[EMAIL PROTECTED]] > Sent: Monday, August 19, 2002 4:28 PM > To: Multiple recipients of list ORACLE-L > > > or is that 1 db set to first_rows? > If so try the query with a rule hint? > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists ---
RE: Win2000/8.1.7.3.0/SQL
Title: RE: Win2000/8.1.7.3.0/SQL Dan: I don't think this is the problem. See query... SQL> select degree, count(*) 2 from dba_tables 3 group by degree; DEGREE COUNT(*)-- -- 1 2652 And I have not changed anything. Thanks (and keep those ideas coming in, folks!), Mike -Original Message-From: Straub, Dan [mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 20, 2002 11:03 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Win2000/8.1.7.3.0/SQL Hi Mike, I got 'DEFAULT'. After 'alter table ... noparallel', it was '1'. From Metalink 66484.1: (3) If any table in a query has a parallel degreee greater than one (including the DEFAULT degree), Oracle uses the cost-based optimizer for that query--even if OPTIMIZER_MODE = RULE, or if there is a RULE hint in the query itself So, since you said that a RULE hint makes it work, this may not be the problem. Dan. -Original Message- From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 10:05 AM To: Multiple recipients of list ORACLE-L Subject: RE: Win2000/8.1.7.3.0/SQL Dan: When you did a 'select degree from dba_tables', did you get '1' or 'DEFAULT'? I get '1's for all my tables. Is there someplace else I should look? Thanks, Mike
RE: Win2000/8.1.7.3.0/SQL
Title: RE: Win2000/8.1.7.3.0/SQL Dan: When you did a 'select degree from dba_tables', did you get '1' or 'DEFAULT'? I get '1's for all my tables. Is there someplace else I should look? Thanks, Mike -Original Message-From: Straub, Dan [mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 20, 2002 9:03 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Win2000/8.1.7.3.0/SQL I think you are on to something Jared. We had this happen at a production site last year. For some reason, the site began reporting performance problems after upgrading from 7.3.4 to 8.1.6. I finally tracked it down to the fact that a majority of our tables had 'degree' set to 'DEFAULT', which forces the use of the CBO. We fixed this by doing 'alter table noparallel' for all the tables which set degree to 1 and solved the problem. Dan. > -Original Message- > From: Jared Still [mailto:[EMAIL PROTECTED]] > Sent: Monday, August 19, 2002 7:38 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Win2000/8.1.7.3.0/SQL > > > > Mike, > > Is the DEGREEE on the table > 1? > > You can see this in DBA_TABLES. > > If the degree of parallelism is > 1 then CBO > will be used regardless of OPTIMIZER_MODE or > OPTIMIZER_GOAL. > > Using a RULE hint will override the optimizer settings. > > I'm guessing that degree is > 1 and you have old statistics. > > Jared > > On Monday 19 August 2002 17:58, Vergara, Michael (TEM) wrote: > > Ok...this is strange. The optimizer_mode is set to RULE, but if > > I put a RULE hint into the SQL it runs OK. I tried increasing > > the sort_area_size, but no joy. The segment with the largest > > number of extents is the silly TEMP segment with 985. After that > > is IDL_UB1$ with 739, and it tapers off quickly after that. > > On the other hand, this query runs fine on our SAP system, and > > it has thousands of tables and lots of extents. > > > > Well, the RULE hint in a RULE system seems to have worked. > > Weird. I never woulda tried that. > > > > Thanks, > > Mike > > > > -Original Message- > > [mailto:[EMAIL PROTECTED]] > > Sent: Monday, August 19, 2002 4:28 PM > > To: Multiple recipients of list ORACLE-L > > > > > > or is that 1 db set to first_rows? > > If so try the query with a rule hint? > > > > Bruce Reardon > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jared Still > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). >
RE: Win2000/8.1.7.3.0/SQL
Jared: The query is selecting from DBA_xxx views. The tables under these views are some of the X$ tables, and tables like user$, ts$, seg$, etc. I can verify that everything but the X$ tables have a degree of 1. How can I check those X$ tables...or should I decide to be content with a resolution? Thanks, Mike -Original Message- Sent: Monday, August 19, 2002 7:38 PM To: Multiple recipients of list ORACLE-L Mike, Is the DEGREEE on the table > 1? You can see this in DBA_TABLES. If the degree of parallelism is > 1 then CBO will be used regardless of OPTIMIZER_MODE or OPTIMIZER_GOAL. Using a RULE hint will override the optimizer settings. I'm guessing that degree is > 1 and you have old statistics. Jared On Monday 19 August 2002 17:58, Vergara, Michael (TEM) wrote: > Ok...this is strange. The optimizer_mode is set to RULE, but if > I put a RULE hint into the SQL it runs OK. I tried increasing > the sort_area_size, but no joy. The segment with the largest > number of extents is the silly TEMP segment with 985. After that > is IDL_UB1$ with 739, and it tapers off quickly after that. > On the other hand, this query runs fine on our SAP system, and > it has thousands of tables and lots of extents. > > Well, the RULE hint in a RULE system seems to have worked. > Weird. I never woulda tried that. > > Thanks, > Mike > > -Original Message- > [mailto:[EMAIL PROTECTED]] > Sent: Monday, August 19, 2002 4:28 PM > To: Multiple recipients of list ORACLE-L > > > or is that 1 db set to first_rows? > If so try the query with a rule hint? > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Win2000/8.1.7.3.0/SQL
Anand: This is one of four queries in a script I call my 'space_critical' script. Every night, an automated process scans all the DBs that I am responsible for, and sends me an e-mail if there is a problem, such as not enough space in a tablespace for a table to add an another extent. When I get this e-mail, I log in to this database with a maintenance ID, and run 'space_critical'. The entire report shows space by tablespace, by datafile, and by 'troubled object'. Trouble Objects are tables, indexes, whatever, that cannot allocate another extent. My script also creates a script in the /tmp directory that will change the next_extent size to a number that will fit in the remaining space. This is useful when the vendor is late delivering the disk you need. I published this script last year to www.searchDatabase.com. The script can be found at http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci778766,00.html. I hope you find it useful. Cheers, Mike -Original Message-From: Anand Kumar N [mailto:[EMAIL PROTECTED]]Sent: Monday, August 19, 2002 9:05 PMTo: Vergara, Michael (TEM)Subject: Re: Win2000/8.1.7.3.0/SQL U'r prompting in this SQL as Generating first troubled objects. What does this mean, actually what is the output of this sql. Pl. reply me. RegardsAnand KumarITW Signode India Ltd
RE: Win2000/8.1.7.3.0/SQL
Ok...this is strange. The optimizer_mode is set to RULE, but if I put a RULE hint into the SQL it runs OK. I tried increasing the sort_area_size, but no joy. The segment with the largest number of extents is the silly TEMP segment with 985. After that is IDL_UB1$ with 739, and it tapers off quickly after that. On the other hand, this query runs fine on our SAP system, and it has thousands of tables and lots of extents. Well, the RULE hint in a RULE system seems to have worked. Weird. I never woulda tried that. Thanks, Mike -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 4:28 PM To: Multiple recipients of list ORACLE-L or is that 1 db set to first_rows? If so try the query with a rule hint? Bruce Reardon -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Win2000/8.1.7.3.0/SQL
Hmmm...that's a possibility. However, the query is blowing out a 2GB temp space that is empty when the query starts. I'll check and play with this field anyway. Thanks, Mike -Original Message- Sent: Monday, August 19, 2002 4:18 PM To: Multiple recipients of list ORACLE-L The order by is dong a sort and you have insufficient sort space configured so it is doing it to disk and that is the temp tablespace or whatever is allocated as the users temporary tablespace. I suspect that this database has the smallest SGA for any of the databases you have tested. You might like to investigate the SORT_AREA_SIZE parameter or maybe just look at increasing the available memory to the instance. Cheers -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Win2000/8.1.7.3.0/SQL
John: > Does that particular Db have it's SYS schema ANALYZED? This should return no > rows - if it does, then you can drop the stats for SYS and run this query > again. Nope. Checked that already, but I checked it again. Any other suggestions? Thanks, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Win2000/8.1.7.3.0/SQL
Hi Gurus: I have this SQL, see... col segment_name format a30 heading "Segment Name" col maxseg format 9,999,999.9 heading "Largest|Segment (MB)" col segment_type format a15 heading "Segment|Type" col pct_increase format 999 heading "Pct|Incr" col next_ext format 9,999,999.9 heading "Next|Extent (MB)" col ownerformat a12 prompt Generating First Troubled Objects Listing... select a.owner, a.tablespace_name, a.segment_name, a.segment_type, a.next_extent/1048576 next_ext, a.pct_increase, max(b.bytes)/1048576 MAXSEG from sys.dba_segments a, sys.dba_free_space b, (select max(fs.bytes) maxbytes, fs.tablespace_name tsname from sys.dba_free_space fs group by fs.tablespace_name) wherea.tablespace_name = b.tablespace_name and a.tablespace_name = tsname (+) and a.next_extent > maxbytes group by a.owner, a.tablespace_name, a.segment_name, a.segment_type, a.next_extent, a.pct_increase order by a.next_extent desc, owner, segment_name / ...and it works great everywhere. Well, almost everywhere, and there's the rub. Thie query works on my 7.3, 8.0, 8i, 8iR2, and most 8iR3 databases. In this one database, on Windows 2000, it blows out the TEMP tablespace. Every time. And this is the only system where that happens. There are only 12 tablespaces, and 15 datafiles. Any ideas why this would fill up the TEMP space? Thanks, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: compile invalid objects
I have written scripts like this in the past, but the problem I run into is that recompiling some objects invalidates others, sometimes in a circular loop. What I'd like to find/see/learn-how-to-do is a script that compiles things in dependency order. So far, this capability eludes me. I use Oracle 8.0.5 -> 8.1.7.4. Cheers, Mike -Original Message-From: Tim Gorman [mailto:[EMAIL PROTECTED]]Sent: Saturday, August 17, 2002 8:48 AMTo: Multiple recipients of list ORACLE-LSubject: Re: compile invalid objects Script "gen_recompile.sql" online at http://www.EvDBT.com/tools.htm... As written, it will not execute the generated "run_recompile.sql" script; you'll have to uncomment the HOST command at the bottom to do that. I like to leave it with it's teeth pulled however -- at least at first -- so I can review the generated script... Hope this helps... - Original Message - From: BigP To: Multiple recipients of list ORACLE-L Sent: Friday, August 16, 2002 4:28 PM Subject: compile invalid objects I am feeling lazy today .. so if someone can give me script that compiles all invalid objects untill all objects are valid ... will be great . Yes I am looking for the one which does this in a loop so that i dont have to run this many times to get 0 invalid objects Thanks , -Bp
RE: Cognos-unix???
We moved away from the Cognos-on-UNIX because of limitations in the tool. Plus, believe it or not, Cognos on Windoze is a LOT faster. Just my 2¢ worth... Mike -Original Message- Sent: Friday, August 16, 2002 9:49 AM To: Multiple recipients of list ORACLE-L I've install Cognos tools on hp-ux 10.20 a while ago. The tool was Cognos Tranformer. We decided to build the cubes on the unix box (instead Win NT) then ftp the cubes on a Winframe server. Which tool do you want to install ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle9i Installation Error
I haven't started playing with 9i yet, but this message sounds like a message from one of the optional components. I usually get something like this when I'm applying a patch and the patched component does not exist. Ah HA! I checked one of my more obscure systems and found that the 'ctx' option is the 'Intermedia Text' option. It sounds like this product is not entirely installed, or is installed incorrectly. If you need it, re-install. If not, just skip over this error and continue your install. Good Luck! Mike -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 13, 2002 8:35 AMTo: Multiple recipients of list ORACLE-LSubject: Oracle9i Installation ErrorHello All, We are trying to install Oracle9i on HP-UX and getting following message: Error in invoking target install of makefile: /oracle/product/9.0.1/ctx/lib/ins_ctx.mk I have looked through metalink but could not find anything satisfying. I would like to hear from someone who has an idea about overcoming this error. Regards. M.Emre HANCIOGLUMasterfoods Services GmbHISI Application SupportTel : +49 2162 500-576Fax: +49 2162 41497E-Mail: [EMAIL PROTECTED]
Oracle vs. DB2
Hi Everyone! Well, there's been a lot of Oracle vs. Microsoft traffic on the list, but now my Manglement wants a similar comparison to IBM's DB2. Does anyone know of web sites or locations where there are documented objective comparisons between Oracle and DB2? I'm faced with answering buzzwords like 'Future Market Position', 'T.C.O. - Cost Effectiveness', 'Demonstrated Technology', and 'Platform Compatibility'. Any references are appreciated. Thanks, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
HP-UX 11.0/8.1.6.2/Parameters
Good Morning! Does anyone know where Oracle decides how many 'cache buffer latches'? I have four databases on a single machine, all at the same version of Oracle, with varying sizes of SGA. One of these instances has 2048 cache buffer latches, the others have 1024. I'm wondering if this is a modifiable setting. Thanks, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: UNIX Q: How do I delete files beginning with #
Y'know, if it were me, I'd do... rm -i '#Column' ... This way I get to say yea or nay to each file, and there are no rude surprises when I'm done. Just my 2¢ worth... Mike -Original Message- Sent: Wednesday, July 31, 2002 10:38 PM To: Multiple recipients of list ORACLE-L rm '#Column' '#This' '#' Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - NCOAUG Training Day, Aug 16 Chicago - Miracle Database Forum, Sep 20-22 Middlefart Denmark - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas -Original Message- Collado Sent: Wednesday, July 31, 2002 11:33 PM To: Multiple recipients of list ORACLE-L Hi, I have files like: #Column #This # How do I get rid of these 3? Rgds, Ross -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ross Collado INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: EMN0
In my experience from Saturday, even 'shutdown immediate' does not work. Are you getting any ORA-600's in your alert.log? I was. Have you recently run utlirp.sql? That's what hosed me up, but I had to because I was refreshing from 64-bit Oracle to 32-bit Oracle. Good Luck, Mike -Original Message- Sent: Monday, July 22, 2002 11:19 AM To: Multiple recipients of list ORACLE-L There is no EMN0 process out there TO kill... that is what concerns me. There are also no user connections (haven't had the listener started in a while... it is (so far) for user testing patches, and we haven't had any patches since we got TEST. Quite honestly I like your solution better than Oracle's... they claim there is no solution other than to shutdown abort, startup restrict, shutdown immediate (EVERY time you shutdown the database... this is a legitimate way of stopping ... per metalink person) -Original Message- Sent: Monday, July 22, 2002 12:38 PM To: Multiple recipients of list ORACLE-L April: I just had something like this over the weekend. In my case, the server was trying to run 'dbms_java.stop_server'. There was some mysterious corruption in the stored Java classes that was making this process hang. If you look at 'ps' or 'top', do you see the client process from svrmgrl running at top speed? If you kill the EMN0 process, does it restart? I was able to run 'sqlplus /nolog' and 'connect internal' even after the shutdown had started, and I looked at the running SQL. That's how I found this. If indeed this is the problem, you will need to deinstall and reinstall Java. Good Luck! Mike -Original Message- Sent: Monday, July 22, 2002 9:48 AM To: Multiple recipients of list ORACLE-L Has anyone experienced problems with Database hanging on shutdown and the only error anywhere is "Restarting dead background process EMN0 " and that appears consistently before the inability to stop the database. I have created an Itar (which was down graded immediately...) and hunted for answers on metalink. There are two 'solutions' that they suggest. One is to ignore it... if you aren't using Advanced Queuing you don't have to worry anyway... the other is every time you shut down do shutdown abort-startup restricted- shutdown immediate... this will kill all the process (of which at the os level and the DB level the only ones running were Oracle generated processes... oratest 36146 1 0 05:59:02 - 0:07 ora_qmn0_TEST oratest 36384 1 0 05:59:02 - 0:01 ora_smon_TEST oratest 36640 1 0 05:59:02 - 0:01 ora_ckpt_TEST oratest 37156 1 0 05:59:02 - 0:00 ora_dbw0_TEST oratest 37416 1 0 05:59:02 - 0:00 ora_pmon_TEST oratest 37672 1 0 05:59:02 - 0:00 ora_lgwr_TEST oratest 41404 1 0 05:59:02 - 0:00 ora_reco_TEST ) Has anyone dealt with this successfully? It deals, from what I have gathered, with Java in the database (maybe?). Thanks in advance for any advice April Wells Corporate Systems Amarillo Texas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Rant
I was told that same thing in an interview. He said "I don't know is not a good answer. I don't know, but I know where to find out." is much better. -Original Message- Sent: Monday, July 22, 2002 9:54 AM To: Multiple recipients of list ORACLE-L even so, I'd rather have someone tell me "my mind has gone blank, but I know I can look it up in this manual" --- KENNETH JANUSZ <[EMAIL PROTECTED]> wrote: > One thing to keep in mind is that it is easy to get "rattled" during > a job > interview and have your mind go blank on you. This is especially > true with > computer technical types who are basically introverts. Some years > back when > I was a corporate controller I interviewed a young lady for a admin > type > position. Her interview was a total disaster. She took the typing > test and > completely messed it up. But there was something about her skills > that came > through and I hired her. I was never sorry that I did. She could > type up > complicated tax forms that were always 100% correct. She was a model > employee. > > Sometimes you have to go by your gut feel. Answers to technical > questions > are not the complete picture. > > My $0.02 worth, > > Ken Janusz, CPIM > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Monday, July 22, 2002 9:58 AM > > > > Ok, I need to vent a little. > > > > Last week, I was asked to do some tech interviews over > > the phones for a mid level DBA position. Someone with > > about 2-3 years experience. > > > > I don't consider myself a real smart DBA, nor do I > > think that I ask particularly tough questions. The > > questions that I ask potential candidates are soley > > based on what is on the resume. So I figure if > > someone has, say, hot backups or SQL tuning on their > > resumes, I'd expect them to be able to hold a fairly > > intelligent conversation about these topics. No such > > luck! > > > > What really frustrated me, and what I really want to > > get out of my system, is that nobody that I talked to, > > had a real good concept of hot backups. Forget about > > recovery. I asked each and every candidate who > > claimed to have done hot backups, just give me a high > > level overview of how you do a hot backup. Don't care > > about syntax, just give me the mechanics. The answers > > I got were completely off base, baffling and > > frustrating. Some of these folks claimed to have 5 > > years experience!!! > > > > 'Well, we use scripts to do these, so I'm not sure how > > these are done...' (But it says on your resume you've > > done this???) > > > > 'Oh, I take the tablespace offline, and copy the > > datafile to tape...' (Unless I'm mistaken, that's not > > how a hot backup is done, right?) > > > > 'Well, I use the export utility, and as the backup > > starts, it is written to the dump file.' (Huh? What?) > > > > 'During this time, everything is written to the redo > > logs and not to the tablespace...' (You've been > > reading one of those books, haven't you?) > > > > I also asked them how they'd put a tablespace in > > backup mode. Simple enough, right? Not one of them > > got it right. Not even close. Didn't have clue as to > > what I was talking about. Fair enough, you don't > > know. Well how about a simple recovery scenario. I > > asked every candidate how they would do an online > > recover of a datafile while the database was still in > > use. No ideas. Not even close. > > > > I dunno, perhaps I'm spoilt by being a member of this > > list? Perhaps I expect every candidate to be as > > knowledgeable as you guys? Perhaps I'm asking too > > much? > > > > Rant over. Thanks for listening. > > > > mkb -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: EMN0
April: I just had something like this over the weekend. In my case, the server was trying to run 'dbms_java.stop_server'. There was some mysterious corruption in the stored Java classes that was making this process hang. If you look at 'ps' or 'top', do you see the client process from svrmgrl running at top speed? If you kill the EMN0 process, does it restart? I was able to run 'sqlplus /nolog' and 'connect internal' even after the shutdown had started, and I looked at the running SQL. That's how I found this. If indeed this is the problem, you will need to deinstall and reinstall Java. Good Luck! Mike -Original Message- Sent: Monday, July 22, 2002 9:48 AM To: Multiple recipients of list ORACLE-L Has anyone experienced problems with Database hanging on shutdown and the only error anywhere is "Restarting dead background process EMN0 " and that appears consistently before the inability to stop the database. I have created an Itar (which was down graded immediately...) and hunted for answers on metalink. There are two 'solutions' that they suggest. One is to ignore it... if you aren't using Advanced Queuing you don't have to worry anyway... the other is every time you shut down do shutdown abort-startup restricted- shutdown immediate... this will kill all the process (of which at the os level and the DB level the only ones running were Oracle generated processes... oratest 36146 1 0 05:59:02 - 0:07 ora_qmn0_TEST oratest 36384 1 0 05:59:02 - 0:01 ora_smon_TEST oratest 36640 1 0 05:59:02 - 0:01 ora_ckpt_TEST oratest 37156 1 0 05:59:02 - 0:00 ora_dbw0_TEST oratest 37416 1 0 05:59:02 - 0:00 ora_pmon_TEST oratest 37672 1 0 05:59:02 - 0:00 ora_lgwr_TEST oratest 41404 1 0 05:59:02 - 0:00 ora_reco_TEST ) Has anyone dealt with this successfully? It deals, from what I have gathered, with Java in the database (maybe?). Thanks in advance for any advice April Wells Corporate Systems Amarillo Texas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Rant
I read your rant, and I agree with you. But I do have one little itsy bitsy question... > I also asked them how they'd put a tablespace in > backup mode. Simple enough, right? Not one of them > got it right. Not even close. Didn't have clue as to > what I was talking about. Fair enough, you don't > know. Well how about a simple recovery scenario. I > asked every candidate how they would do an online > recover of a datafile while the database was still in > use. No ideas. Not even close. How DO you do an online recovery of a datafile while the database is still in use? I've had to do recoveries before, but never this scenario. Thanks, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Migration 8.1.6.0 to 8.1.7.2
Ken: My Two Cents'... It seems to me that you're gonna have to install the 8.1.7.0.0 code in order to apply the 8.1.7.2 patch. So where's the problem? You install 8.1.7, upgrade the DB, apply the .2 patch, and it's Miller Time. Cheers, Mike -Original Message- Sent: Thursday, July 18, 2002 10:43 AM To: Multiple recipients of list ORACLE-L List, One of the DBA's here needs to migrate a fairly sizeable database from 8.1.6.0 to 8.1.7.2 on Solaris. The doc's state that it is advisable to migrate to 8.1.7.0 and then go to 8.1.7.2 but we don't have 8.1.7.0 installed and don't want to install it unless we really have to. Anyone know if it is possible to migrate directly to 8.1.7.2 (docs don't explicitly say it can't be done but don't seem to suggest it either). Ken -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
