RE: URL for Oracle 9i entry level email lists
Title: RE: URL for Oracle 9i entry level email lists I think you'll find that everyone on this list was a beginner at one time and I've had people graciously answer some questions of mine that were pretty basic (read: stupid :-). At the very least, people will point you to resources or documentation that will answer your questions and help you learn more. For example, here's the Oracle docs online: http://tahiti.oracle.com/ If you can't find an answer there, explain to this list your question and why you're having trouble finding an answer. It lets listers look smart when they answer you, and who doesn't like to look smart? :-) You'll learn lots just reading the emails from some of the people on the list! -Original Message-From: Les Ayudo [mailto:[EMAIL PROTECTED]]Sent: Friday, February 14, 2003 11:45 AMTo: Multiple recipients of list ORACLE-LSubject: Re: URL for Oracle 9i entry level email lists This list seems at like it's a little too advanced for a beginner. Do you think I should just stick with it for a while to get familiar w/ some of the Oracle stuff? - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Friday, February 14, 2003 7:34 AM Subject: RE: URL for Oracle 9i entry level email lists This list deals with ALL oracle related issues ... so why you want another one? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: Les Ayudo [mailto:[EMAIL PROTECTED]] Sent: Friday, February 14, 2003 10:19 AM To: Multiple recipients of list ORACLE-L Subject: URL for Oracle 9i entry level email lists I want to subscribe to an entry level Oracle mailing list. Do any of you know any good ones? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Les Ayudo INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Count(*) last 30 seconds
Unfortunately I don't have the reference in front of my right now, but I believe the optimizer has a built in way to understand a count(*) and it is just as fast or faster than count(column_name). -Original Message- Sent: Tuesday, February 11, 2003 12:55 PM To: Multiple recipients of list ORACLE-L Interestingly enough, I haven't seen an official statement on count(*) being slower than count(column name). Sunil Nookala DBA Dell Corp. -Original Message- Sent: Tuesday, February 11, 2003 11:09 AM To: Multiple recipients of list ORACLE-L Hi, 1. create unique index or primary key AND update statistics of the table 2. use count(1) instead of count(*) JP On Tuesday 11 February 2003 17:19, you wrote: Hi list, I issue a select count(*) from mytable and last 30 seconds. The table has 1,466,196 records and were loaded with a batch process, so they are in a countinous space. I consider that time exagerated. The TBS is LMT with a Uniform size of 128 MB. The block size is 8MB, version 9.2.0.1.0 in Windows 2000. Where should I start looking ??? TIA Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121 -- Pruner Jan [EMAIL PROTECTED] http://jan.pruner.cz/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sutton, Reed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: VMware
I agree with Richard. We used VMware in our development environment to consolidate servers. I will say - unless you have a substantial amount of hardware, there is going to the inevitable temptation to add that one extra VM instance that's just one too many and performance suffers. But, if you had a substantial amount of hardware, you probably wouldn't be using VMs. My only advice is be very careful about overloading your servers with too many VMs. Disk, CPU and Memory will become scarce at peak times and performance will be BAD. -Original Message-From: Richard Ji [mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 05, 2003 8:34 PMTo: Multiple recipients of list ORACLE-LSubject: RE: VMware Not in a production environment, but I have been using VMWare Workstation since 2.0 with Oracle as my test, development platform. I run various Linux (RH, SuSE) with Oracle without much problems. I have found occassionally simutanously start Opera and VMware cause my machine to freeze. Now, I wouldn't want to run a production Oracle under VMware. Running Oracle is as complex as it is, why add another component to the mix? You will now have to deal with Windows + VMware + Windows + Oracle. You will have to deal with patching, upgrading VMware. To me, it's not worth it. It's not like you are consolidating 100+ database servers, or are you? Richard Ji -Original Message-From: SusanK [mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 05, 2003 6:30 PMTo: Multiple recipients of list ORACLE-LSubject: VMware All, I was wondering if anyone has any experience (good or bad) with the use of VMware on Oracle database servers? I am hearing rumors within my company that management is looking to utilize VMware to consolidate our WindowsNT/2000 database servers (test, development, and production). At this point I have not been able to find much information relating to the use of VMware in an Oracle environment and I am curious if it is widely used. Any information would be greatly appreciated. Thanks! Susan Kersting [EMAIL PROTECTED] Do you Yahoo!?Yahoo! Mail Plus - Powerful. Affordable. Sign up now
RE: Oracle Migration Workbench for Sybase
Kirti, I am no Sybase expert, but I am staring at a Sybase to SQL Server migration, and I installed the Sybase client tools on my machine and it gave me Sybase Adaptive Server ODBC driver Release 3.50.00.10. Unfortunately I can't tell you if my version is newer or yours is (50 is bigger than 11.. ;-) Hope this helps at least a little bit. -Original Message- Sent: Wednesday, February 05, 2003 10:59 PM To: Multiple recipients of list ORACLE-L Hello Listers, Anyone used this tool? What was your experience like? I am planning on using it to move about 20GB of data from a Sybase 11.x database to Oracle 8i (Rel 3). This is a one time activity. Flat file route (using Sybase 'bcp') is the alternate solution. I would like see if we could use OMWB for this. The doc says I need Sybase Adaptive Server ODBC driver Release 3.11.00.01. Searched Sybase web site for this driver, but failed to locate it. Any ideas about its source? Thanks. - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sutton, Reed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Migration from SQL Server to ORACLE 9i
Another thought is to use DTS to handle at least some of the transfer for you. SQL Server's DTS (Data Transformation Services) package will be able to connect to Oracle, create the table structure and import the data for you. You are on your own as far as foreign keys and primary keys, etc. But something like ERwin could help you out with that. DTS is great for simple data loads, not sure how complicated your migration is, but its something to look into. Good luck! -Original Message- Sent: Tuesday, February 04, 2003 9:40 AM To: Multiple recipients of list ORACLE-L Babu - Congratulations on the project! Is this database especially large or are you facing severe restrictions in terms of the amount of time the data is unavailable to your users? Are there any unusual objects in SQL Server that will be difficult to create in Oracle? I think Oracle provides a migration tool, but I haven't used it. Usually I follow a procedure such as: 1. Create objects in Oracle. 2. Dump data from SQL Server to a flat file. 3. Load the data with SQL*Loader. 4. Verify the data, application. 5. Prepare for production cut-over. 6. Truncate Oracle tables. 7. Dump data from SQL Server to a flat file and load with SQL*Loader. 8. Shut down SQL*Server. 9. Verify application is ready to go live. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, February 04, 2003 3:19 AM To: Multiple recipients of list ORACLE-L Hi Listers, We are planning to migrate one of our SQL Server database to ORACLE 9i. Please point me to the checklist and required documents. Any help in this regard very much appreciated. regards Banarasi Babu T OCP, DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: BanarasiBabu Tippa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sutton, Reed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: last used time of an index ??
Prem, I found this on Google. Some guy named Thomas Kyte? He sounds like maybe he might know what he is talking about ;-) Unfortunately I don't have his book here with me now so I am not sure exactly what code he is talking about, but this should be a good start for you. Question: Has anyone tried to create the object_usage 9i feature in 8.1.7? We're not going to 9i any time soon but would REALLY LIKE the feature to use now. I looked into the create scripts and saw the table and view creates, but didn't find anything that would build a proc to use it. I would guess that using a stint on object auditing would do the trick. index monitoring is only available with 9i and up. You cannot just create the views in 8i -- there isn't any code in the database to supply the needed values behind the view! The alter index iname monitoring command doesn't exist in 8i. ops$[EMAIL PROTECTED] alter index t_idx monitoring usage; alter index t_idx monitoring usage * ERROR at line 1: ORA-02243: invalid ALTER INDEX or ALTER SNAPSHOT option auditing won't help you out here either as it doesn't audit accesses to indexes. If you have my book -- i do describe a way to do this using stored query outlines in a fashion. You can ask the database to store the query outline for all queries executed. From there, you can see in the hints that are stored what indexes are used by which queries. -Original Message- Sent: Thursday, January 30, 2003 9:20 AM To: Multiple recipients of list ORACLE-L Prem That is a 9i feature. One way in 8i is to regularly sample the SQL in the buffers, run explain plan on it, and scan the results for that specific index name. Another way is to drop the index and see if anyone complains ;-) Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 30, 2003 4:50 AM To: Multiple recipients of list ORACLE-L guys, can i find out the time when an index was last used in Ver 8.1.6 ? Regards, Prem Khanna J. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sutton, Reed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SIMPLE QUESTION
Hamid, Stop the listener, delete the file, then restart it. lsnrctl stop delete the log or rename it lsnrctl start It will take less than a minute. If this isn't a very important server you can do it quickly during the day - but use your judgment on that, don't want to get you fired. HTH Reed -Original Message- Sent: Wednesday, May 01, 2002 1:18 PM To: Multiple recipients of list ORACLE-L HI AGAIN, JUST WANT TO CHECK WITH YOU GUYS, MY LISTENER.LOG IS GETTING BIG I TRY TO RENAME IT THEN CREATE A NEW LISTENER.LOG BUT STILL THE OLD ONE IS USING BY ORACLE. HOW CAN I TRUNCATE THE LISTENER.LOG OR CAN I JUST SIMPLY DELETE IT OR NOT? THANKS FOR HELP. Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sutton, Reed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
setenv NLS_LANG American_America.UTF8 for c shell HTH Reed -Original Message- Sent: Thursday, April 18, 2002 2:24 PM To: Multiple recipients of list ORACLE-L Sorry about this RTFM question, but I need a quick answer. I have a remote database in the UTF8 character set. When I export that DB I get this message: Export done in US7ASCII character set and UTF8 NCHAR character set server uses UTF8 character set (possible charset conversion) What can I set my NLS_LANG parameter to so that I get a full UTF8 export? Thanks, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Sutton, Reed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: dedicated server
Hamid, What they mean by that is - assuming Unix here - set your ORACLE_SID, ORACLE_HOME, and ORACLE_BASE to the database you want to connect to. Then just issue svrmgrl or sqlplus. When you connect, you are connecting to the database specified in your ORACLE_SID variable. The same goes for NT, but all you have to do there is at a command prompt set ORACLE_SID = blah and then connect using sqlplus or svrmgrl without a string and it will connect to the database you specified. I hope this helps you. Reed -Original Message- Sent: Tuesday, April 09, 2002 7:43 PM To: Multiple recipients of list ORACLE-L List, I have a problem for shutdown one of the instances, got error OAR-00106 I was looking for the solution on the net, they recommened connect as internal without using the string connection( I beleive it means service name) but if you have more than one instance how can connect internal to a dedicated server, or how can I make a connection to database as dedicated server? Thanks Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sutton, Reed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ora-12514
information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sutton, Reed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Deleting old archive log files.
Mark, We use the forfiles.exe utility that comes with the NT Resource kit. I have attached it here and below I have pulled the code out of our hotbackup.cmd which runs our hotbackups. Its the last step in our hotbackup, to clean up old archived logs which have already been archived to tape. If you need any help with it just let me know. I've cc:ed you directly because I assume the listserv will strip the executable out of my email. Reed obviously, at the beginning of the script all the variables, like %bkupdir%, are defined rem rem Remove archived redo log files older than 3 days. rem forfiles is from the NT Resource Kit rem -p specifies search path rem -m specifies search mask rem -d specifies number of days (+/-) from today rem -c specifies the command to execute on each file remcmd /c executes command specified then terminates the shell rem %bkupdir%\forfiles -p%archdir%\%ORACLE_SID% -m*.arc -d-3 -ccmd /c del @FILE rem rem Remove trace files older than 35 days. rem %bkupdir%\forfiles -p%udumpdir% -m*.trc -d-35 -ccmd /c del @FILE -Original Message- Sent: Thursday, April 04, 2002 5:39 AM To: Multiple recipients of list ORACLE-L Hi All, To save me re-inventing the wheel: Does anybody have a batch script (that runs on NT) that deletes archive log files that are older than X days old? I've looked at the DEL command, but this doesn't have a date/time based attribute parameter.. Has anybody been through this already? All help appreciated! Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). attachment: forfiles.exe
RE: Oracle hangs...Oracle 8.1.7.3 and Solaris 2.7
Well, unfortunately we haven't solved the problem yet, so I don't have any solutions to share with everyone. We are using Sun hardware, and we have not run diagnostics on the memory. I don't want to dismiss that idea out of hand, but I don't understand how bad memory could be affecting only one of the three instances. There are two other 8.1.7.3 instances that run fine, never even a hiccup. The server has 2GB of memory. The application that uses this database (when its up) is connecting over the network, but when it hangs, you are unable to connect from a remote client or from on the server. I suggested to the support person handling our case that maybe we could try using some of the various oradebug options suggested by people on the list and suggested on Metalink, but he suggested looking at the following things first: This may be caused by a system resource problem. Was this DB relinked after the upgrade? It might help to get the initsid.ora's for all the instances What is the total size of each SGA? What is the value of the PROCESSES for each instance How much physical memory on the system? How much swap space? Type sysdef -i |grep SHMMAX Type sysdef -i |grep SEMMNS Still waiting for his reply to my answers... Thanks for all ideas you guys have shared. -Original Message- Sent: Wednesday, March 20, 2002 11:58 PM To: Multiple recipients of list ORACLE-L Please let us know how you fixed the problem. Are you using Sun Hardware? can you run diagnostics for the memory? Are you connecting using IPC(meaning direct) or through TCP(network)? Is it the network that is causing problem? --- Grabowy, Chris [EMAIL PROTECTED] wrote: We have a particular database that hangs on a regular basis. Here are the stats and symptoms. Oracle stats -- 8.1.7.3 (highest patch level applied) Solaris 2.7 UTF8 character set Symptoms -- Random hanging. Hanging meaning SQL processing stops. New connections hang. No traces files. No messages in the alert log. Killing the Oracle processes is the only way to recover from the problem. This problem has been reported to Oracle Support, they are now escalating it up. I just wanted to PING the list to see if anyone else has encountered this. TIA!!! Chris -- 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). = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammed Shakir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Sutton, Reed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 hangs...Oracle 8.1.7.3 and Solaris 2.7
Oracle supports response to my answers was to increase SHMMAX from 128M to 4G and SEMMNS to 2000. Upping the semaphores seems like a good idea, but when I questioned why we should increase SHMMAX to more than 2x the real memory on the machine, the answer was I had my Unix Guru look at these and he recommended the parameters. A little less than what I was hoping for... At this point I am going to start launching my own investigation, from tips from you guys and research on Metalink, to try to find out what these processes are doing when the server is hung. Thanks again for all the help. Reed -Original Message- Sent: Thursday, March 21, 2002 12:51 PM To: Multiple recipients of list ORACLE-L Well, unfortunately we haven't solved the problem yet, so I don't have any solutions to share with everyone. We are using Sun hardware, and we have not run diagnostics on the memory. I don't want to dismiss that idea out of hand, but I don't understand how bad memory could be affecting only one of the three instances. There are two other 8.1.7.3 instances that run fine, never even a hiccup. The server has 2GB of memory. The application that uses this database (when its up) is connecting over the network, but when it hangs, you are unable to connect from a remote client or from on the server. I suggested to the support person handling our case that maybe we could try using some of the various oradebug options suggested by people on the list and suggested on Metalink, but he suggested looking at the following things first: This may be caused by a system resource problem. Was this DB relinked after the upgrade? It might help to get the initsid.ora's for all the instances What is the total size of each SGA? What is the value of the PROCESSES for each instance How much physical memory on the system? How much swap space? Type sysdef -i |grep SHMMAX Type sysdef -i |grep SEMMNS Still waiting for his reply to my answers... Thanks for all ideas you guys have shared. -Original Message- Sent: Wednesday, March 20, 2002 11:58 PM To: Multiple recipients of list ORACLE-L Please let us know how you fixed the problem. Are you using Sun Hardware? can you run diagnostics for the memory? Are you connecting using IPC(meaning direct) or through TCP(network)? Is it the network that is causing problem? --- Grabowy, Chris [EMAIL PROTECTED] wrote: We have a particular database that hangs on a regular basis. Here are the stats and symptoms. Oracle stats -- 8.1.7.3 (highest patch level applied) Solaris 2.7 UTF8 character set Symptoms -- Random hanging. Hanging meaning SQL processing stops. New connections hang. No traces files. No messages in the alert log. Killing the Oracle processes is the only way to recover from the problem. This problem has been reported to Oracle Support, they are now escalating it up. I just wanted to PING the list to see if anyone else has encountered this. TIA!!! Chris -- 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). = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammed Shakir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Sutton, Reed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
