Hi Nameless,
no advice from me than: learn your stuff,
be confident in what you know. And as
you could see from some other answers:
ASCII stupid question, get a stupid ANSI.
;-) Still one of my favorites.
Good luck,
Guido
[EMAIL PROTECTED] 24.09.2003 23.04 Uhr
List , I am planning to give
Hi,
Any body have any idea about how to control the size of library cache and
sql area in shared_pool?
With Regards,
Manoj Kumar Jha
A transcendentalist engaged in auspicious activities does
There is no control on these parameter. Oracle manage it by itself. Only one
parameter: shared_pool_size.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 25, 2003 3:09 PM
Hi,
Any body have any idea about how to
You cannot control the sizes of sql area and library cache
individually
Regards
On Thu, 25 Sep 2003 ManojKr Jha wrote :
Hi,
Any body have any idea about how to control the size of library
cache and
sql area in shared_pool?
With Regards,
Manoj Kumar Jha
Not really, even in India an examinee takes the exam!
The problem is due to the literal translation of the same sentence from
Hindi (most indians speak hindi) to English
Sorry for a little OT.
Regards
Naveen
-Original Message-
From: AK [mailto:[EMAIL PROTECTED]
Sent: Thursday,
Dear list,
Question in Brief:
1. On 7.3 client even if NLS_LANG in registry is set to
'AMERICAN_AMERICA.US7ASCII', the default NLS_DATE_FORMAT for the
session is set to 'DD-MON-YY'. How come? Shouldn't it be
'DD-MON-RR'? There is no environment variable NLS_LANG nor any
SQL*Plus variable. Yes, I
How the ORACLE distribute and mange the size of variouse component in
shared_pool?
There should be some criteria on which it disribute its toatl available
memory to these component.
Steve Adams/Jonathan, do you have any about these?
Also are there any way to control the number and type of
Whoa there!
See below:
-Original Message-
From: elain he [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 23, 2003 9:40 PM
To: Multiple recipients of list ORACLE-L
Subject: select distinct values
Hi,
Could someone shed some light on this.
I'm trying to formulate a query
Hi Manoj,
Although the stats are confused, the SQL area is in fact a subset of the
library cache. Cursors are cached in the library cache as namespace 0.
You can exercise limited control over the memory usage by marking objects
for keeping with DBMS_SHARED_POOL.KEEP. Otherwise, the retention of
Tables have default INITRANS value.
I want to set this parameter to a suitable value. Because INITRANS is 1 as default
value and I want to avoid from load of dynamic
But how can I figure out suitable value of this parameter for each table.
--
Please see the official ORACLE-L FAQ:
I think in most case, initrans=1 should be enough for most tables, as one block has a
transaction slot. unless two different session are DMLing the exact same block, oracle
will dynamically allcoate another transaction slot.
If you really want to find out the tables maybe need more initrans,
Ah-a - NOW I see why you want my old version 5 manuals!!
peter
edinburgh
-Original Message-
From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 24, 2003 7:45 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: 10g: SQL Plus
Well, we have a good,
since one of your developers worked for me for over a year (as a DBA!)
I can vouch for the fact that at least one of them knows the database,
and is a top-notch programmer :)
--- [EMAIL PROTECTED] wrote:
David forgot to mention a couple of things about working for AISD:
- We don't wear
Sir Norgaard, Group,
Accepted, I think #43 is rather cool,
as in: life, the universe and everyting++
I'll have to postpone review/critque/shredding of any
text, statement or documents to the weekend.
Too Busy Fighting non-baarf-ers...
Will have meeting with commercial-of-the-shellf (COTS)
hw
Hi Steve,
Sorry for it, but I want to correct one thing that is ,
it is Libarray cache which is subset of SQL area which intern subset of
shared pool.
With Regards,
Manoj Kumar Jha
A
Jared, Group,
briefly : my preferred cluster has 4 or more machines,
with a single oracle-home installed on the SAN.
Optionally: a physical standby system of 2 or more machines
with stdby db running, lgwr for transport, in max-avail-mode.
a second oracle_home will be kept on the same san,
but
Hi!
Btw, minimum inittrans is 2 in 9i when block is formatted using conventional
insert and it's 3 when a block is formatted using direct path insert, even
though data dictionary claims otherwise.
Optimal inittrans for a *block* is the number of concurrent transactions in
it. Optimal inittrans
As I understand SQL area is a subset of library cache which is a subset of
shared pool.
Taking advantage the opportunity that Steve is here, I'd like to ask how
does Oracle distinguish between recurrent and transient chunks? Is this
hardcoded, that certain types of chunks go to transient end of
Prem Khanna,
Yes I know that Steve is master of unix/oracle internals, that why I want
to clarify my doubt.
I had doubt that why I asked you fine people.
Yes as far doc. and references are concerned, all clearly say that sql area
is subset of library cache.
but my doubt is due to size of
Title: RE: Oracle Compress Option
I think 9202 doesn't like to export compressed tables in direct mode ... so watch out for that ... I implemented, tested and next day reverted back to regular tables due to this export issue. Disk is cheap.
A BAARF party member wannabe !!
Raj
http://www.theregister.co.uk/content/53/33042.html
-Original Message-
Stephane Faroult
Sent: 25 September 2003 02:45
To: Multiple recipients of list ORACLE-L
RANT
Well, concerning point 4), I am surprised by the resilience of users to
often dreadful applications. Perhaps that with age
Title: RE: RAC for download
Me thinks partitioning is part of EE but you must license it ... (so Uncle Larry can sponsor 2 laps in the BMW racing using your license money).
Raj
Rajendra dot Jamadagni at
Title: RE: Oracle Compress Option
Disk is not cheap
if you pay for high availability configuration. I compress historical data on
daily basis and was able to save 70 percent of the disk space. Imagine the
amount of savings for five TB.
Two major
issues:
1) Oracle says
updates will be
Hi,
I have the following data , table Temp
ID Text Order
1 B2
1 A1
1 C3
I want to write a query which says: wherever there is more than 1 occurrence
of ID then concatenate the text in the order specified in the order column.
So i would get:
ID Text
1
Title: RE: DBA needed in Austin, TX
I forwarded this message to a person I work with. He's retiring from the military on October 10th and doesn't have anything lined up yet. We're down in San Antonio at Randolph AFB.
-Scott
-Original Message-
From: Rachel Carmichael [mailto:[EMAIL
Oh, it's not me, I was just replying to somebody. My company is not running
RAC.
I know what clustering means, I have 5+ years of experience with OPS on both
versions 7 and 8 plus I used to teach people VMS and how to tune it. Yeah,
you're absolutely right clustering is flustering, don't do it
Title: Message
I
really like that "no DBA left behind" program of yours, but TX is too hot for
me. I know it's a dry heat
but
nevertheless, I do prefer colder climate. You can keep the Dixie
Chicks.
--Mladen GogalaOracle DBA
-Original Message-From:
[EMAIL PROTECTED]
Yes. Just increase the SHARED_POOL_SIZE parameter and you've increased both
library cache
and SQL area. Not just that, you've also increased the row cache as well.
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of
From 9.2 doc:
Shared Pool
The shared pool portion of the SGA contains three major areas: library
cache, dictionary cache, buffers for parallel execution messages, and
control structures.
The total size of the shared pool is determined by the initialization
parameter SHARED_POOL_SIZE. The
Title: Message
I
agree: disk is cheap, as long as I don't have to pay for it.
--Mladen GogalaOracle DBA
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Jamadagni, RajendraSent: Thursday, September 25, 2003 9:50
AMTo: Multiple
Well, if you look it from memory allocation point of view, then during
startup, a heap in size of shared_pool_size is allocated for shared pool and
all memory allocations for library cache, sql area, pl/sql mpcode, KGL
library cache manager structures, etc, are made from the same shared pool
heap
Title: RE: Oracle Compress Option
Hm, interesting...
How does your active-active config work, do you
have write activity on all nodes?
I'd be interested in any performance issues you had
or currently have...
Have you partitioned your application or data usage
somehow?
What kind of
Title: RE: Oracle Compress Option
Something else I
forgot, full segment scans becomes faster, since he segment is 70 percent
smaller.
So this could
help balancing resource utilization between the CPUs and IO.
Waleed
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL
Hi Tanel,
There was a note in the bug database back in 7.1 days that suggested that it
was hard coded based on the chunk type, and so that's what I wrote in my
book.
However, I fear that that might have been wrong. At least it is in recent
versions. It is not hard to set up a test in which you
Title: RE: Oracle Compress Option
Hi!
I think in DW style environments, compressed fact
tables and indexes on them can give more benefit than just saved disk storage
- if you save 50% in space due compression, then 100% more data can be read
in single IO as well.
Tanel.
- Original
AK, Naveen
Thanks for the clarification. That is an interesting bit of language trivia.
I'm still working on my first language and some people say I need to work
harder. I can't imagine trying for a second language.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
Title: RE: Oracle Compress Option
we have 2 gbit private interconnects of which only one is used at any
given time. Everyone else talks to the dbs using public network. Both are
active/active. On one instance luckily we have application partitioning one side
manages the feeds that come from
Title: Message
dry
heat??
Not
sure about Austin, butI have some co-workers in Dallas where they say it's
100x100: 100 degrees with 100% humidity...
greg
-Original Message-From: Mladen Gogala
[mailto:[EMAIL PROTECTED]Sent: Thursday, September 25, 2003
10:05 AMTo:
Hi All,
I am investigating an effort to move our product into Oracle from SQL Server. Came
across the function isnumeric, isdate in SQL Server that returns true or false if the
input string is in a form that can be converted into a numeric or date type. searched
in oracle help and am not
Title: Message
Hi!
I think putting your small tables to 2K block size
is quite pointless (unless you have tensof thousands of these tables
continously in buffer cache).
Tanel.
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Title: RE: Oracle Compress Option
Thanks for the information.
One more question, is your interconnect ethernet
based or proprietary such hyperfabric for hp etc..
Thanks,
Tanel.
- Original Message -
From:
Jamadagni, Rajendra
To: Multiple recipients of list ORACLE-L
oops, I forgot to mention Partitioning pricing.
Partitioning is also listed seperately under Enterprise Edition options.
This is 25% of the EE price.
Thus, EE is US$40K per CPU. RAC is US$60K per CPU [40K + 20K].
Partitioning is US$50K per CPU [40K + 10K] and RAC with Partitioning would
be
Check oraclestore.com. The default page just shows you the pricing
for the DB EE, true.
However, when you click on Database under Products in the left panel,
you can see Oracle Enterprise Edition Options listed seperately from
Oracle Database.
RAC is under Enterprise Edition Options while EE is
Title: RE: Oracle Compress Option
ethernet ... gBit ...
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly personal. QOTD: Any clod
can have facts, having an
Raj,
How can we know if only one Pvt Interconnect is used
at a given time? How are you monitoring them
real-time? Is the GC traffic not load balanced ?
Are you using cluster_interconnects?
Thanks,
Ravi.
- Original Message -
From: Jamadagni, Rajendra
To: Multiple recipients
I am not sure if there is any such function in 9i . But you can definnitely
accomplish this by writing your own function something like
function isNum(a varchar2) returns boolean is
begin
b := tonumber(a);
result = true;
return result;
exception
when
Title: RE: equivalent for isdate, isnumeric
to_date, to_number
-Original Message-
From: Shiva Maran [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 25, 2003 11:35 AM
To: Multiple recipients of list ORACLE-L
Subject: equivalent for isdate, isnumeric
Hi All,
I am
This topic came up earlier this week, so just look
it up in you mail.
Or check out the archives at www.fatcity.com.
Archives are available at a number of unauthorized
locations near you: www.faqchest.com is one I believe.
Jared
On Thu, 2003-09-25 at 08:34, Shiva Maran wrote:
Hi All,
I
Title: RE: URGENT REPORTS
Guys,
This is a stupid question but how is directing DISPLAY for reports with xterminal services versus the VNC route?
-Original Message-
From: Jesse, Rich [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 24, 2003 6:15 PM
To: Multiple recipients of
Hey all,
Is there a way to get your own executing program from a 9.2.0.4 RAC node?
USERENV('SESSIONID') and SYS_CONTEXT('USERENV','SESSIONID') each return a
big fat zero on RAC.
My ultimate goal is to get the executing session's program, and the only
place I can find that info is in V$SESSION.
Hey, I'll sue you for using my code. My code is fair and balanced and you
cannot use it
without paying royalties.
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of AK
Sent: Thursday, September 25, 2003 12:20 PM
To:
OK, I'll bite: If SORT_AREA_SIZE isn't to be set, then what is? Are you
referring to the automagic PGA management?
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
10:30 AM CST = 5:30 PM CEST. Rats! Now
create or replace function
isnumeric(str varchar2) return boolean deterministic
as
num number:=0;
begin
num:=to_number(str);
return(true);
exception
when others then
return(false);
end;
/
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL
Title: RE: URGENT REPORTS
You got to have xvnc server installed somewhere,
then you can direct any X app to it as you would do with normal X. So the app
appears on vnc virtual display and if you want to see it, you have to connect to
this virtual display using vncviewer.
Tanel.
-
but you are a liar and a bully and have splotches all over your face.
oh - sorry - thought you were that O'Reilly character. I'm reading the book
now. pretty funny.
-Original Message-
Sent: Thursday, September 25, 2003 12:35 PM
To: Multiple recipients of list ORACLE-L
Hey, I'll sue
Title: RE: Oracle Compress Option
we monitor it through nmon ... (aix utility). GC traffic is not load balanced across both interconnects if that is what you mean. There is no way ... first one is used and if that fails the second is used. We are NOT using cluster interconnects I saw some bug
I often do this:
select * from v$session where sid = (select distinct sid from v$mystat);
Alan.
-Original Message-
Sent: Thursday, September 25, 2003 9:20 AM
To: Multiple recipients of list ORACLE-L
Hey all,
Is there a way to get your own executing program from a 9.2.0.4 RAC node?
EE 40,000/CPU
RAC 20,000/CPU
Partitioning10,000/CPU
List prices in US Dollars for each are above. Of course, the promised grid pricing
that was supposed
to be out last week but isnt yet may effect this ... we can all hope at least.
-Original
Join it with (select sid from v$mystat where rownum 2)
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 25, 2003 7:19 PM
Hey all,
Is there a way to get your own executing program from a 9.2.0.4 RAC node?
select inst_id,username,sid,serial#
from gv$session
where sid=dbms_support.mysid;
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Jesse, Rich
Sent: Thursday, September 25, 2003 12:20 PM
To: Multiple recipients of
I want to run some sql scripts and i need to open 255 session at same time and
these session will run somw sql scripts.
HOW CAN I OPEN 255 session at the same time ?
may be a tool , may be shell script.
Help bittee
--
Please see the official ORACLE-L FAQ:
Raj,
How can we know if only one Pvt Interconnect is used
at a given time? How are you monitoring them
real-time? Is the GC traffic not load balanced ?
Are you using cluster_interconnects?
Thanks,
Ravi.
- Original Message -
From: Jamadagni, Rajendra
To: Multiple recipients
Imran,
Tom Kyte has a thread that might help:
http://asktom.oracle.com/pls/ask/f?p=4950:8:1554835115460038644::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:229614022562,
Essentially, you can do this:
CREATE or replace FUNCTION CONCAT_LIST( cur SYS_REFCURSOR )
RETURN VARCHAR2 IS
ret
Thanks Alan and Tanel! Looks like I'll be using V$MYSTAT.
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
-Original Message-
From: Alan Gano [mailto:[EMAIL PROTECTED]
Sent: Thursday, September
Title: RE: USERENV('SESSIONID') on RAC
userenv('sessionid') matches with audsid in v$session ... but you already knew that ...
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email
Type..
sqlplus user/[EMAIL PROTECTED] @script.sql output.log
..255 times on your unix command prompt.
If on windows, type
start /min sqlplus user/[EMAIL PROTECTED] @script.sql
..255 times on your windows command prompt.
Tanel.
- Original Message -
To: Multiple recipients of
Title: RE: URGENT REPORTS
An X-DISPLAY application (Reports) needs to access
an X-display terminal in order for it to run.You can either give it a real
X-terminal, or you can simulate the functionality (pretend X terminal) with
software, either Xvbf or VNC. Since the application doesn't need
ORA-00904: DBMS_SUPPORT.MYSID: invalid identifier
SQL @$ORACLE_HOME/rdbms/admin/dbmssupp
Statement processed.
Statement processed.
SQL select inst_id,username,sid,serial#
2 from gv$session
3 where sid=SYS.dbms_support.mysid;
INST_ID USERNAME SIDSERIAL#
Title: Message
On our
appliance, to get around the irritating load-balancing+failover issue, we're
using 802.3ad link aggregation. Trying to load-balance Gigabit is really
an exercise in futility - almost all of theperformance improvement comes
from improved interrupt queuing (and even
Title: RE: URGENT REPORTS
Thanks.
-Original Message-From: Binley Lim
[mailto:[EMAIL PROTECTED]Sent: Thursday, September 25, 2003
1:05 PMTo: Multiple recipients of list ORACLE-LSubject:
Re: URGENT REPORTS
An X-DISPLAY application (Reports) needs to
access an X-display
100 deg. F and raining - Happens all over Texas during an afternoon summer
thunderstorm, though the rain usually cools things down a bit.
The wimps in Dallas can't complain about humidity at all. Folks in
Houston certainly can.
Unfortunately, my wife won't let me keep even ONE of the Dixie
Rich - Actually the hint in that posting made me realize what I was
wrestling with on an index build. Don Burleson explains it well
http://www.praetoriate.com/oracle_tips_sorting_operations.htm
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Title: RE: DBA needed in Austin, TX
Dude... it NEVER rains in Amarillo. Humidity is rarely over 20%, frequently near 100 degrees... winds of upwards of 30 MPH in the spring, fall and some of the summer (there have been light person warnings here)... but there are only cotton wood trees and
Hi List,
Does anyone come across this issue? What should i do
to resolve this?
Any help would be really appreciated.
TIA
RMAN register database;
RMAN-03022: compiling command: register
RMAN-03023: executing command: register
RMAN-08006: database registered in recovery catalog
RMAN-03023:
I like your username.
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Jesse, Rich
Sent: Thursday, September 25, 2003 1:20 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: USERENV('SESSIONID') on RAC
Title: Message
Nope.
It means that it's hot as heck and humid as heck and it makes you wonder why did
you turn down
that
job offer in Anchorage.
--Mladen GogalaOracle DBA
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Mercadante,
I was talking about partitioning, not about RAC.
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Hemant K Chitale
Sent: Thursday, September 25, 2003 11:55 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: RAC
Mladen,
Why python?, why not keep using perl?
cheers
pete
--
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.
--
Please see the official ORACLE-L
/dev/vx/rdsk/dbdg13/Rcatctrl.ctl
Does this directory exist, does Oracle have priv's on it? Does the file
already exist, and of so who owns it and what are the privs?
RF
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 9/25/2003 12:39 PM
Hi List,
Does anyone come
I would love to have a definitive site that I could send all RAID-F
advocates to where it would be laid out clearly, unambiguously, and
definitively what storage types should be used for what purpose.
Redo logs on RAID 0 with Oracle duplexing (y/n)?
Rollback (or undo) ditto?
Write intensive
Title: RE: DBA needed in Austin, TX
-Original Message-From: April Wells
[mailto:[EMAIL PROTECTED]Sent: Thursday, September 25, 2003 1:40
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
DBA needed in Austin, TX
Dude... it NEVER rains in Amarillo. Humidity is rarely
Hi Robert,
The directory does not exist. I am just trying to
register the database(RMANregister database).
My question is...
from where did it pick up the name of
the control file /dev/vx/rdsk/dbdg13/Rcatctrl.ctl.
Also i tried the same operation(register database) for
different database which
Because my new company is using python and I think I'll have to learn it
sooner or later.
What is more, there seems to be growing confusion with versions on Windows
operating
systems. ActiveState is lagging behind with DBI/DBD drivers and it was a
problem to get
it all working.
What is more, Perl
Title: RE: DBA needed in Austin, TX
Me neither... but my son does (my daughter too). I could tie a
string to him and fly HIM like a kite some days.
There are days when the air is tan... and once I saw it rain mud.
It is really neat
April Wells Oracle DBA/Oracle Apps DBA Corporate Systems
I would strongly advise against redo logs on RAID-0 with oracle duplexing.
Different operating systems respond more or less gracefully to the vanishing
of a storage device (which is the normal behavior of a failed disk on a
RAID-0 set on a HW array). There's too many variables possible to list
Title: Message
Matt,
What is 802.3ad link aggregation ?? Any handy URLs ??
TIA
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly personal. QOTD: Any clod
can
Interesting, we hadn't considered setting up 2 Oracle homes on shared disk.
Had we considered that, we would have likely still gone to a separate oracle
home per node. These servers are running SAP, and SAP is the micro managing
PHB of the COTS world. Changing OHOME can be non-trivial with SAP.
# get number of processes to run from cmd line
if [ -z $1 ]; then
#default to 5
MAX_CHILD_COUNT=5
else
MAX_CHILD_COUNT=$1
fi
echo Running $MAX_CHILD_COUNT children
CHILD_COUNT=0
while [ $CHILD_COUNT -lt $MAX_CHILD_COUNT ]
do
(( CHILD_COUNT = CHILD_COUNT + 1))
# run your
Hello All,
I was wondering if anyone is using OCFS (1.0.9-6) and oracle RAC 9.2.0.4 on
redhat advanced server 2.1. We are hit by OCFS bug 3146671, which freezes up
the archive destination and hangs the RAC instances. The workaround oracle
recommends is to use local file systems for archive
Rich
Spoke to Kirk (virtually anyway). I won't send you his initial response
since there are ladies present (it was aimed at himself, BTW), but after a
bit of looking into it, here's his second response:
The link to SP1 is ftp://ftp.suse.com/pub/unitedlinux/1.0/src/ .. for SP2
/ SP2a the
boolean is not SQL datatype and it's unclear what deterministic
means here.
Mladen Gogala wrote:
create or replace function
isnumeric(str varchar2) return boolean deterministic
as
num number:=0;
begin
num:=to_number(str);
return(true);
exception
when others then
return(false);
end;
/
--
Fellow Listers,
If you don't deal with Oracle databases on SAN/NAS
environments, this posting may not interest you. If
so, my apologies, please delete this. Otherwise,
please read on.
In an effort to better understand what issues you face
when deploying an Oracle database in a SAN/NAS
Crap. I guess I'll have to read another Perl book to continue writing Perl
programs.
And just when it was going so well...
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
-Original Message-
PGA_AGGREGATE_TARGET
Jesse, Rich [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
09/25/2003 09:34 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: guidance
OK, I'll bite: If SORT_AREA_SIZE isn't to be set,
Did you leave off a :-)? I remember plenty of 100% (or at least high
90s') days back in Troy/Albany. When I moved to Seattle I had to explain
what 100% humidity was or what the weather man meant by good sleeping
weather. Don't miss the summers, but I do miss the foliage...
ObOracle: Best
I'm not there yet, at least not in production, but I am looking forward to
putting thousands of small (actually empty) tables and indexes of
Peoplesoft Financials into a 2K tablespace. Not that they will ever occupy
any room in the buffer pool, but just for the savings in disk space (and
Hi,
Do any of you have any recommendation about any tools / software which
replicate data between DB2 and Oracle ? Are there any good products out in
the market ? I would really appreciate if you could suggest something.
I am looking to replicate around couple of hundred thousand rows a day. The
That is a very reasonable default. Why would you want to have the hassle of
file locking
and inter-node coordination for such a trivial thing like archiving redo
files? In a RAC
system, if one instance is unable to archive its logs, the other one will do
that instead.
There should be a table
And what do you suggest?
Matthew Zito
Title: Message
mucho gracias ...
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly personal. QOTD: Any clod
can have facts, having an opinion is an art !
1 - 100 of 156 matches
Mail list logo