RE: Performance monitoring

2002-10-02 Thread Jorma . Vuorio

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

2002-10-02 Thread Jorma . Vuorio

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

2002-10-01 Thread Jorma . Vuorio

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?

2002-09-05 Thread Jorma . Vuorio



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]

2002-09-04 Thread Jorma . Vuorio
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

2002-08-15 Thread Jorma . Vuorio

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.

2001-08-24 Thread Jorma . Vuorio

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

2001-03-30 Thread Jorma . Vuorio

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!

2001-03-21 Thread Jorma . Vuorio

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

2001-03-20 Thread Jorma . Vuorio

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

2001-03-06 Thread Jorma . Vuorio

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

2001-02-14 Thread Jorma . Vuorio

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@_|9Rjpz
 jXYh-'zZqSXEURDCTL*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).