From oracle-l-bounce@freelists.org Fri Jul 30 11:27:37 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i6UGRL523143 for ; Fri, 30 Jul 2004 11:27:31 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i6UGR0623096 for ; Fri, 30 Jul 2004 11:27:21 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 62FC172C5D9; Fri, 30 Jul 2004 11:01:15 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 25157-06; Fri, 30 Jul 2004 11:01:15 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9836672D1DA; Fri, 30 Jul 2004 11:01:08 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 30 Jul 2004 10:59:29 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 50D4972D0DB for ; Fri, 30 Jul 2004 10:59:29 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 24624-08 for ; Fri, 30 Jul 2004 10:59:29 -0500 (EST) Received: from mail.alise.lv (dao-telia.alise.lv [194.19.227.253]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5596F72D0FA for ; Fri, 30 Jul 2004 10:59:28 -0500 (EST) Received: by mail.alise.lv (Postfix, from userid 333) id 761569DCB6; Fri, 30 Jul 2004 19:26:54 +0300 (EEST) Received: from ross.alise.lv (unknown [172.16.0.14]) by mail.alise.lv (Postfix) with ESMTP id C9FDA9DCB3 for ; Fri, 30 Jul 2004 19:26:53 +0300 (EEST) In-Reply-To: <758260AC76ABD64AA3781956D6A50C3D1E83F3@bobwpmsg001.choicepoint.net> To: oracle-l@freelists.org Subject: Re: Changing Character Set MIME-Version: 1.0 X-Mailer: Lotus Notes Release 6.5.2 June 01, 2004 Message-ID: From: J.Velikanovs@alise.lv Date: Fri, 30 Jul 2004 19:18:45 +0300 X-MIMETrack: Serialize by Router on ROSS/IT ALISE/LV(Release 5.0.11 |July 24, 2002) at 2004.07.30 19:18:46, Serialize complete at 2004.07.30 19:18:46 Content-type: text/plain X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 6526 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: J.Velikanovs@alise.lv Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org You can try to update old well known table sys.props$ before run ALTER DATABASE CHARACTER SET ; to change CHARSET to compatable one, in case you have just created database with uncorrect charset and there no incompateble characters in olready loaded data. Definetly: It is unsuported, untested etc. etc. and you use it on your own risk ;) Jurijs 9268222 ============================================ http://otn.oracle.com/ocm/jvelikanovs.html "Ken Payton" Sent by: oracle-l-bounce@freelists.org 30.07.2004 15:01 Please respond to oracle-l To: cc: Subject: Changing Character Set Does anyone know how to switch off the superset check when changing the = national character set. I would like to change the character set of a = new database without rebuilding it and I am receiving ORA-12714: invalid = national character set specified. =20 -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Tim Gorman Sent: Friday, July 30, 2004 5:38 AM To: oracle-l@freelists.org Subject: Re: Lost PERFSTAT bridge scripts Found it Larry, Thanks for the post of Mr Hurley's material. Especially useful is the = use of AUTONOMOUS TRANSACTION pragma, although I've not found it to be necessary... I can understand performing a STATSPACK.SNAP before database shutdown, = to "flush" any values to disk before they are lost, but I am at a loss to understand the reason to perform a STATSPACK.SNAP in an AFTER STARTUP database-event trigger? -Tim on 7/29/04 1:49 PM, Wolfson Larry - lwolfs at = lawrence.wolfson@acxiom.com wrote: > Guess I didn't get specific enough on Google the first time. >=20 > Sorry >=20 > http://www.quest-pipelines.com/pipelines/dba/tips03.htm#january >=20 > January's Tip of the Month >=20 > Automatic Statspack Snapshots at Shutdown and Startup > Compliments of Darryl Hurley, Pipeline SYSOP (dhurley@mdsi.bc.ca) >=20 > Oracle?s Statspack utility provides a straightforward method of = monitoring > database performance statistics. The process is simple; take interval > snapshots of performance indicators and then run reports to see how = much the > indicators have changed during the interval(s). >=20 > Problems arise when intervals span an Oracle shutdown because = comparing > interval values across them is illogical. Here?s an example: >=20 > 10:00 PM Statspack Snapshot #33 shows Physical Reads =3D 100000 > 10:15 PM Database Shutdown > 10:20 PM Database Restarted > 11:00 PM Statspack Snapshot #34 shows Physical Reads =3D 100 >=20 > At this point a StatsPack Report comparing snapshot #33 to snapshot = #34 > would claim that ?99900 physical reads had occurred. Actually the = report > would begin with this self-explanatory text: >=20 > ERROR: Snapshots chosen span an instance shutdown: RESULTS ARE INVALID >=20 > It?s impossible to report across a shutdown, but it is possible to = reduce > the lost periods of time (10:00 to 10:15 and 10:20 to 11:00 in our = example) > by automatically performing snapshots before shutdown and after = startup. > It?s easily done with BEFORE-SHUTDOWN and AFTER-STARTUP triggers. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------