Re: tns-12500 unable to start dedicated server process.
[EMAIL PROTECTED] wrote: I have 3 instances on Oracle 8.1.6,Nt 4. They are all started but on one instance I connect via the listener. The only connection is at the server not using service name. I have the usual plenty of memory,swap,etc. It has been working fine until today. I even stopped the other 2 instances just to give more memory but still fails. The listener.ora has not changed. I have rebooted the server multiple times. Oracle gives me the same old answer increase processes parameter,add more memory,add more swap file,etc. Anyone have any fresh ideas on how to resolve. Thanks Rick Rick, Put your listener in trace mode.This is the process which creates the dedicated server. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: Storing of number datatype in table
[EMAIL PROTECTED] wrote:
Thank u list for ur imm resp. It was the prob with numwidth.
Now I have set the num width to 25 and s working fine.
But whenever i stat the sql the default is set to 9. how do i change the
def numwidth??
Regards,
Sathyanarayanan
|+---
|| Arup Nanda |
|| arupnanda@ho|
|| tmail.com |
|| |
|| 22/11/2002 |
|| 19:38|
|| Please |
|| respond to |
|| ORACLE-L |
|| |
|+---
--|
| |
| To: Multiple recipients of list ORACLE-L |
| [EMAIL PROTECTED] |
| cc: (bcc: Sathyanaryanan K/VGIL) |
| Subject: Re: Storing of number datatype in |
| table |
--|
The number is more than the numwidth specified. Try this
SQL set numwidth 13
SQL select trn_id from trnid;
Your numwidth is perhpas defined as 9; so anything of more precision is
displayed as exponetial notation; internally all numbers are stored the
same.
HTH
Arup Nanda
www.proligence.com
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, November 22, 2002 6:23 AM
Dear List
Have a look at the sql !!!
SQL create table trnid
2 ( trn_id number(10));
Table created.
SQL insert into trnid(trn_id) values('11');/* 10 1's inserted*/
1 row created.
SQL insert into trnid(trn_id) values('1');/* 9 1's inserted*/
1 row created.
SQL commit;
Commit complete.
SQL select trn_id from trnid;
TRN_ID
-
1.111E+09
1
can anyone tell why the number(10) is stored in exp format
Regards,
Sathyanarayanan
Set the value you want in $ORACLE_HOME/sqlplus/admin/glogin.sql or its
Windows equivalent.
--
Regards,
Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroult
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: Storing of number datatype in table
set numwidth value in login.sql file
oracle read it when open a new session
Satyendra ..
[EMAIL PROTECTED] wrote:
Thank u list for ur imm resp. It was the prob with numwidth.
Now I have set the num width to 25 and s working fine.
But whenever i stat the sql the default is set to 9. how do i change the
def numwidth??
Regards,
Sathyanarayanan
|+---
|| Arup Nanda |
|| arupnanda@ho|
|| tmail.com |
|| |
|| 22/11/2002 |
|| 19:38|
|| Please |
|| respond to |
|| ORACLE-L |
|| |
|+---
--|
| |
| To: Multiple recipients of list ORACLE-L |
| [EMAIL PROTECTED] |
| cc: (bcc: Sathyanaryanan K/VGIL) |
| Subject: Re: Storing of number datatype in |
| table |
--|
The number is more than the numwidth specified. Try this
SQL set numwidth 13
SQL select trn_id from trnid;
Your numwidth is perhpas defined as 9; so anything of more precision is
displayed as exponetial notation; internally all numbers are stored the
same.
HTH
Arup Nanda
www.proligence.com
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, November 22, 2002 6:23 AM
Dear List
Have a look at the sql !!!
SQL create table trnid
2 ( trn_id number(10));
Table created.
SQL insert into trnid(trn_id) values('11');/* 10 1's inserted*/
1 row created.
SQL insert into trnid(trn_id) values('1');/* 9 1's inserted*/
1 row created.
SQL commit;
Commit complete.
SQL select trn_id from trnid;
TRN_ID
-
1.111E+09
1
can anyone tell why the number(10) is stored in exp format
Regards,
Sathyanarayanan
--
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arup Nanda
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Satyendra K Khare
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: Storing of number datatype in table
Title: RE: Storing of number datatype in table
set it in your login or glogin file. This file is run by default when you login through sql*plus.
rgds
amar
http://amzone.netfirms.com
The best way to express yourself is to be yourself.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Saturday, November 23, 2002 9:44 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Storing of number datatype in table
Thank u list for ur imm resp. It was the prob with numwidth.
Now I have set the num width to 25 and s working fine.
But whenever i stat the sql the default is set to 9. how do i change the
def numwidth??
Regards,
Sathyanarayanan
|+---
| | Arup Nanda |
| | arupnanda@ho|
| | tmail.com |
| | |
| | 22/11/2002 |
| | 19:38 |
| | Please |
| | respond to |
| | ORACLE-L |
| | |
|+---
--|
| |
| To: Multiple recipients of list ORACLE-L |
| [EMAIL PROTECTED] |
| cc: (bcc: Sathyanaryanan K/VGIL) |
| Subject: Re: Storing of number datatype in |
| table |
--|
The number is more than the numwidth specified. Try this
SQL set numwidth 13
SQL select trn_id from trnid;
Your numwidth is perhpas defined as 9; so anything of more precision is
displayed as exponetial notation; internally all numbers are stored the
same.
HTH
Arup Nanda
www.proligence.com
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, November 22, 2002 6:23 AM
Dear List
Have a look at the sql !!!
SQL create table trnid
2 ( trn_id number(10));
Table created.
SQL insert into trnid(trn_id) values('11');/* 10 1's inserted*/
1 row created.
SQL insert into trnid(trn_id) values('1');/* 9 1's inserted*/
1 row created.
SQL commit;
Commit complete.
SQL select trn_id from trnid;
TRN_ID
-
1.111E+09
1
can anyone tell why the number(10) is stored in exp format
Regards,
Sathyanarayanan
--
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arup Nanda
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).
test (please ignore)
test please ignore __ Do you Yahoo!? Yahoo! Mail Plus Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: john 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).
test (please ignore)
test please ignore __ Do you Yahoo!? Yahoo! Mail Plus Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: john 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: 1M STRIPE SIZE BEST?
Ethan, EMC is recommending a 2-cylinder stripe depth now (960KB) which is pretty close to the 1MB that Oracle's SAME (Stripe and Mirror Everything) configuration recommended in the Optimal Storage Configuration Made Easy paper. Other recommendations: - use at least 4-member or 8-member striped metavolumes to distribute load across multiple disk adapters on the back end; don't go above 8 though or you're likely to run into disk queue depth issues - use powerpath to do load balancing on the front end - put redo logs on the first hyper of the physical disk (outer hyper) Rich -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Post, Ethan Sent: Wednesday, November 20, 2002 5:54 PM To: Multiple recipients of list ORACLE-L Subject: 1M STRIPE SIZE BEST? A number of papers recommend a stripe size of 1 M (even for EMC) for volumes containing data files. I also have the following email from Eyal Aronoff of Quest dated Nov 2000. A number of the white papers are more recent. The reasons for a larger stripe size on a non-RAID 5 device are: 1) Sequential reads are faster if you can take advantege of the read ahead built into the disk caching 2) If a 64K read does not start on the first block of the stripe, two spindled are locked for the duration of the read However, lately we have been testing some EMC gear and it looks like EMC have optimized both of those for smaller strip size too. The bottom line - I no longer have an opinion one way or another. The undelying technology just changes too rapidly. Eyal Your opinions/comments as far as a best practice in setting stripe sizes would be greatly appreciated. Thanks, Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan 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: Rich Holland 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).
help with connecting to sqlplus
ver 8i on windows NT4 chose the Typical install in 8i during installation hence i guess a starter db is created by the installation via svrmgrl did startup trying to connect to sqlplus both gui as well as command line (on the same server box itself) tried with just sqlplus and it challenges for Enter user-name: i entered sys / as sysdba asks for password: i entered change_on_install error ORA-01033: Oracle initialization in progress. waited for 20 minutes, same error. did a shutdown and startup again, same error --- other clues/messages shutdown, shutdown normal show this Error ORA-01507: database not mounted connected to sqlplus with nolog and creating a sample table with CREATE TABLE or do a DESCRIBE TABLE for this shows not connected __ Do you Yahoo!? Yahoo! Mail Plus Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: john 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).
Do user processes apply against shmmax limit?
Hi everyone, I was always under the impression that the only concern with shmmax was that it be large enough for the SGA to fit into it. One of my System Administrators has just told me that the individual user processes (i.e., the PGA since we're not using multi-threaded server) get added to the SGA and if that SGA + user processes shmmax the system will start swapping. I haven't found anything to specifically address this issue on Metalink so I though I'd throw it open. We've started experiencing system slowdown and he says that increasing shmmax could resolve it. I'm skeptical (he also suggested increasing SGA to decrease swapping which I told him in no uncertain terms was nonsense). If anyone has a link to a note or white paper I'd appreciate that too. I've appended his email at the bottom. This slowdown seems to occur even when there's virtually on oracle activity so I'm suspecting some other cause. Thanks, Jay Miller nycsun1 and njsun7 has 6 GB of memory and only 2 GB of share memory. This morning nycsun1 was very slow and I noticed that there was lots of swaping. see vmstst and iostat below in red: procs memorypagedisk faults cpu r b w swap free re mf pi po fr de sr s2 s4 s4 sd in sy cs us sy id 0 0 23 4366736 97528 1 2186 16 12 12 95520 0 0 0 0 0 1104 3330 974 11 8 81 0 0 23 4365992 96056 1 451 16 24 52 85968 3 0 0 0 0 935 847 416 3 1 96 0 0 23 4364712 95512 2 310 36 24 492 85968 68 0 0 0 0 1036 2183 670 13 4 84 0 0 23 4361568 95488 9 2264 0 76 964 95520 136 0 0 0 0 979 4065 607 12 6 82 0 0 23 4362384 96080 1 6 4 8 8 77376 0 0 0 0 0 975 465 457 2 1 97 0 0 23 4361944 95712 4 730 92 48 532 95520 64 0 0 0 0 1040 1859 734 8 3 89 0 0 23 4360424 95480 4 41 36 40 100 77376 7 0 0 0 0 986 1250 542 6 0 94 0 0 23 4361304 96096 3 264 76 36 88 88496 7 0 0 0 0 1037 942 665 5 3 92 0 0 23 4359680 95784 2 449 4 28 84 95520 8 0 0 0 0 922 1047 374 4 1 95 0 0 23 4359936 95464 2 544 4 20 332 95520 44 0 0 0 0 931 1095 384 2 2 96 /s w/s kr/s kw/s wait actv wsvc_t asvc_t %w %b device 0.0 0.00.00.0 0.0 0.00.00.0 0 0 c2t6d0 0.0 34.50.0 270.0 0.2 13.86.7 399.5 6 44 c5t12d0 -- swap disk 0.0 34.50.0 270.0 0.5 10.7 15.5 309.4 18 39 c5t13d0 -- swap disk This shows that the system is not effectively using memory. I suggest increasing the share memory to 4 GB so that DBAs can increase their memory usage. Also set priority paging on. Priority paging will give application first priority then free memory will be allocated to file cache( Solaris 2.6 and 7. Solaris 8 is set dynamically). * ORACLE CONFIGS set shmsys:shminfo_shmmax =204800 -- increase to 409600 set shmsys:shminfo_shmmin=1 set shmsys:shminfo_shmmni=300 set shmsys:shminfo_shmseg=30 set semsys:seminfo_semmap=500 set semsys:seminfo_semmni=200 set semsys:seminfo_semmns=2000 set semsys:seminfo_semmsl=1000 set semsys:seminfo_semmnu=500 set semsys:seminfo_semume=150 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay 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: help with connecting to sqlplus
John, Try this, $ sqlplus / as sysdba HTH ...Ponnusamy At 09:13 AM 11/23/2002 -0800, john wrote: ver 8i on windows NT4 chose the Typical install in 8i during installation hence i guess a starter db is created by the installation via svrmgrl did startup trying to connect to sqlplus both gui as well as command line (on the same server box itself) tried with just sqlplus and it challenges for Enter user-name: i entered sys / as sysdba asks for password: i entered change_on_install error ORA-01033: Oracle initialization in progress. waited for 20 minutes, same error. did a shutdown and startup again, same error --- other clues/messages shutdown, shutdown normal show this Error ORA-01507: database not mounted connected to sqlplus with nolog and creating a sample table with CREATE TABLE or do a DESCRIBE TABLE for this shows not connected __ Do you Yahoo!? Yahoo! Mail Plus Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: john 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). __ *Ponnu Rangasamy* Database Administration IT Application Services Ext. -15739 pgr -858 494 3812 __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ponnusamy 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).
[no subject]
set no-mail -- 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: test (please ignore)
Why do people do this? What is it that they are testing? And why should we ignore it and not each and every single one of us respond directly to such testers to express displeasure (without replying to the list)? Just a thought... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, November 23, 2002 9:13 AM test please ignore __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: john 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: Tim Gorman 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: Do user processes apply against shmmax limit?
Your Sys Admin is wrong. The SHMxxx OS parameters refer to shared memory, not private process heap memory. On most UNIX variants, the ulimit command is used to limit the consumption of memory for heap, stack, etc... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, November 23, 2002 11:48 AM Hi everyone, I was always under the impression that the only concern with shmmax was that it be large enough for the SGA to fit into it. One of my System Administrators has just told me that the individual user processes (i.e., the PGA since we're not using multi-threaded server) get added to the SGA and if that SGA + user processes shmmax the system will start swapping. I haven't found anything to specifically address this issue on Metalink so I though I'd throw it open. We've started experiencing system slowdown and he says that increasing shmmax could resolve it. I'm skeptical (he also suggested increasing SGA to decrease swapping which I told him in no uncertain terms was nonsense). If anyone has a link to a note or white paper I'd appreciate that too. I've appended his email at the bottom. This slowdown seems to occur even when there's virtually on oracle activity so I'm suspecting some other cause. Thanks, Jay Miller nycsun1 and njsun7 has 6 GB of memory and only 2 GB of share memory. This morning nycsun1 was very slow and I noticed that there was lots of swaping. see vmstst and iostat below in red: procs memorypagedisk faults cpu r b w swap free re mf pi po fr de sr s2 s4 s4 sd in sy cs us sy id 0 0 23 4366736 97528 1 2186 16 12 12 95520 0 0 0 0 0 1104 3330 974 11 8 81 0 0 23 4365992 96056 1 451 16 24 52 85968 3 0 0 0 0 935 847 416 3 1 96 0 0 23 4364712 95512 2 310 36 24 492 85968 68 0 0 0 0 1036 2183 670 13 4 84 0 0 23 4361568 95488 9 2264 0 76 964 95520 136 0 0 0 0 979 4065 607 12 6 82 0 0 23 4362384 96080 1 6 4 8 8 77376 0 0 0 0 0 975 465 457 2 1 97 0 0 23 4361944 95712 4 730 92 48 532 95520 64 0 0 0 0 1040 1859 734 8 3 89 0 0 23 4360424 95480 4 41 36 40 100 77376 7 0 0 0 0 986 1250 542 6 0 94 0 0 23 4361304 96096 3 264 76 36 88 88496 7 0 0 0 0 1037 942 665 5 3 92 0 0 23 4359680 95784 2 449 4 28 84 95520 8 0 0 0 0 922 1047 374 4 1 95 0 0 23 4359936 95464 2 544 4 20 332 95520 44 0 0 0 0 931 1095 384 2 2 96 /s w/s kr/s kw/s wait actv wsvc_t asvc_t %w %b device 0.0 0.00.00.0 0.0 0.00.00.0 0 0 c2t6d0 0.0 34.50.0 270.0 0.2 13.86.7 399.5 6 44 c5t12d0 -- swap disk 0.0 34.50.0 270.0 0.5 10.7 15.5 309.4 18 39 c5t13d0 -- swap disk This shows that the system is not effectively using memory. I suggest increasing the share memory to 4 GB so that DBAs can increase their memory usage. Also set priority paging on. Priority paging will give application first priority then free memory will be allocated to file cache( Solaris 2.6 and 7. Solaris 8 is set dynamically). * ORACLE CONFIGS set shmsys:shminfo_shmmax =204800 -- increase to 409600 set shmsys:shminfo_shmmin=1 set shmsys:shminfo_shmmni=300 set shmsys:shminfo_shmseg=30 set semsys:seminfo_semmap=500 set semsys:seminfo_semmni=200 set semsys:seminfo_semmns=2000 set semsys:seminfo_semmsl=1000 set semsys:seminfo_semmnu=500 set semsys:seminfo_semume=150 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay 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: Tim Gorman 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: ora-2083,ora-1256 Urgent
ORA-2083 02083, 0, database name has illegal character '%s' // *Cause: supplied database name can contain only A-Z, 0-9, '_', '#', '$'nb // '.' and '@' characters. // Solution Description: = Potential Solution(s): 1. Check whether you are using a dash - in the database name, i.e., PROD-DB. If so, remove it. 2. Verify whether you have the parameters default domain and/or default zone set to a dash - in the sqlnet.ora file. If so, you must remove it. HTH Ponnusamy At 02:49 PM 11/22/2002 -0800, [EMAIL PROTECTED] wrote: Hi All, I have a down production system on Win NT4,Oracle 8.1.6. I just started getting ora-2083 database name has illegal character '-'. When I try to connect via svrmgrl after setting oracle_sid I get tns-12560 tns protocol adapter error. The other 2 instances work fine. Nothing on MetaLink has been helpful thusfar. Any ideas on how to resolve. Thanks Rick -- 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). __ *Ponnu Rangasamy* Database Administration IT Application Services Ext. -15739 pgr -858 494 3812 __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ponnusamy 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).
9i On Win2k
Has anyone experienced a MS Dos window always being present on their 9.2 install of SQL Worksheet? If so is there anyway to not have the window open all of the time when running it? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay 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: Storing of number datatype in table
There is a file called glogin.sql under $ORACLE_HOME/sqlplus/admin where you
can place the line set numwidth 13, or whatever else. This file is read by
every session when they connect through sql*plus in that machine. Caution :
sessions sonncting through sqlplus only on that machine read this, not from
other cleint machines.
HTH
Arup Nanda
www.proligence.com
From: Stephane Faroult [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Storing of number datatype in table
Date: Fri, 22 Nov 2002 23:43:43 -0800
MIME-Version: 1.0
Received: from newsfeed.cts.com ([209.68.248.164]) by
mc8-f7.law1.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Sat, 23 Nov
2002 00:43:04 -0800
Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com
(8.9.3/8.9.3) with UUCP id AAA54290;Sat, 23 Nov 2002 00:39:57 -0800 (PST)
Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 00509FD7;
Fri, 22 Nov 2002 23:43:43 -0800
Message-ID: [EMAIL PROTECTED]
X-Comment: Oracle RDBMS Community Forum
X-Sender: Stephane Faroult [EMAIL PROTECTED]
Sender: [EMAIL PROTECTED]
Errors-To: [EMAIL PROTECTED]
Organization: Fat City Network Services, San Diego, California
X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman
Precedence: bulk
Return-Path: [EMAIL PROTECTED]
X-OriginalArrivalTime: 23 Nov 2002 08:43:04.0341 (UTC)
FILETIME=[56956450:01C292CC]
[EMAIL PROTECTED] wrote:
Thank u list for ur imm resp. It was the prob with numwidth.
Now I have set the num width to 25 and s working fine.
But whenever i stat the sql the default is set to 9. how do i change the
def numwidth??
Regards,
Sathyanarayanan
|+---
|| Arup Nanda |
|| arupnanda@ho|
|| tmail.com |
|| |
|| 22/11/2002 |
|| 19:38|
|| Please |
|| respond to |
|| ORACLE-L |
|| |
|+---
--|
| |
| To: Multiple recipients of list ORACLE-L |
| [EMAIL PROTECTED] |
| cc: (bcc: Sathyanaryanan K/VGIL) |
| Subject: Re: Storing of number datatype in |
| table |
--|
The number is more than the numwidth specified. Try this
SQL set numwidth 13
SQL select trn_id from trnid;
Your numwidth is perhpas defined as 9; so anything of more precision is
displayed as exponetial notation; internally all numbers are stored the
same.
HTH
Arup Nanda
www.proligence.com
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, November 22, 2002 6:23 AM
Dear List
Have a look at the sql !!!
SQL create table trnid
2 ( trn_id number(10));
Table created.
SQL insert into trnid(trn_id) values('11');/* 10 1's
inserted*/
1 row created.
SQL insert into trnid(trn_id) values('1');/* 9 1's inserted*/
1 row created.
SQL commit;
Commit complete.
SQL select trn_id from trnid;
TRN_ID
-
1.111E+09
1
can anyone tell why the number(10) is stored in exp format
Regards,
Sathyanarayanan
Set the value you want in $ORACLE_HOME/sqlplus/admin/glogin.sql or its
Windows equivalent.
--
Regards,
Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroult
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).
_
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
http://join.msn.com/?page=features/virus
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arup Nanda
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
RE: 9i On Win2k
I see it too. Don't know how to you can avoid it, but would be interested in finding out! Regards, Pat. -Original Message- Sent: Saturday, November 23, 2002 4:44 PM To: Multiple recipients of list ORACLE-L Has anyone experienced a MS Dos window always being present on their 9.2 install of SQL Worksheet? If so is there anyway to not have the window open all of the time when running it? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay 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: Boivin, Patrice J 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).
instance shutdown problem ? (please help)
ver 8i NT4.o all services have been set to automatic and start fine however the NT Event Viwer and the oracle alert.log show that the instance being shutdown just after the box boots up. how do we rectify this problem ? below is from the alert.log ORA-205 signalled during: alter database mount exclusive.. Shutting down instance (abort) License high water mark = 5 Instance terminated by USER, pid = 144 --- please note: the shutdwon was not initiated by any admin or user but done by the system itself after the box boots up. __ Do you Yahoo!? Yahoo! Mail Plus Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: john 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: 9i On Win2k
Something similar happens on Tru64 UNIX when you start the Oracle Universal Installer, a command line window pops up to start the Java environment. I suppose the same thing is going on in Win32. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Saturday, November 23, 2002 6:09 PM To: Multiple recipients of list ORACLE-L I see it too. Don't know how to you can avoid it, but would be interested in finding out! Regards, Pat. -Original Message- Sent: Saturday, November 23, 2002 4:44 PM To: Multiple recipients of list ORACLE-L Has anyone experienced a MS Dos window always being present on their 9.2 install of SQL Worksheet? If so is there anyway to not have the window open all of the time when running it? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay 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: Boivin, Patrice J 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: Boivin, Patrice J 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: Do user processes apply against shmmax limit?
most disturbing is the thought that this person IS the sysadmin with this level of knowledge. --- Tim Gorman [EMAIL PROTECTED] wrote: Your Sys Admin is wrong. The SHMxxx OS parameters refer to shared memory, not private process heap memory. On most UNIX variants, the ulimit command is used to limit the consumption of memory for heap, stack, etc... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, November 23, 2002 11:48 AM Hi everyone, I was always under the impression that the only concern with shmmax was that it be large enough for the SGA to fit into it. One of my System Administrators has just told me that the individual user processes (i.e., the PGA since we're not using multi-threaded server) get added to the SGA and if that SGA + user processes shmmax the system will start swapping. I haven't found anything to specifically address this issue on Metalink so I though I'd throw it open. We've started experiencing system slowdown and he says that increasing shmmax could resolve it. I'm skeptical (he also suggested increasing SGA to decrease swapping which I told him in no uncertain terms was nonsense). If anyone has a link to a note or white paper I'd appreciate that too. I've appended his email at the bottom. This slowdown seems to occur even when there's virtually on oracle activity so I'm suspecting some other cause. Thanks, Jay Miller nycsun1 and njsun7 has 6 GB of memory and only 2 GB of share memory. This morning nycsun1 was very slow and I noticed that there was lots of swaping. see vmstst and iostat below in red: procs memorypagedisk faults cpu r b w swap free re mf pi po fr de sr s2 s4 s4 sd in sy cs us sy id 0 0 23 4366736 97528 1 2186 16 12 12 95520 0 0 0 0 0 1104 3330 974 11 8 81 0 0 23 4365992 96056 1 451 16 24 52 85968 3 0 0 0 0 935 847 416 3 1 96 0 0 23 4364712 95512 2 310 36 24 492 85968 68 0 0 0 0 1036 2183 670 13 4 84 0 0 23 4361568 95488 9 2264 0 76 964 95520 136 0 0 0 0 979 4065 607 12 6 82 0 0 23 4362384 96080 1 6 4 8 8 77376 0 0 0 0 0 975 465 457 2 1 97 0 0 23 4361944 95712 4 730 92 48 532 95520 64 0 0 0 0 1040 1859 734 8 3 89 0 0 23 4360424 95480 4 41 36 40 100 77376 7 0 0 0 0 986 1250 542 6 0 94 0 0 23 4361304 96096 3 264 76 36 88 88496 7 0 0 0 0 1037 942 665 5 3 92 0 0 23 4359680 95784 2 449 4 28 84 95520 8 0 0 0 0 922 1047 374 4 1 95 0 0 23 4359936 95464 2 544 4 20 332 95520 44 0 0 0 0 931 1095 384 2 2 96 /s w/s kr/s kw/s wait actv wsvc_t asvc_t %w %b device 0.0 0.00.00.0 0.0 0.00.00.0 0 0 c2t6d0 0.0 34.50.0 270.0 0.2 13.86.7 399.5 6 44 c5t12d0 -- swap disk 0.0 34.50.0 270.0 0.5 10.7 15.5 309.4 18 39 c5t13d0 -- swap disk This shows that the system is not effectively using memory. I suggest increasing the share memory to 4 GB so that DBAs can increase their memory usage. Also set priority paging on. Priority paging will give application first priority then free memory will be allocated to file cache( Solaris 2.6 and 7. Solaris 8 is set dynamically). * ORACLE CONFIGS set shmsys:shminfo_shmmax =204800 -- increase to 409600 set shmsys:shminfo_shmmin=1 set shmsys:shminfo_shmmni=300 set shmsys:shminfo_shmseg=30 set semsys:seminfo_semmap=500 set semsys:seminfo_semmni=200 set semsys:seminfo_semmns=2000 set semsys:seminfo_semmsl=1000 set semsys:seminfo_semmnu=500 set semsys:seminfo_semume=150 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay 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: Tim Gorman 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
Re: 1M STRIPE SIZE BEST?
Maybe I've forgotten something fundamental about the way RAID 5 works, I dunno. But I'm having a hard time understanding how stripe size is going to determine the number of heads used in an IO. RAID 5 distributes the data across all spindles, with 1 or more of the spindles for any IO being used for the parity data. Someone care to enlighten me? Thanks, Jared On Thursday 21 November 2002 06:33, Thomas Day wrote: We had a discussion about a year ago here and if I remember correctly the best stripe size is a function of number of concurrent users. With a small number of users you want a small stripe size so that each read i/o will utilize the maximum number of heads. It will also tie up the RAID device for the duration of the read. With a large number of users you want a very large stripe size so that a minimum of heads will be used for each read and the RAID device can handle multiple requests at a time. I don't recall any specific numbers and, as you say, the technology is changing so quickly that a discussion from a year ago may not be pertinent to today's environment. Post, Ethan Ethan.Post To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @ps.net cc: Sent by: rootSubject: 1M STRIPE SIZE BEST? 11/20/2002 05:53 PM Please respond to ORACLE-L A number of papers recommend a stripe size of 1 M (even for EMC) for volumes containing data files. I also have the following email from Eyal Aronoff of Quest dated Nov 2000. A number of the white papers are more recent. The reasons for a larger stripe size on a non-RAID 5 device are: 1) Sequential reads are faster if you can take advantege of the read ahead built into the disk caching 2) If a 64K read does not start on the first block of the stripe, two spindled are locked for the duration of the read However, lately we have been testing some EMC gear and it looks like EMC have optimized both of those for smaller strip size too. The bottom line - I no longer have an opinion one way or another. The undelying technology just changes too rapidly. Eyal Your opinions/comments as far as a best practice in setting stripe sizes would be greatly appreciated. Thanks, Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan 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: Jared Still 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: db file sequential read
On Tuesday 19 November 2002 08:39, Cary Millsap wrote: 1. Make sure that the report on this statistic isn't being tricked by examining V$SESSION_WAIT.SECONDS_IN_WAIT. I'd bet money that this is what's happening. If your report uses this column, then it is highly likely that you're not actually waiting very long for physical I/O at all. The problem is that SECONDS_IN_WAIT keeps growing in 3-second increments long after an event completes, until the next event begins. Cary, we certainly appreciate your contibutions to the body of Oracle knowledge here. There's absolutely no other way for use to learn many of these things. Thanks, Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: Do user processes apply against shmmax limit?
Tim, Unless shared servers (MTS) are in use, in which case either the UGA or PGA is in the SGA. To be honest, I can't recall which, and I'm too lazy to go look it up right now. But MTS will consume memory on a per user basis, though the poster didn't mention it. And I'm quite sure you know this, but thought I would mention for the benefit of those on the list that don't know that. Let one of them look it up. :) Also, the vmstat stats show PI/PO at very low rates, and the SR ( scan rate ) is mostly zero. Jay, Ask your SA Where's the memory problem? Jared On Saturday 23 November 2002 11:38, Tim Gorman wrote: Your Sys Admin is wrong. The SHMxxx OS parameters refer to shared memory, not private process heap memory. On most UNIX variants, the ulimit command is used to limit the consumption of memory for heap, stack, etc... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, November 23, 2002 11:48 AM Hi everyone, I was always under the impression that the only concern with shmmax was that it be large enough for the SGA to fit into it. One of my System Administrators has just told me that the individual user processes (i.e., the PGA since we're not using multi-threaded server) get added to the SGA and if that SGA + user processes shmmax the system will start swapping. I haven't found anything to specifically address this issue on Metalink so I though I'd throw it open. We've started experiencing system slowdown and he says that increasing shmmax could resolve it. I'm skeptical (he also suggested increasing SGA to decrease swapping which I told him in no uncertain terms was nonsense). If anyone has a link to a note or white paper I'd appreciate that too. I've appended his email at the bottom. This slowdown seems to occur even when there's virtually on oracle activity so I'm suspecting some other cause. Thanks, Jay Miller nycsun1 and njsun7 has 6 GB of memory and only 2 GB of share memory. This morning nycsun1 was very slow and I noticed that there was lots of swaping. see vmstst and iostat below in red: procs memorypagedisk faults cpu r b w swap free re mf pi po fr de sr s2 s4 s4 sd in sy cs us sy id 0 0 23 4366736 97528 1 2186 16 12 12 95520 0 0 0 0 0 1104 3330 974 11 8 81 0 0 23 4365992 96056 1 451 16 24 52 85968 3 0 0 0 0 935 847 416 3 1 96 0 0 23 4364712 95512 2 310 36 24 492 85968 68 0 0 0 0 1036 2183 670 13 4 84 0 0 23 4361568 95488 9 2264 0 76 964 95520 136 0 0 0 0 979 4065 607 12 6 82 0 0 23 4362384 96080 1 6 4 8 8 77376 0 0 0 0 0 975 465 457 2 1 97 0 0 23 4361944 95712 4 730 92 48 532 95520 64 0 0 0 0 1040 1859 734 8 3 89 0 0 23 4360424 95480 4 41 36 40 100 77376 7 0 0 0 0 986 1250 542 6 0 94 0 0 23 4361304 96096 3 264 76 36 88 88496 7 0 0 0 0 1037 942 665 5 3 92 0 0 23 4359680 95784 2 449 4 28 84 95520 8 0 0 0 0 922 1047 374 4 1 95 0 0 23 4359936 95464 2 544 4 20 332 95520 44 0 0 0 0 931 1095 384 2 2 96 /s w/s kr/s kw/s wait actv wsvc_t asvc_t %w %b device 0.0 0.00.00.0 0.0 0.00.00.0 0 0 c2t6d0 0.0 34.50.0 270.0 0.2 13.86.7 399.5 6 44 c5t12d0 -- swap disk 0.0 34.50.0 270.0 0.5 10.7 15.5 309.4 18 39 c5t13d0 -- swap disk This shows that the system is not effectively using memory. I suggest increasing the share memory to 4 GB so that DBAs can increase their memory usage. Also set priority paging on. Priority paging will give application first priority then free memory will be allocated to file cache( Solaris 2.6 and 7. Solaris 8 is set dynamically). * ORACLE CONFIGS set shmsys:shminfo_shmmax =204800 -- increase to 409600 set shmsys:shminfo_shmmin=1 set shmsys:shminfo_shmmni=300 set shmsys:shminfo_shmseg=30 set semsys:seminfo_semmap=500 set semsys:seminfo_semmni=200 set semsys:seminfo_semmns=2000 set semsys:seminfo_semmsl=1000 set semsys:seminfo_semmnu=500 set semsys:seminfo_semume=150 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay 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: Jared Still
Re: Netbackup [#2]
... and buy the training. You will not fully understand Net Backup without it. Jared On Monday 18 November 2002 02:23, O'Neill, Sean wrote: Is no-one out there using NetBackup???. Without wishing to sound rude I'll assume a non-response indicates an affirmative to that OR that you're all too busy to voice an opinion ;) -Original Message- Sent: Thursday, November 14, 2002 15:04 To: 'List, OracleDBA [Fatcity]' Howdy Folks, Would appreciate feedback on experiences, positive :) or negative :(, folk have had using Veritas NetBackup product for DB recovery, especially in DR scenarios. There is an Oracle agent but so far all it appears to me to be is a glorious scheduler of your own RMAN scripted jobs!. Feedback on features I may have missed with agent would also be appreciated. - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: Do user processes apply against shmmax limit?
Jay, I would suggest that your SA look at the 'w' column under procs. This shows that _since_ UNIX restart 23 jobs were continuously in the wait queue. Maybe something starts up on system reboot... procs memorypagedisk r b w swap free re mf pi po fr de sr s2 s4 s4 sd in 0 0 23 4366736 97528 1 2186 16 12 12 95520 0 0 0 0 0 1104 0 0 23 4365992 96056 1 451 16 24 52 85968 3 0 0 0 0 935 0 0 23 4364712 95512 2 310 36 24 492 85968 68 0 0 0 0 1036 Also, could he show you 'sar -q' stats? This should show any swapping (as opposed to paging). John Kanagaraj Oracle Applications DBA DB Soft Inc Work : (408) 970 7002 Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- From: Miller, Jay [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 23, 2002 10:49 AM To: Multiple recipients of list ORACLE-L Subject: Do user processes apply against shmmax limit? Hi everyone, I was always under the impression that the only concern with shmmax was that it be large enough for the SGA to fit into it. One of my System Administrators has just told me that the individual user processes (i.e., the PGA since we're not using multi-threaded server) get added to the SGA and if that SGA + user processes shmmax the system will start swapping. I haven't found anything to specifically address this issue on Metalink so I though I'd throw it open. We've started experiencing system slowdown and he says that increasing shmmax could resolve it. I'm skeptical (he also suggested increasing SGA to decrease swapping which I told him in no uncertain terms was nonsense). If anyone has a link to a note or white paper I'd appreciate that too. I've appended his email at the bottom. This slowdown seems to occur even when there's virtually on oracle activity so I'm suspecting some other cause. Thanks, Jay Miller nycsun1 and njsun7 has 6 GB of memory and only 2 GB of share memory. This morning nycsun1 was very slow and I noticed that there was lots of swaping. see vmstst and iostat below in red: procs memorypagedisk faults cpu r b w swap free re mf pi po fr de sr s2 s4 s4 sd in sy cs us sy id 0 0 23 4366736 97528 1 2186 16 12 12 95520 0 0 0 0 0 1104 3330 974 11 8 81 0 0 23 4365992 96056 1 451 16 24 52 85968 3 0 0 0 0 935 847 416 3 1 96 0 0 23 4364712 95512 2 310 36 24 492 85968 68 0 0 0 0 1036 2183 670 13 4 84 0 0 23 4361568 95488 9 2264 0 76 964 95520 136 0 0 0 0 979 4065 607 12 6 82 0 0 23 4362384 96080 1 6 4 8 8 77376 0 0 0 0 0 975 465 457 2 1 97 0 0 23 4361944 95712 4 730 92 48 532 95520 64 0 0 0 0 1040 1859 734 8 3 89 0 0 23 4360424 95480 4 41 36 40 100 77376 7 0 0 0 0 986 1250 542 6 0 94 0 0 23 4361304 96096 3 264 76 36 88 88496 7 0 0 0 0 1037 942 665 5 3 92 0 0 23 4359680 95784 2 449 4 28 84 95520 8 0 0 0 0 922 1047 374 4 1 95 0 0 23 4359936 95464 2 544 4 20 332 95520 44 0 0 0 0 931 1095 384 2 2 96 /s w/s kr/s kw/s wait actv wsvc_t asvc_t %w %b device 0.0 0.00.00.0 0.0 0.00.00.0 0 0 c2t6d0 0.0 34.50.0 270.0 0.2 13.86.7 399.5 6 44 c5t12d0 -- swap disk 0.0 34.50.0 270.0 0.5 10.7 15.5 309.4 18 39 c5t13d0 -- swap disk This shows that the system is not effectively using memory. I suggest increasing the share memory to 4 GB so that DBAs can increase their memory usage. Also set priority paging on. Priority paging will give application first priority then free memory will be allocated to file cache( Solaris 2.6 and 7. Solaris 8 is set dynamically). * ORACLE CONFIGS set shmsys:shminfo_shmmax =204800 -- increase to 409600 set shmsys:shminfo_shmmin=1 set shmsys:shminfo_shmmni=300 set shmsys:shminfo_shmseg=30 set semsys:seminfo_semmap=500 set semsys:seminfo_semmni=200 set semsys:seminfo_semmns=2000 set semsys:seminfo_semmsl=1000 set semsys:seminfo_semmnu=500 set semsys:seminfo_semume=150 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay 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: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services--
Re: Oracle 10i features
Look for it to improve dramatically. I might even try to use it. Jared On Sunday 17 November 2002 06:13, J. Laurindo Chiappa wrote: Jared, just a thought : ** WHY ** Oracle experts charged in OEM developmentcan´t do anything close - fast, sweet simple , just to the point ?? Until now, OEM is just a pile of *hit, plain simple. Regards, Chiappa *** REPLY SEPARATOR *** On 13/11/02 at 05:23 Jared Still wrote: Check out OraC, written in Perl of course. :) http://www.tux.org/orac-dba/ Jared On Tuesday 12 November 2002 11:13, Jesse, Rich wrote: Good grief. Like I'm going to go through all of that overhead and hassle? And isn't 9iAS a separately licensable (read: cost) option, even if you're already licensed for EE? I think I'm reading the same PDF you were, Raj: The Console interacts with the Oracle Management Service, which, as a J2EE Web Application hosted by an Oracle9i application Server, leverages all of the reliability, scalability, and robustness of the Oracle9iAS instance. I wish I has time to work on the KISS-method OEM replacement I started... sigh Rich -- Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Tuesday, November 12, 2002 10:40 AM To: Multiple recipients of list ORACLE-L New EM4.0 (announced today) has a bunch of new features ... was just reading the PDF ... but it needs 9iAS ... that is a bummer ... more info on oracle website ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: Jared Still 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: 1M STRIPE SIZE BEST?
Jared, If an I/O call size is bigger than the Striping Unit (the size of one chunk), then a single I/O call can motivate participation of 2+ disks in an array. Even if the I/O call size is exactly the same as the striping unit, it can still motivate activity on 2 disks under normal operating conditions. See Hank Tullis's explanation at www.hotsos.com/catalog. Of course, under partial outage conditions, any read to the failed disk and any write to any disk in the array will engage participation from all the living disks in the array. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Dec 9-11 Honolulu - Hotsos Clinic 101, Jan 7-9 Knoxville - Steve Adams's Miracle Master Class, Jan 13-15 Copenhagen - 2003 Hotsos Symposium, Feb 9-12 Dallas -Original Message- Still Sent: Saturday, November 23, 2002 7:14 PM To: Multiple recipients of list ORACLE-L Maybe I've forgotten something fundamental about the way RAID 5 works, I dunno. But I'm having a hard time understanding how stripe size is going to determine the number of heads used in an IO. RAID 5 distributes the data across all spindles, with 1 or more of the spindles for any IO being used for the parity data. Someone care to enlighten me? Thanks, Jared On Thursday 21 November 2002 06:33, Thomas Day wrote: We had a discussion about a year ago here and if I remember correctly the best stripe size is a function of number of concurrent users. With a small number of users you want a small stripe size so that each read i/o will utilize the maximum number of heads. It will also tie up the RAID device for the duration of the read. With a large number of users you want a very large stripe size so that a minimum of heads will be used for each read and the RAID device can handle multiple requests at a time. I don't recall any specific numbers and, as you say, the technology is changing so quickly that a discussion from a year ago may not be pertinent to today's environment. Post, Ethan Ethan.Post To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @ps.net cc: Sent by: rootSubject: 1M STRIPE SIZE BEST? 11/20/2002 05:53 PM Please respond to ORACLE-L A number of papers recommend a stripe size of 1 M (even for EMC) for volumes containing data files. I also have the following email from Eyal Aronoff of Quest dated Nov 2000. A number of the white papers are more recent. The reasons for a larger stripe size on a non-RAID 5 device are: 1) Sequential reads are faster if you can take advantege of the read ahead built into the disk caching 2) If a 64K read does not start on the first block of the stripe, two spindled are locked for the duration of the read However, lately we have been testing some EMC gear and it looks like EMC have optimized both of those for smaller strip size too. The bottom line - I no longer have an opinion one way or another. The undelying technology just changes too rapidly. Eyal Your opinions/comments as far as a best practice in setting stripe sizes would be greatly appreciated. Thanks, Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan 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: Jared Still 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: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and
Re: instance shutdown problem ? (please help)
John, Well, system does not do a shutdown abort. Oracle finds a problem and then instance aborts. A few things you can do here. (1) See if a trace file is generated around that time in user_dump_dest or background_dump_dest that might provide clues. If you see a core fiel in any directory named core_* in the core_dump_dest, it has cored dumped. (2) Start the database from command line. From NT services panel, make the services OracleServiceXXX manual, from automatic. Then reboot the box. Start the service manually and then see what happens in the process. (3) Start the instance and service in a command prompt window using oradim comamnd. I am not sure of the options; but the oradim command gives a help. At some point you would hit a problem that is decipherable. Please let us know what came out of it. HTH Arup Nanda www.proligence.com From: john [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: instance shutdown problem ? (please help) Date: Sat, 23 Nov 2002 15:23:37 -0800 MIME-Version: 1.0 Received: from newsfeed.cts.com ([209.68.248.164]) by mc7-f16.law1.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Sat, 23 Nov 2002 16:09:45 -0800 Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id QAA21336;Sat, 23 Nov 2002 16:08:01 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 0050A280; Sat, 23 Nov 2002 15:23:37 -0800 Message-ID: [EMAIL PROTECTED] X-Comment: Oracle RDBMS Community Forum X-Sender: john [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] Errors-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Return-Path: [EMAIL PROTECTED] X-OriginalArrivalTime: 24 Nov 2002 00:09:45.0779 (UTC) FILETIME=[CB9F8830:01C2934D] ver 8i NT4.o all services have been set to automatic and start fine however the NT Event Viwer and the oracle alert.log show that the instance being shutdown just after the box boots up. how do we rectify this problem ? below is from the alert.log ORA-205 signalled during: alter database mount exclusive.. Shutting down instance (abort) License high water mark = 5 Instance terminated by USER, pid = 144 --- please note: the shutdwon was not initiated by any admin or user but done by the system itself after the box boots up. __ Do you Yahoo!? Yahoo! Mail Plus Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: john 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). _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arup Nanda 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).
