  | | | Oracle List | For the right person this is a great opp so although I have no vested interest in the position I thought I would post the info.
Position is local to Dallas but requires a week and a half in TokyoI am looking at a new application that will store millions of images about
70-k each. My instinct is to store them in a blob datatype. I haven 't worked
with blobs before. Can anyone suggest resourc
Can you run a "select * from v$recover_file " and put its output up here.
Also the status from v$datafile might be useful
Thanks
I have never done this but I think if you want to set up "STANDBY " you
would do this on your standby database
STARTUP NOMOUNT
ALTER DATABASE MOUNT STANDBY DATABASE
RECOVER STANDBY DATABASE
I have no experience with partitioning but plan on gaining
some ASAP. I want to partition a table into 52 pieces.
This table will contain a rolling 52 week summary of data.
Each week a new partitiPaul
Further to my previous email and your reply we are having this issue while
running from our local PC to server using Reflections. What was your
environment. Or has anyone installed using r
On 04/14/2004 01 42 44 PM ryan.gaffuri@(protected) wrote
> They going out of business? You can get tom kytes and connor mcdonalds books really cheap. if anyone is
> interested.
So Tom and Connor mccdba
There are 2 pieces to this question. There is what the
HW and Cluster manager software will support and then
there is what Oracle will support.
Oracle only supports up to a 32 node cluHi Walt
It depends.
What performance are you talking about? Apologies for not understanding
your 'page truns ' phrase. What 's 25. million turns? hits or changes?
changes or transactions? Even th
On 04/19/2004 07 16 43 PM "Nelson Allan " wrote
> I have exported on 8i on HP-UX and imported to 9.2.0.5 on Linux (RH AS
> 2.1). No problems with the export/import cycle.
This simply forces Sam If you want to use the 10g RAC standard edition
you cannot exceed 4 CPU 's. So you can only have 4 node
1 CPU cluster or 2 node 2 CPU cluster.
I am not 100% sure but I don 't think 10G rac (aHey folks
Are any of you all using any type of storage SNAP implementations to create
copies of your databases??
For example the Veritas FlashSnap product? HP EVA HW SNAP? Looking to
Oracle 9.2
I have two tables voice.line_dup voice.mike_test. mike_test was created
using the scripts from voice.line_dup with the same constraints enabled. I
then inserted all of the data from
On 04/14/2004 08 04 59 AM ryan.gaffuri@(protected) wrote
> Anyone ever run into this situation? Where logical I/Os are radically reduced but overall stress on the system > > is radically increasedThanks. I got that from O 'Reilly 's site. They also have an excerpt from
chapter 12
http //www.oreillynet.com/lpt/a/4304
PS Does anybody know of papers/web sites/books that discuss performance
Hi
I always preferred the command line version for one reason sqlplusw kept
screwing up the display with high values for linesize (like 900).
Stefan
-----Urspr?ngliche Nachricht-----
VonHi Larry
I just did a fresh 10g install on my windows laptop last night plus
AcitveState Perl 5.8.
I ran into the same issue just ignored the Perl that comes with 10g
"fixed " PERL5LIB and
I 'Especially 1521 and 1526 combined with a standard Oracle Net configuration
are highly recommendable.
That way one can easily redirect incoming SQL*NET traffic to a more
lightweight process like A
On 04/14/2004 03 43 59 AM Satheesh.Babu@(protected) wrote
> List
> One of our site is having some peculiar problem. When they are
> running some batch jobs or online operations they X doesn 't have anything to do with Apache. Much more probable answer is that you
are trying to start it up on a busy port. Anyway apache has that strange concept
of error log and it looks like thisThat would be great to get members on this list together. What time and
where? 20
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)] On BehalfThe problem got fixed. It is the OUI problem. It must be upgraded by
installing in $O_H and I am installing into the separate location in the
same way I installed 9201 ie in a separate directory anIt looks to me that I may not have installed the OUI 10.1.0.2 in a proper
location. Here is what I did for oracle 9201 installation Specified
$ORACLE_BASE/oraInventory_9201
$ORACLE_BASE/jre_Larry that won 't work.
Try ftp //ftp.esoftmatic.com/outgoing/DBI
Jared
"Larry Elkins " <elkinsl@(protected) >
Sent by oracle-l-bounce@(protected)
04/13/2004 02 35 PM
Please respondMike...
for your first question
1.- I 've found problems with rbs tablespaces EXPorting
data.
The solution was
1.- Leave the RBS tbs as dictionary managed...
or...
2.- Drop and recreate frWhat is troubling me here is that run2 is using only 5% of the consistent gets that run1 does. I thought consistent gets was the most important statistic for queries?
All of the logical I/Os of run
Alter tablespace temp add tempfile "/db05/oradata/dbx/temp01.dbf "
Igor Neyman OCP DBA
ineyman@(protected)
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto orYou must have physical disks shared between two or more computers. That in particular automatically
eliminates NFS CIFS (SMB) and other file sharing protocols. Netapp (used by our company) is not
On 04/13/2004 01 22 01 PM Deanna Schneider wrote
> The recommended hack is to change all extended characters to their html
> entities before insert - which works fine if you 're using the data
Dennis
Could I suggest the following as an enhancement
to your SQL.
select
/*+ ordered */
sql_text
from
v$process a
v$session b
v$sqltext c
where
a.sp |
|
 |