At 07:59 AM 1/15/2004, you wrote:
What else can I suggest to help them
collect data that will be informative?
My business card ;-)
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
List,
I have to be involved in a conference call this afternoon concerning a
client. They want advice on how to tune their Oracle database. It is a
claims/transaction processing system. It is 8i on Sun 8. The dba on their
system has only 6 months experience and no training. What advice can I
to be involved in a conference call this afternoon concerning a
client. They want advice on how to tune their Oracle database. It is a
claims/transaction processing system. It is 8i on Sun 8. The dba on their
system has only 6 months experience and no training. What advice can I give
them? They need
call this afternoon concerning a
client. They want advice on how to tune their Oracle database. It is a
claims/transaction processing system. It is 8i on Sun 8. The dba on their
system has only 6 months experience and no training. What advice can I give
them? They need a baseline to build
To hire a better DBA or enlist the help of the Hotsos Corp.
would be the most appropriate advice I can think of.
On 01/15/2004 09:59:25 AM, Ehresmann, David wrote:
List,
I have to be involved in a conference call this afternoon concerning a
client. They want advice on how to tune
a small
number of database people. this means less pure oracle jobs.
From: DENNIS WILLIAMS
Date: 2003/12/18 Thu PM 02:59:26 EST
To: Multiple recipients of list ORACLE-L
Subject: RE: RE: Career Advice
Ryan - Excellent points. I well know the feeling of being tied to Oracle's
future
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: RE: Career Advice
Viktor, Ryan - Is what you are experiencing the result of companies moving
to open-systems Web-based architectures?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent
t ORACLE-L Subject: RE: RE: Career Advice Ryan - Excellent points. I well know the feeling of being tied to Oracle's future. As to Oracle pricing itself out of the market, I would like tomake three points: - Pricing is one of the quickest things a vendor can change once it becomes convinced this
to learn Perl(looking forward to it actually!!!)
and Java. Books, web sites, docs - all these material is great. But what if
you're expected to learn fast and I can learn quickly, but still, do you
guys have some advice on how can one express teach himself.
Managing expectation is one thing I
The question is where do you want to go today?
Actually, the question is, Where do you want to go tomorrow?
Consult the crystal ball when it comes to career planning. Fixing VCR's
may match one's skill set but such service won't be needed much when
robots can stamp out new R/W DVD's for $10 a
- all these material is
great. But what if you're expected to learn fast and I can learn
quickly, but still, do you guys have some advice on how can one
express teach himself.
Managing expectation is one thing I need to talk with boss about. Surely
I would not't want to be overwhelmed
DENNIS WILLIAMS scribbled on the wall in glitter crayon:
Saira
I think you have to decide what your goal is. Then you need to
decide how to best accomplish that goal. One tool that can lead you
toward a goal is self-study. I have used that tool many times myself.
However, with
.
From: Thater, William [EMAIL PROTECTED]
Date: 2003/12/18 Thu PM 01:44:37 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Career Advice
DENNIS WILLIAMS scribbled on the wall in glitter crayon:
Saira
I think you have to decide what your goal
to switch since people want experience in the
specific skillset before hiring you.
From: Thater, William [EMAIL PROTECTED]
Date: 2003/12/18 Thu PM 01:44:37 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Career Advice
DENNIS WILLIAMS scribbled on the wall
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: RE: Career Advice
Ryan - Excellent points. I well know the feeling of being tied to Oracle's
future. As to Oracle pricing itself out of the market, I would like to make
three points:
- Pricing is one of the quickest
, that's what you
need to keep doing.
Now that I've been in the field for 25+ years, the best career advice I can
give is to stay on top of current trends and be willing to gain competencies
as various technologies wax and ditch areas - even of strength - as they
wane. The other piece of advice I can
ly a small number of database people. this means less pure oracle jobs. From: DENNIS WILLIAMS <[EMAIL PROTECTED]> Date: 2003/12/18 Thu PM 02:59:26 EST To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: RE: Career Advice Ryan - Excellent points. I well know the
have only a small number of database people. this means less pure oracle jobs. From: DENNIS WILLIAMS <[EMAIL PROTECTED]> Date: 2003/12/18 Thu PM 02:59:26 EST To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: RE: Career Advice Ryan - Excellent points. I well know the
As an applications analyst/junior dba, I feel I need to learn more but
I'm not sure of the direction I should take, so I'm asking for advice.
Should I become interested in Oracle Apps? Or should I learn another
suite like SAP or Siebel or PeopleSoft? The difficulty is that my
company does not use
recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Career Advice
As an applications analyst/junior dba, I feel I need to learn more but
I'm not sure of the direction I should take, so I'm asking for advice.
Should I become interested in Oracle Apps? Or should I learn another
suite
/junior dba, I feel I need to learn more but
I'm not sure of the direction I should take, so I'm asking for advice.
Should I become interested in Oracle Apps? Or should I learn another
suite like SAP or Siebel or PeopleSoft? The difficulty is that my
company does not use any of these. We use
Subject: Re: Career Advice
Your enthusiasm is admirable, but I think that it would
be extremely
difficult
for you to learn any of these packages without actually being
in
an environment where they are used.
It
may be that Tecsys is a complex set of apps on the same level
as
SAP or Oracle Apps
-Mendelin
Sent: Wednesday, December 17, 2003 11:44 AM
To: Multiple recipients of list ORACLE-L
As an applications analyst/junior dba, I feel I need to learn more but
I'm not sure of the direction I should take, so I'm asking for advice.
Should I become interested in Oracle Apps? Or should I learn another
Wow... as talented and knowledgeable as you are, you are one really
bored DBA. You must work alone, or be self-employed.
Or maybe you are trying to tell me to read between the lines...
In any case, I won't get into a silly argument with you.
Thanks for your advice,
Saira
-Original Message
Mladen Gogala scribbled on the wall in glitter crayon:
Have you ever considered a career in country music? Try getting
Stand By your man just right and the rest will come. You have to
learn both kinds of music, country and western. May Jake and Elwood
be with you.
son, that there was
]
Date: 2003/12/17 Wed PM 01:49:25 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Career Advice
Have you ever considered a career in country music? Try getting Stand By your man
just right and the rest will come. You have to learn both kinds of music, country
question you asked
Allan
-Original Message-
Saira Somani-Mendelin
Sent: Wednesday, December 17, 2003 11:44 AM
To: Multiple recipients of list ORACLE-L
As an applications analyst/junior dba, I feel I need to learn more but
I'm not sure of the direction I should take, so I'm asking for advice
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
On Behalf Of [EMAIL PROTECTED]
Sent: December 17, 2003 1:09 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Career Advice
Your enthusiasm is admirable, but I think that it
would be extremely
difficult for you
-
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, December 17, 2003 1:09
PM
Subject: Re: Career Advice
Your enthusiasm is admirable,
but I think that it would be extremely difficult for you to learn any of these packages without actually
, no?
Thanks,
Saira
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of eric king
Sent: December 17, 2003 1:55 PM
To: Multiple recipients of list
ORACLE-L
Subject: Re: Career Advice
That right, packaged software like
SAP and PeopleSoftware should
(cool
stuff)
and I made oracle database just one among my skills. I'm quickly honing skills of a
standup
comedian, too. Please, do not misunderestimate me.
My career advice to you is: do whatever sells.
--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
but
I'm not sure of the direction I should take, so I'm asking for advice.
Should I become interested in Oracle Apps? Or should I learn another
suite like SAP or Siebel or PeopleSoft? The difficulty is that my
company does not use any of these. We use a smaller package by Tecsys
called Elite
Message-From: Saira Somani-Mendelin
[mailto:[EMAIL PROTECTED]Sent: Wednesday, December 17, 2003
1:24 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: Career Advice
Is it that difficult
though? Just to get familiar with it if youve worked with other similar
software
their documentation or
their advice even (as you point out). They ported their application from
Informix to Oracle, so we are experiencing the pains they never had to
in their pre-release days. But luckily, I am somewhat in control of how
the applications are implemented and enhanced.
I like the fact
My career advice to you is: do whatever sells.
Even if it is wearing a sandwich board that says, Hot Large Pizza Now
$5.00
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Odland, Brad
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http
Large pizza for $5 Where?
On 12/17/2003 03:14:43 PM, Odland, Brad wrote:
My career advice to you is: do whatever sells.
Even if it is wearing a sandwich board that says, Hot Large Pizza Now
$5.00
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author
that do the work. Interview them to
find what skills and experiences are required and how you would acquire
those skills and experiences. Ask what their career path was as an example.
Many career advice books describe how to secure and conduct informational
interviews. In a way, that is what you
/17/2003 03:14:43 PM, Odland, Brad wrote:
My career advice to you is: do whatever sells.
Even if it is wearing a sandwich board that says, Hot Large Pizza Now
$5.00
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Odland, Brad
INET: [EMAIL PROTECTED
Little Caesars. $5 CDN (Seriously).
-Original Message-
Mladen Gogala
Sent: December 17, 2003 3:29 PM
To: Multiple recipients of list ORACLE-L
Large pizza for $5 Where?
On 12/17/2003 03:14:43 PM, Odland, Brad wrote:
My career advice to you is: do whatever sells.
Even
)
and I made oracle database just one among my skills. I'm quickly honing
skills of a standup
comedian, too. Please, do not misunderestimate me.
My career advice to you is: do whatever sells.
--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author
, carry-out only.
-Original Message-
Sent: Wednesday, December 17, 2003 3:29 PM
To: Multiple recipients of list ORACLE-L
Large pizza for $5 Where?
On 12/17/2003 03:14:43 PM, Odland, Brad wrote:
My career advice to you is: do whatever sells.
Even if it is wearing
On 12/17/2003 03:44:34 PM, Saira Somani-Mendelin wrote:
Well, good, now that we have that cleared up. Don't get me wrong, I do
like your keen sense of humour and sarcasm - when I know you're joking
and at times its hard to tell.
Dennis has a point. The question is where do you want to go
]
[mailto:[EMAIL PROTECTED] On Behalf Of Odland,
Brad
Sent: December 17, 2003 3:14 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Career Advice
If you
need specifics for a home learning environment setting up Oracle 8.1.7.4 on a Gentoo
linux box at home is a great learning exersize
, carry-out only.
-Original Message-
Sent: Wednesday, December 17, 2003 3:29 PM
To: Multiple recipients of list ORACLE-L
Large pizza for $5 Where?
On 12/17/2003 03:14:43 PM, Odland, Brad wrote:
My career advice to you is: do whatever sells.
Even if it is wearing
to or hires people that do the work. Interview them
to
find what skills and experiences are required and how you would acquire
those skills and experiences. Ask what their career path was as an
example.
Many career advice books describe how to secure and conduct
informational
interviews. In a way
: Career Advice
Have you ever considered a career in country music? Try getting Stand By your man
just right and the rest will come. You have to learn both kinds of music, country
and western. May Jake and Elwood be with you.
On 12/17/2003 12:44:28 PM, Saira Somani-Mendelin wrote
Wednesday, December 17, 2003, 4:24:50 PM, Bobak, Mark ([EMAIL PROTECTED]) wrote:
BM I'm work in Ann Arbor, the place I'm refering to is in Belleville, which is
between Detroit
BM and AA.
Hey, I know Belleville, sort of. Back when I as a kid, my
dad used to deliver potato chips to some Belleville
if you're expected to learn fast and I can learn quickly, but still, do you guys have some advice on how can one "express" teach himself.
Managing expectation is one thing I need to talk with boss about. Surely I would not't want to be overwhelmed with stuff at the beginning. But at the same
04:24 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: Career Advice
Let's take this topic into a more concrete scenario. New boss, company reorg, cross-training is enforced and now DBA'S's are going to be split
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, 18 December 2003 11:34
To: Multiple recipients of list ORACLE-L
Subject: Re: Career Advice
Perl: Since you're working with Oracle, if you were to buy only one book, you might
consider:
http
to it actually!!!)
and Java. Books, web sites, docs - all these material is great. But what if
you're expected to learn fast and I can learn quickly, but still, do you
guys have some advice on how can one express teach himself.
Managing expectation is one thing I need to talk with boss about. Surely I
would
forward to it actually!!!)and Java. Books, web sites, docs - all these material is great. But what ifyou're expected to learn fast and I can learn quickly, but still, do youguys have some advice on how can one "express" teach himself.Managing expectation is one thing I need to talk with
those problems come from bad application or
bugs
anyway...
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday, July 26, 2003 12:59 AM
Hello list I needed your advice on the following :
1. What value do you all specify
Hello list I needed your advice on the following :
1. What value do you all specify in
DBMS_SHARED_POOL.ABORTED_REQUEST_THRESHOLD
( value ) ?
(1.a.) Should it be set equal to the shared_pool_size ?
(1.b.) Should it be greater than shared_pool_size ?
(But wouldn't that be impossible. The free
ORACLE-L [EMAIL PROTECTED]
Sent: Saturday, July 26, 2003 12:59 AM
Hello list I needed your advice on the following :
1. What value do you all specify in
DBMS_SHARED_POOL.ABORTED_REQUEST_THRESHOLD
( value ) ?
(1.a.) Should it be set equal to the shared_pool_size ?
(1.b.) Should it be greater
that sid1 will not influence the performance of sid2=
=2E
Sid1 will be production, sid2 will be a test environment.=0D
Is this setup possible with RAID 5 ??=0D
=0D
Can somebody advice me ?=0D
=0D
Rgds,=0D
=0D
Patrick Van der Sande=0D
Managing Director =0D
ANDES Consulting BVBA=0D
email : [EMAIL
Hello list , I am planning to appear for my Oracle 9i database
fundamentals II exam ( 1z0-032 ) on the 7th .
I would be grateful for any advice , pointers ,etc. Bit nervous cause
it looks tougher than 1z0-031 ( dba fundamentals 1 )
thanks
...
--
Please see the official ORACLE-L FAQ: http
On behalf of Lee Robertson
Please include his address ([EMAIL PROTECTED]) in reply
-Original Message-
Sent: Friday, June 06, 2003 12:36 PM
To: [EMAIL PROTECTED]
We have a potential new client coming up who requires a 500Gb
database, a mix of OLTP and batch work, about 400 users of
- Forwarded by Jared Still/Radisys_Corporation/US on 06/06/2003 09:09
AM -
Jared Still
06/06/2003 08:58 AM
To: [EMAIL PROTECTED]
cc: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject:Re: Erm sorry but I need some advice (Hardware question
Beth,
Since your archiving process involves many tables, I think the best approach
for you would be as follows:
Create a work table that will hold the primary key value for the master
table.
the first step of your process would involve selecting the records to be
archived from the master table,
Thanks Tom, this is an excellent solution!
I used to do something similar when I worked with SQL Server, because it's
good to avoid cursors with SQL Server, but I didn't think of it this time.
Thanks again all,
Beth
-Original Message-
Thomas F
Sent: Thursday, January 30, 2003 6:44 AM
Robert,
Thanks for point that out. Also, if there is index on the table,
redo will still be generated for index.
Richard
-Original Message-
Sent: Tuesday, January 28, 2003 10:54 PM
To: Multiple recipients of list ORACLE-L
/*+ append */ alone does not prevent redo generation. Only
Thanks all, this is helpful information for my boss, who wants to schedule a
procedure to bulk copy data between tables on a regular basis.
For my own problem, I should have been more specific in my example, but I
was thinking more about my boss' issue than my own. (What a great employee
I am!)
Hi all,
Please forgive this newbie question; I'm just getting started with PL/SQL.
I want to write a procedure to copy all rows from one table to another one
with an identical structure. The table has many rows so I'm committing
every thousand records (error handling to be added later). The
If it's a lot of rows and looks like you are archiving it to
a historical table, you could do:
insert /*+ append */ into target_table select * from source_table;
this will do a direct path insert, so it uses space above HWM.
It doesn't generate redo.
Richard
-Original Message-
Sent:
/*+ append */ alone does not prevent redo generation. Only with NOLOGGING in
the SQL
will redo generation be suppressed.
Cheers!
RF
-Original Message-
Sent: Tuesday, January 28, 2003 6:29 PM
To: Multiple recipients of list ORACLE-L
If it's a lot of rows and looks like you are
and one for reporting.
I would like to hear any expert advice regarding the implemention and its pros/cons.
Your help will be highly appreciated. I will summarize.
Thanks,
Michale
**
This e-mail contains privileged attorney
for transaction and one for
reporting.
I would like to hear any expert advice regarding the implemention and its
pros/cons.
Your help will be highly appreciated. I will summarize.
Thanks,
Michale
**
This e-mail contains
Title: RE: expert advice for separation of production from report databa
You didn't say if you are looking at a separate box for your reporting db.
Push for separate hardware, or else you won't be solving your problem.
Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
5259
their
own IT professionals?
Miller, Jay
JayMiller To:
Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
@TDWaterhousecc:
.comSubject:
RE: Advice needed
Theoretically, if the activity of the database doesn't involve too much
disk writing, and the cache is large enough, etc., etc., you can use
parity. When disk drives cost a lot of money, there was some justification
for it. Now that drives are cheap, there really is no justification. To
[EMAIL PROTECTED]
cc:
Subject:Advice needed on move to Sun 15K (losing spindles)
Our CIO has suggested that we get a Sun 15K to house all of our
databases. This has some advantages (communication between the various
boxes would be much faster) but I have some
partitioning to retain this functionality.
Jared
Miller, Jay [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/09/2002 11:53 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Advice needed on move to Sun
JayMiller To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
@TDWaterhousecc:
.comSubject: RE: Advice
JayMiller To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
@TDWaterhousecc:
.comSubject: RE: Advice needed on
move to Sun 15K (losing spindles)
Sent by: root
ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Advice needed on move to Sun 15K (losing spindles)
Our CIO has suggested that we get a Sun 15K to house all of our
databases. This has some advantages (communication between the various
boxes would be much faster) but I have some
I've cussed and discussed the topic of one big stripe versus multiple small
stripes with different people and have yet to come across anyone who has
conducted a real test of various scenarios. If you stripe across all disks,
then you have the advantage of guaranteed, perfectly balance I/O --
partitioning to retain this functionality.
Jared
Miller, Jay [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/09/2002 11:53 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Advice needed on move to Sun
Title: RE: Advice needed on move to Sun 15K (losing spindles)
Lets say a guy only has one finger on each hand to tie his
shoe (mirroring). If he had five fingers (striping) he can
accomplish the job quite a bit faster. Now give him 1000
shoes to tie and listen to him bitch about how he could
respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Advice needed on move to Sun 15K (losing spindles)
Our CIO has suggested that we get a Sun 15K to house all of our
databases. This has some advantages (communication
partitioning to retain this functionality.
Jared
Miller, Jay [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/09/2002 11:53 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:Advice needed on move to Sun
PROTECTED]
Sent by: [EMAIL PROTECTED]
10/09/2002 11:53 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Advice needed on move to Sun 15K (losing spindles)
Our CIO has suggested that we get a Sun 15K
, investigate server
partitioning to retain this functionality.
Jared
Miller, Jay [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/09/2002 11:53 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Advice needed
One thing that should be made clear: Never, ever, stripe with parity (i.e.
RAID 5, etc.) unless you are force, at gunpoint, to do it. That is BAD.
Your database will run faster on an abacus ... well ... maybe a slide rule.
-Original Message-
Yes, it's entirely separate CPUs and
]
Sent by: [EMAIL PROTECTED]
10/09/2002 11:53 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:Advice needed on move to Sun 15K (losing
spindles)
Our CIO has suggested that we get a Sun 15K to house all
Fortunately my SA believes that so we were able to present a united front at
the presentation (and yes, the Sun rep said that with a large enough cache
RAID 5 works just as well as 1+0 - which is what we would be using).
Jay Miller
-Original Message-
Sent: Friday, October 11, 2002 4:54
to retain this functionality.
Jared
Miller, Jay [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/09/2002 11:53 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:Advice needed on move to Sun 15K
Our CIO has suggested that we get a Sun 15K to house all of our
databases. This has some advantages (communication between the various
boxes would be much faster) but I have some performance concerns.
Specifically, our main OLTP database would go down from 18 spindles to 8
spindles.
Jay - I share your concerns. Can you elaborate more on how heavily loaded
the system is? Is it somewhat I/O bound? Basically you're saying that it
would have a single RAID0 set? If you divided the disks differently to
create 2 or 4 RAID sets, would there be enough room for your application?
I've
This one is so easy that even a high school student could answer it. Use
the theory of constraints (book called The Goal) to this one.
When you reduce the number of resources to process a job, sequentially or
concurrently, you induce bottlenecks within the process. Thus, by reducing
the number
Jay,
You will hit performance problems because of not having I/O bandwidth.
Databases don't need storage, they need IO operations. Two important
pieces of info that are missing from your post:
- How many databases in total are going to run on this Sun 15K ?
- How many concurrent users on all
by: [EMAIL PROTECTED]
10/09/2002 11:53 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Advice needed on move to Sun 15K (losing spindles)
Our CIO has suggested that we get a Sun 15K to house all of our
I bet you Sun rep , while trying to unload some hardware on you,
has never heard of the term Logical I/O.Many times when upgrading,
one can make things worse , not better. If you are having performance
problems, then zero in on what those could be and fix it there. Take
some snapshots,
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: Advice needed on move to Sun 15K (losing spindles)
Jay,
You will hit performance problems because of not having I/O bandwidth.
Databases don't need storage, they need IO operations. Two important
Stephen hit it right on the head !!
Buy your CEO a copy of 'The Goal' ! It will be very useful in this and all
future for such 'adventures'.
How big is this Cache?
And how big are all the databases that will be running on this big server?
If database size is cache, then cash goes to the
Folks,
Since good old MetaSh t is once again having problems, as well as the help
line I need to know if any of you have run into the following before:
PENGUIN:8.1:SYS alter package utl_tcp compile body;
alter package utl_tcp compile body
*
ERROR at line 1:
ORA-06544: PL/SQL: internal
I recently moved from one server to another and found that many of the
system object where invalid. I reran catalog.sql and catproc.sql and this
corrected the problems for me... give that a try.
Melanie
-Original Message-
Sent: Tuesday, July 02, 2002 1:05 PM
To: Multiple recipients of
Raj,
Thanks for the help, but in this case I need to first wash a little egg off
of my face. The problem here was at least was easily recoverable. What had
happen was we moved a database instance from one machine to another. It's
cheaper to run two instances on one box that pay Oracle for
Trigger Writing Advice
I was just wondering if you knew that you can
use DBMS_OUTPUT in a trigger
Surprisingly, the answer is yes. Have you tried it?
Jared
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services
-L
Subject:RE: Advance Oracle
Trigger Writing Advice
Hi Chris,
Thanks,
But unfortunately I only
can see the error when the
record is inserted using a third party replication
product. Even then, if I
restart
1 - 100 of 169 matches
Mail list logo