$2.50 is simply because of the $ to Rupee PARITY RATIO & respective Cost of Living
here in India.
Labor in India is NOT Cheap . It is Simply this ratio which gives the impression of
being cheap.
Also Outsourcers get to pay LESS because of the Current prevailing Work-to-Earnings
monetary scen
Yes, in your experience...and maybe most of the other lister's
experience...majority of the time its true...
That's because you people are the best DBAs I've seen...
Your experiences...10...15 years...some of you have a little over 3 years and are
already experts...
Of course a lot of other people
Thanx Govind.
as Robert said, it has a dedicated chapter for that.
...and i'm trying all the scenarios one by one with his book beside.
but just thought, i could some more inputs from the LIST.
I will continue with the book now.
Regards,
Jp.
--
Please see the official ORACLE-L FAQ: http://www
Thanx Dennis,Robert,and Ruth.
I'm going thro' Roberts's book now.
as Robert said, it has a dedicated chapter for that.
...and i'm trying all the scenarios one by one .
but just thought, i could some more inputs from you Gurus.
thanx a lot guys.
I will continue with the book.
Regards,
Jp.
--
Take a look at the Metalink Note:125149.1
ALERT: ONLINE Index Rebuild or IOT Table Move can Produce Corrupt Index
As per the note it affects 8.1.(5/6/7).x
It has the relevant info.
Also take a look at the Docid: 287936.999.
HTH
GovindanK
> Sun solaris 8/oracle 8.1.7.2 64bit.
>
> After some dat
When you get wait seconds > 0 use TKPROF and look for statements taking
time.
HTH
GovindanK
>
> "Ehresmann, David" wrote:
>
>> System-wide Wait Analysis
>> for current wait events
>>
>>
Besides you may refer to Backup & Recovery by Rama Velpuri (8/8i). A bit
old but nevertheless good. All said and done, create a clone database
and keep crashing it in all ways you can think of, and try to recover it.
That should give you the confidence , letting you know how oracle handles
the inte
Or Perl...
On Thu, 2003-09-04 at 14:54, Richard Ji wrote:
> >so my question is, are there things you can do with external procedures that you
> >cant do with java?
>
> Yes there are, for instance, Java doesn't support raw socket, so if you ever need
> that
> you will have to do it in C with ex
The number of waits is irrelevant. What matters is the time waited which in
your case shows 0, but I assume that is because you have not set
timed_statistics to true. Without that the data from v$system_event are
worthless. Cary will probably step in here and tell you that even with
timed_stati
David,
Do you have timed_statistics set to true? If not, you need to do so. Although I
am pretty certain that this is the case, but let's assume that you truly waited
0 seconds. If you were able to remove ALL of the latch free events, you would
improve the response time in the system by 0 seconds.
System-wide Wait Analysis
for current wait events
Average
Event Total SecondsTotal Wait
Name
Did you explain plan? I suspect FTS taking place in case of NOT EXISTS.
It must be using Range scan for the non partitioned table.
Can you confirm / post the explain plan.
GovindanK
> Here the informations :
> table HREL_FUSION :
> 63 millions rows
> 3 indexes on columns : nodos_or,
Sun solaris 8/oracle 8.1.7.2 64bit.
After some database defrag(via alter table xxx move and alter index xxx rebuild), I
got 600-25012 from my delete session and alert file.
SQL> DELETE FROM EOI_PDTLIST WHERE ROWNUM=1;
DELETE FROM EOI_PDTLIST WHERE ROWNUM=1
*
ERROR at line 1:
ORA-
>so my question is, are there things you can do with external procedures that you cant
>do with java?
Yes there are, for instance, Java doesn't support raw socket, so if you ever need that
you will have to do it in C with external procedure. But what's the chance of anyone
is going to use such
The Exam Cram books are harder and harder to find, but used ones are still
available. However, I believe that Pete is going to co-author my upcomming
Mastering Oracle10g book from Sybex So, if you liked his style, stay
tuned.
RF
-Original Message-
To: Multiple recipients of list ORACL
sure...will be glad to learn somethings from your experiences
Murali.
"Niall Litchfield"
Two questions to anyone that has worked with compressed tables.
1. Have any work arounds been discovered to alter tables and say add
columns after a partition has been compressed and then uncompressed?
2. In looking at a block dump of a compressed 9.2 block you can see the
following pieces of i
I don't believe that you can be an owner of a consultant. This practice
was stopped, I believe, in 1865, in the Appomatox courthouse.
Virgil Caine is my name and I drove on the Danville train
'til so much cavalry came and tore up the tracks again
In the winter of '65, we were hungry, just
Title: Message
Yes,
very much.
Allan
-Original Message-From: Niall Litchfield
[mailto:[EMAIL PROTECTED] Sent: Thursday, September
04, 2003 3:45 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Oracle on Win2000
If a
list of "stupid things I have done or found
PC: Dell 8200
OS: XP Prof. SP1
I have had this PC with Norton 2002 virus
software on it since I bought it over a year ago. I recently decided to
upgrade to Internet Security 2003 Prof. Ed. Installation has been a
mess. Has anyone attempted to install this on XP Prof.? If so have
you h
Title: Can't query through a synonym, the solution
Hi List
Well, we figured it out. Here was the sequence of events
T1 - init ora parameter dblink_encrypt_login set to true in the target database
T2 - synonym created
T3 - init ora parameter dblink_encrypt_login set to false in the targ
YOur network guys may have turned off access to ports 1521 or 1575 if you
are using onames to stop the spread of the worm.
I used to DBA 30 some instances on several windows boxes. Both NT and 2k.
Pretty much made a point of rebooting at least once a week. Did cold backups
so database was down a
Here's a little more info. This is from a lady I work with
"Hey I found out a little bit of info on the masters certification.
My dad is the author/architect of the test. He did not assign the scoring
it sounded like it was an outside organization that came up with the
scoring. Anyway he
Jesse wrote
> Put down the Bud Light and drink a REAL beer like Three
> Floyds Alpha King, Sierra Nevada Pale Ale, Guinness, or Goose
> Island Honkers Ale.
>
> There's gotta be an "Oracle" hook here somehere...Drink REAL
> beer at OracleWorld!
Real Ale Clusters...
Flashback Query - you know t
Title: RE: test
-Original Message-From: Stefick Ronald S Contr
ESC/HRIDD [mailto:[EMAIL PROTECTED]Sent: Thursday,
September 04, 2003 2:50 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: test
No Bill, it's a POP "test" That's even
worse. [Shrek]
is
that
Title: Message
don't
always=doesn't ever - you need a tns connection.
Niall
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Smith, Ron L.Sent: 03 September 2003 22:39To:
Multiple recipients of list ORACLE-LSubject: RE: Oracle on
Win2
Title: Message
If a
list of "stupid things I have done or found with Oracle on windows" were to be
written would folk be interested
Niall
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bala
RegupathySent: 03 September 2003 18:44To: Multip
Noons writes
> For an "application DBA"? Exactly which part of the degree
> or OCP prepares or qualifies one for such a job
> specification? Matter of fact, where is "application DBA"
> defined in Oracle education or any other IT education
> organization? Which courses from Oracle prepare on
The last National Geographic talks about slavery, it's running rampant.
Jared this is getting into OT !!!
Patrice.
-Original Message-
Sent: Thursday, September 04, 2003 5:00 PM
To: Multiple recipients of list ORACLE-L
I don't believe that you can be an owner of a consultant. This pract
Still out there on Amazon, even though I don't get any royalties from it
any more (since the publisher went under). It's also available for
online purchase chapter by chapter (I think) on http://www.robonerd.com
Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handboo
run catblock.sql to create dba_blockers and dba_waiters
@?\rdbms\admin\catblock.sql
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, August 29, 2003 01:54
> dba_blockers
>
> this doesnt install by default. i cant remember which script runs
I too have mine setup to take a snapshot every 15 minutes.
Can you teach me how to automate purges using sppurge.sql ?
Thanks
.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, August 29, 2003 06:04
> Start by installing and config
You're becoming a lawyer too? C'ya in court.
--
Mladen Gogala
Oracle DBA
-Original Message-
Rachel Carmichael
Sent: Thursday, September 04, 2003 3:04 PM
To: Multiple recipients of list ORACLE-L
You keep putting me into a class in which I do not belong -- but I thank
you.
I have OCP
Everyone:
In looking at this survey, this can be used for multiple purposes. One is
to pulse the market, however question one can be used for license
violations. Be careful how you answer.
Thank You
Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (313) 227-4350
M
Many thanks Louis for your input,
Have nice day,
Kader
--- Jose Luis Delgado <[EMAIL PROTECTED]>
wrote:
> Hi Kader...
>
> you do not need to do the same on the standby
> database...
>
> That logical changes are reflected automatically...
> The only thing is that your physical datafile remain
My Oracle9i RMAN Backup and Recovery book from Oracle Press has a chapter
devoted to case studies and RMAN.
RF
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 9/4/2003 11:44 AM
Look at the Backup and Recovery Doc's. And there are sample scripts in
OH/rdbms/demo/case1.r
The Rocky Mountain Oracle User Group needs YOU! We are looking
for a few (well, more than a few) good speakers for our annual
Training Days conference to be held in Denver, Colorado on
February 11 & 12, 2004. This is your chance to share your
knowledge and experience with fellow Oracle professional
Mladen Gogala scribbled on the wall in glitter crayon:
> Well, being 6'4", 270 LBS, capable of running 5 miles and doing 20
> pull ups, I wonder why do people get upset if I become truculent or
> belligerent. BTW, your nickname is "Shrek". Mine is "Yogi". Both
> nicknames suggest certain size
> a
well tom kyte isnt certified and refuses to discuss it on his website. OCP is
important for most people. Employers want it.
Im not sure masters certification means much unless you are a principal consultant or
owner of a consultant. You then use that certification to sell your company. Its the
Joe,
It's all about dollars and cents, true. In your view, can a company look
past the next quarter and see that by outsourcing they might be jumping over
dollars to save pennies?
Example, most of the companies in my region aren't Fortune 500, they're
small manufacturing outfits - it's rare to s
Well, being 6'4", 270 LBS, capable of running 5 miles and doing 20 pull ups,
I wonder why do people get upset if I become truculent or belligerent. BTW,
your nickname is "Shrek". Mine is "Yogi". Both nicknames suggest certain
size
and physical build. Am I right?
--
Mladen Gogala
Oracle DBA
--
When working at International Air Transport Association (IATA), the company
moved around 60 jobs from Geneva and London to Montreal because it was
cheaper here.
This is all business as usual.
Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardl
You keep putting me into a class in which I do not belong -- but I
thank you.
I have OCP through 8i, but only because I made it a point of honor to
see if I could pass the exams without ever studying for them, and, in
the case of the 8 and 8i certification, without ever having seen a
database runn
This is all very funny and interesting. Anybody read the story in
yesterday's NY times? Mexica has a concern that their textile industry is
being "stolen" by China because it is cheaper to make products there than in
Mexico.
Sound familiar?
"This is the business we have chosen to be into" Himen
I was just looking into this. If I understand it correctly, you have to
take 2 'advanced' classes =>$2000-$5000 total (depending on which courses)
and then you have to pay $2000 just to take the practicum. This might be
the real deal and an exciting achievement to work towards but I for one know
Mladen Gogala scribbled on the wall in glitter crayon:
> non-aggressive gentleman from India. Lawyers do need a killer
> instinct, DBAs do
> not. For those of us who have it, it's more of a hindrance then a
> useful tool.
you, sir, have obviously not been a DBA in some of the companies i've work
if your on a 1099 the classes should be a business expense. dont know about the
certification. so you could write off the classes. will only save people 25-28%
though...
>
> From: April Wells <[EMAIL PROTECTED]>
> Date: 2003/09/04 Thu PM 12:24:35 EDT
> To: Multiple recipients of list ORACLE-L <
Title: RE: Oracle Masters exam
see... that's when I got my OCP... when the company decided that I needed
to have it, and that they would pay for it. All it proves to me is that I
can pass multiple choice tests... and I can read a book.
April Wells Oracle DBA/Oracle Apps DBA Corporate System
Title: RE: test
No Bill, it's a POP "test"
That's even worse.
-Original Message-
From: Thater, William [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 04, 2003 12:50 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: test
Babette Turner-Underwood scribbled on the
Well, I've had the luxury of not only not paying for any of the
certification, but actually being paid to DO the certification:
7.3 - original certification as an Oracle instructor paid for by Oracle
8.0 - paid for by the now defunct Coriolis Group so I could review their
exam crams for them
8.1 -
Globalization is one of those damned buzzwords that certain politicians and CEO's like
to use to mean that everything will be equal between countries. In reality there is
no such truth as we've seen twice in the past few years. Now maybe if we had a global
monetary system, like the EURO, thing
Mercadante, Thomas F scribbled on the wall in glitter crayon:
> Bill,
>
> Did you point out to them how *freekin wrong* they had been?!?!?!?!
> I would not have been able to resist the free shot.
ya never know when i'll need to find another contract, so i was very
diplomatic. but damn it was
8.1.7.4
Allan
-Original Message-
[mailto:Murali_Pavuloori/[EMAIL PROTECTED]
Sent: Thursday, September 04, 2003 12:55 PM
To: Multiple recipients of list ORACLE-L
What version of Oracle are you running?
Murali.
"Nelson,
Allan"
It doesn't work in only one direction. While jobs are bieng lost to cheaper
labor markets, Indian companies now have to compete with frighteningly
efficient
giants like Nike, Coca Cola, IBM, Microsoft, GM, Union Carbide and others.
Local
companies are losing the market and have to reduce their w
Look at the Backup and Recovery Doc's. And there are sample scripts in
OH/rdbms/demo/case1.rcv thru case4.rcv. The backup and recovery manual is a
great resource!
HTH,
Ruth
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
> Prem Khanna J
> Sent: Thursda
In addition, some non-tech HR wag does their screening of applicants based on
OCP, Oracle Master's, or some such certification. Yes, certification is an
issue whether or not it has technical merit. When it comes at a price that
many of us can't personnaly afford, it's a very BIG issue. I don'
Babette Turner-Underwood scribbled on the wall in glitter crayon:
> test
oh damn, i hate pop quizzes.;-)
--
Bill "Shrek" Thater ORACLE DBA BAARF Party member #25
[EMAIL PROTECTED]
It's no coinciden
-Original Message-From: Farnsworth, Dave
[mailto:[EMAIL PROTECTED]Sent: Wednesday, September
03, 2003 4:24 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Oracle on Win2000
Hammer, screwdriver and duct tape.
;o)[Shrek]
C4 is much more
fun.;-)
--
What version of Oracle are you running?
Murali.
"Nelson,
Title: RE: Oracle Masters exam
-Original Message-From: April Wells
[mailto:[EMAIL PROTECTED]Sent: Thursday, September 04, 2003 12:25
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Oracle Masters exam
I though about trying to figure out how to get it to be a
wri
I plan to apply patchset 9204 for my 9203 rac and found a lot of problems in
metalink, so be careful applying that PATCHSET.So I stop.
here is the list:
1.OUI bug. Must install OUI 2.2.0.18 before patch the database.
2.OUI bug. OUI do not install OUI to other nodes in a RAC system. You must
instal
Tom
I was wondering about the last log file on your
primary database that still hasn't been sent to your
standby database until a switch log occurs...
(thinking about sustained mode too)
Have you taken that into account??
JL
--- "Mercadante, Thomas F" <[EMAIL PROTECTED]>
wrote:
> Arup,
>
This can be done using a Package Variable.
Here are the steps :-
(1) Package Specification
=
CREATE OR REPLACE PACKAGE DSQL AS
n_TestValue NUMBER;
FUNCTIONGetValue RETURN NUMBER;
END;
(2) Package Body
CREATE OR REPLACE PACKAGE BODY DS
Title: Problem querying remote table through a synonym
I'm confused, has anyone ever seen something like this before?
This query works as you can see:
select count(*)
from [EMAIL PROTECTED];
COUNT(*)
--
275375
We execute the following DDL:
DROP SYNONYM MV_USER_ENABL
Anything stored is always easier to configure then anything external. It
shouldn't be
easier to use, though. And you should judge where dies it make sense. For
reading a
simple file 10 times a day (document scanning application at my previous
company),
a properly written C program (using fork,
LOL!
Funny how this "globalisation" bull only
works in one direction, eh?
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message -
> ** Another programmer who lost his job to an Indian
> outsourcer is willing to relocate in India. But Indian
> officials have told him they don't hire Ame
During my free time(ha, between developing pages for kid's soccer
association, redcross instructor and board member, family, work), are
you all interested in my discoveries when i start trudging thru the 10G
world?
if so i'll pick up the "new features for 10g" series when i can get my
hands on
Fact of the matter is the majority of the time its true, like it or
not. Those of you who know me, know I DON'T do politically correct, I
call a spade a spade.
Its true at the officer level in a company(and I'm there in the company
I'm in now), its all about dollars and cents, especially toda
Tom it's me again...
I have a (I consider) really good document about stand
by databases... (old, maybe, but still applies to 8i
standby databases)...
if you are interested... I can send you a copy... it
focuses about the 'details' with theses databases...
HTH
JL
--- "Mercadante, Thomas F"
Prem - I haven't found anything significant online. Perhaps someone else
(Bwill point to a resource. If you want to learn RMAN, my recommendation is to
(Bget a couple of books. The advantage of a book is you end up with a
(Bcomprehensive resource for reference. Myself, I need to go back and refr
My complaint is not based on moral grounds. My complaint is that Oracle's
greed is interfering
with my own. There is drastic difference in the behavior of Oracle Corp.
from the times before
Oracle 8.0 and after. Support has worsened, the quality of the code is
falling, bugs are more
and more numer
Mladen , you seem to be correct,
I checked the spfile and the parameters I try to modify exist there, but
reseting them takes one extra step
Say for example I find that undo_suppress_errors=false in the spfile.
Now if I try
SQL> alter system reset undo_suppress_errors scope=spfile sid='lahiri' ;
a
With respect to all of you out there... I hear so many complaints about
greedy Oracle, and about having to take a class to get certified and the
dollar cost of that. I remind you folks that Oracle is a for profit venture.
It's not Oracle's responsibility to make anything affordable. It's the
respon
Shows how in the loop I am since I left the steering committee :)
my apologies, it is, as Indy pointed out, September 23
--- Indy Johal <[EMAIL PROTECTED]> wrote:
> Rachel
>
> Is it September 18 or 23.
>
>
> Indy Johal
> Manager, Database Administration
> PR Newswire
> [EMAIL PROTECTED]
> h
We have tested a product this winter that was using an external C proc to
call cobol programs.
Stephane
-Original Message-
Jared Still
Sent: Thursday, September 04, 2003 11:34 AM
To: Multiple recipients of list ORACLE-L
One thing you can do is bypass all of your security if
you aren't
>From what I heard at an 8i Internals seminar, the OCM exams are nothing like
the OCP exams.
They really put people on the spot.
Patrice.
-Original Message-
Sent: Thursday, September 04, 2003 12:20 PM
To: Multiple recipients of list ORACLE-L
So, it's nothing like OCP where you get the
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> more and more employers are requiring OCPs and 'related degrees' such as computer
> science or a masters degree.
> At least in the US they are. How are things in other parts of the world?
For an "app
Title: RE: Oracle Masters exam
I though about trying to figure out how to get it to be a write off...
I'm not sure how taking an advanced class will help me to pass the test... I kind of would like to take it just to see if I can... but I really don't want to be doing it just to drum up Ora
Mike, it's always about the money. Unfortunately, I notice that
Oracle Corp. is getting greedier and greedier. Bugs are more and more
numerous and versions are released at such rapid pace that it is
extremely hard an expensive to keep up the pace. Of course, Oracle
would like to get some addition
See the ASM feature of Oracle
10g. http://otn.oracle.com/oramag/oracle/03-sep/o5310gcover_storage.html
Oracle handles virtualisation and redistribution of datafiles and also
provides mirroring of datafiles.
Hemant
At 07:59 AM 04-09-03 -0800, you wrote:
As an interesting side note, Oracle on MV
As an interesting side note, Oracle on MVS/OS390 offers multiplexing of
datafiles, since at least Oracle v6, I believe. It's just something that
never made the jump to other ports, I guess...
on 9/1/03 9:09 PM, Sinardy Xing at [EMAIL PROTECTED] wrote:
> how to startup oracle after machine
> is
I could not say it in a better way
/Quamrul
From: Maria Aurora de la Vega <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: Re: Urgent INFO needed.
Date: Wed, 03 Sep 2003 21:19:41 -0800
Its quite unfair for DBAs to blame
Rachel
Is it September 18 or 23.
Indy Johal
Manager, Database Administration
PR Newswire
[EMAIL PROTECTED]
http://www.prnewswire.com
(201) 946-5687 [W]
(201) 400-3960 [M]
"We tell your story to the world."
Rachel Carmichael <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
09/04/03 11:24
The masters seems a far better test of ability than OCP.
Unfortunately Oracle have attached the spurious "must attend 2 Oracle
classes" clause which makes it obvious that the whole program is just
another revenue channel.
I've considered signing up for it but I baulk at the idea of handing over m
Bahar
This is not Oracle 10i but 10G. It is new Oracle Release which is going to be release during the Oracle Openworld Next Week. So be ready for adventure thru bug again and have fun () in reading the Manual again. I came to know some very good features but it is still not finalized [ I
Hi Kader...
you do not need to do the same on the standby
database...
That logical changes are reflected automatically...
The only thing is that your physical datafile remain
as initially, but your controlfile has the changes.
Was I clear?
note that the only changes that you need to do at your
i saw some posts on the usenets that oracle has been cancelling masters exams and not
refunding the money.
saw a couple of posts on that.
>
> From: "Mladen Gogala" <[EMAIL PROTECTED]>
> Date: 2003/09/04 Thu AM 11:19:30 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subjec
Jose,
I've taken nothing into account. I'm still asking theoretical questions,
trying to prepare for a discussion I will be having this afternoon.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Thursday, September 04, 2003 11:29 AM
To: Multiple recipients of list
Ryan
I'm no expert either. What I heard is that the advantage of external
procedures were good where you have something that needs the performance of
the underlying system. The C code runs directly on the server, whereas Java
is on top of Oracle, which is system-independent.
Dennis Williams
DBA
September 18, NYC, (that meets the 212 area code, by the way, you could
have included 516 too!)
www.nyoug.org for details
--- Mladen Gogala <[EMAIL PROTECTED]> wrote:
> Why don't listers meet on the east coast, somewhere in the area codes
> 203,718 or 212? I don't pay roaming charges in those ph
Depends on your developers. We have few JAVA developers, but quite a few C
programmers. Plus I've got this great book of math routines in C.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Thursday, September 04, 2003 10:49 AM
To: Multiple recipients of l
One thing you can do is bypass all of your security if
you aren't careful. EXTPROC needs to run as some user
other than Oracle (nobody for instance), otherwise you've
just created a huge security breach.
There are other security implications as well. Even running
as 'nobody', you need to ensure
Title: RE: Oracle 9i Rel. 2 on Red Hat Advanced Server 2.1
1 Important Difference
RHAS 2.1 is the only certified version if you are using 9.2
-Original Message-
From: Kulev, Milen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 04, 2003 4:59 AM
To: Multiple recipients of list O
Prem Khanna J [mailto:[EMAIL PROTECTED] on Thursday, September 04, 2003
4:05 AM said;
> Bala,my reply is also the same as John said.
> "PC Anywhere or the console straightaway"
My favorite for remote console access on W2K is TightVNC -
http://www.tightvnc.com/ - or the 'ol standby, NetMeeting. W
So, it's nothing like OCP where you get the certification when you spew out
certain amount of the green stuff? I wonder how long will it take before
seeing
oracle masters who don't know how to take a hot backup.
--
Mladen Gogala
Oracle DBA
-Original Message-
Sharman
Sent: Wednesday, S
ALTER SYSTEM RESET applies to RACs only and you need to give the SID
parameter. When you said "I find that shared_pool_size exists there", did it
exist as the follwoing?
*.shared_pool_size=...
I bet it did. Note how you used the SID in setting the value
alter system set shared_pool_size=40M scop
what is this ? oracle 10i !
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <[EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
---
Title: RE: RE: URGENT : sql*loader performance problem on partionned table - not sql*loader problem but cursor pb!
Here the informations :
table HREL_FUSION :
63 millions rows
3 indexes on columns : nodos_or, nodos_or, numcli <--- too much indexes ??
table primedi_enr2_tem
Arup,
Thanks
for the reply. So I am assuming that the Standby database is in archivelog
mode?
Good
idea performing the backup on the standby rather than the Primary. Our
Primary is supposed to grow to 3TB, so your idea has merit. And our
servers will be in two different buildings, so
No, in Task Manager.
place the cursor over the task bar (at the bottom of the screen),
right-click, and Task Manager will be one of the items listed.
Open it, go to the Performance tab.
Patrice.
-Original Message-
Sent: Thursday, September 04, 2003 3:45 AM
To: Multiple recipients of lis
1 - 100 of 107 matches
Mail list logo