 | | | Oracle List | | > >What advantages do 10G RAC has over 9iRAC?
More people have implemented 9iRAC...to me this equals better support
and more information.
Also a real question is ISV 's software support for 10g dHi all
today I faced a strange (at least for me) problem.I had to delete 30k
row from a table containing long raw. the delete (which was espressed as
delete from t where id in (select id from tOn Wed 26 Jan 2005 16 17 38 +0000 ryan_gaffuri@(protected)
<ryan_gaffuri@(protected) > wrote
> this is the only place i use this email.... looks like they got a new twist on the old nigerian scam.On Wed 26 Jan 2005 16 31 47 -0000 Nick Tilbury @ Northampton
<ntilbury@(protected) > wrote
> We also had a similar issue. Which version of Oracle are you on ?
> Renaming the database will not chIf you are installing the Repository on an Oracle database on the same
machine then No. But if it 's just the Oracle Developer suite (Designer
Reports Forms etc.) then yes 1GB of RAM is plenty.On Wed 26 Jan 2005 10 43 40 -0500 (EST) tboss@(protected)
...
> but I wonder if you 're eventually going to run into major performance
> issues w/ the disable/reenable of FK constraints. Hi Hellen
>Does anyone have information and examples of using "CDATA "?
Let 's say you have to insert the character " < " as text in an element
named "a ".
This is an invalid XML document
<Hi John
>1. Partition the table by the date column
Good for the drops.
>2. Create a local partitioned index using that column
According to your description you don 't need it.
>3. CreateHi all
I was seeing the "slave exit " wait event appearing occassionally on a 9iR2 database last week but couldn 't find much in the way of documentation. I know I know I know - it 's not on the I have 2 schemas A contains tables and B contains Stored Procedures
when I try to trace the stored procedures It doesn 't register the
execution plans and the number or records of each step although
I found out recently
Oracle 9i support ASYNC IO on Linux.
Oracle OCFS supports ASYNC IO on Linux.
*HOWEVER* Oracle 9i RAC + OCFS + using ASYNC IO is NOT supported.
...but I am currently runGuys
Over 5 years or better it has been drilled into my head not to analyze
the system or sys objects. Imagine my surprise when in the readme for
9.2.0.6 patchset it says to run
Dbms_stats.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
--
http //www.freelists.org/webpage/oracle-l
I did this before [back when memory was a problem (so we used MTS)].
Forgive me if everybody already knows this...
Anyway port 1521 is the starting port number the mts server processes
communi have 2 clients still running 8170 on w2k boxes and want to patch up
to coincide with the 9205 server instances. are there any documents
that could be reviewed for accomplishing this migration. doeHi Ian
>The performace increase wad better than I expected. Results were very
>similar for the handful of pv_ids I tried.
The main problem of a compressed table (or partition) is the poor
sAnyone tried the UTL_ENCODE package in Oracle ? In particular trying to get it to decode a file
that has been previously uuencoded via the OS.
Example
Original file f.doc (MS worRoger Xu wrote
>
>How do I do it if I want to build the SQL first in a variable for a PL/SQL statement?
>
>
>cmd 'SELECT ' || l_column || 'FROM emp WHERE name LIKE '% O/ 'REAR ' ESCAPE '/ '
Your right I did not intend to launch a political debate but was
interested to see if anyone else had ever had to deal with such an audit
finding as it was a first for me. Usually suggestions rjamya wrote
> <shudder >
>I see dead emails !
>
>
Take the blue pill. This list is everywhere. It is all around us. *...*
It is the world
that has been pulled *over* *your* *eyes* to bWe are getting ORA-4030 error. The PGA_AGGREGATE_TARGET is 500M with 1.1GB
SGA. What are the possible causes of the problem?
Following are the someof the errors in the alert.log? Is there any bugThis will no doubt make a number of listers happy. )
http //open.itworld.com/4923/050111pervasive/page_1.html
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
httpSQL*Plus or some other database interface?
If SQL*Plus check out the BREAK command in the User Guide.
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)We installed the 9.2.0.6 patch on a Linux server on Jan 5 (the client was at 9.2.0.4). Since that time the allocated space for undo segments has grown alarmingly. The allocated space used to range ~Yeah and call it "crun " ...
Jon Knight
-----Original Message-----
From oracle-l-bounce@(protected) [mailto oracle-l-bounce@(protected)]
On Behalf Of ryan_gaffuri@(protected)
Sent MRuth Gramolini wrote
>I thought this was the quarterly patchset. I downloaded and installed it on
>our test box. Are there going to be more coming before the April quarterly?
>
>
Ruth whaI thought this was the quarterly patchset. I downloaded and installed it on
our test box. Are there going to be more coming before the April quarterly?
Ruth
-----Original Message-----
From Helmut
> >did a restore of our production database to a different box.
> >But RMAN was using an older backup to do that.
What type of contolfile backup are you using?
What is the date of the coHello
I 'm an oracle-l newbie DBA. I just switched my database over to a locally
managed temporary tablespace and apparently set the extent size incorrectly.
We have been getting an ORA-3232 error
On 01/24/2005 06 51 22 AM John Dunn wrote
> I am attempting to use automatic shared memory management in oracle
> 10G but
> having set the sga_target value and attempted to bounce the database |
|
|
