oraperf.dll issue
8.1.7.1.1 - W2K SP2 we're getting warning messages in the Event Viewer as follows. The data buffer created for the Oracle8 service in the C:\WINNT\system32\oraperf.dll library is not aligned on an 8-byte boundary. This may cause problems for applications that are trying to read the performance data buffer. Contact the manufacturer of this library or service to have this problem corrected or to get a newer version of this library. It's related to the Windows performance monitor but aside from that I have no idea what it is or how to address it. Does anybody have idea what this is, or the effect of it on the system if any? Can we ignore this warning or should we act on it? Any answers or suggestions are greatly appreciated. - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
move some records of some tables
Hi, what's the best method to move some rows of some tables of a user from one database to another database on another server? I need a step by step document to achieve this. Thanks, Murat -- Bu e-posta sadece yukarida isimleri belirtilen kisiler arasinda ozel haberlesme amacini tasimaktadir. Size yanlislikla ulasmissa lutfen mesaji geri gonderiniz ve sisteminizden siliniz. Rt.Net Internet Hizmetleri Pazarlama ve Ticaret A.S. bu mesajin icerigi ile ilgili olarak hic bir hukuksal sorumlulugu kabul etmez. This e-mail communication is intended for the private use of the persons named above. If you received this message in error, please immediately notify the sender and delete it from your system. Rt.Net Internet Hizmetleri Pazarlama ve Ticaret A.S. does not accept legal responsibility for the contents of this message. -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MURAT BALKAS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
AW: oraperf.dll issue
Look at following site: http://www.eventid.net HTH Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: O'Neill, Sean [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 2. Dezember 2002 12:39 An: Multiple recipients of list ORACLE-L Betreff: oraperf.dll issue 8.1.7.1.1 - W2K SP2 we're getting warning messages in the Event Viewer as follows. The data buffer created for the Oracle8 service in the C:\WINNT\system32\oraperf.dll library is not aligned on an 8-byte boundary. This may cause problems for applications that are trying to read the performance data buffer. Contact the manufacturer of this library or service to have this problem corrected or to get a newer version of this library. It's related to the Windows performance monitor but aside from that I have no idea what it is or how to address it. Does anybody have idea what this is, or the effect of it on the system if any? Can we ignore this warning or should we act on it? Any answers or suggestions are greatly appreciated. - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: patches
Title: Pro*C for Oracle 817 on Win2000? Yechiel, If that's your philosophy, and there are known unpatched bugs in the server software, how can you be 100 percent sure it will stay up? Granted, many of these bugs are esoteric, but not all. I am curious what Oracle Support consultants do when they have a 24x7 contract, with all these patches. Surely they have a list. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) [Boivin, Patrice J]-Original Message-From: Yechiel Adar [mailto:[EMAIL PROTECTED]]Sent: Friday, November 29, 2002 3:49 AMTo: Multiple recipients of list ORACLE-LSubject: Re: patches We only apply patches as needed and where needed. For example: I had a problem with export taking a long time on one system. I installed a patch for this problem (after testing in test environment of course) only on that database. My motto is: If it ain't broken do not fix it. I have seen too many follow up fixes to install something I do not need. Yechiel AdarMehish - Original Message - From: Boivin, Patrice J To: Multiple recipients of list ORACLE-L Sent: Wednesday, November 27, 2002 9:05 PM Subject: patches I am wondering how your sites handle patching production servers. I just did a search in MetaLink, since 8174 was released there have been 48 patches (if I just select RDBMS). If I select other items in my search,I get upwards of 70 additional bug fixes. How do high reliability sites handle patching? I assume they would rather fix potential problems (testing the patches on a testbed of course) rather than just apply bug fixes as problems are encountered on production servers. regards, Patrice Boivin Systems Analyst (Oracle Certified DBA)
RE: Effect of Upgrading O/S to the 817 database !!!
Methinks NT version 5 is Windows2000 under another name... probably a typo though. Check the certification matrix, but here we are successfully running 8.1.7.4.5. on Windows2000 servers. Windows2000 seems to be more stable than NT 4, from what I've seen so far. Our Windows server administrator certainly things so! There are caveats re. Terminal Server though, check the certification matrix. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Friday, November 29, 2002 4:00 PM To: Multiple recipients of list ORACLE-L Jackson - It is a holiday for most of the U.S. folks, but hopefully someone will get back to you. I am on Unix myself, so of no help to you. My laptop was recently upgraded from NT to 2000 Professional, and the PC administrators said that their experience was to not upgrade the system, but to reformat the hard drive, fresh install Windows 2000 and then reinstall everything. I think your existing Oracle software should be good to reinstall, but you should check the compatibility on http://metalink.oracle.com. And of course you will be doing this on your test machine before you jeopardize your production system. You don't say which 8.1.7 version you are using - 8.1.7.4? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, November 29, 2002 7:04 AM To: Multiple recipients of list ORACLE-L Hi We are currently running Oracle 817 database on a Windows NT, version 5, service pack 6. We need to upgrade O/S to Windows 2000. What should we do on the database side, do we need to do a new Oracle 817 software installation after upgrading O/S and try to startup the database or do we need to do everything from scratch, i.e. install software, create database and import ? I tought this should not have an effect on the database, if that the case, do we then need to just try to startup the database after O/S upgrade ? Please help ...your response will be highly appreciated. Desperado ___ http://www.webmail.co.za the South-African free email service NetWiseGurus.Com Portal - Your Own Internet Business Today! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jackson Dumas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: move some records of some tables
- create database link ... - insert into ... select from ... - delete from ... - commit - drop database link ... Cheers Connor --- MURAT BALKAS [EMAIL PROTECTED] wrote: Hi, what's the best method to move some rows of some tables of a user from one database to another database on another server? I need a step by step document to achieve this. Thanks, Murat -- Bu e-posta sadece yukarida isimleri belirtilen kisiler arasinda ozel haberlesme amacini tasimaktadir. Size yanlislikla ulasmissa lutfen mesaji geri gonderiniz ve sisteminizden siliniz. Rt.Net Internet Hizmetleri Pazarlama ve Ticaret A.S. bu mesajin icerigi ile ilgili olarak hic bir hukuksal sorumlulugu kabul etmez. This e-mail communication is intended for the private use of the persons named above. If you received this message in error, please immediately notify the sender and delete it from your system. Rt.Net Internet Hizmetleri Pazarlama ve Ticaret A.S. does not accept legal responsibility for the contents of this message. -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MURAT BALKAS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Shared Pool Size
Shuan - Bumping up the memory for shared pool and database buffers may well turn out to be the answer, but before you just jump in and make the changes and hope for the best, why not dig into the root causes of the slowness first? Specifically, collect information on the top wait events. I'm not familiar with Toad, but perhaps it can provide these. My personal favorite is STATSPACK, which comes with Oracle, but you'll have to install it. Or you can just directly query the V$ views. If the wait statistics confirm the need to increase these buffers, once you make the change you can measure these statistics again and confirm that you are making a positive improvement. Also, does your signature have some sort of foreign language font? When I opened your email I got an error message about that. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Sunday, December 01, 2002 6:34 PM To: Multiple recipients of list ORACLE-L Dear all DBAs, My Oracle 8.0.5(running on Linux 6.4 kernel 2.2.14) is getting slower recently. Every data input utput is slow. And the Server Stat in Toad showing: Library Cache Get Hit Ratio 51.5540 May need to increase DB_BLOCK_BUFFERS Library Cache Pin Hit Ratio 93.6161 Shared Pool area too small Is that means i should increase the size of shared pool and DB_BLOCK_BUFFERS? the values in init.ora: db_block_buffers = 550 shared_pool_size = 1900 Thanks for helps! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: patches
I think I veer towards Yechiel's view here Patrice. I am not sure I have ever heard anyone suggest applying all outstanding relevant patches to a database however much you test first. (To be honest you are not advocating that, just raising the question). Normal policy wherever I have worked is not to patch unless absolutely necessary. Another point is that 1 patch can provide a new code piece of binary and patches are not cumulative. Therefore applying patch a then patch b could well mean that patch a is overwritten and yet your documentation indicates that it has been installed. HTH John -Original Message- Sent: 02 December 2002 12:54 To: Multiple recipients of list ORACLE-L Yechiel, If that's your philosophy, and there are known unpatched bugs in the server software, how can you be 100 percent sure it will stay up? Granted, many of these bugs are esoteric, but not all. I am curious what Oracle Support consultants do when they have a 24x7 contract, with all these patches. Surely they have a list. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) [Boivin, Patrice J] -Original Message- Sent: Friday, November 29, 2002 3:49 AM To: Multiple recipients of list ORACLE-L We only apply patches as needed and where needed. For example: I had a problem with export taking a long time on one system. I installed a patch for this problem (after testing in test environment of course) only on that database. My motto is: If it ain't broken do not fix it. I have seen too many follow up fixes to install something I do not need. Yechiel Adar Mehish - Original Message - To: Multiple mailto:[EMAIL PROTECTED] recipients of list ORACLE-L Sent: Wednesday, November 27, 2002 9:05 PM I am wondering how your sites handle patching production servers. I just did a search in MetaLink, since 8174 was released there have been 48 patches (if I just select RDBMS). If I select other items in my search, I get upwards of 70 additional bug fixes. How do high reliability sites handle patching? I assume they would rather fix potential problems (testing the patches on a testbed of course) rather than just apply bug fixes as problems are encountered on production servers. regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
INIT 6 on Solaris not working with Oracle automated scripts?
Has anyone encountered a problem rebooting a Solaris box using INIT 6 with the Oracle dbstart/dbshut scripts enabled? My sysadmin seems to feel the problem rests with the Oracle scripts - we issue INIT 6 and nothing happens. Thanks -bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: move some records of some tables
Murat - The best method depends on several circumstances such as how much data is involved. The simplest method if you have two Oracle instances is export/import. Is the username the same on both instances? Are there differences between the instances such as NLS character sets? Are both instances the same Oracle version? Are you moving all the tables for the user? All the rows in each table? Do those tables already exist on the other instance? If yes, do the tables already contain data? If you are not familiar with the Oracle export/import utilities, a good start is to look at this link. http://www.orafaq.net/faqiexp.htm Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, December 02, 2002 5:44 AM To: Multiple recipients of list ORACLE-L Hi, what's the best method to move some rows of some tables of a user from one database to another database on another server? I need a step by step document to achieve this. Thanks, Murat -- Bu e-posta sadece yukarida isimleri belirtilen kisiler arasinda ozel haberlesme amacini tasimaktadir. Size yanlislikla ulasmissa lutfen mesaji geri gonderiniz ve sisteminizden siliniz. Rt.Net Internet Hizmetleri Pazarlama ve Ticaret A.S. bu mesajin icerigi ile ilgili olarak hic bir hukuksal sorumlulugu kabul etmez. This e-mail communication is intended for the private use of the persons named above. If you received this message in error, please immediately notify the sender and delete it from your system. Rt.Net Internet Hizmetleri Pazarlama ve Ticaret A.S. does not accept legal responsibility for the contents of this message. -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MURAT BALKAS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: patches
John - Excellent points. Patrice - One factor to consider is that patches tend to be tested very little by the software vendor. Full releases get tested extensively, but even then there are gaps, because well, we wouldn't be having patches otherwise. If you've ever been a developer at a software vendor, what happens is one customer reports an error. You verify the error and create a patch to fix that specific error. But no comprehensive system testing is done. You ship that patch to fix that problem. Sometimes a vendor will bundle a group of patches together into a patch bundle. Here the testing is much more extensive than for the single patch, but still far short of the extensive full release testing. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, December 02, 2002 7:44 AM To: Multiple recipients of list ORACLE-L I think I veer towards Yechiel's view here Patrice. I am not sure I have ever heard anyone suggest applying all outstanding relevant patches to a database however much you test first. (To be honest you are not advocating that, just raising the question). Normal policy wherever I have worked is not to patch unless absolutely necessary. Another point is that 1 patch can provide a new code piece of binary and patches are not cumulative. Therefore applying patch a then patch b could well mean that patch a is overwritten and yet your documentation indicates that it has been installed. HTH John -Original Message- Sent: 02 December 2002 12:54 To: Multiple recipients of list ORACLE-L Yechiel, If that's your philosophy, and there are known unpatched bugs in the server software, how can you be 100 percent sure it will stay up? Granted, many of these bugs are esoteric, but not all. I am curious what Oracle Support consultants do when they have a 24x7 contract, with all these patches. Surely they have a list. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) [Boivin, Patrice J] -Original Message- Sent: Friday, November 29, 2002 3:49 AM To: Multiple recipients of list ORACLE-L We only apply patches as needed and where needed. For example: I had a problem with export taking a long time on one system. I installed a patch for this problem (after testing in test environment of course) only on that database. My motto is: If it ain't broken do not fix it. I have seen too many follow up fixes to install something I do not need. Yechiel Adar Mehish - Original Message - To: Multiple mailto:[EMAIL PROTECTED] recipients of list ORACLE-L Sent: Wednesday, November 27, 2002 9:05 PM I am wondering how your sites handle patching production servers. I just did a search in MetaLink, since 8174 was released there have been 48 patches (if I just select RDBMS). If I select other items in my search, I get upwards of 70 additional bug fixes. How do high reliability sites handle patching? I assume they would rather fix potential problems (testing the patches on a testbed of course) rather than just apply bug fixes as problems are encountered on production servers. regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: INIT 6 on Solaris not working with Oracle automated scripts?
Has anyone encountered a problem rebooting a Solaris box using INIT 6 with the Oracle dbstart/dbshut scripts enabled? My sysadmin seems to feel the problem rests with the Oracle scripts - we issue INIT 6 and nothing happens. Which version (and kernel patchlevel) of Solaris? Which version of Oracle? Gary Chambers //-- // Lucent Technologies CIO/Servers/Unix // Senior Unix System Administrator // 4 Robbins Road, Westford, MA 01886 // 978-399-0481 / 888-480-6924 (Pager) // Nothing fancy and nothing Microsoft //-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Chambers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Effect of Upgrading O/S to the 817 database !!!
Not a typo: type 'winver' at the cmd prompt on a win2k machine. On Monday 02 December 2002 04:53, Boivin, Patrice J wrote: Methinks NT version 5 is Windows2000 under another name... probably a typo though. Check the certification matrix, but here we are successfully running 8.1.7.4.5. on Windows2000 servers. Windows2000 seems to be more stable than NT 4, from what I've seen so far. Our Windows server administrator certainly things so! There are caveats re. Terminal Server though, check the certification matrix. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Friday, November 29, 2002 4:00 PM To: Multiple recipients of list ORACLE-L Jackson - It is a holiday for most of the U.S. folks, but hopefully someone will get back to you. I am on Unix myself, so of no help to you. My laptop was recently upgraded from NT to 2000 Professional, and the PC administrators said that their experience was to not upgrade the system, but to reformat the hard drive, fresh install Windows 2000 and then reinstall everything. I think your existing Oracle software should be good to reinstall, but you should check the compatibility on http://metalink.oracle.com. And of course you will be doing this on your test machine before you jeopardize your production system. You don't say which 8.1.7 version you are using - 8.1.7.4? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, November 29, 2002 7:04 AM To: Multiple recipients of list ORACLE-L Hi We are currently running Oracle 817 database on a Windows NT, version 5, service pack 6. We need to upgrade O/S to Windows 2000. What should we do on the database side, do we need to do a new Oracle 817 software installation after upgrading O/S and try to startup the database or do we need to do everything from scratch, i.e. install software, create database and import ? I tought this should not have an effect on the database, if that the case, do we then need to just try to startup the database after O/S upgrade ? Please help ...your response will be highly appreciated. Desperado ___ http://www.webmail.co.za the South-African free email service NetWiseGurus.Com Portal - Your Own Internet Business Today! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle on windows and shadow thread file access
Maybe not all of the data files, but the users dedicated server process will open datafiles as needed to read data into the block buffer. Now I don't know if I've helped any, or just added to the confusion. Jared No, that was pretty much what I wanted to know - was there any time when a user's dedicated server process - as opposed to smon, pmon, chpt, arch, lgwr, dbwr, etc. - actually acquired a file handle and opened the file. Thanks for the discussion on this. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9iR2 on Red Hat 8.0
I installed oracle 9.2 on RH 8.0 and there weren't any major issues. The only problem was that RH 8.0 comes WITHOUT XMMS I had to download XMMS myself and to manually relink all my plug-ins (alarm, gtk_list, normalization, 3D sound and some others). I also had to manually recompile lame and cdparanoia and download grip rpm from rpmfind.net. RH rendered my 2000+ MP3 files that, of course, I have only for testing purposes, completely useless without a large effort on my part. This was completely outrageous! -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 12:44 AM To: Multiple recipients of list ORACLE-L Subject: Oracle 9iR2 on Red Hat 8.0 If you've installed Oracle 9i on RH 8.0, please let me know. Also, please let me know of any difficulties and workarounds you may have encountered. Just put a new 40Gig HD in my laptop, and wondering if I can install RH 8.0, or should use 7.2. Thanks Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: IOUG 2003
And Allen Greenspan says inflation is under control... --- [EMAIL PROTECTED] wrote: Dues were $75.00 last year. Weaver, Walt [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/27/2002 07:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: IOUG 2003 Speaking of IOUG, did anyone else get a membership renewal email recently? Seems to me the annual dues have gone up significantly this year. --Walt Weaver Bozeman, Montana -Original Message- Sent: Wednesday, November 27, 2002 8:04 AM To: Multiple recipients of list ORACLE-L Okay, so I'm trying to get costs for conferences etc so my boss can budget for them. I go to the IOUG site and look at costs for the 2003 conference. I see register online so I click on it. They have it set up for speaker registration already, and ask for the email confirmation code you received. Has anyone on this list, who submitted an abstract, actually RECEIVED a response? Either acceptance or rejection? I haven't. How can you set something up to allow people to register if they don't know which way to register? Sheesh. I can't even register for the University Session I want because I don't know what status I should use when registering. Rachel __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: move some records of some tables
answeres inserted. DENNIS WILLIAMS DWILLIAMS@LIFETOTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] UCH.COM cc: Sent by: Subject: RE: move some records of some tables [EMAIL PROTECTED] 12/02/2002 03:44 PM Please respond to ORACLE-L Murat - The best method depends on several circumstances such as how much data is involved. The simplest method if you have two Oracle instances is export/import. Is the username the same on both instances? Yes. Are there differences between the instances such as NLS character sets? No, they're the same. Are both instances the same Oracle version? Yes. Are you moving all the tables for the user? No. All the rows in each table? No. Do those tables already exist on the other instance? Yes. If yes, do the tables already contain data? Yes. And... Another difference is : Original tables are on the SYSTEM tablesapce. This was made by mistake. Tables I'll import to are on another tablespace. If you are not familiar with the Oracle export/import utilities, a good start is to look at this link. http://www.orafaq.net/faqiexp.htm Thanks, I'll look at it. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, December 02, 2002 5:44 AM To: Multiple recipients of list ORACLE-L Hi, what's the best method to move some rows of some tables of a user from one database to another database on another server? I need a step by step document to achieve this. Thanks, Murat -- Bu e-posta sadece yukarida isimleri belirtilen kisiler arasinda ozel haberlesme amacini tasimaktadir. Size yanlislikla ulasmissa lutfen mesaji geri gonderiniz ve sisteminizden siliniz. Rt.Net Internet Hizmetleri Pazarlama ve Ticaret A.S. bu mesajin icerigi ile ilgili olarak hic bir hukuksal sorumlulugu kabul etmez. This e-mail communication is intended for the private use of the persons named above. If you received this message in error, please immediately notify the sender and delete it from your system. Rt.Net Internet Hizmetleri Pazarlama ve Ticaret A.S. does not accept legal responsibility for the contents of this message. -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MURAT BALKAS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL
RE: move some records of some tables
Murat Congratulations on moving the tables out of the SYSTEM tablespace. That is how most of us become better DBAs -- by doing it wrong first. I've learned those lessons myself. Now I read this list and learn from the mistakes of others. If the tables you are moving data into already contain data, you need to decide how to make sure you don't end up with duplicate data. If each table has a primary key, this will prevent duplicate data, but then your import will fail. If the data overlaps and you want the data from the other instance to be loaded, you can first delete the data that overlaps and then import the data. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, December 02, 2002 9:30 AM To: Multiple recipients of list ORACLE-L answeres inserted. DENNIS WILLIAMS DWILLIAMS@LIFETOTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] UCH.COM cc: Sent by: Subject: RE: move some records of some tables [EMAIL PROTECTED] 12/02/2002 03:44 PM Please respond to ORACLE-L Murat - The best method depends on several circumstances such as how much data is involved. The simplest method if you have two Oracle instances is export/import. Is the username the same on both instances? Yes. Are there differences between the instances such as NLS character sets? No, they're the same. Are both instances the same Oracle version? Yes. Are you moving all the tables for the user? No. All the rows in each table? No. Do those tables already exist on the other instance? Yes. If yes, do the tables already contain data? Yes. And... Another difference is : Original tables are on the SYSTEM tablesapce. This was made by mistake. Tables I'll import to are on another tablespace. If you are not familiar with the Oracle export/import utilities, a good start is to look at this link. http://www.orafaq.net/faqiexp.htm Thanks, I'll look at it. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, December 02, 2002 5:44 AM To: Multiple recipients of list ORACLE-L Hi, what's the best method to move some rows of some tables of a user from one database to another database on another server? I need a step by step document to achieve this. Thanks, Murat -- Bu e-posta sadece yukarida isimleri belirtilen kisiler arasinda ozel haberlesme amacini tasimaktadir. Size yanlislikla ulasmissa lutfen mesaji geri gonderiniz ve sisteminizden siliniz. Rt.Net Internet Hizmetleri Pazarlama ve Ticaret A.S. bu mesajin icerigi ile ilgili olarak hic bir hukuksal sorumlulugu kabul etmez. This e-mail communication is intended for the private use of the persons named above. If you received this message in error, please immediately notify the sender and delete it from your system. Rt.Net Internet Hizmetleri Pazarlama ve Ticaret A.S. does not accept legal responsibility for the contents of this message. -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MURAT BALKAS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MURAT BALKAS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
Re: INIT 6 on Solaris not working with Oracle automated
I'm not having a problem withSolaris 9 and init 6 - in fact I have to use init 6 to get my scripts to work. [EMAIL PROTECTED] 12/02/02 07:58AM Has anyone encountered a problem rebooting a Solaris box using INIT 6 withthe Oracle dbstart/dbshut scripts enabled?My sysadmin seems to feel the problem rests with the Oracle scripts - weissue INIT 6 and nothing happens.Thanks-bill-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Magaliff, Bill INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To 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).
RE: Oracle 9iR2 on Red Hat 8.0
Oracle 92i runs fine on all recent Linux distros. I've tested it on Mandrake 9.0 and all's well. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: INIT 6 on Solaris not working with Oracle automated scripts?
init 6 -- takes the system to level 0 and then back to the default level specified in /etc/inittab (initdefault) which is usually level 3 (check /sbin/rc6). The startup script will need to be linked to level 3 (or whatever default level you have in inittab). Also make sure that the shutdown script for Oracle is working if you run it manually (I remember I had to modify them some time ago, for example check if it uses the shutdown immediate mode, replace svrmgrl with sqlplus, etc.). Regards, Waleed -Original Message- Sent: Monday, December 02, 2002 8:59 AM To: Multiple recipients of list ORACLE-L Has anyone encountered a problem rebooting a Solaris box using INIT 6 with the Oracle dbstart/dbshut scripts enabled? My sysadmin seems to feel the problem rests with the Oracle scripts - we issue INIT 6 and nothing happens. Thanks -bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Import Table from Full Backup
Hi listers, Thanks for the comments to Dennis and Ron; I knew there was something wrong with that comment, but decided to ckeck it out with the list just in case :) thanks for your time! Saludos, Veronica Levin Enriquez Compañía Cervecera de Nicaragua -Mensaje original- De: Ron Yount [mailto:[EMAIL PROTECTED]] Enviado el: Friday, November 29, 2002 6:54 PM Para: Multiple recipients of list ORACLE-L Asunto: RE: Import Table from Full Backup Veronica, Ah, rumors are a wonderful thing, especially if they turn out to be true in our favor. :-) Not unless it happens to be the only segment in a given tablespace. A tablespace is as granular as an RMAN restore/backup can be set. Even then, if you were to restore the tablespace to a previous point in time, the database would not be happy since it would be different than the control file scn. HTH, -Ron- -Original Message- Levin Sent: Friday, November 29, 2002 4:39 PM To: Multiple recipients of list ORACLE-L Hi Listers, Is it true that I can do an import of a table from a full backup that was done with RMAN? That was a comment I heard today and doesn't make sense to me, any comments? Saludos, Veronica Levin Enriquez Compañía Cervecera de Nicaragua -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Veronica Levin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Yount INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Veronica Levin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
process memory utilization
Hi,dba friends: I am thinking of measure how much memory per connection used, from the os viewpoint and oracle viewpoint. And this is my result from my production server, and i have some questions below. 23:56:28 SQL select sum(value),sum(value)/count(distinct sid) average from v$sesstat where statistic#=15; --uga SUM(VALUE) AVERAGE 69,098,528 145,777 23:58:09 SQLselect sum(value),sum(value)/count(distinct sid),max(value) from v$sesstat where statistic#=20 --pga SUM(VALUE) SUM(VALUE)/COUNT(DISTINCTSID) MAX(VALUE) - 265,290,648559,684.9117,510,184 There is about my production server(oracle817+solaris7), and I also used pmap to trace some process and it look like: oracle@main-db1$pmap 11443 #some process id i which is choosed randomly via /usr/ucb/ps -aux. 11443: oraclebiddb (LOCAL=NO) 0001 29440K read/exec /export/home/oracle/app/product/8.1.7/bin/oracle 000101DBE000464K read/write/exec /export/home/oracle/app/product/8.1.7/bin/oracle 000101E32000 1440K read/write/exec [ heap ] 00038000 5685720K read/write/exec/shared [ shmid=0x65 ] 7D80 16K read/exec /usr/lib/sparcv9/libmp.so.2 7D902000 8K read/write/exec /usr/lib/sparcv9/libmp.so.2 7DA0 88K read/exec /usr/lib/sparcv9/libm.so.1 7DB14000 16K read/write/exec /usr/lib/sparcv9/libm.so.1 7DC0 8K read/exec /usr/lib/sparcv9/libkstat.so.1 7DD0 8K read/write/exec /usr/lib/sparcv9/libkstat.so.1 7DE0 32K read/exec /usr/lib/sparcv9/librt.so.1 7DF06000 8K read/write/exec /usr/lib/sparcv9/librt.so.1 7E00 24K read/exec /usr/lib/sparcv9/libaio.so.1 7E104000 16K read/write/exec /usr/lib/sparcv9/libaio.so.1 7E20704K read/exec /usr/lib/sparcv9/libc.so.1 7E3AE000 64K read/write/exec /usr/lib/sparcv9/libc.so.1 7E3BE000 8K read/write/exec [ anon ] 7E40 8K read/exec /usr/lib/sparcv9/libsched.so.1 7E50 8K read/write/exec /usr/lib/sparcv9/libsched.so.1 7E60 32K read/exec /usr/lib/sparcv9/libgen.so.1 7E706000 8K read/write/exec /usr/lib/sparcv9/libgen.so.1 7E80 40K read/exec /usr/lib/sparcv9/libsocket.so.1 7E908000 16K read/write/exec /usr/lib/sparcv9/libsocket.so.1 7EA0624K read/exec /usr/lib/sparcv9/libnsl.so.1 7EB9A000 64K read/write/exec /usr/lib/sparcv9/libnsl.so.1 7EBAA000 32K read/write/exec [ anon ] 7EC0 3896K read/exec /export/home/oracle/app/product/8.1.7/lib/libjox8.so 7F0CC000192K read/write/exec /export/home/oracle/app/product/8.1.7/lib/libjox8.so 7F0FC000 8K read/write/exec [ anon ] 7F30 40K read/exec /export/home/oracle/app/product/8.1.7/lib64/libdsbtsh8.so 7F408000 8K read/write/exec /export/home/oracle/app/product/8.1.7/lib64/libdsbtsh8.so 7F40A000 8K read/write/exec [ anon ] 7F50 8K read/exec /export/home/oracle/app/product/8.1.7/lib64/libskgxp8.so 7F60 8K read/write/exec /export/home/oracle/app/product/8.1.7/lib64/libskgxp8.so 7F68128K read/exec /usr/lib/sparcv9/ld.so.1 7F79 16K read/exec /usr/platform/sun4u/lib/sparcv9/libc_psr.so.1 7F79E000 8K read/write/exec /usr/lib/sparcv9/ld.so.1 7F7A 8K read/write/exec [ anon ] 7F7B 8K read/write/exec [ anon ] 7F7C 8K read/write/exec [ anon ] 7F7D 8K read/write/exec/shared [ anon ] 7F7E 8K read/write/exec [ anon ] 7F7F 8K read/exec /usr/lib/sparcv9/libdl.so.1 7FFEE000 72K read/write [ stack ] total 5723336K and i compared it with oracle statistics: 00:11:59 SQL @whoisit 00:12:02 SQL col machine format a30 00:12:02 SQL col program format a40 00:12:02 SQL set line 200 00:12:02 SQL select sid,serial# ,username,osuser,machine,program,process,to_char(logon_time,'/mm/dd hh24:mi:ss') 00:12:02 2 from v$session where paddr in( 00:12:02 3 select addr from v$process where spid in(spid)); Enter value for spid: 11443 old 3: select addr from v$process where spid in(spid)) new 3: select addr from v$process where spid in(11443)) SIDSERIAL# USERNAME OSUSER MACHINEPROGRAM PROCESS TO_CHAR(LOGON_TIME, -- -- -- --
RE: Oracle 9iR2 on Red Hat 8.0
Thanks, RH 8.0 it is. Gogala, Mladen [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/02/2002 07:29 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle 9iR2 on Red Hat 8.0 I installed oracle 9.2 on RH 8.0 and there weren't any major issues. The only problem was that RH 8.0 comes WITHOUT XMMS I had to download XMMS myself and to manually relink all my plug-ins (alarm, gtk_list, normalization, 3D sound and some others). I also had to manually recompile lame and cdparanoia and download grip rpm from rpmfind.net. RH rendered my 2000+ MP3 files that, of course, I have only for testing purposes, completely useless without a large effort on my part. This was completely outrageous! -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 12:44 AM To: Multiple recipients of list ORACLE-L Subject: Oracle 9iR2 on Red Hat 8.0 If you've installed Oracle 9i on RH 8.0, please let me know. Also, please let me know of any difficulties and workarounds you may have encountered. Just put a new 40Gig HD in my laptop, and wondering if I can install RH 8.0, or should use 7.2. Thanks Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9iR2 on Red Hat 8.0
Thanks. RH 8.0 is much nicer than 7.2 Lyndon Tiu [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/02/2002 08:14 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle 9iR2 on Red Hat 8.0 Oracle 92i runs fine on all recent Linux distros. I've tested it on Mandrake 9.0 and all's well. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-1653: unable to extend table - Why?
I was told by the department manager that they were neither using a direct load nor the Append hint. But the developer is back from vacation today so I'll get a more definite answer from him. Thanks, Jay Miller -Original Message- Sent: Friday, November 29, 2002 2:05 PM To: Multiple recipients of list ORACLE-L How are the inserts being done? Are you doing an insert with append hint? -Original Message- Sent: Friday, November 29, 2002 12:59 PM To: Multiple recipients of list ORACLE-L Okay, I can't figure this one out. Earlier this week I got an ORA-1653: unable to extend table on a really big table. However this was just after I had deleted over 2 million rows in the table and we were only inserting 30,000. After reanalyzing the table I saw the following stats in DBA_TABLES: num_freelist_blocks: 2266966 avg_space_freelist_blocks: 3895 Unless I'm misreading this I should have had over 8Gig available for inserts. We tried the insert again and got the same error so I added a datafile and it went through (using about 40Meg of space in the new datafile). Why isn't it making use of the existing blocks on the freelist? Oracle 8.1.7.2 Solaris 2.6 PCTFREE = 10 PCTUSED = 75 Block Size = 4K Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle on windows and shadow thread file access
On UNIX, when a user process needs to access data, it will open the files of interest. The background processes 'attach' to all of the files when the OPEN state of the database is achieved. They do not open each file when they need to read/write. For example, CKPT attaches to the files and will maintain the handle as long as the process is running. Why do I know this, you ask? One afternoon, a support tech moved a datafile since the device was 95% full. User queries would fail when trying to open the file, but checkpoints were succeeding and we could even dump the file headers without any problem. After discussing this situation with the SAs, we postulated that the background processes were keeping the files open and thus were still attached to the files original location. If we shutdown the background processes, the files would have been closed and the original blocks released. Once we resolved the issue, the support techs were scheduled for Oracle 101 training immediately! On Windows, they handle files slightly differently and I am not sure. -Original Message- Sent: Friday, November 29, 2002 3:34 PM To: Multiple recipients of list ORACLE-L On Friday 29 November 2002 08:43, Jeff Herrick wrote: My understanding from the question was that he was wondering whether each user's process in a dedicated-server configuration opened all of the datafiles too Maybe not all of the data files, but the users dedicated server process will open datafiles as needed to read data into the block buffer. Now I don't know if I've helped any, or just added to the confusion. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Apps 11i on Red Hat 8.0
Anyone care to share any experiences installing Apps 11i release 7 on RH 8.0? I'm about to give it a go in the next couple of days - and would appreciate hearing about your experiences. I note that SUSE 7.1 seems to be the only officially certified distro. H. Oracle Trivia Question: If you order the Oracle Apps 11i Release 7 suite from Oracle how many CD's do you get? Answer: 54 (yes thats right, fifty four CD's) - the mind boggles. No wonder they don't let you download the thing :-) Regards Dale Edgar Net 2000 Ltd. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Help with Query
Title: Message Hi list I need some help with a query. I have 3 tables ORIGINALES, CAMBIOS_ORIGINALES, DATOS_FABRICANTES, I have to be able to query an article for whatever code the user provide, ex: (NUMERO_ORIGINAL, CAMBIO_ORIGINAL, NUMERO_FABRICANTE). The 3 tables have a common column, NUMERO_ORIGINAL. When he type a code, no matter which one, I have to display the NUMERO_ORIGINAL, CAMBIO_ORIGINAL(s), NUMERO_FABRICANTE(s) and the DESCRIPTION of the article. I merged the 3 codes in the CODIGO_ARTICULO column to make the join for that column, but I can't get the DESCRIPTION of the article. Any help would be appreciated, SQL DESC ORIGINALESName ---GRUPO COMPANIA NUMERO_ORIGINAL NRO_DESCRIPCION SQL DESC CAMBIOS_ORIGINALESName GRUPO COMPANIA NUMERO_ORIGINAL CAMBIO_ORIGINAL SERIE SQL DESC DATOS_FABRICANTESName ---GRUPO COMPANIA NUMERO_ORIGINAL NUMERO_FABRICANTE LOCALIDAD *** This is what I came up with CREATE OR REPLACE VIEW V_ARTICULOS AS SELECTO.NUMERO_ORIGINAL CODIGO_ARTICULO, O.NUMERO_ORIGINAL, D.DESCRIPCION, ' ' CAMBIO_ORIGINAL, ' ' NUMERO_FABRICANTE FROM ORIGINALES O, DESCRIPCIONES D WHERE D.NRO_DESCRIPCION = O.NRO_DESCRIPCIONUNIONSELECTC.CAMBIO_ORIGINAL CODIGO_ARTICULO, ' ', ' ', C.CAMBIO_ORIGINAL, ' ' NUMERO_FABRICANTE FROM CAMBIOS_ORIGINALES CUNIONSELECTD.NUMERO_FABRICANTE CODIGO_ARTICULO, ' ', ' ', ' ', D.NUMERO_FABRICANTE FROM DATOS_FABRICANTES D / CODIGO_ARTICULO NUMERO_ORIGINAL DESCRIPCION CAMBIO_ORIGINAL NUMERO_FABRICANTE -- 1 1 DESCRIPCION UNO101-122519C1020 12251-PC1-020 101-122519C1020101-12251PC1000 12251-PC1-020 101-12251PC100010A 10A DESCRIPCION UNO10 10A 1010ABC 10A 10ABC12251-PC1-020 12251-PC1-020 JUNTA DE CULATA12345 12345 DESCRIPCION UNO12345A 12345 12345A12345AA 12345 12345AA1414-TT-1414-BR 3 1414-TT-1414-BR147 147 DESCRIPCION UNO Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121
Partition Info
Hello everybody. I have a number of tables with range by date partitions. I need to write a script to monitor the latest partitions and send me an e-mail if it's close to a current date. I am just looking for tables or views that will help me find out the date of the last partition. Sergei. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sergei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle on windows and shadow thread file access
I guess it has to do with the fact that Oracle on Windows is a single process multithreads. So any opened file in the main thread will be accessible and opened for the spawned threads (correct me if I'm wrong). So concurrent access to the files would need to be controlled by O/S resources like mutex. It would be helpful if some one with multithread programming experience in Windows could shed some light here. Regards, Waleed -Original Message- Sent: Monday, December 02, 2002 2:49 PM To: Multiple recipients of list ORACLE-L On UNIX, when a user process needs to access data, it will open the files of interest. The background processes 'attach' to all of the files when the OPEN state of the database is achieved. They do not open each file when they need to read/write. For example, CKPT attaches to the files and will maintain the handle as long as the process is running. Why do I know this, you ask? One afternoon, a support tech moved a datafile since the device was 95% full. User queries would fail when trying to open the file, but checkpoints were succeeding and we could even dump the file headers without any problem. After discussing this situation with the SAs, we postulated that the background processes were keeping the files open and thus were still attached to the files original location. If we shutdown the background processes, the files would have been closed and the original blocks released. Once we resolved the issue, the support techs were scheduled for Oracle 101 training immediately! On Windows, they handle files slightly differently and I am not sure. -Original Message- Sent: Friday, November 29, 2002 3:34 PM To: Multiple recipients of list ORACLE-L On Friday 29 November 2002 08:43, Jeff Herrick wrote: My understanding from the question was that he was wondering whether each user's process in a dedicated-server configuration opened all of the datafiles too Maybe not all of the data files, but the users dedicated server process will open datafiles as needed to read data into the block buffer. Now I don't know if I've helped any, or just added to the confusion. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-1653: unable to extend table - Why?
Okay, I just heard back from the developer. It was definitely not using either a Direct load or and Append hint. Just a regular insert. Any more ideas? -Original Message- Sent: Friday, November 29, 2002 1:39 PM To: Multiple recipients of list ORACLE-L Did you insert using direct path ? If so the insert inserts after the highwater mark. The highwater mark is not reinitialized after deletes. So maybe that's why the insert failed. --- Miller, Jay [EMAIL PROTECTED] a écrit : Okay, I can't figure this one out. Earlier this week I got an ORA-1653: unable to extend table on a really big table. However this was just after I had deleted over 2 million rows in the table and we were only inserting 30,000. After reanalyzing the table I saw the following stats in DBA_TABLES: num_freelist_blocks: 2266966 avg_space_freelist_blocks: 3895 Unless I'm misreading this I should have had over 8Gig available for inserts. We tried the insert again and got the same error so I added a datafile and it went through (using about 40Meg of space in the new datafile). Why isn't it making use of the existing blocks on the freelist? Oracle 8.1.7.2 Solaris 2.6 PCTFREE = 10 PCTUSED = 75 Block Size = 4K Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Stephane=20Paquette?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Database up longer that host?
I use a script named db_uptime.sql (I think I got it from the list here) to calculate how long the database has been up. The output compares nicely to the unix uptime command. We had some maintenance last Wed night that bounced the host (Tru64 5.1a cluster) and naturally the database as well. But when I looked at the host uptime compared to the db_uptime.sql, it looks like the database has been up longer than the host. The db is 8.1.7.3. The host is a Tru64 Compaq (er HP) GS160 AlphaWildfire machine. We are in a cluster, but the databases are all still running on one node. 1* select STARTUP_TIME from v$instance SQL / 27-NOV-2002 18:30:12 SQL @db_uptime Database Uptime Host Name : dgrdb01.firsthealth.com Instance Name : CLAIM Uptime : 4days 21hours 53minutes SQL !uptime 15:40 up 4 days, 14:52, 7 users, load average: 4.13, 6.93, 7.08 SQL select sysdate from dual; SYSDATE 02-DEC-2002 15:40:39 SQL Is there something wrong with the script or just a misalignment in the starts? Stephen Andert (confused in AZ) -- db_uptime.sql select 'Host Name : '||host_name||chr(10)|| 'Instance Name : '||instance_name||chr(10)|| 'Uptime : ' ||floor(xx)||'days ' ||floor((xx-floor(xx))*24)||'hours ' ||round(((xx-floor(xx)*24)-floor((xx-floor(xx)*24)))*60) ||'minutes' Database Uptime from ( select host_name,instance_name ,(sysdate-STARTUP_TIME) xx from v$instance ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Partition Info
Sergei Check HIGH_VALUE column in DBA_TAB_PARTITIONS and compare it to current date. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 02, 2002 3:48 PM Hello everybody. I have a number of tables with range by date partitions. I need to write a script to monitor the latest partitions and send me an e-mail if it's close to a current date. I am just looking for tables or views that will help me find out the date of the last partition. Sergei. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sergei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
9i database create script - My, how things have changed
Title: 9i database create script - My, how things have changed ...since 8.1.7. I've always ran the database creation utility, then swiped the scripts outta the admin\[sid]\create\ directory, scrubbed 'em a bit, and let er rip. My consultants create/install new db's quite frequently, and the 8.1.7 *.bat's work quite well for 'em. However, as I'm sure you've all figgered out already, this don't work no mo. I've taken some cursory rambles thru orafaq, but came out more confused than I came in. I don't want to rely on installing perl or Oracle DCA on each machine, as the consultants I'm supporting aren't going to be too keen on having to go from their current hit the .bat and wait til it says all done MO. So, I'm sure a solution or twenty has been put together for NT/Windows. Care to share? I'm sure I could re-invent this particular wheel, but my boss keeps hollering at me for stuff that I'm actually supposed to produce, so If'n I can turn this one around in a reasonable time, I'd be much abliged.
RE: Partition Info
DBA_TAB_PARTITIONS -Original Message- Sent: Monday, December 02, 2002 3:49 PM To: Multiple recipients of list ORACLE-L Hello everybody. I have a number of tables with range by date partitions. I need to write a script to monitor the latest partitions and send me an e-mail if it's close to a current date. I am just looking for tables or views that will help me find out the date of the last partition. Sergei. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sergei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-1653: unable to extend table - Why?
Yep, I agree that coalescing is irrelevant in my current situation. In any event there was no free space until I added the additional datafile but there was the 8gig of space on the freelists. Jay -Original Message- Sent: Friday, November 29, 2002 8:54 PM To: Multiple recipients of list ORACLE-L Richard, if pctincrease is zero, and there are a large number of contiguous smaller extents, SMON will not automatically coalesce the tablespace. However, whether or not SMON does an automatic coalesce, if you need an extent that is larger than any of the small ones, Oracle will coalesce those smaller extents to make the one you need. so Jay would not have needed to add a datafile no matter what, if he was not doing a direct path insert. As for meeting in person there is a user group meeting on Dec 12 (check www.nyoug.org for details). You can meet me, and more importantly you can meet Tim Gorman, Dan Fink, Arup Nanda and Anita Bardeen, also of this list. They are all presenting :) I saw Priscilla about a month ago, haven't talked with her since. Rachel --- Richard Ji [EMAIL PROTECTED] wrote: Rachel, What I mean to say is when there are a lot of contiguous smaller free extents. Then coalesce will produce a larger free extent so Jay wouldn't have to add a datafile for his table to grow. On the automatically coalescing part, I believe SMON will only coalesce when pctincrease != 0, or has that changed? My understand could be outdated. With LMT one doesn't have to worry about it. Have a Happy Thanksgiving. PS, I am in New York too, would love to meet you in person some time. Have you talked to Priscilla lately? Richard Ji -Original Message- Sent: Friday, November 29, 2002 5:29 PM To: Multiple recipients of list ORACLE-L how would coalescing help even if there were a lot of smaller free extents? Oracle would do the coalesce automatically, there would be no difference between manually coalescing or allowing Oracle to do it when a new extent was needed. --- Richard Ji [EMAIL PROTECTED] wrote: Coalescing might help if there are many smaller free extents that can be coalesced. But that still doesn't solve Jay's problem. Because he doesn't want the table to extent at all since he just deleted 2 million rows so there are plenty of space within the segment itself. Those free blocks should be used, unless he is doing a direct path insert which will only use space above the HWM. Richard Ji -Original Message- Sent: Friday, November 29, 2002 2:05 PM To: Multiple recipients of list ORACLE-L did u coalesced the tablespaces? -Original Message- Sent: sexta-feira, 29 de Novembro de 2002 17:59 To: Multiple recipients of list ORACLE-L Okay, I can't figure this one out. Earlier this week I got an ORA-1653: unable to extend table on a really big table. However this was just after I had deleted over 2 million rows in the table and we were only inserting 30,000. After reanalyzing the table I saw the following stats in DBA_TABLES: num_freelist_blocks: 2266966 avg_space_freelist_blocks: 3895 Unless I'm misreading this I should have had over 8Gig available for inserts. We tried the insert again and got the same error so I added a datafile and it went through (using about 40Meg of space in the new datafile). Why isn't it making use of the existing blocks on the freelist? Oracle 8.1.7.2 Solaris 2.6 PCTFREE = 10 PCTUSED = 75 Block Size = 4K Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paulo Gomes INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official
Error SP2-0642 when Killing Session?
Hi All, A tester has come across a problem testing an SQL script. The script contains an anonymous block which loops through a cursor, writing lines to an output file (using UTL_FILE.PUT_LINE) and deleting rows from a table. The tester is attempting to test failure of the script midway through execution. To do this they are using alter system kill session 'xx, yy';. Unfortunately when they do this they receive the following error hundreds of times... ... SP2-0642: SQL*Plus internal error state 2167, context 4294967294:2:0 Unable to proceed SP2-0642: SQL*Plus internal error state 2167, context 4294967294:2:0 Unable to proceed SP2-0642: SQL*Plus internal error state 2167, context 4294967294:2:0 Unable to proceed SP2-0642: SQL*Plus internal error state 2167, context 4294967294:2:0 Unable to proceed Segmentation Fault(coredump) Any ideas what might be causing this problem? Any other suggestions for making the script fail midway through execution that might avoid this bug? Also, since the script uses dbms_output.put_line to log some progress messages, can they still expect these to appear after the session is killed? Thanks in advance, Mark. PS: Oracle is 8.1.7.4.0 (EE) on Solaris, script is being executed via SQL*Plus 8.1.7.0.0 on Solaris also. Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle on windows and shadow thread file access
Title: RE: Oracle on windows and shadow thread file access I recently downloaded program which is like 'truss' but works in windows environment ... called strace ... from sysinternals.com it shows all files it accesses and all sys calls it makes. Not exactly what you need ... but close by I guess .. they also have a bunch of utilities one that might interest you is filemon. www.sysinternals.com is a good site ... I found it few years ago and I regularly visit them to find neat tools. 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! *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.*1
Re: 9i database create script - My, how things have changed
Would you be interested a set of KSH scripts that generate the SQL scripts to create a database? These are for 8i. I've started to modify for 9i differences, but haven't gotten too far. Not too much work to modify them. Lemme know, Jared Jeremy Pulcifer [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/02/2002 12:53 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:9i database create script - My, how things have changed ...since 8.1.7. I've always ran the database creation utility, then swiped the scripts outta the admin\[sid]\create\ directory, scrubbed 'em a bit, and let er rip. My consultants create/install new db's quite frequently, and the 8.1.7 *.bat's work quite well for 'em. However, as I'm sure you've all figgered out already, this don't work no mo. I've taken some cursory rambles thru orafaq, but came out more confused than I came in. I don't want to rely on installing perl or Oracle DCA on each machine, as the consultants I'm supporting aren't going to be too keen on having to go from their current hit the .bat and wait til it says all done MO. So, I'm sure a solution or twenty has been put together for NT/Windows. Care to share? I'm sure I could re-invent this particular wheel, but my boss keeps hollering at me for stuff that I'm actually supposed to produce, so If'n I can turn this one around in a reasonable time, I'd be much abliged. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Database up longer that host?
Stephen Andert wrote: I use a script named db_uptime.sql (I think I got it from the list here) to calculate how long the database has been up. The output compares nicely to the unix uptime command. We had some maintenance last Wed night that bounced the host (Tru64 5.1a cluster) and naturally the database as well. But when I looked at the host uptime compared to the db_uptime.sql, it looks like the database has been up longer than the host. The db is 8.1.7.3. The host is a Tru64 Compaq (er HP) GS160 AlphaWildfire machine. We are in a cluster, but the databases are all still running on one node. 1* select STARTUP_TIME from v$instance SQL / 27-NOV-2002 18:30:12 SQL @db_uptime Database Uptime Host Name : dgrdb01.firsthealth.com Instance Name : CLAIM Uptime : 4days 21hours 53minutes SQL !uptime 15:40 up 4 days, 14:52, 7 users, load average: 4.13, 6.93, 7.08 SQL select sysdate from dual; SYSDATE 02-DEC-2002 15:40:39 SQL Is there something wrong with the script or just a misalignment in the starts? Stephen Andert (confused in AZ) -- db_uptime.sql select 'Host Name : '||host_name||chr(10)|| 'Instance Name : '||instance_name||chr(10)|| 'Uptime : ' ||floor(xx)||'days ' ||floor((xx-floor(xx))*24)||'hours ' ||round(((xx-floor(xx)*24)-floor((xx-floor(xx)*24)))*60) ||'minutes' Database Uptime from ( select host_name,instance_name ,(sysdate-STARTUP_TIME) xx from v$instance ) Stephen, I hope that the query doesn't come from the list, because it is wrong. The error is to apply floor() before multiplying by 24 or 60 - you have tremendous rounding errors. My own database has not been up long enough to be 100% sure about it but I believe the following to be correct : select 'Host Name : '||host_name||chr(10)|| 'Instance Name : '||instance_name||chr(10)|| 'Uptime : ' ||floor(xx)||'days ' ||floor(xx * 24 - floor(xx * 24))||'hours ' ||round((xx * 86400)/60) ||'minutes' Database Uptime from ( select host_name,instance_name ,(sysdate-STARTUP_TIME) xx from v$instance ) / -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SLA Trigger/Procedure
Just a thought here for a script I think would be handy but I haven't had time to write. It is would be a simple procedure you could call to get the service level for a particular database. I suppose you would have to have some sort of way of defining normal outage windows. Basically a startup trigger would log the times in a table. You should also check the startup time against the last startup time periodically to ensure the trigger always fires. Somehow a procedure/function should be able to use this information to report the service level for the database within the last (week/month/quarter/year). I suppose I will get around to it eventually but if anyone else wants to get started on it I won't mind! Thanks, Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Help with Query
Ramon E. Estevez wrote: Hi list I need some help with a query. I have 3 tables ORIGINALES, CAMBIOS_ORIGINALES, DATOS_FABRICANTES, I have to be able to query an article for whatever code the user provide, ex: (NUMERO_ORIGINAL, CAMBIO_ORIGINAL, NUMERO_FABRICANTE). The 3 tables have a common column, NUMERO_ORIGINAL. When he type a code, no matter which one, I have to display the NUMERO_ORIGINAL, CAMBIO_ORIGINAL(s), NUMERO_FABRICANTE(s) and the DESCRIPTION of the article. I merged the 3 codes in the CODIGO_ARTICULO column to make the join for that column, but I can't get the DESCRIPTION of the article. Any help would be appreciated, Ramon, Your mistake is not to join (on NUMERO_ORIGINAL) with ORIGINALES in the second and third SELECTs of your union - which by the way would be better defined as UNION ALL to avoid a sort. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-1653: unable to extend table - Why?
One thing I haven't seen mentioned yet is what degree of parallelism is defined for the table? What is the next extent size set to? If the table is paralleled, EACH parallel worker will grab a next extent sized segment. (Been bit by this a few times...) How many indexes and are they in the same tablespace? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan JayMiller@TDWater house.comTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: ORA-1653: unable to extend table - Why? 12/02/2002 02:04 PM Please respond to ORACLE-L Yep, I agree that coalescing is irrelevant in my current situation. In any event there was no free space until I added the additional datafile but there was the 8gig of space on the freelists. Jay -Original Message- Sent: Friday, November 29, 2002 8:54 PM To: Multiple recipients of list ORACLE-L Richard, if pctincrease is zero, and there are a large number of contiguous smaller extents, SMON will not automatically coalesce the tablespace. However, whether or not SMON does an automatic coalesce, if you need an extent that is larger than any of the small ones, Oracle will coalesce those smaller extents to make the one you need. so Jay would not have needed to add a datafile no matter what, if he was not doing a direct path insert. As for meeting in person there is a user group meeting on Dec 12 (check www.nyoug.org for details). You can meet me, and more importantly you can meet Tim Gorman, Dan Fink, Arup Nanda and Anita Bardeen, also of this list. They are all presenting :) I saw Priscilla about a month ago, haven't talked with her since. Rachel --- Richard Ji [EMAIL PROTECTED] wrote: Rachel, What I mean to say is when there are a lot of contiguous smaller free extents. Then coalesce will produce a larger free extent so Jay wouldn't have to add a datafile for his table to grow. On the automatically coalescing part, I believe SMON will only coalesce when pctincrease != 0, or has that changed? My understand could be outdated. With LMT one doesn't have to worry about it. Have a Happy Thanksgiving. PS, I am in New York too, would love to meet you in person some time. Have you talked to Priscilla lately? Richard Ji -Original Message- Sent: Friday, November 29, 2002 5:29 PM To: Multiple recipients of list ORACLE-L how would coalescing help even if there were a lot of smaller free extents? Oracle would do the coalesce automatically, there would be no difference between manually coalescing or allowing Oracle to do it when a new extent was needed. --- Richard Ji [EMAIL PROTECTED] wrote: Coalescing might help if there are many smaller free extents that can be coalesced. But that still doesn't solve Jay's problem. Because he doesn't want the table to extent at all since he just deleted 2 million rows so there are plenty of space within the segment itself. Those free blocks should be used, unless he is doing a direct path insert which will only use space above the HWM. Richard Ji -Original Message- Sent: Friday, November 29, 2002 2:05 PM To: Multiple recipients of list
RE: ORA-1653: unable to extend table - Why?
My experience yesterday was that dropping an index and trying to rebuild the same index failed ( even after coalescing the tablespace) since we need to wait for SMON to clean up the extents to make them available. I don't know how we make SMON process to coalesce the free space faster enough( or immediately after we delete from the table or dropping an index ). Any ideas? -Original Message- Sent: Monday, December 02, 2002 3:49 PM To: Multiple recipients of list ORACLE-L Okay, I just heard back from the developer. It was definitely not using either a Direct load or and Append hint. Just a regular insert. Any more ideas? -Original Message- Sent: Friday, November 29, 2002 1:39 PM To: Multiple recipients of list ORACLE-L Did you insert using direct path ? If so the insert inserts after the highwater mark. The highwater mark is not reinitialized after deletes. So maybe that's why the insert failed. --- Miller, Jay [EMAIL PROTECTED] a écrit : Okay, I can't figure this one out. Earlier this week I got an ORA-1653: unable to extend table on a really big table. However this was just after I had deleted over 2 million rows in the table and we were only inserting 30,000. After reanalyzing the table I saw the following stats in DBA_TABLES: num_freelist_blocks: 2266966 avg_space_freelist_blocks: 3895 Unless I'm misreading this I should have had over 8Gig available for inserts. We tried the insert again and got the same error so I added a datafile and it went through (using about 40Meg of space in the new datafile). Why isn't it making use of the existing blocks on the freelist? Oracle 8.1.7.2 Solaris 2.6 PCTFREE = 10 PCTUSED = 75 Block Size = 4K Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Stephane=20Paquette?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Partition Info : thank you
Got it -Original Message- Neyman Sent: Monday, December 02, 2002 1:45 PM To: Multiple recipients of list ORACLE-L Sergei Check HIGH_VALUE column in DBA_TAB_PARTITIONS and compare it to current date. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 02, 2002 3:48 PM Hello everybody. I have a number of tables with range by date partitions. I need to write a script to monitor the latest partitions and send me an e-mail if it's close to a current date. I am just looking for tables or views that will help me find out the date of the last partition. Sergei. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sergei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sergei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SLA Trigger/Procedure
Ethan, That records the startup times, but does not record the time that the database was unavailable. What's needed is a 3rd party monitor that is not dependent on the database being up to record metrics. Jared Post, Ethan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/02/2002 02:33 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:SLA Trigger/Procedure Just a thought here for a script I think would be handy but I haven't had time to write. It is would be a simple procedure you could call to get the service level for a particular database. I suppose you would have to have some sort of way of defining normal outage windows. Basically a startup trigger would log the times in a table. You should also check the startup time against the last startup time periodically to ensure the trigger always fires. Somehow a procedure/function should be able to use this information to report the service level for the database within the last (week/month/quarter/year). I suppose I will get around to it eventually but if anyone else wants to get started on it I won't mind! Thanks, Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Database up longer that host?
On Mon, 2 Dec 2002, Stephane Faroult wrote: Stephen Andert wrote: I use a script named db_uptime.sql (I think I got it from the list here) to calculate how long the database has been up. The output compares nicely to the unix uptime command. I hope that the query doesn't come from the list, because it is wrong. The error is to apply floor() before multiplying by 24 or 60 - you have tremendous rounding errors. My own database has not been up long enough to be 100% sure about it but I believe the following to be correct : Hi: Neither of the scripts works for me. Try this? select 'Host Name : '||host_name|| chr(10)|| 'Instance Name : '||instance_name|| chr(10)|| 'Uptime : ' ||floor(xx)||'days ' || floor( 24 * (xx - floor(xx)) ) || 'hours ' || round( 60 * (24 * xx - floor(24 * xx))) || 'minutes ' from ( select host_name,instance_name ,(sysdate-STARTUP_TIME) xx from v$instance ) / Meg Crocker -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Meg Crocker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Advisory: Lawson Financials RDBMS Insecurity
This may be of interest to some. I believe there are a number of folks on the list with Lawson systems. jared - Forwarded by Jared Still/Radisys_Corporation/US on 12/02/2002 05:42 PM - John Eisenschmidt [EMAIL PROTECTED] 12/02/2002 08:28 AM To: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] cc: Subject:Advisory: Lawson Financials RDBMS Insecurity +---+ | Advisory: lawson001| |Author(s): John Eisenschmidt [EMAIL PROTECTED] | | George Lewis [EMAIL PROTECTED] | | Release Date: December 02, 2002| | Vendor: Lawson | | Application: Financials (possibly others) | |Affected Versions: 8.x Environment | | Affected Platforms: Solaris (possibly others)| | Affected Databases: Oracle (possibly others) | +---+ Summary --- Lawson Financials does not adequately secure data held in third-party relational databases. Background -- Lawson Software was founded in 1975 by Richard Lawson to develop turn-key accounting and business systems. Depending on the platform, Financials was originally written in either RPG or COBOL. All data was stored in a proprietary flat file database called LADB. The Lawson Applications (including Financials) run in an abstraction layer called the environment. The purpose of the environment is to present information in a uniform manner regardless of the host operating system. The current 8.0 environment supports the following operating systems: -AIX -Digital Unix/Tru64 -HP-UX -Sun Solaris -Windows NT/2000 Several years ago, the environment was retrofitted to integrate with popular third-party relational database. These include: -IBM DB2/UDB -Informix -Microsoft SQL Server -Oracle -Sybase As of the release of the 8.0 environment, Lawson only supports the use of a third-party relational database for production systems. For the sake of brevity, this paper will only make specific reference to a Lawson 8.0 environment installation on Sun Solaris with Oracle as the repository. It is likely, however, that the issues raised here will more than likely pose the same risks to other Unix variants and Windows. Detailed Description There are three standard ways to configure Lawson to work with a third-party RDBMS: 1) Oracle database authentication 2) Operating system authentication with a single Lawson user name 3) Operating system authentication with multiple Lawson user names Setup #1 employs a single username and password for all transactions within the database. This username and password are stored in a world-readable text file called the capital database file: bash-2.03$ ls -l [A-Z]* -rw-rw-rw- 1 lawson lawson 106 Jun 11 12:10 IBM -rw-rw-rw- 1 lawson lawson 123 Jun 11 12:10 INFORMIX -rw-rw-rw- 1 lawson lawson 272 Jun 13 08:40 ORACLE -rw-rw-rw- 1 lawson lawson 124 Jun 11 12:10 SYBASE As you can see, the default permission is 666 (world readable), and ownership defaults to group lawson. All users of Financials must be a primary member of group lawson, which means any user with shell access can see the contents of this file. Shell access is required for using the Lawson.Insight Desktop (LID) interface. Please note: the default permissions on this file can be changed to 400, and ownership of the file given to root, however this is not suggested anywhere in the install documents, nor is it mentioned by the Lawson certified installer required to certify your installation. Once an unprivileged user obtains this password, they can easily establish a connection to the database through a connector like ODBC or JDBC. Since the lawson user is the database owner, these credentials make it possible to read, alter, or destroy the database. Setup #1 tends to be the preferred configuration method by Lawson installers, despite the fact that the Lawson Oracle Setup and Tools Guide (version 8.0.2, published May 2002) reflects that this is not a good method to use (page 41). NOTE: The text is not reproduced here due to Lawson's copyright. Setup #2 requires that Oracle is setup to use the operating systems' authentication mechanism. This method utilizes a single account, which still reflects the lack of database auditing and logging as mentioned above. This method is more secure than the previous #1 because the password to the single account is not available in the world-readable text file. If this single password is compromised, the system remains
RE: Partition Info
You may use the following query will identify the 'highest' partition by date range. select partition_name, partition_position , high_value, tablespace_name from dba_tab_partitions where table_name = 'table_name' and table_owner = 'owner' and partition_position = ( select max(partition_position) from dba_tab_partitions where table_name = 'table_name' and table_owner = 'owner' ) You can store the high_value in another table and start manipulating the way you want such as: select max(add_months( to_date( substr(high_value,3,19), 'S-MM-DD HH24:MI:SS' ), 1 )) into new_high_value from temp_table I don't know how we can directly manipulate HIGH_VALUE column in dba_tab_partitions. But I have tried the above in a PL/SQL program and it worked. Hope this helps. -Original Message- Sent: Monday, December 02, 2002 4:39 PM To: Multiple recipients of list ORACLE-L DBA_TAB_PARTITIONS -Original Message- Sent: Monday, December 02, 2002 3:49 PM To: Multiple recipients of list ORACLE-L Hello everybody. I have a number of tables with range by date partitions. I need to write a script to monitor the latest partitions and send me an e-mail if it's close to a current date. I am just looking for tables or views that will help me find out the date of the last partition. Sergei. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sergei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SLA Trigger/Procedure
Perhaps there is a poor mans way of doing this. The startup trigger could fire a procedure that inserts a row into a table and then sleeps for 1 minute before doing the same again. Effectively it would create a ping in the table, which you could then analyze / graph to display uptimes. The next logical step would be to increase the intelligence of the procedure. The table storing the statistic could consist of two columns - uptime and downtime. When the startup trigger fires it creates a new row in the table with both uptime and downtime set to sysdate. It then sleeps for a minute before updating downtime for the most recent record (either remember a primary key or search for max(uptime)). This would be much easier to understand when the database was stopped / started. Of course depending on your accuracy requirement, granularity could be changed to every 5 minutes, 10 minutes, whatever. Hopefully that gives some ideas though. Of course the 3rd party monitors that Jared mentions are worth considering if the database is considered critical. In that case the number one requirement is probably the ability to page / SMS / email when it sees the database is down. Regards, Mark. Jared.Still@ra disys.comTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: SLA Trigger/Procedure om 03/12/2002 12:13 Please respond to ORACLE-L Ethan, That records the startup times, but does not record the time that the database was unavailable. What's needed is a 3rd party monitor that is not dependent on the database being up to record metrics. Jared Post, Ethan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/02/2002 02:33 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:SLA Trigger/Procedure Just a thought here for a script I think would be handy but I haven't had time to write. It is would be a simple procedure you could call to get the service level for a particular database. I suppose you would have to have some sort of way of defining normal outage windows. Basically a startup trigger would log the times in a table. You should also check the startup time against the last startup time periodically to ensure the trigger always fires. Somehow a procedure/function should be able to use this information to report the service level for the database within the last (week/month/quarter/year). I suppose I will get around to it eventually but if anyone else wants to get started on it I won't mind! Thanks, Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
Re: Database up longer that host?
Stephen, If I was in your position I would go and explain to your boss that your mad DBA skillz have resulted in a database that has better uptime than it's physical host even, and discuss a pay rise! Fixing the script will probably return your status to mere mortal DBA. Meg Crocker crocker@monste To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] rtrak.comcc: Sent by: Subject: Re: Database up longer that host? [EMAIL PROTECTED] m 03/12/2002 12:33 Please respond to ORACLE-L On Mon, 2 Dec 2002, Stephane Faroult wrote: Stephen Andert wrote: I use a script named db_uptime.sql (I think I got it from the list here) to calculate how long the database has been up. The output compares nicely to the unix uptime command. I hope that the query doesn't come from the list, because it is wrong. The error is to apply floor() before multiplying by 24 or 60 - you have tremendous rounding errors. My own database has not been up long enough to be 100% sure about it but I believe the following to be correct : Hi: Neither of the scripts works for me. Try this? select 'Host Name : '||host_name|| chr(10)|| 'Instance Name : '||instance_name|| chr(10)|| 'Uptime : ' ||floor(xx)||'days ' || floor( 24 * (xx - floor(xx)) ) || 'hours ' || round( 60 * (24 * xx - floor(24 * xx))) || 'minutes ' from ( select host_name,instance_name ,(sysdate-STARTUP_TIME) xx from v$instance ) / Meg Crocker -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Meg Crocker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY,
RE: ORA-1653: unable to extend table - Why?
Check oradebug to wake up smon --- [EMAIL PROTECTED] a écrit : My experience yesterday was that dropping an index and trying to rebuild the same index failed ( even after coalescing the tablespace) since we need to wait for SMON to clean up the extents to make them available. I don't know how we make SMON process to coalesce the free space faster enough( or immediately after we delete from the table or dropping an index ). Any ideas? -Original Message- Sent: Monday, December 02, 2002 3:49 PM To: Multiple recipients of list ORACLE-L Okay, I just heard back from the developer. It was definitely not using either a Direct load or and Append hint. Just a regular insert. Any more ideas? -Original Message- Sent: Friday, November 29, 2002 1:39 PM To: Multiple recipients of list ORACLE-L Did you insert using direct path ? If so the insert inserts after the highwater mark. The highwater mark is not reinitialized after deletes. So maybe that's why the insert failed. --- Miller, Jay [EMAIL PROTECTED] a écrit : Okay, I can't figure this one out. Earlier this week I got an ORA-1653: unable to extend table on a really big table. However this was just after I had deleted over 2 million rows in the table and we were only inserting 30,000. After reanalyzing the table I saw the following stats in DBA_TABLES: num_freelist_blocks: 2266966 avg_space_freelist_blocks: 3895 Unless I'm misreading this I should have had over 8Gig available for inserts. We tried the insert again and got the same error so I added a datafile and it went through (using about 40Meg of space in the new datafile). Why isn't it making use of the existing blocks on the freelist? Oracle 8.1.7.2 Solaris 2.6 PCTFREE = 10 PCTUSED = 75 Block Size = 4K Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Stephane=20Paquette?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2
RE: Database up longer that host?
You may use following query will give you the uptime in hours and in minutes. select sysdate, startup_time, round( (sysdate - startup_time) *24*60 ,0 ) uptime_in_minutes, round( (sysdate - startup_time) *24 ,0) uptime_in_hours from v$instance SYSDATESTARTUP_TIME UPTIME_IN_MINUTES UPTIME_IN_HOURS -- -- - --- 20021202203918 20021202044608 953 16 Hope this is what you wanted. -Original Message- Sent: Monday, December 02, 2002 8:34 PM To: Multiple recipients of list ORACLE-L On Mon, 2 Dec 2002, Stephane Faroult wrote: Stephen Andert wrote: I use a script named db_uptime.sql (I think I got it from the list here) to calculate how long the database has been up. The output compares nicely to the unix uptime command. I hope that the query doesn't come from the list, because it is wrong. The error is to apply floor() before multiplying by 24 or 60 - you have tremendous rounding errors. My own database has not been up long enough to be 100% sure about it but I believe the following to be correct : Hi: Neither of the scripts works for me. Try this? select 'Host Name : '||host_name|| chr(10)|| 'Instance Name : '||instance_name|| chr(10)|| 'Uptime : ' ||floor(xx)||'days ' || floor( 24 * (xx - floor(xx)) ) || 'hours ' || round( 60 * (24 * xx - floor(24 * xx))) || 'minutes ' from ( select host_name,instance_name ,(sysdate-STARTUP_TIME) xx from v$instance ) / Meg Crocker -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Meg Crocker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database up longer that host?
Govind, Actually, what I want it the same format as I have, I just want the numbers to match (or fall within) the numbers reported by the unix uptime command for example up 4 days, 21:08 hours. In my case, the unix uptime is saying the host was last restarted after the database startup_time reported in v$instance. Stephen [EMAIL PROTECTED] 12/02/02 07:43PM You may use following query will give you the uptime in hours and in minutes. select sysdate, startup_time, round( (sysdate - startup_time) *24*60 ,0 ) uptime_in_minutes, round( (sysdate - startup_time) *24 ,0) uptime_in_hours from v$instance SYSDATESTARTUP_TIME UPTIME_IN_MINUTES UPTIME_IN_HOURS -- -- - --- 20021202203918 20021202044608 953 16 Hope this is what you wanted. -Original Message- Sent: Monday, December 02, 2002 8:34 PM To: Multiple recipients of list ORACLE-L On Mon, 2 Dec 2002, Stephane Faroult wrote: Stephen Andert wrote: I use a script named db_uptime.sql (I think I got it from the list here) to calculate how long the database has been up. The output compares nicely to the unix uptime command. I hope that the query doesn't come from the list, because it is wrong. The error is to apply floor() before multiplying by 24 or 60 - you have tremendous rounding errors. My own database has not been up long enough to be 100% sure about it but I believe the following to be correct : Hi: Neither of the scripts works for me. Try this? select 'Host Name : '||host_name|| chr(10)|| 'Instance Name : '||instance_name|| chr(10)|| 'Uptime : ' ||floor(xx)||'days ' || floor( 24 * (xx - floor(xx)) ) || 'hours ' || round( 60 * (24 * xx - floor(24 * xx))) || 'minutes ' from ( select host_name,instance_name ,(sysdate-STARTUP_TIME) xx from v$instance ) / Meg Crocker -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Meg Crocker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Database up longer that host?
With my luck and the damagement in my current workplace, I'd probably get a written warning for not having done this with all of our databases :) [EMAIL PROTECTED] 12/02/02 07:24PM Stephen, If I was in your position I would go and explain to your boss that your mad DBA skillz have resulted in a database that has better uptime than it's physical host even, and discuss a pay rise! Fixing the script will probably return your status to mere mortal DBA. Meg Crocker crocker@monste To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] rtrak.comcc: Sent by: Subject: Re: Database up longer that host? [EMAIL PROTECTED] m 03/12/2002 12:33 Please respond to ORACLE-L On Mon, 2 Dec 2002, Stephane Faroult wrote: Stephen Andert wrote: I use a script named db_uptime.sql (I think I got it from the list here) to calculate how long the database has been up. The output compares nicely to the unix uptime command. I hope that the query doesn't come from the list, because it is wrong. The error is to apply floor() before multiplying by 24 or 60 - you have tremendous rounding errors. My own database has not been up long enough to be 100% sure about it but I believe the following to be correct : Hi: Neither of the scripts works for me. Try this? select 'Host Name : '||host_name|| chr(10)|| 'Instance Name : '||instance_name|| chr(10)|| 'Uptime : ' ||floor(xx)||'days ' || floor( 24 * (xx - floor(xx)) ) || 'hours ' || round( 60 * (24 * xx - floor(24 * xx))) || 'minutes ' from ( select host_name,instance_name ,(sysdate-STARTUP_TIME) xx from v$instance ) / Meg Crocker -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Meg Crocker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: Database up longer that host?
Try this out. thisqry is working well for hrs and mins. hop u modify this qry get for hrs also wishes select (((sysdate-startup_time)*60*24-mod((sysdate-startup_time)*60*24,60))/60)HRS , round(mod((sysdate-startup_time)*60*24,60))MIN from v$instance Wishes Sathyanarayanan |+--- || Stephen Andert | || stephenandert@firsth| || ealth.com | || | || 03/12/2002 09:28 | || Please respond to| || ORACLE-L | || | |+--- --| | | | To: Multiple recipients of list ORACLE-L | | [EMAIL PROTECTED] | | cc: (bcc: Sathyanaryanan K/VGIL) | | Subject: RE: Database up longer that host? | --| Govind, Actually, what I want it the same format as I have, I just want the numbers to match (or fall within) the numbers reported by the unix uptime command for example up 4 days, 21:08 hours. In my case, the unix uptime is saying the host was last restarted after the database startup_time reported in v$instance. Stephen [EMAIL PROTECTED] 12/02/02 07:43PM You may use following query will give you the uptime in hours and in minutes. select sysdate, startup_time, round( (sysdate - startup_time) *24*60 ,0 ) uptime_in_minutes, round( (sysdate - startup_time) *24 ,0) uptime_in_hours from v$instance SYSDATESTARTUP_TIME UPTIME_IN_MINUTES UPTIME_IN_HOURS -- -- - --- 20021202203918 20021202044608 953 16 Hope this is what you wanted. -Original Message- Sent: Monday, December 02, 2002 8:34 PM To: Multiple recipients of list ORACLE-L On Mon, 2 Dec 2002, Stephane Faroult wrote: Stephen Andert wrote: I use a script named db_uptime.sql (I think I got it from the list here) to calculate how long the database has been up. The output compares nicely to the unix uptime command. I hope that the query doesn't come from the list, because it is wrong. The error is to apply floor() before multiplying by 24 or 60 - you have tremendous rounding errors. My own database has not been up long enough to be 100% sure about it but I believe the following to be correct : Hi: Neither of the scripts works for me. Try this? select 'Host Name : '||host_name|| chr(10)|| 'Instance Name : '||instance_name|| chr(10)|| 'Uptime : ' ||floor(xx)||'days ' || floor( 24 * (xx - floor(xx)) ) || 'hours ' || round( 60 * (24 * xx - floor(24 * xx))) || 'minutes ' from ( select host_name,instance_name ,(sysdate-STARTUP_TIME) xx from v$instance ) / Meg Crocker -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Meg Crocker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP
