Re: TKPROF
Hello, Do you have timed_statistics = true in your init file ? Regards Henrik Sam P. Roberts (ZADCO ITIS) wrote: This is the output from tkprof call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.02 0.02 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch2 0.34 1.73 83385 0 7 --- -- -- -- -- -- -- total4 0.36 1.75 83385 0 7 Misses in library cache during parse: 1 Optimizer goal: RULE Misses in library cache during parse: 1 Optimizer goal: RULE Parsing user id: 36 (GL) Rows Execution Plan --- --- 0 SELECT STATEMENT GOAL: RULE 0 NESTED LOOPS 0INDEX GOAL: ANALYZED (RANGE SCAN) OF 'SAM1' (NON-UNIQUE) 0TABLE ACCESS GOAL: ANALYZED (BY INDEX ROWID) OF 'GL_BALANCES' 0 INDEX GOAL: ANALYZED (RANGE SCAN) OF 'GL_BALANCES_N1' My question - Why is the rows returned 7 in stats, yet the explain shows now Rows: Thanks Sam -- --- Henrik Ekenberg Anoto AB E-mail :[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenberg INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: TKPROF
hello, if EXPLAIN option is used, tkprof generates output against current database statistics not against statistics in raw file. this makes followings wrong: - explain plan may be different than explain plan in raw file since statistics may have changed after raw file is generated. - because of hard parse, execution plans of same SQLs may be different. if you use aggregate=yes(which is default), tkprof will show one execution plan. I did not test for returned row. but, if explain plan changes, returned row should be changed. If there is "Row Source Operation" in your output, use this one instead of explain plan section. "Row Source Operation" shows exact execution plan in raw file. regards... --- "Sam P. Roberts (ZADCO ITIS)" [EMAIL PROTECTED] wrote: This is the output from tkprof call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.02 0.02 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch2 0.34 1.73 83 385 0 7 --- -- -- -- -- -- -- total4 0.36 1.75 83 385 0 7 Misses in library cache during parse: 1 Optimizer goal: RULE Misses in library cache during parse: 1 Optimizer goal: RULE Parsing user id: 36 (GL) Rows Execution Plan --- --- 0 SELECT STATEMENT GOAL: RULE 0 NESTED LOOPS 0INDEX GOAL: ANALYZED (RANGE SCAN) OF 'SAM1' (NON-UNIQUE) 0TABLE ACCESS GOAL: ANALYZED (BY INDEX ROWID) OF 'GL_BALANCES' 0 INDEX GOAL: ANALYZED (RANGE SCAN) OF 'GL_BALANCES_N1' My question - Why is the rows returned 7 in stats, yet the explain shows now Rows: Thanks Sam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam P. Roberts (ZADCO ITIS) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = --- Danisment Gazi Unal Web: http://www.geocities.com/danisment --- __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment UNAL INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Gets
Hi All Could someone explain to me what is a buffer get. I find Logical reads, Consistent gets, Physical Reads and have the impression that the combination of the first two is buffer gets but can't find evidence for it Anybody? Met vriendelijke groet, Jacob van Zanen (Oracle DBA) Informatie Systemen Ernst Young Informatie Communicatie Technologie Kantoor Gouda Tel.: 0182 575316 (intern: 923 316) Fax: 0182 536311 E-mail: [EMAIL PROTECTED] = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopien te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. 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. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. = -- 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).
On-Call - terms, conidtions and perks!
Hi Folks, Our company has inidicated it's heading for 24 x 7 operation. So informal talks are taking place about the new "challenges" this brings regarding having staff on call to support IT systems. I would very much appreciate your feedback if you are in an on-call environment as to what the terms, conditions, and perks (if any) you get for same. Some specific information I'm looking for is: - How frequently are you on-call and for how long and to cover what hours. e.g. one week a month from 22:00 - 06:00. - What tools are you given to support this process. e.g. pager, laptop for remote dial-in, cell phone. - Whats the procedure if you "get the call". Do you dial in initially to try to resolve, that failing go on site, in other words the escalation process - What renumeration or other benefits do you get for being on call. - Are there additional 'benefits' if you are called whilst being on call. I'll treat any replies where requested with strict confidentiality. Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. http://www.organon.ie E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http:\\groups.yahoo.com/group/Oracle-OCP-DBA "They tell me nothing, but expect me to know everything!" -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: [Q] how to check dbms_job on the queue?
OK, L We've got the message (about six times) To get info that you want you can check dba_jobs_running and dba_jobs/all_jobs/user_jobs (especially last_date, last_sec, this_date, this_sec and next_date, next_sec columns). i.e. select dj.job, dj.what, dj.next_date, dj.next_sec from dba_jobs dj where not exist (select 1 from dba_jobs_running djr where djr.job = dj.job) and dj.next_date sysdate order by dj.next_date ; or select dj.job, dj.what, dj.next_date, dj.next_sec from dba_jobs dj where dj.next_date sysdate and dj.this_date is null order by dj.next_date ; HTH Regards Kresimir Fabijanic - Original Message - To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, February 08, 2001 1:19 PM We have ORACLE 8.1.6 on SUn Solaris server. Our users sometime will summit job from ORACLE Discover from the client side. Does their has way to check on server side how many dbms_job wait on queue? Thanks. Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kresimir Fabijanic INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SQL Query (Sorting)
BDY.RTF
RE: On-Call - terms, conidtions and perks!
Hi Sean, In my last job, I was required to do on-call. The way it would work was we would have a rota made up once in 2 weeks. There were about 10-12 of us who would share the on-call. Depending on when your rota was, it could be between 6 p.m. to 8 a.m. the next day on a week day. But if you got stuck with a rota for the weekend, then you were on-call between 8 a.m. on Sat to 8 a.m. on Monday. We were given laptops for remote dial-up and also security cards for passwords. On getting a call, we would try and solve the problem at home. However sometimes (very rarely) it was not possible to solve it right away, perhaps because it required code change or it was a database problem or stuff like that. Then we would just leave it till the next day and work on it when we got to work. As for benefits, we got paid about 9/hr when we were on-call and 50/hr if we got called out. So benefits-wise it wasn't bad at all :-)) HTH, Chandini Paterson -Original Message- Sean Sent: 08 February 2001 10:41 To: Multiple recipients of list ORACLE-L Hi Folks, Our company has inidicated it's heading for 24 x 7 operation. So informal talks are taking place about the new "challenges" this brings regarding having staff on call to support IT systems. I would very much appreciate your feedback if you are in an on-call environment as to what the terms, conditions, and perks (if any) you get for same. Some specific information I'm looking for is: - How frequently are you on-call and for how long and to cover what hours. e.g. one week a month from 22:00 - 06:00. - What tools are you given to support this process. e.g. pager, laptop for remote dial-in, cell phone. - Whats the procedure if you "get the call". Do you dial in initially to try to resolve, that failing go on site, in other words the escalation process - What renumeration or other benefits do you get for being on call. - Are there additional 'benefits' if you are called whilst being on call. I'll treat any replies where requested with strict confidentiality. Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. http://www.organon.ie E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http:\\groups.yahoo.com/group/Oracle-OCP-DBA "They tell me nothing, but expect me to know everything!" -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Chandini Paterson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: On-Call - terms, conidtions and perks!
Sean, Interesting point and getting more valid all the time, as you say. I've worked in places where : 1) there was a laptop/pager provided but no renumeration (7 years ago, I was a junior DBA - didn't know any better!) 2) Rota of call out with (UK pound equivalent of) $6 per weekday, $8 Saturday, $10 Sunday with mobile phone and laptop and pay for any time worked over 1 hour. 3) On-call requirements with mobile phone. renumeration = 1 hour's pay for each 24 hour day of cover (wekday or weekend) plus pay from leaving home to getting home when it was necessary to be at work. I think that 1) above is unacceptable in todays financial requirements for 24/7. Somtimes arranging my life arround a possible call-out made $6-10 per day did not seem worth it but I'm a contractor so it was part of the job when I took it. If I were an employee being asked to provide on-call cover, option 3 plus laptop is pretty much the minimum I would look for. - Mike. -Original Message- Sent: 08 February 2001 10:41 To: Multiple recipients of list ORACLE-L Hi Folks, Our company has inidicated it's heading for 24 x 7 operation. So informal talks are taking place about the new "challenges" this brings regarding having staff on call to support IT systems. I would very much appreciate your feedback if you are in an on-call environment as to what the terms, conditions, and perks (if any) you get for same. Some specific information I'm looking for is: - How frequently are you on-call and for how long and to cover what hours. e.g. one week a month from 22:00 - 06:00. - What tools are you given to support this process. e.g. pager, laptop for remote dial-in, cell phone. - Whats the procedure if you "get the call". Do you dial in initially to try to resolve, that failing go on site, in other words the escalation process - What renumeration or other benefits do you get for being on call. - Are there additional 'benefits' if you are called whilst being on call. I'll treat any replies where requested with strict confidentiality. Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. http://www.organon.ie E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http:\\groups.yahoo.com/group/Oracle-OCP-DBA "They tell me nothing, but expect me to know everything!" -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Jenner Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: On-Call - terms, conidtions and perks!
comments inline On Thu, 08 Feb 2001, O'Neill, Sean wrote: Hi Folks, Our company has inidicated it's heading for 24 x 7 operation. So informal talks are taking place about the new "challenges" this brings regarding having staff on call to support IT systems. I would very much appreciate your feedback if you are in an on-call environment as to what the terms, conditions, and perks (if any) you get for same. Some specific information I'm looking for is: - How frequently are you on-call and for how long and to cover what hours. e.g. one week a month from 22:00 - 06:00. I'm on call constantly. However, since our batch jobs don't run until 10pm, technically that is really the only time I have to worry about being paged (although one time our users got my pager number ... it was quickly changed and very strict instructions were sent out not to do it again). - What tools are you given to support this process. e.g. pager, laptop for remote dial-in, cell phone. Yep. - Whats the procedure if you "get the call". Do you dial in initially to try to resolve, that failing go on site, in other words the escalation process The first page goes to the developers. If it's a program problem, they fix it. If it's database related, I get the page. I dial in from home (I've never had to go onsite, knock on wood, but that would be the next step if connectivity between home and $WORKPLACE went down). - What renumeration or other benefits do you get for being on call. - Are there additional 'benefits' if you are called whilst being on call. $75 per week while on call. Each time being paged is 3 hours work minimum, regardless if you spent 3 hours or 10 minutes fixing the problem. Time after that is billed hourly. Cheers, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Strange command coming up when running sqlplus from Unix server...
A customer of mine, whenever he logs into sqlplus on his Unix server he gets the following: " oracle817 sqlplus inst emulated pid=28337 sqlplus va=0x14005b9b8 pc=0x1200fda40 inst=0x3be6 SQL*Plus: Release 8.1.7.0.0 - Production on Thu Feb 8 09:25:04 2001 (c) Copyright 2000 Oracle Corporation. All rights reserved. Enter user-name: BUT why does this line come up? inst emulated pid=28337 sqlplus va=0x14005b9b8 pc=0x1200fda40 inst=0x3be6 Is it because of a problem with the installation? This problem, however does not occur when I logging to SQL from a PC. " Hope someone can give me some feedback! Regards Natasha BEGIN:VCARD VERSION:2.1 N:Batson;Natasha FN:Natasha Batson EMAIL;PREF;INTERNET:[EMAIL PROTECTED] REV:20010208T133151Z END:VCARD
Re: Strange command coming up when running sqlplus from Unix server...
Don't worry guys! Found the following off of Metalink: Doc ID: Note:124568.1 Subject: Tru64 Unix Svrmgrl or Sqlplus Returns Inst Emulated Before the Standard Banner Type: PROBLEM Status: PUBLISHED Problem Description --- Invocation of 8.1.7.0.0 SVRMGRL or SQLPLUS under Compaq Tru64 Unix returns the following error: # svrmgrl inst emulated pid=7831 svrmgrl va=0x11fffde88 pc=0x12054ca98 inst=0x327e0028 Oracle Server Manager Release 3.1.7.0.0 - Production Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved. Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production SVRMGR Solution Description The above error message is issued on ALPHA chip prior EV56. To verify your Alpha chip generation with : # ./usr/sbin/psrinfo -v The output look similar to: Status of processor 0 as of: 11/15/00 10:02:24 Processor has been on-line since 08/14/2000 11:14:10 The alpha EV5 (21164) processor operates at 250 MHz, and has an alpha internal floating point processor. or Status of processor 0 as of: 11/15/00 08:59:01 Processor has been on-line since11/15/2000 06:54:32 The alpha EV5 (21164) processor operates at 267MHz, and has an alpha internal floating point processor. Explanation --- Beginning with Oracle8i Release 3, (8.1.7) and associated Oracle8i Release 3-based products will be supported on Compaq Tru64 UNIX AlphaServers with EV56 or greater generation CPUs only. Therefore, Oracle Error Correction formally announces the end of Error Correction Support for Oracle products on Compaq Tru64 UNIX AlphaServers containing pre-EV56 generation Alpha CPUs. References -- Note:87.1 Note:118593.1 Additional Search Words --- Compaq Tru64 UNIX AlphaServers AlphaStation (formerly Digital Unix 8.1.7 8.1.7.0.0) xterm, term . Copyright (c) 1995,2000 Oracle Corporation. All Rights Reserved. Legal Notices and Terms of Use. - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Thursday, February 08, 2001 9:31 AM A customer of mine, whenever he logs into sqlplus on his Unix server he gets the following: " oracle817 sqlplus inst emulated pid=28337 sqlplus va=0x14005b9b8 pc=0x1200fda40 inst=0x3be6 SQL*Plus: Release 8.1.7.0.0 - Production on Thu Feb 8 09:25:04 2001 (c) Copyright 2000 Oracle Corporation. All rights reserved. Enter user-name: BUT why does this line come up? inst emulated pid=28337 sqlplus va=0x14005b9b8 pc=0x1200fda40 inst=0x3be6 Is it because of a problem with the installation? This problem, however does not occur when I logging to SQL from a PC. " Hope someone can give me some feedback! Regards Natasha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Natasha Batson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SQL parameter for batch runs [NT]
Hi Folks, I have some SQL scripts which I use to Shutdown and Startup DBs. The SQL scripts are called from OS batch files and run using AT schedule service. Problem, or so I perceive it as being, is that I use SYSTEM user as part of script to connect to DB to Startup/Shutdown and I have the password for same (horror of horrors???) in the SQL script. So I'm wondering how othger folks manage the same process. Do you use the OS file protection to protect the SQL file from prying eyes or perhaps a particular Oracle account stripped of unecessary privs etc to include in script OR is there a antoher more secure way around this issue that I just have not realised?. Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. http://www.organon.ie E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http:\\groups.yahoo.com/group/Oracle-OCP-DBA "They tell me nothing, but expect me to know everything!" -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 8i OCI application on a Ora7 client - Windows NT
Hi, I wrote an OCI application, that I would like to link on a Ora8i client (Windows NT). The problem is, that although I don't user any Ora8i specific functionality, the executable still would not run on a Ora7 client (The Ora8i OCI.DLL is copyed into the same directory on the Ora7 client as the application executable). Can some one please help, how this can be resolved? TIA. Best regards, Tamas Szecsy The cause, I am using the Ora8i OCI.DLL is that the function calls (e.g. OCIDescribe ) are much more readable than the Ora7 version of it (odsc etc.). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: On-Call - terms, conidtions and perks!
Hi Sean, I have worked in two environments that required 24X7 support. My first job as a DBA we had a 4 man team and rotated the pager every week. So each DBA was on-call once a month. All we carried was a pager. We all had personal computers at home, so we really didn't need a laptop. If the on-call DBA needed to go out of town or something he made arrangements before hand to get his rotation covered. There was no monetary supplement for being on-call. My manager kind of lumped it in our salaries and supplemented comp time in. (3Yrs) My second experience was with a larger organization and they equiped on-call personnel with a laptop, pager and cell phone. There was a rotation every week depending on how many people were in your group. They actually paid on-call personnel $125/wk whether you were called or not. So having the laptop and the supplemental income really made that experience a little better. (1yr) I hope that helps --- "O'Neill, Sean" [EMAIL PROTECTED] wrote: Hi Folks, Our company has inidicated it's heading for 24 x 7 operation. So informal talks are taking place about the new "challenges" this brings regarding having staff on call to support IT systems. I would very much appreciate your feedback if you are in an on-call environment as to what the terms, conditions, and perks (if any) you get for same. Some specific information I'm looking for is: - How frequently are you on-call and for how long and to cover what hours. e.g. one week a month from 22:00 - 06:00. - What tools are you given to support this process. e.g. pager, laptop for remote dial-in, cell phone. - Whats the procedure if you "get the call". Do you dial in initially to try to resolve, that failing go on site, in other words the escalation process - What renumeration or other benefits do you get for being on call. - Are there additional 'benefits' if you are called whilst being on call. I'll treat any replies where requested with strict confidentiality. Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. http://www.organon.ie E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http:\\groups.yahoo.com/group/Oracle-OCP-DBA "They tell me nothing, but expect me to know everything!" -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: james ellis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SQL parameter for batch runs [NT]
How many DB's are on the machine. I as well use this command for backups, but I have the oracle_sid set so I do no need to use the entire connect string. I just say, "connect internal" and it will connect allowing me to do startups and shutdowns. The other way around the issue is to use NT security(heheh) to block all users from these files except for administrators. H.I'll give it a little more though, I am sure someone here will solve it before me. Have a good one Kev -Original Message- Sean Sent: Thursday, February 08, 2001 8:50 AM To: Multiple recipients of list ORACLE-L Hi Folks, I have some SQL scripts which I use to Shutdown and Startup DBs. The SQL scripts are called from OS batch files and run using AT schedule service. Problem, or so I perceive it as being, is that I use SYSTEM user as part of script to connect to DB to Startup/Shutdown and I have the password for same (horror of horrors???) in the SQL script. So I'm wondering how othger folks manage the same process. Do you use the OS file protection to protect the SQL file from prying eyes or perhaps a particular Oracle account stripped of unecessary privs etc to include in script OR is there a antoher more secure way around this issue that I just have not realised?. Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. http://www.organon.ie E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http:\\groups.yahoo.com/group/Oracle-OCP-DBA "They tell me nothing, but expect me to know everything!" -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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[2]:RE: final frontier / RE: RE: RE: OT NT2K vs Unix.
Well, Since we've gone this far down the gutter, you all have a good laugh. BTW: those of you unfamiliar with Star Trek have my pity. -- BRAIN SYSTEM: Attention. Alert registered. CENTRAL: Alert? Number One, report! NUMBER ONE: Sir! We're picking up a loud beeping sound. CENTRAL: Beeping? We were just asleep! NUMBER ONE: Yes sir. Ears report it's very persistent CENTRAL: Goodness, are we being tortured? NUMBER ONE: Sir, Eyes are functional and request instruction. CENTRAL: Tell them to open up and try to find out what is going on. NUMBER ONE: Scope! Okay, I see darkness... darkness... CENTRAL: Well of course. Keep looking. NUMBER ONE: Sir, urgent report from Stomach on the horn, do you want to take it? CENTRAL: Stomach, what's going on? STOMACH: Sir, we've taken a hit, it...it looks bad, sir. CENTRAL: Get hold of yourself, man! STOMACH: Yessir. It looks like a burrito, sir. It exploded at about 1900 hours and we've been out of action ever since. I don't...I don't know if she can take much more, Captain. CENTRAL: Stomach! Now you listen to me, son. We're all counting on you up here. Don't give up now. Remember the chili of '94? We made it through that, we can make it through anything. STOMACH: Yessir. You can count on me, sir. CENTRAL: Good man. NUMBER ONE: Sir, I've got a visual on the clock! CENTRAL: Tell me, Number One. NUMBER ONE: Oh my God, sir. It's horrible. CENTRAL: Dammit sailor, get a grip on yourself! NUMBER ONE: It's... It's three thirty, sir. In the morning. CENTRAL: In the morning? Not again. I thought...I thought that we'd had the worst of it yesterday. SYSTEM: Sixty seconds to consciousness. CENTRAL: This is madness. Do you know what's going to happen if we go conscious now, this early? NUMBER ONE: Work, sir? CENTRAL: That's right, Number One. It'll be work, all right. I don't...don't know if I can live through that hell again. SYSTEM: Fifty seconds to consciousness. NUMBER ONE: Sir? Do you have orders? CENTRAL: Hmmm? NUMBER ONE: Orders, sir. Do you have orders for us? CENTRAL: Orders? Orders, Number One? Damn right there are orders! Let's get ourselves moving. NUMBER ONE: Aye aye, sir! SYSTEM: Forty seconds to consciousness. CENTRAL: Shut that damn thing off, I'm trying to think. Get our remote stations on line. I want a Search and Acquire on anything that feels like a pager. Tell them to MOVE. Bladder! BLADDER: Yes sir? CENTRAL: How are you holding? BLADDER: All systems are flush and ready, sir. We can go another three hours, easy. CENTRAL: Very well, Bladder. Number One, get me Nose on the horn. NOSE: Sir, Nose reporting, sir! CENTRAL: Good to hear from you, Nose. How are you doing up there? NOSE: We registered cat breath about twenty minutes ago, but it was pretty faint and I didn't think... CENTRAL: Steady on, nose. You were right not to trigger an alert. NOSE: Thank you, sir. CENTRAL: Nose, I'm afraid I have bad news for you, son. We took a burrito last night. NOSE: Oh no, sir, not again! CENTRAL: I said steady! You're going to have to hold on, you hear me? Hold on, and it will pass. I don't want ANYTHING getting through to Consciousness. NOSE: Yes sir. I'll try, sir. CENTRAL: That's the spirit. Stomach! STOMACH: Sir? CENTRAL: How are you doing down there? STOMACH: We've been breached, Captain. The whole alimentary is in flames. I'm trying to keep it contained, butI can't promise anything. CENTRAL: Damn! Any report from our search party? NUMBER ONE: Sir, Fingers report they located and toppled a glass of water, a pair of glasses, and a box of Kleenex. No luck on the pager, sir. CENTRAL: Number One, I don't mind telling you, if we don't get this under control we're going to lose her. NUMBER ONE: Yes sir. CENTRAL: How much time on the system clock? NUMBER ONE: Ten seconds to consciousness, sir. We've lost smile control in the lower facial and we're developing a frown. CENTRAL: Brace yourself, Number One. I'm afraid we've had it. NUMBER ONE: Sir! Fingers has located target. Repeat, Fingers is on target! CENTRAL: Fire! NUMBER ONE: Hit! Sir, direct hit! CENTRAL: Ears! NUMBER ONE: It's gone, Captain! Ears reports the beeping is gone! CENTRAL: We've done it! SYSTEM: Consciousness cancelled. NUMBER ONE: Sir, all systems are ready for sleep mode. Repeat, sleep mode now ready. CENTRAL: Trigger sleep mode NOW. NUMBER ONE: Sleep mode triggered, aye aye, sir. CENTRAL: Shut Eyes. NUMBER ONE: Eyes off, sir. Frown relaxed, smile restored. CENTRAL: By golly, that was a close one. NUMBER ONE: Yessir. Sir, Dream Team requests selection sir. CENTRAL: Let's roll the one where we show up for church wearing only our underwear, I like that one. NUMBER ONE: Roger that, sir. Dream selection completed and tape is rolling, sir. CENTRAL: Good work, Number One. You take the helm. NUMBER ONE: Aye aye,
RE: On-Call - terms, conidtions and perks!
Oh, I envy you very much. Before my previous job, I worked at 24/7 car tow service company. We just have 2 dba. So each of us took one week rotate on call. we constantly been paged at midnight. Sometimes be paged because the system slow. I learned if they said system slow. I don't go to my pc immediately. I will wait be paged again. Most time the problems were gone. But I suffered sleepless the whole night. We don't have any extra pay. No cell phone. Joan -Original Message- Conron Sent: Thursday, February 08, 2001 7:16 AM To: Multiple recipients of list ORACLE-L comments inline On Thu, 08 Feb 2001, O'Neill, Sean wrote: Hi Folks, Our company has inidicated it's heading for 24 x 7 operation. So informal talks are taking place about the new "challenges" this brings regarding having staff on call to support IT systems. I would very much appreciate your feedback if you are in an on-call environment as to what the terms, conditions, and perks (if any) you get for same. Some specific information I'm looking for is: - How frequently are you on-call and for how long and to cover what hours. e.g. one week a month from 22:00 - 06:00. I'm on call constantly. However, since our batch jobs don't run until 10pm, technically that is really the only time I have to worry about being paged (although one time our users got my pager number ... it was quickly changed and very strict instructions were sent out not to do it again). - What tools are you given to support this process. e.g. pager, laptop for remote dial-in, cell phone. Yep. - Whats the procedure if you "get the call". Do you dial in initially to try to resolve, that failing go on site, in other words the escalation process The first page goes to the developers. If it's a program problem, they fix it. If it's database related, I get the page. I dial in from home (I've never had to go onsite, knock on wood, but that would be the next step if connectivity between home and $WORKPLACE went down). - What renumeration or other benefits do you get for being on call. - Are there additional 'benefits' if you are called whilst being on call. $75 per week while on call. Each time being paged is 3 hours work minimum, regardless if you spent 3 hours or 10 minutes fixing the problem. Time after that is billed hourly. Cheers, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: On-Call - terms, conidtions and perks!
We likewise do 24x7 support for a computer integrated manufacturing line an around the world sales organization (sales offices in the pacific Europe). There are two of us so we share the duties typically two weeks at a time. The company pays $200 per week no matter if you get called or not. We each have pagers but the on call person has the cell phone. There is a laptop, but we never use it as the company provides ISDN service from home into the local area network. That's scheduled to change in the near future to a VPN setup with ATT. At any rate, things have been setup such that no matter if your in the office or at home you have the same access and resources. We've spent a lot of time and money in setting up the production DB's and servers in the most fault tolerant way possible. Multiple CPU HP's that soft fail with redundant power supplies. Mirrored EMC disk arrays, triple oversized UPS systems, fault tolerant CISCO switches, etc., etc., etc... Also, since there was no such tool in the old Oracle 6 days we created a program that runs on an NT box as a client application that watches the DB's 24x7 and knows where the appropriate pagers for the appropriate errors are, default the DBA's. The entire system works almost flawlessly. Last year we only had 5 hours of unscheduled down time across 10 production instances, all for hardware problems which really weren't 'unscheduled' since we had two days notice before. Most weeks the only call that comes in is a real nuisance as one of the line techs will mis-diagnose the error he's seeing. Dick Goulet -- 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: Decimal to Hex conversion
rawtohex() -Original Message- Sent: Thursday, February 08, 2001 5:15 AM To: Multiple recipients of list ORACLE-L Hi everybody, I am facing a problem converting from decimal values to hexadecimal values. i.e. col1 col2 -- 2021 801 should give (2021*65536+801)=132449057 I am asked to present this value in hexView like : 07E50321 any suggestions howto convert (probably via simple SQL) ? TNX Frank Foelz sorry, but I posted this to [EMAIL PROTECTED], already. We are facing problems with some mailservers today. _ Scheidt Bachmann GmbH Gestaltung Parkhaussysteme Breite Strasse 132 41238 Moenchengladbach Phone : ++49 2166 / 266 - 837 Fax: ++49 2166 / 266 - 615 e-mail : mailto:[EMAIL PROTECTED] URL: http://www.scheidt-bachmann.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Foelz.Frank INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 message has been checked for all known viruses by UUNET delivered through the MessageLabs Virus Control Centre. For further information visit http://www.uk.uu.net/products/security/virus/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dasko, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:RE: Precise Sql info
Joan, Can I quote you on that to my damagement?? Dick Goulet Reply Separator Author: "Joan Hsieh" [EMAIL PROTECTED] Date: 2/6/2001 1:38 PM Hi Mike, I uses precise sql and I like it very much. Especially good for peoplesoft kind of application. I used sql lab, sql expert, too. But I give precise sql the highest score. It is expensive but worth every penny. That's what I think. Thanks, Joan -Original Message- Lanteigne Sent: Tuesday, February 06, 2001 1:09 PM To: Multiple recipients of list ORACLE-L Hi all, Thanks for all who responded to my dba/PeopleSoft query. Your insights were very helpful. Now I'm looking for any thoughts on Precise SQL and the Precise Enterprise product line. From their web page, it seems like a job unto itself to run! Any thought or experiences welcome. Thanks again Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Lanteigne INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SQL parameter for batch runs [NT]
I have shutdown and startup scripts run by the root process via cron or init.d (automatic scripts at startup or shutdown). These scripts shell to the Oracle account, but because they start as root the scripts do not need the Oracle password. If you are running as the Oracle account you connect internal, which needs no password entered, and do your shutdown and startup's "O'Neill, Sean" [EMAIL PROTECTED] 02/08/01 08:50AM Hi Folks, I have some SQL scripts which I use to Shutdown and Startup DBs. The SQL scripts are called from OS batch files and run using AT schedule service. Problem, or so I perceive it as being, is that I use SYSTEM user as part of script to connect to DB to Startup/Shutdown and I have the password for same (horror of horrors???) in the SQL script. So I'm wondering how othger folks manage the same process. Do you use the OS file protection to protect the SQL file from prying eyes or perhaps a particular Oracle account stripped of unecessary privs etc to include in script OR is there a antoher more secure way around this issue that I just have not realised?. Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. http://www.organon.ie E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http:\\groups.yahoo.com/group/Oracle-OCP-DBA "They tell me nothing, but expect me to know everything!" -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: William Beilstein INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: oracle8i and Java
Hello, Loadjava should be in the bin folder in your Oracle Home. If you have install the jva module. Regrads Henrik Chandini Paterson wrote: Okay folks, I am trying to work with Java in Oracle (woohoo). And I am already stuck. Can't seem to get the loadjava command line to work. Worse, though I have the dbms_java package loaded, I can't find the loadjava procedure (or the drop java or anything). I am on Oracle 8.1.5. What am I doing wrong. What do I need to do to get the darn thing to work. Help Thanks for any input, Chandini Paterson -- --- Henrik Ekenberg Anoto AB Direct+46 (0)8 410 78 577 Vasagatan 7 Mobile+46 (0)733 478 577 111 20 Stockholm, Sweden www.anoto.com Switchb. +46 (0)8 406 79 00 E-mail :[EMAIL PROTECTED] Fax +46 (0)8 406 79 50 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenberg INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SQL parameter for batch runs [NT]
We do thing a little different. First, only the IS staff has access to the UNIX prompt. Second, there is a file maintained by ROOT which contains both login id and passwords. These values are loaded through a . script loading Sys_Name and Sys_Password. Third, all sql's, sqlload, exports are executed using the $Sys_Name/$Sys_Password syntax. That way, we can change passwords at a whim, update the controlling . file and all scripts continue as though nothing has changed. -Original Message- From: O'Neill, Sean [SMTP:[EMAIL PROTECTED]] Sent: Thursday, February 08, 2001 8:50 AM To: Multiple recipients of list ORACLE-L Subject:SQL parameter for batch runs [NT] Hi Folks, I have some SQL scripts which I use to Shutdown and Startup DBs. The SQL scripts are called from OS batch files and run using AT schedule service. Problem, or so I perceive it as being, is that I use SYSTEM user as part of script to connect to DB to Startup/Shutdown and I have the password for same (horror of horrors???) in the SQL script. So I'm wondering how othger folks manage the same process. Do you use the OS file protection to protect the SQL file from prying eyes or perhaps a particular Oracle account stripped of unecessary privs etc to include in script OR is there a antoher more secure way around this issue that I just have not realised?. Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. http://www.organon.ie E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http:\\groups.yahoo.com/group/Oracle-OCP-DBA "They tell me nothing, but expect me to know everything!" -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: William Rogge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: On-Call - terms, conidtions and perks!
Sean, This reply sounds different from the others but I thought I would throw it out for comparison. I am a full-time employee at a smallish company. When I was hired, part of the job description was to be on-call. We went over the specifics in some detail before I signed on for the job. There was no specific monetary compensation for being on-call but I was offered what I considered to be a very generous salary which I accepted with full knowlege of the on-call requirement. That said, I was on call 24 hours a day seven days a week for five months straight except for a 4-day reprieve in October. Once we finally were able to hire a new DBA and bring him up to speed, I've been trading off being on-call with him for the last month. We take seven-day rotations from Friday to Friday. No particular compensation per se other than our boss will give us a day off if it's been a particularly bad weekend. I have a laptop and a beeper to accomplish this. Our computer center pages us if certain database jobs fail. Anyone in our company who has access to the pager database can page us at will. Usually they're not too abusive of the privilege but I try to discourage pages for things that I feel can wait til the next day (non-Production problems). I get paged an average of once or twice a week. Lately we haven't been getting many pages at all as things have settled down somewhat. Sometimes we get paged a lot more often. Once paged we're supposed to reply promptly (who knows how that is defined). Usually if I don't respond within 15 minutes I get paged again or they call me directly at home. If they can't reach me for some reason after a half hour or an hour, they will page or call the other DBA(s). We don't currently have a formal backup DBA arrangement. Once I talk with whoever paged, I get the picture of the problem, log in from home and fix the problem. Then I call them back or send an email. At a previous contract position at a large company, DBAs were on-call for a week at a time every 8 weeks. Employees earned an extra day of vacation for every week of being on call. Contractors were paid $7 per hour for all 24 hours of being on call and switched over to billing full hourly rate once called (1 hour minimum). Most of the DBAs at that company seemed satisfied with the situation. Just curious- how many DBAs allow coworkers to page them at will or to call them at their home phone number? Is that a fairly common practice? Thanks, Cherie Machler Gelco Information Network "O'Neill, Sean" [EMAIL PROTECTED] on 02/08/2001 04:40:56 AM Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Cherie Machler/GELCO) Hi Folks, Our company has inidicated it's heading for 24 x 7 operation. So informal talks are taking place about the new "challenges" this brings regarding having staff on call to support IT systems. I would very much appreciate your feedback if you are in an on-call environment as to what the terms, conditions, and perks (if any) you get for same. -- 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: Pl/SQL Dynamic SQL questions
Thanks David, Yes this does help very much. I actually figured out the PL*SQL hangup yesterday. I was doing something really silly (!) with bind variables...Thanks for the code sample! Susan -Original Message- Sent: Wednesday, February 07, 2001 11:11 AM To: Multiple recipients of list ORACLE-L Susan, Dynamic SQL can get pretty interesting, depending on the values of your programmer defined records. Obviously your code compiles, but when you add the variable, funny things can happen. When you break out of the routine, what line is showing as being the hangup? If it's your bigSQL, try commenting out various parts of the code and use something like dbms_output.put_line to see what your variables and clauses look like. Here's a snippet of something similar I wrote. It selects from different tables using different where clauses depending on user input from the browser: CREATE OR REPLACE PROCEDURE leadsResults( leadFunction varchar2, customer varchar2, leads_phone_npa varchar2, leads_phone_nxx varchar2, leads_phone_suffixvarchar2, clli varchar2, marketvarchar2, statusvarchar2) AS v_idowa_cookie.cookie; fromClause varchar2(20); whereClause varchar2(250); TYPE RefCurTyp IS REF CURSOR; listCur RefCurTyp; BEGIN v_id:=OWA_COOKIE.GET('employee'); IF leadFunction = 'workingLeads' THEN v_lead_type:= NULL; fromClause:='leads'; IF clli IS NOT NULL AND customer IS NOT NULL AND status IS NOT NULL THEN whereClause:= 'WHERE ld_clli = ' |||| clli |||| 'AND UPPER(ld_bus_name) like UPPER(' ||||'\%' || customer || '\%'||||') AND ld_term_code = ' ||||status|||| 'AND to_number(ld_emp_id) = ' ||v_id.vals(1)|| 'ORDER BY ld_bus_name'; END IF; END IF; OPEN listCur for 'SELECT ld_bus_name, ld_term_code, ld_timestamp, ld_sic_name, ld_bus_phone, ld_bus_addr, ld_bus_city, ld_bus_state, ld_bus_zip, ld_notes, ld_duns_num from ' || fromClause || ' ' || whereClause; Hope this helps. David A. Barbour Oracle DBA - ConnectSouth 512-681-9438 [EMAIL PROTECTED] -Original Message- Sent: Tuesday, February 06, 2001 3:18 PM To: Multiple recipients of list ORACLE-L Hello all, Okay, so I may be making this problem more difficult than it appears, but I'm having a helluva time using ref cursors with dynamic sql in a function. Anybody done this? Basically I'm trying to construct the select, from and where clauses via variables; so for instance, I test for acctType (passed in as a parameter) like so: if (acctType = 0) then selectClause := 'select etc.'; elsif (accType = 1) then selectClause := 'select etc.'; etc. etc. Then I have one big sqlStmt variable where I concat the select, from, where clause. I open the sqlStmt, fetch into a programmer defined record and try and return this cursor. Problem is sql*plus locks up each time I try to run it. I never get anything back which leads me to believe that something is terribly wrong with my approach. I've used an approach outlined in the Oracle documentation... Thanks for you help! Hope this makes sense :) SE Teague Aresenal Digital Solutions Data Services [EMAIL PROTECTED] 919.760.1167 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Susan E Teague INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information
Re: Strange command coming up when running sqlplus from Unix server...
Hi Natasha, Looks like an install problem. Check your /etc/system directory. Natasha Batson [EMAIL PROTECTED] wrote: A customer of mine, whenever he logs into sqlplus on his Unix server he getsthe following:"oracle817 sqlplusinst emulated pid=28337 va=0x14005b9b8 pc=0x1200fda40inst=0x3be6SQL*Plus: Release 8.1.7.0.0 - Production on Thu Feb 8 09:25:04 2001(c) Copyright 2000 Oracle Corporation. All rights reserved.Enter user-name:BUTwhy does this line come up?inst emulated pid=28337 va=0x14005b9b8 pc=0x1200fda40inst=0x3be6Is it because of a problem with the installation?This problem, however does not occur when I logging to SQL from a PC."Hope someone can give me some feedback!RegardsNatashaBEGIN:VCARDVERSION:2.1N:Batson;NatashaFN:Natasha BatsonEMAIL;PREF;INTERNET:[EMAIL PROTECTED]REV:20010208T133151ZEND:VCARDRocky WelchSenior Consultant - Internet Services GroupArthur AndersenDo You Yahoo!? - Get personalized email addresses from Yahoo! Mail Personal Address - only $35 a year!
OT RE:
Title: OT RE: LOL!! -Original Message- From: Eric D. Pierce [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 6:21 PM To: Multiple recipients of list ORACLE-L Subject: Re: to port or starboard? [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] On 7 Feb 2001, at 14:41, Travis Scrivner wrote: list ... ... send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
FW: oracle8i and Java
Forgot to add, when I run the loadjava utility, I get the following error message Unable to initialize threads: cannot find class java/lang/Thread Could not create Java VM Chandini Paterson -Original Message- Paterson Sent: 08 February 2001 12:30 To: Multiple recipients of list ORACLE-L Okay folks, I am trying to work with Java in Oracle (woohoo). And I am already stuck. Can't seem to get the loadjava command line to work. Worse, though I have the dbms_java package loaded, I can't find the loadjava procedure (or the drop java or anything). I am on Oracle 8.1.5. What am I doing wrong. What do I need to do to get the darn thing to work. Help Thanks for any input, Chandini Paterson -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chandini Paterson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Chandini Paterson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:Ora 8i OCI application on a Ora7 client - Windows NT
Tamas, You've got two choices: 1) install the Oracle8 client wherever the program will be run. 2) rebuild using the Oracle7 OCI library. Dick Goulet Reply Separator Author: Szecsy Tamas [EMAIL PROTECTED] Date: 2/8/2001 5:10 AM Hi, I wrote an OCI application, that I would like to link on a Ora8i client (Windows NT). The problem is, that although I don't user any Ora8i specific functionality, the executable still would not run on a Ora7 client (The Ora8i OCI.DLL is copyed into the same directory on the Ora7 client as the application executable). Can some one please help, how this can be resolved? TIA. Best regards, Tamas Szecsy The cause, I am using the Ora8i OCI.DLL is that the function calls (e.g. OCIDescribe ) are much more readable than the Ora7 version of it (odsc etc.). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Decimal to Hex conversion
If you're using Shell scripting you can do this by: echo `expr 2021 \* 65536 + 801` | awk '{ printf "%x\n", $1 }' -- Deepak Sharma --- "Foelz.Frank" [EMAIL PROTECTED] wrote: Hi everybody, I am facing a problem converting from decimal values to hexadecimal values. i.e. col1 col2 -- 2021 801 should give (2021*65536+801)=132449057 I am asked to present this value in hexView like : 07E50321 any suggestions howto convert (probably via simple SQL) ? TNX Frank Foelz sorry, but I posted this to [EMAIL PROTECTED], already. We are facing problems with some mailservers today. _ Scheidt Bachmann GmbH Gestaltung Parkhaussysteme Breite Strasse 132 41238 Moenchengladbach Phone : ++49 2166 / 266 - 837 Fax: ++49 2166 / 266 - 615 e-mail : mailto:[EMAIL PROTECTED] URL: http://www.scheidt-bachmann.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Foelz.Frank INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 DBA, Minneapolis, MN USA __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Sharma INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: On-Call - terms, conidtions and perks!
In my last posititon I was the only DBA and consequently carried a pager and laptop. Vacations ment taking the gear with me. The job perc was that I had TOTAL CONTROL of all aspects of the system. No extra compensation for being on-call 24x365. (4yrs) In my current position we have just changed the on-call policy. Formerly we received $100/week when carying the phone (digital page/voice phone). We also received $50/call incident pay. On a busy week this could be quite benificial($$). The new policy is $250/week when on-call and no incident pay. Still not a bad deal. (1yr) Rodd Holman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Holman, Rodney INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to insert data in LOBs
Hi Saurabh, Just do some RD on dbms_lob, it has all procedures for maintaining LOBs. Simple small data (say 50 charac. text in CLOB) can be inserted normally. There are also functions like empty_clob() you may like to try out. Hitarth Trivedi -Original Message- Sent: Thursday, February 08, 2001 8:32 AM To: Multiple recipients of list ORACLE-L hi all, i want to know how to insert values i.e. text/word or images in a table's LOB column. can we insert them with the regular insert command. please help in this regard. thanks in advance.. saurabh FCS Software Solutions Ltd. Noida.(India) [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Trivedi, Hitarth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: USE_SHARED_SOCKET on 8.1.5 8.1.6
Title: RE: USE_SHARED_SOCKET on 8.1.5 8.1.6 You can do this if you like, BUT shutting down the listener clears the port and ALL CONNECTIONS that are maintained through it. -Original Message- From: Maria Freytag [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 5:42 PM To: Multiple recipients of list ORACLE-L Subject: USE_SHARED_SOCKET on 8.1.5 8.1.6 I'm trying to activate port sharing under Win NT 4.0 SP 5. I've set the USE_SHARED_SOCKET to TRUE in Control Panel, System environment. Connected to database from a client. Stopped the listener on the server. But my client connection didn't terminate. I think my connection should have terminated. My understanding of how this works is by setting USE_SHARED_SOCKET to TRUE this allows the OS to share port 1521 and the clients will then stay on 1521 when connecting to the database and will not be port redirected. Has anyone been successful at implementing port sharing using USE_SHARED_SOCKET on 8.1.5 and/or 8.1.6? Thanks Maria -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Freytag INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: On-Call - terms, conidtions and perks!
Help Desk at Data Center is supposed to page/call on_call_dba or developer for all problems. Here 3 dba's with one month rotation provided with laptop and pager. No compensation for on call DBA except time off if it is a bad problem at night time. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 08 Feb 2001 07:21:30 -0800 Sean, This reply sounds different from the others but I thought I would throw it out for comparison. I am a full-time employee at a smallish company. When I was hired, part of the job description was to be on-call. We went over the specifics in some detail before I signed on for the job. There was no specific monetary compensation for being on-call but I was offered what I considered to be a very generous salary which I accepted with full knowlege of the on-call requirement. That said, I was on call 24 hours a day seven days a week for five months straight except for a 4-day reprieve in October. Once we finally were able to hire a new DBA and bring him up to speed, I've been trading off being on-call with him for the last month. We take seven-day rotations from Friday to Friday. No particular compensation per se other than our boss will give us a day off if it's been a particularly bad weekend. I have a laptop and a beeper to accomplish this. Our computer center pages us if certain database jobs fail. Anyone in our company who has access to the pager database can page us at will. Usually they're not too abusive of the privilege but I try to discourage pages for things that I feel can wait til the next day (non-Production problems). I get paged an average of once or twice a week. Lately we haven't been getting many pages at all as things have settled down somewhat. Sometimes we get paged a lot more often. Once paged we're supposed to reply promptly (who knows how that is defined). Usually if I don't respond within 15 minutes I get paged again or they call me directly at home. If they can't reach me for some reason after a half hour or an hour, they will page or call the other DBA(s). We don't currently have a formal backup DBA arrangement. Once I talk with whoever paged, I get the picture of the problem, log in from home and fix the problem. Then I call them back or send an email. At a previous contract position at a large company, DBAs were on-call for a week at a time every 8 weeks. Employees earned an extra day of vacation for every week of being on call. Contractors were paid $7 per hour for all 24 hours of being on call and switched over to billing full hourly rate once called (1 hour minimum). Most of the DBAs at that company seemed satisfied with the situation. Just curious- how many DBAs allow coworkers to page them at will or to call them at their home phone number? Is that a fairly common practice? Thanks, Cherie Machler Gelco Information Network "O'Neill, Sean" [EMAIL PROTECTED] on 02/08/2001 04:40:56 AM Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Cherie Machler/GELCO) Hi Folks, Our company has inidicated it's heading for 24 x 7 operation. So informal talks are taking place about the new "challenges" this brings regarding having staff on call to support IT systems. I would very much appreciate your feedback if you are in an on-call environment as to what the terms, conditions, and perks (if any) you get for same. -- 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Scripts -- Scripts -- Scripts
Hi List, Does anyone have some sql scripts to share that shows things such as table structure, index structure, triggers (their code), procedures code, etc. I'm on a migration and I want to make sure I'm not forgetting anything. Any help would be appreciated. Thanks ___ Do You Yahoo!? Enva mensajes instantneos y recibe alertas de correo con Yahoo! Messenger - http://messenger.yahoo.es -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Pablo=20ksksksk?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Silly question perhaps -- iAS vs. IIS
We use IIS very successfully connecting to our Oracle database. I can't really give you impact because I don't know what a OAS connection is like, but we generally get very good response from the Web Server, and always get a good response from the database. However, it is rare that we have more than 20 users connected at once, though the web or otherwise. The only thing we have had to be very careful about is being sure to close all connections on the same page that we open them because the connection doesn't die just because the session was closed. At 04:37 AM 2/8/01 -0800, you wrote: I don't know if this is a silly question, but I am playing devil's advocate because one of the managers here made a comment re. this. Why would someone bother using the Oracle Web Server anyway? We have two boxes that use OWS 3.0.1.1 (we will upgrade very soon to OAS 4.0, Oracle doesn't support 3.0.1.1 anymore), with JInitiator and Forms / Reports server. Another box is using the Oracle Application Web Toolkit to access my database, generating thousands of separate sessions per day, each about one second in length. I don't know about the other Web server options out there, is there a way to do the same thing with IIS and OLE DB, for example? What would the impact be on Web server performance, the network, and the back end database? Just wondering, please enlighten me. I asked the ODTUG listserv but there was resounding silence. TIA Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Rgion des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Regina Harter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Parameter obsolete
Hello list, This question is not a matter or life or death but a curiosity I have. Im working with Oracle 8.1.6 and NT. Each time I open the database, I get the next message in the XXXALERT.log : Obsolete system parameters with specified values: distributed_lock_timeout I included it the init.ora file following a friend advice, but i have read that it has no sense in this Oracle version, so, could anybody tell me if I can delete it? TIA -- Beatriz Martnez Jimnez [EMAIL PROTECTED] Ingeniera Informtica Fundacin CIDAUT Parque Tecnolgico de Boecillo, parcela 209 Boecillo 47151 Valladolid tfno.983 54 80 35 begin:vcard n:MartÃnez Jiménez;Beatriz x-mozilla-html:FALSE url:www.cidaut.es org:Fundación CIDAUT;Departamento Informática adr:;;Parque Tecnológico de Boecillo;Boecillo;Vallodolid;47151;España version:2.1 email;internet:[EMAIL PROTECTED] title:Ingeniera Informática fn:Beatriz end:vcard
RE: oracle8i and Java
It is in the bin folder. I checked the database. It has got the java/lang/Thread in the all_objects. My path and classpath are also set to the correct paths. And it still doesn't work. Its' driving me nuts. Chandini -Original Message- Ekenberg Sent: 08 February 2001 14:57 To: Multiple recipients of list ORACLE-L Hello, Loadjava should be in the bin folder in your Oracle Home. If you have install the jva module. Regrads Henrik Chandini Paterson wrote: Okay folks, I am trying to work with Java in Oracle (woohoo). And I am already stuck. Can't seem to get the loadjava command line to work. Worse, though I have the dbms_java package loaded, I can't find the loadjava procedure (or the drop java or anything). I am on Oracle 8.1.5. What am I doing wrong. What do I need to do to get the darn thing to work. Help Thanks for any input, Chandini Paterson -- --- Henrik Ekenberg Anoto AB Direct+46 (0)8 410 78 577 Vasagatan 7 Mobile+46 (0)733 478 577 111 20 Stockholm, Sweden www.anoto.com Switchb. +46 (0)8 406 79 00 E-mail :[EMAIL PROTECTED] Fax +46 (0)8 406 79 50 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenberg INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Chandini Paterson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Decimal to Hex conversion
There probably is a package called base_convert. I haven't used it but it showed up on Metalink, try it out. -- Deepak --- "Foelz.Frank" [EMAIL PROTECTED] wrote: Hi everybody, I am facing a problem converting from decimal values to hexadecimal values. i.e. col1 col2 -- 2021 801 should give (2021*65536+801)=132449057 I am asked to present this value in hexView like : 07E50321 any suggestions howto convert (probably via simple SQL) ? TNX Frank Foelz sorry, but I posted this to [EMAIL PROTECTED], already. We are facing problems with some mailservers today. _ Scheidt Bachmann GmbH Gestaltung Parkhaussysteme Breite Strasse 132 41238 Moenchengladbach Phone : ++49 2166 / 266 - 837 Fax: ++49 2166 / 266 - 615 e-mail : mailto:[EMAIL PROTECTED] URL: http://www.scheidt-bachmann.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Foelz.Frank INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 DBA, Minneapolis, MN USA __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Sharma INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Parameter obsolete
Hello Beatriz, This parameter has been made into a hidden parameter as part of Oracle's drive to reduce the complexity of your job. Just put an underscore in front of the parameter name and Oracle will assume that you know what you're doing and will stop complaining. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Friday, 9 February 2001 3:16 To: Multiple recipients of list ORACLE-L Hello list, This question is not a matter or life or death but a curiosity I have. Im working with Oracle 8.1.6 and NT. Each time I open the database, I get the next message in the XXXALERT.log : Obsolete system parameters with specified values: distributed_lock_timeout I included it the init.ora file following a friend advice, but i have read that it has no sense in this Oracle version, so, could anybody tell me if I can delete it? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Adams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: buffer keep
Hi Kevin, Try the ideal_cache_size.sql script at http://www.ixora.com.au/scripts/cache.htm#ideal_cache_size on the Ixora web site. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Friday, 9 February 2001 1:32 To: Multiple recipients of list ORACLE-L I have put several tables in the buffer_pool keep. i would like to know how to measure how much of the buffer pool is being used and if possible how big are the tables that are in it. i have looked under v$buffer_pool and v$buffer_pool_statistics and dba_tables, but I am not sure how to do this. any help would be greatly appreciated. Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Steve Adams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Applying patches - minimizing database down time
Attention all installation gurus/hacks... I'm looking for suggestions, experiences, and best practices on safely applying Oracle patches and minimizing database down time. By way of example let's say we're going from server version 8.1.6.0.0 to 8.1.6.3.0. Let's also say we're going to apply the 8.1.6.3.0 interMedia patchset. Here are some generalized steps: 1) Uncompress/untar the patchsets to a staging area. 2) Whilst the database is up, run the installer to install all the requisite software to a new $ORACLE_HOME. old $ORACLE_HOME = /u01/app/oracle/product/8.1.6 new $ORACLE_HOME = /u01/app/oracle/product/8.1.6.3.0 export ORACLE_HOME=/u01/app/oracle/product/8.1.6.3.0 /u01/app/oracle/product/8.1.6/bin/runInstaller 3) Whilst the database is up, copy interMedia executables and libraries to the appropriate sub-directores of the new $ORACLE_HOME. 4) Whilst the database is up, run the installer to install the new patches pointing it to the staging area in step 1. 5) Shut everything down. Shutdown Oracle dependent processes like ctxsrv. Shutdown the listener. Shutdown the database: alter system checkpoint; shutdown abort; startup; shutdown immediate; Do not make any cold backups. Depend on RMAN backups for recovery should anything go awry. 6) Relink oracle. make -f ins_rdbms.mk ioracle 7) Change the PATH and oratab to reflect the new $ORACLE_HOME. 8) Startup the database, listener, and ctxsrv to make the application available. 9) With everything up, run the SQL scripts to complete the patch: @catalog.sql @catproc.sql @catrep.sql create or replace java system; -- interMedia stuff @dr0pkh.sql @dr0plb.sql @dr0type.plb 10) scan/recompile invalid objects. HERE'S THE PIVOTAL ISSUE... Depending on resources step 9 could take about two hours. What are the effects of executing this while the application is running? Comments and suggestions? TIA, Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Orr INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Hit Ratio fallen through the floor at 31% since a db crash yester
Title: Hit Ratio fallen through the floor at 31% since a db crash yesterday We are running 8.1.5 on Solaris. We can't seem to find the cause - everything is up and running fine, just extremely slow. What should we be looking at? TIA, Barb
8.1.5 or 8.1.7 and app 11.0 or 11i
Hello everyone I am in the process of upgrading oracle financial application from 10.7 (now running on HPUX 10.20 and oracle 7.3.4.4) to 11.0 or 11i. I have two questions 1- which one of the oracle version is more stable 8.1.5 or 8.1.7 (I will be upgrading HPUX to 11.0) 2- what is the difference between 11i and 11.0 and what are the gotchas to look for and what is the recommended verion. 3- which combination is more appropriate and stabe, please tell HPUX 11.0 oracle 8.1.7 app 11i HPUX 11.0 oracle 7.3.4.4 app 11.0 HPUX 11.0 oracle 8.1.7 app 11.0 HPUX 10.20 oracle 8.1.5 app 10.7 HPUX 11.0 oracle 8.1.7 app 10.7 Or any other recommended combination Thank you very much in replying to this I need help here Thanks again __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mukesh Ghildiyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: TABLE CACHE
Hi Oli My question is how to compute memeory require by table. Regards -Mala From: Oliver Artelt [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: TABLE CACHE Date: Wed, 07 Feb 2001 13:34:44 -0800 Hi select blocks from dba_segments where segment_name ='table' shows the size of your table. oli On Wednesday 07 February 2001 19:54, [EMAIL PROTECTED] wrote: Hi DBAs I have one large table.I want to keep it into memory thru alter table tname cache; Is there any computation formula how much ram this table takes. Please help me.Thanks in advance. Regards -Mala _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- --- Oliver Artelt, System- und Datenbankadministration --- cubeoffice GmbH Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mala 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: Applying patches - minimizing database down time
(Not a sales pitch) Talk to your Quest rep about a product they are working on or is already available which will allow you to do upgrades/patches with no or minimal downtime. It involves a kind of replication. The way I see it is you must have some kind of replication if you want to make upgrades or patches truly transparent (ie. no or minimal downtime). I would not make a database to the users will running catalog, catproc, etc. HTH Gerardo -Original Message- Sent: Thursday, February 08, 2001 10:23 AM To: Multiple recipients of list ORACLE-L Attention all installation gurus/hacks... I'm looking for suggestions, experiences, and best practices on safely applying Oracle patches and minimizing database down time. By way of example let's say we're going from server version 8.1.6.0.0 to 8.1.6.3.0. Let's also say we're going to apply the 8.1.6.3.0 interMedia patchset. Here are some generalized steps: 1) Uncompress/untar the patchsets to a staging area. 2) Whilst the database is up, run the installer to install all the requisite software to a new $ORACLE_HOME. old $ORACLE_HOME = /u01/app/oracle/product/8.1.6 new $ORACLE_HOME = /u01/app/oracle/product/8.1.6.3.0 export ORACLE_HOME=/u01/app/oracle/product/8.1.6.3.0 /u01/app/oracle/product/8.1.6/bin/runInstaller 3) Whilst the database is up, copy interMedia executables and libraries to the appropriate sub-directores of the new $ORACLE_HOME. 4) Whilst the database is up, run the installer to install the new patches pointing it to the staging area in step 1. 5) Shut everything down. Shutdown Oracle dependent processes like ctxsrv. Shutdown the listener. Shutdown the database: alter system checkpoint; shutdown abort; startup; shutdown immediate; Do not make any cold backups. Depend on RMAN backups for recovery should anything go awry. 6) Relink oracle. make -f ins_rdbms.mk ioracle 7) Change the PATH and oratab to reflect the new $ORACLE_HOME. 8) Startup the database, listener, and ctxsrv to make the application available. 9) With everything up, run the SQL scripts to complete the patch: @catalog.sql @catproc.sql @catrep.sql create or replace java system; -- interMedia stuff @dr0pkh.sql @dr0plb.sql @dr0type.plb 10) scan/recompile invalid objects. HERE'S THE PIVOTAL ISSUE... Depending on resources step 9 could take about two hours. What are the effects of executing this while the application is running? Comments and suggestions? TIA, Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Orr INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Molina, Gerardo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 8.1.5 or 8.1.7 and app 11.0 or 11i
Is 8.1.7 even certified with the APPS?? Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 (216) 781-4204 Mukesh Ghildiyal [EMAIL PROTECTED] 2/8/01 1:55:58 PM Hello everyone I am in the process of upgrading oracle financial application from 10.7 (now running on HPUX 10.20 and oracle 7.3.4.4) to 11.0 or 11i. I have two questions 1- which one of the oracle version is more stable 8.1.5 or 8.1.7 (I will be upgrading HPUX to 11.0) 2- what is the difference between 11i and 11.0 and what are the gotchas to look for and what is the recommended verion. 3- which combination is more appropriate and stabe, please tell HPUX 11.0 oracle 8.1.7 app 11i HPUX 11.0 oracle 7.3.4.4 app 11.0 HPUX 11.0 oracle 8.1.7 app 11.0 HPUX 10.20 oracle 8.1.5 app 10.7 HPUX 11.0 oracle 8.1.7 app 10.7 Or any other recommended combination Thank you very much in replying to this I need help here Thanks again __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mukesh Ghildiyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content="text/html; charset=iso-8859-1" http-equiv=Content-Type META content="MSHTML 5.00.3211.1700" name=GENERATOR/HEAD BODY style="FONT: 10pt Courier New; MARGIN-LEFT: 2px; MARGIN-TOP: 2px" DIVIs 8.1.7 even certified with the APPS??/DIV DIVnbsp;/DIV DIVJeffrey BeckstromBRDatabase AdministratorBRGreater Cleveland Regional Transit AuthorityBR1240 W. 6th StreetBRCleveland, Ohio 44113BR(216) 781-4204BRBRgt;gt;gt; Mukesh Ghildiyal lt;[EMAIL PROTECTED]gt; 2/8/01 1:55:58 PM gt;gt;gt;BRHellonbsp; everyoneBRBRI am in the process of upgrading oracle financialBRapplication from 10.7 (now running on HPUX 10.20 andBRoracle 7.3.4.4) to 11.0 or 11i. I have two questionsBRBRnbsp;nbsp;nbsp; 1- which one of the oracle version is more stableBR8.1.5 or 8.1.7 (I will be upgrading HPUX to 11.0)BRnbsp;nbsp; BRnbsp; 2- what is the difference between 11i and 11.0 andBRwhat are the gotchas to look for and what is theBRrecommended verion.BRBR3- which combination is more appropriate and stabe,BRplease tellBRBRnbsp;nbsp;nbsp; HPUX 11.0 oracle 8.1.7 app 11iBRnbsp;nbsp;nbsp; HPUX 11.0 oracle 7.3.4.4 app 11.0BRnbsp;nbsp;nbsp; HPUX 11.0 oracle 8.1.7 app 11.0BRnbsp;nbsp;nbsp; HPUX 10.20 oracle 8.1.5 app 10.7BRnbsp;nbsp;nbsp; HPUX 11.0 oracle 8.1.7 app 10.7BRBROr any other recommended combinationBRBRBRThank you very much in replying to this BRBRI neednbsp; help here BRBRThanks againBRBRBRBR__BRDo You Yahoo!?BRGet personalized email addresses from Yahoo! Mail - only $35 BRa year!nbsp; A href="http://personal.mail.yahoo.com/"http://personal.mail.yahoo.com//ABR-- BRPlease see the official ORACLE-L FAQ: A href="http://www.orafaq.com"http://www.orafaq.com/ABR-- BRAuthor: Mukesh GhildiyalBRnbsp; INET: [EMAIL PROTECTED]BRBRFat City Network Servicesnbsp;nbsp;nbsp; -- (858) 538-5051nbsp; FAX: (858) 538-5051BRSan Diego, Californianbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; -- Public Internet access / Mailing ListsBRBRTo REMOVE yourself from this mailing list, send an E-Mail messageBRto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inBRthe message BODY, include a line containing: UNSUB ORACLE-LBR(or the name of mailing list you want to be removed from).nbsp; You mayBRalso send the HELP command for other information (like subscribing).BR/DIV/BODY/HTML
Re: Hit Ratio fallen through the floor at 31% since a db crash yester
If I were you I would check whether anything went wrong with the parameter file while recovering from the crash. MAke sure Pramter settings are as is before the crash. Check your indexes, trigeers. Check whether the packages and procedures are pinned as they were before crash. These are few of the things I can think of while waiting eagerly for aday off tomorrow. Hope this helps. Shaibal Barbra Hale [EMAIL PROTECTED] wrote: We are running 8.1.5 on Solaris. We can't seem to find the cause - everything is up and running fine, just extremely slow. What should we be looking at? TIA, Barb Do You Yahoo!? - Get personalized email addresses from Yahoo! Mail Personal Address - only $35 a year!
RE: TABLE CACHE
I think we are understanding your question. The answer simply is that RAM use equals disk use. The size of your table on disk is what it will need in memory. -Original Message- From: mala singh [SMTP:[EMAIL PROTECTED]] Sent: Thursday, February 08, 2001 1:21 PM To: Multiple recipients of list ORACLE-L Subject: Re: TABLE CACHE Hi Oli My question is how to compute memeory require by table. Regards -Mala From: Oliver Artelt [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: TABLE CACHE Date: Wed, 07 Feb 2001 13:34:44 -0800 Hi select blocks from dba_segments where segment_name ='table' shows the size of your table. oli On Wednesday 07 February 2001 19:54, [EMAIL PROTECTED] wrote: Hi DBAs I have one large table.I want to keep it into memory thru alter table tname cache; Is there any computation formula how much ram this table takes. Please help me.Thanks in advance. Regards -Mala _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- --- Oliver Artelt, System- und Datenbankadministration --- cubeoffice GmbH Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mala 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Elliott, Patrick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Scripts -- Scripts -- Scripts
Go thru my SQL's in my web site and you will find all the SQL's you are looking for. Santhosh Channa http://www.geocities.com/csbabu (or) http://www.csbabu.com -Original Message- From: Pablo ksksksk [SMTP:[EMAIL PROTECTED]] Sent: Thursday, February 08, 2001 12:06 PM To: Multiple recipients of list ORACLE-L Subject: Scripts -- Scripts -- Scripts Hi List, Does anyone have some sql scripts to share that shows things such as table structure, index structure, triggers (their code), procedures code, etc. I'm on a migration and I want to make sure I'm not forgetting anything. Any help would be appreciated. Thanks ___ Do You Yahoo!? Enva mensajes instantneos y recibe alertas de correo con Yahoo! Messenger - http://messenger.yahoo.es -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Pablo=20ksksksk?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Channa, Santhosh, SITS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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[2]: On-Call - terms, conidtions and perks!
Cherie, We have specific response criteria. From the time of the page your suppose to a)contact the person paging within 15 minutes, b)1 hour till online from home c)4 hours till in the office (if required). Normally our HelpDesk acts as the first line of defense from 7am till 11pm. after that the users can call direct to the pager/cellphone. My NT program calls the pager 24x7 no matter what. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 2/8/2001 7:21 AM Sean, This reply sounds different from the others but I thought I would throw it out for comparison. I am a full-time employee at a smallish company. When I was hired, part of the job description was to be on-call. We went over the specifics in some detail before I signed on for the job. There was no specific monetary compensation for being on-call but I was offered what I considered to be a very generous salary which I accepted with full knowlege of the on-call requirement. That said, I was on call 24 hours a day seven days a week for five months straight except for a 4-day reprieve in October. Once we finally were able to hire a new DBA and bring him up to speed, I've been trading off being on-call with him for the last month. We take seven-day rotations from Friday to Friday. No particular compensation per se other than our boss will give us a day off if it's been a particularly bad weekend. I have a laptop and a beeper to accomplish this. Our computer center pages us if certain database jobs fail. Anyone in our company who has access to the pager database can page us at will. Usually they're not too abusive of the privilege but I try to discourage pages for things that I feel can wait til the next day (non-Production problems). I get paged an average of once or twice a week. Lately we haven't been getting many pages at all as things have settled down somewhat. Sometimes we get paged a lot more often. Once paged we're supposed to reply promptly (who knows how that is defined). Usually if I don't respond within 15 minutes I get paged again or they call me directly at home. If they can't reach me for some reason after a half hour or an hour, they will page or call the other DBA(s). We don't currently have a formal backup DBA arrangement. Once I talk with whoever paged, I get the picture of the problem, log in from home and fix the problem. Then I call them back or send an email. At a previous contract position at a large company, DBAs were on-call for a week at a time every 8 weeks. Employees earned an extra day of vacation for every week of being on call. Contractors were paid $7 per hour for all 24 hours of being on call and switched over to billing full hourly rate once called (1 hour minimum). Most of the DBAs at that company seemed satisfied with the situation. Just curious- how many DBAs allow coworkers to page them at will or to call them at their home phone number? Is that a fairly common practice? Thanks, Cherie Machler Gelco Information Network "O'Neill, Sean" [EMAIL PROTECTED] on 02/08/2001 04:40:56 AM Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Cherie Machler/GELCO) Hi Folks, Our company has inidicated it's heading for 24 x 7 operation. So informal talks are taking place about the new "challenges" this brings regarding having staff on call to support IT systems. I would very much appreciate your feedback if you are in an on-call environment as to what the terms, conditions, and perks (if any) you get for same. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
for SCSA
Hi Guys I want prepare for SCSA, Could you recommend any specific books for These two papers?? Thanks in advance Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Hit Ratio fallen through the floor at 31% since a db crash ye
Title: Hit Ratio fallen through the floor at 31% since a db crash yesterday I tried that one already!! -Original Message-From: Kimberly Smith [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 08, 2001 12:19 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Hit Ratio fallen through the floor at 31% since a db crash ye Here we like to blame the network on all problems, irregardless of what it is (mostly to bug the network guy). -Original Message-From: Barbra Hale [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 08, 2001 11:02 AMTo: Multiple recipients of list ORACLE-LSubject: Hit Ratio fallen through the floor at 31% since a db crash yester We are running 8.1.5 on Solaris. We can't seem to find the cause - everything is up and running fine, just extremely slow. What should we be looking at? TIA, Barb
RE: Hit Ratio fallen through the floor at 31% since a db crash ye
Title: Hit Ratio fallen through the floor at 31% since a db crash yesterday Checkforlostorinvalidindexes -Original Message-From: Barbra Hale [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 08, 2001 12:02 PMTo: Multiple recipients of list ORACLE-LSubject: Hit Ratio fallen through the floor at 31% since a db crash yester We are running 8.1.5 on Solaris. We can't seem to find the cause - everything is up and running fine, just extremely slow. What should we be looking at? TIA, Barb
RE: Hit Ratio fallen through the floor at 31% since a db crash ye
Just wondering...how long was the instance up before the crash? Could it be that your buffer cache just hasn't built up to where it was before the crash? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Thursday, February 08, 2001 13:02 To: Multiple recipients of list ORACLE-L We are running 8.1.5 on Solaris. We can't seem to find the cause - everything is up and running fine, just extremely slow. What should we be looking at? TIA, Barb This message has been scanned for viruses with Trend Micro's Interscan VirusWall. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Applying patches - minimizing database down time
Do you have a test instance to apply the patches to? Check the release notes, and see if any DDL is included in the patch. If none of the database objects change, then you do not need to run the rdbms scripts. Also, I have heard that you cannot copy oracle homes any more with the new "Universal" installer. You have to reinstall the base software to the new directory. It keeps track of the directory it is installed in and will not run out of a new directory. -Original Message- From: Steve Orr [SMTP:[EMAIL PROTECTED]] Sent: Thursday, February 08, 2001 2:45 PM To: Multiple recipients of list ORACLE-L Subject: RE: Applying patches - minimizing database down time Yeah, I like the theory but putting the theory into practice is another story. Maybe I'll try it another day. I thought Oracle supported 24X7 Internet ecommerce. Well I guess it does if you never need to upgrade, as if that were a realistic option. Or if you want to work 80+ hours to reduce database down time from 1 hour to 5 minutes. "Patches? We don't need no stinkin' patches!" L.E. Returning to Dog Patch, Lil' Abner -Original Message- Patrick Sent: Thursday, February 08, 2001 12:21 PM To: Multiple recipients of list ORACLE-L You might consider cloning your database, and then using logminer to extract the changes to the production database that occur during the upgrade to the cloned database. The sql extracted from the logs using logminer can then be run against the upgraded clone after shutting down production and before letting the users loose on the database. Of course you will want to do this at a time of low update/delete activity to minimize the time that it will take to execute the sql on the upgraded clone. I have not actually done this, but in theory it should work. Look into the documentation for logminer. -Original Message- From: Molina, Gerardo [SMTP:[EMAIL PROTECTED]] Sent: Thursday, February 08, 2001 12:56 PM To: Multiple recipients of list ORACLE-L Subject:RE: Applying patches - minimizing database down time (Not a sales pitch) Talk to your Quest rep about a product they are working on or is already available which will allow you to do upgrades/patches with no or minimal downtime. It involves a kind of replication. The way I see it is you must have some kind of replication if you want to make upgrades or patches truly transparent (ie. no or minimal downtime). I would not make a database to the users will running catalog, catproc, etc. HTH Gerardo -Original Message- Sent: Thursday, February 08, 2001 10:23 AM To: Multiple recipients of list ORACLE-L Attention all installation gurus/hacks... I'm looking for suggestions, experiences, and best practices on safely applying Oracle patches and minimizing database down time. By way of example let's say we're going from server version 8.1.6.0.0 to 8.1.6.3.0. Let's also say we're going to apply the 8.1.6.3.0 interMedia patchset. Here are some generalized steps: 1) Uncompress/untar the patchsets to a staging area. 2) Whilst the database is up, run the installer to install all the requisite software to a new $ORACLE_HOME. old $ORACLE_HOME = /u01/app/oracle/product/8.1.6 new $ORACLE_HOME = /u01/app/oracle/product/8.1.6.3.0 export ORACLE_HOME=/u01/app/oracle/product/8.1.6.3.0 /u01/app/oracle/product/8.1.6/bin/runInstaller 3) Whilst the database is up, copy interMedia executables and libraries to the appropriate sub-directores of the new $ORACLE_HOME. 4) Whilst the database is up, run the installer to install the new patches pointing it to the staging area in step 1. 5) Shut everything down. Shutdown Oracle dependent processes like ctxsrv. Shutdown the listener. Shutdown the database: alter system checkpoint; shutdown abort; startup; shutdown immediate; Do not make any cold backups. Depend on RMAN backups for recovery should anything go awry. 6) Relink oracle. make -f ins_rdbms.mk ioracle 7) Change the PATH and oratab to reflect the new $ORACLE_HOME. 8) Startup the database, listener, and ctxsrv to make the application available. 9) With everything up, run the SQL scripts to complete the patch: @catalog.sql @catproc.sql @catrep.sql create or replace java system; -- interMedia stuff @dr0pkh.sql @dr0plb.sql @dr0type.plb 10) scan/recompile invalid objects. HERE'S THE PIVOTAL ISSUE... Depending on resources step 9 could take about two hours. What are the effects of executing this while the application is running? Comments and suggestions? TIA, Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Orr INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,
RE: Hit Ratio fallen through the floor at 31% since a db crash ye
Barb, pick the slowest application and examine it for the waits. What is the application waiting for? Take a look at v$session_event (cumulative) and v$session_wait (current wait). If you see things like "scattered db file read' or 'sequential db file read', then you have a problem with access path (optimizer). If that is the case, you'll need to pull a few tricks with the optimizer. The best thing that can be done with the optimizer on 8.1.5 is the upgrade to 8.1.7. If you have 'enqueue wait', examine your ITL, (initrans/maxtrans) and lock related parameters. If you have "log space waits", increase your log buffer. If you have "free buffer waits", increase your buffer cache. Next, examine your alert log and examine the frequency of checkpoints. If that is more then once every 10 minutes or so, increase your logfiles in size numbers. Size does matter! When this is done, examine your v$librarycache and v$rowcache, pin the frequently used procedures and adjust the size of your shared pool. Next, consider using MTS and defining the large pool to separate your sorts and hash actions from your PL/SQL objects. After that, examine your tables and see how are they used. Put the big reference tables in hash clusters, the small ones in the "KEEP" buffer pool and put the transaction and the history tables in the "RECYCLE" buffer pool. consider using the partitioning option for your largest tables and consider moving all your objects to locally managed tablespaces. do not forget to spread your IO across several controllers. With a little luck, you will be done just in time to perform the next major upgrade, when the process will start all over again. Enjoy! -Original Message- Sent: Thursday, February 08, 2001 3:45 PM To: Multiple recipients of list ORACLE-L I tried that one already!! -Original Message- Sent: Thursday, February 08, 2001 12:19 PM To: Multiple recipients of list ORACLE-L Here we like to blame the network on all problems, irregardless of what it is (mostly to bug the network guy). -Original Message- Sent: Thursday, February 08, 2001 11:02 AM To: Multiple recipients of list ORACLE-L We are running 8.1.5 on Solaris. We can't seem to find the cause - everything is up and running fine, just extremely slow. What should we be looking at? TIA, Barb -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Hit Ratio fallen through the floor at 31% since a db crash ye
Title: RE: Hit Ratio fallen through the floor at 31% since a db crash ye It had only been up for a few weeks. It could be the buffer cache. -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 08, 2001 1:03 PM To: Multiple recipients of list ORACLE-L Subject: RE: Hit Ratio fallen through the floor at 31% since a db crash ye Just wondering...how long was the instance up before the crash? Could it be that your buffer cache just hasn't built up to where it was before the crash? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Thursday, February 08, 2001 13:02 To: Multiple recipients of list ORACLE-L We are running 8.1.5 on Solaris. We can't seem to find the cause - everything is up and running fine, just extremely slow. What should we be looking at? TIA, Barb This message has been scanned for viruses with Trend Micro's Interscan VirusWall. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 8.1.7 DB and auto registration with Listener
the list ROCKS!!! -Original Message- Kirti Sent: Thursday, February 08, 2001 4:15 PM To: Multiple recipients of list ORACLE-L Hi Gilles, Thanks for the tip. It is now working.. My TAR with OWS is awaiting reply from Oracle Internals team (whatever that means;).. for the past 2 days.. Once again the list does get the job done faster :) - Kirti Deshpande Verizon Information Services -Original Message- From: Gilles PARC [SMTP:[EMAIL PROTECTED]] Sent: Thursday, February 08, 2001 2:07 PM To: Multiple recipients of list ORACLE-L Subject: Re: 8.1.7 DB and auto registration with Listener Hi Kirti, I have the same problem here on Aix 4.3..3 / RDBMS 8.1.7 : restarting or reloading the listener, pmon gets stuck on socket (close_wait status) and never register again the database. But today i find a workaround simply putting INSTANCE_NAME parameter in my init.ora file I have opened a TAR with OWS and they are supposed to fill a new bug. Hope this helps in your situation Best Regards Gilles Parc Email : [EMAIL PROTECTED] carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gilles PARC INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: MINUS VS NOT IN
The reason the minus is so much faster is because it does a hash join. Try adding a /*+ hash_aj */ hint to the "not in" and you should get better response. Also, there is no need to put a distinct in the second select of the minus or the sub select of the "not in". Minus will do a sort distinct anyway. Here is the new sql. select distinct icons from inpatient where icons not in (select /*+ hash_aj */ icons from ptca) / -Original Message- From: Peter Hazelton [SMTP:[EMAIL PROTECTED]] Sent: Thursday, February 08, 2001 3:03 PM To: Multiple recipients of list ORACLE-L Subject: MINUS VS NOT IN Hello all. I read a question concerning the use of the MINUS function earlier and I had not heard of it before today. After some experimenting with it, I was quite amazed at the speed of this function compared to using NOT IN. Considering the following: Query One select distinct icons from inpatient minus select distinct icons from ptca; Query 2 select distinct icons from inpatient where icons NOT IN(select distinct icons from ptca) Query number one began to run in about 5 seconds whereas query 2 took forever to run. My question is why is the MINUS so much faster? My understanding of the NOT IN is that it probably builds the record set in the second part of the SQL query each time it comes to a new icons number in the first part of the query. Therefore, if there are one thousand records to be searched, it probably builds the record set one thousand times. Is this correct? If so, how does the MINUS function build and compare the record set? And finally, where do I get these wonderful little tidbits? Would a SQL tuning book exist that might talk about the strengths and limitations of different functions? I really appreciate your time and input. Petre Hazelton Halifax, Nova Scotia CANADA _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Hazelton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Elliott, Patrick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Decimal to Hex conversion
On Thu, 8 Feb 2001, Deepak Sharma wrote: There probably is a package called base_convert. I haven't used it but it showed up on Metalink, try it out. -- Deepak Here's a modified version of one from Tom Kyte. He had separate functions, I prefer a package. Jared -- ** some test code here --- select radix.to_hex(285) from dual; select radix.to_dec('11D', 16) from dual; select radix.to_bin(255) from dual; select radix.to_bin(256) from dual; --- create or replace package radix is /* courtesy of Thomas Kyte */ function to_base( p_dec in number, p_base in number ) return varchar2; function to_dec ( p_str in varchar2, p_from_base in number default 16 ) return number; function to_hex( p_dec in number ) return varchar2; function to_bin( p_dec in number ) return varchar2; function to_oct( p_dec in number ) return varchar2; pragma restrict_references( to_base, wnds, rnds, wnps, rnps ); pragma restrict_references( to_dec, wnds, rnds, wnps, rnps ); pragma restrict_references( to_hex, wnds, rnds, wnps, rnps ); pragma restrict_references( to_bin, wnds, rnds, wnps, rnps ); pragma restrict_references( to_oct, wnds, rnds, wnps, rnps ); end radix; / show errors create or replace package body radix is function to_base( p_dec in number, p_base in number ) return varchar2 is l_str varchar2(255) default NULL; l_num number default p_dec; l_hex varchar2(16) default '0123456789ABCDEF'; begin if ( trunc(p_dec) p_dec OR p_dec 0 ) then raise INVALID_NUMBER; end if; loop l_str := substr( l_hex, mod(l_num,p_base)+1, 1 ) || l_str; l_num := trunc( l_num/p_base ); exit when ( l_num = 0 ); end loop; return l_str; end to_base; function to_dec ( p_str in varchar2, p_from_base in number default 16 ) return number is l_num number default 0; l_hex varchar2(16) default '0123456789ABCDEF'; begin for i in 1 .. length(p_str) loop l_num := l_num * p_from_base + instr(l_hex,upper(substr(p_str,i,1)))-1; end loop; return l_num; end to_dec; function to_hex( p_dec in number ) return varchar2 is begin return to_base( p_dec, 16 ); end to_hex; function to_bin( p_dec in number ) return varchar2 is begin return to_base( p_dec, 2 ); end to_bin; function to_oct( p_dec in number ) return varchar2 is begin return to_base( p_dec, 8 ); end to_oct; end radix; / show errors -- 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: STARTUP Force
Yeah right! I have six years of experience and I use shutdown abort all the time. Just force a checkpoint first to speed up hot recovery on the startup. The other forms of shutdown take too long, and may never complete if you have long running transactions that don't do frequent commits. Check out the following paper if you think I am wrong... http://www.wolfenet.com/~jeremiah/241.pdf Startup force, on the other hand, I would never use this unless I had a high level oracle support engineer holding my hand. -Original Message- From: Mark Leith [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 8:01 AM To: Multiple recipients of list ORACLE-L Subject: RE: STARTUP Force One thing I would say Neena - ONLY use SHUTDOWN ABORT as an absolute LAST resort!! If you are shuting down the database normally, on 8, first do a SHUTDOWN TRANSACTIONAL, if you need to close the database quickly, try a SHUTDOWN IMMEDIATE, wait for 5 or so minutes, and if all else fails ONLY THEN issue a SHUTDOWN ABORT!! SHUTDOWN ABORT can cause corruption, and recovering is a bit of a pain the arse (as a list memeber found out recently).. You don't seem to have a lot of experience with Oracle, as Joe mentioned. Now I have around 3 years experience and STILL have NO experience with Backup and Recovery (fair enough it is not an issue for me). Grab hold of the Oracle docs from http://www.otn.oracle.com/ and start reading away. Regards Mark -Original Message- Testa Sent: Wednesday, February 07, 2001 12:30 To: Multiple recipients of list ORACLE-L Neena, after looking at your last 3 messages, you need to sit down and read the administrators guide, 90% of your questions are answered in that book and nowadays there is no excuse for not reading docs(unlike back in version 6 days when people used to hoard the books). joe TIL-TEC wrote: When do a DBA prefers to use STARTUP FORCE than SHUTDOWN ABORT+STARTUP NORMAL ? --Neena -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Elliott, Patrick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle 8i DBA with Solaris Exp. Needed in Phoenix, AZ...
If you're interested in a great career move, then consider this opportunity in Phoenix, AZ with a leading company that needs an Oracle 8i DBA to join it's team. This is a staff position. *Requirements: -2+ yrs Oracle DBA experience is needed... -Oracle 8i experience -Solaris experience -Must have good communication skills -U.S. citizenship or permanent residency required This position is with a company that offers : * Quality Work Environment * Base salary 80-85K * Financial Stability * Relocation Assistance NO sub contracting positions available. PLEASE do not send your resume if you are not in the United States. For immediate consideration, please send your resume to: Email: [EMAIL PROTECTED] Phone: 1-800-549-8502. * Please use job code:One/Phoenix/8i/MaryAnne/ We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiitiondescribed above- if it is not a match for your skills. Thanks, Bill Law OraStaff, Inc-"The Proven Connection To Oracle Opportunity" -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-29521 with Corba Advice ?
How many objects of type "JAVA CLASS" are in the database? In 8.1.6 I have 8544 but that includes a few hundered loaded by a couple of scripts in rdbms admin I think intitjvm creates about 8100 classes. I would expect 8.1.7 to have at least that many. If you have far fewer, perhaps a .jar file is missing? Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Thursday, February 08, 2001 1:35 AM To: Multiple recipients of list ORACLE-L Hello, We have a Oracle 8.1.7 database on Solaris. The characterset is UTF8. I have run initjvm.ora ( How can I check that the installation was ok ?) But when we run loadjava we have errors ORA-29521: referenced name org/omg/CORBA/Any could not be found ORA-29521: referenced name org/omg/CORBA/BAD_TYPECODE could not be found ORA-29521: referenced name org/omg/CORBA/MARSHAL could not be found ORA-29521: referenced name org/omg/CORBA/ORB could not be found Any advice ? Regards Henrik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenberg INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Applying patches - minimizing database down time
Steve, Seems like a fast, secure procedure. One question though, Why would you issue the 'shutdown abort' in step 5 ? You never quite know how long instance recovery will take. Someone mentioned replication. It seems that a standby db might be worth taking a look at. A lot of work building, cutting over, and rebuilding, but may result in minimum downtime. dgm - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, February 08, 2001 4:15 PM Do you have a test instance to apply the patches to? Check the release notes, and see if any DDL is included in the patch. If none of the database objects change, then you do not need to run the rdbms scripts. Also, I have heard that you cannot copy oracle homes any more with the new "Universal" installer. You have to reinstall the base software to the new directory. It keeps track of the directory it is installed in and will not run out of a new directory. -Original Message- From: Steve Orr [SMTP:[EMAIL PROTECTED]] Sent: Thursday, February 08, 2001 2:45 PM To: Multiple recipients of list ORACLE-L Subject: RE: Applying patches - minimizing database down time Yeah, I like the theory but putting the theory into practice is another story. Maybe I'll try it another day. I thought Oracle supported 24X7 Internet ecommerce. Well I guess it does if you never need to upgrade, as if that were a realistic option. Or if you want to work 80+ hours to reduce database down time from 1 hour to 5 minutes. "Patches? We don't need no stinkin' patches!" L.E. Returning to Dog Patch, Lil' Abner -Original Message- Patrick Sent: Thursday, February 08, 2001 12:21 PM To: Multiple recipients of list ORACLE-L You might consider cloning your database, and then using logminer to extract the changes to the production database that occur during the upgrade to the cloned database. The sql extracted from the logs using logminer can then be run against the upgraded clone after shutting down production and before letting the users loose on the database. Of course you will want to do this at a time of low update/delete activity to minimize the time that it will take to execute the sql on the upgraded clone. I have not actually done this, but in theory it should work. Look into the documentation for logminer. -Original Message- From: Molina, Gerardo [SMTP:[EMAIL PROTECTED]] Sent: Thursday, February 08, 2001 12:56 PM To: Multiple recipients of list ORACLE-L Subject: RE: Applying patches - minimizing database down time (Not a sales pitch) Talk to your Quest rep about a product they are working on or is already available which will allow you to do upgrades/patches with no or minimal downtime. It involves a kind of replication. The way I see it is you must have some kind of replication if you want to make upgrades or patches truly transparent (ie. no or minimal downtime). I would not make a database to the users will running catalog, catproc, etc. HTH Gerardo -Original Message- Sent: Thursday, February 08, 2001 10:23 AM To: Multiple recipients of list ORACLE-L Attention all installation gurus/hacks... I'm looking for suggestions, experiences, and best practices on safely applying Oracle patches and minimizing database down time. By way of example let's say we're going from server version 8.1.6.0.0 to 8.1.6.3.0. Let's also say we're going to apply the 8.1.6.3.0 interMedia patchset. Here are some generalized steps: 1) Uncompress/untar the patchsets to a staging area. 2) Whilst the database is up, run the installer to install all the requisite software to a new $ORACLE_HOME. old $ORACLE_HOME = /u01/app/oracle/product/8.1.6 new $ORACLE_HOME = /u01/app/oracle/product/8.1.6.3.0 export ORACLE_HOME=/u01/app/oracle/product/8.1.6.3.0 /u01/app/oracle/product/8.1.6/bin/runInstaller 3) Whilst the database is up, copy interMedia executables and libraries to the appropriate sub-directores of the new $ORACLE_HOME. 4) Whilst the database is up, run the installer to install the new patches pointing it to the staging area in step 1. 5) Shut everything down. Shutdown Oracle dependent processes like ctxsrv. Shutdown the listener. Shutdown the database: alter system checkpoint; shutdown abort; startup; shutdown immediate; Do not make any cold backups. Depend on RMAN backups for recovery should anything go awry. 6) Relink oracle. make -f ins_rdbms.mk ioracle 7) Change the PATH and oratab to reflect the new $ORACLE_HOME. 8) Startup the database, listener, and ctxsrv to make the application available. 9) With everything up, run the SQL scripts to complete the patch: @catalog.sql @catproc.sql
urgent! ora-00600[17003][89907688][0][1]
gurus, i have stored procedures used by forms. when i compile the forms as user1, the ff error occurs: ora-00600 internal error code, arguments[17003][89907688][0][1] ora-00600 internal error code,arguments[17003][87215920][0][1] and the forms get aborted. Illegal operation has occured. User1 has been granted an execute and synonym for these stored procedures by user2. User1's temporary tablespace has increased. Is the error has something to do w/ this? However when i run form under it's original owner user 2, no error occur. pls help... i don't know wat to do anymore! thanks Grace Lim Suy Sing Comm'l Corp. (063)-02-247-41-34 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: grace lim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 816 on linux
Yes...I got almost the same problem. I failed when creating database using dbassist, but I got slightly different error message. It said ORA-03114 (not sure, though) NOT CONNECTED TO ORACLE. It seems that the instance startup failed.. Now, I am trying to create it manually... - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Friday, February 09, 2001 8:55 AM Hi.. I just install Oracle 816 on Redhat 7.0. Installation process went well without creating DB. When I tried to create DB, I got error 3113: end-of-file on communication channel after run "startup nomount pfile = "/u01/app/oracle/admin/hrweb/pfile/inithrweb.ora"". I also lookup in metalink. It told me to remove "remote_login_passwordfile = exclusive" out of init.ora file. I did but it still does not work. Anybody have this kind of error. Please help. Chakaphan Supacharuwong -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nosie INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
sync objects between user's
hi all gurus... I have 2 user, eg : A and B. They have their own object or shema, and some object are same. Now, I have to synchronize their objects, because I want A and B have same objects or schema. If they have some object which last ddl time will be use. Any suggestion ? Thank u Loli
Enqueue types
Title: Enqueue types Does anyone recognize enqueues JI, TC, and TX? (Steve, are you on?) SELECT * FROM x$ksqst WHERE ksqstget 0; EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT --- -- --- enqueue 144378 78718 25112607 173.936521 ADDR INDX INST_ID KS KSQSTGET KSQSTWAT -- -- -- -- -- 000399F11808 69 1 CF 179654 39 000399F11820 72 1 CI 65152 0 000399F11880 84 1 CU 1043538 55 000399F11938 107 1 DL 444 0 000399F11968 113 1 DR 5569 0 000399F11988 117 1 DV 46432 0 000399F11998 119 1 DX 95350 0 000399F11B70 178 1 FS 1 0 000399F11D90 246 1 HW 98917 0 000399F11E70 274 1 IS 9441 0 000399F11F20 296 1 JI 14455 5511 --- 000399F12268 401 1 MR 20 0 000399F12500 484 1 PE 868094 0 000399F12508 485 1 PF 134 0 000399F12568 497 1 PR 93 0 000399F12570 498 1 PS 340 0 000399F12778 563 1 RT 1 0 000399F12860 592 1 SQ 504008 96 000399F12870 594 1 SS 6 0 000399F12878 595 1 ST 21481 1 000399F128F0 610 1 TC 23860 1243 - 000399F12940 620 1 TM 17757089 0 000399F12970 626 1 TS 3829 0 000399F12978 627 1 TT 1352011 0 000399F12998 631 1 TX 16390088 648 000399F12A70 658 1 US 870014 0 000399F12C38 715 1 WL 47348 2 27 rows selected. Any information or referral to a manual is appreciated. I don't have Steve's book with me, unfortunately. Thanks, Linda
AW: Decimal to Hex conversion
Hi helpers, just a note to say thank you, to everyone who gave me hints, packages and func.s !!! Great maillist !!! TNX Frank Foelz _ Scheidt Bachmann GmbH Gestaltung Parkhaussysteme Breite Strasse 132 41238 Moenchengladbach Phone : ++49 2166 / 266 - 837 Fax: ++49 2166 / 266 - 615 e-mail : mailto:[EMAIL PROTECTED] URL: http://www.scheidt-bachmann.de -Ursprngliche Nachricht- Von: Foelz.Frank [mailto:[EMAIL PROTECTED]] Gesendet am: Donnerstag, 8. Februar 2001 11:15 An: Multiple recipients of list ORACLE-L Betreff: Decimal to Hex conversion Hi everybody, I am facing a problem converting from decimal values to hexadecimal values. i.e. col1 col2 -- 2021 801 should give (2021*65536+801)=132449057 I am asked to present this value in hexView like : 07E50321 any suggestions howto convert (probably via simple SQL) ? TNX Frank Foelz sorry, but I posted this to [EMAIL PROTECTED], already. We are facing problems with some mailservers today. _ Scheidt Bachmann GmbH Gestaltung Parkhaussysteme Breite Strasse 132 41238 Moenchengladbach Phone : ++49 2166 / 266 - 837 Fax: ++49 2166 / 266 - 615 e-mail : mailto:[EMAIL PROTECTED] URL: http://www.scheidt-bachmann.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Foelz.Frank INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Foelz.Frank INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).