Hi
Gurus
Oracle
8.1.7 on HP Unix
I
have some problems in Materialized view
Here
are the sequence of steps
Created
a normal view CT_PRODUCTID_VW
Created
a materialized view CT_PRODUCID_MVW
Dropped
view CT_PRODUCTID_VW
Rename
CT_PRODUCTID_MVW to CT_PRODUC
But the main point is valid. The phenomenon observed by Nancy is caused by the
storage in the row.
On 2003.10.16 19:59, Paul Drake wrote:
how about using tablespaces UMDOTBS (instead of UNDOTBS) and SYTSEM?
thanks for the laugh.
Pd
Mladen Gogala <[EMAIL PROTECTED]> wrote:
This is because "ENABLE
--Boundary-00=_4CPVRN00
Content-Type: Multipart/Alternative;
boundary="Boundary-00=_5CPVMY50"
--Boundary-00=_5CPVMY50
Content-Type: Text/Plain;
charset="shift_jis"
Content-Transfer-Encoding: quoted-printable
Congrats Den
That's the problem with answering without thinking the answer completely
through. My example below was only looking at the relationship from the
child table side. If you look at it from the parent table side and add
predicates - probably the more frequently used scenario - the problem
becomes c
[EMAIL PROTECTED] wrote:
Mladen Gogala wrote:
I believe that this would be the best solution:
DECLARE
RowCount NUMBER:= 0;
BEGIN
/* This will work if the RESOURCE table has the "parallel"
attribute set. In 8i, table needs to be partitioned as well */
EXECUTE IMMMEDIAT
> -Original Message-
> quriyat
>
> Can anyone enlighten me on the diff between
> ANALYZE TABLE COMPUTE STATISTICS
> --AND--
> analyze table my_emp compute statistics for table for all indexes
> for all indexed columns;
Time to dust off the old "check analyze options" SQL!
These
There is plenty of documentation on these commands which I suggest reading,
but to summarise obscenely...
These options can be used to analyze just certain elements whilst leaving
other statistics unchanged. If you rebuilt the indexes on a table you
might want to simply "analyze table blah for a
Hemant,
It is absolutely true with Oracle Financials Databases and I have seen
performance degradation when indexes on such databses are not rebuilt at a
regular interval meaning indexes on certain tables on mothly basis.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of
Title: RE: db version control - schemas, code
I
forgot to add to this message, I have requested permission
to
forward this presentation to
others.
Matt
Matt Adams - GE Appliances -
[EMAIL PROTECTED]We have enough youth.How about a fountain of
intelligence?
-Original Message--
I'll be in Paris. Have to receive my Oracle Magazine reward and admire
La Defense - or vice versa.
Mogens
Stephane Faroult wrote:
I have just received an e-mail from Tanel saying he had not had the time
to participate recently and enquiring about any list get-together at
Oracle World Paris. I w
Guiness Mean Time will not have effect on the time recorded in the
database, just how it is displayed.
On 10/16/2003 11:34:26 AM, David Wagoner wrote:
To support internationalization, we may need to change our server
time
zone
from US EST to GMT. What effect, if any, will this have on the
O
Title: RE: db version control - schemas, code
It's
on their website, and it does look excellent. Thanks for the
tip.
Anyone
ever use OEM Change Manager?
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Adams, Matthew (GECP, MABG,
088130)Sent
Mladen Gogala wrote:
>
> I believe that this would be the best solution:
> DECLARE
> RowCount NUMBER:= 0;
>
> BEGIN
> /* This will work if the RESOURCE table has the "parallel"
> attribute set. In 8i, table needs to be partitioned as well */
>
> EXECUTE IMMMEDIA
Do you have concrete numbers. It''s been a while that I did my tests for
the paper and I would have to dig out my old testcases, but I was left with
the impression that the join cardinality "formula" was derived from
parent-child relationship joins and that the cardinality estimates are OK
for
SF,
Thanks for update.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Thu, 16 Oct 2003 15:04:25 -0800
I have just received an e-mail from Tanel saying he had not had the time
to participate recently and enquiring about any list get-tog
Richard,
Quoting Metalink Note "182699.1" on
" bde_rebuild.sql -
Validates and
Rebuilds Fragmentated Indexes
(8.0-9.0)"
Index fragmentation occurs when a key value changes, and the index row is
deleted from one place (Leaf Block) and inserted into
another.
Deleted Leaf R
Hi Dennis
Congrats __ Keep the spirit flying
GovindanK
OCP-8,8i
Brainbench Certified Master 8 DBA
- Original Message -
To: "Multiple recipients of list ORACLE-L"
Sent: Thursday, October 16, 2003 12:24 PM
> I just passed the Net8 Administration OCP exam. This w
Hi List
Can anyone enlighten me on the diff between
ANALYZE TABLE COMPUTE STATISTICS
--AND--
analyze table my_emp compute statistics for table for all indexes
for all indexed columns;
TIA
___
No banners. No pop-ups. No kidding.
Introducing M
You are right. As you agreed our ultimate goal is user satisfaction and I
believe in that, may be a old habit. I came into computer area because of
our dissatisfaction(being enduser) with our IT shop otherwise professionaly
I used to be a qualified professional accountant playing with numbers.
We had a question recently on the list about RBO still physically being
there in 10g or not. I asked Graham Wood in Development, and here's his
reply:
==
RBO is still there.
De-supported means that if you find a bug, such as wrong results, in RBO
it will not be fixed,
At least I would then die with a broad smile on my face, knowing that
that version was delayed, too...
Pete Sharman wrote:
Sure, I've got an accurate rumour. Of course, I'd have to kill you if I
told you. Do you really want to know that much? :)
Pete
"Controlling developers is like herding ca
A fine response, Richard. Thank you.
One of the guys coding the index stuff was/is Jonathan Klein, and I
remember asking him some years ago about reuse of index blocks, and he -
at that point - said that he was pretty sure he put the reuse of leaf
blocks into 7.1, but that branch blocks didn't
Jared's suggestion improves performance but does not implement batch
commits. I think most people are trying to steer you away from batch
commits - for a good reason. Often people say "you have to commit every
1000 records" - where I work that exists as a standard even. I've fought
long and har
how about using tablespaces UMDOTBS (instead of UNDOTBS) and SYTSEM?
thanks for the laugh.
PdMladen Gogala <[EMAIL PROTECTED]> wrote:
This is because "ENABLE STORAGE IN ROW" is the default, which meansthat oracle will store the first 4000 bytes in the original block.The first part of a LOB is,
I forgot to include years of troubleshooting and debugging experience
the techniques to go with it.
:)
Jared
"Bob Metelsky" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/16/2003 01:24 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[
That's funny. When I tried it on Oracle 9.0.1.1.0 on SunOS there was no error.
When I tried it on Oracle 9.2.0.3.0 on SunOS the value assigned to po_out was an X
followed by two (2) spaces.
> -Original Message-
> Post, Ethan
>
> Seeing this on AIX 5.1 64 bit Oracle 9.2.0.1.0 with char
>
Congrates Dennis ,
Get set for 9i upgrade soon. 10g is on the way :)
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, October 16, 2003 12:24 PM
> I just passed the Net8 Administration OCP exam. This was my last exam, so
I
> suppos
Way to go Dennis!
DENNIS WILLIAMS <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/16/2003 12:24 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Passed Net8 OCP Exam
I just p
Embedded \0 on the assignment?
-Original Message-
Sent: Thursday, October 16, 2003 6:05 PM
To: Multiple recipients of list ORACLE-L
Seeing this on AIX 5.1 64 bit Oracle 9.2.0.1.0 with char datatypes. Anyone
aware of this issue?
CREATE TABLE CHAR_TEST
(
CHAR1 CHAR(1)
)
---
On OTN check for HA or High Availability for all sort of white papers on
dataguard. If you have metalink access then check for top tech doc option
and then see for dataguard..
HTH,
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Thu
Seeing this on AIX 5.1 64 bit Oracle 9.2.0.1.0 with char datatypes. Anyone
aware of this issue?
CREATE TABLE CHAR_TEST
(
CHAR1 CHAR(1)
)
--
CREATE OR REPLACE PROCEDURE TEST_CHAR (
po_
I have just received an e-mail from Tanel saying he had not had the time
to participate recently and enquiring about any list get-together at
Oracle World Paris. I won't attend OW myself but I'll happen to be in
the very same area, invoicing happily, on Monday, Wednesday and Thursday
till I leave t
Thanks for the info.
Too bad you can't get some metrics to show what was happening.
Yes, user satisfaction is the ultimate indicator of tuning success, but
there are also metrics to back it up, they just need to be collected
before and after.
Thanks,
Jared
"M Rafiq" <[EMAIL PROTECTED]
Well, some jobs (including snapshot refreshes) may get confused, and if
you create or alter objects I wonder how Oracle may handle dependencies
... Fortunately you are moving 5 hours ahead, rather than back, so risks
are probably quite limited.
--
Regards,
Stephane Faroult
Oriole Software
--
Pl
http://download-east.oracle.com/docs/html/A96673_01/toc.htm
On 10/16/2003 06:39:32 PM, Michael Kline wrote:
I'm at a new site right now and they have set up Standby environment
on 9i
Rel 2. The agent also is running on both the servers. They want to
use
the
GUI frontend of DataGuard and have OEM
So, what exactly is the difference between a grid and RAC/OPS?
The associations that I get when somebody mentions the word "grid"
are I-95 in Norwalk/Stamford area around 8:30 AM or LIE at the
approximately the same time. That can be used to demonstrate gridlock
computing.
On 10/16/2003 06:29:33 P
My bad. The SQL is not quite right: 'append' is a hint:
alter table resource nologging;
insert /*+ append */ into resource
select * from rqmt;
Read up on direct load insert in the concepts manual,
along with nologging.
Bypass the redo and undo - no need for commits.
Just back it up when fin
We have a 8.1.7.0 with the following from v$rollstat.
Extent size is 10M for all segments. Do you find
anything unusual with usn#3? I expect Rssize for to be
17G (1777*10M - extents*extent_size).
USNEXTENTS RSSIZE
-- --
0 11
I'm at a new site
right now and they have set up Standby environment on 9i Rel
2. The agent also is running on both the servers. They want to use the GUI
frontend of DataGuard and have OEM installed, but have not taken the final
steps of
setting up the Management Server to tie it all
toget
I think the assumption must be that all the computers on the grid are
attached to a SAN. Does that seem reasonable?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, October 16, 2003 5:04 PM
To: Multiple recipients of list ORACLE-L
For database ty
log into target database.
SQL> set long 32000 (or whatever if you have long datatype involved)
SQL> set arraysize 100
SQL> set copycommit 1000 <-- LOOKY!!
SQL> COPY FROM ${REMOTE_LOGIN}/[EMAIL PROTECTED] INSERT
${LOCAL_SCHEMA}.${THE_TABLE} USING ${QUERY};
In this case QUERY will probably be "s
Well, for which process do you want to see PGA? Go to the /proc/$PID
directory and look into the memory maps.
The other way of looking into
PGA would be interpreting process tables from /dev/kmem.
If you know how to do that, you can do something like
dd if=/dev/mem of=`tty`
On 10/16/2003 05:3
If your intention is to find the amount of memory used
by an Oracle Process at the OS level, use pmap command
in Solaris.
-Ravi.
--- Roger Xu <[EMAIL PROTECTED]> wrote:
> I can use "ipcs -am" to see the sga at os level. but
> I do not see any pga?
>
> Roger Xu
> Database Administrator
> Dr Peppe
Low end servers, usually running Linux, 1 or 2 CPU's, 2 Gb of memory, that
can easily be racked (or even RAC'ed).
Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not. It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
-Origi
For database type stuff, one must wonder how the data itself can be handled
by CPU resources scattered hither and yon. The answer comes from the fairly
recent knowledge that, in our universe, every particle has a matching
particle; and changing one of the particles results in a change in the other
This is because "ENABLE STORAGE IN ROW" is the default, which means
that oracle will store the first 4000 bytes in the original block.
The first part of a LOB is, essentially, identical to VARCHAR2(4000)
or VARRAW(4000). If you say something like
CREATE TABLE t
(
ISCT_ID NUMBER(10)
You are right. What I had in mind was to parse the information in a
nice way, but I didn't have the time.
On 10/16/2003 02:29:31 PM, [EMAIL PROTECTED] wrote:
I'm as much a Perl bigot as anyone Mladen, but really,
what's the point of rewriting grep?
grep -i HZ /var/log/syslog | head -1
Jared
Mercadante, Thomas F scribbled on the wall in glitter crayon:
> w-ho! now go have a beer!
i can only have a beer if i pass an OCP exam? Larry is getting WAYY to
involved in my personal life!;-)
--
Bill "Shrek" Thater ORACLE DBA
"I'm going to work my ticket if I can..." -
Peter,
First, are you sure it is hanging? It does take quite awhile to finish.
Secondly, did you up the Jave_Shared_Pool param to a decent value (I think
the migration doc says 4Meg, but increase it to 8 and try it again).
and finally, if you are not using Java in the database, it really is not
The grid is presently at version 1.0, and like any 1.0 release is fraught with
problems. One doesn't just install the grid, but installs several packages which have
interdependencies to the extent that upgrading one will almost certainly cause
failures somewhere else.
I digress...
A develope
I can use "ipcs -am" to see the sga at os level. but I do not see any pga?
Roger Xu
Database Administrator
Dr Pepper Bottling Company of Texas
(972)721-8337
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Roger Xu
INET: [EMAIL PROTECTED]
Fat City Network Services
Congrats Dennis - I guess easy is always relative and depends on experience. I would
venture that running Oracle with various applications on various platforms in various
organizations provides a wealth of experience - some you wish you never have - all
adding up to a pretty well-rounded backgr
Hot dog! Maybe my time has finally come!
http://itmanagement.earthweb.com/career/article.php/3092891
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Servi
w-ho! now go have a beer!
congrats!
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Thursday, October 16, 2003 3:24 PM
To: Multiple recipients of list ORACLE-L
I just passed the Net8 Administration OCP exam. This was my last exam, so I
suppose I am now a
so far so good with 64-bit 9204 on Solaris9
-Original Message-
Sent: Thursday, October 16, 2003 4:00 PM
To: Multiple recipients of list ORACLE-L
Hi,
I installed Oracle 9201 on Sun Solaris9 and it has been giving me lots of
trace files in udump directory. Checking with Metalink confirmed
Congratulations!!!
-Original Message-
Sent: Thursday, October 16, 2003 1:44 PM
To: Multiple recipients of list ORACLE-L
Congratulations Dennis!
On 10/16/2003 03:24:26 PM, DENNIS WILLIAMS wrote:
> I just passed the Net8 Administration OCP exam. This was my last
> exam,
> so I
> suppose
Congratulations, Dennis!
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
DENNIS WILLIAMS
Sent: Thursday, October 16, 2003 2:24 PM
To: Multiple recipients of list ORACLE-L
I just passed the Net8 Administration OCP exam. This was my last exam,
so I
suppose I am now an OCP for
Congrats Dennis! I know we have be at that for some time now
Way to go!
bob
Scott - My questions were distributed exactly as yours, maybe even the
same
questions, but it's all a blur now.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
[mailto:[EMAIL PRO
I know Oracle provides us dbms_lob package to manipulate LOB data. However,
I can use standard DML to manipulate CLOB data as following. Is there
advantage to use dbms_lob package?
SQL> CREATE TABLE t
2 (
3ISCT_ID NUMBER(10),
4CONTENT CLOB
5 );
Table cre
Hi,
I installed Oracle 9201 on Sun Solaris9 and it has been giving me lots of
trace files in udump directory. Checking with Metalink confirmed that it
was due to a oracle bug. Metalink says the bug is fixed in 9203. Now I
found the latest patchset is 9204 (out about one and half month ago). Has
an
A windows solution
for /f %d in (C:\yourfile.txt) do echo ,%d,>>C:\yourfilewithcomma.txt
bob
Hi List
I have 1000 lines in my data file. I want to add
'(comma) at the begining and end of each line.
For example,
abf
jd
djkhk
jd3
Shold be convrte
--- [EMAIL PROTECTED] wrote:
> That will work, slowly.
> You might like to try something like this
> insert into resource
> nologging
> select * from rqmt
> append;
How's that commiting every 1000 records?
> Read up on the 'append' and 'nologging' first.
???
>
>
>
>
>
>
>
> Maryann
Scott - My questions were distributed exactly as yours, maybe even the same
questions, but it's all a blur now.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 2:55 PM
To: Multiple recipients of list OR
It may take a while to run (1/2 hour), how long has it been running?
There are some issues with reloading java on an upgrade. I just went through
the same thing, but on AIX 4.3.3. I don't have the metalink note in front of
me, I will be able to pass it on tomrrow. Some things from memory ar
I don't know whether HP-UX has /proc/cpuinfo, but that is the
place where the information about CPU is recorded.
On 10/16/2003 02:29:31 PM, [EMAIL PROTECTED] wrote:
I'm as much a Perl bigot as anyone Mladen, but really,
what's the point of rewriting grep?
grep -i HZ /var/log/syslog | head -1
Jared
SQLPlus probably doesn't hangit take a long time to create or replace
JAVA on some systems.
-Original Message-
Sent: Thursday, October 16, 2003 3:14 PM
To: Multiple recipients of list ORACLE-L
Environment:
AIX 5.2
Oracle 8.1.7.4
I copied a database from an 8.1.7.0 environment and
Congratulations...
Make sure you put
TNS_SKILL_LEVEL=((CERT=$OCP)(PROTOCOL=$ORA_ED)(RENEW=$ANNUAL)) in your
sqlnet.ora file
-Original Message-
Sent: Thursday, October 16, 2003 2:24 PM
To: Multiple recipients of list ORACLE-L
I just passed the Net8 Administration OCP exam. This was m
TORA, OraC, sqlplus, vi, perl and a linux box to run it
on, though the
database
servers are mostly Win2k.
Software
$0.00
OS
$0.0
HW
$12k
A
procedure return with no errors
Priceless
FWIW for a nice sql editor golden is nice. Others on this
list sold me on that
Is there any way to get the CBO (8.1.7) to recognize parent/child
relationships? This seems to be an extreme example of the Join Independence
Assumption Fallacy (or I guess maybe the Predicate Independence Assumption)
discussed by Wolfgang Breitling in "Fallacies of the Cost Based Optimizer".
If I
Environment:
AIX 5.2
Oracle 8.1.7.4
I copied a database from an 8.1.7.0 environment and am going
through the procedure to migrate it to 8.1.7.4. My Oracle home has
already been patched.
When I get to step 10 in the procedure where it says:
SQL> create or replace java system
/
sqlplus hangs.
Assuming that we have duplicate rows ( NOT duplicate keys ), you may try this. I have
borrowed this from a friend of mine.
We have used it successfully. Each of the columns in the table are included as
predicates to confirm that we are deleting only the duplicate rows.
delete from noderelatedr
We just discussed this about a month ago.
3 basic solutions:
1. delete from table where rowid not in
(select max(rowid) from table group by col_1,col_2,etc);
sql only solution, not really feasible in huge environments
2. Alter table mytab enable constraint PK exceptions into exceptions;
Better
Title: RE: Passed Net8 OCP Exam
WooHoo! Congrats Dennis! So were the questions distributed the same as when I took it, or did they emphasize different areas? Just curious.
-Scott Stefick
-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October
Title: Message
FYI... Golden is a query tool (and a damn good one)... In my
opinion, it's what SQL Worksheet should be... Simple to use and
fast... The PL/SQL editor from Benthic is separate tool called
PLEdit... It's ok but not great... Like Golden it is quick and
simple... But, if y
Thanks, Melanie! I was already getting frustrated that nobody got the
joke. Though I am slowly melting into a Connecticut Yankee (I even
started cheering for the Yankees), my English is still such that people
usually think that it's just a bad spelling.
On 10/16/2003 02:44:25 PM, Melanie Caffr
Hi,
I am trying to remove the duplicate rows from a table with the column data..
I cannot use PK as it's just a sequence number...
I could find all the duplicate rows by grouping the column. but how can i
delete only the duplicate ones and retain the original dat
Of course, you all do realize that Arnold can't be president... right?
I've actually heard the talking heads talking about it like it's
possible
LOL
Ignoramouses!
RF
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 10/16/2003 1:29 PM
Check your Latin...that's "Gub
Congratulations Dennis!
On 10/16/2003 03:24:26 PM, DENNIS WILLIAMS wrote:
I just passed the Net8 Administration OCP exam. This was my last
exam,
so I
suppose I am now an OCP for Oracle8i.
Thanks to everyone for their helpful tips. Some people said (or
implied)
that this is a very easy exam. I
Congrats! Now... What will you do with your sig line
-Original Message-
Sent: Thursday, October 16, 2003 3:24 PM
To: Multiple recipients of list ORACLE-L
I just passed the Net8 Administration OCP exam. This was my last exam, so I
suppose I am now an OCP for Oracle8i.
Thanks to e
Title: Message
We do
something similar here.
Developers gets Golden (from Benthic). Which has a nice little PL/SQL
Editor and SQL spreadsheet.
DBAs
get TOAD.
Babette
Turner-Underwood work: [EMAIL PROTECTED] home: [EMAIL PROTECTED]
954-3752 (Mon - Fri 7am -
3pm)
-Original Message
I just passed the Net8 Administration OCP exam. This was my last exam, so I
suppose I am now an OCP for Oracle8i.
Thanks to everyone for their helpful tips. Some people said (or implied)
that this is a very easy exam. I would dispute that. I found it just like
the other exams, in that if you hav
I know this should really be on the OT list, but, I couldn't help
laughing at the below.
And all along, I thought Mladen's original comment was actually just a
clever amalgamation of "governor" and "terminator".
Whatever the original intent, it's still funny. :-)
-Original Message-
[EMA
There is a toll "schema manager " by quest . Have a look at that as well. I
haven't used it though.
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, October 16, 2003 10:24 AM
> Hi All,
>
> Client would like me to propose a solutio
Title: RE: db version control - schemas, code
there was an excellent presentation by Mark Stock at
SEOUC 2002 called
Tag! Whose Code is it?
about embedding versioning inside of Oracle objects.
I'm reluctant to send it without getting approval from
the copyright holder, but the authors e
Current issue of ComputerWorld has an article on Grid, but I enjoyed the fantastic
cartoon :)
- Kirti
--- Jared Still <[EMAIL PROTECTED]> wrote:
> Here's a recently curmudgeonly reply to a friend that
> asked the same question.
>
> -
>
> As for 10g itself: the 'g' stan
> ... As load increases, Oracle
> will spawn off work onto the other free servers somehow.
>
Looks like Oracle is finally "catching up" with what we've
been enjoying on Windoze, for quite a number of years now.
Only for some strange reason this very principle used to be
called "worm propagati
Check your Latin...that's "Gubernator"...
|How, in the world, did a man with such a poor taste in movies
|build such a huge company like Oracle Corp? No wonder that Arnie
|has become a guvernator of CA. BTW, has anyone here seen the
|"Demolition Man"? It's not an Arnie movie, but the scene with th
We had Sun's N1 architect here a few months ago to brief us on N1. ( grid)
In a nutshell, all of your servers go in a pool, the administrative software
doles out the resources as needed, simple as that.
Of course, it is not that simple. Very interesting stuff, though I think the current
buzz ab
I'm as much a Perl bigot as anyone Mladen, but really,
what's the point of rewriting grep?
grep -i HZ /var/log/syslog | head -1
Jared
Mladen Gogala <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/16/2003 07:59 AM
Please respond to ORACLE-L
To: Multiple recipie
I usually do
echo passwd | sqlplus -s [EMAIL PROTECTED]
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
That will work, slowly.
You might like to try something like this
insert into resource
nologging
select * from rqmt
append;
Read up on the 'append' and 'nologging' first.
Jared
Maryann Atkinson <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/16/2003 08:54 AM
Please respond to ORAC
OT list please
Mladen Gogala <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/16/2003 10:34 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Re: OT California
How, in the worl
List, anyone finished the exercises in cary's book ? or at least chapter 5 ?
. I tried www.oreilly.com/catalog/optoraclep.
Hey maybe I can get you guys to write my term paper too :) Professor Milsap
is a real stickler for assignments and will probably flunk me for copying.
But seriously,
Cary sa
There is a company called Merant (www.merant.com) which is a
maker of change management tool called PVCS. They have module
for Oracle, which can compare schemas as well as store fmb files.
As fo the methodology, company documentation is marked with "company
confidential", which means that I'm not a
I think it's more than that. I've got a meeting with the Oracle folks
tomorrow for an overview of other stuff, but he did mention that grid
computing is not like Oracle Failover.
It's more like you have a group of servers at your disposal. Oracle has
*not* been installed on these machines.
Yo
Ain't necessarily so. We already have some customers using grid technology
with 9iR2 and 9iAS, along with the toolkit that's available on OTN (whose
name escapes me at the moment). These are very high end business clients
(not government or academia) that the Advanced Technology Solutions group i
I run the following script, and the -S option solved the problem I had (I even had the line # out in the script and re-invoked it).
If the username/pw is on a separate line as shown below, the ps command does not display the userid/pw info.
# Set environment variables#!/bin/ksh
# Set local env
How, in the world, did a man with such a poor taste in movies
build such a huge company like Oracle Corp? No wonder that Arnie
has become a guvernator of CA. BTW, has anyone here seen the
"Demolition Man"? It's not an Arnie movie, but the scene with the
"Schwartzenegger presidential library" go
I believe that this would be the best solution:
DECLARE
RowCount NUMBER:= 0;
BEGIN
/* This will work if the RESOURCE table has the "parallel"
attribute set. In 8i, table needs to be partitioned as well */
EXECUTE IMMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';
SELE
yeah dont commit every 1000 records and do it in one shot. this is going to be much
slower.
why do you want to do it this way? Ive done 100m inserts with just an insert select
and one commit.
>
> From: Maryann Atkinson <[EMAIL PROTECTED]>
> Date: 2003/10/16 Thu AM 11:54:33 EDT
> To: Multiple
1 - 100 of 168 matches
Mail list logo