Creating a Reporting Instance
Hiya folks, Task at hand is to create a reporting instance from an v8.0.4 beast (in structure, not size) originating from ISAM. We need to replicate the main transaction tables (30 in all) + reference tables. All will receive I, U and D activity. Seems to me quite an easy solution to use simple snapshots/snapshot logs and be done with it. A colleague, however, questioned why we need snapshot logs and interference w/the PROD instance. Fair enough I guess. The reason behind the logs was easy to refute, but the whether we have other non-intrusive methods didn't roll off my tongue as well as I would have liked it to have. Some options I came up with: - Transportable tablespaces - Log Miner - Shareplex - cloning - RO standby ... The question I have is what other options have others tried/implemented? And, for those of you w/DW experience (which I obviously do not have) - how do you handle the incremental transactions after initial population? Is it accepted practice to use triggers to feed scratch tables for ETL processes? What comes into play when restrictions on the prod instance are in place (ie: the config cannot change)? What sort of comparison routines are standard for an OLTP-Datamart/DW setup? Hope that all makes sense. My situation is not particularly complex, but I've no doubt others can provide handy insight. Cheers, Casey ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Casey Dyke 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: Listener problems
once clients are connected, you can shut down the listener... all that means is that no one else can connect once it is down. size of listener.log is OS dependent, it's just a file on disk. You can recreate it by shutting down the listener renaming or deleting the listener.log file starting up the listener --- Tatireddy, Shrinivas (MED, Keane) [EMAIL PROTECTED] wrote: Hi lists, I have some problem with my listener. That is resolved with the help of metalink. But I have a doubt in this regard. When I try to see the status, lsnrctl status 816LISTENER the statement hung for 10 minutes. I checked metalink and found the solution was, probably the size of listener.log is very big. So archive/remove it. In the mean time , this was resolved by another group of DBAs. In such a situations how to create another listener.log. If I stop/start the listener, this will affect the clients who are running trnx. how do i create another log. And how to know the size of listener.log (There is no parameter for this) is is o/s dependent? Thnx and regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Virtual NC on Solaris box
Hi lists, Does anybody using VNC (Virtual network computing) provided by ATT. Platform : Server solaris 5.6 Client : win 98 Can it be used instead of Xwindows? Does this work in a low speed networks? any ideas ? pros ? cons? Thnx and regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) 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).
extenal procedure listener and firewall
We have just installed a firewall and are now getting lots of ORA-28575: unable to open RPC connection to external procedure agent errors, although the listener appears to be running. Anyone else had this problem? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn 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).
How Can I get A sequence Current Value in PROC
Hi when writing a program PROC sequenceName.NEXTVAL points to the next value of a sequence, is there anything like sequenceName.SOMETHING that returns current value of sequence. Thanks E. __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ehsan sinavalda 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).
Find DBA users
Title: Find DBA users Hi! Is there a data dictionary view that gives me all users who have geen granted the DBA role? This is 8.1.7 on Sun Solaris. Thanks, Helmut
Re: extenal procedure listener and firewall
I memory serves me right I think that this is from using MTS, its problem is that it opens a random port number for the connection and that means that the remote user never see's that connection, Some firewalls are able to handle these connections but must are simple packet filtering and if the port is not in the list then a connection never gets through If you search the archives at fatcity.com you might find something HTH Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.Mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 -- Facsimile: +61 (0)7 3303 3048 John Dunn [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 26/11/2001 08:50 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:extenal procedure listener and firewall We have just installed a firewall and are now getting lots of ORA-28575: unable to open RPC connection to external procedure agent errors, although the listener appears to be running. Anyone else had this problem? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn 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). -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise.
List users planning to meet during Open world
Hi everyone, Are we planning any LIST USERS meeting (like at the IOUGa LIVE) during open world? Regards, Murali _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murali Vallath 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: Find DBA users
Title: Find DBA users Try select grantee from dba_role_privs where granted_role = 'DBA' John -Original Message-From: Daiminger, Helmut [mailto:[EMAIL PROTECTED]]Sent: 26 November 2001 12:10To: Multiple recipients of list ORACLE-LSubject: Find DBA users Hi! Is there a data dictionary view that gives me all users who have geen granted the DBA role? This is 8.1.7 on Sun Solaris. Thanks, Helmut ** This email and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium. **
Re: Find DBA users
Hi, Select grantee, granted_role from dba_role_privs where granted_role = 'DBA'; Jack Daiminger, Helmut [EMAIL PROTECTED]@fatcity.com on 26-11-2001 13:10:24 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Hi! Is there a data dictionary view that gives me all users who have geen granted the DBA role? This is 8.1.7 on Sun Solaris. Thanks, Helmut === De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor de geadresseerde. Gebruik van deze informatie door anderen dan de geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan. === The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Find DBA users
SELECT * FROM DBA_ROLE_PRIVS WHERE GRANTED_ROLE = 'DBA'; JP On Mon 26. November 2001 13:10, you wrote: Hi! Is there a data dictionary view that gives me all users who have geen granted the DBA role? This is 8.1.7 on Sun Solaris. Thanks, Helmut Content-Type: text/html; charset=iso-8859-1; name=Pøíloha: 1 Content-Transfer-Encoding: 7bit Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How Can I get A sequence Current Value in PROC
You can use another pseducolumn CURRVAL but you must use at least once per session the NEXTVAL before using the CURRVAL or else you would get the ORA-08002 error. ... SELECT your_sequence.CURRVAL INTO your_variable FROM dual; ... HTH Iulian -Original Message- Sent: Monday, November 26, 2001 2:50 PM To: Multiple recipients of list ORACLE-L ** This email has been tested for viruses by F-Secure Antivirus administered by IT Network Department. ** Hi when writing a program PROC sequenceName.NEXTVAL points to the next value of a sequence, is there anything like sequenceName.SOMETHING that returns current value of sequence. Thanks E. __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ehsan sinavalda 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). ** The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Mobil Rom is neither liable for the proper, complete transmission of the information contained in this communication nor any delay in its receipt. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: List users planning to meet during Open world
Hi, is there a way to get the size in MB of a particular table in my database ? Thank You, Gavin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gavin D'mello 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: Find DBA users
select * from dba_role_privs where granted_role = 'DBA'; Gints Plivna IT Sistçmas, Meríeïa 13, LV1050 Rîga http://www.itsystems.lv/gints/ Daiminger, Helmut Helmut.Daiminger@Kirch To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Gruppe.decc: Sent by: Subject: Find DBA users [EMAIL PROTECTED] 2001.11.26 14:10 Please respond to ORACLE-L Hi! Is there a data dictionary view that gives me all users who have geen granted the DBA role? This is 8.1.7 on Sun Solaris. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Listener problems
Title: RE: Listener problems The following script is one I pulled off from the list a few months ago and added a few lines. It is proving pretty useful. Note it uses the set option to redirect to a new output file John #!/bin/ksh # Script to copy out listener.log and compress it. ORACLE_BASE=/u01/app/oracle export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/8.1.6 export ORACLE_HOME PATH=$ORACLE_HOME/bin:/usr/local/bin:/bin:/usr/bin export PATH COMPRESSED_FILE=/u01/app/oracle/product/8.1.6/network/log/listener`date +%Y%m%d%H%M`.log lsnrctl set log_file /u01/app/oracle/product/8.1.6/network/log/listener2.log mv /u01/app/oracle/product/8.1.6/network/log/listener.log $COMPRESSED_FILE mv /u01/app/oracle/product/8.1.6/network/log/listener2.log /u01/app/oracle/product/8.1.6/network/log/listener.log lsnrctl set log_file /u01/app/oracle/product/8.1.6/network/log/listener.log compress $COMPRESSED_FILE # # now remove all compressed listener logs older than 10 days # find /u01/app/oracle/product/8.1.6/network/log/list*.Z -mtime +10 -print -exec rm {} \; A suitable crontab entry for the oracle account would be 00 19 * * * /home/oracle/tidy_listener_log.sh /home/oracle/tidy_listener_log.log 21 -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: 26 November 2001 09:30 To: Multiple recipients of list ORACLE-L Subject: Re: Listener problems once clients are connected, you can shut down the listener... all that means is that no one else can connect once it is down. size of listener.log is OS dependent, it's just a file on disk. You can recreate it by shutting down the listener renaming or deleting the listener.log file starting up the listener --- Tatireddy, Shrinivas (MED, Keane) [EMAIL PROTECTED] wrote: Hi lists, I have some problem with my listener. That is resolved with the help of metalink. But I have a doubt in this regard. When I try to see the status, lsnrctl status 816LISTENER the statement hung for 10 minutes. I checked metalink and found the solution was, probably the size of listener.log is very big. So archive/remove it. In the mean time , this was resolved by another group of DBAs. In such a situations how to create another listener.log. If I stop/start the listener, this will affect the clients who are running trnx. how do i create another log. And how to know the size of listener.log (There is no parameter for this) is is o/s dependent? Thnx and regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** This email and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium. **
RE: Find DBA users
Helmut, Try DBA_ROLE_PRIVS: select * from DBA_ROLE_PRIVS where granted_role = 'DBA'; HTH Mark -Original Message- Helmut Sent: 26 November 2001 12:10 To: Multiple recipients of list ORACLE-L Hi! Is there a data dictionary view that gives me all users who have geen granted the DBA role? This is 8.1.7 on Sun Solaris. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith 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: Find DBA users
Check view dba_sys_privs Mujeeb Chowdhry [EMAIL PROTECTED] 11/26/01 07:10AM Hi! Is there a data dictionary view that gives me all users who have geen granted the DBA role? This is 8.1.7 on Sun Solaris. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mujeeb Chowdhry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: List users planning to meet during Open world
Something like this will do the job: = spool table_space_usage.log set pagesize 0 set linesize 80 select substr (segment_name,1,20) ,bytes / 1024 kbytes ,extents ,blocks from sys.dba_segments where owner = 'LAWSON' and segment_name like 'AP%' and segment_type = 'TABLE' order by segment_name / spool off; Bill Gentry DBA Allina Health System Minneapolis, MN 55403 612-775-1190 [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 26, 2001 8:05 AM Hi, is there a way to get the size in MB of a particular table in my database ? Thank You, Gavin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gavin D'mello 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: Bill Gentry 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: Find DBA users
Title: Find DBA users select grantee from dba_role_privs where granted_role = 'DBA'; Dave -Original Message-From: Daiminger, Helmut [mailto:[EMAIL PROTECTED]]Sent: Monday, November 26, 2001 6:10 AMTo: Multiple recipients of list ORACLE-LSubject: Find DBA users Hi! Is there a data dictionary view that gives me all users who have geen granted the DBA role? This is 8.1.7 on Sun Solaris. Thanks, Helmut
RE: Find DBA users
Title: RE: Find DBA users [EMAIL PROTECTED] select grantee from dba_role_privs where granted_role='DBA'; GRANTEE -- SCOTT SYS SYSTEM [EMAIL PROTECTED] grant dba to nirmal; Grant succeeded. [EMAIL PROTECTED] select grantee from dba_role_privs where granted_role='DBA'; GRANTEE -- NIRMAL SCOTT SYS SYSTEM [EMAIL PROTECTED] HTH, Nirmal. -Original Message- From: Daiminger, Helmut [SMTP:[EMAIL PROTECTED]] Sent: Monday, November 26, 2001 3:10 PM To: Multiple recipients of list ORACLE-L Subject: Find DBA users Hi! Is there a data dictionary view that gives me all users who have geen granted the DBA role? This is 8.1.7 on Sun Solaris. Thanks, Helmut
RE: How Can I get A sequence Current Value in PROC
.CURRVAL Only works after .NEXTVAL Simon Fox -Original Message- Sent: 26 November 2001 12:50 To: Multiple recipients of list ORACLE-L Hi when writing a program PROC sequenceName.NEXTVAL points to the next value of a sequence, is there anything like sequenceName.SOMETHING that returns current value of sequence. Thanks E. __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ehsan sinavalda 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). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: FOX, Simon INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How Can I get A sequence Current Value in PROC
Yes, sequenceName.CURRVAL Note that this provides the current value for the session: i.e. the value that was last returned by NEXTVAL within that session. Therefore: 1. NEXTVAL must have been called at least once before in the session to define CURRVAL. 2. Even if NEXTVAL is called for the sequence in another session, CURRVAL in the original session will relate to the previous call to NEXTVAL in the original session - it does not increment. - Bill. At 04:50 26/11/01 -0800, you wrote: Hi when writing a program PROC sequenceName.NEXTVAL points to the next value of a sequence, is there anything like sequenceName.SOMETHING that returns current value of sequence. Thanks E. __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ehsan sinavalda 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: Bill Buchan 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: Morpheus killed my Oracle! Help!
I think he is on Windows platform. Sounds like it's a play machine since he can put Morpheus on it. One option is to simply change Oracle to listen on some other port. [EMAIL PROTECTED] 11/25/01 08:20PM Look in your /etc/services or inetd.conf file. It sounds like Morpheous still has a listener attached to the port and you need to remove the reverence to 1521. If inetd.conf needs editing you will need to send a kill -1 to the inetd process to re read the inetd.conf Cheers Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.Mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 --Facsimile: +61 (0)7 3303 3048 Csillag Zsolt [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 26/11/2001 09:00 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:Morpheus killed my Oracle! Help! Hi, I've installed Morpheus. Right after that I couldn't attach to Oracle ( 8.1i under Windows Nt), because the 1521 port was already used. (that's why the listener couldn't start) I uninstalled Morpheus but the port is still used. I've tried other ports but every one seems to be used. Thank you in advance Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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). -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: List users planning to meet during Open world
well, nothing official has been planned as yet I will be leaving for CA on Wednesday, and will probably go to nomail or digest mode on the list -- so if someone sets up a meeting will you PLEASE email me directly at this account? I will be checking email! Rachel --- Murali Vallath [EMAIL PROTECTED] wrote: Hi everyone, Are we planning any LIST USERS meeting (like at the IOUGa LIVE) during open world? Regards, Murali _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murali Vallath INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Find DBA users
Damn! And we were just talking about this earlier Jack!! You got there before me, but I already sent one off!! :) Hey - at least mine is at least a *little* different :P -Original Message- [EMAIL PROTECTED] Sent: 26 November 2001 13:25 To: Multiple recipients of list ORACLE-L Hi, Select grantee, granted_role from dba_role_privs where granted_role = 'DBA'; Jack Daiminger, Helmut [EMAIL PROTECTED]@fatcity.com on 26-11-2001 13:10:24 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Hi! Is there a data dictionary view that gives me all users who have geen granted the DBA role? This is 8.1.7 on Sun Solaris. Thanks, Helmut === De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor de geadresseerde. Gebruik van deze informatie door anderen dan de geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan. === The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How Can I get A sequence Current Value in PROC
Or I think you can query the dictionary SELECT last_number INTO your_variable FROM user_sequences WHERE sequence_name = UPPER(your_sequence) I don't know why it's necessary to use nextval, but they state this in the documentation. Iulian -Original Message- Sent: Monday, November 26, 2001 4:30 PM To: Multiple recipients of list ORACLE-L Does anyone know why Oracle forces you to use NEXTVAL before doing CURRVAL. I would think sometimes you would want to use CURRVAL without incrementing sequence first. Thanks Rick -Original Message- Sent: Monday, November 26, 2001 8:50 AM To: Multiple recipients of list ORACLE-L You can use another pseducolumn CURRVAL but you must use at least once per session the NEXTVAL before using the CURRVAL or else you would get the ORA-08002 error. ... SELECT your_sequence.CURRVAL INTO your_variable FROM dual; ... HTH Iulian -Original Message- Sent: Monday, November 26, 2001 2:50 PM To: Multiple recipients of list ORACLE-L ** This email has been tested for viruses by F-Secure Antivirus administered by IT Network Department. ** Hi when writing a program PROC sequenceName.NEXTVAL points to the next value of a sequence, is there anything like sequenceName.SOMETHING that returns current value of sequence. Thanks E. __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ehsan sinavalda 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). ** The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Mobil Rom is neither liable for the proper, complete transmission of the information contained in this communication nor any delay in its receipt. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How Can I get A sequence Current Value in PROC
I don't know But You can get last_number from dba/user_sequences view I just looked at this view and found some interesting results If sequence is nocache then it seems last_number really is the last number But if some sequence values are stored in cache then last number values are something like starting_value + n * increment_by * cache_size enjoy!!! :-) I don't know if it is written somewhere in the docs. Gints Plivna IT Sistçmas, Meríeïa 13, LV1050 Rîga http://www.itsystems.lv/gints/ Cale, Rick T (Richard)To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] RICHARD.T.CALE cc: @saic.comSubject: RE: How Can I get A sequence Current Value in PROC Sent by: [EMAIL PROTECTED] m 2001.11.26 16:30 Please respond to ORACLE-L Does anyone know why Oracle forces you to use NEXTVAL before doing CURRVAL. I would think sometimes you would want to use CURRVAL without incrementing sequence first. Thanks Rick -Original Message- Sent: Monday, November 26, 2001 8:50 AM To: Multiple recipients of list ORACLE-L You can use another pseducolumn CURRVAL but you must use at least once per session the NEXTVAL before using the CURRVAL or else you would get the ORA-08002 error. ... SELECT your_sequence.CURRVAL INTO your_variable FROM dual; ... HTH Iulian -Original Message- Sent: Monday, November 26, 2001 2:50 PM To: Multiple recipients of list ORACLE-L ** This email has been tested for viruses by F-Secure Antivirus administered by IT Network Department. ** Hi when writing a program PROC sequenceName.NEXTVAL points to the next value of a sequence, is there anything like sequenceName.SOMETHING that returns current value of sequence. Thanks E. __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ehsan sinavalda 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). ** The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Mobil Rom is neither liable for the proper, complete transmission of the information contained in this communication nor any delay in its receipt.
Re[2]: Two questions about PRO*C
If your going to do selects with dynamic SQL in Pro*C check out the SQLDA or SQL Descriptor area. I'll admit it's a pain to set up the first time, but thereafter it is mainly a cut paste operation. If you need an example let me know privately, it can get a little BIG. Dick Goulet Reply Separator Author: Stephane Faroult [EMAIL PROTECTED] Date: 11/22/2001 5:45 AM ehsan sinavalda wrote: Hi All 1- I have a (char *) that contains a SQL statement, Can I apply it to database from a PROC program. Yes, it's called dynamic SQL. EXECUTE IMMEDIATE is fine if it's DDL or hard-coded INSERT/UPDATE/DELETE. SELECTs are more or less complicated, depending on whether you already know the number and types of the items in the select list. The less you know about the statement, the more complicated it becomes. Check the demo programs. 2- How can I move a cursor to first record? Although OCI functions are beginning to have parameters pointing into the direction of scrolling back cursors (but so far only one direction is allowed, forwards), this is inherently unnatural to Oracle. Close the cursor and reopen it. -- Regards, Stephane Faroult Oriole Corporation Voice: +44 (0) 7050-696-269 Fax:+44 (0) 7050-696-449 Performance Tools Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Find DBA users
Helmut, Since you know enough to ask if there is a data dictionary view, might I suggest you also spend some time reviewing the reference manual which contains a list of all the data dictionary views and what information they contain? just a thought, people seem to have been in a good mood this morning, no one beat on you to read the manuals for yourself. Rachel --- Daiminger, Helmut [EMAIL PROTECTED] wrote: Hi! Is there a data dictionary view that gives me all users who have geen granted the DBA role? This is 8.1.7 on Sun Solaris. Thanks, Helmut __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How Can I get A sequence Current Value in PROC
Hi Yes. Try sequenceName.CURRVAL. Once you've retrieved a value, you can refer to this value as often as you want to with CURRVAL. Regards, Stefan ehsan sinavalda schrieb: Hi when writing a program PROC sequenceName.NEXTVAL points to the next value of a sequence, is there anything like sequenceName.SOMETHING that returns current value of sequence. Thanks E. __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ehsan sinavalda 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). - This Mail has been checked for Viruses Attention: Encrypted mails can NOT be checked! ** Diese Mail wurde auf Viren geprueft Hinweis: Verschluesselte mails koennen NICHT auf Viren geprueft werden! - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke 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: IOT and ora-600 [ktbgcur_2] on NT 81714
Bruce, This may not be related at all, but I sometimes get ORA-00600 [smbalo_1] on an IOT when the Analyze Table The_Table Estimate Statistics Sample x Percent statement is executed against it. The table gets truncated and repopulated nightly and has about 544,000 rows. What's weird is that a few weeks ago ... Sample 5 Percent would produce the error, but 4 and 6 percent wouldn't. Just last night 6 percent started producing the error and now only 3 percent or lower will work. I haven't pursued it with Oracle Support, since we're soon to move to a new Win2k server with 8.1.7.2.5 (we're currently on 8.1.6.0.0 under Win2k) and I'm hoping the problem will just go away. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Bruce (CALBBAY) Sent: Thursday, November 22, 2001 8:15 PM To: Multiple recipients of list ORACLE-L Hi, We are testing the use of IOTs getting ready to implement 1 in production. During some of the testing we have encountered an ora-600 [ktbgcur_2] in the alert log. This has been logged with Oracle support to get an explanation of what this means but in the meantime I was wondering if anyone else has come across this? The all important version information: Oracle 8.1.7.1.4 - Windows NT4, Quad processor server with parallel degree of default on all tables and indexes. From the alert log: Sun Nov 18 14:36:54 2001 Errors in file d:\oracle\admin\abcd\udump\ORA00657.TRC: ORA-00600: internal error code, arguments: [ktbgcur_2], [], [], [], [], [], [], [] From the user dump file (ora00657.trc mentioned above) *** 2001-11-18 14:36:54.843 ksedmp: internal or fatal error ORA-00600: internal error code, arguments: [ktbgcur_2], [], [], [], [], [], [], [] Current SQL statement for this session: SELECT ANLY_ANALYSIS,ELMN_ELEMENT,ELEMENT_PERCENTAGE FROM ANALYSIS_ELEMENTS WHERE ROWID=:1 FOR UPDATE OF ANLY_ANALYSIS NOWAIT - Call Stack Trace - Any feedback would be appreciated. Thanks, Bruce Reardon mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite 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: Find DBA users
Or get one of those big posters -Original Message- Sent: Monday, November 26, 2001 7:15 AM To: Multiple recipients of list ORACLE-L Helmut, Since you know enough to ask if there is a data dictionary view, might I suggest you also spend some time reviewing the reference manual which contains a list of all the data dictionary views and what information they contain? just a thought, people seem to have been in a good mood this morning, no one beat on you to read the manuals for yourself. Rachel --- Daiminger, Helmut [EMAIL PROTECTED] wrote: Hi! Is there a data dictionary view that gives me all users who have geen granted the DBA role? This is 8.1.7 on Sun Solaris. Thanks, Helmut __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith 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: Morpheus killed my Oracle! Help!
- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 26, 2001 01:00 I've installed Morpheus. Right after that I couldn't attach to Oracle ( 8.1i under Windows Nt), because the 1521 port was already used. (that's why the listener couldn't start) AFAIK Morpheus uses port 1214 and will not interfere with the listener I uninstalled Morpheus but the port is still used. I've tried other ports but every one seems to be used. could u clarify this? Marin ...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov 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: Find DBA users
Hi, My databases are running smooth, Euro testing is almost finished. I do have time to read my list-mail from the list :-). Playing around with Norad at the moment. My alerts should be sent to my mailbox i.s.o my website !! but this PC only has internet through the lan and no e-mail or modem attached. ah well we'll get it to work somehow. Jack Mark Leith [EMAIL PROTECTED]@fatcity.com on 26-11-2001 15:55:19 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Damn! And we were just talking about this earlier Jack!! You got there before me, but I already sent one off!! :) Hey - at least mine is at least a *little* different :P -Original Message- [EMAIL PROTECTED] Sent: 26 November 2001 13:25 To: Multiple recipients of list ORACLE-L Hi, Select grantee, granted_role from dba_role_privs where granted_role = 'DBA'; Jack Daiminger, Helmut [EMAIL PROTECTED]@fatcity.com on 26-11-2001 13:10:24 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Hi! Is there a data dictionary view that gives me all users who have geen granted the DBA role? This is 8.1.7 on Sun Solaris. Thanks, Helmut === De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor de geadresseerde. Gebruik van deze informatie door anderen dan de geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan. === The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). === De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor de geadresseerde. Gebruik van deze informatie door anderen dan de geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan. === The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. Ernst Young is neither liable for the proper and complete
RE: How Can I get A sequence Current Value in PROC
Afternoon, I had always assumed that this was because, before you get the next number for a sequence using NEXTVAL, there ISN'T a current value. There is only the last number generated, visible in the dictionary. NEXTVAL initialises the current value, setting it to (LAST_NUMBER + INCREMENT_BY). This becomes the current value to be used by that transaction. Other transactions that have not used NEXTVAL do not have a current value from that sequence (but can look at the value in the dictionary). Thanks, Harry Lowes Database Administrator, npower Northern Limited mailto:[EMAIL PROTECTED] -Original Message- Sent: 26 November 2001 15:00 To: Multiple recipients of list ORACLE-L Or I think you can query the dictionary SELECT last_number INTO your_variable FROM user_sequences WHERE sequence_name = UPPER(your_sequence) I don't know why it's necessary to use nextval, but they state this in the documentation. Iulian -Original Message- Sent: Monday, November 26, 2001 4:30 PM To: Multiple recipients of list ORACLE-L Does anyone know why Oracle forces you to use NEXTVAL before doing CURRVAL. I would think sometimes you would want to use CURRVAL without incrementing sequence first. Thanks Rick -Original Message- Sent: Monday, November 26, 2001 8:50 AM To: Multiple recipients of list ORACLE-L You can use another pseducolumn CURRVAL but you must use at least once per session the NEXTVAL before using the CURRVAL or else you would get the ORA-08002 error. ... SELECT your_sequence.CURRVAL INTO your_variable FROM dual; ... HTH Iulian -Original Message- Sent: Monday, November 26, 2001 2:50 PM To: Multiple recipients of list ORACLE-L ** This email has been tested for viruses by F-Secure Antivirus administered by IT Network Department. ** Hi when writing a program PROC sequenceName.NEXTVAL points to the next value of a sequence, is there anything like sequenceName.SOMETHING that returns current value of sequence. Thanks E. __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ehsan sinavalda 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). ** The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Mobil Rom is neither liable for the proper, complete transmission of the information contained in this communication nor any delay in its receipt. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) 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
Re: Find DBA users
Try : select grantee from dba_role_privs where granted_role = 'DBA' From: Daiminger, Helmut [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Find DBA users Date: Mon, 26 Nov 2001 04:10:24 -0800 Hi! Is there a data dictionary view that gives me all users who have geen granted the DBA role? This is 8.1.7 on Sun Solaris. Thanks, Helmut _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sunny Verghese 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: Find DBA users
Do you have an SMTP server that you can forward the alerts to? You could forward the alerts over your LAN to the mail server, to then forward to your internet email account? Have you tried using the EMAIL_USING_SMTP action? Another option is to install a server agent (if you don't already have one on another DBAs machine) on to a PC with an email client/modem, use a FORWARD action from your client to the alternate server agents alerter, then use the email action on any event that has originated from JACK.. The final option is to set up your PC properly :P HTH Mark -Original Message- [EMAIL PROTECTED] Sent: 26 November 2001 15:46 To: Multiple recipients of list ORACLE-L Hi, My databases are running smooth, Euro testing is almost finished. I do have time to read my list-mail from the list :-). Playing around with Norad at the moment. My alerts should be sent to my mailbox i.s.o my website !! but this PC only has internet through the lan and no e-mail or modem attached. ah well we'll get it to work somehow. Jack Mark Leith [EMAIL PROTECTED]@fatcity.com on 26-11-2001 15:55:19 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Damn! And we were just talking about this earlier Jack!! You got there before me, but I already sent one off!! :) Hey - at least mine is at least a *little* different :P -Original Message- [EMAIL PROTECTED] Sent: 26 November 2001 13:25 To: Multiple recipients of list ORACLE-L Hi, Select grantee, granted_role from dba_role_privs where granted_role = 'DBA'; Jack Daiminger, Helmut [EMAIL PROTECTED]@fatcity.com on 26-11-2001 13:10:24 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Hi! Is there a data dictionary view that gives me all users who have geen granted the DBA role? This is 8.1.7 on Sun Solaris. Thanks, Helmut === De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor de geadresseerde. Gebruik van deze informatie door anderen dan de geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan. === The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). === De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor de geadresseerde. Gebruik van deze informatie door anderen dan de geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is niet toegestaan. Ernst Young staat niet in
Latest classes12.zip
Hello All, Where can I ge the lates classes*.zip file ? I was looking all over metalink,technet and other oracle site... no luck.. Any help ;;; PLease Cheers RK
Re: Morpheus killed my Oracle! Help!
Hi, Unfortunatelly my Oracle runs under Windows Nt, so I have no inetd.conf :-( At 17:20 2001.11.25. -0800, you wrote: Look in your /etc/services or inetd.conf file. It sounds like Morpheous still has a listener attached to the port and you need to remove the reverence to 1521. If inetd.conf needs editing you will need to send a kill -1 to the inetd process to re read the inetd.conf Cheers Peter McLarty E-mail: [EMAIL PROTECTED] Technical Consultant WWW: http://www.Mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, Australia Mobile: +61 (0)402 094 238 -- Facsimile: +61 (0)7 3303 3048 Csillag Zsolt [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 26/11/2001 09:00 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject: Morpheus killed my Oracle! Help! Hi, I've installed Morpheus. Right after that I couldn't attach to Oracle ( 8.1i under Windows Nt), because the 1521 port was already used. (that's why the listener couldn't start) I uninstalled Morpheus but the port is still used. I've tried other ports but every one seems to be used. Thank you in advance Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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). -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Zsolt Csillag Hungary
RE: Standard Deviation
Peter - I did a quick search in www.google.com http://www.google.com , entering Oracle Standard Deviation, and turned up the fact that Oracle8i supports the STDDEV function. Enjoy. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 26, 2001 6:05 AM To: Multiple recipients of list ORACLE-L Hi I asked this earlier over on the ODTUG-SQLPLUS-L list, not much response I am working on a problem where I have rows of data and the structure includes 48 elements of data in each row on which i need to calculate the standard deviation for the 48 elements in that row. I currently have that data in a PL/SQL table in the form of one element to each row in that table as part of the overall package and could use this to calculate it. 1) Can I use stddev on a pl/sql table and if so what column name do I use in the stddev function. The column type in the PL/SQL table is Number. or 2) Do I need to write it out to a temp table and get it from that. TIA Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.Mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 --Facsimile: +61 (0)7 3303 3048 -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: A problem
There is no indication of the platform involved. On UNIX one can set an environment variable in a shell script EXPORT_DATE= `date + %d%m%y` export EXPORT_DATE and then use that variable in the Oracle export command's file directive. For instance, $ORACLE_HOME/BIN/exp file=name$EXPORT_DATE.dmp. The above does not include the century. There is a format marker for centuries, but it does not seem to work on our machines. I'm not sure what you want for name. In other words how does it vary from export to export, and are these variations in any order or completely random. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 21, 2001 8:25 AM To: Multiple recipients of list ORACLE-L -- Forwarded Message -- Date: Wed, 21 Nov 2001 15:34:27 +0100 I have created a job to export a user shema How can I tell Oracle each time it make the export to use lets say namedate.dmp I mean for example if today is 21.11.2001 the exported file whoud have name21112001.dmp or something like this... --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Latest classes12.zip
technet.oracle.com: Downloads -- Select Utility or driver -- Oracle JDBC drivers or from $ORACLE_HOME\jdbc\lib of your oracle installation hth, Marin "...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. " - Original Message - From: ASCI To: Multiple recipients of list ORACLE-L Sent: Monday, November 26, 2001 19:05 Subject: Latest classes12.zip Hello All, Where can I ge the lates classes*.zip file ? I was looking all over metalink,technet and other oracle site... no luck.. Any help ;;; PLease Cheers RK
create trigger and create any trigger
Is the CREATE ANY TRIGGER privilege required in order for a user to create a trigger on another user's table? Oracle8: The Complete Reference leads me to believe that all the user needs is the ALTER privilege for the table and the CREATE TRIGGER privilege. It seems to say that CREATE ANY TRIGGER is only required if the trigger is to be created in another schema. However, as USER1, I can't get the following to work without it: CREATE TRIGGER ABC AFTER INSERT ON USER2.DATA_READY FOR EACH ROW BEGIN return; END; SQL @t3.sql AFTER INSERT ON USER2.DATA_READY FOR EACH ROW * ERROR at line 2: ORA-00942: table or view does not exist Am I looking at this correctly? (I'm running 8.0.5.2.1 and all privileges on USER2.DATA_READY have been granted directly to USER1) Thanks. Kurt Wiegand IBM Global Services Cable Wireless Communications [EMAIL PROTECTED] 703 760-3619 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wiegand, Kurt 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: Standard Deviation
Ok, it sounds like you already know about the stddev function (since you mentioned it) and its 2 cousins. So it seems like what you are looking for is the best way to apply it to the data in your PL/SQL table, right? Here are some links to suggestions and workarounds for selecting from a PL/SQL table. You can use a function against a real PL/SQL table, or, you can create an SQL type, not PL/SQL type, and do some neat things. You can search for more examples while there. http://asktom.oracle.com/pls/ask/f?p=4950:8:285838::NO::F4950_P8_DISPLAYID:6 66224436920 http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:195057541 7033 And, if performance isn't absolutely critical, you could define an object type of number and hit the table again, returning each of the 48 columns as a separate row and applying the STDDEV function. Here is an example for transposing the columns into rows so that you can apply the function: SQL select * from sdev 2 / A1 A2 A3 -- -- -- 1 2 3 SQL create or replace type numlistt as table of number 2 / Type created. SQL select a.column_value foo 2 from the (select cast( numlistt(A1,A2,A3) as numlistt) from sdev) A 3 / FOO -- 1 2 3 1 select stddev(a.column_value) foo 2* from the (select cast( numlistt(A1,A2,A3) as numlistt) from sdev) A SQL / FOO -- 1 Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 -Original Message- [EMAIL PROTECTED] Sent: Monday, November 26, 2001 6:05 AM To: Multiple recipients of list ORACLE-L Hi I asked this earlier over on the ODTUG-SQLPLUS-L list, not much response I am working on a problem where I have rows of data and the structure includes 48 elements of data in each row on which i need to calculate the standard deviation for the 48 elements in that row. I currently have that data in a PL/SQL table in the form of one element to each row in that table as part of the overall package and could use this to calculate it. 1) Can I use stddev on a pl/sql table and if so what column name do I use in the stddev function. The column type in the PL/SQL table is Number. or 2) Do I need to write it out to a temp table and get it from that. TIA Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.Mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 --Facsimile: +61 (0)7 3303 3048 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Elkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle Arcserve
Title: Oracle Arcserve Anyone using Oracle with this CA (yack, yack) product? Any comments would be greatly appreciated. Please email me directly . Thanks Lisa Koivu Oracle Database Monkey Fairfield Resorts, Inc. 954-935-4117
archival log
Is there any way to prevent ARCH process from logging into SIDARCH.TRC file? I know, I can delete the file any time. But I want ARCH not to log at all. Igor Neyman, OCP DBA[EMAIL PROTECTED]
Oracle 9.0.1.1.1 on Win2k: stalls during installation: 85% Database Configuration Assistant
For that past few weeks, I have not for life of me been able to get Oracle 9.0.1.1.1 (free download) installed on my Win2k box. I can install it just fine on the same box inside of a Vmware WinXP Pro instance, or any other box, but not mine. Mine had Oracle 8.1.7 (Enterprise - not the free download) but I have uninstalled it. When I install Oracle 9.0.1.1.1 (using Personal), it goes fine until the screen where you select your database (General, Transactions, none, etc.). (No matter what I select) I click next, and it runs some calculations, the bar at the top gets to 85% Database Configuration Assistant and then locks up. My only option is to click the x in the top right and quit the installer. Since I can install it just fine on a new box, then I know that the reason this is happening has something to do with the sofwtare I already have installed. Can anyone recommend a course of action (rather than nuke-and-repave)? Thanks, Dan Browning -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dan Browning 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: poor parse/execute ratio.. next steps?
Doug - I would suggest that you start by trying to identify the worst offenders in your SQL code. If modifying the source code is an option, you can use Pareto's rule (80/20 principle) to identify the worst offenders. In my experience, the worst troublemakers are batch reports that can flood your SQL with non-reusable SQL that quickly ages out the good (reusable SQL). Individual screens where users enter the occasional query with non-bound variables Once you exhaust the options for modifying code, or if your situation won't let you use that option, take a look at the init.ora parameter cursor_sharing=force. Be sure to read the available notes on this because there are several caveats. This has been discussed several times on this list, so search the archives. Personally, I would try the manual option first, but I haven't tried the cursor_sharing=force alternative. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, November 23, 2001 5:00 PM To: Multiple recipients of list ORACLE-L 50% - pretty bad for a system that's been up for one week. I checked and found that there were a few cases, blatent, that bind variables weren't being used. What's the next step? Increase the shared pool? Is there any way I can monitor how often statements are being aged out? Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: X Win client
Vladimir...check out http://www.mcsr.olemiss.edu/computing/xwin32.html(it's FREE). May work for you depending on your needs. -Original Message-From: Vladimir Barac - posao [mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 21, 2001 4:41 AMTo: Multiple recipients of list ORACLE-LSubject: OT: X Win client Hi all! Is there any free (important: free) X client software for NT? Regards, Vladimir Barac
RE: Oracle 9.0.1.1.1 on Win2k: stalls during installation: 85% Database Configuration Assistant
Tom, Thank you so much! I will report back with the results. Dan Browning Kavod Technologies -Original Message- From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]] Sent: Monday, November 26, 2001 11:21 AM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: RE: Oracle 9.0.1.1.1 on Win2k: stalls during installation: 85% Database Configuration Assistant Dan, It sounds like the 817 install left some trash around. If I were you, I would go into the registry and remove all traces of Oracle. Then, reboot the win2k box and try your install again. Attached is the Create a clean machine document that I obtained a few years back from an Oracle install disk. I have used it many times, and it *always* solves install problems on NT for me. The trick is to remove all traces, and reboot to make sure that all dll's have been purged from the system. Hope this helps! Tom Mercadante Oracle Certified Professional -Original Message- From: Dan Browning [mailto:[EMAIL PROTECTED]] Sent: Monday, November 26, 2001 1:55 PM To: Multiple recipients of list ORACLE-L Subject: Oracle 9.0.1.1.1 on Win2k: stalls during installation: 85% Database Configuration Assistant For that past few weeks, I have not for life of me been able to get Oracle 9.0.1.1.1 (free download) installed on my Win2k box. I can install it just fine on the same box inside of a Vmware WinXP Pro instance, or any other box, but not mine. Mine had Oracle 8.1.7 (Enterprise - not the free download) but I have uninstalled it. When I install Oracle 9.0.1.1.1 (using Personal), it goes fine until the screen where you select your database (General, Transactions, none, etc.). (No matter what I select) I click next, and it runs some calculations, the bar at the top gets to 85% Database Configuration Assistant and then locks up. My only option is to click the x in the top right and quit the installer. Since I can install it just fine on a new box, then I know that the reason this is happening has something to do with the sofwtare I already have installed. Can anyone recommend a course of action (rather than nuke-and-repave)? Thanks, Dan Browning -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dan Browning 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: Dan Browning 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: Creating a Reporting Instance
Whoops - rereading this and I notice I state All will receive I, U and D activity. One responder questioned how I could do this w/RO snapshots. Obviously can't. The point I meant to make is I have to manage an initial population of data and then the changes. Fast refresh would be my preference - hence the logs. So, the method I'm leaning toward is simple RO snapshots w/fast refresh. No updateable snapshots required. There is overhead (an extra insert at least) on the PROD instance associated w/snapshot logs, likewise triggers if I use them. My question is simply what do others do to avoid this overhead (if anything) when handling incremental DML? I can only assume that in very high transaction environments, the logs/trigger approach would reduce commit time and, in turn, application performance. Does this present concern to some? Any and all comments much appreciated ... and thanks Mark for pointing out my err ... :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Casey Dyke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9.0.1.1.1 on Win2k: stalls during installation: 85% D
Dan, It sounds like the 817 install left some trash around. If I were you, I would go into the registry and remove all traces of Oracle. Then, reboot the win2k box and try your install again. Attached is the Create a clean machine document that I obtained a few years back from an Oracle install disk. I have used it many times, and it *always* solves install problems on NT for me. The trick is to remove all traces, and reboot to make sure that all dll's have been purged from the system. Hope this helps! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, November 26, 2001 1:55 PM To: Multiple recipients of list ORACLE-L Database Configuration Assistant For that past few weeks, I have not for life of me been able to get Oracle 9.0.1.1.1 (free download) installed on my Win2k box. I can install it just fine on the same box inside of a Vmware WinXP Pro instance, or any other box, but not mine. Mine had Oracle 8.1.7 (Enterprise - not the free download) but I have uninstalled it. When I install Oracle 9.0.1.1.1 (using Personal), it goes fine until the screen where you select your database (General, Transactions, none, etc.). (No matter what I select) I click next, and it runs some calculations, the bar at the top gets to 85% Database Configuration Assistant and then locks up. My only option is to click the x in the top right and quit the installer. Since I can install it just fine on a new box, then I know that the reason this is happening has something to do with the sofwtare I already have installed. Can anyone recommend a course of action (rather than nuke-and-repave)? Thanks, Dan Browning -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dan Browning 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). Creating a Clean Machine.doc Description: MS-Word document
RE: Oracle 9.0.1.1.1 on Win2k: stalls during installation: 85% Database Configuration Assistant
It worked great. Thanks! Dan Browning Kavod Technologies -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Dan Browning Sent: Monday, November 26, 2001 11:26 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle 9.0.1.1.1 on Win2k: stalls during installation: 85% Database Configuration Assistant Tom, Thank you so much! I will report back with the results. Dan Browning Kavod Technologies -Original Message- From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]] Sent: Monday, November 26, 2001 11:21 AM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: RE: Oracle 9.0.1.1.1 on Win2k: stalls during installation: 85% Database Configuration Assistant Dan, It sounds like the 817 install left some trash around. If I were you, I would go into the registry and remove all traces of Oracle. Then, reboot the win2k box and try your install again. Attached is the Create a clean machine document that I obtained a few years back from an Oracle install disk. I have used it many times, and it *always* solves install problems on NT for me. The trick is to remove all traces, and reboot to make sure that all dll's have been purged from the system. Hope this helps! Tom Mercadante Oracle Certified Professional -Original Message- From: Dan Browning [mailto:[EMAIL PROTECTED]] Sent: Monday, November 26, 2001 1:55 PM To: Multiple recipients of list ORACLE-L Subject: Oracle 9.0.1.1.1 on Win2k: stalls during installation: 85% Database Configuration Assistant For that past few weeks, I have not for life of me been able to get Oracle 9.0.1.1.1 (free download) installed on my Win2k box. I can install it just fine on the same box inside of a Vmware WinXP Pro instance, or any other box, but not mine. Mine had Oracle 8.1.7 (Enterprise - not the free download) but I have uninstalled it. When I install Oracle 9.0.1.1.1 (using Personal), it goes fine until the screen where you select your database (General, Transactions, none, etc.). (No matter what I select) I click next, and it runs some calculations, the bar at the top gets to 85% Database Configuration Assistant and then locks up. My only option is to click the x in the top right and quit the installer. Since I can install it just fine on a new box, then I know that the reason this is happening has something to do with the sofwtare I already have installed. Can anyone recommend a course of action (rather than nuke-and-repave)? Thanks, Dan Browning -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dan Browning 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: Dan Browning 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: Dan Browning 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: Morpheus killed my Oracle! Help!
Hi, I don't know what Morpheous is, but have you tried netstat -an to find out which ports really are in use. For example on my notebook: rem no listener running H:\netstat -an | find 1521 H:\ H:\lsnrctl start rem and the listener output was here. The command completed successfully H:\netstat -an | find 1521 TCP0.0.0.0:1521 0.0.0.0:0 LISTENING H:\ so after listener was running I have something listening on port 1521. Does your winnt\system32\drivers\etc\services file get updated by Morpheous? If so, maybe it will tell you what ports are used. When you try to start the listener service what gets written into the listener log file? HTH, Bruce Reardon -Original Message- Sent: Tuesday, 27 November 2001 4:20 Hi, Unfortunatelly my Oracle runs under Windows Nt, so I have no inetd.conf :-( At 17:20 2001.11.25. -0800, you wrote: Look in your /etc/services or inetd.conf file. It sounds like Morpheous still has a listener attached to the port and you need to remove the reverence to 1521. If inetd.conf needs editing you will need to send a kill -1 to the inetd process to re read the inetd.conf Cheers Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.Mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 --Facsimile: +61 (0)7 3303 3048 Csillag Zsolt [EMAIL PROTECTED] 26/11/2001 09:00 AM Subject:Morpheus killed my Oracle! Help! Hi, I've installed Morpheus. Right after that I couldn't attach to Oracle ( 8.1i under Windows Nt), because the 1521 port was already used. (that's why the listener couldn't start) I uninstalled Morpheus but the port is still used. I've tried other ports but every one seems to be used. Thank you in advance Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
rman question
Title: rman question OK, this may be dumb. I was under the impression that if you use rman to back up your database, you MUST use rman to restore and recover. Is this not true? Is it possible to utilize rman for restore and sign in to sql*plus or svrmgrl to initiate the recovery? Any comments are appreciated. THanks Lisa Koivu Oracle Database Monkey Fairfield Resorts, Inc. 954-935-4117
RE: import
Oto, You will need to set the operating system environment variable NLS_LANG to the one that was used for the export. (Just go back to the source system and type in 'echo $NLS_LANG' and set the same value). This is *only* in case you have NOT used the DIRECT=Y option - if you exported using the direct method, you will need to export normal again and use this bypass. This is because the Oracle kernel needs to be able to preserve the character set across export/import, and DIRECT=Y avoids this translation buffer during export. John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Kill your killer-commute! Listen to great commercial-free christian music 24x7 (details at www.klove.com) ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: Moucka otakar [mailto:[EMAIL PROTECTED]] Sent: Friday, November 23, 2001 5:40 AM To: Multiple recipients of list ORACLE-L Subject: import Hello listers, I have problem with character encoding during import using imp. Error code is .. IMP-00016: required character set conversion (type 1 to 871) not supported . My question is : What is syntax for import with settings charset ? Database charaset is UTF8. Thanx Oto -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Moucka otakar 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: 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).
RMAN
Hi Does any one have RMAN hotbackup script withour catalog? If yes can you please send me. Thanks seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Unix Oracle Processes
Hi, Thanks for your help. I solved the problem. For some insane and unknown reason all the oracle processes (ie smon, pmon lgwr etc) were stuck! I restarted the server and it worked fine. I don't know why they were stuck! Regards, Sujatha -Original Message- Sent: Monday, 26 November 2001 4:55 PM To: Multiple recipients of list ORACLE-L Hi I am not sure if I have understood ur problem but can u please try this 1. cd $ORACLE_HOME/dbs 2. ls -alt lk*.ora 3. if there is any file by the name lkdb_name.ora where db_name is the database name and NOT SID then try removing this file and starting up the database again. do this ONLY if this database is NOT a. standby or b. Oracle parallel sever ( init.ora does NOT have any parallel server parameters!) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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: Sujatha Madan 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: rman question
Lisa, You must use RMAN for restore as the format of the backup pieces can be understood only by RMAN. Since RMAN is an Oracle - internal process, it reads the database a *DB* block (or multiples thereof) at a time, rather than the OS read an *OS* block at at time which could result in fractured reads (which in turn necessitates full block redo logging during Hot backup mode). This also means that RMAN can recognize empty blocks and thus skip backup of these blocks - resulting in a small backup set in the beginning that grows with database usage and activity... Lots of interesting stuff / concepts can be found in the Recovery Manager user's guide and reference - a must read if you are planning to user RMAN. Hth, John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Kill your killer-commute! Listen to great commercial-free christian music 24x7 (details at www.klove.com) ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- Sent: Monday, November 26, 2001 1:05 PM To: Multiple recipients of list ORACLE-L OK, this may be dumb. I was under the impression that if you use rman to back up your database, you MUST use rman to restore and recover. Is this not true? Is it possible to utilize rman for restore and sign in to sql*plus or svrmgrl to initiate the recovery? Any comments are appreciated. THanks Lisa Koivu Oracle Database Monkey Fairfield Resorts, Inc. 954-935-4117 -- 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).
RE: RE: Unix Oracle Processes
Sujatha: I've seen this happen before under these circumstances: 1) The DB is up and running, started by the Oracle owner. 2) A UNIX user who is a member of the DBA group starts svrmgrl and tries to start the same instance. Now suddenly there are two sets of processes for that instance. One is the real database instance and the other is in some unknown wierd state, and the DBA is confused. This is all the more reason to keep the members of the DBA group to a minimum. HTH, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation (909) 914-2304 -Original Message- Sent: Monday, November 26, 2001 1:40 PM To: Multiple recipients of list ORACLE-L Hi, Thanks for your help. I solved the problem. For some insane and unknown reason all the oracle processes (ie smon, pmon lgwr etc) were stuck! I restarted the server and it worked fine. I don't know why they were stuck! -- 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: rman question
Title: rman question If You use RMAN to backup, you MUST use RMAN to restore. Once it is restored to the regular files, you may use Svrmgrl to recover if this is comfortable to you. But, recovery thru RMAN is easy, just one/two additional commands.Svrmgrl is not avaialble from Oracle 9 onwards! -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Monday, November 26, 2001 1:05 PMTo: Multiple recipients of list ORACLE-LSubject: rman question OK, this may be dumb. I was under the impression that if you use rman to back up your database, you MUST use rman to restore and recover. Is this not true? Is it possible to utilize rman for restore and sign in to sql*plus or svrmgrl to initiate the recovery? Any comments are appreciated. THanks Lisa Koivu Oracle Database Monkey Fairfield Resorts, Inc. 954-935-4117
ACM SIGMOD-papers of interest #1
Well, I'm way behind on my reading so I am just finishing a quick (?) skim of the May proceedings of the 2001 ACM SIGMOD Conference on Management of Data. There is some interesting stuff in there so I thought I would try to review some of the high points I found. ACM SIGMOD is the Special Interest Group on Management of Data from the Association for Computing Machinery. You can join for just $20 and get totally swamped with CDs and publications. (www.acm.org) There are a few interesting articles. This is installment #1 DBMSs On A Modern Processor: Where Does Time Go? (http://www-2.cs.cmu.edu/~natassa/papers/vldb99_paper.pdf) Anastassia Ailamaki, David J. DeWitt, Mark D. Hill, David A. Wood University of Wisconsin - Madison from Proceedings of the 25th VLDB Conference, 1999 This paper was actually referenced in a paper from ACM SIGMOD 2001 (Improving Index Performance through Prefetching) The main point is that even as we concentrate on increasing performance by tuning IO, the hit from processor cache misses is becoming more important. The increasing gap between processor speed and DRAM/disk speeds is accentuating this problem. Most DBMSs focus on caching data in main memory (buffer cache), but this ignores the caching of main memory in level 1 and level 2 processor caches. Cache misses can account for 50% of execution time. In this paper, the authors examine four commercial (unnamed) DBMSs running on a 6400 PII Intel Xeon/MT Workstation running Windows NT v4.0. The focus is on the memory interactions, so to reduce IO effects, a memory resident database is used (the buffer pool was large enough to hold the datasets for the queries). Almost half the execution time was spent on stalls. The breakdown is as follows: * 90% of the stalls are from: -second-level cache data misses -first -level cache instruction misses * 20% of the stalls are from subtle implemention details (e.g. branch misdirection) Analysis was done using simple queries (sequential range, index range, sequential join). The results were compared to TPC-D (and TPC-C?) benchmarks which yielded similar results. It thus appears reasonable to scale the conclusions of this simple methodology to more complex scenarios. DETAILS Query time = computation time + memory stalls + branch misdirection overhead + resource related stalls - overlap (some work can be done while waiting for a stall). Computation time is usually less than 1/2 of the execution time. Since memory access times decrease more slowly than processor clock speeds, the computation time componant will continue to decrease. Most of the workload is also seen to be latency, not bandwidth bound (latency - how long it takes. bandwidth - how much you can do in a given time. If you are latency bound, adding more processors won't help as the information isn't getting there fast enough. [summarized from In Search of Clusters. thanks Ross]) Memory stall times vary more across different query types than across different DBMSs. Memory stall is the most significant one of the three major stall types. The bulk of the memory stall is from L1-information cache and L2-data cache. It is possible, however, that tuning for one or two of the stall types will just shift the bottleneck to the remaining stalls. Memory stalls are also dependent on increasing record size [locality of data]. Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henry Poras 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).
Disabling Constraints
I need to disable some constraints to load table data for my DB conversion. I cannot find the syntax to do this. I think it should be ALTER TABLE something. Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Unix Oracle Processes
Hi, Thanks. I think that is exactly what happened. Someone has tried to shutdown and startup the database logged in as the root user. It screwed things up a bit ... but now they seem fine. Cheers, Sujatha -Original Message- Sent: Tuesday, 27 November 2001 9:25 AM To: Multiple recipients of list ORACLE-L Sujatha: I've seen this happen before under these circumstances: 1) The DB is up and running, started by the Oracle owner. 2) A UNIX user who is a member of the DBA group starts svrmgrl and tries to start the same instance. Now suddenly there are two sets of processes for that instance. One is the real database instance and the other is in some unknown wierd state, and the DBA is confused. This is all the more reason to keep the members of the DBA group to a minimum. HTH, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation (909) 914-2304 -Original Message- Sent: Monday, November 26, 2001 1:40 PM To: Multiple recipients of list ORACLE-L Hi, Thanks for your help. I solved the problem. For some insane and unknown reason all the oracle processes (ie smon, pmon lgwr etc) were stuck! I restarted the server and it worked fine. I don't know why they were stuck! -- 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: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
? ORA-04031
hello ... i got the following error from a full export ... . exporting posttables actions EXP-8: ORACLE error 4031 encountered ORA-04031: unable to allocate 4080 bytes of shared memory (shared pool,DBMS_REPCAT,PL/SQL MPCODE,B AMIMA: Bam Buffer) ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at line 1 ORA-06512: at SYS.DBMS_SYS_SQL, line 781 ORA-06512: at SYS.DBMS_SQL, line 316 ORA-06512: at SYS.DBMS_EXPORT_EXTENSION, line 82 ORA-06512: at SYS.DBMS_EXPORT_EXTENSION, line 133 ORA-06512: at line 1 EXP-0: Export terminated unsuccessfully i think it might have something to do with some failed rman backups, and the shared memory segments not being freed up ... but i would appreciate your help in resolving this problem ... thank you in advance ... Nechama Glasrot Oracle DBA Seisint, Inc. 6601 Park of Commerce Blvd. Boca Raton, Florida 33487 [EMAIL PROTECTED] Direct 561.999.3977 Main 561.999.4400 Fax 561.999.4695 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glasrot, Nechama 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: rman question
Title: rman question Hi, Your initial statement is correct. If you use rman to backup, you must use it to restore/recover. All the rman backup sets are understandable only by rman. Cheers Sujatha -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, 27 November 2001 8:05 AMTo: Multiple recipients of list ORACLE-LSubject: rman question OK, this may be dumb. I was under the impression that if you use rman to back up your database, you MUST use rman to restore and recover. Is this not true? Is it possible to utilize rman for restore and sign in to sql*plus or svrmgrl to initiate the recovery? Any comments are appreciated. THanks Lisa Koivu Oracle Database Monkey Fairfield Resorts, Inc. 954-935-4117
Re: rman question
Yes, That is, you can do both, let RMAN do it for you or apply the logs after restoring them. anjan "Koivu, Lisa" wrote: OK, this may be dumb. I was under the impression that if you use rman to back up your database, you MUST use rman to restore and recover. Is this not true? Is it possible to utilize rman for restore and sign in to sql*plus or svrmgrl to initiate the recovery? Any comments are appreciated. THanks Lisa Koivu Oracle Database Monkey Fairfield Resorts, Inc. 954-935-4117 begin:vcard n:Thakuria;Anjan tel;work:817-963-3291 x-mozilla-html:TRUE url:www.eds.com org:EDS;Midrange Database Engineering adr:;;;Fort Worth;Texas;76155;U.S.A version:2.1 email;internet:[EMAIL PROTECTED] title:Infrastructure Specialist fn:Anjan Thakuria end:vcard
Re: RMAN
Seema, there are examples in the manual. Anjan Seema Singh wrote: Hi Does any one have RMAN hotbackup script withour catalog? If yes can you please send me. Thanks seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). begin:vcard n:Thakuria;Anjan tel;work:817-963-3291 x-mozilla-html:TRUE url:www.eds.com org:EDS;Midrange Database Engineering adr:;;;Fort Worth;Texas;76155;U.S.A version:2.1 email;internet:[EMAIL PROTECTED] title:Infrastructure Specialist fn:Anjan Thakuria end:vcard
RE: Morpheus killed my Oracle! Help!
Hi, At 20:34 2001.11.26. +, you wrote: Hi, I don't know what Morpheous is, but have you tried netstat -an to find out which ports really are in use. For example on my notebook: rem no listener running When I type netstat then: TCP nt:1025 localhost:026 ESTABLISHED TCP nt:1026 localhost:025 ESTABLISHED TCP nt:1076 10.0.0.17:1521 SYN_SENT My listener.log contains: Megfigyelési kisérlet a következon: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=nt)(PORT=1521))(PROTOCOL_STACK=(PRESENTATION=GIOP)(SESSION=RAW))) TNS-12542: TNS: ezt a címet már más használja - This address is being used TNS-12560: TNS: protokoll adapter hiba TNS-00512: Ezt a címet már más használja 32-bit Windows Error: 48: Unknown error Thank you H:\netstat -an | find 1521 H:\ H:\lsnrctl start rem and the listener output was here. The command completed successfully H:\netstat -an | find 1521 TCP0.0.0.0:1521 0.0.0.0:0 LISTENING H:\ so after listener was running I have something listening on port 1521. Does your winnt\system32\drivers\etc\services file get updated by Morpheous? If so, maybe it will tell you what ports are used. When you try to start the listener service what gets written into the listener log file? HTH, Bruce Reardon - Csillag Zsolt [EMAIL PROTECTED] 26/11/2001 09:00 AM Subject:Morpheus killed my Oracle! Help! Hi, I've installed Morpheus. Right after that I couldn't attach to Oracle ( 8.1i under Windows Nt), because the 1521 port was already used. (that's why the listener couldn't start) I uninstalled Morpheus but the port is still used. I've tried other ports but every one seems to be used. Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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: Disabling Constraints
To disable a constraint: alter table table-name disable constraint constraint-name ; should do the trick. Assuming you don't have any constraint violations, the following should work just fine to enable the constraint: alter table table-name enable constraint constraint-name ; Kent At 02:31 PM 11/26/01 -0800, you wrote: I need to disable some constraints to load table data for my DB conversion. I cannot find the syntax to do this. I think it should be ALTER TABLE something. Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz 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: Kent Wayson 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).
Buffer Busy Waits -- Sanity check please
Title: Buffer Busy Waits -- Sanity check please We recently had a new website go live. Since then, I'm seeing constant buffer busy waits and after a period of time, I see sessions hung on the same block#. The SQL query is always a COUNT(*) (below). It's almost as though one session has a lock of some sort in the buffer cache and other sessions are blocked. Although, I've checked and there's no DML ongoing, so I'm unsure as to why we would see this. Note that v$session shows 78 and 393 to be INACTIVE, while 159 is ACTIVE. So it's like 159 can't write to the buffer cache because 78 and 393 have a lock there. Note that these are all defined as persistent connections, via the Vignette front-end. I'm sure all the clues are there but my brain is too fuzzed to piece it together. SID SQL_TEXT O/S User - --- 159 SELECT COUNT(*) NUM,SUM(TOTAL_CHARGE_AMT) TOT FROM BBN.BBN_SRV vignette 159 _PAID_WARR_CLAIM WHERE CUSTOMER_ID = :b1 AND ENTERPRISE_CD = : vignette 159 b2 AND (CHECK_ID IS NOT NULL AND CHECK_ID != 'PENDING' ) vignette SID EVENT P1TEXT P1 P2TEXT P2 P3TEXT P3 - -- -- --- -- - -- 78 buffer busy waits file# 72 block# 109177 id 130 393 buffer busy waits file# 72 block# 109177 id 130 159 db file scattered read file# 72 block# 109177 blocks 8 Jeffery D Thomas DBA Thomson Information Services Thomson multimedia Inc. Email: [EMAIL PROTECTED] DBA Quickplace: http://gkmqp.tce.com/tis_dba
RE: Buffer Busy Waits -- Sanity check please
Title: Buffer Busy Waits -- Sanity check please Check what segment owns this block: file# 72 block# 109177 This could help finding the way to approach this problem. -Original Message-From: Thomas Jeff [mailto:[EMAIL PROTECTED]]Sent: Monday, November 26, 2001 6:21 PMTo: Multiple recipients of list ORACLE-LSubject: Buffer Busy Waits -- Sanity check please We recently had a new website go live. Since then, I'm seeing constant buffer busy waits and after a period of time, I see sessions hung on the same block#. The SQL query is always a COUNT(*) (below). It's almost as though one session has a lock of some sort in the buffer cache and other sessions are blocked. Although, I've checked and there's no DML ongoing, so I'm unsure as to why we would see this. Note that v$session shows 78 and 393 to be INACTIVE, while 159 is ACTIVE. So it's like 159 can't write to the buffer cache because 78 and 393 have a lock there. Note that these are all defined as persistent connections, via the Vignette front-end. I'm sure all the clues are there but my brain is too fuzzed to piece it together. SID SQL_TEXT O/S User - --- 159 SELECT COUNT(*) NUM,SUM(TOTAL_CHARGE_AMT) TOT FROM BBN.BBN_SRV vignette 159 _PAID_WARR_CLAIM WHERE CUSTOMER_ID = :b1 AND ENTERPRISE_CD = : vignette 159 b2 AND (CHECK_ID IS NOT NULL AND CHECK_ID != 'PENDING' ) vignette SID EVENT P1TEXT P1 P2TEXT P2 P3TEXT P3 - -- -- --- -- - -- 78 buffer busy waits file# 72 block# 109177 id 130 393 buffer busy waits file# 72 block# 109177 id 130 159 db file scattered read file# 72 block# 109177 blocks 8 Jeffery D Thomas DBA Thomson Information Services Thomson multimedia Inc. Email: [EMAIL PROTECTED] DBA Quickplace: http://gkmqp.tce.com/tis_dba
Re: ACM SIGMOD-papers of interest #1
Interesting stuff, thanks Henry. For those of you techheads that don't yet have a copy of 'Scaling Oracle 8i', it's full of architectural info that will help you understand this stuff. Good bedtime reading. :) Jared Henry Poras Henry.Poras@c To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] tp.com cc: Sent by: Subject: ACM SIGMOD-papers of interest #1 [EMAIL PROTECTED] om 11/26/01 02:31 PM Please respond to ORACLE-L Well, I'm way behind on my reading so I am just finishing a quick (?) skim of the May proceedings of the 2001 ACM SIGMOD Conference on Management of Data. There is some interesting stuff in there so I thought I would try to review some of the high points I found. ACM SIGMOD is the Special Interest Group on Management of Data from the Association for Computing Machinery. You can join for just $20 and get totally swamped with CDs and publications. (www.acm.org) There are a few interesting articles. This is installment #1 DBMSs On A Modern Processor: Where Does Time Go? (http://www-2.cs.cmu.edu/~natassa/papers/vldb99_paper.pdf) Anastassia Ailamaki, David J. DeWitt, Mark D. Hill, David A. Wood University of Wisconsin - Madison from Proceedings of the 25th VLDB Conference, 1999 This paper was actually referenced in a paper from ACM SIGMOD 2001 (Improving Index Performance through Prefetching) The main point is that even as we concentrate on increasing performance by tuning IO, the hit from processor cache misses is becoming more important. The increasing gap between processor speed and DRAM/disk speeds is accentuating this problem. Most DBMSs focus on caching data in main memory (buffer cache), but this ignores the caching of main memory in level 1 and level 2 processor caches. Cache misses can account for 50% of execution time. In this paper, the authors examine four commercial (unnamed) DBMSs running on a 6400 PII Intel Xeon/MT Workstation running Windows NT v4.0. The focus is on the memory interactions, so to reduce IO effects, a memory resident database is used (the buffer pool was large enough to hold the datasets for the queries). Almost half the execution time was spent on stalls. The breakdown is as follows: * 90% of the stalls are from: -second-level cache data misses -first -level cache instruction misses * 20% of the stalls are from subtle implemention details (e.g. branch misdirection) Analysis was done using simple queries (sequential range, index range, sequential join). The results were compared to TPC-D (and TPC-C?) benchmarks which yielded similar results. It thus appears reasonable to scale the conclusions of this simple methodology to more complex scenarios. DETAILS Query time = computation time + memory stalls + branch misdirection overhead + resource related stalls - overlap (some work can be done while waiting for a stall). Computation time is usually less than 1/2 of the execution time. Since memory access times decrease more slowly than processor clock speeds, the computation time componant will continue to decrease. Most of the workload is also seen to be latency, not bandwidth bound (latency - how long it takes. bandwidth - how much you can do in a given time. If you are latency bound, adding more processors won't help as the information isn't getting there fast enough. [summarized from In Search of Clusters. thanks Ross]) Memory stall times vary more across different query
Re: ACM SIGMOD-papers of interest #1
--- [EMAIL PROTECTED] wrote: Interesting stuff, thanks Henry. For those of you techheads that don't yet have a copy of 'Scaling Oracle 8i', it's full of architectural info that will help you understand this stuff. Good bedtime reading. :) gotta get you a life Jared :) __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ACM SIGMOD-papers of interest #1
On Monday 26 November 2001 19:15, Rachel Carmichael wrote: For those of you techheads that don't yet have a copy of 'Scaling Oracle 8i', it's full of architectural info that will help you understand this stuff. Good bedtime reading. :) gotta get you a life Jared :) Huh? What's that? -- 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: poor parse/execute ratio.. next steps?
Thanks... will do On Mon, 26 Nov 2001 11:10:39 -0800, you wrote: Doug - I would suggest that you start by trying to identify the worst offenders in your SQL code. If modifying the source code is an option, you can use Pareto's rule (80/20 principle) to identify the worst offenders. In my experience, the worst troublemakers are batch reports that can flood your SQL with non-reusable SQL that quickly ages out the good (reusable SQL). Individual screens where users enter the occasional query with non-bound variables Once you exhaust the options for modifying code, or if your situation won't let you use that option, take a look at the init.ora parameter cursor_sharing=force. Be sure to read the available notes on this because there are several caveats. This has been discussed several times on this list, so search the archives. Personally, I would try the manual option first, but I haven't tried the cursor_sharing=force alternative. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, November 23, 2001 5:00 PM To: Multiple recipients of list ORACLE-L 50% - pretty bad for a system that's been up for one week. I checked and found that there were a few cases, blatent, that bind variables weren't being used. What's the next step? Increase the shared pool? Is there any way I can monitor how often statements are being aged out? Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9.0.1.1.1 on Win2k: stalls during installation: 85% D
Title: RE: Oracle 9.0.1.1.1 on Win2k: stalls during installation: 85% D Hi Tom, A week before i was tried to install oracle 9i on WinNT4(20GB Hard Disk, 128MB RAM). The software has been downloaded from Net. In my pc, i already have oracle731. I had tried to install oracle9i in another home. I had been installed oracle server sucessfully, but while creating the DB it failed by throwing our error message OUT of memory, there is no log, nothing. I cann't able to identify why is was happening. Even i tried to increase the virtual memory too (I want to know is it helpful if we were in out of memory state?). Then what i did is, uninstalled Oracle731, and cleared all relavant registry entries, restart the PC, started to install ORa9i. This time, it has done nicely, no problem nothing. But i was confused why installer refering other versions of oracle to install ora9i, anyway we are using different home, is't it?... Ok, ur attachment is in binary format, so it's NOT useful for us. I didn't find any similar type of doc file in ora9i installer CD. Can you post it in text format, if you don't mind. Another thing is, I would go into the registry and remove all traces of Oracle. -- How can do this, do you mean that, just search for oracle9i or something similar like this and remove from the registery? Thanks in advance Rgds, Nirmal. -Original Message- From: Mercadante, Thomas F [SMTP:[EMAIL PROTECTED]] Sent: Monday, November 26, 2001 10:21 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle 9.0.1.1.1 on Win2k: stalls during installation: 85% D Dan, It sounds like the 817 install left some trash around. If I were you, [Nirmal Kumar Muthu Kumaran] I would go into the registry and remove all traces of Oracle. Then, reboot the win2k box and try your install again. Attached is the Create a clean machine document that I obtained a few years back from an Oracle install disk. I have used it many times, and it *always* solves install problems on NT for me. The trick is to remove all traces, and reboot to make sure that all dll's have been purged from the system. Hope this helps! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, November 26, 2001 1:55 PM To: Multiple recipients of list ORACLE-L Database Configuration Assistant For that past few weeks, I have not for life of me been able to get Oracle 9.0.1.1.1 (free download) installed on my Win2k box. I can install it just fine on the same box inside of a Vmware WinXP Pro instance, or any other box, but not mine. Mine had Oracle 8.1.7 (Enterprise - not the free download) but I have uninstalled it. When I install Oracle 9.0.1.1.1 (using Personal), it goes fine until the screen where you select your database (General, Transactions, none, etc.). (No matter what I select) I click next, and it runs some calculations, the bar at the top gets to 85% Database Configuration Assistant and then locks up. My only option is to click the x in the top right and quit the installer. Since I can install it just fine on a new box, then I know that the reason this is happening has something to do with the sofwtare I already have installed. Can anyone recommend a course of action (rather than nuke-and-repave)? Thanks, Dan Browning -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dan Browning 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). File: Creating a Clean Machine.doc
RE: create trigger and create any trigger
Title: RE: create trigger and create any trigger hI You must have create any trigger privilege to create trigger on any table which in other schema. The alter any table will allow you to change the structure of table, but not to create trigger on it. -Original Message- From: Wiegand, Kurt [SMTP:[EMAIL PROTECTED]] Sent: Monday, November 26, 2001 9:00 PM To: Multiple recipients of list ORACLE-L Subject: create trigger and create any trigger Is the CREATE ANY TRIGGER privilege required in order for a user to create a trigger on another user's table? Oracle8: The Complete Reference leads me to believe that all the user needs is the ALTER privilege for the table and the CREATE TRIGGER privilege. It seems to say that CREATE ANY TRIGGER is only required if the trigger is to be created in another schema. However, as USER1, I can't get the following to work without it: CREATE TRIGGER ABC AFTER INSERT ON USER2.DATA_READY FOR EACH ROW BEGIN return; END; SQL @t3.sql AFTER INSERT ON USER2.DATA_READY FOR EACH ROW * ERROR at line 2: ORA-00942: table or view does not exist Am I looking at this correctly? (I'm running 8.0.5.2.1 and all privileges on USER2.DATA_READY have been granted directly to USER1) Thanks. Kurt Wiegand IBM Global Services Cable Wireless Communications [EMAIL PROTECTED] 703 760-3619 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wiegand, Kurt 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).