RE: Performance monitoring
Thak's Mark I agreed, but they have gotten an idea to get only couple most important measurements from db, because they don't want to have a huge reports with all possible statistics. Very understandable, but as You wrote, there isn't any absolutely top ten. In any case, I have to do this (stupid) list, so give Your best shot, please. t.Jorma Ps. I heard, that Dave Ensor from BMC, has once presented that kind of list? -Original Message- Sent: 02 October, 2002 12:23 To: Multiple recipients of list ORACLE-L Jorma, Performance tuning is a complex subject. There really isn't a list of 10 things to watch for. Every system is different. I would (attempt to) summarize tuning by these five steps: 1.) Have a capacity/performance target in mind. If you don't know where you're going, how will you know if you have gotten there? 2.) Monitor your response times as load increases. Can you achieve your response time target at the specified load? If so, you're done, successful test, congratulations. If not, continue to next step. 3.) Actively monitor what's going on in the database, while it's happening. It's always easier to see it in real time than just looking at random StatsPack snapshots taken at 5 or 10 or 15 minute intervals. (Not that I'm saying StatsPack shouldn't be collected. I'm just saying don't rely on StatsPack as your only source of info about the database.) The V$ Wait Interface is your friend. If you're not familiar with it, go to http://www.hotsos.com/ and get Mogens Norgaard's paper, Introducing the V$ Wait Interface. Where is the database spending it's time? What's the bottleneck? If you identify a few trouble sessions, you may want to dive deeper w/ some 10046 traces at level 8 on specific sessions. You almost certainly do NOT want to do this instance wide. 4.) Once you have some indication as to what's going on in the database, you need to see how the system is doing overall. On most flavors of *nix, where I'm comfortable, sar (System Activity Reporter) is an excellent tool. Use it to determine if you have any systemwide CPU, memory, or I/O contention. (Other OSes almost certainly have similar utilities.) 5.) Address the biggest bottleneck. This is where it can't be summarized in a simple step. You need to understand the bottleneck, so that you can understand how to tune it. If may be latch contention. Depending on the latch, it could be poorly tuned SQL, or lack of bind variables, or simple CPU capacity limits, or a whole host of things. I/O contention? Could be anything from poorly designed and/or configured RAID array to poorly tuned SQL, or who knows what. Determine the cause of the biggest bottleneck and minimize or eliminate it. There you have it, Mark's Simplified Performance Tuning, in five easy steps! ;-) -Mark On Wed, 2002-10-02 at 02:08, [EMAIL PROTECTED] wrote: Ave ! I like to hear Your opinion about the most importat issues, what should be monitored from the database (8.1.7, SUN) during perfomance testing. The purpose in this case, is limit the monitoring to concern only about 10 most important ones. I have difficulties to make my mind to pick up the right ones, so if You had to have made similar kind of decisions or have opinions, please let me know. TIA Jorma - Name: Jorma Vuorio Phone: +358-9-7180 67759 Company: Nokia Business Infrastucture Fax:+358-9-7180 67465 Address: P.O.Box 321, FIN-00045 NOKIA GROUP, FINLAND Internet: [EMAIL PROTECTED]Mobile: +358-50-486 8043 - -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well. -- Rene Descartes -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark J. Bobak INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru
RE: Performance monitoring
Hi Greg You can count on, that I have tried to tell them, what You wrote in two first lines. I have to got a hammer...:) -Original Message- Sent: 03 October, 2002 00:18 To: Multiple recipients of list ORACLE-L The ten most important performance items to monitor are your ten most important business transactions. Period, end of story. If you want to provide an intelligent response, monitor how long they take and provide a weekly report, noting any changes. Ratios and wait events are just diagnostic tools -- when business transactions become slow you use them to find where the problem is. Anyone who asks you to monitor ten internal things, such as ratios or wait events, and no more than just ten because they only want the ten most important, is simply uneducated and unexperienced, since these things are of no importantance if the system is running fast enough for the users, and besides there are way more than ten important things like this. However, they may also be very smart, since a good manager may be wise to start by getting a handle on the ten most important things. Probably, you want to be taking statspack snapshots every hour just to have a baseline, so just DO THAT and give the statspack report to the manager once a week -- and make them happy by picking out ten items you consider important and running a yellow highlighter over them. Have a cover page that compares the current value of the ten items with the same items four weeks ago -- so you are monitoring them. That's fast, easy and smart, it makes your manager happy and you'll have your eye on the ball too. But don't forget that the most important thing to monitor is reality. Your coolest move is to have the manager pull the users into a meeting and get them to identify the ten business transactions that are most important to them. Find out if any are too slow. Find out if anything is too slow. Monitor that. Tune that. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Performance monitoring
Ave ! I like to hear Your opinion about the most importat issues, what should be monitored from the database (8.1.7, SUN) during perfomance testing. The purpose in this case, is limit the monitoring to concern only about 10 most important ones. I have difficulties to make my mind to pick up the right ones, so if You had to have made similar kind of decisions or have opinions, please let me know. TIA Jorma - Name: Jorma Vuorio Phone: +358-9-7180 67759 Company: Nokia Business Infrastucture Fax:+358-9-7180 67465 Address: P.O.Box 321, FIN-00045 NOKIA GROUP, FINLAND Internet: [EMAIL PROTECTED]Mobile: +358-50-486 8043 - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How long did job run?
You can find it from last_date column from that table: SQL alter session set nls_date_format='dd.mm. hh24:mi:ss'; SQL select LAST_DATE from dba_jobs; LAST_DATE---05.09.2002 12:39:31 HTH Jorma -Original Message-From: ext Vladimir Barac [mailto:[EMAIL PROTECTED]]Sent: 05 September, 2002 11:43To: Multiple recipients of list ORACLE-LSubject: How long did job run? Hello to everyone Is it possible to find LAST execution time of a job? DBA_JOBS has column TOTAL_TIME, but I need something like "last time". Thanks
RE: Changing sysdate[Scanned]
Title: RE: Constraints problem It's date, not newdate. Check "man date". -Original Message-From: ext Karthikeyan S [mailto:[EMAIL PROTECTED]]Sent: 04 September, 2002 13:28To: Multiple recipients of list ORACLE-LSubject: RE: Changing sysdate[Scanned] Hi, I am getting the error "newdate does not exist" when I tried $newdate '09042002 14:48:00'. Is it the commandI should use to change the sysdate in Solaris? regards, Karthik -Original Message-From: Naveen Nahata [mailto:[EMAIL PROTECTED]]Sent: Wednesday, September 04, 2002 12:53 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Changing sysdate[Scanned]Change the System date, and restart the database. -Original Message-From: Karthikeyan S [mailto:[EMAIL PROTECTED]]Sent: Wednesday, September 04, 2002 12:18 PMTo: Multiple recipients of list ORACLE-LSubject: Changing sysdate Hi, Is it possible to change the sysdate? (Solaris 5.8, Oracle 8.1.7) TIA. K.
RE: Hot Backup using EMC /BCV splits
Ave ! Why there is that step 2 (sleep 5)? I assume, that the backup script (or whatever) runs straight forward without spawning any simultaneous running subprocesses of course. Just curious. Br. Jorma -Original Message- Sent: 15 August, 2002 18:39 To: Multiple recipients of list ORACLE-L rofl! it should be 1, 4, 5, 2. [EMAIL PROTECTED] 08/15/02 10:58AM Hello, We are on IBM AIX 4.3.3 with EMC and BCVs. Our Unix admin has setup the backups for the database in following sequence to do the Hot backup. 1. Put all tablespaces in the database in Hot backup mode 2. Sleep 5 3. Put all the tablespaces back into normal mode 4. Split the BCV's 5. Mount on another machine and backed up from it. What I am concerned is with step 4. Split BCV's should be done at step 2 instead of step 4. According to our Unix Admin, EMC takes care of consistency and there is no need for any concern. As per him the split is instant split and EMC guarantees consistency. What do you all think. What is the recommended procedure. TIA, Nate -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nat INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: any body come across, decreasing db_block_size.
Yes, it works. t.Jorma -Original Message- From: ext Tatireddy, Shrinivas (MED, Keane) [mailto:[EMAIL PROTECTED]] Sent: 24 August, 2001 14:25 To: Multiple recipients of list ORACLE-L Subject: any body come across, decreasing db_block_size. Hi lists have any body come across, decreasing db_block_size. we know that the db_block_size can be increased. to do this, usual way is export full db. create new db with new increased db_block_size and import the data into it. will this work for decrease db_block_size. my present size is 8 k now that should be decreased to 4K srinvias -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Set transaction does not work
No, but just a select can end up "snapshot too old" (or update/delete because these includes a select). The updates/deletes of the other transactions may lead to this, because the select can't get a consistent view from rollback segs, when the needed data is overwritten by another transaction. This is mostly a pain of the long running queries when there is lot of other update/delete/insert activities in the db. Br. Jorma -Original Message- From: ext Mohammad Rafiq [mailto:[EMAIL PROTECTED]] Sent: 29 March, 2001 22:07 To: Multiple recipients of list ORACLE-L Subject: Re: Set transaction does not work Under your situation of select only statement there is no use of rollback segment whether big or small. This error is a result of some other long running job using that rollback segment. Please advise relevant developer to check his code doing some delete,update,insert and intoduce some commit size in his code first. To implement set transaction use commit first like commit; set transaction use rollback segment BIG_ROLLBACK; then your sql or code HTH Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 29 Mar 2001 09:50:55 -0800 RDBMS 7.3.2.3 I am running this under SQLPLUS set transaction use rollback segment BIG_ROLLBACK select c1, c2 from giant_poorly_indexed_table where unindexed_colum=''; exit; I end up with "snapshot too old" rollback segment RB_07. Why won't it use the giant rollback segment I created for this transaction? The segment is public and it is online. -Original Message- From: Brian Wisniewski [SMTP:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 7:45 AM To:Multiple recipients of list ORACLE-L Subject: Re: Is terminal release of 8.0.x still supported? I checked yesterday and 8.0.6 which is the terminal 8.0.X release is still supported on Solaris. Freakin' vendor won't certify their product for anything above 8.0.5 which hasn't been supported for nearly a year now. mumble, mumble... - Brian --- [EMAIL PROTECTED] wrote: We have some 8.0.4 databases running on Sun Solaris. I believe that 8.0.4 has been desupported as of December 31, 2000. We are unable to upgrade one of our apps at this time that is running on an 8.0.4 database. Is the terminal release of 8.0.x still supported? If yes, what is that terminal release? Is it 8.0.7? How long before that terminal release will be desupported (if it is currently supported)? Thanks, Cherie Machler Gelco Information Network -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: NLS_DATE_FORMAT not effective..help!
Try: Alter session set nls_date_format=date_mask; HTH Jorma Hi, Thanks for the reply. But as far as i tried , it is not possible to set NLS_DATE_FORMAT at instance level (except the entry in init file.) I think Martin Kendall wrote: Just create a Database on-logon trigger and setup the date as you want it. Then providing any "client" does not do an alter session you will have a standard DB date format. -Original Message- Sent: 20 March 2001 08:36 To: Multiple recipients of list ORACLE-L Hi Gurus, We want to change the default date format of oracle from 'dd-mon-yy' to 'MM/DD/' format for one of our database ( 8.1.6 ). I have set NLS_DATE_FORMAT as "MM/DD/" (also tried for year!) in init file. It doesn't seems to have any effect when i query sysdate (SQL PLUS) from a client PC (Win 95 / Oracle 8 client / SQL PLUS) . Still in SQL PLUS it is displaying the date as 20-MAR-01 ( default format - dd-mon-yy) Ofcourse, after modifying, i bounced the db and listener. Interesting thing is when i query sysdate from SQLPLUS of my server (where Oracle is installed ), it is giving me the date as SELECT SYSDATE FROM DUAL; 03/20/200 ( it should be 03/20/2001 ) What went wrong? Did anyone faced similar problem? Do i need to modify registry in client PCs ( Win 9X)...?? Thank You. Arul. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arul kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Martin Kendall INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Arul kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: If-statement
You don't have to use any if's, but use translate function: update Your_table set Your_column = translate(Your_column,'?','0'); HTH Jorma -Original Message- From: ext [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 20 March, 2001 13:41 To: Multiple recipients of list ORACLE-L Subject: If-statement Hallo, Do you have any good example on how to write a procedure, that checks if there is a ? in a column in tna table in te database. If it is a ? then it will be put a "0" in the place where it is a ?. If it is not a ? then it will be the no change in that place. Please help me with this Roland Skldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: NUMBER datatype
99 This is an elementary q. If i have a col of NUMBER data type what is the last number that can be stored in this col. Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Urgent! Change Character Set from WE8IS088591 to UTF8
How about: SVRMGR startup mount SVRMGR alter system ENABLE RESTRICTED SESSION; Statement processed. SVRMGR ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; Statement processed. SVRMGR ALTER DATABASE OPEN; Statement processed. SVRMGR ALTER DATABASE CHARACTER SET ; Statement processed SVRMGR ALTER DATABASE NATIONAL CHARACTER SET **; Statement processed. SVRMGR shutdown immediate SVRMGR startup Answer from this list some time ago :) Br. Jorma -Original Message- From: ext Martin Kendall [mailto:[EMAIL PROTECTED]] Sent: 14 February, 2001 13:21 To: Multiple recipients of list ORACLE-L Subject: RE: Urgent! Change Character Set from WE8IS088591 to UTF8 DO NOT do this in 8i as you will not be able to restart the database. Martin -Original Message- Sent: 14 February 2001 10:31 To: Multiple recipients of list ORACLE-L i once hear someone said that: update sys.props$ set value='utf8' where name ='NLS_characterset'; and it seems it do work,but not konw whether it is legal,and no experience in production database. - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Wednesday, February 14, 2001 7:40 AM I have a 8.1.6.0.0 database. What is the best way to change Character Set from WE8ISO8859P1 to UTF8 from: NLS_CHARACTERSET WE8ISO8859P1 To: NLS_CHARACTERSET UTF8 Thanks Larry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry 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). Wsz^r9,BmY (a!jSbz Z(tm).zZ(SI?Y9tQ@_|9Rjpz jXYh-'zZqSXEURDCTL*kaSsSX'X u1(tm),j kr+rr?"\"--)v)...z xfb)-^jXy'Sx5%9, B^zsSX'X*.?_?~slv^Br?jw_-... +(tm)byb '.n+? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Martin Kendall INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).