Re: HELP HELP HELP HELP !!!!!!
Check the Alert log to see what's going on Ali TOYGAR [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] du.tr cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: HELP HELP HELP HELP !! [EMAIL PROTECTED] 11-04-2002 08:28 Please respond to ORACLE-L I faced with following error. ORA-01033: Oracle startup or shutdown in progress What is the problem. I restart server again and again but problem is not solved. Please HELP ME. == De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and 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: Jack van Zanen 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: HELP HELP HELP HELP !!!!!!
What version of Oracle are you using, what is your operating system, and what happened to cause you to resart the server several times? I don't think that's going to help you, in fact it may make things worse. Looks like Oracle is trying to perform an instance recovery from a crash and applying redo logs. Be patient and let it do it's thing.Of course if you're on NT/W2K you may have to stop the Oracle Service, delete the password file and Oracle Service, then recreate the service. David A. BarbourOracle DBA, OCPAISD512-414-1002Ali TOYGAR [EMAIL PROTECTED]Sent by: [EMAIL PROTECTED]04/10/2002 10:28 PM PSTPlease respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: bcc: Subject: HELP HELP HELP HELP !! I faced with following error. ORA-01033: Oracle startup or shutdown in progressWhat is the problem. I restart server again and again but problem is not solved.Please HELP ME. -- 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: HELP HELP HELP HELP !!!!!!
Always try to use a meaningful subject! When ny mail recipe rules ( my consciuos) see a subject like this, its is interpreted for spam or virus mail hence ignored/deleted - could have done better with: Back to the topic: Check the OS logs also for possible cause of loss of services. A clip into your logs will be helpful to us. --- CSW -Original Message- Sent: Thursday, April 11, 2002 10:48 AM To: Multiple recipients of list ORACLE-L Check the Alert log to see what's going on Ali TOYGAR [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] du.tr cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: HELP HELP HELP HELP !! [EMAIL PROTECTED] 11-04-2002 08:28 Please respond to ORACLE-L I faced with following error. ORA-01033: Oracle startup or shutdown in progress What is the problem. I restart server again and again but problem is not solved. Please HELP ME. == De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and 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: Jack van Zanen 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: Simon Waibale 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).
subtract minute from date/time
I want to subtract a minute from a date/time How can I do this? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: subtract minute from date/time
date-1/(24*60*60) Jack John Dunn john.dunn@sefas.To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] co.uk cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: subtract minute from date/time [EMAIL PROTECTED] 11-04-2002 13:08 Please respond to ORACLE-L I want to subtract a minute from a date/time How can I do this? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). == De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and 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: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: subtract minute from date/time
I know that if you have a date field then you can get the hour using the formula date_field/60/60/24 thus to get the minutes will be date_field/60/60 -Original Message- Sent: Thursday, April 11, 2002 14:08 To: Multiple recipients of list ORACLE-L I want to subtract a minute from a date/time How can I do this? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hatzistavrou Giannis 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: subtract minute from date/time
select to_number(to_char(sysdate, 'MI')) from dual; JP On Thu 11. April 2002 13:08, you wrote: I want to subtract a minute from a date/time How can I do this? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: subtract minute from date/time
date_fld - 1/1440 Iain Nicoll Test and Release De-Regulated Services Internal : 700 2331 External : 0141 568 2331 -Original Message- Sent: Thursday, April 11, 2002 12:08 PM To: Multiple recipients of list ORACLE-L I want to subtract a minute from a date/time How can I do this? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nicoll, Iain (Calanais) 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: subtract minute from date/time
To subtract a minute you can do it this way select to_char(sysdate,'DD-MON- HH24:mi:ss') , to_char((sysdate - 1/(24*60)),'DD-MON- HH24:mi:ss') from dual; Hope this answers your query John Dunn [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 04/11/02 04:38 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:subtract minute from date/time I want to subtract a minute from a date/time How can I do this? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: subtract minute from date/time
Try this query: select to_char (sysdate - (1/(24*60) * 5),'HH24:MI:SS') from dual; ^ this subtracts 5 mins from current date time. On Thu, 11 Apr 2002, John Dunn wrote: I want to subtract a minute from a date/time How can I do this? John -- Volkan YILDIRIM Ankara Patent Bureau Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Volkan YILDIRIM 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: disk subsystem performance question
I just started a couple days ago at this client. They're using Hitachi technology in the QA and prod environment with 181G disk. I asked the SA twice and he confirmed the 181 G disk. I'll ask more details to the SA as soon as I know him better. --- Deshpande, Kirti [EMAIL PROTECTED] a écrit : John, I agree with the 18GB drives implementation and pushing for more 'parity groups'. That's what we did. Now, HDS was back to sell more disk and backup soultions to us. I am not sure what we have agreed to purchase. A cache of 10GB for the 400GB database is nothing. I bet you will have tables larger than the cache size. A single FTS on these tables will flush the whole cache... We have 16GB cache (I think I remember that right, and is the max for 7700E), and that is not enough for several servers that the cabinet supports. - Kirti -Original Message- Sent: Wednesday, April 10, 2002 7:08 PM To: Multiple recipients of list ORACLE-L Thanks for all the replies. We are determined to lay out the data as well as we can across the disks we are about to purchase - with the goal of striping across array groups and smaller, faster drives. The real argument for us is 18GB vs. 73GB disk drives and how we can stripe. The Hitachi is configured into groups of 4 physical disks called parity groups and you can choose RAID 5 or RAID 1+0 for that 4 disk set.If you have 73GB drives in a 4-disk RAID 5 configuration you get roughly 219GB of usable space in each parity group (this is what we are being told is the best option for us).This means our heavily concurrently accessed 400GB production database goes on 2 parity groups (2 sets of 4 disks). To me, this sounds like a nightmare waiting to happen and we are trying to stop it.The 18GB drives are less capacity but we can get ourselves spread over more parity groups for better concurrency. We do have about 10GB of cache but it is being shared across the enterprise with various other applications. We as a DBA group are really trying to sell the 18GB RAID 1+0 drive solution especially after reading the groups' experiences - unfortunately we are fighting a lot of marketing hype. If anyone has additional experiences or feedback with Hitachi or EMC they would like to share or comments (agree/disagree) with my thoughts, I'd love to hear them. I'm open for learning! Thanks, John Dailey Oracle DBA ING Americas - Application Services Atlanta, GA Don GranamanTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] granaman@coxcc: .netSubject: Re: disk subsystem performance question Sent by: root@fatcity. com 04/10/2002 01:08 PM Please respond to ORACLE-L Short answer - NO! Nobody's disk subsystem is so fast that no intelligence is required in the layout. This is common vendor blather and one of the most popular myths. I have been hearing it for at least six years - and it still isn't true. Layout still makes a huge difference. RAID levels still make a huge difference. Cache won't solve all your problems (it does help though). I've redone the disk layout on some of the biggest, fastest fully-loaded with cache EMC Syms available that had some don't worry about it layout and seen database throughput go up by as much as 8x. See Gaja's whitepaper on RAID at http://www.quest.com/whitepapers/Raid1.pdf . Don Granaman [certifiable oraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 10, 2002 10:38 AM Hi all, We are running both a Hitachi 7700E and a 9960 disk subsystem here and we are getting ready to move our production DBs from the old(7700E) to the new(9960) Hitachi. We have had trouble in the past on the 7700E due to disk contention and layout, i.e. we weren't striped across the array groups very well this caused pretty poor I/O performance.This has been a learning experience for the DBAs and the SAs here for the logical vs. physical aspects of our disks. Anyway, to make a long story short, we are ordering disk for the move to the 9960 and we have 2 choices in disk sizes - 18GB and 73GB, and 2 choices in RAID - 1+0 and 5. I would like to get the smaller, faster 18GB drives in a RAID 1+0 configuration and stripe our data across the array groups as wide as possible. However, I am running into objections from the Hitachi people that their system is s fast we need not worry about such minor
Re: subtract minute from date/time
Sorry this is one second :-) Jack van Zanen [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) [EMAIL PROTECTED] Subject: Re: subtract minute from date/time 11-04-2002 13:23 Please respond to ORACLE-L date-1/(24*60*60) Jack John Dunn john.dunn@sefas.To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] co.uk cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: subtract minute from date/time [EMAIL PROTECTED] 11-04-2002 13:08 Please respond to ORACLE-L I want to subtract a minute from a date/time How can I do this? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). == De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and 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
Utl_file
Hallo, Is it possible to do a select from some tables in the database and then use utl_file package to create an excel file. And also to make the headers in the columns bold and right positioned. Please give me an easy example on how to write the code. Thanks in advance Roland -- 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: Does index need rebuilding when table is truncated
Good point Robert, The reason the index space still exists after a lot of deletes is the method the index is stored in the database. very similar to the old organization chart of a large corporation. If you eliminate all of the people between the CEO and the janitor you still have the multiple levels displayed on the chart. The may be vacant and just pointers to the next lower level but the still exist on the chart. Indexes are stored the same way. One block points to the next and so forth from the top to the bottom. Remove all of the data between the two and the path from the top to the bottom still exists thus the index storage is still used. If you export the data, truncate the table and import the data the path becomes top-to-bottom one step and the old index storage area is freed up. The janitor then reports directly to the CEO. Ron ROR mª¿ªm [EMAIL PROTECTED] 04/09/02 06:33PM There is not a HWM indicator for an index as there is for a table. When a truncate occurs, the blocks are cleared in the index and the extents (beyond the initial extent) are deallocated (assuming you do not issue the reuse storage clause). RF -Original Message- Sent: Tuesday, April 09, 2002 5:52 PM To: Multiple recipients of list ORACLE-L Hello, Lisa, what I was wondering when I read Rick's e-mail was... what about the HWM for the indexes when someone truncates a table. The table's HWM pointer gets reset of course, but I can never recall seeing anything about what happens to the index space. Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 09, 2002 5:33 PM To: Multiple recipients of list ORACLE-L Hi Rick, Nope. Try it. You'll see that the extents clear up just like the extents in the table do, if you don't specify the REUSE STORAGE clause. Lisa Koivu Oracle Database Tank Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 5:11 PM To: Multiple recipients of list ORACLE-L Subject: Does index need rebuilding when table is truncated Hi All, I know if you delete lots of data using delete the indexes may need rebuilding. Is this the case if the table is truncated? Thanks Rick -- 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: Koivu, Lisa 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: Sherman, Paul R. 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: Freeman, Robert 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
RE: subtract minute from date/time
I'm glad its not just me thats having a bad morning making the numbers work... My understanding of it goes something like this: When working with date/times, oracle considers 1 to mean One day. There are 24 hours in every day, so to get the figure for one hour you use 1/24 eg sysdate - 1/24 would give you the time one hour ago. There are 60 minutes in each hour, so one minute is 1/(24*60) Which is 24 hours times 60 minutes Similarly, if you wanted seconds there are 60 in each minute, so 1 second is 1/(24*60*60) Thats one day divided by (number of hours in a day * number of minutes in an hour * number of seconds in a minute) You can probably do the same thing with decimals, but the numbers are messy. If Oracle handled anything smaller than a second, we'd probably start seeing issues with rounding errors... Hope thats clear and I haven't made any obvious mistakes. Simon Anderson -Original Message- Sent: Thursday, April 11, 2002 14:08 To: Multiple recipients of list ORACLE-L I want to subtract a minute from a date/time How can I do this? John -- -- 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).
PLS-00201: identifier 'SYS.DBMS_AQ' must be declared
Hi all. I am using the package dbms_aq in a pl/sql program and it's working fine but when i changed the same program into a trigger it's showing the error PLS-00201: identifier 'SYS.DBMS_AQ' must be declared. I have granted execute permission on dbms_aq to that user . Do i need to grant any more permission at access dbms_aq in a trigger ...??? If so which privilege or role should i grant ?? Please help. Thanks in advance regards, shibu Oracle DBA Acusis - Bangalore
Re: Utl_file
utl_file.put_line(file_id, col1||','|| col2||','|| col3); etc for a CSV file hth connor --- [EMAIL PROTECTED] wrote: Hallo, Is it possible to do a select from some tables in the database and then use utl_file package to create an excel file. And also to make the headers in the columns bold and right positioned. Please give me an easy example on how to write the code. Thanks in advance Roland -- 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 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: Does index need rebuilding when table is truncated
But the original poster was referring to a truncate ... aka Enron using your metaphor :-) Cheers Connor --- Ron Rogers [EMAIL PROTECTED] wrote: Good point Robert, The reason the index space still exists after a lot of deletes is the method the index is stored in the database. very similar to the old organization chart of a large corporation. If you eliminate all of the people between the CEO and the janitor you still have the multiple levels displayed on the chart. The may be vacant and just pointers to the next lower level but the still exist on the chart. Indexes are stored the same way. One block points to the next and so forth from the top to the bottom. Remove all of the data between the two and the path from the top to the bottom still exists thus the index storage is still used. If you export the data, truncate the table and import the data the path becomes top-to-bottom one step and the old index storage area is freed up. The janitor then reports directly to the CEO. Ron ROR mª¿ªm [EMAIL PROTECTED] 04/09/02 06:33PM There is not a HWM indicator for an index as there is for a table. When a truncate occurs, the blocks are cleared in the index and the extents (beyond the initial extent) are deallocated (assuming you do not issue the reuse storage clause). RF -Original Message- Sent: Tuesday, April 09, 2002 5:52 PM To: Multiple recipients of list ORACLE-L Hello, Lisa, what I was wondering when I read Rick's e-mail was... what about the HWM for the indexes when someone truncates a table. The table's HWM pointer gets reset of course, but I can never recall seeing anything about what happens to the index space. Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 09, 2002 5:33 PM To: Multiple recipients of list ORACLE-L Hi Rick, Nope. Try it. You'll see that the extents clear up just like the extents in the table do, if you don't specify the REUSE STORAGE clause. Lisa Koivu Oracle Database Tank Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 5:11 PM To: Multiple recipients of list ORACLE-L Subject:Does index need rebuilding when table is truncated Hi All, I know if you delete lots of data using delete the indexes may need rebuilding. Is this the case if the table is truncated? Thanks Rick -- 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: Koivu, Lisa 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: Sherman, Paul R. 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: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To
Re: Utl_file
Connor, Do you really think, that Roland will be satisfied with your reply ?:-) Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 11, 2002 9:23 AM utl_file.put_line(file_id, col1||','|| col2||','|| col3); etc for a CSV file hth connor --- [EMAIL PROTECTED] wrote: Hallo, Is it possible to do a select from some tables in the database and then use utl_file package to create an excel file. And also to make the headers in the columns bold and right positioned. Please give me an easy example on how to write the code. Thanks in advance Roland -- 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 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: Igor Neyman 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).
comming down the pipe
List, I just returned from a 9i seminar and in one of the presentations a NEW version of Oracle was briefly discussed, 10i. It is planned to be able to handle the buffer cache, memory allocation, datafiles, tablespaces , etc, etc automatically and efficiently. There were many other items mentioned and I could not write them down and pay attention. The expected time frame is the next 2 years. The 9i release 2 is expected to hit the Oracle Store June 2002. Ron ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers 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?
I have heard two different ones, no idea if either is correct :-) trace kernel profiler transient kernel profiler John [EMAIL PROTECTED] wrote: What does it stand for? Tool Kit Profiler??? tia, David Nemeth __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA 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: disk subsystem performance question
Marie, there is a thread going on this Oracle list about disk subsystem speed, I am going to forward a couple of the responses to you. I think that it is reiterating that we need to have raid 0+1 in our PROD environment. [EMAIL PROTECTED] 04/10/02 01:06PM James Howerton wrote: John, We have the Hitachi 5800 series with RAID 5. The sales guys also said their system is s fast we need not worry about such minor details. Don't believe them!!! Write speed is SLOW. After we added bare drives for redo log files, archive logs, conrtol files it made a dramatic difference in DB performance. Hitachi some Sa's don't want to set up RAID 1+0 because it makes more work for them than a RAID 5 install. Within the last month our development box was switched from RAID-1 to RAID-5 because additional disk capacity was required. The big data load job almost doubled in time from 150 minutes to 270 minutes due to the double writes incurred by RAID-5 overhead. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler 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: CHRIS FARMER 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).
No DBAs needed on AS400
We are going through a merger, and management is looking to eliminate positions. Here is a brief summary of my discussion with the new director of IT: Director: Back when I we were using an AS400, we didn't need a DBA. Me: Then you probably were just using files. Director: No, it was a database. Me: Could you issue SQL commands? Director: Yes. But we didn't need a DBA. I guess it was just one of those mysteries of life. My thoughts are that he is using the term database in the generic sense of the word (our files are our database), or he was using some proprietary database that doesn't even begin to compare to Oracle. For those of you who know AS400s, I would appreciate some insight that would demonstrate why he needs to keep me as a DBA. Thanks, Jay -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter 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?
I thought it was Trace Kernel Profiler. PB --- Deshpande, Kirti [EMAIL PROTECTED] wrote: Transient Kernel Profile. - Kirti -Original Message- Sent: Wednesday, April 10, 2002 8:38 PM To: Multiple recipients of list ORACLE-L What does it stand for? Tool Kit Profiler??? tia, David Nemeth __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Nemeth 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). __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel 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: comming down the pipe
I'll believe it when I see it. Oracle, like MicroSlop, is into vaporware too. Reply Separator Author: Jamadagni; Rajendra [EMAIL PROTECTED] Date: 4/11/2002 6:03 AM We have a bug in 9012 that we were asking for backport, but were told it is merged into 10i release, and will be available on 9013. We had tough time to get 9013 even compiled on aix, so we are still at 9012. IIRC in 10i the system tablespace3 becomes LMT I guess. Oh and before I forget, you won't need a DBA for 10i either. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Thursday, April 11, 2002 9:43 AM To: Multiple recipients of list ORACLE-L List, I just returned from a 9i seminar and in one of the presentations a NEW version of Oracle was briefly discussed, 10i. It is planned to be able to handle the buffer cache, memory allocation, datafiles, tablespaces , etc, etc automatically and efficiently. There were many other items mentioned and I could not write them down and pay attention. The expected time frame is the next 2 years. The 9i release 2 is expected to hit the Oracle Store June 2002. Ron ROR mª¿ªm ***1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. ***1
RE: No DBAs needed on AS400
Jay, I would provide a list of functions you perform daily and what would happen if they are not completed in a timely manner. I would also update my resume. Sounds like a pretty naive director of IT. Either he/she is making a play to move you out and get a prior buddy in place, or is a complete idiot, thinking of short-term money savings but is completely unaware of long-term result. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, April 11, 2002 9:54 AM To: Multiple recipients of list ORACLE-L We are going through a merger, and management is looking to eliminate positions. Here is a brief summary of my discussion with the new director of IT: Director: Back when I we were using an AS400, we didn't need a DBA. Me: Then you probably were just using files. Director: No, it was a database. Me: Could you issue SQL commands? Director: Yes. But we didn't need a DBA. I guess it was just one of those mysteries of life. My thoughts are that he is using the term database in the generic sense of the word (our files are our database), or he was using some proprietary database that doesn't even begin to compare to Oracle. For those of you who know AS400s, I would appreciate some insight that would demonstrate why he needs to keep me as a DBA. Thanks, Jay -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter 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: Mercadante, Thomas F 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: comming down the pipe
Wasn't that expression originally coming down the pike, as in turnpike? :-) __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel 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).
OT: Oracle to DB2 books?
I checked bookpool and amazon and can't seem to find any decent books for experienced DBA's who need to learn UDB/DB2. Has anyone found a decent book for Oracle DBA's needing to learn UDB? Since my company has chosen UDB for 'strategic' reasons on an upcoming project I need to learn this product. I'm about to download IBM's CBT but would like to have a book to read also. Thanks - Brian __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski 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: No DBAs needed on AS400
From discussions that I have had here, DB2 on the AS-400 IS implemented as indexed flat files against which you write sql. It IS a database (says rdbms right on the box). Insight... I'm not sure why he is tied to the AS-400... -Original Message- Sent: Thursday, April 11, 2002 8:54 AM To: Multiple recipients of list ORACLE-L We are going through a merger, and management is looking to eliminate positions. Here is a brief summary of my discussion with the new director of IT: Director: Back when I we were using an AS400, we didn't need a DBA. Me: Then you probably were just using files. Director: No, it was a database. Me: Could you issue SQL commands? Director: Yes. But we didn't need a DBA. I guess it was just one of those mysteries of life. My thoughts are that he is using the term database in the generic sense of the word (our files are our database), or he was using some proprietary database that doesn't even begin to compare to Oracle. For those of you who know AS400s, I would appreciate some insight that would demonstrate why he needs to keep me as a DBA. Thanks, Jay -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). begin 666 InterScan_Disclaimer.txt M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@ M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!) M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@ M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE %;G0N#0H end -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: April Wells 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: No DBAs needed on AS400
On the AS400 IBM created DB2/400 that allowed DB2 to be ported to that platform. If they are not running DB2 on that platform, then they are using CICS-400 with VSAM files. Now. If you are performing queries from Oracle to DB2 (SQL Queries), that is being performed through Oracle's gateway product. If not, then they have installed DB2. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Thursday, April 11, 2002 10:09 AM To: Multiple recipients of list ORACLE-L Subject:RE: No DBAs needed on AS400 Does it have DB2 as the database? -Original Message- Sent: Thursday, April 11, 2002 8:54 AM To: Multiple recipients of list ORACLE-L We are going through a merger, and management is looking to eliminate positions. Here is a brief summary of my discussion with the new director of IT: Director: Back when I we were using an AS400, we didn't need a DBA. Me: Then you probably were just using files. Director: No, it was a database. Me: Could you issue SQL commands? Director: Yes. But we didn't need a DBA. I guess it was just one of those mysteries of life. My thoughts are that he is using the term database in the generic sense of the word (our files are our database), or he was using some proprietary database that doesn't even begin to compare to Oracle. For those of you who know AS400s, I would appreciate some insight that would demonstrate why he needs to keep me as a DBA. Thanks, Jay -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter 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: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karniotis, Stephen 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: No DBAs needed on AS400
I believe they have a form of DB2 called DB/400 (or something like that). I don't think Oracle runs on this platform. The Progress RDMS ran on it at one time, but it was a mess, so not anymore. My $0.02 worth, Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 11, 2002 9:08 AM Does it have DB2 as the database? -Original Message- Sent: Thursday, April 11, 2002 8:54 AM To: Multiple recipients of list ORACLE-L We are going through a merger, and management is looking to eliminate positions. Here is a brief summary of my discussion with the new director of IT: Director: Back when I we were using an AS400, we didn't need a DBA. Me: Then you probably were just using files. Director: No, it was a database. Me: Could you issue SQL commands? Director: Yes. But we didn't need a DBA. I guess it was just one of those mysteries of life. My thoughts are that he is using the term database in the generic sense of the word (our files are our database), or he was using some proprietary database that doesn't even begin to compare to Oracle. For those of you who know AS400s, I would appreciate some insight that would demonstrate why he needs to keep me as a DBA. Thanks, Jay -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter 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: Farnsworth, Dave 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: KENNETH JANUSZ INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
bytes per extent
Is there a query to get the number of bytes used and free in an each extent? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: No DBAs needed on AS400
It's been a while since I actually worked on a AS400 but from my understanding, DB2 is integrated into OS400, the operating system for the AS400. In the System/36 and System/38 worlds, you used RPG and a bunch of other utilities to create your programs and files. The files were flat files and I think when AS400 came out, this concept was still in place except now the files were stored in a database - DB2. I have seen one application on an AS400. There was no RI, no procs or triggers. The application had its roots in a System/36 system and had been re-written for the AS400. All the logic was in the app and DB2 just stored the data. Yes, you can run a utility (strsql I think) that brings up a screen and you can query the tables stored in the database using plain SQL. You can also bypass the app and directly insert/update/delete data aswell. hth mkb --- Jay Hostetter [EMAIL PROTECTED] wrote: We are going through a merger, and management is looking to eliminate positions. Here is a brief summary of my discussion with the new director of IT: Director: Back when I we were using an AS400, we didn't need a DBA. Me: Then you probably were just using files. Director: No, it was a database. Me: Could you issue SQL commands? Director: Yes. But we didn't need a DBA. I guess it was just one of those mysteries of life. My thoughts are that he is using the term database in the generic sense of the word (our files are our database), or he was using some proprietary database that doesn't even begin to compare to Oracle. For those of you who know AS400s, I would appreciate some insight that would demonstrate why he needs to keep me as a DBA. Thanks, Jay -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mkb 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: insert performance
Paul - How many insert processes did you run on each system? Is the disk layout identical in terms of spreading across devices? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, April 10, 2002 6:43 PM To: Multiple recipients of list ORACLE-L Greetings! I am trying to diagnose a performance difference between two databases running the same test. They are similarly configured (same SGA size, etc.), and the servers are identical except for the number of CPUs (server A has 4, server B has 6). On database A, INSERT performance is about 190 rows/second. On database B, INSERT performance is over 500 rows/second. I saw some cache buffers chains, buffer busy, and library cache latch waits on database A while the test was running, as well as redo log sync waits. The waits didn't seem excessive, though. I checked for checkpoint not complete redo allocation messages in database A's alert log and found none. The db_block_lru_latches parameter is set to one-half the number of CPUs in both machines. I'd much appreciate any suggestions as to what else to check. I know that freelists can be an issue (there are multiple sessions performing inserts); how can I check to see if there's freelist contention? Anything else I should investigate? Many TIA, = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: No DBAs needed on AS400
So you can cover his ass when a problem happens. On Thu, 11 Apr 2002, Jay Hostetter wrote: We are going through a merger, and management is looking to eliminate positions. Here is a brief summary of my discussion with the new director of IT: Director: Back when I we were using an AS400, we didn't need a DBA. Me: Then you probably were just using files. Director: No, it was a database. Me: Could you issue SQL commands? Director: Yes. But we didn't need a DBA. I guess it was just one of those mysteries of life. My thoughts are that he is using the term database in the generic sense of the word (our files are our database), or he was using some proprietary database that doesn't even begin to compare to Oracle. For those of you who know AS400s, I would appreciate some insight that would demonstrate why he needs to keep me as a DBA. Thanks, Jay -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter 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: Alex 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 to DB2 books?
Brian - you might check IBM's Web site. They have typically been generous with their information. Another resource would be to start getting familiar with DB2 newslists. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, April 11, 2002 9:29 AM To: Multiple recipients of list ORACLE-L I checked bookpool and amazon and can't seem to find any decent books for experienced DBA's who need to learn UDB/DB2. Has anyone found a decent book for Oracle DBA's needing to learn UDB? Since my company has chosen UDB for 'strategic' reasons on an upcoming project I need to learn this product. I'm about to download IBM's CBT but would like to have a book to read also. Thanks - Brian __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: redo_size values in v$sysstat
Glenn, The buffer cache hit ratio is meaning less, not only after startup but any time you calculate it. I am pretty sure that I am not the first one and probably not the last one saying that on this mailing list. Now about the claim of why you need to wait until 10i to get this fixed, has probably something to do with the fact of how the SGA is allocated on the HP platform. Any change in the layout of the fixed SGA will mean a recompile of the code on HP. Now it looks to me that the upper 4 bytes of the 8 bytes have been set to -1: 18446744069434437169 012EEE31 18446744052688746229 FFFB1B0FF6F5 So you probably could adjust for that Anjo. Glenn Travis wrote: I sent a message last week regarding our values in the v$sysstat table being WAY too large; physical_reads = 18,446,744,069,434,437,169 db_block_gets, physical_reads_direct, physical_writes_direct also. This prevents us from running the db cache hit ratio queries. I logged a tar with Oracle and they said it was a bug (#1713403). It is caused by an overflow in v$sysstat when the amount of generated redo grows over 2GB. They say this bug can't be fixed (at least not until 10i!). I am running on 8.1.7 (HP-UX11). If you are on 8i, could you query the v$sysstat table and let me know if anyone else is seeing this problem? col name for a20 col value for 999,999,999,999,999,999,999 select name,value from v$sysstat where name in ('redo size', 'physical reads', 'db block gets') / NAMEVALUE db block gets 18,446,743,996,920,309,855 physical reads 18,446,744,052,688,746,229 redo size 17,049,609,736 I find it unacceptable that Oracle would ignore this until 10i. The only time I can get a cache hit ratio is when I first start up the database (which doesn't mean anything). I know hit ratios are overrated and we look at waits more for performance tuning (read all the articles), but it is still frustrating nonetheless. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis 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: Anjo Kolk 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: comming down the pipe
It wasn't awl pike, as in the 20 - 30 ft long Swiss pikes used in the late middle ages? Never mind. What's a turnpike??? I know nothing. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Thursday, April 11, 2002 11:24 AM To: Multiple recipients of list ORACLE-L Subject:Re: comming down the pipe Wasn't that expression originally coming down the pike, as in turnpike? :-) -- 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).
Re: bytes per extent
Here is a script that I got from another lister. Hope it is what you're looking for. column tsname format a25 heading 'Tablespace Name' column tot format 99,999,999 heading 'Size (K)' column fsp Format 99,999,999 heading 'Free (K)' column csp Format 999,999 heading 'Free|Extents' column msp Format 9,999,999 heading 'Max Free|Ext (K)' column pctused Format 999.99 heading '% Used' column tsno noprint compute sum of tot fsp on report break on report select fi.tablespace_name tsname, sum(fi.bytes)/1024 tot, iv.free/1024 fsp, ((SUM(fi.bytes)-iv.free)/SUM(fi.bytes))*100 pctused, iv.no_of_exts csp, iv.max/1024 msp from dba_data_files fi, ( select t.tablespace_name, NVL(MAX(f.bytes),0) max, NVL(sum(f.bytes),0) free, count(f.bytes) no_of_exts from sys.dba_free_space f, sys.dba_tablespaces t where t.tablespace_name=f.tablespace_name(+) and t.status != 'INVALID' group by t.tablespace_name ) iv where fi.tablespace_name = iv.tablespace_name GROUP BY fi.tablespace_name, iv.free, iv.no_of_exts, iv.max ORDER BY fi.tablespace_name / clear breaks clear columns clear computes Regards, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 11, 2002 10:39 AM Is there a query to get the number of bytes used and free in an each extent? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini 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: No DBAs needed on AS400
Jay - I can see the manager's confusion. After all, one expects computers to become easier and require less effort to maintain as time goes by. I forwarded your question to another list that has some AS/400 programmers. -- On the AS400 you can run queries and use SQL even though the machine is configured to use files. Under the covers it is still AS400/DB2. -- The AS/400 has a full-featured database built into the operating system. Originally it didn't even have a name but IBM started calling it DB2/400 when they found out that some people didn't know it was there. And you don't need a DBA. Virtually all the functions that are performed by a DBA on an Oracle database, for example, are handled automatically by the AS/400 under the covers. -- Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, April 11, 2002 8:54 AM To: Multiple recipients of list ORACLE-L We are going through a merger, and management is looking to eliminate positions. Here is a brief summary of my discussion with the new director of IT: Director: Back when I we were using an AS400, we didn't need a DBA. Me: Then you probably were just using files. Director: No, it was a database. Me: Could you issue SQL commands? Director: Yes. But we didn't need a DBA. I guess it was just one of those mysteries of life. My thoughts are that he is using the term database in the generic sense of the word (our files are our database), or he was using some proprietary database that doesn't even begin to compare to Oracle. For those of you who know AS400s, I would appreciate some insight that would demonstrate why he needs to keep me as a DBA. Thanks, Jay -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:No DBAs needed on AS400
Jay, We still have one of those dinosaurs running here called HP's TurboImage database. It also does not need a DBA, actually it does not understand what a DBA is. The database is hierachtical with the constraints set during creation. I constantly have fun with the older ManMan developers as we move them into PeopleSoft. They have no idea of what's going on under the covers. SQL is a foreign language to them, their all use to TurboImage intrinsics and a SQL*Plus look alike tool called Quiz. It's kind of fun, you have to use a dataset (they call them databases), report out columns, and then set conditions. Kind of like writing SQL with the from clause first. This type of structure has to be carried into the application programs as well, namely you've got to call the dbopen intrinsic before you can use a dataset. BTW, that's in C syntax 'dbopen(MANDB.MDATABAS.MMV090)' (the HP3000 MPEi/x directory structure is kind of strange). There is no such thing as rollback or read consistent view and recovery consists of going back to the last backup, all of which are cold, and having everyone re-enter their transactions. OH, yes, there is no such thing as a user. If you have the ability to loggon to the HP3000, you can use the database and everything is wide open. No ideas of security. Problem with TurboImage is that to modify a database you have to rebuild it using an HP utility and then you have to rebuild all of your application programs, or else they crash. Developers do that task as needed and when they mess up, well all hell can and does break loose. Also you need to run these third party utilities each night so that there is room for the dataset to grow and you have to fix broken chains all the time. There is no concept of an instance either. Your application program directly accesses the data files/datasets, so 'impeded' sessions are a common occurance and if an application messes up it can require a system reboot to clear the problems. Sure you don't need a DBA, but you sure as heck need an operator. Problem is that most operators don't get paid as well as a DBA. If your new CIO is in that mindset I'd recommend polishing your resume, cause your gonna need it. Dick Goulet Reply Separator Author: Jay Hostetter [EMAIL PROTECTED] Date: 4/11/2002 5:54 AM We are going through a merger, and management is looking to eliminate positions. Here is a brief summary of my discussion with the new director of IT: Director: Back when I we were using an AS400, we didn't need a DBA. Me: Then you probably were just using files. Director: No, it was a database. Me: Could you issue SQL commands? Director: Yes. But we didn't need a DBA. I guess it was just one of those mysteries of life. My thoughts are that he is using the term database in the generic sense of the word (our files are our database), or he was using some proprietary database that doesn't even begin to compare to Oracle. For those of you who know AS400s, I would appreciate some insight that would demonstrate why he needs to keep me as a DBA. Thanks, Jay -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter 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: No DBAs needed on AS400
Just tell him that with AS400 one doesn't need a CIO either and that will be the end of that. AS400 is a closed system, perfect for running canned apps, maintained by somebody and is, in essence, equivalent of outsourcing. For that, you don't need to have an IT, just a person to manage the contract. If the business need to adjust the applications frequently and to create it's own solution, AS400 would be just a little bit awkward, not to mention the fact that programmers knowing AS400 are very hard to come across and usually demand a premium salary. -Original Message- From: Jay Hostetter [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 11, 2002 9:54 AM To: Multiple recipients of list ORACLE-L Subject: No DBAs needed on AS400 We are going through a merger, and management is looking to eliminate positions. Here is a brief summary of my discussion with the new director of IT: Director: Back when I we were using an AS400, we didn't need a DBA. Me: Then you probably were just using files. Director: No, it was a database. Me: Could you issue SQL commands? Director: Yes. But we didn't need a DBA. I guess it was just one of those mysteries of life. My thoughts are that he is using the term database in the generic sense of the word (our files are our database), or he was using some proprietary database that doesn't even begin to compare to Oracle. For those of you who know AS400s, I would appreciate some insight that would demonstrate why he needs to keep me as a DBA. Thanks, Jay -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter 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: 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: Favourite Urban Myth
He would have used 'renice' if we had let him have root. Jared On Wednesday 10 April 2002 09:33, Alan Davey wrote: You mean he didn't use the 'nice' command? ;^) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:bytes per extent
None that I aware of, but check out DBMS_SPACE. Dick Goulet Reply Separator Author: Ray Stell [EMAIL PROTECTED] Date: 4/11/2002 6:39 AM Is there a query to get the number of bytes used and free in an each extent? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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).
Currently log-in users
How do I check who is currently logging into database, where he is accessing from and what he is doing? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M 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: No DBAs needed on AS400
Jay, The AS400 machines are the heirs to the System 38 machines which were themselves derived from a 'Future System' which was so revolutionary that it was killed off by the IBM marketing on the eve of announcement for fear that it would frighten their System 360/370 customers (the cost of migrating to competition wouldn't have been higher than migrating to the 'future system' and they didn't take the risk). The operating system indeed has a built-in RDBMS, which may not have all the features of Oracle or UDB, but don't expect to make a bean-counter understand technical subtleties. After all, many people don't make the difference between Access and Oracle. Anyway, you have several ways to defend your position: a) Migration. Assuming they want to switch to something else, they will need somebody who knows the current system well. This in turn will help you learn the new system and find arguments to help preserve your job. b) Oracle doesn't need any DBA either. If you have no new application, no developer, if you don't upgrade anything, if volumes stay the same who needs a DBA? However, as soon as one of the premises is false ... - Original Message - From: Jay Hostetter [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thu, 11 Apr 2002 05:54:07 We are going through a merger, and management is looking to eliminate posit= ions. Here is a brief summary of my discussion with the new director of IT= :=0D =0D Director: Back when I we were using an AS400, we didn't need a DBA.=0D Me: Then you probably were just using files.=0D Director: No, it was a database.=0D Me: Could you issue SQL commands?=0D Director: Yes. But we didn't need a DBA. I guess it was just one of thos= e mysteries of life.=0D =0D =0D My thoughts are that he is using the term database in the generic sense o= f the word (our files are our database), or he was using some proprietary= database that doesn't even begin to compare to Oracle.=0D =0D For those of you who know AS400s, I would appreciate some insight that woul= d demonstrate why he needs to keep me as a DBA.=0D =0D Thanks,=0D Jay=0D =0D =0D --=0D Please see the official ORACLE-L FAQ: http://www.orafaq.com=0D --=0D Author: Jay Hostetter=0D INET: [EMAIL PROTECTED]=0D =0D Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051=0D San Diego, California-- Public Internet access / Mailing Lists=0D To REMOVE yourself from this mailing list, send an E-Mail message=0D to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in=0D the message BODY, include a line containing: UNSUB ORACLE-L=0D (or the name of mailing list you want to be removed from). You may=0D also send the HELP command for other information (like subscribing).=0D --- -=0D Stephane Faroult Oriole Corporation Performance Tools Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul 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: Favourite Urban Myth
Thanks, I was somehow not recognizing the part where you said the shell script was named 'rm'. Yeah, that would take a system down. Here's one for you. It's happened to me twice, many years ago. What happens when you want to remove all of the *.txt files in a dir and are a little slow letting go of the shift key on the *? You get: rm *txt which leaves you with a directory with one empty file in it. I learned to alter my typing habits after the second time. Jared On Wednesday 10 April 2002 15:19, Don Granaman wrote: Recursion - it called itself endlessly. $HOME/bin (where it lived) was the leading element of $PATH. After a minute or less, it was thousands of processes deep. After changing it to /bin/rm -i $* it worked as intended. Don Granaman [certifiable OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 10, 2002 4:23 PM ?? rm -i $* I'm having a hard time understanding why this would spawn more than one process. Jared Don Granaman [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 04/10/02 11:25 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Favourite Urban Myth Do Unix admin fiascoes count? I once had an SA do # chmod -R 700 /dev because he thought someone was inappropriately dinging something there. Can you imagine how many things break when /dev/null is unwritable and unreadable? And when /dev/vx/rdsk/... (with a database on raw devices) are not readable or writable by Oracle? The same fellow also once changed oracle's UID and the dba GID and did a chown oracle:dba on all of oracle's directories and files - without telling anyone or shutting down the instances running on the server. Oracle hung - suddenly it did not own any processes or semaphores! (ipcrm is not the preferred method of shutting down oracle!) My own most embarrassing fiasco occurred many, many years ago - when I was fairly new to Unix. I created a shell script named rm which did rm -i $* You can imagine what happened the first time I ran it - processes were spawning faster than I could kill them, even with a script... It was admin by BOB time. (BOB=Big Orange Button.) Fortunately, it was on a development server! Don Granaman [certifiable OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 10, 2002 10:53 AM On Tuesday 09 April 2002 20:03, Deshpande, Kirti wrote: Well Kirti, if you're going to morph this thread into stupid DBA tricks... We had one young fellow working for us that was new to unix. He had just discovered that he could run a job in the background via '' at about the same time he was assigned the task of recompiling all of the files for an entire application. You can probably guess the rest. ;) About the time he started bragging about how quickly he was able to recompile all of the code, we were all headed to the server room to find out why our dev server was suddenly so slow... Jared We had one dba who (by mistake) issued a 'chown -R oracle:dba' followed by 'chmod -R 750 *' from the '/' directory while logged in as root. Fortunately, it was a server with no production databases on it, just a couple of Development databases. She never new what a '#' prompt was. She is long gone but such memories linger for ever ;) It took a while for the SA's to let Oracle DBAs get root privileges after that episode. And in my previous job, I had a junior DBA who tried to kill a background job (%1) with 'kill -9' as root. The problem was, he forgot to put in '%' before the '1' and then came to me stating that the Server does not respond anymore :( while I was talking to the Customer who had beaten him to place a trouble call about 'the database just hung-up'. Is there a Darwin Award for the Living (DBA)? =;) - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --
RE: cache buffer chains contention
Title: RE: cache buffer chains contention Would it seem likely for Oracle to be doing ANYTHING for a full 30 seconds without hitting another wait? Matt Adams - GE Appliances - [EMAIL PROTECTED] Reason is 6/7ths of treason. - The Xtals -Original Message- From: Jonathan Lewis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 6:54 PM To: Multiple recipients of list ORACLE-L Subject: Re: cache buffer chains contention seconds_in_wait increments every three seconds, so if State is anything other than WAITING the column tells you how much time has passed since the last wait completed. (Contrary to the urban legend that says the value is meaningless). There are various anomalies and oddities about wait events, though, and if you session REALLY is doing nothing for 30 seconds, then you've hit one; however normally I would say that your session is busy doing something (from Oracle's perspective) in that 30 seconds. Jonathan Lewis http://www.jlcomp.demon.co.uk Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 10 April 2002 20:56 |Ok, some guru please explain this to me. | |process is waiting for 'latch free' according to |v$session_wait and the value of P2 = 26 |which is the cache buffer chains latch. |(while holding the HW enqueue, with a bunch of |processes waiting on HW) | |State = 'WAITED KNOWN TIME', so I look at |WAIT_TIME, which is 2. | |However, the process does not appear to be doing |ANYTHING and the seconds in the SECONDS_IN_WAIT |column is increasing! This continues for about |30 seconds, when finally it finishes whatever |it was doing and allows the next process to |grab the HW enqueue | |Why would SECONDS_IN_WAIT be increasing when it supposed to be |done waiting already? | | | | |Matt Adams - GE Appliances - [EMAIL PROTECTED] |Reason is 6/7ths of treason. - The Xtals | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis 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: No DBAs needed on AS400
I never worked on AS400, but this aligns with what I recall. I believe that the System/38 was the first IBM system that had an embedded database. (System 36 did not -- it used older technology.) And that was used as the basis for the AS400. If I recall correctly, the OS used the database to store pretty much everything including all the system parameters and data. I believe this pre-dates DB2 and was very likely not a true relational database -- though I could be wrong on that. I suspect that SQL query capabilities were added on afterwards, similar to what was done with Ingres and Informix. (Informix was just indexed files and you could bypass SQL and do indexed file reads for performance reasons. Ingres had its own query language before SQL (QUEL?).) You didn't need a DBA, because the OS controlled everything and I don't think there was any ability to tune the system. The AS400 was designed to be pretty much a hands-off system. Just plug it in and let it run. Marc Perkowitz Senior Consultant TWJ Consulting, LLP - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 11, 2002 9:33 AM It's been a while since I actually worked on a AS400 but from my understanding, DB2 is integrated into OS400, the operating system for the AS400. In the System/36 and System/38 worlds, you used RPG and a bunch of other utilities to create your programs and files. The files were flat files and I think when AS400 came out, this concept was still in place except now the files were stored in a database - DB2. I have seen one application on an AS400. There was no RI, no procs or triggers. The application had its roots in a System/36 system and had been re-written for the AS400. All the logic was in the app and DB2 just stored the data. Yes, you can run a utility (strsql I think) that brings up a screen and you can query the tables stored in the database using plain SQL. You can also bypass the app and directly insert/update/delete data aswell. hth mkb --- Jay Hostetter [EMAIL PROTECTED] wrote: We are going through a merger, and management is looking to eliminate positions. Here is a brief summary of my discussion with the new director of IT: Director: Back when I we were using an AS400, we didn't need a DBA. Me: Then you probably were just using files. Director: No, it was a database. Me: Could you issue SQL commands? Director: Yes. But we didn't need a DBA. I guess it was just one of those mysteries of life. My thoughts are that he is using the term database in the generic sense of the word (our files are our database), or he was using some proprietary database that doesn't even begin to compare to Oracle. For those of you who know AS400s, I would appreciate some insight that would demonstrate why he needs to keep me as a DBA. Thanks, Jay -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mkb 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: Marc Perkowitz 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).
svrmgrl vs. sqlplus
Hi all, I have problem with my oracle client on linux. Using 'svrmgrl' I can connect to a database but if I use 'sqlplus', I get an ORA-01034 error. Can anybody say me why? And how to repair it? Server: Alpha with Tru64 Unix 4.0F: Oracle7 Server Release 7.3.4.0.0 with the 64-bit option - Production PL/SQL Release 2.3.4.0.0 - Production Client: Red Hat Linux release 6.1, Kernel 2.2.19-6.2.7enterprise on a 4-processor i686 Oracle8 Release 8.0.5.0.0 - Production PL/SQL Release 8.0.5.0.0 - Production If I try 'svrmgrl', it's OK: $ svrmgrl Oracle Server Manager Release 3.0.5.0.0 - Production (c) Copyright 1997, Oracle Corporation. All Rights Reserved. Oracle8 Release 8.0.5.0.0 - Production PL/SQL Release 8.0.5.0.0 - Production SVRMGR connect test/test@test Connected. SVRMGR But trying 'sqlplus' I get an error: $ sqlplus test/test@test SQL*Plus: Release 8.0.5.0.0 - Production on Thu Apr 11 16:35:46 2002 (c) Copyright 1998 Oracle Corporation. All rights reserved. ERROR: ORA-01034: ORACLE not available Help me, please. Mike P.S.: This error (1034) in sqlplus comes only with connecting to Oracle7. I have no problem with connecting to Oracle8 or higher. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michal Zaschke 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: bytes per extent
Here are a few scripts: PROMPT PROMPTShow free and used blocks allocated to table or index and indicate HWM PROMPT PROMPT This script will request 2 parameters if not specified on the command line: PROMPT1 = owner of tables to check (wild cards allowable) PROMPT2 = name of table to check (wild cards allowable) SET SERVEROUT ON SIZE 20 SET VERIFY OFF ECHO OFF DECLARE -- CURSOR CU_tabl IS SELECT * FROMall_objects WHERE owner LIKE UPPER('1') and object_name LIKE UPPER('2') and object_type IN ('TABLE','INDEX') ORDER BY owner,object_type,object_name; -- R_tabl CU_tabl%ROWTYPE; -- SEGMENT_OWNER VARCHAR2(30); SEGMENT_NAME VARCHAR2(30); SEGMENT_TYPE VARCHAR2(20); TOTAL_BLOCKS NUMBER ; TOTAL_BYTESNUMBER ; UNUSED_BLOCKS NUMBER ; UNUSED_BYTES NUMBER ; LAST_USED_EXTENT_FILE_ID NUMBER ; LAST_USED_EXTENT_BLOCK_ID NUMBER ; LAST_USED_BLOCKNUMBER ; -- FREELIST_GROUP_ID NUMBER ; FREE_BLKS NUMBER ; SCAN_LIMIT NUMBER ; -- L_temp NUMBER; L_min_blocks NUMBER(40) DEFAULT 10; L_act_perf BOOLEAN DEFAULT FALSE; -- BEGIN FOR R_tabl IN CU_tabl LOOP -- DBMS_SPACE.UNUSED_SPACE(R_tabl.owner,R_tabl.object_name,R_tabl.object_type, TOTAL_BLOCKS, TOTAL_BYTES, UNUSED_BLOCKS, UNUSED_BYTES, LAST_USED_EXTENT_FILE_ID, LAST_USED_EXTENT_BLOCK_ID, LAST_USED_BLOCK); -- freelist_group_id := 0; scan_limit :=99; sys.DBMS_SPACE.FREE_BLOCKS(R_tabl.owner,R_tabl.object_name,R_tabl.object_typ e, FREELIST_GROUP_ID, FREE_BLKS, SCAN_LIMIT); -- dbms_output.put_line('.'); dbms_output.put_line('Table '||R_tabl.owner||'.'||R_tabl.object_name||'('||R_tabl.object_type||')'); dbms_output.put_line('Total blocks ='||TO_CHAR(TOTAL_BLOCKS,'999,999')); dbms_output.put_line('Total bytes(k) ='||TO_CHAR(TOTAL_BYTES/1024,'999,999')); dbms_output.put_line('Unused bytes(k) ='||TO_CHAR(UNUSED_BYTES/1024,'999,999')); dbms_output.put_line('Blocks above HWM ='||TO_CHAR(UNUSED_BLOCKS,'999,999')); dbms_output.put_line('Blocks below HWM ='||TO_CHAR(TOTAL_BLOCKS-UNUSED_BLOCKS-1,'999,999')); dbms_output.put_line('Free blocks ='||TO_CHAR(FREE_BLKS,'999,999')); IF (TOTAL_BLOCKS-1) 0 THEN dbms_output.put_line('%free wrt used blocks ='||TO_CHAR(free_blks/(TOTAL_BLOCKS-1) * 100,'999,999')||'%'); ELSE dbms_output.put_line('%free wrt used blocks=n/a'); END IF; L_act_perf := TRUE; -- END LOOP; -- IF NOT L_act_perf THEN dbms_output.put_line('.'); dbms_output.put_line('No tables found'); END IF; END; / --SET VERIFY ON @@GetBlockSize column blocks_used format 9,999,999 heading Blocks used column bk format 9,999,999 heading Space used(k) column rc format 9,999,999 heading Row Count PROMPT Count up how many actual blocks are used for a table and translate this into kilobytes PROMPT select COUNT(DISTINCT(SUBSTR(ROWID,1,8)||SUBSTR(ROWID,15,4))) Blocks_Used , COUNT(DISTINCT(SUBSTR(ROWID,1,8)||SUBSTR(ROWID,15,4)))*_db_block_size/1024 bk, COUNT(*) rc from 1; CLEAR COLUMNS And GetBlockSize is: REM Get block size from V$PARAMETER and store for use in other utilities undef _db_block_size column xpvx new_value _db_block_size heading Block size|(bytes) Format A10 select p.Value xpvx fromV$PARAMETER p WHERE name = 'db_block_size' / clear columns All courtesy of Tim Onions I believe (but can't remember for sure).. HTH Mark -Original Message- Sent: 11 April 2002 15:39 To: Multiple recipients of list ORACLE-L Is there a query to get the number of bytes used and free in an each extent? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB
Re: No DBAs needed on AS400
Can't help you there. The AS/400 evolved from the S/34, S/36, and S/38 line of IBM machines. My 77-yr-old stepfather (at the time, 62-yrs-old) bought a S/38 for his trucking company in NJ, complete with payroll, GL, AR, AP, etc software. He didn't have an IT department, needless to say. They just wheeled the machine in, the IBM guy set it up, then he (my stepfather) watched the IBM guy run everything for 2-3 days, then he picked up the manual (he wasn't even a mechanic, just a driver who built a company) and ran the system for years until he sold the company and retired. Did backups and everything. Had his drivers deliver the tapes in a firebox to his two other truck terminals. He is always a little amused that I can make a full-time living on computers... It's not hyperbole -- it's fact. IBM built some sweet machines for years, and the AS/400 is not only easy to operate but also the fastest commercial machine on the planet to this day. I've always suspected that was one reason why Oracle never bothered to port to AS/400, because DB2/400 was waiting there to slap them silly... Fatal flaw: they don't talk to non-AS/400s or non-mainframes easily. Hence open systems. It's an old story. Remeber: technical merit doesn't always win the day. After all, just compare the relative fortunes of DEC (or IBM) against Microsoft. If your new director is determined to go the AS/400 route (which includes isolating your company from just about everything except what runs on AS/400 and IBM mainframes), then you'd better brush up on your resume... Sorry... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 11, 2002 7:54 AM We are going through a merger, and management is looking to eliminate positions. Here is a brief summary of my discussion with the new director of IT: Director: Back when I we were using an AS400, we didn't need a DBA. Me: Then you probably were just using files. Director: No, it was a database. Me: Could you issue SQL commands? Director: Yes. But we didn't need a DBA. I guess it was just one of those mysteries of life. My thoughts are that he is using the term database in the generic sense of the word (our files are our database), or he was using some proprietary database that doesn't even begin to compare to Oracle. For those of you who know AS400s, I would appreciate some insight that would demonstrate why he needs to keep me as a DBA. Thanks, Jay -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter 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: Tim Gorman 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: Currently log-in users
Start with v$session. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 11, 2002 11:53 AM How do I check who is currently logging into database, where he is accessing from and what he is doing? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M 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: Igor Neyman 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: Currently log-in users
v$session would be a good startin place. Dave -Original Message- Sent: Thursday, April 11, 2002 10:53 AM To: Multiple recipients of list ORACLE-L How do I check who is currently logging into database, where he is accessing from and what he is doing? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M 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: Farnsworth, Dave 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: svrmgrl vs. sqlplus
Michal, The only problem similar to that I have seen on 6.1 Red Hat was the result of a problem in the sqlnet.ora. Are you sure the names, TRACE_LEVEL, etc that should be the same for all the target instances (78) are the same? Good Luck! John -Original Message- Sent: Thursday, April 11, 2002 11:38 AM To: Multiple recipients of list ORACLE-L Hi all, I have problem with my oracle client on linux. Using 'svrmgrl' I can connect to a database but if I use 'sqlplus', I get an ORA-01034 error. Can anybody say me why? And how to repair it? Server: Alpha with Tru64 Unix 4.0F: Oracle7 Server Release 7.3.4.0.0 with the 64-bit option - Production PL/SQL Release 2.3.4.0.0 - Production Client: Red Hat Linux release 6.1, Kernel 2.2.19-6.2.7enterprise on a 4-processor i686 Oracle8 Release 8.0.5.0.0 - Production PL/SQL Release 8.0.5.0.0 - Production If I try 'svrmgrl', it's OK: $ svrmgrl Oracle Server Manager Release 3.0.5.0.0 - Production (c) Copyright 1997, Oracle Corporation. All Rights Reserved. Oracle8 Release 8.0.5.0.0 - Production PL/SQL Release 8.0.5.0.0 - Production SVRMGR connect test/test@test Connected. SVRMGR But trying 'sqlplus' I get an error: $ sqlplus test/test@test SQL*Plus: Release 8.0.5.0.0 - Production on Thu Apr 11 16:35:46 2002 (c) Copyright 1998 Oracle Corporation. All rights reserved. ERROR: ORA-01034: ORACLE not available Help me, please. Mike P.S.: This error (1034) in sqlplus comes only with connecting to Oracle7. I have no problem with connecting to Oracle8 or higher. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michal Zaschke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman 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: No DBAs needed on AS400
We have DB2 running on an AS400 and have a DB2 DBA. She does those unimportant things like backup/restore, source control, duhveloper control, database reorgs and all sorts of other junk. She is busy all the time. -Original Message- Sent: Thursday, April 11, 2002 10:44 AM To: Multiple recipients of list ORACLE-L I never worked on AS400, but this aligns with what I recall. I believe that the System/38 was the first IBM system that had an embedded database. (System 36 did not -- it used older technology.) And that was used as the basis for the AS400. If I recall correctly, the OS used the database to store pretty much everything including all the system parameters and data. I believe this pre-dates DB2 and was very likely not a true relational database -- though I could be wrong on that. I suspect that SQL query capabilities were added on afterwards, similar to what was done with Ingres and Informix. (Informix was just indexed files and you could bypass SQL and do indexed file reads for performance reasons. Ingres had its own query language before SQL (QUEL?).) You didn't need a DBA, because the OS controlled everything and I don't think there was any ability to tune the system. The AS400 was designed to be pretty much a hands-off system. Just plug it in and let it run. Marc Perkowitz Senior Consultant TWJ Consulting, LLP - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 11, 2002 9:33 AM It's been a while since I actually worked on a AS400 but from my understanding, DB2 is integrated into OS400, the operating system for the AS400. In the System/36 and System/38 worlds, you used RPG and a bunch of other utilities to create your programs and files. The files were flat files and I think when AS400 came out, this concept was still in place except now the files were stored in a database - DB2. I have seen one application on an AS400. There was no RI, no procs or triggers. The application had its roots in a System/36 system and had been re-written for the AS400. All the logic was in the app and DB2 just stored the data. Yes, you can run a utility (strsql I think) that brings up a screen and you can query the tables stored in the database using plain SQL. You can also bypass the app and directly insert/update/delete data aswell. hth mkb --- Jay Hostetter [EMAIL PROTECTED] wrote: We are going through a merger, and management is looking to eliminate positions. Here is a brief summary of my discussion with the new director of IT: Director: Back when I we were using an AS400, we didn't need a DBA. Me: Then you probably were just using files. Director: No, it was a database. Me: Could you issue SQL commands? Director: Yes. But we didn't need a DBA. I guess it was just one of those mysteries of life. My thoughts are that he is using the term database in the generic sense of the word (our files are our database), or he was using some proprietary database that doesn't even begin to compare to Oracle. For those of you who know AS400s, I would appreciate some insight that would demonstrate why he needs to keep me as a DBA. Thanks, Jay -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mkb 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: Marc Perkowitz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing
OEM Error On Unix
Hell All, I am seeing the following error , when I am trying to start OEM console on HP Unix. Any Idea , what I am missing and would like to know , what is this Management server and how to start it on HP Unix .. Thanks in advance ...OLE_Obj... Thanks, Madhu V Reddy Database Support Services (952) 324-0392 ( work ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reddy, Madhusudana 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).
Submit job last day of each month
Hi, Does anyone know how I can submit a job using dbms_job the last day of each month. I know there is a last_day function but cannot figure how to use this correctly in dbms_job. Thanks Rick -- 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: Currently log-in users
Hi, You may use the view V$SESSION. Regards M.Emre HANCIOGLU Masterfoods Services GmbH Nguyen, David M [EMAIL PROTECTED] xo.com Sent by: [EMAIL PROTECTED] 11.04.02 17:53 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: Currently log-in users How do I check who is currently logging into database, where he is accessing from and what he is doing? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M 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: package in sqlarea
Thanks Mohammed! Some comments: tools that query from the V$SQLAREA seeking inefficient SQL by looking at DISK_READS (i.e. physical reads or cache misses on the Buffer Cache) and BUFFER_GETS (i.e. logical reads) can only be as effective as the Shared SQL Area cache in the Shared Pool. That is, your mileage may certainly vary! If the Shared SQL Area is being abused as a cache in any way, which can happen multiple ways, then the effectiveness of queries against V$SQLAREA can be severely limited. For example, if the Shared SQL Area is being flooded with many similar SQL statements that are only being used once and once only, due to the lack of use of bind variables by the application, then the cache of SQL statements may only provide you with the last 30 seconds of information in the database. This is not very useful. I try to kludge around this in TOP_STMT2 by attempting to aggregate statistics for all SQL statements which are the same to the first 60 characters of the SQL text, but this brings up other possible distortions. With a well-behaved application that is utilizing bind-variables, allowing SQL statements to be cached for long periods of time, queries against V$SQLAREA (such as in TOP_STMT2 and many of Steve Adam's scripts on IXORA) work like magic. The TOP_STMT2 procedure attempts to gauge the impact of a SQL statement by comparing the values in DISK_READS against the total physical reads (from V$SYSSTAT) and BUFFER_GETS against total logical reads (from V$SYSSTAT). While this estimated impact is fraught with all kinds of inaccuracy, it still provides a pretty good indication of just how debilitating a specific SQL statement might be on overall system resource consumption. --- The very best utility for SQL tuning is STATSPACK. STATSPACK takes snapshots of the V$ views (including V$SQLAREA) on a periodic basis (default: 60 mins) all the time. So, it keeps a long-term history SQL utilization, across instance restarts and such. Now, you can really analyze SQL utilization and get a good measure across longer time periods. Problem is, out of the box you only get STATSPACK's single canned report, which only compares differences between two separate snapshots. If these two snapshots are intersected by an instance restart, the report does not handle it well. Also, in my opinion the standard STATSPACK report is about as useful to the average person as the old BSTAT/ESTAT report. That is, not very useful. It's just too much information, much of it irrelevant. So, just as with BSTAT/ESTAT, I consider the YAPP report from the www.oraperf.com website to be an integral part of STATSPACK (as with BSTAT/ESTAT). Reading the YAPP report provides insight into whether SQL tuning is the top issue or not, or whether wait-event bottlenecks are the top issue or not. Thanks Anjo! I've customized STATSPACK to add additional columns to it's tables to store delta or incremental change values between snapshots. These values have to be calculated separately from the STATSPACK.SNAP packaged procedure or you have to be willing to modify the STATSPACK package. Since STATSPACK is essentially open source, this isn't hard. It becomes a matter of style. I prefer to leave STATSPACK components as pristine as possible to facilitate upgrade. Anyway, once you have calculated delta values between snapshots, you can treat the STATSPACK tables almost like a portion of a data warehouse and do some cool analysis queries against it. I've adapted a version of TOP_STMT2 (called it TOP_STMT3 -- originality is not my strongpoint!) to run against these customized delta values in STATSPACK and I'm able to accurate monitor for offensive SQL across months of gathered data. Cool stuff... What a great time to be alive (and not working on AS/400!)... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 10, 2002 8:28 PM You need to check the SQL in the procedure. I have the same situation. I run Tim Gornman's temp_top_stmt2.sql script to identify the SQL within the procedure. Statspack also identifies the high resource consuming SQL. IXORA also provides scripts to identify them. Shakir --- Big Planet [EMAIL PROTECTED] wrote: Hi List , While searching for poor sqls , I am getting a stored procedure name in v$sqlarea with high value in disk_reads . What does it mean and how can I reduce the disk read . Yeah ..one more thing does the case of stored proc and name of bind varibales creats different entry in sqlarea . TIA Bp = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammed Shakir INET: [EMAIL PROTECTED] Fat City Network
Re: svrmgrl vs. sqlplus
All my sqlnet.ora is: names.default_domain = suas.cz sqlnet.expire_time = 10 John Weatherman wrote: Michal, The only problem similar to that I have seen on 6.1 Red Hat was the result of a problem in the sqlnet.ora. Are you sure the names, TRACE_LEVEL, etc that should be the same for all the target instances (78) are the same? Good Luck! John -Original Message- Sent: Thursday, April 11, 2002 11:38 AM To: Multiple recipients of list ORACLE-L Hi all, I have problem with my oracle client on linux. Using 'svrmgrl' I can connect to a database but if I use 'sqlplus', I get an ORA-01034 error. Can anybody say me why? And how to repair it? Server: Alpha with Tru64 Unix 4.0F: Oracle7 Server Release 7.3.4.0.0 with the 64-bit option - Production PL/SQL Release 2.3.4.0.0 - Production Client: Red Hat Linux release 6.1, Kernel 2.2.19-6.2.7enterprise on a 4-processor i686 Oracle8 Release 8.0.5.0.0 - Production PL/SQL Release 8.0.5.0.0 - Production If I try 'svrmgrl', it's OK: $ svrmgrl Oracle Server Manager Release 3.0.5.0.0 - Production (c) Copyright 1997, Oracle Corporation. All Rights Reserved. Oracle8 Release 8.0.5.0.0 - Production PL/SQL Release 8.0.5.0.0 - Production SVRMGR connect test/test@test Connected. SVRMGR But trying 'sqlplus' I get an error: $ sqlplus test/test@test SQL*Plus: Release 8.0.5.0.0 - Production on Thu Apr 11 16:35:46 2002 (c) Copyright 1998 Oracle Corporation. All rights reserved. ERROR: ORA-01034: ORACLE not available Help me, please. Mike P.S.: This error (1034) in sqlplus comes only with connecting to Oracle7. I have no problem with connecting to Oracle8 or higher. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michal Zaschke 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).
Exchanging partition takes a lot of times
I'm testing the exchange partition and it's taking 90 seconds to exchange a table containing 700 000 rows with a partition containing also 700 000 rows. I've noticed that SYS is doing a crazy select to check on the PK of the tables even if I used whitout validation in the exchange statement. I this normal behavior ? = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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: Currently log-in users
Some selects You can find in http://www.itsystems.lv/gints/dba_selects.htm I'm sure there are websites with more scripts around the net, of course... Gints Plivna IT Sistçmas, Meríeïa 13, LV1050 Rîga http://www.itsystems.lv/gints/ How do I check who is currently logging into database, where he is accessing from and what he is doing? Thanks, David -- 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: Currently log-in users
Here's a good starting point. If you want I also have a unix shell script driver for this that does a little more formatting. set feedback off set heading off set timing off set time off set echo off set term off set pagesize 256 set space 1 column username format a8 column machine format a8 column terminal format a8 column logon_time format a18 column SESSION ID format a11 column module heading FORM format a20 spool /tmp/logged_in.lst select username, substr(machine,1,8), substr(terminal,1,8), to_char(logon_time,'DD-MON-YY HH:MI am') logon_time, ||sid||','||serial#|| SESSION ID, nvl(substr(module,1,20), 'Character session') from v$session where type = 'USER' and username != 'SYSTEM' and username is not null and status != 'KILLED'; spool off prompt prompt spool /tmp/logged_in2.lst select 'Total Users currently logged in'||' '||count(*) from v$session where type = 'USER' and username != 'SYSTEM'; spool off spool /tmp/logged_in3.lst select 'GUI users logged in: '||' '||count(*) from v$session where machine != ('mufasa') and username != 'SYSTEM'; spool off exit Joe LaCascio Oracle DBA, Unix Administrator Wheaton College, MA 508.286.3405 On Thu, 11 Apr 2002, Nguyen, David M wrote: How do I check who is currently logging into database, where he is accessing from and what he is doing? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M 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: Joe LaCascio 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: OEM Error On Unix
Oops !!! Error message is missing , here is the error: VTK-1000: Unable to connect to the management server server.mydomain.com. Please verify that you have entered the correct host name and the status of the Oracle Management Server. Thanks Madhu -Original Message- Sent: Thursday, April 11, 2002 11:26 AM To: Multiple recipients of list ORACLE-L Hell All, I am seeing the following error , when I am trying to start OEM console on HP Unix. Any Idea , what I am missing and would like to know , what is this Management server and how to start it on HP Unix .. Thanks in advance ...OLE_Obj... Thanks, Madhu V Reddy Database Support Services (952) 324-0392 ( work ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reddy, Madhusudana 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: Reddy, Madhusudana 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: migrate from 8i to 9i
I think you have to use only the 8i version on EXP and IMP in this case, as 9i EXP cannot connect to 8i database and 9i IMP cannot read 8i EXP dmp file. --- Kader Ben [EMAIL PROTECTED] wrote: Thanks I'm thinking about this idea, Ben --- [EMAIL PROTECTED] wrote: I'm assuming that you're creating a 9i database on the new machine when you install Oracle. I find it useful to pre-create the tablespaces (and users) on the new database, rather than let the import do that. This gives you more control over where datafiles end up and do some clearup on unneeded users, etc. Kader Ben kaderb To: Multiple recipients of list ORACLE-L @yahoo.com [EMAIL PROTECTED] Sent by: rootcc: Subject: migrate from 8i to 9i 04/09/2002 03:18 PM Please respond to ORACLE-L Hi friends, I need your advise on the following question. I have DB on 8i and I want create new one on another machine with 9i. I thought do the following steps: 1 - Install oracle 9i on a new machine 2 - make full export of the 8i DB 3 - import it on the new one (9i) So before I proceed I need your input. Am I correct with these steps? There is something wrong? Many thanks for you, Kader __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kader Ben 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). __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kader Ben INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson
Re: disk subsystem performance question
Battery backup on the controller should help in this case. If there is none, write back mode should be used (instead of write through), loosing advantages of on-board caching (still helps with the reads). Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 10, 2002 6:58 PM Much of the supposed 'speed' may come from onboard caching on the controller. There is the minor risk that a crash could come after Oracle commits the data and before it is actually written to disk. --- [EMAIL PROTECTED] wrote: Hi all, We are running both a Hitachi 7700E and a 9960 disk subsystem here and we are getting ready to move our production DBs from the old(7700E) to the new(9960) Hitachi. We have had trouble in the past on the 7700E due to disk contention and layout, i.e. we weren't striped across the array groups very well this caused pretty poor I/O performance.This has been a learning experience for the DBAs and the SAs here for the logical vs. physical aspects of our disks. Anyway, to make a long story short, we are ordering disk for the move to the 9960 and we have 2 choices in disk sizes - 18GB and 73GB, and 2 choices in RAID - 1+0 and 5. I would like to get the smaller, faster 18GB drives in a RAID 1+0 configuration and stripe our data across the array groups as wide as possible. However, I am running into objections from the Hitachi people that their system is s fast we need not worry about such minor details. I'm having a hard time believing that given our I/O problems on the 7700E. Performance is given a high priority here. What I would like to know is others' experience with disk subsystems - specifically Hitachi but EMC and others as well have you been able to throw the disk in and forget it or have you had success in getting to the dirty details? Have you tested or noticed an improvement with smaller, faster drives in a disk subsystem like the Hitachi or have you traveled that path and found no noticeable improvement? I'm looking for either a) ammunition that my view is correct, or b) I'm wrong and we can get bigger drives which will make Enterprise Planning very happy from a $$$ standpoint because our Hitachi capacity will last longer. We are running Oracle 8.1.7 / AIX 4.3.3 / Peoplesoft Financials version 8. 2 production databases , one 400 GB and the other about 1TB. We've got some other production DBs but these are our big guys. Thanks in advance for any and all input - any help is greatly appreciated. I'd be happy to share any info we have found up to this point and our experiences on the 7700E as well if anyone is interested - despite the fact I will probably bore you to death :-) John Dailey Oracle DBA ING Americas - Application Services Atlanta, GA -- 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). = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett 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: Igor Neyman 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]
NVARCHAR2 datatype and FK. Bug???? Feature ????
Hi everybody, Oracle 8.1.7.2, Solaris. What is your opinion on this? Seems, Metalink doesn't have any :( SQL create table test_pk( 2 id nvarchar2(20) primary key 3 ); Table created. SQL create table test_Fk( 2 id nvarchar2(20), 3 constraint c_test_FK foreign key(id) references test_pk(id) on delete cascade); Table created. SQL insert into test_pk values (N'1'); 1 row created. SQL insert into test_fk values (N'1'); 1 row created. SQL commit; Commit complete. SQL delete from test_pk ; delete from test_pk * ERROR at line 1: ORA-12704: character set mismatch TIA Vadim Gorbounov Oracle DBA 724 Solutions Inc. Tel:(416)226-2900 ext 5070 Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vadim Gorbounov 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: Utl_file
I don't think you will be able to do what you want with utl_file unless you know the entire Excel file formatting details. I don't think BOLDING, RIGHT JUSTIFY, etc. can be part of a .cvs file. I know that Oracle has several products or options for $$$ that can do a lot of the Excel formation things for you. I have never had to deal directly with them and I am not even sure of all the available solutions. But in an effort to point you in the correct direction (maybe) look into Objects for OLE, Web DB, and Oracle Reports. There is no simple solution and you are going to need to do some research. Overall, I think is more pain than it's worth for just some fancy formatting (tell them to highlight and justify it themselves). Another option might be to put it in html table format, easy with utl_file, and then open/import that into Excel (just an idea) I tried to help, if all this is wrong, then just remember that it was for free;-) Brian P. MacLean Oracle DBA, OCP8i Roland.Skoldbl [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Utl_file om 04/11/02 05:28 AM Please respond to ORACLE-L Hallo, Is it possible to do a select from some tables in the database and then use utl_file package to create an excel file. And also to make the headers in the columns bold and right positioned. Please give me an easy example on how to write the code. Thanks in advance Roland -- 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).
Re: Submit job last day of each month
Your job interval should be: 'TRUNC(LAST_DAY(SYSDATE) + 1)' Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 11, 2002 12:25 PM Hi, Does anyone know how I can submit a job using dbms_job the last day of each month. I know there is a last_day function but cannot figure how to use this correctly in dbms_job. Thanks Rick -- 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: Igor Neyman 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: Currently log-in users
Try either of 1 script and make changes according to your requirement: 1) col LOGIN_TIME format a12 COL OSUSER FORMAT A7 COL ORACLE_USER FORMAT A8 COL PROGRAM FORMAT A25 COL PROCESS_NR FORMAT A8 col uur format A5 select to_char(a.logon_time,'DD/MM HH24:MI') LOGIN_TIME, to_char(round(c.seconds_in_wait/3600,0))||'.'|| to_char(round(mod(c.seconds_in_wait,3600)/60,0)) HOUR, a.osuser OS_USER, a.username ORACLE_USER, b.program PROGRAM, b.spid PROCESS_NR, a.sid SID, a.serial# SERIAL# from v$session a, v$process b, v$session_wait c where a.paddr=b.addr and a.sid=c.sid / 2- set linesize 120 select SADDR, SID, SERIAL#, PADDR, substr(USERNAME,1,8) USER, STATUS STATUS_, SCHEMA#, OSUSER, PROCESS, LOGON_TIME, LAST_CALL_ET from v$session order by osuser / Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 11 Apr 2002 07:53:26 -0800 How do I check who is currently logging into database, where he is accessing from and what he is doing? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M 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). MOHAMMAD RAFIQ _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.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).
RE: Utl_file
search on asktom.oracle.com for owa_sylk package, this is much better to export as excel format than csv format. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2
RE: OEM Error On Unix
Try oemctrl start oms -Original Message- Sent: Thursday, April 11, 2002 11:26 AM To: Multiple recipients of list ORACLE-L Hell All, I am seeing the following error , when I am trying to start OEM console on HP Unix. Any Idea , what I am missing and would like to know , what is this Management server and how to start it on HP Unix .. Thanks in advance ...OLE_Obj... Thanks, Madhu V Reddy Database Support Services (952) 324-0392 ( work ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reddy, Madhusudana 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: Nguyen, David M 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:Submit job last day of each month
declare job_id number; job varchar2(2000) := 'Fill in what you need'; begin dbms_job.submit(job_id, job, last_day(sysdate). 'last_day(sysdate)'); dbms_output.put_line('Job number is: '||job); end; Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 4/11/2002 8:25 AM Hi, Does anyone know how I can submit a job using dbms_job the last day of each month. I know there is a last_day function but cannot figure how to use this correctly in dbms_job. Thanks Rick -- 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).
Re: No DBAs needed on AS400
In the late 80's and early 90's I worked on an AS/400. We also had NO DBA, and the box looked and ran like we had NO DBA. Back then IBM pushed AS/400's as a put it in and forget it/don't worry about it box. And as a result our database looked and ran like a POS. I remember submitting jobs, and after 1 hour of elapsed run time the job had 1 second of cpu. That's when I made my decision to switch to Oracle and Unix. I'm sure AS/400's are fine quality machines, and I'm not trying to bash them here (everything has it's place in the market). If your looking for justification, find out if IBM offers training for AS/400 DBA's. Use the course description as ammunition as to why he should have had a DBA or ask him who carried out the tasks the class described. Also check out books on Amazon for same. Then describe the tasks that a Oracle DBA performs and ask him who he expects to perform them. He's just rattling your cage, time to rattle his. (This email is dedicated to Earl Fisher at Famous Footwear and all the irreparable damage he caused me) Brian P. MacLean Oracle DBA, OCP8i Jay Hostetter jhostetter@decommunica To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] tions.comcc: Sent by: Subject: No DBAs needed on AS400 [EMAIL PROTECTED] 04/11/02 06:54 AM Please respond to ORACLE-L We are going through a merger, and management is looking to eliminate positions. Here is a brief summary of my discussion with the new director of IT: Director: Back when I we were using an AS400, we didn't need a DBA. Me: Then you probably were just using files. Director: No, it was a database. Me: Could you issue SQL commands? Director: Yes. But we didn't need a DBA. I guess it was just one of those mysteries of life. My thoughts are that he is using the term database in the generic sense of the word (our files are our database), or he was using some proprietary database that doesn't even begin to compare to Oracle. For those of you who know AS400s, I would appreciate some insight that would demonstrate why he needs to keep me as a DBA. Thanks, Jay -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter 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: migrate from 8i to 9i
If that new box is a sand box, I would just play to see if exp of 8i can be imported in 9i. -Original Message- Sent: Thursday, April 11, 2002 10:03 AM To: Multiple recipients of list ORACLE-L I think you have to use only the 8i version on EXP and IMP in this case, as 9i EXP cannot connect to 8i database and 9i IMP cannot read 8i EXP dmp file. --- Kader Ben [EMAIL PROTECTED] wrote: Thanks I'm thinking about this idea, Ben --- [EMAIL PROTECTED] wrote: I'm assuming that you're creating a 9i database on the new machine when you install Oracle. I find it useful to pre-create the tablespaces (and users) on the new database, rather than let the import do that. This gives you more control over where datafiles end up and do some clearup on unneeded users, etc. Kader Ben kaderb To: Multiple recipients of list ORACLE-L @yahoo.com [EMAIL PROTECTED] Sent by: rootcc: Subject: migrate from 8i to 9i 04/09/2002 03:18 PM Please respond to ORACLE-L Hi friends, I need your advise on the following question. I have DB on 8i and I want create new one on another machine with 9i. I thought do the following steps: 1 - Install oracle 9i on a new machine 2 - make full export of the 8i DB 3 - import it on the new one (9i) So before I proceed I need your input. Am I correct with these steps? There is something wrong? Many thanks for you, Kader __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kader Ben 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). __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kader Ben 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: migrate from 8i to 9i
You must be thinking of something else, I just got thru doing a 9i import of an 8i dmp file. -Original Message- Sent: Thursday, April 11, 2002 12:03 PM To: Multiple recipients of list ORACLE-L I think you have to use only the 8i version on EXP and IMP in this case, as 9i EXP cannot connect to 8i database and 9i IMP cannot read 8i EXP dmp file. --- Kader Ben [EMAIL PROTECTED] wrote: Thanks I'm thinking about this idea, Ben --- [EMAIL PROTECTED] wrote: I'm assuming that you're creating a 9i database on the new machine when you install Oracle. I find it useful to pre-create the tablespaces (and users) on the new database, rather than let the import do that. This gives you more control over where datafiles end up and do some clearup on unneeded users, etc. Kader Ben kaderb To: Multiple recipients of list ORACLE-L @yahoo.com [EMAIL PROTECTED] Sent by: rootcc: Subject: migrate from 8i to 9i 04/09/2002 03:18 PM Please respond to ORACLE-L Hi friends, I need your advise on the following question. I have DB on 8i and I want create new one on another machine with 9i. I thought do the following steps: 1 - Install oracle 9i on a new machine 2 - make full export of the 8i DB 3 - import it on the new one (9i) So before I proceed I need your input. Am I correct with these steps? There is something wrong? Many thanks for you, Kader __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kader Ben 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). __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kader Ben 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: Submit job last day of each month
Oops... Sorry, should be: 'TRUNC(LAST_DAY(SYSDATE))' Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 11, 2002 1:03 PM Your job interval should be: 'TRUNC(LAST_DAY(SYSDATE) + 1)' Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 11, 2002 12:25 PM Hi, Does anyone know how I can submit a job using dbms_job the last day of each month. I know there is a last_day function but cannot figure how to use this correctly in dbms_job. Thanks Rick -- 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: Igor Neyman 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: Igor Neyman 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: cache buffer chains contention
Yep, Using CPU or being re-scheduled by the OS. Anjo. "Adams, Matthew (GEA, 088130)" wrote: Would it seem likely for Oracle to be doing ANYTHING for a full 30 seconds without hitting another wait? Matt Adams - GE Appliances - [EMAIL PROTECTED] Reason is 6/7ths of treason. - The Xtals -Original Message- From: Jonathan Lewis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 6:54 PM To: Multiple recipients of list ORACLE-L Subject: Re: cache buffer chains contention seconds_in_wait increments every three seconds, so if State is anything other than WAITING the column tells you how much time has passed since the last wait completed. (Contrary to the urban legend that says the value is meaningless). There are various anomalies and oddities about wait events, though, and if you session REALLY is doing nothing for 30 seconds, then you've hit one; however normally I would say that your session is busy doing something (from Oracle's perspective) in that 30 seconds. Jonathan Lewis http://www.jlcomp.demon.co.uk Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]> Date: 10 April 2002 20:56 |Ok, some guru please explain this to me. | |process is waiting for 'latch free' according to |v$session_wait and the value of P2 = 26 |which is the cache buffer chains latch. |(while holding the HW enqueue, with a bunch of |processes waiting on HW) | |State = 'WAITED KNOWN TIME', so I look at |WAIT_TIME, which is 2. | |However, the process does not appear to be doing |ANYTHING and the seconds in the SECONDS_IN_WAIT |column is increasing! This continues for about |30 seconds, when finally it finishes whatever |it was doing and allows the next process to |grab the HW enqueue | |Why would SECONDS_IN_WAIT be increasing when it supposed to be |done waiting already? | | | | |Matt Adams - GE Appliances - [EMAIL PROTECTED] |Reason is 6/7ths of treason. - The Xtals | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis 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: Currently log-in users
Thanks for the script. It is useful for me. David -Original Message- Sent: Thursday, April 11, 2002 12:09 PM To: Multiple recipients of list ORACLE-L Try either of 1 script and make changes according to your requirement: 1) col LOGIN_TIME format a12 COL OSUSER FORMAT A7 COL ORACLE_USER FORMAT A8 COL PROGRAM FORMAT A25 COL PROCESS_NR FORMAT A8 col uur format A5 select to_char(a.logon_time,'DD/MM HH24:MI') LOGIN_TIME, to_char(round(c.seconds_in_wait/3600,0))||'.'|| to_char(round(mod(c.seconds_in_wait,3600)/60,0)) HOUR, a.osuser OS_USER, a.username ORACLE_USER, b.program PROGRAM, b.spid PROCESS_NR, a.sid SID, a.serial# SERIAL# from v$session a, v$process b, v$session_wait c where a.paddr=b.addr and a.sid=c.sid / 2- set linesize 120 select SADDR, SID, SERIAL#, PADDR, substr(USERNAME,1,8) USER, STATUS STATUS_, SCHEMA#, OSUSER, PROCESS, LOGON_TIME, LAST_CALL_ET from v$session order by osuser / Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 11 Apr 2002 07:53:26 -0800 How do I check who is currently logging into database, where he is accessing from and what he is doing? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M 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). MOHAMMAD RAFIQ _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M 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: OEM Error On Unix
I could not see this on HP-UNIX client ( $OH/bin ) where I have installed all the Oracle Client ( Administration ), Would you let me know the location , where I can find this on UNIX --Madhu -Original Message- Sent: Thursday, April 11, 2002 12:29 PM To: Multiple recipients of list ORACLE-L Try oemctrl start oms -Original Message- Sent: Thursday, April 11, 2002 11:26 AM To: Multiple recipients of list ORACLE-L Hell All, I am seeing the following error , when I am trying to start OEM console on HP Unix. Any Idea , what I am missing and would like to know , what is this Management server and how to start it on HP Unix .. Thanks in advance ...OLE_Obj... Thanks, Madhu V Reddy Database Support Services (952) 324-0392 ( work ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reddy, Madhusudana 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: Nguyen, David M 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: Reddy, Madhusudana 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: IOUG conference get together
Count me in. When/Where? Any San Diego local(s) on the list? Stephen Andert [EMAIL PROTECTED] 04/09/02 07:43AM Do we have a location, date, time???--- Joe Testa [EMAIL PROTECTED] wrote: So for those of us going to the IOUG Conf, do we want to plan a get together? Throwing this out for ideas, etc. Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe 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).=Pete BarnettLead Database AdministratorThe Regence Group[EMAIL PROTECTED]__Do You Yahoo!?Yahoo! Tax Center - online filing with TurboTaxhttp://taxes.yahoo.com/-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Peter Barnett INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Add Instance
Hi List, I have 4 instance(for 4 databases) running on sun solaris oracle 8.1.6, if i want to add one of these instance as secondary instance to one of my database is it possible or not? if YES how? Appreciate Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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: No DBAs needed on AS400
Thank you for all the replies that I have received. It sounds like a version of DB2 comes along with the OS, or a full fledged version of DB2 can be installed. From what I have heard about their AS400 system, they can access their files directly - without going through a database. This reminds me of my COBOL days on VMS. It sounds like DB2 can be configured to use files, which would mean that you could either update the file directly or go through DB2 - is this correct? I can also make another VMS relation here - we had a tool called DataTrieve which you could configure to use regular files. You could then issue SQL like statements through DataTrieve against your files. Is DB2 like this? Somebody needed to configure DataTrieve before it could reference a file - what about DB2? Unless they never changed/added files on the AS400. Comments were made that DB2 and AS400s are not open. Does this mean that you couldn't write a client/server program to access data on DB2 (say using C++ from Windows 2000)? I'm off to find on-line docs... Answers to some questions: Does it have DB2 as the database? He didn't say that it was running DB2. If you are performing queries from Oracle to DB2 (SQL Queries), that is being performed through Oracle's gateway product. We are not doing this. [EMAIL PROTECTED] 04/11/02 10:44AM Jay - I can see the manager's confusion. After all, one expects computers to become easier and require less effort to maintain as time goes by. I forwarded your question to another list that has some AS/400 programmers. -- On the AS400 you can run queries and use SQL even though the machine is configured to use files. Under the covers it is still AS400/DB2. -- The AS/400 has a full-featured database built into the operating system. Originally it didn't even have a name but IBM started calling it DB2/400 when they found out that some people didn't know it was there. And you don't need a DBA. Virtually all the functions that are performed by a DBA on an Oracle database, for example, are handled automatically by the AS/400 under the covers. -- Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter 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: comming down the pipe
I alway thought it was pipeline. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -Original Message- Sent: Thursday, April 11, 2002 9:24 AM To: Multiple recipients of list ORACLE-L Wasn't that expression originally coming down the pike, as in turnpike? :-) __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel 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: Ball, Terry 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).
Is DATAFILE order important in CREATE CONTROLFILE?
I'm writing a Perl script to automate the procedure to create a copy of an 8.1.7 production DB to a development server. Both production and dev are HP/UX 11.0. In doing this, I've created a file that cross-references where the production datafiles are and where they are to be placed in dev. This works fine, but I also wanted to dynamically create the CREATE CONTROLFILE statement for the new dev DB. I've noticed that the DATAFILE clause does not have the SYSTEM tablespace's datafile first, nor are any of the other datafiles in the same order that they are in production (e.g. from the output of an ALTER SYSTEM BACKUP CONTROLFILE TO TRACE). Does this matter? Does the order need to be preserved? I suppose I'll end up dynamically creating the cross-reference file, which would preserve the order, but now I'm curious. TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: comming down the pipe
The 1904 World's Fair is where coming down the Pike originated. But the reference wasn't to a turnpike or to the family of North American fishies... http://www.crawforddirect.com/1904wf.html Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA Disclaimer: I'm an idiot, but the difference between me and other idiots is that at least I know I'm an idiot. -Original Message- From: Ball, Terry [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 11, 2002 1:43 PM To: Multiple recipients of list ORACLE-L Subject: RE: comming down the pipe I alway thought it was pipeline. -- 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:RE: No DBAs needed on AS400
DataTrieve!! That useful pile of *^%!! I have not heard of that tool in the last 10 years, boy are you ever tweaking the memory! It was one tool that I hated to love. Yes you did have to do some configuration before it would work, but once it was working could you ever parse a file. Slice Dice through mega byte logs with ease! So long as no one was trying to also update the file, then you'd have problems. Damn, those were the days!! :-) Dick Goulet Reply Separator Author: Jay Hostetter [EMAIL PROTECTED] Date: 4/11/2002 10:50 AM Thank you for all the replies that I have received. It sounds like a version of DB2 comes along with the OS, or a full fledged version of DB2 can be installed. From what I have heard about their AS400 system, they can access their files directly - without going through a database. This reminds me of my COBOL days on VMS. It sounds like DB2 can be configured to use files, which would mean that you could either update the file directly or go through DB2 - is this correct? I can also make another VMS relation here - we had a tool called DataTrieve which you could configure to use regular files. You could then issue SQL like statements through DataTrieve against your files. Is DB2 like this? Somebody needed to configure DataTrieve before it could reference a file - what about DB2? Unless they never changed/added files on the AS400. Comments were made that DB2 and AS400s are not open. Does this mean that you couldn't write a client/server program to access data on DB2 (say using C++ from Windows 2000)? I'm off to find on-line docs... Answers to some questions: Does it have DB2 as the database? He didn't say that it was running DB2. If you are performing queries from Oracle to DB2 (SQL Queries), that is being performed through Oracle's gateway product. We are not doing this. [EMAIL PROTECTED] 04/11/02 10:44AM Jay - I can see the manager's confusion. After all, one expects computers to become easier and require less effort to maintain as time goes by. I forwarded your question to another list that has some AS/400 programmers. -- On the AS400 you can run queries and use SQL even though the machine is configured to use files. Under the covers it is still AS400/DB2. -- The AS/400 has a full-featured database built into the operating system. Originally it didn't even have a name but IBM started calling it DB2/400 when they found out that some people didn't know it was there. And you don't need a DBA. Virtually all the functions that are performed by a DBA on an Oracle database, for example, are handled automatically by the AS/400 under the covers. -- Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter 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: Currently log-in users
I'm sure that everyone is sending you their version of this: ttitle off set pages 40 lines 132 column value heading '' column sessions_current format 999,999,999 heading '# Currently Logged On' column sessions_highwater format 999,999,999 heading 'Most # Logged On' column pusername format a8 heading 'Process|User' column terminal format a14 heading 'Terminal' column pprogram format a26 heading 'Process program' column susername format a8 heading 'Session|User' column server format a9 heading 'Server' column osuser format a8 heading 'Op Sys|User' column sprogram format a27 heading 'Session program' select value from v$parameter where name='db_name'; select sessions_current, sessions_highwater from v$license; select p.username pusername, s.terminal, p.program pprogram, s.username susername, server, osuser, s.program sprogram from v$process p, v$session s where addr=paddr(+) / Nguyen, David M To: Multiple recipients of list ORACLE-L david.m.nguy[EMAIL PROTECTED] en cc: @xo.com Subject: Currently log-in users Sent by: root 04/11/2002 11:53 AM Please respond to ORACLE-L How do I check who is currently logging into database, where he is accessing from and what he is doing? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M 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: insert performance
Dennis-- The faster machine had 10 database connections, the slower, 50. Not all were used in either case. But my comparison is for inserts done by a single session, i.e., it's not the aggregate insert rate, but a direct comparison of the same insert statement in a single session on each server. As for the disk layout, I don't have that information readily available (the SA department doesn't like to let the DBA department get involved in such things!). I don't think it's significantly different, though. Thanks, Paul --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Paul - How many insert processes did you run on each system? Is the disk layout identical in terms of spreading across devices? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, April 10, 2002 6:43 PM To: Multiple recipients of list ORACLE-L Greetings! I am trying to diagnose a performance difference between two databases running the same test. They are similarly configured (same SGA size, etc.), and the servers are identical except for the number of CPUs (server A has 4, server B has 6). On database A, INSERT performance is about 190 rows/second. On database B, INSERT performance is over 500 rows/second. I saw some cache buffers chains, buffer busy, and library cache latch waits on database A while the test was running, as well as redo log sync waits. The waits didn't seem excessive, though. I checked for checkpoint not complete redo allocation messages in database A's alert log and found none. The db_block_lru_latches parameter is set to one-half the number of CPUs in both machines. I'd much appreciate any suggestions as to what else to check. I know that freelists can be an issue (there are multiple sessions performing inserts); how can I check to see if there's freelist contention? Anything else I should investigate? Many TIA, = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel 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: No DBAs needed on AS400
Title: RE: No DBAs needed on AS400 Comments were made that DB2 and AS400s are not open. Does this mean that you couldn't write a client/server program to access data on DB2 (say using C++ from Windows 2000)? RUMBA/400 formerly pc support connects to the AS400 from a windows pc. Last I knew, the AS400 data need to be converted from EBCDIC into the wrkdoc area for ASCII in order for Rumba/400 to work with it correctly. -Original Message- From: Jay Hostetter [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 11, 2002 2:51 PM To: Multiple recipients of list ORACLE-L Subject: RE: No DBAs needed on AS400 Thank you for all the replies that I have received. It sounds like a version of DB2 comes along with the OS, or a full fledged version of DB2 can be installed. From what I have heard about their AS400 system, they can access their files directly - without going through a database. This reminds me of my COBOL days on VMS. It sounds like DB2 can be configured to use files, which would mean that you could either update the file directly or go through DB2 - is this correct? I can also make another VMS relation here - we had a tool called DataTrieve which you could configure to use regular files. You could then issue SQL like statements through DataTrieve against your files. Is DB2 like this? Somebody needed to configure DataTrieve before it could reference a file - what about DB2? Unless they never changed/added files on the AS400. Comments were made that DB2 and AS400s are not open. Does this mean that you couldn't write a client/server program to access data on DB2 (say using C++ from Windows 2000)? I'm off to find on-line docs... Answers to some questions: Does it have DB2 as the database? He didn't say that it was running DB2. If you are performing queries from Oracle to DB2 (SQL Queries), that is being performed through Oracle's gateway product. We are not doing this. [EMAIL PROTECTED] 04/11/02 10:44AM Jay - I can see the manager's confusion. After all, one expects computers to become easier and require less effort to maintain as time goes by. I forwarded your question to another list that has some AS/400 programmers. -- On the AS400 you can run queries and use SQL even though the machine is configured to use files. Under the covers it is still AS400/DB2. -- The AS/400 has a full-featured database built into the operating system. Originally it didn't even have a name but IBM started calling it DB2/400 when they found out that some people didn't know it was there. And you don't need a DBA. Virtually all the functions that are performed by a DBA on an Oracle database, for example, are handled automatically by the AS/400 under the covers. -- Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter 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: Is DATAFILE order important in CREATE CONTROLFILE?
Order of files in alter system backup... does not matter. Wow using Perl to do this when then procedure is documented a 1000 times over. I am sure you have some very good reason. Automating something that I would think is not very frequent may be overkill. Oh well enjoy. Rick Jesse, Rich Rich.Jesse@qtiTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] world.com cc: Sent by: Subject: Is DATAFILE order important in CREATE CONTROLFILE? [EMAIL PROTECTED] m 04/11/2002 03:13 PM Please respond to ORACLE-L I'm writing a Perl script to automate the procedure to create a copy of an 8.1.7 production DB to a development server. Both production and dev are HP/UX 11.0. In doing this, I've created a file that cross-references where the production datafiles are and where they are to be placed in dev. This works fine, but I also wanted to dynamically create the CREATE CONTROLFILE statement for the new dev DB. I've noticed that the DATAFILE clause does not have the SYSTEM tablespace's datafile first, nor are any of the other datafiles in the same order that they are in production (e.g. from the output of an ALTER SYSTEM BACKUP CONTROLFILE TO TRACE). Does this matter? Does the order need to be preserved? I suppose I'll end up dynamically creating the cross-reference file, which would preserve the order, but now I'm curious. TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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).
How to Find Every View In Which a Column is Used.
The dependencies tables do not go down to the column level. If I want to know all views that access the sal column of scott.emp how do I do this. I can find out the name of the views which access the table via dependencies, get the view text and parse it by eye. But I don't want to do that. I want the database to do so. I can use dbms_dql.parse, dbms_sql.describe columns, and the text of the view; however, this method does not work very well if the view contains a function or an operation on the column. Oracle must hold this information somewhere after a statement is parsed, but where ? Ian -- 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: Is DATAFILE order important in CREATE CONTROLFILE?
Jesse - No, order isn't important. This is a relational database after all - right? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, April 11, 2002 2:13 PM To: Multiple recipients of list ORACLE-L I'm writing a Perl script to automate the procedure to create a copy of an 8.1.7 production DB to a development server. Both production and dev are HP/UX 11.0. In doing this, I've created a file that cross-references where the production datafiles are and where they are to be placed in dev. This works fine, but I also wanted to dynamically create the CREATE CONTROLFILE statement for the new dev DB. I've noticed that the DATAFILE clause does not have the SYSTEM tablespace's datafile first, nor are any of the other datafiles in the same order that they are in production (e.g. from the output of an ALTER SYSTEM BACKUP CONTROLFILE TO TRACE). Does this matter? Does the order need to be preserved? I suppose I'll end up dynamically creating the cross-reference file, which would preserve the order, but now I'm curious. TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: cache buffer chains contention
It's certainly possible for Oracle to be pushed into very heavy CPU usage, particularly for PX slaves, but even in serial queries. Two common 'causes' are queries with correlated sub-queries against small tables; and queries which have been over-indexed and hinted to avoid table-scans. Bottom line, though, is that if the session does not appear to be in an Oracle-recorded wait state, it is either using (or scheduled to use) CPU, or you've hit a wait state that isn't instrumented properly. Jonathan Lewis http://www.jlcomp.demon.co.uk Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis 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).
V$SESSION
If there is an entry in V$SESSION, does it imply that user has a current session within the instance? If not, how do I determine which users have logged out of the DB? Under what conditions would I not be able to obtain any SQL from V$SQLAREA for any given SID? 1 select username, osuser, sql_text 2 from v$session ss, v$sqlarea sa 3 where ss.sid = 861 4 and ss.sql_address = sa.address 5* and ss.sql_hash_value = sa.hash_value [EMAIL PROTECTED] / no rows selected [EMAIL PROTECTED] select * from v$session where sid = 861; SADDR SIDSERIAL# AUDSID PADDR USER# USERNAME COMMAND TADDR -- -- -- -- -- -- LOCKWAIT STATUS SERVER SCHEMA# SCHEMANAME OSUSER PROCESS - -- -- --- - MACHINE TERMINAL - PROGRAM TYPE SQL_ADDR SQL_HASH_VALUE PREV_SQL -- -- PREV_HASH_VALUE MODULE MODULE_HASH --- --- ACTION ACTION_HASH --- CLIENT_INFO FIXED_TABLE_SEQUENCE ROW_WAIT_OBJ# - ROW_WAIT_FILE# ROW_WAIT_BLOCK# ROW_WAIT_ROW# LOGON_TIM LAST_CALL_ET -- --- - - AF4518E4861680 47669205 AF289B1C 2494 OPS$RCAMPBEL0 INACTIVE DEDICATED 2494 OPS$RCAMPBEL rcampbel 25645 titanpts/200 runform30@titan (TNS interface) USER 000 A54EFF6C -2.129E+09 frmula_inq1635528872 from menu_driver 306861083 683581 -1 14 13785328 11-APR-02 117 -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 Daylight Savings Time means that everybody gets up 1 hour earlier. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler 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: OEM Error On Unix
Try to do $which oemctrl or $find / -name *oem* -print Someone on the distro might add in comments David -Original Message- Sent: Thursday, April 11, 2002 1:04 PM To: Multiple recipients of list ORACLE-L I could not see this on HP-UNIX client ( $OH/bin ) where I have installed all the Oracle Client ( Administration ), Would you let me know the location , where I can find this on UNIX --Madhu -Original Message- Sent: Thursday, April 11, 2002 12:29 PM To: Multiple recipients of list ORACLE-L Try oemctrl start oms -Original Message- Sent: Thursday, April 11, 2002 11:26 AM To: Multiple recipients of list ORACLE-L Hell All, I am seeing the following error , when I am trying to start OEM console on HP Unix. Any Idea , what I am missing and would like to know , what is this Management server and how to start it on HP Unix .. Thanks in advance ...OLE_Obj... Thanks, Madhu V Reddy Database Support Services (952) 324-0392 ( work ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reddy, Madhusudana 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: Nguyen, David M 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: Reddy, Madhusudana 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: Nguyen, David M 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: comming down the pipe
Hello, Pipeline is for sales and gas, almost the same thing. It's coming down the (turn)pike is the way to describe something that is anticipated soon. Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: Thursday, April 11, 2002 2:43 PM To: Multiple recipients of list ORACLE-L I alway thought it was pipeline. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -Original Message- Sent: Thursday, April 11, 2002 9:24 AM To: Multiple recipients of list ORACLE-L Wasn't that expression originally coming down the pike, as in turnpike? :-) __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel 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: Ball, Terry 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: Sherman, Paul R. 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 9i doesn't start on Linux
Hi Zsolt , check /etc/oratab, you may need to replace N by Y hth Vadim -Original Message- Sent: Thursday, April 11, 2002 4:04 PM To: Multiple recipients of list ORACLE-L Hi, I've installed Oracle 9i on Suse Linux 7.1. The lsnrctl starts nicely, however when I type dbstart then it does absolutelly nothing. No error message, but the database won't start. Any ideas? Thank you in advance Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Zsolt Csillag 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: Vadim Gorbounov 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: comming down the pipe
Rich - Thanks for this cultural education. -Original Message- Sent: Thursday, April 11, 2002 2:19 PM To: Multiple recipients of list ORACLE-L The 1904 World's Fair is where coming down the Pike originated. But the reference wasn't to a turnpike or to the family of North American fishies... http://www.crawforddirect.com/1904wf.html Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA Disclaimer: I'm an idiot, but the difference between me and other idiots is that at least I know I'm an idiot. -Original Message- From: Ball, Terry [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 11, 2002 1:43 PM To: Multiple recipients of list ORACLE-L Subject: RE: comming down the pipe I alway thought it was pipeline. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).