RE: OEM question
Shaw, Check these things. 1. Check whether OEM agent is running on NT4. (On unix the command is - lsnrctl dbsnmp_status). Perhaps on NT this might work. 2. One OEM agent is enough on one machine. This agent would monitor all the databases running on that machine. 3. Now, in the second step, if OEM agent is running, then check oratab file. (on unix, this file is located in -- /var/opt/oractle directory). In NT, I do not know the location of this file. 4. Now, IMPORTANT - See that an entry is available for both of the databases in oratab file. Your OEM should be able to recognize the second database. Rao -Original Message- Sent: Wednesday, January 30, 2002 11:26 AM To: Multiple recipients of list ORACLE-L - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 30, 2002 17:20 I have 2 8.1.6 instances running on a NT4 (sp6) server using the same listener. With Enterprise manager (oem server is a different machine), I can see - discover one of the instances but not the other. If I use toad or sqlplus I can connect to the other instance. Any guesses as to what I need to do to see this other instance with enterprise manager? make sure that the Oracle Intelligent Agent is running on the second instance (you can check this by executing agentctl status agent) also u may wish to check Oracle Intelligent User's Guide at http://download-uk.oracle.com/otndoc/oracle9i/901_doc/em.901/a88771/chap2.ht m#1005065 for agent configuration instructions 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Unix question
Roland, The file permissions on the file - loadfiles.sh --- might be set to no execute, no read, no write permissions for the group and others. In this case, only the owner of the file could access the file. Hence, under what user id are you calling this script? Also, check the permissions on the --- loadfiles.sh. Or change the file permissions on - loadfiles.sh ---. Go to the directory where - loadfiles.sh --- exists. Enter --- chmod 777 loadfiles.sh. Then run your command. If you get error during chmod command, it means you are not the owner of the file and hence, you are getting the error. In that case, you have two options. Either contact your sysadmin and ask him to change the file permissions on loadfiles.sh. Or if you know the owner's userid and pass word, then log on as that user and then change permissions on loadfiles.sh by executing the command chmod 777 loadfiles.sh Rao -Original Message- Sent: Friday, January 11, 2002 8:00 AM To: Multiple recipients of list ORACLE-L Hi can you do a cat on that file? if no: Maybe there are invisible characters as the back/front of the file name. try mv *loadfiles.sh* loadfiles.sh (see if you get message that filenames are identical) If that is not the problem, maybe the script calls a file that doesn't exist Jack [EMAIL PROTECTED]@fatcity.com on 11-01-2002 13:25:18 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Hallo, why do I get the error message No such file or directory. when I try to run unix script loadfiles.sh which is located in the directory /konto/tmp. This file, loadfiles.sh really exists in that directory. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Becoming a DBA questions
I also read this article today morning. After reading this article I got so much fed up with eweek news, I un-subscribed it from my mail system. Rao -Original Message- Sent: Friday, January 04, 2002 1:16 PM To: Multiple recipients of list ORACLE-L Lemme get this right. This guy is a *new* DBA. He's making 150k and he's not even a senior DBA, where he can make 200k? That's all from me. I'm gonna go sulk now. Jared DENNIS WILLIAMS DWILLIAMS@LIFE To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] TOUCH.COMcc: Sent by: Subject: RE: Becoming a DBA questions [EMAIL PROTECTED] m 01/04/02 09:05 AM Please respond to ORACLE-L The following eweek article might be of interest. If the link gets mangled, the article is at http://www.eweek.com Following the Data to a DBA Job by Jeff Moad. http://www.eweek.com/article/0,3658,s%253D703%2526a%253D20563,00.asp -- 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). -- 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: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Init.ora Compabible Setting
Ken, If you set the compatible to 817, then, you would be able to take advantage of 817 version. Or, if you have some software which is compatible with 8.1.0, then, it is better to leave like that. I personally prefer setting it to 817. Rao -Original Message- Sent: Monday, December 10, 2001 9:30 AM To: Multiple recipients of list ORACLE-L My init.ora compatible is set to 8.1.0. Is this correct for 8.1.7? Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: tablespace in backup mode
Charlie, Select * from v$backup; If any tablespace is left in backup mode, then, you would see --- ACTIVE --- under the column status. Rao -Original Message- Sent: Monday, December 10, 2001 9:26 AM To: Multiple recipients of list ORACLE-L Which table/view do I query to determine if any tablespace has been left in hot backup mode? -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 6041 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 Rose are red. Violets are blue. I'm schizophrenic I am too! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Changes to db after renaming mount points
Sujatha, You could do this in two ways --- either through recreating the control file -- (alter database backup controlfile to trace) and then make modfifications of new disk locations to the control file (trace file). Then from cold backup, copy the databse files to those new locations and bring up the datbase using the new modified controlfile. Second method: All of your steps are ok but you missed --- mounting the datbase before moving redo and taking the tablespaces offline. See below one details. If you are on 817 version, following are the steps to move the datafiles from one location to another location (I do not know whether these steps would work for versions prior to 817). 1. Take the tablespace offline -- alter tablespace your_tablespace offline normal; 2. Now, through another window on Unix, copy the data files to the new location using unix command --- mv. 4. After completing the data file copy, then issue the command alter tablespace your_tablespace rename datafile '/export/home0/oracle/rbdb1/users01.dbf', to '/export/home5/rbdb1/users01.dbf'; 5. After copying all the data files of this tablespace, bring up the tablespace on line -- alter tablespace your_tablespace online; 6. For moving the redo logs, shutdown the database and open the database in mount state. 7. Move the redo log files to new locations using the unix command -- mv. 7. Now, issue the following command (i.e., when the database is in mount state). ALTER DATABASE RENAME FILE '/export/home3/ora_log1.rdo' TO '/export/home4/ora_log1.rdo'; 8. Now, open the database for normal use. Prior to doing and also after completing the above operations, take the cold backup. Thanks, Rao -Original Message- Sent: Monday, December 03, 2001 11:10 PM To: Multiple recipients of list ORACLE-L Hi, I now have extra disks so I am re-arranging our databases. We will also be renaming the mount points (obviously the db's are on UNIX - HP-UX). I just want to confirm the steps I would have to do for this: 1. Make a cold backup 2. Move Controlfiles: (i) copy existing cf's to new location (ii) edit the control_files parameter in init.ora to change the existing cf name. 3. Rename/move redo logs: (i) Copy existing redo logs to new location (ii) Do a ALTER DATABASE RENAME FILE for each redo log moved 4. Rename/move datafiles: (i) Copy existing df's to new location (ii) Do a ALTER DATABASE RENAME FILE for each datafile moved. Does this sound fine? ... Have I missed anything? ... or should I look out for something special? Thanks for your help Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Resume issues - (Not posting my resume)
Bambi, Excellent one. Great. Printed it and filed in my personal file. Rao -Original Message- Sent: Friday, November 30, 2001 4:10 PM To: Multiple recipients of list ORACLE-L Dennis -- I sent Kimberly my tips offline (and my resume) but thought I would forward my tips based on nearly 24 years of experience to you folks in case you find it of value. If so, great, if not, oh well, but they were lessons learned over the years and apply to all jobs, contract and perm. If you have a boodle of experience, great. Don't hide it. But if your resume is going to be over two pages, go ahead and add a page to the front. The first page should be all the buzzwords that people are looking for, broken up into categories: Education Hardware Databases Languages Software Security Clearances Certifications Publications Major Industries That You Know Well (ie., not just database administration but a good knowledge of a good segment of the industry itself) That way, nobody has to fish on your resume for words like Oracle, Unix, C++, PeopleSoft or Oil and Gas. If HR people are looking through a pile of resumes for those buzzwords, the faster you can get into the smaller pile of people who have those skills, the better off you are. If someone has to wade through 4 pages just to see a skill they're looking for, you can pretty much assume they're not going to take the time. A-Number-One rule in job-hunting is Make Your Resume Friendly to The People Making Small Piles of Big Piles. The person you're actually going to be working for won't get to be impressed by all the cool stuff you've done if he/she never gets the resume. Work experience (if you've been an employee most of your professional career) or project experience (if you've been a consultant most of your professional career) should follow. Write about the major things you've done at your jobs/clients in paragraphs. Use whole sentences. Pretend that you are as comfortable with the written word as you are with grep and awk. Some people say bullet points with action verbs are the way to go; I don't agree. You have a small amount of space to demonstrate verbal and written communication skills (which is a requirement for EVERY JOB), make the most of it. As for which jobs to list and which not to, my rule of thumb is that if you've been at a particular job/client for more than 6 months, it should be listed by name, you might want to modify that to suit your experience. Regardless, if you've been doing a bunch of short-term projects, you can clump them in together in a single paragraph that shows a particular chunk of time with only your major clients listed by name in there. If you have minor clients (companies nobody's ever heard of) in that chunk of time, don't bother listing them, even if you have no major clients in there. There's no shame in saying small business or mid-size corporation rather than Joe's Barbershop or Peppers Waterbeds. When you have client with a household name, their name should appear in the paragraph. If you did vastly different things for different clients on a short-term basis, it is still better to cluster them together than not to. You'd rather look like a stable person with a variety of skills than a huge job-hopper who never stays anywhere very long (even if the latter is substantially more true than the former). One mistake to avoid: if you've been at a client for 12 years, the paragraph doesn't have to be long to prove it. You may have a shorter paragraph for a long job where your job function was clearly defined than a much shorter job where you were a maverick/firefighter/janitor. And if your resume has to be 5 pages, then it has to be 5 pages. There's a limit to how small you can make the type and how short you can make the paragraphs. You still need your resume to be your representative, and if you've been in the field for a long time, you sometimes just can't be represented by one page. Hope this helps... Bambi. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Possibly moving to Sun Equipment
Steve, We have a three 420R boxes, two 450 boxes, three 6500's. Each of our 420R's configuration is --- 4 cpu's - 450 MHZ, 4 GB RAM. We are using 420R boxes for our development. We have Oracle 817, WebLogic 6.1 and some middle tier software loaded onto these 420Rs. These 420R boxes come initially with one disk controller card. If you want to add additional disks, then, you would need to purchase additional controller cards. Now, regarding performance, we were trying to benchmark how many TPS 420R could send via WebLogic. I cannot post the exact TPS figures to the list as the damagement might interpret as revealing confidential info. But, my opinion is the number of TPS are very less or throughput is very less compared to E6500's. Rao -Original Message- Sent: Thursday, November 29, 2001 7:00 PM To: Multiple recipients of list ORACLE-L Well I have just returned from the Sun site, and checked out the two systems. The 420r is a rackmount server in the Enterprise Server series. It uses Sparciii processors, up to 4 at 450mhz. I don't' think I would consider this configuration an upgrade. I also doubt you'd classify this one as a screamer. The 880 is one of the Sunfire series of servers sporting a pair of 2 900mhz 64 bit UltraSparciii processors. This one sounds much more exciting to me. As I type this, I am informed that the powers that be are also looking at some HP UX boxes. Well either way we go I don't think it will be too traumatic for me. I am hoping for that Sun 880 now. -Original Message- Sent: Thursday, November 29, 2001 2:54 PM To: Multiple recipients of list ORACLE-L Steve - Is the 420R part of the new Sun Serengeti series? We had a test box here and I recall the model number as being similar. If it is the same thing, that box was a real screamer. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, November 29, 2001 3:50 PM To: Multiple recipients of list ORACLE-L Sorry for the double posting. I failed to include a subject line initially. My first day back, and already a list faux paus. Two I guess if you count the double post. Hello All, It has been a while since I have been here, but I am back and properly s ubscribed to the list again. I am looking to draw from your experiences here with hardware. Our current database resides on a Data General Aviion system with a Clarion drive cabinet. While we are very pleased with the system, and it's performance Data General is going the way of the Dinosaur, so we need to look at other options. The ones most currently floated have been the Sparc 880 or the 420R either configured with dual gigahertz processors. The IT manager has a desk piled high with marketing gobbledeegook, and has asked me if I know anything about either system. All I have been able to do is assure him that Solaris is essentially UNIX, and tell him I would check with some knowledgeable folks here about the hardware. Our DG box sports a Gig of RAM, and 4 300 mhz Intel processors. The best thing by far about our system is the Clarion drive cabinet that handles all our drives. The good news is I hear our cabinet is compatible with Sun hardware, so that might come right along with us. I have done a bit of internet searching, and seen these Sun boxes priced under 20K. My question is this. Are these serious platforms for a business currently handling 10K OLTP transactions a day, and looking to double or triple that volume within two years? Steve McClure - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 for Sun/64 Bit Question
Tom, Yes. Oracle 817 comes in two disks. Installation is little tricky. The best way, I found is, copy both the cd's onto two different locations on the disk. Then start the installation. Once, the first file is over, it asks you for the second CD. Then, you give the file path where you copied the second cd. Rao -Original Message- Sent: Monday, December 03, 2001 1:16 PM To: Multiple recipients of list ORACLE-L All, I have the install disks for 8.1.7 for Sun SPARC Solaris. Are these disks (2 of them) the same for Sun 64bit? I looked on TechNet, and I do not see any other 817 release for Sun. I do see, however, 64 bit for Oracle for 9i. Thanks! Tom Mercadante Oracle Certified Professional -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Quick Question on hotbackup
Seema, You do not need to switch current log file at the beginning of your job. You switch the log file before taking the copy of archive log files. Generally, listener and tnsnames files copy is not required. Overall the steps you outlined are ok. But remember at every step to check for the success or failure of your step before proceeding with the next step. If you are trying to write the script in Unix, I suggest the following additional things. 1. Before starting the hot backup job, check whether the db is up or not. If the db is not up, then abort the job and send a mail to the Daring Boys All (DBAs). 2. Before putting a tablespace in the hot backup mode, check whether the tablespace is already in hot backup mode. This could happen if another DBA is doing hot backup on the same tablespace. 3. After copying the datafile, do unix compare. If it fails, then abort the job and send a mail to DBA. 4. Also after copying the archive log files, you need to delete the archive logs. Else, your archive log space would keep increasing. 5. Once all the tablespaces and archive logs are copied, it is a good practice to compress these files. Rao -Original Message- Sent: Monday, December 03, 2001 2:35 PM To: Multiple recipients of list ORACLE-L Hi The following files are backed in hotbackup right? -Switch the current log -take the structure of database by alter database backup controlfile to trace; -Data files (ALter tablespace begin backup and ALter tablespace end backup ) -All parameter like init.ora,listener.ora,tnsnames.ora and passwd file -All archive log files Is any things missing in this list? Thanks -Seema -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 for Sun/64 Bit Question
William, Thanks for the update. Rao -Original Message- Sent: Monday, December 03, 2001 3:15 PM To: Multiple recipients of list ORACLE-L Rao, Maheswara wrote: Tom, Yes. Oracle 817 comes in two disks. Installation is little tricky. The best way, I found is, copy both the cd's onto two different locations on the disk. Then start the installation. Once, the first file is over, it asks you for the second CD. Then, you give the file path where you copied the second cd. Rao as long as you start the runInstaller from a directory other than /cdrom, you can change the CD when it asks you to. i've done it for 8.1.7 and 9iAS with no problems. -- -- Bill Shrek Thater ORACLE DBA Telergy,Inc. [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. This message transmitted on 100% recycled electrons. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: doubts reg : Tablespace
Sangeetha, 1. During creation of tablespace, if you make it online, then, tablespace is available for use immediately after its creation. Otherwise (offline), you need to issue a separate statement making the tablespace online after tablespace is created. 2. Yes. You could store two different users objects in the same tablespace and datafile. Basically, a tablespace contains some datafiles. Users are assigned to the tablespace ( I mean users are granted space quota privileges on the tablespace). 3. No. Two tablespaces cannot contain the same datafile. a bit of advice: Please read Oracle concepts Vol.1. It would clarify most of your doubts on these tablespaces and datafiles. Rao -Original Message- Sent: Wednesday, November 28, 2001 12:10 PM To: Multiple recipients of list ORACLE-L hi, what is the exact use of making the 'status' online or offline at the time of creation of tablespace. can objects of two diff users be stored in the same tablespace and datafile. can two tablespaces contain the same datafile . thanx in advance sangeetha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Crontabs and Oracle
Tim, Sourcing a .profile within cron jobs is not a good way doing a shell scripting. One big reason --- A .profile might contain a lot of functions which are OK if you are loggin in with that specific user id. And those functions might be doing some job that might affect the cron job. In my opinion, the correct way is to export the required variables or setting them in the beginning of the cron job. Rao -Original Message- Sent: Friday, November 30, 2001 5:35 AM To: Multiple recipients of list ORACLE-L On Thu, Nov 29, 2001 at 11:15:43AM -0800, [EMAIL PROTECTED] wrote: I've seen a number of suggestions for sourcing .profile in the cron jobs, but this is not always a good idea, as .profile often contains script that will not execute when not attached to a tty. I think sourcing .profile is the 'right' thing to do. If that breaks then the .profile needs fixing as it'll probably also break things like rsh/rcp etc. I've seen both these code sytles used (for sh/ksh/bash etc): if [ $PS1 ] then ... interactive stuff here ... fi or case $- in *i*) ... commands for an interactive shell here ... ;; *) ;; esac Tim. -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Crontabs and Oracle
Good idea. Rao -Original Message- Sent: Friday, November 30, 2001 12:52 PM To: Multiple recipients of list ORACLE-L What I did is create a file that sets the environment for each database. This file is sourced in my profile as well as any script I create. Therefore, when it comes time to put a script in cron I do nothing but place it in there. Plus, that gives me one spot I ever have to change when I upgrade. This file takes the database sid as a parameter. -Original Message- Maheswara Sent: Friday, November 30, 2001 7:07 AM To: Multiple recipients of list ORACLE-L Tim, Sourcing a .profile within cron jobs is not a good way doing a shell scripting. One big reason --- A .profile might contain a lot of functions which are OK if you are loggin in with that specific user id. And those functions might be doing some job that might affect the cron job. In my opinion, the correct way is to export the required variables or setting them in the beginning of the cron job. Rao -Original Message- Sent: Friday, November 30, 2001 5:35 AM To: Multiple recipients of list ORACLE-L On Thu, Nov 29, 2001 at 11:15:43AM -0800, [EMAIL PROTECTED] wrote: I've seen a number of suggestions for sourcing .profile in the cron jobs, but this is not always a good idea, as .profile often contains script that will not execute when not attached to a tty. I think sourcing .profile is the 'right' thing to do. If that breaks then the .profile needs fixing as it'll probably also break things like rsh/rcp etc. I've seen both these code sytles used (for sh/ksh/bash etc): if [ $PS1 ] then ... interactive stuff here ... fi or case $- in *i*) ... commands for an interactive shell here ... ;; *) ;; esac Tim. -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ORA-03113
Title: RE: RE: ORA-03113 Lisa, ps -fu oracleSID - command would not work. The reason is when you -u option with ps, it looks for the user by name mentioned. In this case, there would not be any user by name oracleSID (most likely). All the oracle processes would be owned by the user oracle. Now, the following modification for the command might work. I did not test this completely. ps -fu oracle | grep -v SID | grep -v PPID | awk '{ print $2; }' | xargs kill -9 Rao -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Thursday, November 29, 2001 1:27 PMTo: Multiple recipients of list ORACLE-LSubject: RE: RE: ORA-03113 Yes, you are right. If you have multiple instances change the command to something like this, assuming your sid name is SID ps -fu oracleSID|grep -v PPID|awk '{ print $2; }'|xargs kill -9 Try it without the xargs kill -9 to verify it's choosing what you need. Otherwise just kill smon, pmon and the database will come down. I have done this many times and only once did I end up in a recovery. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Greg Faktor [SMTP:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 12:21 PM To: Multiple recipients of list ORACLE-L Subject: Re: RE: ORA-03113 If I'll apply this command it's will take all oracle processes down for every instance in this box? Thanks. [EMAIL PROTECTED] 11/29 10:35 AM Why don't you want to want to take all the oracle processes down? I thought that's what you wanted to accomplish with shutdown immediate? Go ahead and issue Mladen's command and restart the database. It's the only way you can bring it down if you can't connect with svrmgrl or sqlplus. Lisa Koivu Oracle Database Monkey Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Greg Faktor [SMTP:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 10:05 AM To: Multiple recipients of list ORACLE-L Subject: ORA-03113 Hi All! I tried shutdown immediate and get ORA-03113. Now I can't connect to database. How I can take instance down? On this HP box 10 different databases. This command was posted some time back by Mladen: ps -fu oracle|grep -v PPID|awk '{ print $2; }'|xargs kill -9 It's will take all oracle processes and listeners down which I don't want to do. I'm on Oracle 8.1.6. Thanks. Greg. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Faktor INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Greg Faktor INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Urgent - error ORA-24327
List The environment : Oracle 817 : Solaris 7 : Memory - 4 GB. WebLogic Vesrion: 6.1 In the WebLogic Connection pool, when we try to open the connections beyond 246, we are getting this error - ORA 24327. We are not getting this error when the connection pool in the WebLogic is below 245. Any help would be appreciated. Thanks, Rao
RE: Urgent - error ORA-24327
Deepak, Processes parameter is set to 1000. Rao -Original Message- Sent: Wednesday, November 28, 2001 5:05 PM To: Multiple recipients of list ORACLE-L what is your processes parameter set to? --- Rao, Maheswara [EMAIL PROTECTED] wrote: List The environment : Oracle 817 : Solaris 7 : Memory - 4 GB. WebLogic Vesrion: 6.1 In the WebLogic Connection pool, when we try to open the connections beyond 246, we are getting this error - ORA 24327. We are not getting this error when the connection pool in the WebLogic is below 245. Any help would be appreciated. Thanks, Rao -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: HELP : doubts regarding --- Tablespace ,Roll Segment , dif
sangeetha, 1. When a tablespace is deleted, the users do not get dropped. Users would still be present. However, the tables created on the tablespace would be dropped. Users and their details are maintained in Oracle dictionary. If you have DBA permissions on your database, check the view, dba_users. You would see all the users. 2. A rollback segment stores any data that is changed in the database. But there are many ramifications for a rollback segment. Read Oracle concepts manual for a complete understanding of rollback segments. 3. There are many differences between Oracle 8i and Oracle 9i. Listing them here would be very lengthy. You could create a user account in http://otn.oracle.com/ . It is free. There go to this link -- http://otn.oracle.com/products/oracle9i/content.html . In this you would see a title - Oracle 9i features. Rao -Original Message- Sent: Tuesday, November 27, 2001 9:30 AM To: Multiple recipients of list ORACLE-L between oracle 8i and 9i, and between oracle 8i and previous versions - urgent hi list, i enrolled in this list jus today and it was really nice to see the questions and the responses that were posted.here i've got few doubts.if possible plz do clear them as soon as possible, as comming nov 30th is my project presentation. 1)If a tablespace is deleted will the users and tables created in that tablespace get deleted?,if not in which tablespace will the users and tables get stored. 2)what is the function of Roll Segment?...is it necessary to create it every time we create tablespace? 3)plz do give me the exact difference between oracle8i and oracle9i,ie., what are the advancements in Oracle9i not present in oracle 8i. d) diff between oracle8i and its previous versions. plz do clear all or any of the above doubts. awaiting for all u're replies eagerly. regards sangeetha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 the best
Prasad, See Jared's reply to your mail. Check V$session as Jared suggested. If you have questions after checking, then e-mail the problem. Rao -Original Message- Sent: Saturday, November 10, 2001 1:20 AM To: Multiple recipients of list ORACLE-L Hi Rao, No, it is not running in MTS mode. It is running in shared server mode. Prasad BAV. --- Rao, Maheswara [EMAIL PROTECTED] wrote: Prasad, Is the database running on MTS mode? Rao -Original Message- Sent: Friday, November 09, 2001 9:00 AM To: Multiple recipients of list ORACLE-L Hi, All of us believe Oracle is the best database server. We can keep our application data on Oracle and just forget the rest. I strongly believe I can do anything I want, with Oracle. We have a problem with Oracle. Ours is a small application with most hits. Lot of people will be using our solution and each hit results in database access. We have limitation on the maximum number of connections that can be made from Java application(servlet). We are accessing from 16 servlet machines to the database and making around 500 connections. We are using a connection pool from Javaexchange(DbConnectionBroker). When the application reaches beyond 500(I think the number is still less) connections, the database stops responding. Database machine's CPU usage goes 100%. And any requests from servlets at this point, will wait for a long time to get response from oracle. We are using Oracle 8.1.7, on Windows 2000. System RAM is 3GB. We are using 1.5GB of SGA. System is 1GHz processor. We are using CLOB very frequently. Thanks in advance for your suggestion on tuning. Regards, Prasad BAV. __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Prasad BAV INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 the best
Prasad, Is the database running on MTS mode? Rao -Original Message- Sent: Friday, November 09, 2001 9:00 AM To: Multiple recipients of list ORACLE-L Hi, All of us believe Oracle is the best database server. We can keep our application data on Oracle and just forget the rest. I strongly believe I can do anything I want, with Oracle. We have a problem with Oracle. Ours is a small application with most hits. Lot of people will be using our solution and each hit results in database access. We have limitation on the maximum number of connections that can be made from Java application(servlet). We are accessing from 16 servlet machines to the database and making around 500 connections. We are using a connection pool from Javaexchange(DbConnectionBroker). When the application reaches beyond 500(I think the number is still less) connections, the database stops responding. Database machine's CPU usage goes 100%. And any requests from servlets at this point, will wait for a long time to get response from oracle. We are using Oracle 8.1.7, on Windows 2000. System RAM is 3GB. We are using 1.5GB of SGA. System is 1GHz processor. We are using CLOB very frequently. Thanks in advance for your suggestion on tuning. Regards, Prasad BAV. __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Prasad BAV INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Another Oracle DBA gets The Bullet in the UK - Seeking an O
Raj, One small suggestion: If maintaining many db's leaves you with less time to attend to the developer's questions or developers' requirements, bring up this case to your boss. Put it to him in such a way that the company requires another DBA. In that way, you would be doing two services in this troubled times. 1. You would be providing a job to a guy. 2. You would be left free to attend to your production tasks. Due to financial constraints, if your company could not appoint another DBA, then, at least your boss and the management would be aware WHY you could not attend to the developers requests quickly. In my experience, I found that having good relationships in the company with as many as you can, would give you advantage when you most require it. Do not leave anybody with an empty feeling that his/her request isn't important. Even if it is not important, try to explain your priorities to them. Over a period of time, very quickly the developers would start understanding your problems and they would start respecting you and appreciate the job you do. Rao -Original Message- Sent: Friday, November 09, 2001 8:31 AM To: Multiple recipients of list ORACLE-L O good people skills -- you leave them smiling even when you tell them no they can't have what they want. You are not arbitrary about decisions, you explain WHY something won't work and offer an alternative that will. You smile at people, get to their work as quickly as you can, explain delays when you can't. Oh, and you ask how are you and LISTEN for the answer :) Rachel --- Randy Kirkpatrick [EMAIL PROTECTED] wrote: RS That doesn't sound like good people skills ... just that you don't put up with any $ # ! ? ... Good people skills would leave them thinking their whimsies were entertained and you wouldn't call developers - duhvelopers (even if they are duhveloping with half a brain!) Randy Kirkpatrick -Original Message- From: Sakthi , Raj [SMTP:[EMAIL PROTECTED]] Sent: Thursday, November 08, 2001 10:25 AM To: Multiple recipients of list ORACLE-L Subject: RE: Another Oracle DBA gets The Bullet in the UK - Seeking an O Wellwhen it comes to people skills I am THE winner in my company.every Duhveloper and some went and complained that I don't entertain their whimsies and Fancies to CIO ( they put it much harsher, of course..;) ).But you know ,when you have 20 database and 3 OS and few Java duhvelopers let loose in the system , then you don't have a chance to look at your apartment in daylight...heck last week I was in same clothes for 42 Hours straight recovering 150 GB Monster from a 'rolling disaster'. Say anything else but don't say my Job is not complex...Thank God I love what I do. Cheers, RS -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Location of PLAN_TABLE
Title: Location of PLAN_TABLE We keep plan table in each of the developers schema and thus there is no problem of deletions and maintenance of this table. Also, this is not such an important table for DBA maintenance. Rao -Original Message-From: Thomas Jeff [mailto:[EMAIL PROTECTED]]Sent: Monday, October 29, 2001 12:05 PMTo: Multiple recipients of list ORACLE-LSubject: Location of PLAN_TABLE Rather a trivial question, but our DBA team is discussing how best to implement the location of the plan table. My preference is is simply create is as SYS, public synonym, and grant privs on it to our developers. I'm being outvoted by the others, who want to create it in each and every application schema, but still grant access to all developers with no synonyms, the thinking being, that it would help to minimize accidental deletions of execution plans and so forth. My belief is that's simply over-thinking this issue. What do you do at your sites? Thanks. Jeffery D Thomas DBA Thomson Information Services Thomson multimedia Inc. Email: [EMAIL PROTECTED] DBA Quickplace: http://gkmqp.tce.com/tis_dba
Comparing data between two tables in two schema
List, I have two schema. The tables in both schema are having same name and structures. Is there any tool to compare the data between two schema tabels? Thanks, Rao -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Does start with/connect by uses full table scan?
Thanks a lot Guy. Very good link with lot of examples. Rao -Original Message- Sent: Tuesday, September 25, 2001 6:30 AM To: Multiple recipients of list ORACLE-L According to this page, you would use concatenated indexes: http://www.arsdigita.com/books/sql/trees.html Hmmm. g -Original Message- Sent: Monday, September 24, 2001 7:36 PM To: Multiple recipients of list ORACLE-L List, Does Oracle go for full table scan or does it use indexes when we use start with/connect by clause? Thanks, Rao -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Design Issue - Quick response appreciated
Thanks Jay. Quetion:When we use start with/connect by clause, does Oracle do full table scan? Thanks, Rao -Original Message- Sent: Friday, September 21, 2001 5:25 PM To: Multiple recipients of list ORACLE-L Ouch! I was assuming (for no good reason) that the field you used in your example (ACCOUNT_ID) is the only one that would change. In this case I agree with Christopher. Go with a generated key as your primary key (your current primary key columns can be an alternate key), then you can use that as the only prior_id column. With regards to the second question you can then go back as far as you like using the START WITH/CONNECT BY clauses in your SELECT statement. Jay Miller -Original Message- Sent: Friday, September 21, 2001 3:45 PM To: Multiple recipients of list ORACLE-L Jay, Good thought. Questions: 1. How many prior_ID's do I need to maintain? Logically, user could change any of the columns in a primary key. 2. Say, a transaction udergoes 2 times changes i.e., first time, account_ID is changed. Second time, Security_id is changed. This means, I inserted two records into the transaction table pertaining to original transaction. How do I retrieve earlier three records? i.e., the latest change in the account_id=IBM. If the user is querying based on this, he would get two records. But he would not get the record where he changed security_ID. (My primary key = Security ID + Account ID + Account Type + Trade Date). 3. How do manage and retrieve the records from the child tables? Thanks, Rao -Original Message- Sent: Friday, September 21, 2001 2:26 PM To: Multiple recipients of list ORACLE-L One thought is to have an additional column called something like 'PRIOR_ID'. If the Account_id is changed (actually a new value inserted) then the PRIOR_ID for the new row is set to the ACCOUNT_ID of the old row. That way you can always trace back if the transaction used to have a different account. Jay Miller -Original Message- Sent: Friday, September 21, 2001 12:35 PM To: Multiple recipients of list ORACLE-L List, OLTP application with 24x7 requirement. 300,000 records per day are inserted into the transaction table. Environment: Solari 7. Oracle 817. The transaction table layout. Security ID Account ID Account Type Trade Date And other columns in this table. In the above table, the primary key is -- Security ID + Account ID + Account Type + Trade Date There are many to one relationships built to other child tables from Transaction Table Scenario: User inserts a record into transaction table. In the first record, Account ID value is HP and he might insert a record into the child table (Or this transaction may not insert a record into a child table). After some time, the user queries the original record with the primary key and then changes the value in the column - Account ID to IBM. Now, the original transaction record is NOT UPDATED. A record IS INSERTED with the new values. Also, he might or might not insert a record into a child table with this new values of primary key. Now the user would query the transaction table with Account ID = IBM. But, the user wants to get all the previous records also; in this case, he want to see the record with Account ID = HP also. Also, he want to see the related records from the child tables. I tried with the idea of sequence number generation but it was failing. Any ideas or suggestions are much appreciated. Thanks, Rao Maheswara Rao, Oracle DBA SunGard Securities -- 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: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
RE: Design Issue - Quick response appreciated
might or might not insert a record into a child table with this new values of primary key. Now the user would query the transaction table with Account ID = IBM. But, the user wants to get all the previous records also; in this case, he want to see the record with Account ID = HP also. Also, he want to see the related records from the child tables. I tried with the idea of sequence number generation but it was failing. Any ideas or suggestions are much appreciated. Thanks, Rao Maheswara Rao, Oracle DBA SunGard Securities -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Does start with/connect by uses full table scan?
List, Does Oracle go for full table scan or does it use indexes when we use start with/connect by clause? Thanks, Rao -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Discovering same SIDs on 2 boxes in OEM
Rich, It is doable. We have two databases with same SID. One on production and another on development box. This is a result of our Unix SA doing it in dark ages. I had some difficulty in getting the OEM discover these nodes. If I recall correctly, following is the sequence. 1. Try to discover each node one at a time. 2. If the step one fails, then, remove both nodes (production and development nodes) from OEM. Then discover only production node. 3. After step 2, go to development box. Stop the intelligent agent on development box. Delete all the logs created by intelligent agent (Please check the Oracle docs for the location of these intelligent agent logs are created). 4. Start the intelligent agent on development box. Now try to recognize. Caveat: In our case, production and development databases are same version. Rao -Original Message- Sent: Monday, September 24, 2001 1:06 PM To: Multiple recipients of list ORACLE-L Using OEM v2.2, how can one differentiate between two databases with the same SID on two different boxes using Discover node? I have a production DB in v7.3.5 that I need to test both the conversion and the app, so the SID is the same on each box, but the ONAMES alias is (obviously) different. The production has already been discovered, but the test one will not discover, I think due to the SID being the same. Is this doable? I would RTFM, but I can't find a decent M to FR RE:OEM. :) TIA, Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Design Issue - Quick response appreciated
values of primary key. Now the user would query the transaction table with Account ID = IBM. But, the user wants to get all the previous records also; in this case, he want to see the record with Account ID = HP also. Also, he want to see the related records from the child tables. How do I do this? Thanks, Rao -Original Message- Sent: Friday, September 21, 2001 3:17 PM To: Multiple recipients of list ORACLE-L Then use a surrogate key, i.e. sequence number. Numbers that change are not candidates for key, doing so introduces problems in which you are having as well as others. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Friday, September 21, 2001 2:30 PM To: Multiple recipients of list ORACLE-L In our case, we do not have any other columns --- 1. which could identify uniquely a record and yet do not undergo a change. Thanks, Rao -Original Message- Sent: Friday, September 21, 2001 1:35 PM To: Multiple recipients of list ORACLE-L Generally it is bad practice to use columns in the primary key, which change. They introduce many different problems. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Friday, September 21, 2001 12:35 PM To: Multiple recipients of list ORACLE-L List, OLTP application with 24x7 requirement. 300,000 records per day are inserted into the transaction table. Environment: Solari 7. Oracle 817. The transaction table layout. Security ID Account ID Account Type Trade Date And other columns in this table. In the above table, the primary key is -- Security ID + Account ID + Account Type + Trade Date There are many to one relationships built to other child tables from Transaction Table Scenario: User inserts a record into transaction table. In the first record, Account ID value is HP and he might insert a record into the child table (Or this transaction may not insert a record into a child table). After some time, the user queries the original record with the primary key and then changes the value in the column - Account ID to IBM. Now, the original transaction record is NOT UPDATED. A record IS INSERTED with the new values. Also, he might or might not insert a record into a child table with this new values of primary key. Now the user would query the transaction table with Account ID = IBM. But, the user wants to get all the previous records also; in this case, he want to see the record with Account ID = HP also. Also, he want to see the related records from the child tables. I tried with the idea of sequence number generation but it was failing. Any ideas or suggestions are much appreciated. Thanks, Rao Maheswara Rao, Oracle DBA SunGard Securities -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Design Issue - Quick response appreciated
List, OLTP application with 24x7 requirement.300,000 records per day are inserted into the transaction table. Environment: Solari 7. Oracle 817. The transaction table layout. Security ID Account ID Account Type Trade Date And other columns in this table. In the above table, the primary key is -- Security ID + Account ID + Account Type + Trade Date There aremanyto one relationshipsbuiltto other child tables from TransactionTable Scenario: User inserts a record into transaction table. In the first record, Account ID value is "HP" and he might insert a record into the child table (Or this transaction may not insert a record into a child table). After some time, the user queries the original record with the primary key and then changes the value in the column - Account ID to "IBM". Now, the original transaction record is NOT UPDATED. A record IS INSERTED with the new values. Also, he might or might not insert a record into a child table with this new values of primary key. Now the user would query the transaction table with Account ID = IBM. But,the user wants to get all the previous records also; in this case, he want to see the record with Account ID = "HP" also. Also, he want to see the related records from the child tables. I tried with the idea of sequence number generation but it was failing. Any ideasor suggestions are much appreciated. Thanks, Rao Maheswara Rao, Oracle DBA SunGard Securities
RE: Design Issue - Quick response appreciated
In our case, we do not have any other columns --- 1. which could identify uniquely a record and yet do not undergo a change. Thanks, Rao -Original Message-From: Christopher Spence [mailto:[EMAIL PROTECTED]]Sent: Friday, September 21, 2001 1:35 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Design Issue - Quick response appreciated Generally it is bad practice to use columns in the primary key, which change. They introduce many different problems. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax: (707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message-----From: Rao, Maheswara [mailto:[EMAIL PROTECTED]] Sent: Friday, September 21, 2001 12:35 PMTo: Multiple recipients of list ORACLE-LSubject: Design Issue - Quick response appreciated List, OLTP application with 24x7 requirement.300,000 records per day are inserted into the transaction table. Environment: Solari 7. Oracle 817. The transaction table layout. Security ID Account ID Account Type Trade Date And other columns in this table. In the above table, the primary key is -- Security ID + Account ID + Account Type + Trade Date There aremanyto one relationshipsbuiltto other child tables from TransactionTable Scenario: User inserts a record into transaction table. In the first record, Account ID value is "HP" and he might insert a record into the child table (Or this transaction may not insert a record into a child table). After some time, the user queries the original record with the primary key and then changes the value in the column - Account ID to "IBM". Now, the original transaction record is NOT UPDATED. A record IS INSERTED with the new values. Also, he might or might not insert a record into a child table with this new values of primary key. Now the user would query the transaction table with Account ID = IBM. But,the user wants to get all the previous records also; in this case, he want to see the record with Account ID = "HP" also. Also, he want to see the related records from the child tables. I tried with the idea of sequence number generation but it was failing. Any ideasor suggestions are much appreciated. Thanks, Rao Maheswara Rao, Oracle DBA SunGard Securities
RE: Design Issue - Quick response appreciated
Jay, Good thought. Questions: 1. How many prior_ID's do I need to maintain? Logically, user could change any of the columns in a primary key. 2. Say, a transaction udergoes 2 times changes i.e., first time, account_ID is changed. Second time, Security_id is changed. This means, I inserted two records into the transaction table pertaining to original transaction. How do I retrieve earlier three records? i.e., the latest change in the account_id=IBM. If the user is querying based on this, he would get two records. But he would not get the record where he changed security_ID. (My primary key = Security ID + Account ID + Account Type + Trade Date). 3. How do manage and retrieve the records from the child tables? Thanks, Rao -Original Message- Sent: Friday, September 21, 2001 2:26 PM To: Multiple recipients of list ORACLE-L One thought is to have an additional column called something like 'PRIOR_ID'. If the Account_id is changed (actually a new value inserted) then the PRIOR_ID for the new row is set to the ACCOUNT_ID of the old row. That way you can always trace back if the transaction used to have a different account. Jay Miller -Original Message- Sent: Friday, September 21, 2001 12:35 PM To: Multiple recipients of list ORACLE-L List, OLTP application with 24x7 requirement. 300,000 records per day are inserted into the transaction table. Environment: Solari 7. Oracle 817. The transaction table layout. Security ID Account ID Account Type Trade Date And other columns in this table. In the above table, the primary key is -- Security ID + Account ID + Account Type + Trade Date There are many to one relationships built to other child tables from Transaction Table Scenario: User inserts a record into transaction table. In the first record, Account ID value is HP and he might insert a record into the child table (Or this transaction may not insert a record into a child table). After some time, the user queries the original record with the primary key and then changes the value in the column - Account ID to IBM. Now, the original transaction record is NOT UPDATED. A record IS INSERTED with the new values. Also, he might or might not insert a record into a child table with this new values of primary key. Now the user would query the transaction table with Account ID = IBM. But, the user wants to get all the previous records also; in this case, he want to see the record with Account ID = HP also. Also, he want to see the related records from the child tables. I tried with the idea of sequence number generation but it was failing. Any ideas or suggestions are much appreciated. Thanks, Rao Maheswara Rao, Oracle DBA SunGard Securities -- 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: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Design Issue - Quick response appreciated
Christopher, Thanks for the reply. Surrogate key solves the problem of having a record with a unique identifier for a record. But I still have the following problems. 1. How do I link the previous records whenever a query is issued by the user? 2. Please see my requirement below: Scenario: User inserts a record into transaction table. In the first record, Account ID value is HP and he might insert a record into the child table (Or this transaction may not insert a record into a child table). After some time, the user queries the original record with the primary key and then changes the value in the column - Account ID to IBM. Now, the original transaction record is NOT UPDATED. A record IS INSERTED with the new values. Also, he might or might not insert a record into a child table with this new values of primary key. Now the user would query the transaction table with Account ID = IBM. But, the user wants to get all the previous records also; in this case, he want to see the record with Account ID = HP also. Also, he want to see the related records from the child tables. How do I do this? Thanks, Rao -Original Message- Sent: Friday, September 21, 2001 3:17 PM To: Multiple recipients of list ORACLE-L Then use a surrogate key, i.e. sequence number. Numbers that change are not candidates for key, doing so introduces problems in which you are having as well as others. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Friday, September 21, 2001 2:30 PM To: Multiple recipients of list ORACLE-L In our case, we do not have any other columns --- 1. which could identify uniquely a record and yet do not undergo a change. Thanks, Rao -Original Message- Sent: Friday, September 21, 2001 1:35 PM To: Multiple recipients of list ORACLE-L Generally it is bad practice to use columns in the primary key, which change. They introduce many different problems. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Friday, September 21, 2001 12:35 PM To: Multiple recipients of list ORACLE-L List, OLTP application with 24x7 requirement. 300,000 records per day are inserted into the transaction table. Environment: Solari 7. Oracle 817. The transaction table layout. Security ID Account ID Account Type Trade Date And other columns in this table. In the above table, the primary key is -- Security ID + Account ID + Account Type + Trade Date There are many to one relationships built to other child tables from Transaction Table Scenario: User inserts a record into transaction table. In the first record, Account ID value is HP and he might insert a record into the child table (Or this transaction may not insert a record into a child table). After some time, the user queries the original record with the primary key and then changes the value in the column - Account ID to IBM. Now, the original transaction record is NOT UPDATED. A record IS INSERTED with the new values. Also, he might or might not insert a record into a child table with this new values of primary key. Now the user would query the transaction table with Account ID = IBM. But, the user wants to get all the previous records also; in this case, he want to see the record with Account ID = HP also. Also, he want to see the related records from the child tables. I tried with the idea of sequence number generation but it was failing. Any ideas or suggestions are much appreciated. Thanks, Rao Maheswara Rao, Oracle DBA SunGard Securities -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Question on Gaja's Raid Document
List, While reading Gaja's excellent document on Implementing Raid on Oracle Systems, Gaja mentions the following in his document. The degree of striping in the DATA and INDX volumes should also consider factors such as data/index partitioning, availability requirements and support for parallel operations. Please note that 16 datafiles placed on 16 individual drives can support a 16-way parallel operation (if you have memory and CPU to support it and your controller is not out of capacity because all 16 drives engaged at the same time). The same cannot be concluded with 16 datafiles placed on a 16-way RAID volume with 16 drives. The degree of parallelism that you deploy on a 16-way volume will be significantly less, when compared to the former configuration of 16 individual drives. This factor should be factored, when making degree of striping decisions, which in turn controls the number of volumes on your system. Question: Why the degree of parallelism is less on a 16-way volume compared to 16 individual drives? Thanks, Rao -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Sqlplus tunning
If you are on 8i, then use, parallel option. If this option is not set, then, you need to put the following parameter in your init.ora and then bounce the db. The parameter is --- PARALLEL_MIN_SERVERS. Give a value of 30 initially. Then, give a hint in your statement for parallel (Please see the manual for exact syntax. Off hand, could not tell you). Then try your query. If you observe significant time difference, then, set other PARALLEL parameters in init.ora to optimize your system. Rao, Maheswara Rao Oracle DBA -Original Message- Sent: Wednesday, September 19, 2001 2:25 AM To: Multiple recipients of list ORACLE-L try nested query in place of sort join method... - Original Message - Date: Wednesday, September 19, 2001 11:10 am Try to use Index for big table ITEM To avoid full table scan. Create index item_index on item(no); This will speed the process... --- Sinardy [EMAIL PROTECTED] wrote: Hi, I have 2 big tables, ITEM (is about 1 million rows) and RTNITEM (is about 20K rows) When I do: SELECT ITEM.no, NVL(SUM(ITEM.CUSTSOLD), 0), NVL(SUM(RTNITEM.CUSTRTN) FROM ITEM, RTNITEM WHERE ITEM.no=RTNITEM.no GROUP BY ITEM.no; Time to execute above query is to long. I tried CREATE OR REPLACE VIEW proc_view_itemsold AS SELECT no, NVL(SUM(custsold, 0)) AS sold FROM item GROUP BY no; CREATE OR REPLACE VIEW proc_view_itemrtn AS SELECT no, NVL(SUM(custrtn, 0)) as return FROM rtnitem GROUP BY no; SELECT i.no, i.sold r.return FROM proc_view_itemsold, proc_view_itemrtn WHERE i.no = r.no; DROP VIEW proc_view_itemsold; DROP VIEW proc_view_itemrtn; The result is the same, it took more than 25 minutes. Do I have to create a temporary tables instead of view to prevent these two giant tables producing a cardinality product ? In this situation is that possible using inner query with where clause again to prevent those giant tables combined? Thank you, Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Inserting records into a table without creating indexes
List, Environment: Solaris 7 : Oracle 817 : OLTP system with stringent throughput requirements A transaction inserts a record into 4 tables. After successful insert into all the four tables, the transaction issues a commit. Many alternate index keys (AK's) are defined on each table. Expected number of transactions : 300 - 400 transactions per second. Requirement: While insert is taking place on the tables, I do not want to create indexes. Immediately After the transaction is committed, I want to create indexes for the inserted record. I do not want disable the indexes during the transaction processing. Is the above requirement feasible? Or am I on a wrong path? Please advise. Thanks, Rao -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: OT : kernel using 75% of CPU
Jerry, Be aware that the system performance degardes drastically while truss is running. Rao Maheswara Rao -Original Message- Sent: Thursday, August 30, 2001 11:36 AM To: Multiple recipients of list ORACLE-L Hi, Jerry, Next time you see top output like shown below, please provide this information: In SQL*Plus: select * from v$session_wait where sid = (select sid from v$session where paddr = (select addr from v$process where spid = 2286)); may need to run it a few times. Post it to the list (or email me) unless the wait is like 'SQL*Net%' or '%timer%' or 'rdbms%'. And also find the SQL by select * from v$sql where address = (select sql_address from v$session) once you know the SID and On OS: truss -flp 2286 (the first 100 lines or so should be OK; if there's a pause in running truss, indicate where the pause happens) Also let us know if there's anything special in alert.log and any new file in udump. Yong Huang [EMAIL PROTECTED] you wrote: PID USERNAME THR PRI NICE SIZE RES STATE TIMECPU COMMAND 2286 oracle 1 00 1844M 1814M run 9:44 13.90% oracle 11068 oracle 1 00 2056K 1536K cpu00:02 1.53% top 11333 oracle 1 00 1150M 1124M cpu10:01 1.39% oracle __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: yong huang INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: !! Keeping the list alive
Title: RE: !! Keeping the list alive I support. -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 30, 2001 11:22 AMTo: Multiple recipients of list ORACLE-LSubject: RE: !! Keeping the list alive AMEN! -Original Message- From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 10:46 AM To: Multiple recipients of list ORACLE-L Subject: RE: !! Keeping the list alive no, those posts keep us "underworked" DBAs from killing the duhvelopers who make us do the same thing over and over and over and who never listen when we tell them the correct way to design the tables. :) From: "Boivin, Patrice J" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: !! Keeping the list alive Date: Thu, 30 Aug 2001 04:00:52 -0800 Just look at the number of OT postings in the last couple of months... : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 7:58 PM To: Multiple recipients of list ORACLE-L Subject: RE: !! Keeping the list alive You're surprised at those willing to pay? You have to realize that most DBAs are over-payed and under-worked ducking -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 1:43 PM To: Multiple recipients of list ORACLE-L Subject: !! Keeping the list alive This list is apparently a more valuable resource to many of you than I realized. I'm literally bowled over by the generosity. I've received so many emails about this that I really can't personally reply to them all right now. -- 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: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: RE: financial problems with fatcity.com
Title: OT: RE: financial problems with fatcity.com Ross, We need to give free ride to you also. Without your wit, the list some times becomes drag with too much of a heavy techie stuff. (just pulling :) ) Rao -Original Message-From: Mohan, Ross [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 30, 2001 12:22 PMTo: Multiple recipients of list ORACLE-LSubject: RE: RE: financial problems with fatcity.com Guys like Lewis, Adams, Uni-Bomberism, etc. both add value and get advertising for their ownsites/products. I think it balances out well enough to not worry about it. For me, I'd be happy to see them get a free ride, but would rather have a Benevolent Dictator ( Jared/Bruce ) make this call. my $0.02
RE: OT : kernel using 75% of CPU
Title: Message Jerry, On solaris you could run the same command. Here is the path: /usr/ucb/ps -aux Rao Maheswara.Rao @ Sungardp3 . com -Original Message-From: Jerry C [mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 28, 2001 4:17 PMTo: Multiple recipients of list ORACLE-LSubject: Re: OT : kernel using 75% of CPU Does anybody know how I can see how much memory each process is using under Solaris. On Digital UNIX it was ps -aux, if I remember correctly... Thanks! Jerry - Original Message - From: Jerry C To: [EMAIL PROTECTED] Sent: Tuesday, August 28, 2001 2:58 PM Subject: Re: OT : kernel using 75% of CPU Thanks for the reply, Chris. I'm a bit ashamed, being as old as I am, that I don't have a better grasp on swapping. I initially thought maybe it was a swap problem also, but top shows 0.0% swap. I thought I had also checked vmstat earlier, but yikes: csuaor46 csuaor46 vmstat 15 20procs memory page disk faults cpur b w swap free re mf pi po fr de sr s6 s1 s1 s5 in sy cs us sy id2 0 0 15352 14472 68 1513 14 227 953 56488 260 0 2 2 0 638 78 933 25 24 5011 0 0 6240696 63336 105 1759 41 246 1754 62760 545 0 8 8 0 1130 4956 773 22 76 111 0 0 6243360 62864 42 2594 82 236 2357 62760 757 0 7 6 0 1239 6960 987 40 60 18 0 0 6238120 62368 48 1746 25 260 3767 56488 1198 0 7 6 0 1052 4837 762 36 63 18 0 0 6239640 65200 33 1772 229 262 2092 62760 619 0 16 16 0 1232 5776 871 28 70 25 1 0 6247656 62440 57 2078 162 497 4025 62760 1308 0 15 15 0 1216 5808 815 21 75 45 0 0 6247776 63456 26 2445 149 285 2716 62760 2188 0 11 13 0 1164 6593 903 17 79 410 1 0 6240680 62648 80 3008 266 523 4527 62760 9226 0 25 25 0 1127 6725 884 22 76 26 0 0 6218216 68664 33 2251 66 105 1086 62760 377 0 6 6 0 847 20782 744 31 67 25 0 0 6201240 62840 9 1799 72 350 2490 62760 415 0 9 9 0 1207 8889 781 15 80 55 0 0 6199336 62760 6 1935 40 923 3564 62760 636 0 9 9 0 1373 5193 1082 21 69 1010 0 0 6189552 63840 11 1476 33 722 3089 62760 548 0 9 8 0 1364 4530 957 21 77 210 0 0 6174304 70704 25 2705 86 759 6441 62760 1003 0 10 10 0 1258 5551 836 29 67 48 0 0 6186512 63824 51 1728 44 227 1413 56488 188 0 9 7 0 1319 4485 676 31 68 07 0 0 6196448 63064 49 1635 44 235 1179 62760 167 0 4 4 0 1207 4968 694 39 61 19 0 0 6188656 63872 11 1915 112 433 2065 62760 308 0 13 12 0 1140 4835 828 37 62 1 Do the pi (page in) and po (page out) statistics represent swapping?! Thanks again, Jerry - Original Message - From: Christopher Spence To: Multiple recipients of list ORACLE-L Sent: Tuesday, August 28, 2001 1:30 PM Subject: RE: OT : kernel using 75% of CPU paging and swapping is the first thing that comes to mind, look at vmstat. I think your question is completely on topic. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax: (707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message-From: Jerry C [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 28, 2001 11:20 AMTo: Multiple recipients of list ORACLE-LSubject: OT : kernel using 75% of CPU Hi there, I have a Sun e4500, running Solaris 2.7 and Oracle8.1.7.1.0. Everything looks normal from a database perspective, but when I run "top" it show the kernel being very hog-like: load averages: 14.38, 15.18, 15.18 07:16:21126 processes: 118 sleeping, 4 running, 4 on cpuCPU states: 0.6% idle, 26.6% user, 72.8% kernel, 0.0% iowait, 0.0% swapMemory: 4096M real, 63M free, 216M swap in use, 5310M swap free PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND2286 oracle 1 0 0 1844M 1814M run 9:44 13.90% oracle11068 oracle 1 0 0 2056K 1536K cpu0 0:02 1.53% top11333 oracle 1 0 0 1150M 1124M cpu1 0:01 1.39% oracle5944 oracle 1 40 0 1820M 1789M sleep 14:40 1.36% oracle4797 root 1 50 0 2112K 1248K sleep 6:01 1.36% top11346 oracle 1 0 0 110M 92M cpu0 0:01 1.26% oracle4 oracle 1 0 0 1009M 984M cpu1 0:00 0.66% oracle11157 oracle 1 0 0 1009M 984M run 0:00 0.63% oracle11368 oracle 1 33 0 1794M 1765M sleep 0:00 0.29% oracle19558 oracle 1 60 0 1797M 1751M sleep 78:28 0.28% oracle19554 oracle 1
RE: is C compiler a must for oracle UNIX installations ?
Rahul, I installed different versions of Oracle (804,816,817) on Sun boxes without c compiler. Oracle installation went through. By this, I could say that on Sun Solaris machines we do not require c compiler for Oracle installation. Perhaps, on HP boxes the story might be the same or different. Rao [EMAIL PROTECTED] -Original Message- Sent: Thursday, August 16, 2001 1:35 AM To: Multiple recipients of list ORACLE-L some of my friends are telling me that they have succesfuly installed oracle 7.3.1 on AIX 4 WITHOUT the C compiler present.. !! and i was the one telling them how oralce requires to relink the executables after the installation. Regards -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Usage of Number type for table columns - Thanks to all
Thank you all who took the time to answer the above question. Now, I am going to allow columns types as floating. I copied all the replies to this question so that somebody could benefit from this. Once again thanks to Dick Goulet, Kevin Lange, David A. Barbour, Galen Boyer. Replies to the above question. --- The boss is somewhat right, but are you absolutely certain that the current program interface to the data will remain forever? What is the likelihood of someone having to correct the data via SQL*Plus or some other method where the restrictions will have no effect. The main reason of applying the constraints at the database level is that is the lowest level of granularity for the data and consequently the one place where one can be absolutely certain that business rules get applied irregardless of where the data comes from. Dick Goulet I hate to be on the side of management but much time is spent going back and resizing fields and applications because the field defined is no longer big enough. Been there and done that many times. Kevin Lange - In this case, I think your boss is right. If you feel the need to have some integrity checking at the DB level, use FKs. CHECK and possibly NOT NULL constraints will subject you to the type of application/database maintenance a well-thought out plan should endeavor to avoid. Just be sure that your use of the foreign key is tightly tied to business rules. As an example, a three digit location code in a telecommunications package could tie back to an NPA_NXX_PAIR_CODE table. If for whatever reason this becomes a four-digit number (skip the technical explanations of why that will NEVER happen, just think of the logical approach - we dial 1 to get long-distance, why not a an additional digit(s) to access a region, kind of like what you do now if you use one of those 10-10 numbers), you will still have a valid app (although you may have to do some updates on existing records). David A. Barbour -- on Wed, 15 Aug 2001, [EMAIL PROTECTED] wrote: In one of our applications, my boss wants to define all the numeric columns as NUMBER or leave it as floating point. He wants to define all the tables like this wherever numeric column is defined in the table. Example: Location_ID NUMBER We know, from our application character, that this location_ID would never cross beyond 3 digits. Today you know this, but it could change, so allow for it. Also, we know that this specific column does not require any digits to the right of the decimal point. --- (This column is only an example). It sounds like you are going to have intelligence in this key. I would recommend against that one. He does not want to specify any precision or scale for the number type columns. His point is --- Oracle would use only that much space depending on the actual number of digits he enters into the column. Thus, he is not wasting any space. But Oracle will have a bit of a performance hit when it joins to this table on a number (I assume alot of these columns will be PK's). I believe it is the same penalty that Oracle encounters when it has to query a varchar vs char field, it has to figure out how far to look with the varchar where it doesn't with a char, and the opposite argument also holds, the varchar is much more flexible than the char. So, if these are going to be used to join tables together alot, you might want to consider a straight integer sequence. Also, he says, during the beginning of application, we might not know the maximum limits for number column. Hence, leaving them as floating point ( Location_ID NUMBER), gives him flexibility and he need not change the number column precision or scale during the entire life cycle of the application. Once again, it sounds like you have intelligence in these keys. He says, it is upto the application program (JAVA/EJB) to control and check the maximum length permissible against a column depending on the business rules. Yes and no. It is ultimately up to the DB to protect itself, but the app shouldn't rely on the DB's protection to get it correct. -- Author: Galen Boyer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want
Usage of Number type for table columns
List, In one of our applications, my boss wants to define all the numeric columns as NUMBER or leave it as floating point. He wants to define all the tables like this wherever numeric column is defined in the table. Example: Location_ID NUMBER We know, from our application character, that this location_ID would never cross beyond 3 digits. Also, we know that this specific column does not require any digits to the right of the decimal point. --- (This column is only an example). He does not want to specify any precision or scale for the number type columns. His point is --- Oracle would use only that much space depending on the actual number of digits he enters into the column. Thus, he is not wasting any space. Also, he says, during the beginning of application, we might not know the maximum limits for number column. Hence, leaving them as floating point ( Location_ID NUMBER), gives him flexibility and he need not change the number column precision or scale during the entire life cycle of the application. He says, it is upto the application program (JAVA/EJB) to control and check the maximum length permissible against a column depending on the business rules. I do not know whether this is a correct approach. Intuitively, I feel that this approach is not correct. However, I am not able to come up with any valid reason to negate his approach. Please inform whether the approach is correct or having any problems, from your experience. Thanks, Rao [EMAIL PROTECTED] DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
What privileges are required for Shareplex?
List, We are installing Shareplex. Could any of you tell what privileges are required for a shareplex user? The customer support person from QUEST says that shareplex user requires DBA privileges. Is it correct? Thanks Rao [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: AutoExtend
Michael, Login as a dba user and execute the following query. select tablespace_name, file_name, autoextensible from dba_data_files order by tablespace_name; You will see either - YES or NO under autoextensible column. Rao [EMAIL PROTECTED] -Original Message- Sent: Friday, July 20, 2001 11:51 AM To: Multiple recipients of list ORACLE-L How can I determine if tablespaces are set up in autoextend? -- Author: Michael E. Cupp, Jr. INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Why this SQL does not work? - Thank You All
I thank all the people that took time to clear the question. Kevin Lange babu Jack C. Applewhite Regina Harter Henry Poras Stephane Faroult I thank all of the above. Your timely response helped me in clearing the question from my developers. Thanks, Rao [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Why this SQL does not work?
List, Following are two SQL statements. The first SQL statement works OK (where ROWNUM 5 is used). The second SQL statement does not return any rows (where ROWNUM = 5 is used). This table contains 200 records. First SQL statement --- SELECT * FROM (SELECT PROCESSED_DATE FROM TRADES WHERE PROCESSED_STATUS = 0 ORDER BY ENTRY_DATE) WHERE ROWNUM 5 Second SQL statement SELECT * FROM (SELECT PROCESSED_DATE FROM TRADES WHERE PROCESSED_STATUS = 0 ORDER BY ENTRY_DATE) WHERE ROWNUM = 5 --- Question: Why second SQL statement does not work? I would be thankful for the clarification. Thanks, Rao [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Pentium 4 (gotta love wintel) install (attempt)
Shaw, I installed 817 on P4 with 1.5ghz. Yes. During the installation I had to use those workarounds. However, I did not face any problem for listener. Please tell what problem you are facing for installing listener. Rao -Original Message- Sent: Tuesday, July 03, 2001 10:25 AM To: Multiple recipients of list ORACLE-L Trying to install 8.1.7 on a new P4 and it wouldn't. Scanned metalink and found the work arounds (no patches yet), and I still can't get it to install the listener (installed the database and client so I can use sqlplus just no listener). Any one have the secret of how this actually works? -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Common Oracle RDBMS Misconceptions
Rachel, I am interested in reading your paper - Exploding the Myths. How do I get access to this paper? Is it available on any website? Thanks Rao -Original Message- Sent: Tuesday, June 26, 2001 1:57 PM To: Multiple recipients of list ORACLE-L Jeremiah, Marlene and I did an exploding the myths paper very similar to what you are doing.. always set pctincrease on your temporary tablespace to 1 and my OOW submission is very very similar to yours. Not quite, but really close. It will be interesting to see if they choose one, both or neither of our papers :) Rachel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Installed Product Info
Terry, Oracle 816 maintains inventory location depending on your $ORACLE_BASE environment variable settind during Oracle installation. Ours is Solaris environment. On solaris following directories contain inventory info. 1. /var/opt/orace --- After the installation, a text file by name - oraInst.loc -- is created in this directory. This file contains the inventory location. 2. Inventory location - $ORACLE_BASE/oraInventory. 3. Now this $ORACLE_BASE/oraInventory/logs/installActions.log --- this file contains all the products installed. 4. If you vi the above file (in step 3 above), and scroll upto the line - Current Inventory: - you will see all the products installed. The above info is valid for solaris environment. Please check your AIX environment. Hope the above helps. Rao [EMAIL PROTECTED] -Original Message- Sent: Monday, June 18, 2001 12:31 PM To: Multiple recipients of list ORACLE-L We have installed 8.1.6 on several AIX nodes and some of them are showing no installed product thru OUI. We would like to have _all_ of them look the same without having to re-install oracle. I think I remember someone saying that there is/are file(s) that keep this info. Does anyone know what is necessary to get this info without the full install? TIA Terry -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 8i database ER diagram
Magesh, You could use either of the following tools to build your ERD through reverse engineering. 1. Oracle Designer 2. ERWIN In my company we use both the above products. I personally prefer using Oracle Designer due to many reasons (My reasons are irrelevant here for the purpose of answering your question). If it is one time job, then you could download either of the products free (Please check whether you could do reverse engineering with a free downloaded version). Rao -Original Message- Sent: Tuesday, June 12, 2001 7:01 AM To: Multiple recipients of list ORACLE-L What about to use Oracle Designer?. Regards. Miguel Urosa. 12/06/2001 11.00 magesh [EMAIL PROTECTED] 12/06/2001 11.01 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Shared server model
Raj, Your bosses idea might be OK with the following conditions. 1. If your database size is small (what is small is relative term. I consider a database small if it is less than 200 GB) 2. If the number of users accessing the database is less (around 50 users). 3. If you have big server with large amount of memory (more than or equal to 4 GB) and more than or equal to 4 processors. And no other application is competing for hardware resources. 4. If your server is a unix box (Forget doing this idea on NT. If your boss insists on NT, then start brushing up your resume!!). 5. If you have backup plans for your database. The list could give you suggestions, if you come out with your database size, number of users, type of database (OLTP/DSS), the hardware configuration etc. Rao -Original Message- Sent: Tuesday, June 12, 2001 8:11 AM To: Multiple recipients of list ORACLE-L DBAs, I am working for a web developing and hosting company. My boss came out with an idea of putting all the DB in a massive(!!) server so that we dont need to have seperate server for each DB. He argues this is better idea than having DB server for each site. I am not sure how this will work. Any thoughts on this would be helpful to me.. Thanks Raj -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Enforced Costraints ??
Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Daemen, Remco INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 do IMP EXP - SOS
Title: How do IMP & EXP - SOS Deewaker, You did not mention what is the version of Oracle 8i. I am assuming it is higher than Oracle 815. In this case do the following steps. 1. Take export of the schema using exp from Oracle 815. To do this , you can connect to your source database using a connect string thru tnsnames. 2. Once you have the dmp file, then use the imp of Oracle 815 to do import into Oracle 815. Rao [EMAIL PROTECTED] -Original Message-From: Deewaker G.V. [mailto:[EMAIL PROTECTED]]Sent: Monday, June 11, 2001 3:51 AMTo: Multiple recipients of list ORACLE-LSubject: How do IMP EXP - SOS hi I need to do the IMP of a dmp file from Oracle 8i to 8.1.5 can you guys pls help me how to go about it with warm regards deewaker g v
RE: What next ?
I sent Mladen Gogala's mail to my boss and to a couple of managers. Everyone had a nice laughter and of course, now, they know about DBA. Thanks Mladen for your nice one. Rao -Original Message- Sent: Friday, June 08, 2001 1:20 PM To: Multiple recipients of list ORACLE-L Mladen Gogala for president! Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Thursday, June 07, 2001 2:56 PM To: Multiple recipients of list ORACLE-L Nope. DBAs are chosen, not trained. To become a good DBA one must go to Mt. Sinai and talk to a burning bush. If the bush talks back, then the applicant will have the power to split the seas of data into partitions. Instead of appealing to pharaoh to let his people go, the real DBA uses the phrase will you, please, lay off that @#! beeper and leave me alone?. DBAs communicate with the developers/users in terms of commandments. Disobeying them can have excruciating consequences for all those who dare to disrespect a DBA. To make, the long story short, being a DBA is a calling and not a job. Sincerely yours, BDBAFH -Original Message- Sent: Thursday, June 07, 2001 11:41 AM To: Multiple recipients of list ORACLE-L At 09:50 PM 6/6/01 -0800, you wrote: Do you want a paper to say you are marginally qualified to be a DBA or do you actually want to learn database administration? To a large extent I agree with you about the relative unimportance of paper qualifications. However, one thing that a formal course of study is good for, is to make you aware of all the nooks and crannies of your chosen subject. For instance, if you are self-taught, and the subject of replication never comes up, you may never even *know* that it exists. Or, unless you are very self-disciplined, you may never do anything with crash recovery until actually presented with the need (a bad time to be learning it, IMO). So if you are going to go the self-study route, have a formal plan of some kind -- whether it's getting hold of the course curriculum for Oracle courses, of just getting some good DBA books and going through them beginning to end. Dennis Taylor Living with a saint is harder than being one. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis Taylor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: What next ?
, June 06, 2001 9:55 PM Hello friend , Gurus I just start my Oracle developer job in April 2001, I feel interesting in Oracle Dba jobs but my current job is stuck with only application development .How can I build up my DBA skill if I did't have chance on doing the related jobs ? But I manage to build up a small system running testing in my home with Duron 750 + 128 Ram and 10 gig normal IDE , After I install my win2kpro ,oracle OEM and the database with pre-configuration option. everthing go smooth on that. I have manage to get a TOAD trial version to install in my win2k too , but what now ? Is there any pratical or tutorial on this ? Or taking the OCP exam and exam cram to study will help ? Raymond fall asleep in waiting for the Q. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Autologout of idle users
Mark, Create profile and assign the profile to the user. Also, enable resource limits to take effect. Following is an example for creating a profile. Step 1. CREATE PROFILE duh1 LIMIT SESSIONS_PER_USERUNLIMITED CPU_PER_SESSIONUNLIMITED IDLE_TIME 30 ; Step 2. Assign the profile to the user or to the users whom you want to limit idle sessions time. ALTER USER SCOTT PROFILE duh1; Step 3. Connect to the system through SQL with DBA privileges. ALETER SYSTEM RESOURCE_LIMIT TRUE; In the above example, if the user exceeds idle time 30 minutes, then Oracle end's the session. ONE CAUTION: Be very careful with some of the irate developers or with lazy developers who do not log out ever. To avoid the clashes, send a mail to every body that you are implementing this idle time and let evey body know in advance. Rao -Original Message- Sent: Thursday, June 07, 2001 4:31 AM To: Multiple recipients of list ORACLE-L Check out PROFILES which can be used to achieve what you are after. hth connor --- Mark Liggayu [EMAIL PROTECTED] wrote: What commant should I use to automatically logout uses in oracle who has been idle for more than 30 minutes? We have UNIX as an OS. Thanks, Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Liggayu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 price politics
ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Your views on Quest - Shareplex - Thank you all
Thank you all for giving your time to express your opinions. I would be consolidating all the opinions I received in the list and send a mail within the next two days. I hope, this consolidation would help for any future queries on this subject. Thanks, Rao [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ok two databases..two machines..one database name
We have two 804 db's with same sid running on two different machines. One is production and another is development. Our TNSNAMES contain machine_name + sid. This way we identify which db we are connecting. Initially I had lot of problems getting OEM recognize these two db's. When I called up Oracle support, they said that I cannot have two db's with same sid and global name and OEM agent would not recognize. Essentially, they washed off their hands clean. Then, I played around with the intelligent agent file and finally OEM started recognizing the two db's. ONE CAUTION: Keep your archived redo's stored separately and come up with a plan on identifying which tape belongs to what machine. Passwords, yes, be careful. Rao -Original Message- Sent: Thursday, May 24, 2001 8:41 PM To: Multiple recipients of list ORACLE-L I have been tasked with moving a production database to a 'backup' machine. I ran my plan past you a week or so ago. Essentially I will put the DB in backup mode, copy the datafiles, shutdown, copy redo and control files, then recover on the second machine. So far plain vanilla. I understand the above procedure enough to have actually thought of it. My problem now is this. I need to test this instance on the 'backup' machine before we actually do the move. This is Just to make sure the application is completely in order. One of the developers is telling me that having the two databases up and running with the same SID, even on separate machines MAY cause trouble for the production instance. I believe that if I make sure the tnsnames.ora file for both servers points to their own local instances, that I will not have a problem. The clients will only access the database pointed to in their tnsnames files, so I am confident we are ok there. My question is can I have databases with the same name running simultaneously on two different machines if I make sure the tnsnames for each database points to it's own server? The database is 7.3.4. As soon as I send this off I am going to create a small DB just to test this out, but your input, as usual, is appreciated. Thanks, Steve McClure -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Full user export
At the OS level give the following command. exp owner=user name Now, the program will ask you the username. This time either give a user name who has dba priviliger or give the same user name you mentioned in the above command (exp owner=username) If you had given the dba user name, then while importing you need to import the file into that specific user using the dba user name. hth Rao -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 9:16 AM To: Multiple recipients of list ORACLE-L Hi DBA's What is the proper syntax of the exp command to get export of all objects owned by a user - tables, views, stored procedures, synonyms, grants. And will the import require special parameters too? I have a small development database on Windows NT and would like to create a copy on Windows Me running Personal Oracle for Win 98. When I duplicated the database to anotehr Windows NT machine it was simple - copy all datafiles, mount the database, update control files, etc. But here I have different operating systems so can not simply copy files. Thanks Witold -- 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: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: cdump, bdump, udump
I also monitored the processes and found that alert.log file is constantly accessed at least by one Oracle process during a period of one hour continuous monitoring. Hence, my conclusions: 1. By removing alert.log, the space would not be reclaimed by the disk on Unix machines immediately until you bounce the db. 2. Perhaps, on rare occasions, the space is reclaimed by the disk without bouncing the db. But this, in my opinion, is a rarity. Thanks, Rao [EMAIL PROTECTED] -Original Message- Sent: Tuesday, May 15, 2001 7:46 PM To: Multiple recipients of list ORACLE-L I tried the 'alien' weapon - fuser - against the alert.log file. There are 18 oracle processes accessing it. A simple rm will delete the file handle but apparently not actually release the space without bouncing the database. Lesson learned. And, that's my limit for today. Pete Barnett Oracle Database Administrator Regence BlueCross BlueShield [EMAIL PROTECTED] On Tue, 15 May 2001, Rajaram wrote: Look like this message did not get thru.. sending again. Pl. Ignore if repeat 1. Space occupied by alert.log is freed once you delete the file. 2. You may not see an immediate reclamation of free space. Try to do sync ( In solaris) and notice the free space. Also, try more than one method of free space checking - Using du, bdf, sam or sysadmin tools. -Original Message- From: Rao, Maheswara [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 2:50 PM To: Multiple recipients of list ORACLE-L Subject: RE: cdump, bdump, udump Terry, I tested this again now. I removed alert.log and then checked disk usage. It did not release the disk space. Then I bounced the db. Now, the disk space is released. Environment: Solaris 7, 64 bit. Oracle 817. Rao [EMAIL PROTECTED] -Original Message- Sent: Tuesday, May 15, 2001 12:36 PM To: Multiple recipients of list ORACLE-L On Solaris 2.5, 2.6 and 2.7, as well as AIX we have removed the alert.log and space has immediately become free. (Not true with the listener.log however). Terry Rao, Maheswara wrote: Ron, You would not be able free the disk space even if alert.log is deleted. For example, if alert.log file size is 500 MB size and then you delete the alert.log, still you would not be able to get a disk free space of 500 MB. This space would be released once you bounce the database. The above scenario is similar even if you copy alert.log to a different location and then delete the rows. The above scenario applies to Solaris environment. I do not know what happens in NT environment. Rao [EMAIL PROTECTED] -Original Message- Sent: Wednesday, April 25, 2001 10:39 AM To: Multiple recipients of list ORACLE-L Team, Correct me if I am wrong, please.. If you delete the alert.log file with the database up and running, the oracle still thinks the file exists and writes to a non existant file that you can't see. The proper method of reducing the file size is to copy the file to a backup location, and edit the original and delete rows from the file. OR if you do not need to keep the original log for analysis you could copu /dev/null alert.log. Just a house keeping note. ROR ma?am [EMAIL PROTECTED] 04/24/01 09:21AM Sinardy, First, I suggest you find some time and sit down and READ the Oracle documentation. Otherwise you are going to get a large number of RTFM emails, and some flaming as well. Now.. the alert log is created (if it does not already exist) or written to every time Oracle wants to record an event that has happened in the database/instance. So log switches will be in there, database shutdown and startup messages, errors dealing with the infrastructure of the database (failure to extend a rollback segment, failure to get space in the temp segment, disasterous database errors etc) There are other messages as well, I'm not going to list every one. Bdump contains trace files that relate to the Oracle background process -- anything generated by smon, pmon, etc Udump contains trace files that relate to specific user Oracle processes Cdump contains core dumps, associated with one or another trace files in the bdump directory. Rachel From: Sinardy Xing [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: cdump, bdump, udump Date: Tue, 24 Apr 2001 03:40:27 -0800 Hi all, When those logs will created ? Thank you Sinardy -Original Message- Sent: Tuesday, 24 April 2001 9:41 AM To: LazyDBA mailing list Hi DBAs and SAs, I had a task to do housekeep ...\bdump\alertSID.log What logs usually Oracle system need to housekeep, and what are these directory cdump, bdump and udump for ? NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today
RE: job offer from SAUDI ARABIA
Bunyamin, I worked in Saudi Arabia for 5 yrs. (approx.). I could help you and clarify your various other questions. If interested, please contact me directly. Rao [EMAIL PROTECTED] -Original Message- From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 16, 2001 8:50 AM To: Multiple recipients of list ORACLE-L Subject: job offer from SAUDI ARABIA Hi all , I have taken an offer from a company in Europe to work in Saudi Arabia for 2 years. But I must learn the living conditions there. f there is an Arabian here , can you answer these.. 1) How are the living conditions?Expensive? 2) Will my wife have to cover her hair? Is it mandatory there? 3) How are the social activities like cinema? Thanks.
RE: Vocabulary
It is unit of measurement in India. One Lakh = 100, 000 Rao [EMAIL PROTECTED] -Original Message- Sent: Wednesday, May 16, 2001 1:56 PM To: Multiple recipients of list ORACLE-L I have seen this several times, and I am very curious as to what lakhs are. Is this a standard of measurement? At 10:35 PM 5/15/01 -0800, you wrote: Dear DBA Gurus, I have some static data in two of my tables which contains lakhs of records. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Regina Harter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: cdump, bdump, udump
). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: cdump, bdump, udump
OK. I would test this. scheduled a cron to run in the night to remove alert.log (of course after copying!!). Rao [EMAIL PROTECTED] -Original Message- Sent: Tuesday, May 15, 2001 4:55 PM To: Multiple recipients of list ORACLE-L Do you have frequest writes to your alert log? If you try to remove will it is being written to, it will not release the space. We tend to remove our logs during periods of low acitivity, so the file is not likely to be being written to. So we have not seen the space not released. Terry Rao, Maheswara wrote: Terry, I tested this again now. I removed alert.log and then checked disk usage. It did not release the disk space. Then I bounced the db. Now, the disk space is released. Environment: Solaris 7, 64 bit. Oracle 817. Rao [EMAIL PROTECTED] -Original Message- Sent: Tuesday, May 15, 2001 12:36 PM To: Multiple recipients of list ORACLE-L On Solaris 2.5, 2.6 and 2.7, as well as AIX we have removed the alert.log and space has immediately become free. (Not true with the listener.log however). Terry Rao, Maheswara wrote: Ron, You would not be able free the disk space even if alert.log is deleted. For example, if alert.log file size is 500 MB size and then you delete the alert.log, still you would not be able to get a disk free space of 500 MB. This space would be released once you bounce the database. The above scenario is similar even if you copy alert.log to a different location and then delete the rows. The above scenario applies to Solaris environment. I do not know what happens in NT environment. Rao [EMAIL PROTECTED] -Original Message- Sent: Wednesday, April 25, 2001 10:39 AM To: Multiple recipients of list ORACLE-L Team, Correct me if I am wrong, please.. If you delete the alert.log file with the database up and running, the oracle still thinks the file exists and writes to a non existant file that you can't see. The proper method of reducing the file size is to copy the file to a backup location, and edit the original and delete rows from the file. OR if you do not need to keep the original log for analysis you could copu /dev/null alert.log. Just a house keeping note. ROR mª¿ªm [EMAIL PROTECTED] 04/24/01 09:21AM Sinardy, First, I suggest you find some time and sit down and READ the Oracle documentation. Otherwise you are going to get a large number of RTFM emails, and some flaming as well. Now.. the alert log is created (if it does not already exist) or written to every time Oracle wants to record an event that has happened in the database/instance. So log switches will be in there, database shutdown and startup messages, errors dealing with the infrastructure of the database (failure to extend a rollback segment, failure to get space in the temp segment, disasterous database errors etc) There are other messages as well, I'm not going to list every one. Bdump contains trace files that relate to the Oracle background process -- anything generated by smon, pmon, etc Udump contains trace files that relate to specific user Oracle processes Cdump contains core dumps, associated with one or another trace files in the bdump directory. Rachel From: Sinardy Xing [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: cdump, bdump, udump Date: Tue, 24 Apr 2001 03:40:27 -0800 Hi all, When those logs will created ? Thank you Sinardy -Original Message- Sent: Tuesday, 24 April 2001 9:41 AM To: LazyDBA mailing list Hi DBAs and SAs, I had a task to do housekeep ...\bdump\alertSID.log What logs usually Oracle system need to housekeep, and what are these directory cdump, bdump and udump for ? Thank you for your time Sinardy Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 8i installation problem on Pentium 4
I had this problem while installing on my Pentium 4 machine. I raised a tar for this and as per their instructions, I could install 817 on Pentium. I quoting the contents of the tar for your reference. If you have any problems, please contact me directly. Oracle Tar instructions: Please review bug 1507768 and doc id 131299.1 out on metalink, you can view them by doing an 'advanced' search This is a known issue with the OUI and Intel pentium 4. The workaround is listed in note 131299.1 If you have problems with this you can follow the simplied instructions below.. Problem: Oracle Universal Installer will not run on Intel Pentium Machines Solution: 1. Create a temporary directory on your server. 2. Copy the contents of the Oracle Server CD to the temporary directory created in step 1. 3. Search the directory structure created in step 1 for the existence of the filename symcjit.dll. 4. Rename each copy of the symcjit.dll to symcjit.old. 5. Run the setup.exe from the \install\win32 directory and install Oracle 8.1.x. Rao [EMAIL PROTECTED] -Original Message- Sent: Monday, May 14, 2001 12:31 PM To: Multiple recipients of list ORACLE-L Hi, everyone: I had problem installing Oracle 8.1.7.0 on my Petium 4 machine running Windows Me. I changed the scripts to use -nojit option, however, when I was installing, only Oracle Cllients was installed. Any idea? TIA Matt -- 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: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Order of columns in a table
Select column_name, column_id From user_tab_columns Where table_name = 'YOUR TABLE NAME'; Rao [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 10, 2001 3:01 PM To: Multiple recipients of list ORACLE-L Hi! How can I find out what the order of columns in a table is? If I do a select * from tablename, the columns appear in a specific order. The same order than they appear when I do a describe tablename. I can even do an insert without specifying the columns in my VALUES (.,) when they are in that specific order. How and where can I find the order of the columns within a table? Any ideas? Yhis is 8.1.6 on Win2k. Thanks, Helmut -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: multiple schema in a database ???
Ours is ASP environment and each customer has a different schema. Make sure 1. Your database BR procedures are correctly implemented and tested with recovery scenarios. 2. If possible, take an export and incremental exports and test your exports. Rao [EMAIL PROTECTED] -Original Message- Sent: Monday, May 07, 2001 9:26 AM To: Multiple recipients of list ORACLE-L Having multiple schemas is a very normal part of an Oracle Database. For example, our current database has 70 different schemas [EMAIL PROTECTED] 05/07/01 03:00AM Andrea Oracle schrieb: Hi all, We'll have a meeting about the following issue: Due to large amount of transactions each trainee has, the existing training database in Sybase used multiple databases to handle each trainee's transactions. To implement this in Oracle, we may need to create multiple schemas in one Oracle database, instead of creating multiple Oracle databases. Let's investigate the impact of having multiple schema in a database. Looks like Public synonym needs to be get rid off. Any other idea about the impact of having multiple schema? And is there an easy way to create a schema which is identical to another one? Thank you. Andrea __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rename Datafile
You do not need to shut the database. Only take the tablespace offline where the datafiles are reorganized. Rao [EMAIL PROTECTED] -Original Message- Sent: Monday, May 07, 2001 10:56 AM To: Multiple recipients of list ORACLE-L Dear DBAs Question about alter database rename file '/oldlocation/datafile1' to '/newlocation/datafile1'; This command ususal to move a datafile to a new location. In case of rename file, I mean here '/oldlocation/datafile1' to '/newlocation/newdatafilename'; or '/oldlocation/datafile1' to '/oldlocation/newdatafilename'; I have never seen anybook mention this I guess step is 1. shutdown database (normal or immediate) 2. cp /oldlocation/datafile1 /newlocation/newdatafilename or mv /oldlocation/datafile1 /oldlocation/newdatafilename 3. startup restirct mount; 3 alter database rename file '/oldlocation/datafile1' to '/newlocation/newdatafilename'; or '/oldlocation/datafile1' to '/oldlocation/newdatafilename'; 4. check status of v$datafile 5. restart database Any suggestiion? Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mitchell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
What is best practice - differenet schema/different dbs
List, I would like to have your opinion on the following scenario. We are having an application which is used by different customers (around 15 customers). On an average each customer will have around 1,000 transactions per 5 minutes. Now, is it better to have a separate database for each customer on the same machine or to create all the customers as different schema in one single database? What are the pros and cons. I am specifically looking at performance and security issues. Environment: This application is a 24x7 environment, OLTP application. Sun 6500 Solaris 7 with 4 CPUS. Raid 10. Memory 4 GB (memory can be increased if required). Oracle 816. Thanks, Rao -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 security ?
UID 0 means root user. Root user by definition can access any file in the system. Rao -Original Message- Sent: Tuesday, March 27, 2001 10:41 AM To: Multiple recipients of list ORACLE-L Just make sure that the non-owner performing backup has the UID 0. -Original Message- Sent: Monday, March 26, 2001 8:00 PM To: Multiple recipients of list ORACLE-L Hi guys, (With - Solaris 2.7) Do you have any solution how to allow "non owner" to perform backup ? with "tar command" For example: myfile.txt rw--- can you solve this puzzled ? If you think I need to write a unix script would you please teaching me and showing me the steps ? Thank you, Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: export/import
Joseph, Following might help you. We have databases 8.1.6 on Solaris 2.7. On NT4 we have 8.0.4. We export user schema/tables from 816 and import the schema/tables into 804 on NT. Important things are: If your databases versions are same on both the machines, then use the same exp/imp software versions. Else use the lesser version. For example, to export the tables from 816, I use exp version from 804. Reason: exp/imp are downward compatible but not upwards. Also, while ftp, keep the file transfer in binary. Hope this might clarify some things. Rao -Original Message- To: Multiple recipients of list ORACLE-L Sent: 03/07/2001 5:31 PM Can I import a database from NT which was exported from AIX RS6000 servers? Do I just move the expdat.dmp (exported output) from AIX to NT and simply use the export/import utilities? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leyden, Joseph INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OEM 2.2. installation blues
Title: RE: OEM 2.2. installation blues Hi, We installed oem2.2 on NT with 256 MB RAM. Installation went through well and did not face any problems. The packs installed Tuning, Change Management, Diagnostics. Rao [EMAIL PROTECTED] -Original Message- From: Vincent Ruger [mailto:[EMAIL PROTECTED]] Sent: Friday, March 02, 2001 3:36 AM To: Multiple recipients of list ORACLE-L Subject: RE: OEM 2.2. installation blues Hi, Yes, w've installed oem2.2 on a nt (ibm) machine with 180 Mb ram. It works fine, with the 3 major packs. (tuning, diag and change) The management server runs fine and even the data gatherer works very good, we collect the data from unix (aix) trough the nt dg for our packs and no problem. nt with service pack 6 hth Vincent Ruger -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Namens Boivin, Patrice J Verzonden: donderdag 1 maart 2001 14:55 Aan: Multiple recipients of list ORACLE-L Onderwerp: OEM 2.2. installation blues Hi, Has anyone successfully installed OEM 2.2. on their machine? My test server has 256M more RAM coming, but in the meantime I haven't given up hope. Although hope is dwindling... I only have 380M of RAM. I started the installation process, then went to talk to someone. When I returned there was a Blue Screen of Death waiting for me. After powering off and powering on my machine, Peak Memory usage on my machine is at 680M of memory! Is this NT going crazy or does the Oracle Universal Installer really need that much memory to install OEM 2.2.? Could there be a creeping memory leak in the Universal Installer? (make that a galloping memory leak) I allocated 1G of virtual memory, but I know from experience on this machine at least that NT can't handle virtual memory very well, it keeps blue screening when I exceed available physical memory by too much. TIA Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
RE: How to find a listener service without running lsnrctl servic
List This problem is solved thanks to Chuck Hamilton suggestion. I thank all the list members who took their time in suggesting the solution. Following is the solution given by Chuck Hamilton. You can do what you want by using the setuid bit. On some version of unix you may need a kernel parameter change to allow shell scripts to run with the setuid bit turned on. 1. Log in as the "oracle" user. 2. Remove the password from the shell script and put it into a separate file protected with unix permissions. echo "mypassword" listener.pass chmod 600 listener.pass # Now only "oracle" can read this file 3. Change the line in your shell script to read the password from the listener.pass file. For KSH something like this works. lsnrctl ! | grep ORCL # (or whatever service you're looking for) set password $(listener.pass) status ! 4. Change the permission on the shell script and add the setuid bit. This causes the run-time user id to be set to the owner of the shell script (which should also be "oracle"). chmod u+s check_listener.sh or chmod 4755 check_listener.sh Any user can now run the script, and even read the script, but can't see the password because he can only cat the script, not the password file. Thank You Chuk Hamilton. Rao [EMAIL PROTECTED] Hi DBAs, I would like to find out whether a specific listener service is up or not without running the command --- lsnrctl services. Is there any way I can do this through a shell script or unix command? My environment : Solaris 2.7 : Oracle 8.0.4 Thanks for your help, Rao [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 find a listener service without running lsnrctl servic
Title: RE: How to find a listener service without running lsnrctl services Mohan, Thanks for your suggestion. Ps ef | grep tns --à gives me only the LISTENER. I would like to know a specific service that is started by a listener service or alternately I would like to grep for a specific service in the listener. For example, if my listener is starting a service by name MINT4, I would like to know that the service MINT4 is up. Please suggest a way how to do this without doing lsnrctl services. Rao [EMAIL PROTECTED] -Original Message- From: Mohan, Ross [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 20, 2001 6:41 PM To: Multiple recipients of list ORACLE-L Subject: RE: How to find a listener service without running lsnrctl servic ps -ef | grep tns -Original Message- From: Rao, Maheswara [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 20, 2001 6:00 PM To: Multiple recipients of list ORACLE-L Subject: How to find a listener service without running lsnrctl services Hi DBAs, I would like to find out whether a specific listener service is up or not without running the command --- lsnrctl services. Is there any way I can do this through a shell script or unix command? My environment : Solaris 2.7 : Oracle 8.0.4 Thanks for your help, Rao [EMAIL PROTECTED]
RE: How to find a listener service without running lsnrctl servic
Hi Djordje, Thank you for the suggestion. Doing grep for a specific service on an output produced by lsnrctl services, yes, I could get the answer. However, I am trying to create a shell script through which the user will find whether a specific listener service is up or not. The problem is I do not want to give the password of listener. Also, by greping the output of lsnrctl --- this output could have been produced some time back but at the time the user is querying the service might be down. Please suggest a way to do the above. Thanks, Rao [EMAIL PROTECTED] -Original Message- Sent: Tuesday, February 20, 2001 6:50 PM To: Multiple recipients of list ORACLE-L Why not running it from a script, and grep and awk from output wht you need to see ? Djordje - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, February 20, 2001 6:00 PM Hi DBAs, I would like to find out whether a specific listener service is up or not without running the command --- lsnrctl services. Is there any way I can do this through a shell script or unix command? My environment : Solaris 2.7 : Oracle 8.0.4 Thanks for your help, Rao [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Sun/Oracle Best Practices URL
Zubair, Check this url. http://www.sun.com/software/solutions/blueprints/0101/SunOracle.pdf;$session id$Z2EDDYQAABYJRAMTA1FU45Q Rao [EMAIL PROTECTED] -Original Message- Sent: Tuesday, February 20, 2001 3:21 AM To: Multiple recipients of list ORACLE-L Hi Where can i get this Sun/Oracle Best Practices paper. TIA Zabair Ahmed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to find a listener service without running lsnrctl services
Hi DBAs, I would like to find out whether a specific listener service is up or not without running the command --- lsnrctl services. Is there any way I can do this through a shell script or unix command? My environment : Solaris 2.7 : Oracle 8.0.4 Thanks for your help, Rao [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: this drove me crazy!!!
Saurabh, When I created this function fist time, I also got error. Then I created emp table (in test schema) and then again created the function. This second time, the fuction is created without any errors. And I found this idea acadamically good. However, usage of this in real time might be minimal (I believe). Rao -Original Message- To: Multiple recipients of list ORACLE-L Sent: 02/17/2001 7:25 AM but this function is created with compilation errors.. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, February 13, 2001 1:15 AM I can do it. SQL create or replace function dumb 2 return number is 3 pragma autonomous_transaction; 4 begin 5 insert into emp (empno) values (10); 6 commit; 7 return 0; 8 end; 9 / Function created. Try a few of these: SQL select empno 2 from emp 3 where dumb=0 and 4 empno 20; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).