Re: Where does a DBA go from here?
Yeah, we're doing the Forum on 27-28 of May (confirmed) and we'll do a Miracle Master Class with Jonathan about 5-6 weeks later. Apart from the 200-250 hours flight time to get there, it should prove fun. Let's have a Fatcity Oracle-L party while we're there, shall we? Mogens Suhen Pather wrote: Sujatha, Just spoke to Peter Bach, Miracle AS , Australia The forum dates are not confirmed yet but it will be towards the end of May. Once he has the dates confirmed he will post it on the Miracle website. You can call him for more info, the numbers can be obtained from the Miracle AS website. It should be a great training to attend with lots of big names from the industry. He says that Jonathan Lewis will also be doing a training course (seminar) in Australia similar to the one on his website (JLCOMP). Regards $uhen Where can I get more information about this Database Forum in Sydney ?? Cheers, Sujatha -Original Message- From: Mogens Nrgaard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 19 February 2002 10:18 AM To: Multiple recipients of list ORACLE-L Subject: Re: Where does a DBA go from here? Time for some real marketing here :-). Jonathan Lewis, Cary Millsap, Anjo Kolk, Steve Adams, Bjorn Engsig, James Morle and a few others will be the main speakers at the Database Forum we're doing in Sydney in late May. A couple of days with these guys should prove fun and educational. These days we even have an informal organisation called The OakTable Network ( www.OakTable.net ) which, for instance, will have a booth at Oracle World in Copenhagen in June where you can ask anything you like, sit around my oak table, and drink beer (well, maybe not that :) ), listen to mini presentations by the guys, and so on. EoM (End of Marketing). PS: We'll also try to build the worlds biggest laptop RAC cluster. That's proving a challenge. So far, we've managed to run two nodes on the laptops, but then it becomes harder - much harder. But James, Jonathan and Bjorn are working on it. Wouldn't it be fun if anybody could bring their laptop, plug it in, be part of the RAC thing for some minutes, and then get a certificate stating that the person participated in the worlds biggest, etc...? Mogens Greg Moore wrote: Now wheredo I go for more Oracle training? Consider looking at the web sites of the Oracle DBA's who are up on thelatest techniques. They sometimes teach advanced classes. CraigShallahamer (www.orapub.com) offers an advanced class, as does Cary Millsap.Steve Adams recently taught a class in San Francisco. Tim Gorman may giveadvanced classes.The latest and best thinking seems to appear first in papers that are freelyavailable, and then later appears in books and classes. These four DBA'soffer papers like that on their sites, and link to other sites with more ofthe same. After a certain point you have to turn to quality books, papersand conferences.If it's classes you want, a clever move might be to take some UNIX orWindows system administration ones, to broaden your skills into some newarea like that.
RE: Where does a DBA go from here?
Enough already :-)... Lee (jealous in England!) -Original Message-From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]]Sent: 19 February 2002 08:08To: Multiple recipients of list ORACLE-LSubject: Re: Where does a DBA go from here? Yeah, we're doing the Forum on 27-28 of May (confirmed) and we'll do a Miracle Master Class with Jonathan about 5-6 weeks later. Apart from the 200-250 hours flight time to get there, it should prove fun. Let's have a Fatcity Oracle-L party while we're there, shall we?MogensSuhen Pather wrote: Sujatha, Just spoke to Peter Bach, Miracle AS , Australia The forum dates are not confirmed yet but it will be towards the end of May. Once he has the dates confirmed he will post it on the Miracle website. You can call him for more info, the numbers can be obtained from the Miracle AS website. It should be a great training to attend with lots of big names from the industry. He says that Jonathan Lewis will also be doing a training course (seminar) in Australia similar to the one on his website (JLCOMP). Regards $uhen Where can I get more information about this Database Forum in Sydney ?? Cheers, Sujatha -Original Message-From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]]Sent: Tuesday, 19 February 2002 10:18 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Where does a DBA go from here? Time for some real marketing here :-). Jonathan Lewis, Cary Millsap, Anjo Kolk, Steve Adams, Bjorn Engsig, James Morle and a few others will be the main speakers at the Database Forum we're doing in Sydney in late May. A couple of days with these guys should prove fun and educational. These days we even have an informal organisation called The OakTable Network ( www.OakTable.net ) which, for instance, will have a booth at Oracle World in Copenhagen in June where you can ask anything you like, sit around my oak table, and drink beer (well, maybe not that :) ), listen to mini presentations by the guys, and so on.EoM (End of Marketing).PS: We'll also try to build the worlds biggest laptop RAC cluster. That's proving a challenge. So far, we've managed to run two nodes on the laptops, but then it becomes harder - much harder. But James, Jonathan and Bjorn are working on it. Wouldn't it be fun if anybody could bring their laptop, plug it in, be part of the RAC thing for some minutes, and then get a certificate stating that the person participated in the worlds biggest, etc...?MogensGreg Moore wrote:!--[if !supportLineBreakNewLine]--!--[endif]-- Now wheredo I go for more Oracle training?Consider looking at the web sites of the Oracle DBA's who are up on thelatest techniques. They sometimes teach advanced classes. CraigShallahamer (www.orapub.com) offers an advanced class, as does Cary Millsap.Steve Adams recently taught a class in San Francisco. Tim Gorman may giveadvanced classes.The latest and best thinking seems to appear first in papers that are freelyavailable, and then later appears in books and classes. These four DBA'soffer papers like that on their sites, and link to other sites with more ofthe same. After a certain point you have to turn to quality books, papersand conferences.If it's classes you want, a clever move might be to take some UNIX orWindows system administration ones, to broaden your skills into some newarea like that. The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system.
Re: Weird ODBC Issue
- Original Message - Been there, done that. I still prefer fantasy. there are some interesting statistics in the last issue of Profit Magazine (http://www.oracle.com/oramag/profit/02-feb/index.html?p12forward2.html) a Lycos web search for Reality returns 4,991,337 hits and a search for Fantasy returns 5,952,582 hits Marin ...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Rollback Segments
iag/iap, rpt and sql*menu were for the duhvelopers!. I wouldn't remember these product ; Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Anjo Kolk [EMAIL PROTECTED] 19/02/2002 03:43 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Re: Rollback Segments How about iag/iap ? And rpt ? Oh and SQL*Menu ? And there were about 14 enqueue/locks in Oracle Version 5 as far as I can remember. Anjo Kolk Brings back memories of joining Oracle Europe in 1985 ;-) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, February 19, 2002 6:43 AM I remember the BI.ORA (Before-Image) file, IOR and ODS in Oracle 5. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Rachel Carmichael [EMAIL PROTECTED] 19/02/2002 06:18 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: RE: Rollback Segments UFI no, but the rest... that's where I started in Oracle -- version 5 --- Conboy, Jim [EMAIL PROTECTED] wrote: Holy cow Mladen, what a memory! Does anybody else remember (or admit to) using UFI? Jim ** ...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like
Re: Oracle 8i patch installation
If you install an additional option/product back from the 8.1.7 CDs later, you should reapply the 8.1.7.3 Patch. However, you would not need to rerun the sql scripts (catalog.sql, catproc.sql) unless the new option requires it -- e.g. if you install Advanced Replication later, you would need to run catrep.sql Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd [EMAIL PROTECTED] 19/02/2002 10:53 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Oracle 8i patch installation Hi, At my site I normally install Oracle Server EE using custom installation, i.e. I install only the products that I need. Now an Oracle 8i patchset (e.g. 8.1.7.3 patchset) contains patches for many products (RDBMS, PL/SQL, Networking, Intermedia etc). If I install say 8.1.7.3 on top of my current 8.1.7.0 it will install not only patches for products that I have in my current 8.1.7.0 installation, but also extra patches as well. This is fine for now I can foresee a problem in future when I install additional products from the 8.1.7.0 CD. Should I reapply the 8.1.7.3 patchset then to ensure that all products are properly patches? Do you see any problem with installing the same patchset more than once for an Oracle server? Thanks Long -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Disable certain users from login to database while applying H
Hi Gurus, Thanks for replying to my qn. Startup Database in Restricted mode will not work (for more details, pls refer to the email below). The following solutions : 1. Database ON LOGON Trigger = don't know whether it will work 2. Lock Database Account = I am going to use this solution. 3. Change Database Account Password = I believe it will work In our Oracle HR, we also support oracle client-server forms/reports, so I've to disable their accounts so that they do not access the HR database using sqlplus/forms/reports while I am applying patches. Regds, Catherine -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 2:13 PM To: Multiple recipients of list ORACLE-L Subject:Re: Disable certain users from login to database while applying Human As you are talking of Oracle Apps, NONE of the suggested solutions : 1. Database ON LOGON Trigger 2. Lock Database Account 3. Change Database Account Password 4. Startup Database in Restricted mode would work. The users connect to the Database in the APPS schema -- this is the universal schema that Oracle Apps uses. The Patch requires APPS so Restricted doesn't help (unless you grant Restricted to APPS in which case all the users can logon). Ditto about locking, changing password or writing a trigger on the APPS schema. What you can do are : 1. Shutdown the Apache server for the Self-Service Modules 2. Shutdown the Forms server for the Forms Module 3. Shutdown the Concurrent Managers. All of the above would affect ALL users. Alternatively, login to the Application as the System Administrator user and change the Application User Passwords for the users whom you want disabled. Change the passwords back to a default (WELCOME) later. However, what you SHOULD do, per Oracle Support, is 1. Shutdown 2. Shutdown 3. Shutdown as I have listed above. If you are familiar with Oracle Applications Patching and are comfortable with reading the Patch drivers, you can figure out what database objects are being modified/updated/created and what Forms/Reports/HTML etc files are being modified/created by the patch. Then you can take an intelligent decision should you allow users to logon when applying the patch ? Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED] 18/02/2002 03:28 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Disable certain users from login to database while applying Human Hi Gurus, I need to disable certain users from login to database while I apply the Human Resources Patches for our Oracle HR 11i Applications. Which is the best way to do it ? Should I write on-logon trigger to disable or should I take away their privileges to logon to report/forms/sqlplus ? What about the rest of the DBA Applications administrator ? What do U guys do to solve the dead-lock problem (If my users access the HR tables while I apply the patches, I will encounter dead-lock problem) ? Please advise. Thanks. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of
RE: Oracle Advanced Replication
I will write my comments in your response. Scroll down. One point I would like to stress: We are planing to drop replication and work with the live DB in case one DB goes down. In this case we will work for some days without replication until we rebuild the dba machine and then do an export/import from the live DB to the new one and rebuild the replication again. See my comments bellow. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Rahul Dandekar [SMTP:[EMAIL PROTECTED]] Sent: Mon, February 18, 2002 7:03 PM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle Advanced Replication Adar, How do you take care of backups? I mean, what kind of backups do you take? How are you addressing the scenario of incomplete recovery? Following are some of my doubts. 1. What kind of Backup should be taken? Online or Offline? Does replication would generate substantially higher redo? [ADAR]We do online backups using Veritas backupexec + some exports at key points. Ø Lets analyze the possibility of Online Backups : q Redo Generation Apparently, a database in replicated environment would generate significantly more redo if the same database was not in replicated environment. Is there sufficient bandwidth (diskspace, tapes) for the additional redo? [ADAR] We are doing synchronous replication (2 phase commit). In this case oracle use a trigger to update the backup DB without writing anything to the redo log. The redo log will inflate in case of asynchronous replication because of the updates to the replication tables. q Need for Complete Recovery If we need to recover one of the databases then it should be complete recovery. Incomplete recovery will not be permissible since the databases are in replicated environment. (Lets not consider 'All' the databases restored from their backups till a certain SCN.) [ADAR] We are doing full backup just in case of both system failure. If one system fails we continue to work with the other and synchronize later. q Quick Recovery Also, the recovery must be done quickly. This is because as one of the databases in replicated environment is down, the DEFTRAN queues in other master sites would start getting larger and larger and it might reach to a stage where we would also need to do the 'Offline Instantiation' for replicated objects. [ADAR] We are not planing it this way. For NOW we plan on dropping the replication and building the bad DB from scratch, using export from the live DB and building the replication again. Our system is dealing room and we have each Sunday available as the dealers around the world have a day off. So if one computer is down we will not have replication until next Sunday. This also gives us time to fix the computer and build a new DB without pressure. q When complete ercovery is not possible In case complete recovery is not possible then we need to recover the databases and then perform 'Offline Instantiation' for replicated objects. [ADAR] That's the beauty of our plan. You do not need recovery at all. Just use the live DB as a source to recreate the bad DB again. Ø What if we take Offline Backups : q For a simple recovery, entire database needs to be restored from the cold backup. q 'Offline Instantiation' needs to be performed each time media recovery is performed. This is because media recovery would always bring the database till the time of cold backup and other master sites would be ahead in time. q In case datafiles affecting 'only' those tablespaces which have objects which are replicated are needing recovery then recovery can be done by using transportable tablespaces feature. i. First, we would need to drop those tablespaces from the database. ii. We can then drop replication for this master group. iii. Transport and Plug-in the tablespace's datafile from other master site. iv. Rebuild replication. TIA, +Rahul - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, February 17, 2002 11:18 AM Hello Peter We implemented Advance Replication as part of dealing room. We defined master to master real-time replication. Synchronous, 2 phase commit, from the primary to the backup DB as each deal is a lot of money and standby database will not reflect updates since the last log file
RE: [Fwd: UNIX Performance Issues]
Title: Message Rahul, Did you get a response on this? I'm not sure I fully understand the actual question - are you looking for specific commands you need to run to get the information, or advice on how to interpret it? Don't forget that you will really need to correlate many of these statistics to the Oracle pathology at the same time. This then causes a problem because your sample points will at the very least experience clock drift and become harder to compare over time. There are ways to solve it, though. Anyway, if you could elaborate a little, I can try to assist! Regards James --James MorleScale Abilities, Ltdhttp://www.scaleabilities.co.ukAuthor of "Scaling Oracle8i - Building Highly Scalable OLTP System Architectures" -Original Message-From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]] Sent: 18 February 2002 22:11To: James MorleSubject: [Fwd: UNIX Performance Issues]Hi James,I've got no idea whether this is of interest or not to you, but you probably know a bit about this topic.Mogens Original Message Subject: UNIX Performance Issues Date: Thu, 14 Feb 2002 07:43:26 -0800 From: "Rahul Dandekar" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]DBAs, This might be littlebit (or completely!) UNIX related... But I am told to do the performance analysis of some 10-15 machines and generate some statistical data to find out bottlenecks and identify areas of tuning... Operating System : Solaris 2.6 I have been using sar, iostat, top... I actually plan to script these things and run these scripts at certain intervals and put the data in database (Oracle 8i) and then do the crunching... Inputs are appreciated... 1. I/O What is current I/O status. Is there a lot of I/O going on? 2. Paging Is there lot of swapping / paging happening? Which processes are getting swapped in/out continuously? Are the I/O waits due to swapping / paging or regular stuff like DB waiting to read from DB files? 3. CPU What is the CPU utulization? Which processes are using lot of CPU? 4. Memory What is the current picture of Real and Virtual Memory? What processes are using how much memory? Which processes are i n real memory and which are in virtual memory? Which processes are swapped in and out from/to real/virtual memory and how many times? 5. Network What is the percentage utilization of network pipe? What is the capacity (bandwidth) of the network device? What percentage of that bandwidth is getting used? Is the system waiting for data from outside network I/O? In short, is there any bandwidth problem with network device or network traffic. Thanks, ___ ______ ___ ___ / /\ / /\ / /\ / /\ / /\ / /::\ / /::\/ /:// /:// /:/ / /:/\:\ / /:/:| / /:// /:// /:/ / /::\ \:\ / /:/|:| / /::\ __ / /:/ ___ / /:/ /__/:/\:\_\:\ /__/::\|:| /__/:/\:\/ /\ /__/:/ / /\ /__/:/ \__\/~|::\/:/ \__\/\:\:| \__\/ \:\/:/ \ \:\ / /:/ \ \:\ | |:|::/ \__\::| \__\::/ \ \:\ /:/ \ \:\ | |:|\/ | |:| / /:/ \ \:\/:/ \ \:\ |__|:| |__|:| /__/:/ \ \::/ \ \:\ \__\| \__\| \__\/ \__\/ \__\/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Dandekar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Copy files to hard drive from unix server
Hallo, anyone who can give me an easy example on a unix shell script that copies files from a unix directory /test/files to the hard drive directory c:\temp Thanks in advance. Would appreciate very much. Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Rollback Segments
There must be somebody beside myself remembering version 3, which did not have read consistency - the great new feature of version 4. In 3, doing UFI insert into emp select * from emp; would cause anything from having 28 rows in emp till having and endless loop in the kernel only finishing when your database file ran full... Yep - we are some old bitter men around here... /Bjørn. On Tuesday 19 February 2002 06:43, you wrote: I remember the BI.ORA (Before-Image) file, IOR and ODS in Oracle 5. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Rachel Carmichael [EMAIL PROTECTED] 19/02/2002 06:18 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: RE: Rollback Segments UFI no, but the rest... that's where I started in Oracle -- version 5 --- Conboy, Jim [EMAIL PROTECTED] wrote: Holy cow Mladen, what a memory! Does anybody else remember (or admit to) using UFI? Jim ** ...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: =?iso-8859-1?q?Bj=F8rn=20Engsig?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Where does a DBA go from here?
Mogens, Are you sure you have that time scale right for the flight times? I seem to recall it took me a mere (!) 24 hours to return to NYC from Brisbane. and I am jealous and longing to go to this class as well. sigh.. Rachel --- Mogens Nørgaard [EMAIL PROTECTED] wrote: Yeah, we're doing the Forum on 27-28 of May (confirmed) and we'll do a Miracle Master Class with Jonathan about 5-6 weeks later. Apart from the 200-250 hours flight time to get there, it should prove fun. Let's have a Fatcity Oracle-L party while we're there, shall we? Mogens Suhen Pather wrote: Sujatha, Just spoke to Peter Bach, Miracle AS , Australia The forum dates are not confirmed yet but it will be towards the end of May. Once he has the dates confirmed he will post it on the Miracle website. You can call him for more info, the numbers can be obtained from the Miracle AS website. It should be a great training to attend with lots of big names from the industry. He says that Jonathan Lewis will also be doing a training course (seminar) in Australia similar to the one on his website (JLCOMP). Regards $uhen Where can I get more information about this Database Forum in Sydney ?? Cheers, Sujatha -Original Message- From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 19 February 2002 10:18 AM To: Multiple recipients of list ORACLE-L Subject: Re: Where does a DBA go from here? Time for some real marketing here :-). Jonathan Lewis, Cary Millsap, Anjo Kolk, Steve Adams, Bjorn Engsig, James Morle and a few others will be the main speakers at the Database Forum we're doing in Sydney in late May. A couple of days with these guys should prove fun and educational. These days we even have an informal organisation called The OakTable Network ( www.OakTable.net http://www.OakTable.net ) which, for instance, will have a booth at Oracle World in Copenhagen in June where you can ask anything you like, sit around my oak table, and drink beer (well, maybe not that :) ), listen to mini presentations by the guys, and so on. EoM (End of Marketing). PS: We'll also try to build the worlds biggest laptop RAC cluster. That's proving a challenge. So far, we've managed to run two nodes on the laptops, but then it becomes harder - much harder. But James, Jonathan and Bjorn are working on it. Wouldn't it be fun if anybody could bring their laptop, plug it in, be part of the RAC thing for some minutes, and then get a certificate stating that the person participated in the worlds biggest, etc...? Mogens Greg Moore wrote: Now where do I go for more Oracle training? Consider looking at the web sites of the Oracle DBA's who are up on the latest techniques. They sometimes teach advanced classes. Craig Shallahamer (www.orapub.com http://www.orapub.com) offers an advanced class, as does Cary Millsap. Steve Adams recently taught a class in San Francisco. Tim Gorman may give advanced classes. The latest and best thinking seems to appear first in papers that are freely available, and then later appears in books and classes. These four DBA's offer papers like that on their sites, and link to other sites with more of the same. After a certain point you have to turn to quality books, papers and conferences. If it's classes you want, a clever move might be to take some UNIX or Windows system administration ones, to broaden your skills into some new area like that. __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: [Fwd: UNIX Performance Issues]
Title: Message James, Interleaved, please find my reply +Rahul - Original Message - From: James Morle To: Multiple recipients of list ORACLE-L Sent: Tuesday, February 19, 2002 6:03 AM Subject: RE: [Fwd: UNIX Performance Issues] Rahul, Did you get a response on this? I'm not sure I fully understand the actual question - are you looking for specific commands you need to run to get the information, [Rahul] Yes. I would like to know which flags of the commonly used commands give good information. For general System stats, I use "sar -u" (same as default), for Memory / Virtual Memory I use "vmstat" and look for "r b w swap free pi po us sy id" columns. I am looking for general monitoring. And once we have this general information giving a overall picture, we could know if there is a problem and we could investigate further. I am specifically looking for IO and Network statistics. Is there any command which would give me approx IO of the system, say in last 5 minutes or current? How to get network statistics? I was littlebit confused with netstat. There are two main categories in my output : hme0 and Total. What does that mean? input hme0 output input (Total) outputpackets errs packets errs colls packets errs packets errs colls5757291 0 2447690 0 0 6071152 0 2761551 0 045 0 1 0 0 45 0 1 0 024 0 2 0 0 24 0 2 0 0 What I plan to do is to take snapshot of all these statistics at acertain frequency and put it in database.Later on I could generate reports based on this. Currently, I have a lot of "Camera"s like thistaking snapshots of my system. Others involveOracle stuff like DB Size Growth, Performance Ratios,UNIX File System usage, Replication Statistics, Growth of DB objects, a lot of monitors for application info (e.g. total # of clients, # of invoices generated per day). I generate trends based on this archival data for capacity planning and proactively anticipating chronic problems. or advice on how to interpret it? Don't forget that you will really need to correlate many of these statistics to the Oracle pathology at the same time. You said it! I want co-relation of Application Load, UNIX System Load and Database Statistics. And not just when the problem arises. So, that's what I am trying to develop. This then causes a problem because your sample points will at the very least experience clock drift and become harder to compare over time. There are ways to solve it, though. Anyway, if you could elaborate a little, I can try to assist! Regards James --James MorleScale Abilities, Ltdhttp://www.scaleabilities.co.ukAuthor of "Scaling Oracle8i - Building Highly Scalable OLTP System Architectures" -Original Message-From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]] Sent: 18 February 2002 22:11To: James MorleSubject: [Fwd: UNIX Performance Issues]Hi James,I've got no idea whether this is of interest or not to you, but you probably know a bit about this topic.Mogens Original Message Subject: UNIX Performance Issues Date: Thu, 14 Feb 2002 07:43:26 -0800 From: "Rahul Dandekar" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]DBAs, This might be littlebit (or completely!) UNIX related... But I am told to do the performance analysis of some 10-15 machines and generate some statistical data to find out bottlenecks and identify areas of tuning... Operating System : Solaris 2.6 I have been using sar, iostat, top... I actually plan to script these things and run these scripts at certain intervals and put the data in database (Oracle 8i) and then do the crunching... Inputs are appreciated... 1. I/O What is current I/O status. Is there a lot of I/O going on? 2. Paging Is there lot of swapping / paging happening? Which processes are getting swapped in/out continuously? Are the I/O waits due to swapping / paging or regular stuff like DB waiting to read from DB files? 3. CPU What is the CPU utulization? Which processes are using lot of CPU? 4. Memory What is the current picture of Real and Virtual Memory? What processes are using how much memory? Which processes are i n real memory and which are in virtual memory? Which processes are swapped in and out from/to real/virtual memory and how many times? 5. Network What is the percentage utilization of network pipe? What is the capacity (bandwidth) of the network device? What percentage of that bandwidth is getting used? Is the system waiting for data from outside network I/O? In short, is there any bandwidth problem with network device or network traffic.
RE: Where does a DBA go from here?
Mogens is using a new type of aircraft from the other large Seattle company That's why it takes 10 times longer... ;-) -- James Morle Scale Abilities, Ltd http://www.scaleabilities.co.uk Author of Scaling Oracle8i - Building Highly Scalable OLTP System Architectures -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Rachel Carmichael Sent: 19 February 2002 12:38 To: Multiple recipients of list ORACLE-L Subject: Re: Where does a DBA go from here? Mogens, Are you sure you have that time scale right for the flight times? I seem to recall it took me a mere (!) 24 hours to return to NYC from Brisbane. and I am jealous and longing to go to this class as well. sigh.. Rachel --- Mogens Nørgaard [EMAIL PROTECTED] wrote: Yeah, we're doing the Forum on 27-28 of May (confirmed) and we'll do a Miracle Master Class with Jonathan about 5-6 weeks later. Apart from the 200-250 hours flight time to get there, it should prove fun. Let's have a Fatcity Oracle-L party while we're there, shall we? Mogens Suhen Pather wrote: Sujatha, Just spoke to Peter Bach, Miracle AS , Australia The forum dates are not confirmed yet but it will be towards the end of May. Once he has the dates confirmed he will post it on the Miracle website. You can call him for more info, the numbers can be obtained from the Miracle AS website. It should be a great training to attend with lots of big names from the industry. He says that Jonathan Lewis will also be doing a training course (seminar) in Australia similar to the one on his website (JLCOMP). Regards $uhen Where can I get more information about this Database Forum in Sydney ?? Cheers, Sujatha -Original Message- From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 19 February 2002 10:18 AM To: Multiple recipients of list ORACLE-L Subject: Re: Where does a DBA go from here? Time for some real marketing here :-). Jonathan Lewis, Cary Millsap, Anjo Kolk, Steve Adams, Bjorn Engsig, James Morle and a few others will be the main speakers at the Database Forum we're doing in Sydney in late May. A couple of days with these guys should prove fun and educational. These days we even have an informal organisation called The OakTable Network ( www.OakTable.net http://www.OakTable.net ) which, for instance, will have a booth at Oracle World in Copenhagen in June where you can ask anything you like, sit around my oak table, and drink beer (well, maybe not that :) ), listen to mini presentations by the guys, and so on. EoM (End of Marketing). PS: We'll also try to build the worlds biggest laptop RAC cluster. That's proving a challenge. So far, we've managed to run two nodes on the laptops, but then it becomes harder - much harder. But James, Jonathan and Bjorn are working on it. Wouldn't it be fun if anybody could bring their laptop, plug it in, be part of the RAC thing for some minutes, and then get a certificate stating that the person participated in the worlds biggest, etc...? Mogens Greg Moore wrote: Now where do I go for more Oracle training? Consider looking at the web sites of the Oracle DBA's who are up on the latest techniques. They sometimes teach advanced classes. Craig Shallahamer (www.orapub.com http://www.orapub.com) offers an advanced class, as does Cary Millsap. Steve Adams recently taught a class in San Francisco. Tim Gorman may give advanced classes. The latest and best thinking seems to appear first in papers that are freely available, and then later appears in books and classes. These four DBA's offer papers like that on their sites, and link to other sites with more of the same. After a certain point you have to turn to quality books, papers and conferences. If it's classes you want, a clever move might be to take some UNIX or Windows system administration ones, to broaden your skills into some new area like that. __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Re: Copy files to hard drive from unix server
I do it from dos / command prompt in windows as follows Create files cmds and c.bat and run c.bat +--+ | cmds | +--+ oracle password lcd c:\temp get /test/files bye +---+ | c.bat | +---+ ftp -s:cmds tmatesttmrm +Rahul - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, February 19, 2002 6:43 AM Hallo, anyone who can give me an easy example on a unix shell script that copies files from a unix directory /test/files to the hard drive directory c:\temp Thanks in advance. Would appreciate very much. Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Dandekar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: [Fwd: UNIX Performance Issues]
Title: Message Rahul, Here's what I would do. 1) I would use "mpstat" for the processor statistics. This breaks the usage up by processor in SMP configurations. This can be useful to see the relative loading of each CPU, in particular the breakdown of kernel and user time. 2) Memory: Concentrate on Page Outs and Free Memory more than anything else. That will give you plenty of clues about memory starvation, and the relevence of your VM tuning. 3) I/O: User "sar -d". It's a bit annoying on a system with a lot of disks, because it returns a row for every device, even if no I/O occurred in the sample period. However, it makes it easier to parse. ;-) Notably, keep an eye on the Service Times (avserv?), Wait times (avwait), and the queue depth. The utilisation is a function of these (queuing theory), but you can store that too as a shortcut. You can give sar any sample period, so your 5 minute averages are no problem. 4) Network: "netstat 5" will report a row for every 5 seconds (for example), showing how many packets went in and out of each interface. Your question below is easily answered - you have two columns in your output; the first is for the named interface (hme0), the 100baseT network card. The second is a total of all cards - looks like you only have one. This total can also include the loopback interface (lo0), so look out for that. Good luck, you're doing the right thing. I've been working on some software to do just this for a couple of years. I'd love to hear how it goes! Regards James --James MorleScale Abilities, Ltdhttp://www.scaleabilities.co.ukAuthor of "Scaling Oracle8i - Building Highly Scalable OLTP System Architectures" -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Rahul DandekarSent: 19 February 2002 12:59To: Multiple recipients of list ORACLE-LSubject: Re: [Fwd: UNIX Performance Issues] James, Interleaved, please find my reply +Rahul - Original Message - From: James Morle To: Multiple recipients of list ORACLE-L Sent: Tuesday, February 19, 2002 6:03 AM Subject: RE: [Fwd: UNIX Performance Issues] Rahul, Did you get a response on this? I'm not sure I fully understand the actual question - are you looking for specific commands you need to run to get the information, [Rahul] Yes. I would like to know which flags of the commonly used commands give good information. For general System stats, I use "sar -u" (same as default), for Memory / Virtual Memory I use "vmstat" and look for "r b w swap free pi po us sy id" columns. I am looking for general monitoring. And once we have this general information giving a overall picture, we could know if there is a problem and we could investigate further. I am specifically looking for IO and Network statistics. Is there any command which would give me approx IO of the system, say in last 5 minutes or current? How to get network statistics? I was littlebit confused with netstat. There are two main categories in my output : hme0 and Total. What does that mean? input hme0 output input (Total) outputpackets errs packets errs colls packets errs packets errs colls5757291 0 2447690 0 0 6071152 0 2761551 0 045 0 1 0 0 45 0 1 0 024 0 2 0 0 24 0 2 0 0 What I plan to do is to take snapshot of all these statistics at acertain frequency and put it in database.Later on I could generate reports based on this. Currently, I have a lot of "Camera"s like thistaking snapshots of my system. Others involveOracle stuff like DB Size Growth, Performance Ratios,UNIX File System usage, Replication Statistics, Growth of DB objects, a lot of monitors for application info (e.g. total # of clients, # of invoices generated per day). I generate trends based on this archival data for capacity planning and proactively anticipating chronic problems. or advice on how to interpret it? Don't forget that you will really need to correlate many of these statistics to the Oracle pathology at the same time. You said it! I want co-relation of Application Load, UNIX System Load and Database Statistics. And not just when the problem arises. So, that's what I am trying to develop. This then causes a problem because your sample points will at the very least experience clock drift and become harder to compare over time. There are ways to solve it, though. Anyway, if you could elaborate a little, I can try to assist! Regards James --James MorleScale Abilities, Ltdhttp://www.scaleabilities.co.ukAuthor of "Scaling Oracle8i - Building Highly Scalable OLTP System Architectures" -Original Message-From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]] Sent: 18 February
RE: Where does a DBA go from here?
Obviously you don't know Boeing Travel. The way it works is: 8 hours flying time to Hawaii. 230 hours layover (with per diem). 12 hours flying time to Sydney. And if you schedule your flight to Hawaii for wheels up before 6am, then you get a full per-diem for that day too. James Morle James.Morle To: Multiple recipients of list ORACLE-L @scaleabiliti[EMAIL PROTECTED] es.co.ukcc: Sent by: rootSubject: RE: Where does a DBA go from here? 02/19/2002 08:08 AM Please respond to ORACLE-L Mogens is using a new type of aircraft from the other large Seattle company That's why it takes 10 times longer... ;-) -- James Morle Scale Abilities, Ltd http://www.scaleabilities.co.uk Author of Scaling Oracle8i - Building Highly Scalable OLTP System Architectures -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Rachel Carmichael Sent: 19 February 2002 12:38 To: Multiple recipients of list ORACLE-L Subject: Re: Where does a DBA go from here? Mogens, Are you sure you have that time scale right for the flight times? I seem to recall it took me a mere (!) 24 hours to return to NYC from Brisbane. and I am jealous and longing to go to this class as well. sigh.. Rachel --- Mogens Nørgaard [EMAIL PROTECTED] wrote: Yeah, we're doing the Forum on 27-28 of May (confirmed) and we'll do a Miracle Master Class with Jonathan about 5-6 weeks later. Apart from the 200-250 hours flight time to get there, it should prove fun. Let's have a Fatcity Oracle-L party while we're there, shall we? Mogens Suhen Pather wrote: Sujatha, Just spoke to Peter Bach, Miracle AS , Australia The forum dates are not confirmed yet but it will be towards the end of May. Once he has the dates confirmed he will post it on the Miracle website. You can call him for more info, the numbers can be obtained from the Miracle AS website. It should be a great training to attend with lots of big names from the industry. He says that Jonathan Lewis will also be doing a training course (seminar) in Australia similar to the one on his website (JLCOMP). Regards $uhen Where can I get more information about this Database Forum in Sydney ?? Cheers, Sujatha -Original Message- From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 19 February 2002 10:18 AM To: Multiple recipients of list ORACLE-L Subject: Re: Where does a DBA go from here? Time for some real marketing here :-). Jonathan Lewis, Cary Millsap, Anjo Kolk, Steve Adams, Bjorn Engsig, James Morle and a few others will be the main speakers at the Database Forum we're doing in Sydney in late May. A couple of days with these guys should prove fun and educational. These days we even have an informal organisation called The OakTable Network ( www.OakTable.net http://www.OakTable.net ) which, for instance, will have a booth at Oracle World in Copenhagen in June where you can ask anything you like, sit around my oak table, and drink beer (well, maybe not that :) ), listen to mini presentations by the guys, and so on. EoM (End of Marketing). PS: We'll also try to build the worlds biggest laptop RAC cluster. That's proving a challenge. So far, we've managed to run two nodes on the laptops, but then it becomes harder - much harder. But James, Jonathan and Bjorn are working on it. Wouldn't it be fun if anybody could bring their laptop, plug it in, be
RE: Rollback Segments
Actually, the Hercules graphics is able to generate graphics. I had to settle for Hercules since I could not afford a color monitor(using a CGA card) back then. So I looked for games, etc. that had a Hercules graphics mode. And, Hercules used twice the amount of pixels then CGA did, so I was able to find emulation software that allowed me to play CGA color games on my Hercules card. It replaced the limited CGA color pallete with patterns on the amber monitor. Sigh. The good old days... -Original Message- Sent: Monday, February 18, 2002 6:24 PM To: Multiple recipients of list ORACLE-L I do. User Friendly Interface. Hush, don't tell anybody, but I started with Oracle 4 on PC/XT with a huge, 20MB Winchester hard drive. The whole machine has had a Hercules screen card (text only, no graphics) and 512KB (no, it's not a mistake, it really is the letter K) of memory. I still have those 3 big, grey boxes with 5 5.25 floppies which used to contain the whole installation. Unfortunately, I cannot install it because I no longer have DOS 3.3 which was required for Oracle 4. Oh well, I seem to be getting old. -Original Message- Sent: Monday, February 18, 2002 1:59 PM To: Multiple recipients of list ORACLE-L Holy cow Mladen, what a memory! Does anybody else remember (or admit to) using UFI? Jim ** ...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: [Fwd: UNIX Performance Issues]
Title: Message Hi, I was at the Sun benchmarking labs in Paris before Christmas, and they had a tool which someone on there was working on. It had a web based interface, and showed everything OS performance related that you could think of. It was also very configurable, and had lots of graphs, charts etc. One of the best thing about it was that it could record the past statistics, for trend analysis. And had good report generation tools. The problem is I didn't catch it's name, and don't know if it's released yet. Sorry. Also, take a look at "High performance oracle tuning with statspack". It has lots of scripts etc. doing the type of thing you want. Jim -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of James MorleSent: 19 February 2002 13:58To: Multiple recipients of list ORACLE-LSubject: RE: [Fwd: UNIX Performance Issues] Rahul, Here's what I would do. 1) I would use "mpstat" for the processor statistics. This breaks the usage up by processor in SMP configurations. This can be useful to see the relative loading of each CPU, in particular the breakdown of kernel and user time. 2) Memory: Concentrate on Page Outs and Free Memory more than anything else. That will give you plenty of clues about memory starvation, and the relevence of your VM tuning. 3) I/O: User "sar -d". It's a bit annoying on a system with a lot of disks, because it returns a row for every device, even if no I/O occurred in the sample period. However, it makes it easier to parse. ;-) Notably, keep an eye on the Service Times (avserv?), Wait times (avwait), and the queue depth. The utilisation is a function of these (queuing theory), but you can store that too as a shortcut. You can give sar any sample period, so your 5 minute averages are no problem. 4) Network: "netstat 5" will report a row for every 5 seconds (for example), showing how many packets went in and out of each interface. Your question below is easily answered - you have two columns in your output; the first is for the named interface (hme0), the 100baseT network card. The second is a total of all cards - looks like you only have one. This total can also include the loopback interface (lo0), so look out for that. Good luck, you're doing the right thing. I've been working on some software to do just this for a couple of years. I'd love to hear how it goes! Regards James --James MorleScale Abilities, Ltdhttp://www.scaleabilities.co.ukAuthor of "Scaling Oracle8i - Building Highly Scalable OLTP System Architectures" -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Rahul DandekarSent: 19 February 2002 12:59To: Multiple recipients of list ORACLE-LSubject: Re: [Fwd: UNIX Performance Issues] James, Interleaved, please find my reply +Rahul - Original Message - From: James Morle To: Multiple recipients of list ORACLE-L Sent: Tuesday, February 19, 2002 6:03 AM Subject: RE: [Fwd: UNIX Performance Issues] Rahul, Did you get a response on this? I'm not sure I fully understand the actual question - are you looking for specific commands you need to run to get the information, [Rahul] Yes. I would like to know which flags of the commonly used commands give good information. For general System stats, I use "sar -u" (same as default), for Memory / Virtual Memory I use "vmstat" and look for "r b w swap free pi po us sy id" columns. I am looking for general monitoring. And once we have this general information giving a overall picture, we could know if there is a problem and we could investigate further. I am specifically looking for IO and Network statistics. Is there any command which would give me approx IO of the system, say in last 5 minutes or current? How to get network statistics? I was littlebit confused with netstat. There are two main categories in my output : hme0 and Total. What does that mean? input hme0 output input (Total) outputpackets errs packets errs colls packets errs packets errs colls5757291 0 2447690 0 0 6071152 0 2761551 0 045 0 1 0 0 45 0 1 0 024 0 2 0 0 24 0 2 0 0 What I plan to do is to take snapshot of all these statistics at acertain frequency and put it in database.Later on I could generate reports based on this. Currently, I have a lot of "Camera"s like thistaking snapshots of my system. Others involveOracle stuff like DB Size Growth, Performance Ratios,UNIX File System usage, Replication Statistics, Growth of DB objects, a lot of monitors for application
RE: Where does a DBA go from here?
ah, I thought perhaps it was because every 500 miles he has to stop and have a beer or two, or threee --- James Morle [EMAIL PROTECTED] wrote: Mogens is using a new type of aircraft from the other large Seattle company That's why it takes 10 times longer... ;-) -- James Morle Scale Abilities, Ltd http://www.scaleabilities.co.uk Author of Scaling Oracle8i - Building Highly Scalable OLTP System Architectures -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Rachel Carmichael Sent: 19 February 2002 12:38 To: Multiple recipients of list ORACLE-L Subject: Re: Where does a DBA go from here? Mogens, Are you sure you have that time scale right for the flight times? I seem to recall it took me a mere (!) 24 hours to return to NYC from Brisbane. and I am jealous and longing to go to this class as well. sigh.. Rachel --- Mogens Nørgaard [EMAIL PROTECTED] wrote: Yeah, we're doing the Forum on 27-28 of May (confirmed) and we'll do a Miracle Master Class with Jonathan about 5-6 weeks later. Apart from the 200-250 hours flight time to get there, it should prove fun. Let's have a Fatcity Oracle-L party while we're there, shall we? Mogens Suhen Pather wrote: Sujatha, Just spoke to Peter Bach, Miracle AS , Australia The forum dates are not confirmed yet but it will be towards the end of May. Once he has the dates confirmed he will post it on the Miracle website. You can call him for more info, the numbers can be obtained from the Miracle AS website. It should be a great training to attend with lots of big names from the industry. He says that Jonathan Lewis will also be doing a training course (seminar) in Australia similar to the one on his website (JLCOMP). Regards $uhen Where can I get more information about this Database Forum in Sydney ?? Cheers, Sujatha -Original Message- From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 19 February 2002 10:18 AM To: Multiple recipients of list ORACLE-L Subject: Re: Where does a DBA go from here? Time for some real marketing here :-). Jonathan Lewis, Cary Millsap, Anjo Kolk, Steve Adams, Bjorn Engsig, James Morle and a few others will be the main speakers at the Database Forum we're doing in Sydney in late May. A couple of days with these guys should prove fun and educational. These days we even have an informal organisation called The OakTable Network ( www.OakTable.net http://www.OakTable.net ) which, for instance, will have a booth at Oracle World in Copenhagen in June where you can ask anything you like, sit around my oak table, and drink beer (well, maybe not that :) ), listen to mini presentations by the guys, and so on. EoM (End of Marketing). PS: We'll also try to build the worlds biggest laptop RAC cluster. That's proving a challenge. So far, we've managed to run two nodes on the laptops, but then it becomes harder - much harder. But James, Jonathan and Bjorn are working on it. Wouldn't it be fun if anybody could bring their laptop, plug it in, be part of the RAC thing for some minutes, and then get a certificate stating that the person participated in the worlds biggest, etc...? Mogens Greg Moore wrote: Now where do I go for more Oracle training? Consider looking at the web sites of the Oracle DBA's who are up on the latest techniques. They sometimes teach advanced classes. Craig Shallahamer (www.orapub.com http://www.orapub.com) offers an advanced class, as does Cary Millsap. Steve Adams recently taught a class in San Francisco. Tim Gorman may give advanced classes. The latest and best thinking seems to appear first in papers that are freely available, and then later appears in books and classes. These four DBA's offer papers like that on their sites, and link to other sites with more of the same. After a certain point you have to turn to quality books, papers and conferences. If it's classes you want, a clever move might be to take some UNIX or === message truncated === __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.yahoo.com -- Please see the official
RH Linux 7.2/ Oracle 9i Books
We are an NT/2000 shop running Oracle Applications 11.5.3 on 8.1.7.2.1. All the DBA's here have cut their teeth on Oracle on NT/2000. Recently, we have committed to going with the Oracle 9i RAC configuration on Red Hat Linux (7.1 I think). With all this in mind, does anyone have any suggestions on some great Linux/Red Hat/Oracle on Linux books that could help us out? We're talking everything from Linux sysadmin to Oracle/Linux DBA. Any suggestions and personal experiences would be greatly appreciated. Thanks, Chuck -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Speaks, Chuck W. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle Developer/DBA Needed in Macon, Georgia-Local Candidates
Stable manufacturing firm in Macon, Georgia is looking for an Oracle developer who has some DBA functions as well. Oracle development is the key. If the candidate has strong development skills and is interested in doing some DBA functions and some knowledge of the functions, resumes would be welcomed. This is a full-time staff position. *Only candidates who live in the Macon and 285 loop area will be considered. No relocation is provided. Only sent a resume if you are in this area. ** No Sponsorship is available. DO NOT send your resume if you have H-1B status. *Candidates Need to have solid Oracle Forms, Reports, PL/SQL experience.. some DBA experience is highly preferred. Base salary is in the 70-80 K range. *U.S. citizenship or green card holders only PLEASE do not send your resume if you are not in the United States. For immediate consideration, please send your resume as an attachment to: Email: [EMAIL PROTECTED] Please use job code: One/Macon/Dev/DBA/Larson All inquiries held in confidence. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Just got back from SQL*Server 2000 training...
Maybe because I heard that Sybase finally implemented row-level locking. As of v10 (and I thought at least early 11 releases), the base unit of locking was the block. And that was the end of my 6-month stint programming with Sybase. Then there was that Interbase fiasco I had before being found by The Oracle... :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Monday, February 18, 2002 4:49 PM To: Multiple recipients of list ORACLE-L geez, that (and the truncate log problem) were there back when I worked with Sybase 4.7 they STILL haven't fixed those problems? WHY does anyone use this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: script to rename constraints
I don't have one, but would love to have one. ( hint, hint ) Jared On Tuesday 19 February 2002 03:28, John Dunn wrote: Anyone got a script that will drop table constraints which have system generated names and recreate them with names based upon the table name? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Email -- DB (export/parse)
Hi, Does anyone know of a utility that would allow me to export email, from say Outlook or Outlook Express, directly to a database or to a flat file (delimited) for import into a database? It doesn't need to be fancy, basically just date/time, to/from, subject, body. Thanks. -w __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Library Cache wait -- Who is holding this latch
Title: Message you'll have to take a library cache dump and look for the latch number displayed in the P1 Field of your query. HTH Greetings Diego Cutrone - Original Message - From: Gupta, Brijesh To: Multiple recipients of list ORACLE-L Sent: Friday, February 15, 2002 12:08 PM Subject: Library Cache wait -- Who is holding this latch Hi All I have a session which is waiting for Library Cache latch for 6 hours. How can I find who is holding this latch. This session is executing a pl/sql script ( Not package ). Latch# 60 is library cache latch. Here is from v$session_wait 1 select * from v$session_wait 2* where sid=1005PROD/Press Enter to Continue SID SEQ# EVENT P1TEXT --- --- -- -P1RAW P2TEXT P2 P2RAW --- -- Wait Sec inP3TEXT P3 P3RAW time Wait STATE --- -- 1005 5987 latch free address @99250701C0A5E228 number 60 003Ctries 0 00 -1 32,962 WAITED SHORT Thanks Brijesh Gupta Oracle Production DBA
Re: [Fwd: UNIX Performance Issues]
Title: Message James, Getting interesting, isn't it? I have added my response... - Original Message - From: James Morle To: Multiple recipients of list ORACLE-L Sent: Tuesday, February 19, 2002 8:58 AM Subject: RE: [Fwd: UNIX Performance Issues] Rahul, Here's what I would do. 1) I would use "mpstat" for the processor statistics. This breaks the usage up by processor in SMP configurations. This can be useful to see the relative loading of each CPU, in particular the breakdown of kernel and user time. 2) Memory: Concentrate on Page Outs and Free Memory more than anything else. That will give you plenty of clues about memory starvation, and the relevence of your VM tuning. 3) I/O: User "sar -d". It's a bit annoying on a system with a lot of disks, because it returns a row for every device, even if no I/O occurred in the sample period. However, it makes it easier to parse. ;-) Notably, keep an eye on the Service Times (avserv?), Wait times (avwait), and the queue depth. The utilisation is a function of these (queuing theory), but you can store that too as a shortcut. You can give sar any sample period, so your 5 minute averages are no problem. How can I get the current I/O load on the system? I don't know exactly what metric I am looking for. But I want to establish some baseline metric for each machine and then hunt for spikes from the gathered data. The metric can be "I/O load on system bus in Mb/sec" (like the netstat info packets input and output). I don't want individual disk statistics. I just want a overall number, which I can snapshot. 4) Network: "netstat 5" will report a row for every 5 seconds (for example), showing how many packets went in and out of each interface. Your question below is easily answered - you have two columns in your output; the first is for the named interface (hme0), the 100baseT network card. The second is a total of all cards - looks like you only have one. This total can also include the loopback interface (lo0), so look out for that. If I have only one card then why the total and hme0 data are different (by about 10%)? Good luck, you're doing the right thing. I've been working on some software to do just this for a couple of years. I'd love to hear how it goes! +Rahul Regards James --James MorleScale Abilities, Ltdhttp://www.scaleabilities.co.ukAuthor of "Scaling Oracle8i - Building Highly Scalable OLTP System Architectures" -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Rahul DandekarSent: 19 February 2002 12:59To: Multiple recipients of list ORACLE-LSubject: Re: [Fwd: UNIX Performance Issues] James, Interleaved, please find my reply +Rahul - Original Message - From: James Morle To: Multiple recipients of list ORACLE-L Sent: Tuesday, February 19, 2002 6:03 AM Subject: RE: [Fwd: UNIX Performance Issues] Rahul, Did you get a response on this? I'm not sure I fully understand the actual question - are you looking for specific commands you need to run to get the information, [Rahul] Yes. I would like to know which flags of the commonly used commands give good information. For general System stats, I use "sar -u" (same as default), for Memory / Virtual Memory I use "vmstat" and look for "r b w swap free pi po us sy id" columns. I am looking for general monitoring. And once we have this general information giving a overall picture, we could know if there is a problem and we could investigate further. I am specifically looking for IO and Network statistics. Is there any command which would give me approx IO of the system, say in last 5 minutes or current? How to get network statistics? I was littlebit confused with netstat. There are two main categories in my output : hme0 and Total. What does that mean? input hme0 output input (Total) outputpackets errs packets errs colls packets errs packets errs colls5757291 0 2447690 0 0 6071152 0 2761551 0 045 0 1 0 0 45 0 1 0 024 0 2 0 0 24 0 2 0 0 What I plan to do is to take snapshot of all these statistics at acertain frequency and put it in database.Later on I could generate reports based on this. Currently, I have a lot of "Camera"s like thistaking snapshots of my system. Others involveOracle stuff like DB Size Growth, Performance Ratios,UNIX File System usage, Replication Statistics, Growth of DB objects, a lot of monitors for application info (e.g. total # of clients, # of invoices generated per day). I generate trends based on this archival data
FW: rename foreign keys from system-assigned constraint names to
Here is something that was posted before - I haven't tried it so I don't know how well it works (if it does). -Original Message- Sent: Wednesday, August 08, 2001 4:23 PM To: Multiple recipients of list ORACLE-L more I just found this script on another site and thought this group would benefit from it, as we are always looking for usefult scripts... apologies if the formatting is bad. Here is a script that renames foreign keys from system-assigned constraint names to more intelligible names. The names use the current table name and the referenced table name. This greatly improves readability, especially for error messages. DECLARE c_owner CONSTANT VARCHAR2 (30):= 'FLEETPRO'; CURSOR cons_cur IS SELECT C.owner, C.constraint_name, C.table_name, TRANSLATE (C.table_name,'ABCDEFGHIJKLMNOPQRSTUVWXYZ_', 'ABCDEFGHIJKLMNOPQRSTUVWXYZ') as RTrimTable , CR.owner as ROwner, CR.constraint_name as RCName, CR.table_name as RTable, TRANSLATE (CR.table_name,'ABCDEFGHIJKLMNOPQRSTUVWXYZ_', 'ABCDEFGHIJKLMNOPQRSTUVWXYZ') as RtrimRTable FROM all_constraints C, all_constraints CR WHERE C.owner = 'FLEETPRO' AND C.owner = CR.owner AND C.constraint_type in ('R') AND UPPER(SUBSTR(C.constraint_name,1,3)) 'FK_' AND C.r_constraint_name = CR.constraint_name ORDER BY C.table_name,CR.table_name; -- AND rownum 50; cons_rec cons_cur%ROWTYPE; CURSOR col_curs IS SELECT column_name, position FROM all_cons_columns cc WHERE cc.owner = cons_rec.owner AND cc.constraint_name = cons_rec.constraint_name AND cc.table_name = cons_rec.table_name ORDER BY position; CURSOR col_R_curs IS SELECT column_name, position FROM all_cons_columns cc WHERE cc.owner = cons_rec.ROwner AND cc.constraint_name = cons_rec.RCname AND cc.table_name = cons_rec.RTable ORDER BY position; v_table_name all_constraints.table_name%type; v_Rtable_name all_constraints.table_name%type; v_ctr int; v_fklist VARCHAR2 (1000); v_fklist_R VARCHAR2 (1000); v_global_name VARCHAR2 (80); BEGIN OPEN cons_cur; v_table_name := NULL; v_Rtable_name := NULL; v_ctr := 0; LOOP FETCH cons_cur INTO cons_rec; EXIT WHEN cons_cur%NOTFOUND; v_fklist := NULL; v_fklist_R := NULL; FOR col_rec IN col_curs LOOP IF v_fklist IS NULL THEN v_fklist := '( ' || col_rec.column_name; ELSE v_fklist := v_fklist || ', ' || col_rec.column_name; END IF; END LOOP; FOR col_rec IN col_R_curs LOOP IF v_fklist_R IS NULL THEN v_fklist_R := '( ' || col_rec.column_name; ELSE v_fklist_R := v_fklist_R || ', ' || col_rec.column_name; END IF; END LOOP; IF ((v_table_name = cons_rec.table_name) AND (v_Rtable_name = cons_rec.Rtable)) THEN v_ctr := v_ctr + 1; Else v_ctr := 0; v_table_name := cons_rec.table_name; v_Rtable_name := cons_rec.Rtable; End If; v_fklist := v_fklist || ')'; v_fklist_R := v_fklist_R || ')'; DBMS_OUTPUT.put_line 'alter table ' || cons_rec.owner || '.' || cons_rec.table_name ); DBMS_OUTPUT.put_line 'drop constraint ' || cons_rec.constraint_name || ';' ); DBMS_OUTPUT.put_line 'alter table ' || cons_rec.owner || '.' || cons_rec.table_name ); IF v_ctr 0 THEN v_global_name := 'FK_' || cons_rec.table_name || '_' || cons_rec.RTable || to_char(v_ctr); ELSE v_global_name := 'FK_' || cons_rec.table_name || '_' || cons_rec.RTable; END IF; IF length( v_global_name ) 29 Then IF v_ctr 0 then v_global_name := 'FK_' || cons_rec.RtrimTable || '_' || cons_rec.RtrimRTable || to_char(v_ctr); ELSE v_global_name := 'FK_' || cons_rec.RtrimTable || '_' || cons_rec.RtrimRTable; END IF; END IF; DBMS_OUTPUT.put_line 'add constraint ' || v_global_name || ' foreign key ' || v_fklist ); DBMS_OUTPUT.put_line 'references ' || cons_rec.ROwner || '.' || cons_rec.Rtable || ' ' || v_fklist_R || ';' ); DBMS_OUTPUT.new_line (); END LOOP; END; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Fw: Just got back from SQL*Server 2000 training...
I sent this e-mail to a friend who works with SqlServer and he sent this to a SqlServer list as You can see from headers Here are comments of a member :- Gints Plivna IT Sistçmas, Meríeïa 13, LV1050 Rîga http://www.itsystems.lv/gints/ - Original Message - To: SQL 7 Discussions [EMAIL PROTECTED] Sent: Tuesday, February 19, 2002 5:29 PM My two cent's prefaced by . I'm not an Oracle expert, and my answers reflect my limited (5 years) experience as a DBA... *Row size cannot span multiple 8k pages, therefore max row size = 8k I've yet to see a properly designed database that needs more than this. Unless he/she doesn't understand that text/image data is stored separately *Cannot take DB out of archivelog mode. Can limit what is posted to txn log, but cannot stop it. Why would you want to? So you have the remote possibility of ending up with a corrupt, unrecoverable database if the power supply on the system fails? *Txn logs not mirrored. Must rely on RAID or other mirroring software. Hardware RAID/mirrors are much better than software, so if you are comparing Oracle software based mirrors to the hardware based ones we use then our way is much faster *Separate permissions for RI checking. Requires two permission grants if foreign key exists - one for child table and one for parent table. Called REFERENCES permission. No comment. Not sure what he's after here. *Recommended that ALL production objects owned by DBO - not conducive to multi-schema instances. This is just a best-practices item. It works both ways. I personnally find it easier to use Oracle when everything is owned by one user. *Activities that are restricted during backups: 1. Creating or modifying databases. 2. Performing autogrow operations. 3. Creating indexes. 4. Performing nonlogged operations. 5. Shrinking a database. I've not found this to be a limitation. How often do you actually do these tasks on a production database, anyways? Backups directly to tape require the tape to be attached locally to SQL Server. Okay, if you really want to transfer your 10+GB database over the network each night, I suppose you will need to use Oracle. *When txn log fills up, have to just truncate the log in order for processing to continue. Leaves system vulnerable until you get a full DB backup. Seems a little like disk space filling up in Oracle. How is this different? *If you have a 100GB DB that is full, your backup will be 100GB. No compression of backups! Valid point here. But I'd rather not trust my backup to a compression scheme anyways. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RedHat Linux 7.2 Oracle 9i Shutdown
Just an FYI, I was missing a link in the rc2.d directory for K00... script. In other flavors of unix, runlevel 2 was startup multiuser, didn't think it needed a kill link. Thanks to all for your help! Gene [EMAIL PROTECTED] 02/14/02 08:28AM [Gene Sais] Thank you. Not sure if it will work, but I was missing an K00... entry in rc2.d. I just linked it, lets see what happens on next bounce. FWIW, the right way to deal with these symlinks under RHL 7.2 is to have an /etc/init.d/whatever wrapper script that includes a comment section like this: #!/bin/sh # # pulse This script handles the starting and stopping of the various # clustering services in Red Hat Linux. # # chkconfig: - 60 10 # description: pulse is the controlling daemon that spawns off the lvs \ # daemon as well as heartbeating and monitoring of services \ # on the real servers. # processname: pulse # pidfile: /var/run/pulse.pid # config: /etc/lvs.cf Then you can just use the chkconfig / ntsysv / etc. interface for turning things on and off in various runlevels. The 2 chkconfig numbers are the symlink numbers (controlling order of execution) for startup and shutdown respectively. Much much easier, at least IMHO, than doing symlinks by hand. James -- James Manning [EMAIL PROTECTED] GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Manning INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Correction to: Oracle Developer/DBA Needed in Macon,
*Candidates not in the Macon area must be willing to relocate themselves: Stable manufacturing firm in Macon, Georgia is looking for an Oracle developer who has some DBA functions as well. Oracle development is the key. If the candidate has strong development skills and is interested in doing some DBA functions and some knowledge of the functions, resumes would be welcomed. This is a full-time staff position. ** No Sponsorship is available. DO NOT send your resume if you have H-1B status. *Candidates Need to have solid Oracle Forms, Reports, PL/SQL experience.. some DBA experience is highly preferred. Base salary is in the 70-80 K range. *U.S. citizenship or green card holders only PLEASE do not send your resume if you are not in the United States. For immediate consideration, please send your resume as an attachment to: Email: [EMAIL PROTECTED] Please use job code: one/Macon/Dev/DBA/Larson All inquiries held in confidence. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Just got back from SQL*Server 2000 training...
- Original Message - To: SQL 7 Discussions [EMAIL PROTECTED] Sent: Tuesday, February 19, 2002 5:29 PM *When txn log fills up, have to just truncate the log in order for processing to continue. Leaves system vulnerable until you get a full DB backup. Seems a little like disk space filling up in Oracle. How is this different? Interesting. When this happened to us Oracle-wise, I just moved the oldest archives to a mount point that did have enough room. Since we at least had enough forethought to incorporate several redo log groups, the DB never stopped. And since we never actually deleted any archive logs, we were never at great risk of permanent loss of data. Or we could have also duplexed the arches offsite, too. Because we all know that RAID controllers NEVER fail... Truncate the log. Yeah, right. Ya know, as much as I have whined about the way Oracle does some things (e.g. stupid-ass security-by-obscurity for DBAs and some wierd things with OiD), I still think it's the best yet available. Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to build an Oracle database from scratch
This topic comes up occasionally, some of you may find this article useful. http://dbasupport.com/oracle/ora9i/solutions/createDB.shtml Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Correction to: Oracle Developer/DBA Needed in Macon,
Deliverence.listen to those banjo's. -Original Message- Sent: Tuesday, February 19, 2002 10:49 AM To: Multiple recipients of list ORACLE-L *Candidates not in the Macon area must be willing to relocate themselves: Stable manufacturing firm in Macon, Georgia is looking for an Oracle developer who has some DBA functions as well. Oracle development is the key. If the candidate has strong development skills and is interested in doing some DBA functions and some knowledge of the functions, resumes would be welcomed. This is a full-time staff position. ** No Sponsorship is available. DO NOT send your resume if you have H-1B status. *Candidates Need to have solid Oracle Forms, Reports, PL/SQL experience.. some DBA experience is highly preferred. Base salary is in the 70-80 K range. *U.S. citizenship or green card holders only PLEASE do not send your resume if you are not in the United States. For immediate consideration, please send your resume as an attachment to: Email: [EMAIL PROTECTED] Please use job code: one/Macon/Dev/DBA/Larson All inquiries held in confidence. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Fw: Just got back from SQL*Server 2000 training...
Archivelog mode - I don't like putting test databases in archivelog mode. Or databases that are updated once a day. Redo logs are adequate to recover from a power system failure. Mirroring - The problem with relying on hardware mirroring is that it mirrors everything - corruption, delete commands, etc. I learned this one the hard way. Restricted activities- You probably don't have to do this stuff on small SQL Server databases. txn log - Oracle isn't vulnerable when you are backing up/deleting archive logs. single schema - Sounds like some applications that we have had to install, which were developed by lazy programmers who weren't concerned about security. You know, the ones that require a single user with full DBA rights. [EMAIL PROTECTED] 02/19/02 11:08AM I sent this e-mail to a friend who works with SqlServer and he sent this to a SqlServer list as You can see from headers Here are comments of a member :- Gints Plivna IT Sisttmas, Merfena 13, LV1050 Rega http://www.itsystems.lv/gints/ - Original Message - To: SQL 7 Discussions [EMAIL PROTECTED] Sent: Tuesday, February 19, 2002 5:29 PM My two cent's prefaced by . I'm not an Oracle expert, and my answers reflect my limited (5 years) experience as a DBA... *Row size cannot span multiple 8k pages, therefore max row size = 8k I've yet to see a properly designed database that needs more than this. Unless he/she doesn't understand that text/image data is stored separately *Cannot take DB out of archivelog mode. Can limit what is posted to txn log, but cannot stop it. Why would you want to? So you have the remote possibility of ending up with a corrupt, unrecoverable database if the power supply on the system fails? *Txn logs not mirrored. Must rely on RAID or other mirroring software. Hardware RAID/mirrors are much better than software, so if you are comparing Oracle software based mirrors to the hardware based ones we use then our way is much faster *Separate permissions for RI checking. Requires two permission grants if foreign key exists - one for child table and one for parent table. Called REFERENCES permission. No comment. Not sure what he's after here. *Recommended that ALL production objects owned by DBO - not conducive to multi-schema instances. This is just a best-practices item. It works both ways. I personnally find it easier to use Oracle when everything is owned by one user. *Activities that are restricted during backups: 1. Creating or modifying databases. 2. Performing autogrow operations. 3. Creating indexes. 4. Performing nonlogged operations. 5. Shrinking a database. I've not found this to be a limitation. How often do you actually do these tasks on a production database, anyways? Backups directly to tape require the tape to be attached locally to SQL Server. Okay, if you really want to transfer your 10+GB database over the network each night, I suppose you will need to use Oracle. *When txn log fills up, have to just truncate the log in order for processing to continue. Leaves system vulnerable until you get a full DB backup. Seems a little like disk space filling up in Oracle. How is this different? *If you have a 100GB DB that is full, your backup will be 100GB. No compression of backups! Valid point here. But I'd rather not trust my backup to a compression scheme anyways. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Weird ODBC Issue
On one instance, APPS owns the tables and SCOTT has select and has a synonym pointing at the table. On the other instance, SCOTT owns the table and there's no primary key defined. Just to be irritating, the latter instance shows the table, the former does not. Bambi. -Original Message- Sent: Monday, February 18, 2002 2:43 PM To: Multiple recipients of list ORACLE-L The user needs to have select permissions on the table. I'm assuming they are using the file,get external data, link tables and choosing ODBC data sources method to get to the data. Does the user APPS/APPS own the tables? Are there public synonyms on the tables? What ODBC driver are you using? I feel the Merant drivers are the best. From my experience any user trying to access the data this way was able to see all users.tablenames in the system but did not have authority to access them. Access needs to define unique keys to identify each record so it can update it. When attaching a table and there is no PK access will ask you to pick a number of columns that will make the record unique. Hope this helps. -Original Message- From: Bellows, Bambi [SMTP:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 12:35 PM To: Multiple recipients of list ORACLE-L Subject: Weird ODBC Issue I'm not exactly sure why, but I have a user who wants to see Oracle tables in Access. Whatever. So, the user can go into our pal SCOTT/TIGER no problem and look at tables from user_tables (not all_tables, which I find weird, but, what the hay). But, if the user tries to go into APPS/APPS, he can only see one table, and that one is owned by ADS. Anyone have similar problems? Any clue as to a resolution? Let me know... Yer pal, Bambi. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Fw: Just got back from SQL*Server 2000 training...
Well there is no arguement there if he is willing to live with all MS limitations by saying I don't expect to do this... I can live with this... blah blah... Rich From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Fw: Just got back from SQL*Server 2000 training... Date: Tue, 19 Feb 2002 08:08:21 -0800 I sent this e-mail to a friend who works with SqlServer and he sent this to a SqlServer list as You can see from headers Here are comments of a member :- Gints Plivna IT Sistçmas, Meríeïa 13, LV1050 Rîga http://www.itsystems.lv/gints/ - Original Message - To: SQL 7 Discussions [EMAIL PROTECTED] Sent: Tuesday, February 19, 2002 5:29 PM My two cent's prefaced by . I'm not an Oracle expert, and my answers reflect my limited (5 years) experience as a DBA... *Row size cannot span multiple 8k pages, therefore max row size = 8k I've yet to see a properly designed database that needs more than this. Unless he/she doesn't understand that text/image data is stored separately *Cannot take DB out of archivelog mode. Can limit what is posted to txn log, but cannot stop it. Why would you want to? So you have the remote possibility of ending up with a corrupt, unrecoverable database if the power supply on the system fails? *Txn logs not mirrored. Must rely on RAID or other mirroring software. Hardware RAID/mirrors are much better than software, so if you are comparing Oracle software based mirrors to the hardware based ones we use then our way is much faster *Separate permissions for RI checking. Requires two permission grants if foreign key exists - one for child table and one for parent table. Called REFERENCES permission. No comment. Not sure what he's after here. *Recommended that ALL production objects owned by DBO - not conducive to multi-schema instances. This is just a best-practices item. It works both ways. I personnally find it easier to use Oracle when everything is owned by one user. *Activities that are restricted during backups: 1. Creating or modifying databases. 2. Performing autogrow operations. 3. Creating indexes. 4. Performing nonlogged operations. 5. Shrinking a database. I've not found this to be a limitation. How often do you actually do these tasks on a production database, anyways? Backups directly to tape require the tape to be attached locally to SQL Server. Okay, if you really want to transfer your 10+GB database over the network each night, I suppose you will need to use Oracle. *When txn log fills up, have to just truncate the log in order for processing to continue. Leaves system vulnerable until you get a full DB backup. Seems a little like disk space filling up in Oracle. How is this different? *If you have a 100GB DB that is full, your backup will be 100GB. No compression of backups! Valid point here. But I'd rather not trust my backup to a compression scheme anyways. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oracle dba INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to build an Oracle database from scratch
Thanks for the good link. I wonder why the author is still using 7.3.x limitations when the URL is under 9i. Still very useful but probably needs revising. Rick Jared.Still@r adisys.com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: How to build an Oracle database from scratch com 02/19/2002 12:28 PM Please respond to ORACLE-L This topic comes up occasionally, some of you may find this article useful. http://dbasupport.com/oracle/ora9i/solutions/createDB.shtml Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: [Fwd: UNIX Performance Issues]
Title: Message Hi Rahul. Interesting, as ever! See below James --James MorleScale Abilities, Ltdhttp://www.scaleabilities.co.ukAuthor of "Scaling Oracle8i - Building Highly Scalable OLTP System Architectures" -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Rahul DandekarSent: 19 February 2002 15:49To: Multiple recipients of list ORACLE-LSubject: Re: [Fwd: UNIX Performance Issues] James, Getting interesting, isn't it? I have added my response... - Original Message - From: James Morle To: Multiple recipients of list ORACLE-L Sent: Tuesday, February 19, 2002 8:58 AM Subject: RE: [Fwd: UNIX Performance Issues] Rahul, Here's what I would do. 1) I would use "mpstat" for the processor statistics. This breaks the usage up by processor in SMP configurations. This can be useful to see the relative loading of each CPU, in particular the breakdown of kernel and user time. 2) Memory: Concentrate on Page Outs and Free Memory more than anything else. That will give you plenty of clues about memory starvation, and the relevence of your VM tuning. 3) I/O: User "sar -d". It's a bit annoying on a system with a lot of disks, because it returns a row for every device, even if no I/O occurred in the sample period. However, it makes it easier to parse. ;-) Notably, keep an eye on the Service Times (avserv?), Wait times (avwait), and the queue depth. The utilisation is a function of these (queuing theory), but you can store that too as a shortcut. You can give sar any sample period, so your 5 minute averages are no problem. How can I get the current I/O load on the system? I don't know exactly what metric I am looking for. But I want to establish some baseline metric for each machine and then hunt for spikes from the gathered data. The metric can be "I/O load on system bus in Mb/sec" (like the netstat info packets input and output). I don't want individual disk statistics. I just want a overall number, which I can snapshot. I know what you're after, but it's just not going to work that way! A network adapter is a single serial resource with a finite limit. An I/O subsystem is an arbitrarily complex *set* ofresources with a finitecapacity on each! For example, if you were to just measure the aggregate I/O rate across your SAN (or whatever), that may well return a good number. However, one disk in there could be assuming 50% or more of the load due to hotspots. This disk would probably be providing multi-SECOND response time, and because it's the hot disk, will be slowing nearly everything down. Your aggregate stats would not show this. You need per-disk, per-controller, and if you've got a very busy system you might want to start worrying about backplane capacity. There's no easy way to measure that one, however. 4) Network: "netstat 5" will report a row for every 5 seconds (for example), showing how many packets went in and out of each interface. Your question below is easily answered - you have two columns in your output; the first is for the named interface (hme0), the 100baseT network card. The second is a total of all cards - looks like you only have one. This total can also include the loopback interface (lo0), so look out for that. If I have only one card then why the total and hme0 data are different (by about 10%)? I suspect it is reporting the lo0interface in the total, but not showing it individually. Check out the options for netstat (I don't have Slowlaris in front of me right now). Good luck, you're doing the right thing. I've been working on some software to do just this for a couple of years. I'd love to hear how it goes! +Rahul Regards James --James MorleScale Abilities, Ltdhttp://www.scaleabilities.co.ukAuthor of "Scaling Oracle8i - Building Highly Scalable OLTP System Architectures" -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Rahul DandekarSent: 19 February 2002 12:59To: Multiple recipients of list ORACLE-LSubject: Re: [Fwd: UNIX Performance Issues] James, Interleaved, please find my reply +Rahul - Original Message - From: James Morle To: Multiple recipients of list ORACLE-L Sent: Tuesday, February 19, 2002 6:03 AM Subject: RE: [Fwd: UNIX Performance Issues] Rahul, Did you get a response on this? I'm not sure I fully understand the actual question - are you looking for specific commands you need to run to get the information, [Rahul] Yes. I
Re: FW: rename foreign keys from system-assigned constraint names to
Have you or anyone else on the list used this script? Successfully? More than once? Jared YTTRI Lisa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/19/02 08:43 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:FW: rename foreign keys from system-assigned constraint names to Here is something that was posted before - I haven't tried it so I don't know how well it works (if it does). -Original Message- Sent: Wednesday, August 08, 2001 4:23 PM To: Multiple recipients of list ORACLE-L more I just found this script on another site and thought this group would benefit from it, as we are always looking for usefult scripts... apologies if the formatting is bad. Here is a script that renames foreign keys from system-assigned constraint names to more intelligible names. The names use the current table name and the referenced table name. This greatly improves readability, especially for error messages. DECLARE c_owner CONSTANT VARCHAR2 (30):= 'FLEETPRO'; CURSOR cons_cur IS SELECT C.owner, C.constraint_name, C.table_name, TRANSLATE (C.table_name,'ABCDEFGHIJKLMNOPQRSTUVWXYZ_', 'ABCDEFGHIJKLMNOPQRSTUVWXYZ') as RTrimTable , CR.owner as ROwner, CR.constraint_name as RCName, CR.table_name as RTable, TRANSLATE (CR.table_name,'ABCDEFGHIJKLMNOPQRSTUVWXYZ_', 'ABCDEFGHIJKLMNOPQRSTUVWXYZ') as RtrimRTable FROM all_constraints C, all_constraints CR WHERE C.owner = 'FLEETPRO' AND C.owner = CR.owner AND C.constraint_type in ('R') AND UPPER(SUBSTR(C.constraint_name,1,3)) 'FK_' AND C.r_constraint_name = CR.constraint_name ORDER BY C.table_name,CR.table_name; -- AND rownum 50; cons_rec cons_cur%ROWTYPE; CURSOR col_curs IS SELECT column_name, position FROM all_cons_columns cc WHERE cc.owner = cons_rec.owner AND cc.constraint_name = cons_rec.constraint_name AND cc.table_name = cons_rec.table_name ORDER BY position; CURSOR col_R_curs IS SELECT column_name, position FROM all_cons_columns cc WHERE cc.owner = cons_rec.ROwner AND cc.constraint_name = cons_rec.RCname AND cc.table_name = cons_rec.RTable ORDER BY position; v_table_name all_constraints.table_name%type; v_Rtable_name all_constraints.table_name%type; v_ctr int; v_fklist VARCHAR2 (1000); v_fklist_R VARCHAR2 (1000); v_global_name VARCHAR2 (80); BEGIN OPEN cons_cur; v_table_name := NULL; v_Rtable_name := NULL; v_ctr := 0; LOOP FETCH cons_cur INTO cons_rec; EXIT WHEN cons_cur%NOTFOUND; v_fklist := NULL; v_fklist_R := NULL; FOR col_rec IN col_curs LOOP IF v_fklist IS NULL THEN v_fklist := '( ' || col_rec.column_name; ELSE v_fklist := v_fklist || ', ' || col_rec.column_name; END IF; END LOOP; FOR col_rec IN col_R_curs LOOP IF v_fklist_R IS NULL THEN v_fklist_R := '( ' || col_rec.column_name; ELSE v_fklist_R := v_fklist_R || ', ' || col_rec.column_name; END IF; END LOOP; IF ((v_table_name = cons_rec.table_name) AND (v_Rtable_name = cons_rec.Rtable)) THEN v_ctr := v_ctr + 1; Else v_ctr := 0; v_table_name := cons_rec.table_name; v_Rtable_name := cons_rec.Rtable; End If; v_fklist := v_fklist || ')'; v_fklist_R := v_fklist_R || ')'; DBMS_OUTPUT.put_line 'alter table ' || cons_rec.owner || '.' || cons_rec.table_name ); DBMS_OUTPUT.put_line 'drop constraint ' || cons_rec.constraint_name || ';' ); DBMS_OUTPUT.put_line 'alter table ' || cons_rec.owner || '.' || cons_rec.table_name ); IF v_ctr 0 THEN v_global_name := 'FK_' || cons_rec.table_name || '_' || cons_rec.RTable || to_char(v_ctr); ELSE v_global_name := 'FK_' || cons_rec.table_name || '_' || cons_rec.RTable; END IF; IF length( v_global_name ) 29 Then IF v_ctr 0 then v_global_name := 'FK_' || cons_rec.RtrimTable || '_' || cons_rec.RtrimRTable || to_char(v_ctr); ELSE v_global_name := 'FK_' || cons_rec.RtrimTable || '_' || cons_rec.RtrimRTable; END IF; END IF; DBMS_OUTPUT.put_line 'add constraint ' || v_global_name || ' foreign key ' || v_fklist ); DBMS_OUTPUT.put_line 'references ' || cons_rec.ROwner || '.' ||
Re: Fw: Just got back from SQL*Server 2000 training...
Couldn't resist responding to this. *Cannot take DB out of archivelog mode. Can limit what is posted to txn log, but cannot stop it. Why would you want to? So you have the remote possibility of ending up with a corrupt, unrecoverable database if the power supply on the system fails? JS: Taking a database out of archive mode is certainly valid for large load operations. Let's see, I want to load 50 gig of raw data into my data warehouse tonight, that will generate about 800 gig of redo. Do I really want to do generate that much redo, deal with the overhead, and back it up besides? Or would it be easier to put the DW back in archive mode and back up the new data? *Txn logs not mirrored. Must rely on RAID or other mirroring software. Hardware RAID/mirrors are much better than software, so if you are comparing Oracle software based mirrors to the hardware based ones we use then our way is much faster JS: No mention of reliability there though is there? If I don't have control over the hardware layout, I want Oracle to mirror the logs, period. Backups directly to tape require the tape to be attached locally to SQL Server. Okay, if you really want to transfer your 10+GB database over the network each night, I suppose you will need to use Oracle. JS: 10+GB over the network is trivial. If you are using anything that approaches enterprise level backups, you will dedicate some fast pipes to your network attached tape system. This means that if you're using for instance Tivoli with a StorageTek Tape Silo,you must copy it first to disk, since you're not going to have direct access. Making backups to disk first tends to break any Oracle specific tape cataloging system ( RMAN for instance ) so that files must be located manually in case of a restore. *When txn log fills up, have to just truncate the log in order for processing to continue. Leaves system vulnerable until you get a full DB backup. Seems a little like disk space filling up in Oracle. How is this different? JS: This is a poor analogy. It isn't like disk space filling up in Oracle. The only disk likely to fill up is the archive log destination, and if you're doing your job as a DBA, that won't happen. I've been to DBA class for Sybase, which has the identical mechanism for transaction logging. It's crude and vulnerable. *If you have a 100GB DB that is full, your backup will be 100GB. No compression of backups! Valid point here. But I'd rather not trust my backup to a compression scheme anyways. Then you must not be backing up to tape, as all tape drive systems use built in compression. The I don't trust compression complaint is a red herring. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Disable certain users from login to database while applying H
1. Database ON LOGON Trigger = don't know whether it will work Have you tried this? It absolutely will work, and would be easier to use and administer. Jared CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/19/02 01:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Disable certain users from login to database while applying H Hi Gurus, Thanks for replying to my qn. Startup Database in Restricted mode will not work (for more details, pls refer to the email below). The following solutions : 1. Database ON LOGON Trigger = don't know whether it will work 2. Lock Database Account = I am going to use this solution. 3. Change Database Account Password = I believe it will work In our Oracle HR, we also support oracle client-server forms/reports, so I've to disable their accounts so that they do not access the HR database using sqlplus/forms/reports while I am applying patches. Regds, Catherine -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 2:13 PM To: Multiple recipients of list ORACLE-L Subject:Re: Disable certain users from login to database while applying Human As you are talking of Oracle Apps, NONE of the suggested solutions : 1. Database ON LOGON Trigger 2. Lock Database Account 3. Change Database Account Password 4. Startup Database in Restricted mode would work. The users connect to the Database in the APPS schema -- this is the universal schema that Oracle Apps uses. The Patch requires APPS so Restricted doesn't help (unless you grant Restricted to APPS in which case all the users can logon). Ditto about locking, changing password or writing a trigger on the APPS schema. What you can do are : 1. Shutdown the Apache server for the Self-Service Modules 2. Shutdown the Forms server for the Forms Module 3. Shutdown the Concurrent Managers. All of the above would affect ALL users. Alternatively, login to the Application as the System Administrator user and change the Application User Passwords for the users whom you want disabled. Change the passwords back to a default (WELCOME) later. However, what you SHOULD do, per Oracle Support, is 1. Shutdown 2. Shutdown 3. Shutdown as I have listed above. If you are familiar with Oracle Applications Patching and are comfortable with reading the Patch drivers, you can figure out what database objects are being modified/updated/created and what Forms/Reports/HTML etc files are being modified/created by the patch. Then you can take an intelligent decision should you allow users to logon when applying the patch ? Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED] 18/02/2002 03:28 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Disable certain users from login to database while applying Human Hi Gurus, I need to disable certain
Re: Rollback Segments
Man, I remember those days. When I talk to teenagers about having actually worked with such machines, I get a deeper appreciation for the word 'old'. And you actually had a 20MB hard drive. *sigh* On Monday 18 February 2002 06:23 pm, you wrote: I do. User Friendly Interface. Hush, don't tell anybody, but I started with Oracle 4 on PC/XT with a huge, 20MB Winchester hard drive. The whole machine has had a Hercules screen card (text only, no graphics) and 512KB (no, it's not a mistake, it really is the letter K) of memory. I still have those 3 big, grey boxes with 5 5.25 floppies which used to contain the whole installation. Unfortunately, I cannot install it because I no longer have DOS 3.3 which was required for Oracle 4. Oh well, I seem to be getting old. -Original Message- Sent: Monday, February 18, 2002 1:59 PM To: Multiple recipients of list ORACLE-L Holy cow Mladen, what a memory! Does anybody else remember (or admit to) using UFI? Jim ** ...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?... -- Dwayne Cox[EMAIL PROTECTED] DBA, Development Department, Info Tech, Inc. 5700 SW 34th Street, Suite 1235 phone: (352) 381.4521 Gainesville, FL 32608 fax: (352) 381. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dwayne Cox INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Email -- DB (export/parse)
I believe Netscape have a utility to convert Outlook datafiles to 'mbox' format, which is more easily parsed. James -- James Morle Scale Abilities, Ltd http://www.scaleabilities.co.uk Author of Scaling Oracle8i - Building Highly Scalable OLTP System Architectures -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Walter K Sent: 19 February 2002 16:18 To: Multiple recipients of list ORACLE-L Subject: Email -- DB (export/parse) Hi, Does anyone know of a utility that would allow me to export email, from say Outlook or Outlook Express, directly to a database or to a flat file (delimited) for import into a database? It doesn't need to be fancy, basically just date/time, to/from, subject, body. Thanks. -w __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: James Morle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Fw: Just got back from SQL*Server 2000 training...
We run a couple of production systems in noarchivelog. This is due to how they operate. They are reporting datamarts and the nightly loads would generate way to much redo to contain. Since all the data originates elsewhere recovery just means redoing a load. Any OLTP should be in archivelog. If you run out of space roll the old archives off to tape and delete from the filesystem. This is no where near the comparison of truncating the txn log. If you need an old log you can still get it back. Single schema?? Depends on the application and its operation. We run multiple schemas on some of our databases and single schema on others. It's a matter of separating different apps or app functions from others. When it makes sense do it. When it doesn't don't. That's why we are DBA's to direct the deveolpers in how these things should be handled. Rodd On Tue, 2002-02-19 at 11:38, Jay Hostetter wrote: Archivelog mode - I don't like putting test databases in archivelog mode. Or databases that are updated once a day. Redo logs are adequate to recover from a power system failure. Mirroring - The problem with relying on hardware mirroring is that it mirrors everything - corruption, delete commands, etc. I learned this one the hard way. Restricted activities- You probably don't have to do this stuff on small SQL Server databases. txn log - Oracle isn't vulnerable when you are backing up/deleting archive logs. single schema - Sounds like some applications that we have had to install, which were developed by lazy programmers who weren't concerned about security. You know, the ones that require a single user with full DBA rights. [EMAIL PROTECTED] 02/19/02 11:08AM I sent this e-mail to a friend who works with SqlServer and he sent this to a SqlServer list as You can see from headers Here are comments of a member :- Gints Plivna IT Sisttmas, Merfena 13, LV1050 Rega http://www.itsystems.lv/gints/ - Original Message - To: SQL 7 Discussions [EMAIL PROTECTED] Sent: Tuesday, February 19, 2002 5:29 PM My two cent's prefaced by . I'm not an Oracle expert, and my answers reflect my limited (5 years) experience as a DBA... *Row size cannot span multiple 8k pages, therefore max row size = 8k I've yet to see a properly designed database that needs more than this. Unless he/she doesn't understand that text/image data is stored separately *Cannot take DB out of archivelog mode. Can limit what is posted to txn log, but cannot stop it. Why would you want to? So you have the remote possibility of ending up with a corrupt, unrecoverable database if the power supply on the system fails? *Txn logs not mirrored. Must rely on RAID or other mirroring software. Hardware RAID/mirrors are much better than software, so if you are comparing Oracle software based mirrors to the hardware based ones we use then our way is much faster *Separate permissions for RI checking. Requires two permission grants if foreign key exists - one for child table and one for parent table. Called REFERENCES permission. No comment. Not sure what he's after here. *Recommended that ALL production objects owned by DBO - not conducive to multi-schema instances. This is just a best-practices item. It works both ways. I personnally find it easier to use Oracle when everything is owned by one user. *Activities that are restricted during backups: 1. Creating or modifying databases. 2. Performing autogrow operations. 3. Creating indexes. 4. Performing nonlogged operations. 5. Shrinking a database. I've not found this to be a limitation. How often do you actually do these tasks on a production database, anyways? Backups directly to tape require the tape to be attached locally to SQL Server. Okay, if you really want to transfer your 10+GB database over the network each night, I suppose you will need to use Oracle. *When txn log fills up, have to just truncate the log in order for processing to continue. Leaves system vulnerable until you get a full DB backup. Seems a little like disk space filling up in Oracle. How is this different? *If you have a 100GB DB that is full, your backup will be 100GB. No compression of backups! Valid point here. But I'd rather not trust my backup to a compression scheme anyways. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Re: RH Linux 7.2/ Oracle 9i Books
- Original Message - With all this in mind, does anyone have any suggestions on some great Linux/Red Hat/Oracle on Linux books that could help us out? We're talking everything from Linux sysadmin to Oracle/Linux DBA. Any suggestions and personal experiences would be greatly appreciated. check out http://www.redhat.com/docs/manuals/linux/ , u'll get 1000+ pages of manuals and books the 9i installation used to fail for RH 7.2 few months ago because of a conflict with one of the packages shipped with it, check Metalink for the resolution hth, Marin ...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Fw: Just got back from SQL*Server 2000 training...
Sounds like the M$ Brainwashing has taken root. :-) John [EMAIL PROTECTED] wrote: Well there is no arguement there if he is willing to live with all MS limitations by saying I don't expect to do this... I can live with this... blah blah... Rich From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Fw: Just got back from SQL*Server 2000 training... Date: Tue, 19 Feb 2002 08:08:21 -0800 I sent this e-mail to a friend who works with SqlServer and he sent this to a SqlServer list as You can see from headers Here are comments of a member :- Gints Plivna IT Sistçmas, Meríeïa 13, LV1050 Rîga http://www.itsystems.lv/gints/ - Original Message - To: SQL 7 Discussions [EMAIL PROTECTED] Sent: Tuesday, February 19, 2002 5:29 PM My two cent's prefaced by . I'm not an Oracle expert, and my answers reflect my limited (5 years) experience as a DBA... *Row size cannot span multiple 8k pages, therefore max row size = 8k I've yet to see a properly designed database that needs more than this. Unless he/she doesn't understand that text/image data is stored separately *Cannot take DB out of archivelog mode. Can limit what is posted to txn log, but cannot stop it. Why would you want to? So you have the remote possibility of ending up with a corrupt, unrecoverable database if the power supply on the system fails? *Txn logs not mirrored. Must rely on RAID or other mirroring software. Hardware RAID/mirrors are much better than software, so if you are comparing Oracle software based mirrors to the hardware based ones we use then our way is much faster *Separate permissions for RI checking. Requires two permission grants if foreign key exists - one for child table and one for parent table. Called REFERENCES permission. No comment. Not sure what he's after here. *Recommended that ALL production objects owned by DBO - not conducive to multi-schema instances. This is just a best-practices item. It works both ways. I personnally find it easier to use Oracle when everything is owned by one user. *Activities that are restricted during backups: 1. Creating or modifying databases. 2. Performing autogrow operations. 3. Creating indexes. 4. Performing nonlogged operations. 5. Shrinking a database. I've not found this to be a limitation. How often do you actually do these tasks on a production database, anyways? Backups directly to tape require the tape to be attached locally to SQL Server. Okay, if you really want to transfer your 10+GB database over the network each night, I suppose you will need to use Oracle. *When txn log fills up, have to just truncate the log in order for processing to continue. Leaves system vulnerable until you get a full DB backup. Seems a little like disk space filling up in Oracle. How is this different? *If you have a 100GB DB that is full, your backup will be 100GB. No compression of backups! Valid point here. But I'd rather not trust my backup to a compression scheme anyways. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: orantdba INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Fw: Just got back from SQL*Server 2000 training...
See below... Backups directly to tape require the tape to be attached locally to SQL Server. Okay, if you really want to transfer your 10+GB database over the network each night, I suppose you will need to use Oracle. JS: 10+GB over the network is trivial. If you are using anything that approaches enterprise level backups, you will dedicate some fast pipes to your network attached tape system. This means that if you're using for instance Tivoli with a StorageTek Tape Silo,you must copy it first to disk, since you're not going to have direct access. Making backups to disk first tends to break any Oracle specific tape cataloging system ( RMAN for instance ) so that files must be located manually in case of a restore. I think the real key is that the value of 10GB is quoted as an extreme example! Just affirms my opinion that SQL-Server is where Oracle was over 10 years ago James -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Morle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Email -- DB (export/parse)
Check out Import/Export feature of MS Outlook (File- Import and Export). I believe there is an option to export Outlook items to a .csv format file. I have not used it, as this feature is not installed on my PC but the online Help describes what it does. HTH, - Kirti -Original Message- Sent: Tuesday, February 19, 2002 10:18 AM To: Multiple recipients of list ORACLE-L Hi, Does anyone know of a utility that would allow me to export email, from say Outlook or Outlook Express, directly to a database or to a flat file (delimited) for import into a database? It doesn't need to be fancy, basically just date/time, to/from, subject, body. Thanks. -w __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle Licensing - Concurrent users
We have been asked to gather statistics on the number of clients using Oracle. This is being done to determine if we have sufficient licensing. We have about 100 instances to monitor. Has anyone done this? Any ideas on what Concurrent users might mean to the majority of people? We have both Oracle 7 and Oracle 8. Ron Smith DBA Kerr-McGee Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rollback Segments
Bjorn, you old coot, you've got me beat. I do remember the UFI prompt though... User Friendly Interface... and the real geeks would program their own SQL*Plus environment using HLI (now OCI) with the OROL option which would allow the rollback of a single statement rather than a whole transaction. Now, in my day, we had fire but we had to make our own coal and we kept warm on the hides of old terminals that used to roam the plains. What were things like in your day? Bambi. -Original Message- Sent: Tuesday, February 19, 2002 5:23 AM To: Multiple recipients of list ORACLE-L There must be somebody beside myself remembering version 3, which did not have read consistency - the great new feature of version 4. In 3, doing UFI insert into emp select * from emp; would cause anything from having 28 rows in emp till having and endless loop in the kernel only finishing when your database file ran full... Yep - we are some old bitter men around here... /Bjørn. On Tuesday 19 February 2002 06:43, you wrote: I remember the BI.ORA (Before-Image) file, IOR and ODS in Oracle 5. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Rachel Carmichael [EMAIL PROTECTED] 19/02/2002 06:18 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: RE: Rollback Segments UFI no, but the rest... that's where I started in Oracle -- version 5 --- Conboy, Jim [EMAIL PROTECTED] wrote: Holy cow Mladen, what a memory! Does anybody else remember (or admit to) using UFI? Jim ** ...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: =?iso-8859-1?q?Bj=F8rn=20Engsig?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rollback Segments
SQL*Menu wasn't around in V5. IAP/IAG were there, and IAD came out in v5.1 (it was the first of the SQL*Forms). RPT/RPF were there too. And there was something called SQL*Calc which I never used (cuz you could do anything you wanted off of the DUAL table, so why bother with anything else). Now, in IAP, you could put in a %SW in the middle of the questions and IAG, while it was generating, would stop and ask you questions interactively until you entered %SW to have it return to the script. It was a handy way to add fields. User exits were the other big change with v5.1. Prior to that, you could specify any procedure of a C program linked with the form; afterwards, you had to use IAPXIT. Well, enough talking about the good old days. I'm off to do an applications upgrade on a production machine. See you some time next week. ;) Bambi (the geezer). -Original Message- Sent: Tuesday, February 19, 2002 1:43 AM To: Multiple recipients of list ORACLE-L How about iag/iap ? And rpt ? Oh and SQL*Menu ? And there were about 14 enqueue/locks in Oracle Version 5 as far as I can remember. Anjo Kolk Brings back memories of joining Oracle Europe in 1985 ;-) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, February 19, 2002 6:43 AM I remember the BI.ORA (Before-Image) file, IOR and ODS in Oracle 5. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Rachel Carmichael [EMAIL PROTECTED] 19/02/2002 06:18 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: RE: Rollback Segments UFI no, but the rest... that's where I started in Oracle -- version 5 --- Conboy, Jim [EMAIL PROTECTED] wrote: Holy cow Mladen, what a memory! Does anybody else remember (or admit to) using UFI? Jim ** ...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --
Re: Library Cache wait -- Who is holding this latch
You shouldn't need to do that. To find out who the holders are of all latches currently being aited on by ithers you could do SELECT lh.sid, ln.name, sq.sql_text FROM v$latchholder lh, v$sqlarea sq, v$session se, v$session_wait sw, v$latchname ln WHERE sw.event = 'latch free' AND sw.p1raw = lh.laddr AND ln.latch# = sw.p2 AND se.sid = lh.sid AND se.sql_address = sq.address AND se.sql_hash_value = sq.hash_value // George Schlossnagle // Principal Consultant // OmniTI, Inc http://www.omniti.com // (c) 301.343.6422 (e) [EMAIL PROTECTED] // 1024D/1100A5A0 1370 F70A 9365 96C9 2F5E 56C2 B2B9 262F 1100 A5A0 On Tuesday, February 19, 2002, at 11:28 AM, Diego Cutrone wrote: you'll have to take a library cache dump and look for the latch number displayed in the P1 Field of your query. HTH Greetings Diego Cutrone - Original Message - From: Gupta, Brijesh To: Multiple recipients of list ORACLE-L Sent: Friday, February 15, 2002 12:08 PM Subject: Library Cache wait -- Who is holding this latch Hi All I have a session which is waiting for Library Cache latch for 6 hours. How can I find who is holding this latch. This session is executing a pl/sql script ( Not package ). Latch# 60 is library cache latch. Here is from v$session_wait 1 select * from v$session_wait 2* where sid=1005 PROD>/ Press Enter to Continue SID SEQ# EVENT P1TEXT --- --- -- - P1RAW P2TEXT P2 P2RAW --- -- Wait Sec in P3TEXT P3 P3RAW time Wait STATE --- -- 1005 5987 latch free address @9925 0701C0A5E228 number 60 003C tries 0 00 -1 32,962 WAITED SHORT Thanks Brijesh Gupta Oracle Production DBA
Re: RedHat Linux 7.2 Oracle 9i Shutdown
- Original Message - Just an FYI, I was missing a link in the rc2.d directory for K00... script. In other flavors of unix, runlevel 2 was startup multiuser, didn't think it needed a kill link. Thanks to all for your help! I don't think u need to kill oracle (K?? link) when u enter runlevel 2 - u have to do it only for runlevels 0 and 6 (and eventually for 1). when the system enters a runlevel (e.g. level 2) it first executes K?? scripts and then S?? scripts. The K?? scripts are executed only for the components that are already running (i.e. started by S?? scripts in the previous runlevel, such components are recognized by scanning the /var/lock/subsys directory) so even if u place the kill script for Oracle in the directory for runlevel 2 it will not be executed since Oracle was not started yet (if runlevel 2 is the default level for your system, it is the first level being entered) and yes, runlevel 2 is the multiuser startup hth, Marin ...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Rollback Segments
Bjørn - I remember the joys of Version 3. There was also the fun screen generator program where you had to decide where everything was going by using its character position and you had to enter that by hand. The first pass at most screens was interesting. One of the users referred to UFI as User Surly Interface Ben Schilling -Original Message- Sent: Tuesday, February 19, 2002 1:19 PM To: Multiple recipients of list ORACLE-L Bjorn, you old coot, you've got me beat. I do remember the UFI prompt though... User Friendly Interface... and the real geeks would program their own SQL*Plus environment using HLI (now OCI) with the OROL option which would allow the rollback of a single statement rather than a whole transaction. Now, in my day, we had fire but we had to make our own coal and we kept warm on the hides of old terminals that used to roam the plains. What were things like in your day? Bambi. -Original Message- Sent: Tuesday, February 19, 2002 5:23 AM To: Multiple recipients of list ORACLE-L There must be somebody beside myself remembering version 3, which did not have read consistency - the great new feature of version 4. In 3, doing UFI insert into emp select * from emp; would cause anything from having 28 rows in emp till having and endless loop in the kernel only finishing when your database file ran full... Yep - we are some old bitter men around here... /Bjørn. On Tuesday 19 February 2002 06:43, you wrote: I remember the BI.ORA (Before-Image) file, IOR and ODS in Oracle 5. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Rachel Carmichael [EMAIL PROTECTED] 19/02/2002 06:18 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: RE: Rollback Segments UFI no, but the rest... that's where I started in Oracle -- version 5 --- Conboy, Jim [EMAIL PROTECTED] wrote: Holy cow Mladen, what a memory! Does anybody else remember (or admit to) using UFI? Jim ** ...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: =?iso-8859-1?q?Bj=F8rn=20Engsig?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed
Re: Oracle Licensing - Concurrent users
Ron, It is funny you mentioned this, just last week our corporate office asked us to run a script...provided by Oracle...to gather user/session information to determine if we have enough licences. The thing that I found odd, was that they wanted this information from every single database including all development, test, stress, production, and crash burn. I have never heard of Oracle doing this before...we thought maybe management was trying to determine if we have enough work to do :) I am glad to hear that we are not the only ones being asked for this information. Below are the requirements we were asked to follow. 1. The DBA's must provide the 5 critical pieces of info( for each database) necessary in order to start our licensing auditing: Server name (must be in DNS) Database Name Connect String Oracle Version Application Type 2. DBA's must create a user LMS on each database to be monitored. The enclosed script must be run in order to create a LMS user. We will modify our TNSNAMES.ora to remotely access this information from the information on the OSW worksheet that is returned. 3. DBA's must add this process to create the LMS user give Corporate access to monitor new databases on a on-going basis in order for RRD to comply with Oracle licensing agreements. Traci L. Rebman Oracle Database Administrator R.R. Donnelley Sons Financial Smith, Ron L. To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc: om Subject: Oracle Licensing - Concurrent users Sent by: [EMAIL PROTECTED] om 02/19/2002 02:14 PM Please respond to ORACLE-L We have been asked to gather statistics on the number of clients using Oracle. This is being done to determine if we have sufficient licensing. We have about 100 instances to monitor. Has anyone done this? Any ideas on what Concurrent users might mean to the majority of people? We have both Oracle 7 and Oracle 8. Ron Smith DBA Kerr-McGee Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Developer Interview Questions? - Thanks!
Between all your suggestions and what I'd put together already I think I'm ready for him :). Jay Miller -Original Message- Sent: Friday, February 15, 2002 5:22 PM To: Multiple recipients of list ORACLE-L In addition to SQL tuning, the prospective employee should know what cursor variables are, bind variables, and the advantages of using them. The hopeful candidate should also know how to minimize opening cursors through reuse, or at least not look like a scared deer in the headlights when asked about it. Excellent paper on this by Bjorn Engsig at http://otn.oracle.com/deploy/performance Jared John Kanagaraj [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/15/02 01:38 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Developer Interview Questions? Jay, I would feel that PL/SQL tuning is the same as SQL tuning. Just pull out one of your complicated Explain Plan or TKProf outputs and ask the Interviewee (is there such a word?) to explain the meaning. Also quiz him/her about the various joins and the approach he/she would take when a DBA/User complains of a slow query - If 'trace file', 'tkprof' and 'explain plan' don't appear in the answer, then you may as well stop the interview :) John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Grace - Getting something we don't deserve Mercy - NOT getting something we deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: Miller, Jay [mailto:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 10:14 AM To: Multiple recipients of list ORACLE-L Subject: Developer Interview Questions? I've been asked to conduct a technical interview for a new PL/SQL developer, with an emphasis on performance tuning issues (which is why I'm doing it instead of one of the existing developers who seem to have some difficulty with the idea of running something through Explain Plan before sending it to me to go into production - I usually do all the SQL tuning). I've put together a few things but wondered if anyone could point me to a document with some good interview questions (I've only conducted DBA technical interviews in the past). Thanks! Jay Miller x48355 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from).
Re: Oracle Licensing - Concurrent users
I suggest you talk to your Oracle rep before getting started. 'Concurrent' licensing is no longer a valid licensing model for Oracle. They sell by named user or per CPU. Their criteria for making you use the CPU licensing is rather broad. Just went through a licensing audit here. Lots o fun, let me tell you. While on the subject, does anyone have a good app/spreadsheet or template of some kind for tracking Oracle license use? It needs to track EE and Std versions, named and CPU licenses, servers, databases on the servers, users on the databases. I've cobbled my own stuff together from bits of string and baling wire, but I'm getting tired of messing with modifying SQL everytime I want a different view of the data, or to see if I can squeeze another app in without licensing more users. Thanks, Jared Smith, Ron L. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/19/02 11:14 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Oracle Licensing - Concurrent users We have been asked to gather statistics on the number of clients using Oracle. This is being done to determine if we have sufficient licensing. We have about 100 instances to monitor. Has anyone done this? Any ideas on what Concurrent users might mean to the majority of people? We have both Oracle 7 and Oracle 8. Ron Smith DBA Kerr-McGee Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Rollback Segments
I had a Hercules card too. I needed it to play some RPG game. Funny how many geeks had amber. I was so sick of the green on the VT and Vulcan boxes, I would sniff around for a tvi912c or tvi925 with it's baby blue. And then, of course the VT2xx series came out with its amber and everything was terrific. When I finally got off of VAXes, I was up to something like a VT460 only to go into Unix and set my TERM=vt100. How Neolithic. Pass the arthritis cream. Bambi. -Original Message- Sent: Tuesday, February 19, 2002 8:28 AM To: Multiple recipients of list ORACLE-L Actually, the Hercules graphics is able to generate graphics. I had to settle for Hercules since I could not afford a color monitor(using a CGA card) back then. So I looked for games, etc. that had a Hercules graphics mode. And, Hercules used twice the amount of pixels then CGA did, so I was able to find emulation software that allowed me to play CGA color games on my Hercules card. It replaced the limited CGA color pallete with patterns on the amber monitor. Sigh. The good old days... -Original Message- Sent: Monday, February 18, 2002 6:24 PM To: Multiple recipients of list ORACLE-L I do. User Friendly Interface. Hush, don't tell anybody, but I started with Oracle 4 on PC/XT with a huge, 20MB Winchester hard drive. The whole machine has had a Hercules screen card (text only, no graphics) and 512KB (no, it's not a mistake, it really is the letter K) of memory. I still have those 3 big, grey boxes with 5 5.25 floppies which used to contain the whole installation. Unfortunately, I cannot install it because I no longer have DOS 3.3 which was required for Oracle 4. Oh well, I seem to be getting old. -Original Message- Sent: Monday, February 18, 2002 1:59 PM To: Multiple recipients of list ORACLE-L Holy cow Mladen, what a memory! Does anybody else remember (or admit to) using UFI? Jim ** ...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rollback Segments
[EMAIL PROTECTED] wrote: SQL*Menu wasn't around in V5. IAP/IAG were there, and IAD came out in v5.1 (it was the first of the SQL*Forms). RPT/RPF were there too. And there was something called SQL*Calc which I never used (cuz you could do anything you i had to do a bunch with SQL*Calc because damagement understood Lotus123. it was less than enjoyable.;-) -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. Avoid temporary variables and strange women. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Solaris Kernel Memory Parameters Recommendations?
Ive read a couple of brief passages about setting the kernel memory parameters in UNIX that are required for an Oracle installation. The information found on MetaLink and in the Oracle 9i installation guide are brief at best and somewhat confusing for a non-UNIX-sys admin. like myself. Would some of you more experienced UNIX/Oracle DBAs please provide a plain English explanation describing your strategy in setting the following 7 parameters in the /etc/system file: SEMMNI SEMMNS SEMMSL SHMMAX SHMMIN SHMMNI SHMSEG To use a simple example, lets say the server has 1 GB of RAM to work with. Thanks in advance for sharing, david David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide, Inc. 8000 Regency Parkway, Suite 110 Cary, NC 27511-8582 Tel. (919) 466-6723 Fax (919) 466-6783 Mobile (919) 225-4962 [EMAIL PROTECTED] http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, 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 the sender by phone or email and delete this e-mail message from your computer. Thank you.
RE: Rollback Segments
I was s excited when I got my Hercules card! That computer was a 10 MHz speed-monster with a gigantic 83 KB hard drive. And WOW, graphics with my new Hercules card! I had such fun running stupid little programs that would make a globe turn, not to mention being able to type in Arabic and see it on the monitor. (Never mind that it took me hours to compose a letter in Arabic.) Before that ... well, it was Intel MDS and Isis, and Computer Automation, and DEC PDP's, and a bunch of OS's and pointer-based line editors that haven't existed for a realy long time now... We had block printers! Remember those? Did you say something about arthritis cream, Bambi ?? --JoJo -Original Message- Bambi Sent: Tuesday, February 19, 2002 11:50 AM To: Multiple recipients of list ORACLE-L I had a Hercules card too. I needed it to play some RPG game. Funny how many geeks had amber. I was so sick of the green on the VT and Vulcan boxes, I would sniff around for a tvi912c or tvi925 with it's baby blue. And then, of course the VT2xx series came out with its amber and everything was terrific. When I finally got off of VAXes, I was up to something like a VT460 only to go into Unix and set my TERM=vt100. How Neolithic. Pass the arthritis cream. Bambi. -Original Message- Sent: Tuesday, February 19, 2002 8:28 AM To: Multiple recipients of list ORACLE-L Actually, the Hercules graphics is able to generate graphics. I had to settle for Hercules since I could not afford a color monitor(using a CGA card) back then. So I looked for games, etc. that had a Hercules graphics mode. And, Hercules used twice the amount of pixels then CGA did, so I was able to find emulation software that allowed me to play CGA color games on my Hercules card. It replaced the limited CGA color pallete with patterns on the amber monitor. Sigh. The good old days... -Original Message- Sent: Monday, February 18, 2002 6:24 PM To: Multiple recipients of list ORACLE-L I do. User Friendly Interface. Hush, don't tell anybody, but I started with Oracle 4 on PC/XT with a huge, 20MB Winchester hard drive. The whole machine has had a Hercules screen card (text only, no graphics) and 512KB (no, it's not a mistake, it really is the letter K) of memory. I still have those 3 big, grey boxes with 5 5.25 floppies which used to contain the whole installation. Unfortunately, I cannot install it because I no longer have DOS 3.3 which was required for Oracle 4. Oh well, I seem to be getting old. -Original Message- Sent: Monday, February 18, 2002 1:59 PM To: Multiple recipients of list ORACLE-L Holy cow Mladen, what a memory! Does anybody else remember (or admit to) using UFI? Jim ** ...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)
Re:Oracle Developer/DBA Needed in Macon, Georgia-Local Candi
HUMM, After the fiasco in Noble who in their right mind would want to go to Georgia. :-) Reply Separator Author: OraStaff [EMAIL PROTECTED] Date: 2/19/2002 7:38 AM Stable manufacturing firm in Macon, Georgia is looking for an Oracle developer who has some DBA functions as well. Oracle development is the key. If the candidate has strong development skills and is interested in doing some DBA functions and some knowledge of the functions, resumes would be welcomed. This is a full-time staff position. *Only candidates who live in the Macon and 285 loop area will be considered. No relocation is provided. Only sent a resume if you are in this area. ** No Sponsorship is available. DO NOT send your resume if you have H-1B status. *Candidates Need to have solid Oracle Forms, Reports, PL/SQL experience.. some DBA experience is highly preferred. Base salary is in the 70-80 K range. *U.S. citizenship or green card holders only PLEASE do not send your resume if you are not in the United States. For immediate consideration, please send your resume as an attachment to: Email: [EMAIL PROTECTED] Please use job code: One/Macon/Dev/DBA/Larson All inquiries held in confidence. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Licensing - Concurrent users
I agree with Mr. Still, Our new project is licensed CPU based . The cpu count is important for the server. So that distributed databases is not preferable anymore for country wide applications. As Oracle says , this is a new feature of WEB WORLD. If your applications are client -server then the rules may change. Bunyamin Karadeniz - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, February 19, 2002 10:00 PM I suggest you talk to your Oracle rep before getting started. 'Concurrent' licensing is no longer a valid licensing model for Oracle. They sell by named user or per CPU. Their criteria for making you use the CPU licensing is rather broad. Just went through a licensing audit here. Lots o fun, let me tell you. While on the subject, does anyone have a good app/spreadsheet or template of some kind for tracking Oracle license use? It needs to track EE and Std versions, named and CPU licenses, servers, databases on the servers, users on the databases. I've cobbled my own stuff together from bits of string and baling wire, but I'm getting tired of messing with modifying SQL everytime I want a different view of the data, or to see if I can squeeze another app in without licensing more users. Thanks, Jared Smith, Ron L. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/19/02 11:14 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Oracle Licensing - Concurrent users We have been asked to gather statistics on the number of clients using Oracle. This is being done to determine if we have sufficient licensing. We have about 100 instances to monitor. Has anyone done this? Any ideas on what Concurrent users might mean to the majority of people? We have both Oracle 7 and Oracle 8. Ron Smith DBA Kerr-McGee Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin K. Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rollback Segments
Hey, Sql*Calc was pretty nice, but it kept changing and then they dropped it for the most part. Sql*Graph was pretty cool in theory, but never could come up with data to make it useful. And don't forget fastform which made things so easy, and rpt as a programming language instead of for reports... The days of micro-VAX and VAX750's. PC version fit on about 10-14 floppies, was it? I may still have them some place. The PC-XT and Dos 3.2 and Oracle 4.1.1 which could run on 512k of memory and you could write a distributed Order Entry system on it and tie it all back to a corporate VAX, before Sql*Net. Yea, them were the days... Michael Kline ThinkSpark Richmond, VA 804-744-1545 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of bill thater Sent: Tuesday, February 19, 2002 2:54 PM To: Multiple recipients of list ORACLE-L Subject: Re: Rollback Segments [EMAIL PROTECTED] wrote: SQL*Menu wasn't around in V5. IAP/IAG were there, and IAD came out in v5.1 (it was the first of the SQL*Forms). RPT/RPF were there too. And there was something called SQL*Calc which I never used (cuz you could do anything you i had to do a bunch with SQL*Calc because damagement understood Lotus123. it was less than enjoyable.;-) -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. Avoid temporary variables and strange women. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Michael Kline INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Pinning Packages in the Shared Pool??
Hi all, There used to be a piece of wisdom that indicated that you should pin Large, frequently used objects in the shared pool at startup of the database where large was defined as 5000 bytes. Is this still true There was also a list of Oracle Packages that were recommended to be pinned. That included diutil, dbms_sql, dbms_utility, and standard. Is this still good advice? Thanks, John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: orantdba INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Licensing - Concurrent users
Smith, Ron L. wrote: We have been asked to gather statistics on the number of clients using Oracle. This is being done to determine if we have sufficient licensing. We have about 100 instances to monitor. Has anyone done this? Any ideas on what Concurrent users might mean to the majority of people? We have both Oracle 7 and Oracle 8. Ron Smith DBA Kerr-McGee Corp Well, I have just been working on this for one of my customers last week. The obvious thing is to query V$SESSION at regular intervals (dbms_job can help) and what you can do is store the result through a database link to a single instance. Where it was tricky was that we wanted to identify 'system' processes (easy, except that job processes are marked as 'USER', which is debatable), and (that's where the snag is) processes which are the results of a connection through a database link. The logic is that a database link is initiated by a 'normal' connection - for which the full-blown licence is already paid. So they should not exactly count as much as regular connection; and if this is not a good argument, then it is probably possible to reduce their number by shifting around applications. Ultimately we could apply Larry's favorite concept of 'single instance' (anyway I have always found DB links messy). My trouble was that nothing, but human knowledge, can tell whether the connection comes from a database link or is genuine (if somebody has a way, please share !). All the user information (machine, program, module, action ...) comes from the initial connection and is propagated. I have solved this (not fully satisfactorily) by having a table automatically inserted with unknown (machine, program) pairs and manually updated to say 'If we see this program on this database, then it comes from a database link' - or 'anything coming from this machine must come from a database link'. Added something for connection from HTTP servers, although I doubt that those will be spontaneously discussed during the negotiation. -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Rollback Segments
Title: RE: Rollback Segments Does anyone have older copies of Oracle 4, and the equivalent version of forms? PVT Email me, please. -Original Message- From: Michael Kline [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 3:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: Rollback Segments Hey, Sql*Calc was pretty nice, but it kept changing and then they dropped it for the most part. Sql*Graph was pretty cool in theory, but never could come up with data to make it useful. And don't forget fastform which made things so easy, and rpt as a programming language instead of for reports... The days of micro-VAX and VAX750's. PC version fit on about 10-14 floppies, was it? I may still have them some place. The PC-XT and Dos 3.2 and Oracle 4.1.1 which could run on 512k of memory and you could write a distributed Order Entry system on it and tie it all back to a corporate VAX, before Sql*Net. Yea, them were the days... Michael Kline ThinkSpark Richmond, VA 804-744-1545 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of bill thater Sent: Tuesday, February 19, 2002 2:54 PM To: Multiple recipients of list ORACLE-L Subject: Re: Rollback Segments [EMAIL PROTECTED] wrote: SQL*Menu wasn't around in V5. IAP/IAG were there, and IAD came out in v5.1 (it was the first of the SQL*Forms). RPT/RPF were there too. And there was something called SQL*Calc which I never used (cuz you could do anything you i had to do a bunch with SQL*Calc because damagement understood Lotus123. it was less than enjoyable.;-) -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. Avoid temporary variables and strange women. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Michael Kline INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORA-00604 ORA-00942
HI LIST, WHEN I TRY TO DROP A USER I GET THE FOLLOWING ERRORS ANYBODY HAVE ANY IDEA WHY?? ORA-00604 ERROR OCCURED AT RECURSIVE SQL LEVEL1 ORA-00942 TABLE OR VIEW DOES NOT EXIST BUT I CAN SEE THE USER WHICH EXIST ORACLE 8.1.6 ON UNIX Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Solaris Kernel Memory Parameters Recommendations?
This is what I use: SHMMAX = of physical memory SHMMIN = 1 SHMMNI = 100 SHMSEG = 10 SEMMNI = 100 SEMMSL = 10 + SUM(initsid.ora PROCESSES parameters) SEMMNS = SUM(initsid.ora PROCESSES parameters) + largest initsid.ora PROCESSES parameter + (10 * number of instances) SEMOPM = 100 SEMVMX = 32767 I got the formulas for SEMMSL and SEMMNS from Oracle, via a tar. They aren't the same as the ones in the manual. Also remember to add in semaphore numbers for other applications that may be running on the machine (like Patrol). David Wagoner wrote: Ive read a couple of brief passages about setting the kernel memory parameters in UNIX that are required for an Oracle installation.The information found on MetaLink and in the Oracle 9i installation guide are brief at best and somewhat confusing for a non-UNIX-sys admin. like myself.Would some of you more experienced UNIX/Oracle DBAs please provide a plain English explanation describing your strategy in setting the following 7 parameters in the /etc/system file: SEMMNI SEMMNS SEMMSL SHMMAX SHMMIN SHMMNI SHMSEG To use a simple example, lets say the server has 1 GB of RAM to work with. Thanks in advance for sharing, david David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide, Inc. 8000 Regency Parkway, Suite 110 Cary, NC 27511-8582 Tel. (919) 466-6723 Fax (919) 466-6783 Mobile (919) 225-4962 [EMAIL PROTECTED] http://www.arsenaldigital.com/ ***NOTICE*** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, 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 the sender by phone or email and delete this e-mail message from your computer.Thank you. -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer
Re: ORA-00604 ORA-00942
Is it on a newly created database? Did you run the catproc and the catalog scripts? Raj Hamid Alavi hamid.alavi@quTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ovadx.com cc: Sent by: Subject: ORA-00604 ORA-00942 [EMAIL PROTECTED] m February 19, 2002 03:40 PM Please respond to ORACLE-L HI LIST, WHEN I TRY TO DROP A USER I GET THE FOLLOWING ERRORS ANYBODY HAVE ANY IDEA WHY?? ORA-00604 ERROR OCCURED AT RECURSIVE SQL LEVEL1 ORA-00942 TABLE OR VIEW DOES NOT EXIST BUT I CAN SEE THE USER WHICH EXIST ORACLE 8.1.6 ON UNIX Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Licensing - Concurrent users
you need to be careful if you are also using databases whose contents appear on the web, as Oracle will want you to use a web license (extremely expensive) even if the data is not directly accessed but appears on the web in static pages generated from the Oracle database. --- Stephane Faroult [EMAIL PROTECTED] wrote: Smith, Ron L. wrote: We have been asked to gather statistics on the number of clients using Oracle. This is being done to determine if we have sufficient licensing. We have about 100 instances to monitor. Has anyone done this? Any ideas on what Concurrent users might mean to the majority of people? We have both Oracle 7 and Oracle 8. Ron Smith DBA Kerr-McGee Corp Well, I have just been working on this for one of my customers last week. The obvious thing is to query V$SESSION at regular intervals (dbms_job can help) and what you can do is store the result through a database link to a single instance. Where it was tricky was that we wanted to identify 'system' processes (easy, except that job processes are marked as 'USER', which is debatable), and (that's where the snag is) processes which are the results of a connection through a database link. The logic is that a database link is initiated by a 'normal' connection - for which the full-blown licence is already paid. So they should not exactly count as much as regular connection; and if this is not a good argument, then it is probably possible to reduce their number by shifting around applications. Ultimately we could apply Larry's favorite concept of 'single instance' (anyway I have always found DB links messy). My trouble was that nothing, but human knowledge, can tell whether the connection comes from a database link or is genuine (if somebody has a way, please share !). All the user information (machine, program, module, action ...) comes from the initial connection and is propagated. I have solved this (not fully satisfactorily) by having a table automatically inserted with unknown (machine, program) pairs and manually updated to say 'If we see this program on this database, then it comes from a database link' - or 'anything coming from this machine must come from a database link'. Added something for connection from HTTP servers, although I doubt that those will be spontaneously discussed during the negotiation. -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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-00604 ORA-00942
NO IS NOT A NEWLY VREATED DATABASE, IT WAS WORKING FOR A WHILE. -Original Message- Sent: Tuesday, February 19, 2002 12:53 PM To: Multiple recipients of list ORACLE-L Is it on a newly created database? Did you run the catproc and the catalog scripts? Raj Hamid Alavi hamid.alavi@quTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ovadx.com cc: Sent by: Subject: ORA-00604 ORA-00942 [EMAIL PROTECTED] m February 19, 2002 03:40 PM Please respond to ORACLE-L HI LIST, WHEN I TRY TO DROP A USER I GET THE FOLLOWING ERRORS ANYBODY HAVE ANY IDEA WHY?? ORA-00604 ERROR OCCURED AT RECURSIVE SQL LEVEL1 ORA-00942 TABLE OR VIEW DOES NOT EXIST BUT I CAN SEE THE USER WHICH EXIST ORACLE 8.1.6 ON UNIX Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:RE: Just got back from SQL*Server 2000 training...
I find both the observations Jim made during the class and the remarks from the SqlServer list as both interesting. Having worked with SQL*Server as well as being an Oracle addict I observe that we each view our RDBMS choices as the best there is which is kind of valid. It's just very interesting how much more you can do when the software vendor is not so self assured that he knows best. Oh, you don't believe MicroSlop knows what is in your best interest? Go read the fine print on your license agreement, you've already agreed to that. Now pardon me while I allow Bill to drive. He says I need a patch for Access those Oracle tools are in the way and require deleting. Dick Goulet Reply Separator Author: Jesse; Rich [EMAIL PROTECTED] Date: 2/19/2002 8:43 AM - Original Message - To: SQL 7 Discussions [EMAIL PROTECTED] Sent: Tuesday, February 19, 2002 5:29 PM *When txn log fills up, have to just truncate the log in order for processing to continue. Leaves system vulnerable until you get a full DB backup. Seems a little like disk space filling up in Oracle. How is this different? Interesting. When this happened to us Oracle-wise, I just moved the oldest archives to a mount point that did have enough room. Since we at least had enough forethought to incorporate several redo log groups, the DB never stopped. And since we never actually deleted any archive logs, we were never at great risk of permanent loss of data. Or we could have also duplexed the arches offsite, too. Because we all know that RAID controllers NEVER fail... Truncate the log. Yeah, right. Ya know, as much as I have whined about the way Oracle does some things (e.g. stupid-ass security-by-obscurity for DBAs and some wierd things with OiD), I still think it's the best yet available. Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Solaris Kernel Memory Parameters Recommendations?
In addition to what you've already received, I would include settting SEMMNU (semaphore undo structures ) equal to SEMMNI. Not doing so can cause rather baffling errors at the OS level at times. Jared David Wagoner [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/19/02 12:04 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Solaris Kernel Memory Parameters Recommendations? I've read a couple of brief passages about setting the kernel memory parameters in UNIX that are required for an Oracle installation. The information found on MetaLink and in the Oracle 9i installation guide are brief at best and somewhat confusing for a non-UNIX-sys admin. like myself. Would some of you more experienced UNIX/Oracle DBAs please provide a plain English explanation describing your strategy in setting the following 7 parameters in the /etc/system file: SEMMNI SEMMNS SEMMSL SHMMAX SHMMIN SHMMNI SHMSEG To use a simple example, let's say the server has 1 GB of RAM to work with. Thanks in advance for sharing, david David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide, Inc. 8000 Regency Parkway, Suite 110 Cary, NC 27511-8582 Tel. (919) 466-6723 Fax (919) 466-6783 Mobile (919) 225-4962 [EMAIL PROTECTED] http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, 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 the sender by phone or email and delete this e-mail message from your computer. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SET TRANSACTION for a Distributed Transaction
Can I use SET TRANSACTION USE ROLLBACK SEGMENT RBS_NAME for a distributed transaction, where Im doing a whole bunch of INSERTS on a target db that SELECT data from a source db? I was thinking of constructing this to run when logged into the source db - I'd insert data to a target db across a database link. I assume the RBS would have to be on the target db? Or could the RBS be on the source db, even though the inserts are taking place on the target? Alternatively I could write the script whereby the inserts happen on the local db and the selects happen across the db link - in that case the SET TRANSACTION would use a local RBS . . . any ideas/comments on writing putting something like this together? Thanks -bill magaliff -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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-00604 ORA-00942
Something is probably going awry with the Oracle data dictionary tables. Oracle says to call customer support...Good Luck Can try dropping individual objects first then dropping user. Rick Hamid Alavi hamid.alavi@quTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ovadx.com cc: Sent by: Subject: ORA-00604 ORA-00942 [EMAIL PROTECTED] m 02/19/2002 03:40 PM Please respond to ORACLE-L HI LIST, WHEN I TRY TO DROP A USER I GET THE FOLLOWING ERRORS ANYBODY HAVE ANY IDEA WHY?? ORA-00604 ERROR OCCURED AT RECURSIVE SQL LEVEL1 ORA-00942 TABLE OR VIEW DOES NOT EXIST BUT I CAN SEE THE USER WHICH EXIST ORACLE 8.1.6 ON UNIX Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Licensing - Concurrent users
Thanks for the info! Ron -Original Message- Sent: Tuesday, February 19, 2002 2:41 PM To: Multiple recipients of list ORACLE-L Smith, Ron L. wrote: We have been asked to gather statistics on the number of clients using Oracle. This is being done to determine if we have sufficient licensing. We have about 100 instances to monitor. Has anyone done this? Any ideas on what Concurrent users might mean to the majority of people? We have both Oracle 7 and Oracle 8. Ron Smith DBA Kerr-McGee Corp Well, I have just been working on this for one of my customers last week. The obvious thing is to query V$SESSION at regular intervals (dbms_job can help) and what you can do is store the result through a database link to a single instance. Where it was tricky was that we wanted to identify 'system' processes (easy, except that job processes are marked as 'USER', which is debatable), and (that's where the snag is) processes which are the results of a connection through a database link. The logic is that a database link is initiated by a 'normal' connection - for which the full-blown licence is already paid. So they should not exactly count as much as regular connection; and if this is not a good argument, then it is probably possible to reduce their number by shifting around applications. Ultimately we could apply Larry's favorite concept of 'single instance' (anyway I have always found DB links messy). My trouble was that nothing, but human knowledge, can tell whether the connection comes from a database link or is genuine (if somebody has a way, please share !). All the user information (machine, program, module, action ...) comes from the initial connection and is propagated. I have solved this (not fully satisfactorily) by having a table automatically inserted with unknown (machine, program) pairs and manually updated to say 'If we see this program on this database, then it comes from a database link' - or 'anything coming from this machine must come from a database link'. Added something for connection from HTTP servers, although I doubt that those will be spontaneously discussed during the negotiation. -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Licensing - Concurrent users
Querying v$session will not work for many applications. SAP and Agile ( mfg app ) come to mind. They each use their own integrated app server. Hundreds of users may make use of the database via 20 connected sessions. These are databases that legitimately use Named user licenses: they don't require a CPU license. By querying v$session it's also difficult to catch occasionaly users that none the less must be licensed. Jared Stephane Faroult [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/19/02 12:40 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Oracle Licensing - Concurrent users Smith, Ron L. wrote: We have been asked to gather statistics on the number of clients using Oracle. This is being done to determine if we have sufficient licensing. We have about 100 instances to monitor. Has anyone done this? Any ideas on what Concurrent users might mean to the majority of people? We have both Oracle 7 and Oracle 8. Ron Smith DBA Kerr-McGee Corp Well, I have just been working on this for one of my customers last week. The obvious thing is to query V$SESSION at regular intervals (dbms_job can help) and what you can do is store the result through a database link to a single instance. Where it was tricky was that we wanted to identify 'system' processes (easy, except that job processes are marked as 'USER', which is debatable), and (that's where the snag is) processes which are the results of a connection through a database link. The logic is that a database link is initiated by a 'normal' connection - for which the full-blown licence is already paid. So they should not exactly count as much as regular connection; and if this is not a good argument, then it is probably possible to reduce their number by shifting around applications. Ultimately we could apply Larry's favorite concept of 'single instance' (anyway I have always found DB links messy). My trouble was that nothing, but human knowledge, can tell whether the connection comes from a database link or is genuine (if somebody has a way, please share !). All the user information (machine, program, module, action ...) comes from the initial connection and is propagated. I have solved this (not fully satisfactorily) by having a table automatically inserted with unknown (machine, program) pairs and manually updated to say 'If we see this program on this database, then it comes from a database link' - or 'anything coming from this machine must come from a database link'. Added something for connection from HTTP servers, although I doubt that those will be spontaneously discussed during the negotiation. -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Licensing - Concurrent users
They may also require this for databases that feed another system. A small app ( 60 users ) we're installing here would require a CPU license ($60k) if we feed data to SAP. As someone else has already pointed out, so much for distributed computing. Jared Rachel Carmichael [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/19/02 01:04 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Oracle Licensing - Concurrent users you need to be careful if you are also using databases whose contents appear on the web, as Oracle will want you to use a web license (extremely expensive) even if the data is not directly accessed but appears on the web in static pages generated from the Oracle database. --- Stephane Faroult [EMAIL PROTECTED] wrote: Smith, Ron L. wrote: We have been asked to gather statistics on the number of clients using Oracle. This is being done to determine if we have sufficient licensing. We have about 100 instances to monitor. Has anyone done this? Any ideas on what Concurrent users might mean to the majority of people? We have both Oracle 7 and Oracle 8. Ron Smith DBA Kerr-McGee Corp Well, I have just been working on this for one of my customers last week. The obvious thing is to query V$SESSION at regular intervals (dbms_job can help) and what you can do is store the result through a database link to a single instance. Where it was tricky was that we wanted to identify 'system' processes (easy, except that job processes are marked as 'USER', which is debatable), and (that's where the snag is) processes which are the results of a connection through a database link. The logic is that a database link is initiated by a 'normal' connection - for which the full-blown licence is already paid. So they should not exactly count as much as regular connection; and if this is not a good argument, then it is probably possible to reduce their number by shifting around applications. Ultimately we could apply Larry's favorite concept of 'single instance' (anyway I have always found DB links messy). My trouble was that nothing, but human knowledge, can tell whether the connection comes from a database link or is genuine (if somebody has a way, please share !). All the user information (machine, program, module, action ...) comes from the initial connection and is propagated. I have solved this (not fully satisfactorily) by having a table automatically inserted with unknown (machine, program) pairs and manually updated to say 'If we see this program on this database, then it comes from a database link' - or 'anything coming from this machine must come from a database link'. Added something for connection from HTTP servers, although I doubt that those will be spontaneously discussed during the negotiation. -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be
RE: Where does a DBA go from here?
Maybe he is doing a round the world trip before getting to Sydney. $uhen Mogens is using a new type of aircraft from the other large Seattle company That's why it takes 10 times longer... ;-) -- James Morle Scale Abilities, Ltd http://www.scaleabilities.co.uk Author of Scaling Oracle8i - Building Highly Scalable OLTP System Architectures -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Rachel Carmichael Sent: 19 February 2002 12:38 To: Multiple recipients of list ORACLE-L Subject: Re: Where does a DBA go from here? Mogens, Are you sure you have that time scale right for the flight times? I seem to recall it took me a mere (!) 24 hours to return to NYC from Brisbane. and I am jealous and longing to go to this class as well. sigh.. Rachel --- Mogens Nørgaard [EMAIL PROTECTED] wrote: Yeah, we're doing the Forum on 27-28 of May (confirmed) and we'll do a Miracle Master Class with Jonathan about 5-6 weeks later. Apart from the 200-250 hours flight time to get there, it should prove fun. Let's have a Fatcity Oracle-L party while we're there, shall we? Mogens Suhen Pather wrote: Sujatha, Just spoke to Peter Bach, Miracle AS , Australia The forum dates are not confirmed yet but it will be towards the end of May. Once he has the dates confirmed he will post it on the Miracle website. You can call him for more info, the numbers can be obtained from the Miracle AS website. It should be a great training to attend with lots of big names from the industry. He says that Jonathan Lewis will also be doing a training course (seminar) in Australia similar to the one on his website (JLCOMP). Regards $uhen Where can I get more information about this Database Forum in Sydney ?? Cheers, Sujatha -Original Message- From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 19 February 2002 10:18 AM To: Multiple recipients of list ORACLE-L Subject: Re: Where does a DBA go from here? Time for some real marketing here :-). Jonathan Lewis, Cary Millsap, Anjo Kolk, Steve Adams, Bjorn Engsig, James Morle and a few others will be the main speakers at the Database Forum we're doing in Sydney in late May. A couple of days with these guys should prove fun and educational. These days we even have an informal organisation called The OakTable Network ( www.OakTable.net http://www.OakTable.net ) which, for instance, will have a booth at Oracle World in Copenhagen in June where you can ask anything you like, sit around my oak table, and drink beer (well, maybe not that :) ), listen to mini presentations by the guys, and so on. EoM (End of Marketing). PS: We'll also try to build the worlds biggest laptop RAC cluster. That's proving a challenge. So far, we've managed to run two nodes on the laptops, but then it becomes harder - much harder. But James, Jonathan and Bjorn are working on it. Wouldn't it be fun if anybody could bring their laptop, plug it in, be part of the RAC thing for some minutes, and then get a certificate stating that the person participated in the worlds biggest, etc...? Mogens Greg Moore wrote: Now where do I go for more Oracle training? Consider looking at the web sites of the Oracle DBA's who are up on the latest techniques. They sometimes teach advanced classes. Craig Shallahamer (www.orapub.com http://www.orapub.com) offers an advanced class, as does Cary Millsap. Steve Adams recently taught a class in San Francisco. Tim Gorman may give advanced classes. The latest and best thinking seems to appear first in papers that are freely available, and then later appears in books and classes. These four DBA's offer papers like that on their sites, and link to other sites with more of the same. After a certain point you have to turn to quality books, papers and conferences. If it's classes you want, a clever move might be to take some UNIX or Windows system administration ones, to broaden your skills into some new area like that. __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.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 FAX: (858) 538-5051 San Diego,
Confusion about oradim.log file
Hi All, In 8.0.5 when I used the oradim utility to create a service I would always review the oradim.log file to see if all is well. I just created my first oracle 8i service using oradim. When I reviewed the oradim.log file I got an error message saying it cannot open the control files. Well of course not. Why in 8i does oradim.log contain this error? I can create the database fine with no problems. The docs always say to review oradim.log for errors before continuing. So why are they now putting in errors that are not really errors. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
add index to a unique-constrained column--how come?
The Oracle9i Database Administrator's Guide says: Creating a Unique Index Explicitly Indexes can be unique or nonunique. Unique indexes guarantee that no two rows of a table have duplicate values in the key column (or columns). Nonunique indexes do not impose this restriction on the column values. Use the CREATE UNIQUE INDEX statement to create a unique index. The following example creates a unique index: CREATE UNIQUE INDEX dept_unique_index ON dept (dname) TABLESPACE indx; Alternatively, you can define UNIQUE integrity constraints on the desired columns. Oracle enforces UNIQUE integrity constraints by automatically defining a unique index on the unique key. This is discussed in the following section. However, it is advisable that any index that exists for query performance, including unique indexes, be created explicitly (See it at http://download-west.oracle.com/otndoc/oracle9i/901_doc/server.901/a90117/in dexes.htm#10069) If there's already an index there for the constraint, why do we want an additional one? Does it take up space? Will the implicit (is that the right word?) index not be used in queries if you don't also create an explicit one? Thanks! -Roy Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pardee, Roy E INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Dynamic SQL
Title: Dynamic SQL We have Oracle version 8.0.5 and need to use dynamic sql. Through research I know that there is a dbms_sql package that is suppose to support this, but we cannot find an example of what we are needing to do. We have been told that we can do it easily in '8i' but we are not able to upgrade yet. We are trying to populate a reference cursor via a procedure with a select statement. Has anyone done this and if so can you furnish an example? I may need to tell more about what we are doing and if so please tell me. Thank you, Laura
Using User Defined functions or not
Hi, This question is with reference to tuning.Developers are repeatdely using same code ( for example if they want to add as second to date ther are using like date+1/86400) and they want to use something like following function so that they can write addsecond(date) in their code... function AddSecond(RefDate date) return date as begin return RefDate + 1/86400; end; Issus is now of performance...it looks like using function is degrading the performance ..Does it advisable to use extensive use of UDF in code Thanks --Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Two whitepapers, for interest and comments
In the process of preparing some documentation for a client, I prepared two brief white papers related to Oracle sizing and performance tuning. A colleague suggested I post them here, so here goes. Comments/feedback are of course welcome. :) Sizing Memory for Oracle on Solaris (http://www.omniti.com/~george/sizing_wp.pdf) Using Cached QuickIO to Accelerate Oracle on Small Memory Systems (http://www.omniti.com/~george/qio_wp.pdf) Best, George // George Schlossnagle // Principal Consultant // OmniTI, Inc http://www.omniti.com // 1024D/1100A5A0 1370 F70A 9365 96C9 2F5E 56C2 B2B9 262F 1100 A5A0 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Schlossnagle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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-00604 ORA-00942
Hamid, Had a similar problem last month, but I also noticed that I got the same error message when I tried to drop any object. (Although I first noticed it when I tried to drop a user.) Do you only get this error when you drop a user? After messing around with it for a bit, I determined that the system tablespace/data dictionary might be a bit wacked. It was only a 1 gig database running in noarchivelog mode, and I had an export from the last time a user logged in (lucky me!) so I recreating the database, did the import and everything was up and running again in no time - which was good because I had a few other things that required my immediate attention. Check to see if you get the ORA-00604 error message from dropping something else other than a user. Regards, Jeff - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, February 19, 2002 1:40 PM HI LIST, WHEN I TRY TO DROP A USER I GET THE FOLLOWING ERRORS ANYBODY HAVE ANY IDEA WHY?? ORA-00604 ERROR OCCURED AT RECURSIVE SQL LEVEL1 ORA-00942 TABLE OR VIEW DOES NOT EXIST BUT I CAN SEE THE USER WHICH EXIST ORACLE 8.1.6 ON UNIX Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Cox INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Licensing - Concurrent users
Rachel - By Web license, do you mean the unlimited-user CPU-based licensing? Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, February 19, 2002 3:05 PM To: Multiple recipients of list ORACLE-L you need to be careful if you are also using databases whose contents appear on the web, as Oracle will want you to use a web license (extremely expensive) even if the data is not directly accessed but appears on the web in static pages generated from the Oracle database. --- Stephane Faroult [EMAIL PROTECTED] wrote: Smith, Ron L. wrote: We have been asked to gather statistics on the number of clients using Oracle. This is being done to determine if we have sufficient licensing. We have about 100 instances to monitor. Has anyone done this? Any ideas on what Concurrent users might mean to the majority of people? We have both Oracle 7 and Oracle 8. Ron Smith DBA Kerr-McGee Corp Well, I have just been working on this for one of my customers last week. The obvious thing is to query V$SESSION at regular intervals (dbms_job can help) and what you can do is store the result through a database link to a single instance. Where it was tricky was that we wanted to identify 'system' processes (easy, except that job processes are marked as 'USER', which is debatable), and (that's where the snag is) processes which are the results of a connection through a database link. The logic is that a database link is initiated by a 'normal' connection - for which the full-blown licence is already paid. So they should not exactly count as much as regular connection; and if this is not a good argument, then it is probably possible to reduce their number by shifting around applications. Ultimately we could apply Larry's favorite concept of 'single instance' (anyway I have always found DB links messy). My trouble was that nothing, but human knowledge, can tell whether the connection comes from a database link or is genuine (if somebody has a way, please share !). All the user information (machine, program, module, action ...) comes from the initial connection and is propagated. I have solved this (not fully satisfactorily) by having a table automatically inserted with unknown (machine, program) pairs and manually updated to say 'If we see this program on this database, then it comes from a database link' - or 'anything coming from this machine must come from a database link'. Added something for connection from HTTP servers, although I doubt that those will be spontaneously discussed during the negotiation. -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:Using User Defined functions or not
Harvinder, I use a fairly large number of user defined functions/procedures. There has been a significant improvement in database performance with them. On top of that there is a lot of improved consistency in the application of business rules to boot. One item I would recommend is enlarging your shared_pool as that's where these little beasties reside it sure does not help having to constantly reload them. It also helps to bundle these small functions into larger packages that are easier to either pin or keep memory resident as they're always being used. Dick Goulet Reply Separator Author: Harvinder Singh [EMAIL PROTECTED] Date: 2/19/2002 1:59 PM Hi, This question is with reference to tuning.Developers are repeatdely using same code ( for example if they want to add as second to date ther are using like date+1/86400) and they want to use something like following function so that they can write addsecond(date) in their code... function AddSecond(RefDate date) return date as begin return RefDate + 1/86400; end; Issus is now of performance...it looks like using function is degrading the performance ..Does it advisable to use extensive use of UDF in code Thanks --Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Async I/O on Sun Solaris
Oracle/Solaris does a decent job of faking asynch i/o, but it isn't real. The details are on Steve Adam's website (www.ixora.com.au). Jay Miller -Original Message- Sent: Monday, February 18, 2002 1:33 PM To: Multiple recipients of list ORACLE-L I don't think you need raw devices for asynch I/O. We used asynch I/O without raw for years quite successfully. Veritas vxfs with Q I/O also helped. You need raw if you are going to implement Oracle9i RAC or Oracle Parallel Server. If not the issue, I would highly recommend asynch I/O over synchronous I/O to eliminate the intercommunication between the slave processes. Not to mention the memory consumption. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Monday, February 18, 2002 12:13 PM To: Multiple recipients of list ORACLE-L Subject:Re: Async I/O on Sun Solaris Works like a charm against qio files as well. May work on vxfs (I haven't checked). It may be a metter of definition, but I wouldn't characterize not working on ufs as not working on Solaris. That seems an overly sweeping statement to me. George On Saturday, February 16, 2002, at 09:03 PM, Jared Still wrote: Well, no not actually. You must use raw devices for async IO to work with Oracle on Solaris. It's pretty easy to prove this using svrmgrl and truss. If you dig around in the archives you may find some references to it, or search on google as there are a couple of sites that archive this list. With cooked filesystems, you won't get async IO on Solaris, at least on 2.6 and 2.7. Not sure about 2.8. Jared On Saturday 16 February 2002 16:08, George Schlossnagle wrote: Huh? asynch_io works fine on Solaris. At least on Solaris 2.6, 7, and 8. On Friday, February 15, 2002, at 10:28 AM, Peter Barnett wrote: Async IO on Solaris does not work - or at least it has not worked with lower OS releases. Someone might have more up to date information on Solaris 8. --- Daiminger, Helmut [EMAIL PROTECTED] wrote: Hi! How can I find out whether my operating system supports async I/O? Can I turn this on/off? What is the relation between async I/O and the usage of Oracle I/O slaves? Can anybody shed some light on this? This is 8.1.7 on Sun Solaris 8. Thanks, Helmut = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do You Yahoo!? Got something to say? Say it better with Yahoo! Video Mail http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). // George Schlossnagle // 1024D/1100A5A0? 1370 F70A 9365 96C9 2F5E?56C2 B2B9 262F 1100 A5A0 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). // George Schlossnagle // 1024D/1100A5A0 1370 F70A 9365 96C9 2F5E 56C2 B2B9 262F 1100 A5A0 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Schlossnagle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City
Re: Dynamic SQL
Burton, Laura L. wrote: We have Oracle version 8.0.5 and need to use dynamic sql. Through research I know that there is a dbms_sql package that is suppose to support this, but we cannot find an example of what we are needing to do. We have been told that we can do it easily in '8i' but we are not able to upgrade yet. We are trying to populate a reference cursor via a procedure with a select statement. Has anyone done this and if so can you furnish an example? I may need to tell more about what we are doing and if so please tell me. Thank you, Laura Laura, Read $ORACLE_HOME/rdbms/admin/dbmssql.sql, it contains examples. -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Using User Defined functions or not
Harvinder Singh wrote: Hi, This question is with reference to tuning.Developers are repeatdely using same code ( for example if they want to add as second to date ther are using like date+1/86400) and they want to use something like following function so that they can write addsecond(date) in their code... function AddSecond(RefDate date) return date as begin return RefDate + 1/86400; end; Issus is now of performance...it looks like using function is degrading the performance ..Does it advisable to use extensive use of UDF in code Thanks --Harvinder Harvinder, Functions are used for relatively complicated code. You could say 'well, we use a lot of loops, so why not using function inc(i) which returns i + 1'. Calling a function means stacking up a few things (return address, parameters), jumping to an address (which may be outside of physical memory at this time), popping things out of the stack, processing, jumping back ... Complicated stuff. Must be worth the trouble. Do not believe that by making everything a function it will become more maintainable. It's very difficult to follow the logic of a program when every two instructions you have a function call. -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re: Fw: Just got back from SQL*Server 2000 training...
Jared, I was going to respond, but you did a great job for me. Your points were my points exactly. I really tried to go to the SQL*Server class with an open mind thinking I'm adding a skill set, but I found myself constantly comparing to Oracle. I didn't mean to start the Holy War again, but thought it would make an interesting conversation. A bit more: Having databases in noarchivelog mode, especially during batch loads for data warehouses/datamarts is extremely important for a large database shop like ours. In terms of RAID, I was just pointing out that while we mirror our redo logs to at least two different groups with two different members, I was shocked that the transaction log in SQL*Server was in no way mirrored by SQL*Server. It was either do it at the hardware/OS level or risk it. Not a Mission Critical mentality. As for transferring 10GB over the network, this would be just backing up our archive logs, not to mention the datafiles themselves. We do it every day around the clock using our tape silo. We use RMAN with hotbackups directly to tape via Veritas NetBackup enterprise wide. 10GB is trivial in the Oracle world, however, judging by the response I got, not so trivial in the SQL*Server world. One last thing: Having been to the Oracle education classes, I was expecting to learn in depth how SQL*Server uses memory to buffer the database, shared SQL, etc. thinking this would be a major tuning strategy for SQL*Server. Based on the nature of your system, you could gear the equivalent of an SGA accordingly. I almost spit up my two cups of coffee when the instructor showed me the GUI slide-bar that controls memory allocation to SQL*Server. If you need more, just slide the bar to the right... I still chuckle... Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] wrote: Couldn't resist responding to this. *Cannot take DB out of archivelog mode. Can limit what is posted to txn log, but cannot stop it. Why would you want to? So you have the remote possibility of ending up with a corrupt, unrecoverable database if the power supply on the system fails? JS: Taking a database out of archive mode is certainly valid for large load operations. Let's see, I want to load 50 gig of raw data into my data warehouse tonight, that will generate about 800 gig of redo. Do I really want to do generate that much redo, deal with the overhead, and back it up besides? Or would it be easier to put the DW back in archive mode and back up the new data? *Txn logs not mirrored. Must rely on RAID or other mirroring software. Hardware RAID/mirrors are much better than software, so if you are comparing Oracle software based mirrors to the hardware based ones we use then our way is much faster JS: No mention of reliability there though is there? If I don't have control over the hardware layout, I want Oracle to mirror the logs, period. Backups directly to tape require the tape to be attached locally to SQL Server. Okay, if you really want to transfer your 10+GB database over the network each night, I suppose you will need to use Oracle. JS: 10+GB over the network is trivial. If you are using anything that approaches enterprise level backups, you will dedicate some fast pipes to your network attached tape system. This means that if you're using for instance Tivoli with a StorageTek Tape Silo,you must copy it first to disk, since you're not going to have direct access. Making backups to disk first tends to break any Oracle specific tape cataloging system ( RMAN for instance ) so that files must be located manually in case of a restore. *When txn log fills up, have to just truncate the log in order for processing to continue. Leaves system vulnerable until you get a full DB backup. Seems a little like disk space filling up in Oracle. How is this different? JS: This is a poor analogy. It isn't like disk space filling up in Oracle. The only disk likely to fill up is the archive log destination, and if you're doing your job as a DBA, that won't happen. I've been to DBA class for Sybase, which has the identical mechanism for transaction logging. It's crude and vulnerable. *If you have a 100GB DB that is full, your backup will be 100GB. No compression of backups! Valid point here. But I'd rather not trust my backup to a compression scheme anyways. Then you must not be backing up to tape, as all tape drive systems use built in compression. The I don't trust compression complaint is a red herring. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
UNIX QUESTION.
HI LIST, ANYBODY KNOW WHAT'S THE EQUIVALENT OF THIS COMMAND IN UNIX? host start cmd /c copy /u04/oradata/AMDEV/rbs01.dbf D:\oradata\fred\backup APPRECIATE FOR YOUR HELP. Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-00604 ORA-00942
I HAVE CHECKED IT, I CAN DROP ANY TABLE FROM USER BUT NOT USER. DOESN'T LET ME TO DROP ANY USER. EVEN DOESN'T LET ME TO SHUTDOWN -Original Message- Sent: Tuesday, February 19, 2002 2:03 PM To: Multiple recipients of list ORACLE-L Hamid, Had a similar problem last month, but I also noticed that I got the same error message when I tried to drop any object. (Although I first noticed it when I tried to drop a user.) Do you only get this error when you drop a user? After messing around with it for a bit, I determined that the system tablespace/data dictionary might be a bit wacked. It was only a 1 gig database running in noarchivelog mode, and I had an export from the last time a user logged in (lucky me!) so I recreating the database, did the import and everything was up and running again in no time - which was good because I had a few other things that required my immediate attention. Check to see if you get the ORA-00604 error message from dropping something else other than a user. Regards, Jeff - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, February 19, 2002 1:40 PM HI LIST, WHEN I TRY TO DROP A USER I GET THE FOLLOWING ERRORS ANYBODY HAVE ANY IDEA WHY?? ORA-00604 ERROR OCCURED AT RECURSIVE SQL LEVEL1 ORA-00942 TABLE OR VIEW DOES NOT EXIST BUT I CAN SEE THE USER WHICH EXIST ORACLE 8.1.6 ON UNIX Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Cox INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: add index to a unique-constrained column--how come?
- Original Message - If there's already an index there for the constraint, why do we want an additional one? Does it take up space? if there already exists a unique index on the column, the unique constraint should reuse it hth, Marin ...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Where does a DBA go from here?
I'm in for it! -Original Message-From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]]Sent: Tuesday, 19 February 2002 7:08 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Where does a DBA go from here?Yeah, we're doing the Forum on 27-28 of May (confirmed) and we'll do a Miracle Master Class with Jonathan about 5-6 weeks later. Apart from the 200-250 hours flight time to get there, it should prove fun. Let's have a Fatcity Oracle-L party while we're there, shall we?MogensSuhen Pather wrote: Sujatha, Just spoke to Peter Bach, Miracle AS , Australia The forum dates are not confirmed yet but it will be towards the end of May. Once he has the dates confirmed he will post it on the Miracle website. You can call him for more info, the numbers can be obtained from the Miracle AS website. It should be a great training to attend with lots of big names from the industry. He says that Jonathan Lewis will also be doing a training course (seminar) in Australia similar to the one on his website (JLCOMP). Regards $uhen Where can I get more information about this Database Forum in Sydney ?? Cheers, Sujatha -Original Message-From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]]Sent: Tuesday, 19 February 2002 10:18 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Where does a DBA go from here? Time for some real marketing here :-). Jonathan Lewis, Cary Millsap, Anjo Kolk, Steve Adams, Bjorn Engsig, James Morle and a few others will be the main speakers at the Database Forum we're doing in Sydney in late May. A couple of days with these guys should prove fun and educational. These days we even have an informal organisation called The OakTable Network ( www.OakTable.net ) which, for instance, will have a booth at Oracle World in Copenhagen in June where you can ask anything you like, sit around my oak table, and drink beer (well, maybe not that :) ), listen to mini presentations by the guys, and so on.EoM (End of Marketing).PS: We'll also try to build the worlds biggest laptop RAC cluster. That's proving a challenge. So far, we've managed to run two nodes on the laptops, but then it becomes harder - much harder. But James, Jonathan and Bjorn are working on it. Wouldn't it be fun if anybody could bring their laptop, plug it in, be part of the RAC thing for some minutes, and then get a certificate stating that the person participated in the worlds biggest, etc...?MogensGreg Moore wrote:!--[if !supportLineBreakNewLine]--!--[endif]-- Now wheredo I go for more Oracle training?Consider looking at the web sites of the Oracle DBA's who are up on thelatest techniques. They sometimes teach advanced classes. CraigShallahamer (www.orapub.com) offers an advanced class, as does Cary Millsap.Steve Adams recently taught a class in San Francisco. Tim Gorman may giveadvanced classes.The latest and best thinking seems to appear first in papers that are freelyavailable, and then later appears in books and classes. These four DBA'soffer papers like that on their sites, and link to other sites with more ofthe same. After a certain point you have to turn to quality books, papersand conferences.If it's classes you want, a clever move might be to take some UNIX orWindows system administration ones, to broaden your skills into some newarea like that.
Re: UNIX QUESTION.
[Hamid Alavi] ANYBODY KNOW WHAT'S THE EQUIVALENT OF THIS COMMAND IN UNIX? host start cmd /c copy /u04/oradata/AMDEV/rbs01.dbf D:\oradata\fred\backup host cp /u04/oradata/AMDEV/rbs01.dbf /oradata/fred/backup -- James Manning [EMAIL PROTECTED] GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Manning INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Intelligent Agent 8.1.7 / RedHat 7.1
List: I'm posting this for Peter -- he's having problems with list email. Thanks for any help!! Barb Maybe Someone can help me with this problem... 1) Operating System: Redhat Linux 7.1 2) Database: Oracle 8.1.7 I have gone through the users guide trouble shooting intelligent agent and have not found the problem. Problem: I can not discover Intelligent Agent from another BOX running Oracle Enterprise Manager. I can not connect to port 1748 that agent is running on. I have turned off the firewall option in setup on 7.1 linux. The agent appears to be running. I am on the same subnet. Why can I not connect to port 1748 ? P.S. ( I have a box that is running RedHat 6.2 with Oracle 8.1.7 and I can pass all the tests and discover works. ) Peter Bruni Senior Programmer Analyst Denver Newspaper Agency [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Where does a DBA go from here?
Count me in for both parties. $uhen Yeah, we're doing the Forum on 27-28 of May (confirmed) and we'll do a Miracle Master Class with Jonathan about 5-6 weeks later. Apart from the 200-250 hours flight time to get there, it should prove fun. Let's have a Fatcity Oracle-L party while we're there, shall we? Mogens Suhen Pather wrote: Sujatha, Just spoke to Peter Bach, Miracle AS , Australia The forum dates are not confirmed yet but it will be towards the end of May. Once he has the dates confirmed he will post it on the Miracle website. You can call him for more info, the numbers can be obtained from the Miracle AS website. It should be a great training to attend with lots of big names from the industry. He says that Jonathan Lewis will also be doing a training course (seminar) in Australia similar to the one on his website (JLCOMP). Regards $uhen Where can I get more information about this Database Forum in Sydney ?? Cheers, Sujatha -Original Message- From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 19 February 2002 10:18 AM To: Multiple recipients of list ORACLE-L Subject: Re: Where does a DBA go from here? Time for some real marketing here :-). Jonathan Lewis, Cary Millsap, Anjo Kolk, Steve Adams, Bjorn Engsig, James Morle and a few others will be the main speakers at the Database Forum we're doing in Sydney in late May. A couple of days with these guys should prove fun and educational. These days we even have an informal organisation called The OakTable Network ( www.OakTable.net ) which, for instance, will have a booth at Oracle World in Copenhagen in June where you can ask anything you like, sit around my oak table, and drink beer (well, maybe not that :) ), listen to mini presentations by the guys, and so on. EoM (End of Marketing). PS: We'll also try to build the worlds biggest laptop RAC cluster. That's proving a challenge. So far, we've managed to run two nodes on the laptops, but then it becomes harder - much harder. But James, Jonathan and Bjorn are working on it. Wouldn't it be fun if anybody could bring their laptop, plug it in, be part of the RAC thing for some minutes, and then get a certificate stating that the person participated in the worlds biggest, etc...? Mogens Greg Moore wrote: !--[if !supportLineBreakNewLine]-- !--[endif]-- Now where do I go for more Oracle training? Consider looking at the web sites of the Oracle DBA's who are up on the latest techniques. They sometimes teach advanced classes. Craig Shallahamer (www.orapub.com) offers an advanced class, as does Cary Millsap. Steve Adams recently taught a class in San Francisco. Tim Gorman may give advanced classes. The latest and best thinking seems to appear first in papers that are freely available, and then later appears in books and classes. These four DBA's offer papers like that on their sites, and link to other sites with more of the same. After a certain point you have to turn to quality books, papers and conferences. If it's classes you want, a clever move might be to take some UNIX or Windows system administration ones, to broaden your skills into some new area like that.
RE: [Fwd: UNIX Performance Issues]
Title: Message Rahul, For a start go to ixora.com.au and run Steve Adams response_time_breakdown.sql script against each of your databases. Paste the contents into a document with a little commentary and you have a nice summary of any potential issues. I have automated the process and get a daily diff of the script in a report each day via email. Lets me know where my waits are occuring. If I see something terribly unusual I investigate. Another easy thing to do is implement automated Statspack snapshots during peak periods and you might spot some trouble there. This will at least qwell any fears of performance trouble for the time being (or help you spot some). SAR reports aren't a bad idea either because they are also easy to automate. - Ethan DBAs,This might be littlebit (or completely!) UNIX related... But I am toldto do the performance analysis of some 10-15 machines and generatesome statistical data to find out bottlenecks and identify areas oftuning...Operating System : Solaris 2.6I have been using sar, iostat, top...I actually plan to script these things and run these scripts at certainintervals and put the data in database (Oracle 8i) and then do thecrunching...Inputs are appreciated...1. I/O What is current I/O status. Is there a lot of I/O going on?2. Paging Is there lot of swapping / paging happening? Which processes are getting swapped in/out continuously? Are the I/O waits due to swapping / paging or regular stuff like DB waiting to read from DB files?3. CPU What is the CPU utulization? Which processes are using lot of CPU?4. Memory What is the current picture of Real and Virtual Memory? What processes are using how much memory? Which processes are in real memory and which are in virtual memory? Which processes are swapped in and out from/to real/virtual memory and how many times?5. Network What is the percentage utilization of network pipe? What is the capacity (bandwidth) of the network device? What percentage of that bandwidth is getting used? Is the system waiting for data from outside network I/O? In short, is there any bandwidth problem with network device or network traffic.Thanks, ___ ___ ___ ___ ___ / /\ / /\ / /\ / /\ / /\ / /::\ / /::\ / /:/ / /:/ / /:/ / /:/\:\ / /:/:| / /:/ / /:/ / /:/ / /::\ \:\ / /:/|:| / /::\ __ / /:/ ___ / /:/ /__/:/\:\_\:\ /__/::\|:| /__/:/\:\/ /\ /__/:/ / /\ /__/:/ \__\/~|::\/:/ \__\/\:\:| \__\/ \:\/:/ \ \:\ / /:/ \ \:\ | |:|::/ \__\::| \__\::/ \ \:\ /:/ \ \:\ | |:|\/ | |:| / /:/ \ \:\/:/ \ \:\ |__|:| |__|:| /__/:/ \ \::/ \ \:\ \__\| \__\| \__\/ \__\/ \__\/-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Rahul Dandekar INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).