[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
[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
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
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]
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
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
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
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
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
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
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
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
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
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
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
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,
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
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
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:
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
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
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
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
... 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
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
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,
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
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
28 matches
Mail list logo
