information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Michael Kline
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
database server and tries to
add something to it, that's when you really start having problems.
Keep it plain and it will do much better.
I just found 99% cpu for 3 months very impressive.
Maks.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Michael Kline
INET: [EMAIL
subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Michael Kline
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Michael Kline
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
: http://www.orafaq.com
--
Author: Ray Stell
INET: [EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Michael Kline
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public
to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Michael Kline
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
normally only see a database emergency about
once a year. Everything else is planned in advance.
Michael Kline
ThinkSpark
Richmond, VA
804-744-1545
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Paul Vallee
Sent: Tuesday, March 26, 2002 1:09 PM
into a visual basic program, but if this get a copy of the whole
table could be stopped, then this opportunity
would be over.
It's been too long since I've looked at Sql Server 7, and I can't think of anything
off hand.
Maybe one of you have been there, done that...
Thanks.
Michael Kline
ThinkSpark
to bundle iFS copycat into it operating syste
I think they wrote edlin, but that was years ago.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Michael Kline
INET: [EMAIL PROTECTED]
Fat City
://www.orafaq.com
--
Author: Michael Kline
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from
, before Sql*Net. Yea, them were the days...
Michael Kline
ThinkSpark
Richmond, VA
804-744-1545
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of bill thater
Sent: Tuesday, February 19, 2002 2:54 PM
To: Multiple recipients of list ORACLE-L
Subject: Re
://www.orafaq.com
--
Author: Michael Kline
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from
://www.orafaq.com
--
Author: Michael Kline
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from
failure to comply and lack of the teamwork spirit on this insanity was
duly noted. It was like Dilbert's worst nightmare.)
(...)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Michael Kline
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX
This seems new to me. Is there a work around?
sqlr 1* alter index sys.I_obj2 storage(next 1m)
*ERROR at line 1:ORA-00701: object necessary for warmstarting database cannot be
altered
Michael Kline
ThinkSpark Richmond, VA
804-744-1545
--
Please see the official ORACLE-L FAQ: http
FAQ: http://www.orafaq.com
--
Author: Michael Kline
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE
Bozeman, Montana, USA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Michael Kline
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
and I'm sure it would help interpersonal communications
some.
Cherie Machler
Oracle DBA
Gelco Information Network
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Michael Kline
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858
Title: RE: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB
Oh
the good old days when at the state
government they decided to call us
Bureau of Application Development And System
Software
Yep,
until the initials became apparent.. I think
it
lasted about 2-4 weeks, and they changed it.
--
Author: Michael Kline
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send
., Owner
13308 Thornridge Court; Midlothian, VA 23112, USA.
Work: 804-744-1545 Cell: 804-314-6262
Pager: 877-705-1155 ICQ: 1009605, 975313
[EMAIL PROTECTED]; [EMAIL PROTECTED];
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Michael Kline
INET: [EMAIL PROTECTED
--
Author: Michael Kline
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing
ORACLE-L FAQ: http://www.orafaq.net
--
Author: Michael Kline
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Michael Kline
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
I've got a cust
that is showing some signs that one would
think is having a
horrible problem onI/O...
I suspect it is the
"error" of having a **HUGE** value
in db_block_buffers
and it's constantly crunching memory
trying to figure
out which ones to free up. It's only
256 meg, but
Is there an "Easy"
way to assign specific tnslistener
ports to a specific
database?
Let's say I
wanted:
1521 to be
prod1
1522 to be
devl1
1523 to be
web1
1524 to be
test1
Right now ports are
basically assigned to servers
which may well be
adequate. But I was asked, and
it seems
PM
To: Multiple recipients of list ORACLE-L
Hi Robert,
Can you suggest a good RMAN book to start out. We're
also in the process of looking at RMAN to replace
in-house scripts.
TIA
Tom P.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Michael Kline
INET
My Financials
person is out, what might the following imply?
"I am currently working on a new tax book to the current Oracle fixed
assets
and I would like to copy the data from production to the test
environment.
I would like to add some major changes to these assets in the test region
Anyone have a
"simple" script to scan an alert
log for errors and
email a report if found?
Customer wants
something to run "often", but only
email when an error
is found. I've got something
that does a bit of
that and runs twice a day, but
always sends
out.
Thanks.
Maks.
I have a cust
pounding a Sun E450 I believe they
said it was with a
large RAID with fiber channels.
They pound this
thing at 2,037 I/O per seconds and
end up having about
3,868 I/O per data block wait.
This is averaged
over 3-5 days, 24 hr/day, so there
are times it's way
over that.
Have a client that
is using Linux and Oracle 9i.
They are attempting
to do live inventory on 5
branches using
streaming technology,
but when it kicks
it, it literally
shuts the network
down... If you are not in
before it starts
you can't get on. It appears
to do this to all 5
branches.
Got a
bit more on what they were doing.
One
really gets "scared" when Oracle wants to know what you're
doing.
Maks.
-Original Message-From: GregSubject: RE: Oracle 9i and streaming
technology
Actually streams is a
hybrid of several Oracle technologies: Log miner (used to hot
want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Michael Kline
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San
Punched cards and a sorter. Then COBOL with
indexed files once
loaded sequentially.
Michael KlineBusiness to Business
SolutionsRichmond,
VA804-744-1545
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of TOMPKINS,
MARGARETSent: Tuesday, July
Got a cust who went
Oracle 9i with failsafe...
Now Veritas is
broke and they evidently know it.
Anyone else bit by
this, and what was the solution
if
any?
I guess the 9i is
supposed to work, but when you
add failsafe it's
broke.. Hearing this 2nd hand
you
know..
Michael Alan Kline,
I have a customer
whose long term goal is to
have what would
probably be close to RAS, but
with the servers on
a FAST backbone and about
500-800 feet
apart...
Is there a way to
put that together with
hardware
software?
In some ways they
may even want to force a
splitting of the
load
Can RMAN backup a
database and leave any traces?
I have a client
site that was maintained with no
documentation and
now evaluating for how bad things
may
be.
We found an export
taking place, but no evidence
of anything else.
The alert.log shows NOTHING
as far as shutdown,
start up,
I found no signs of
RMAN being used in
any way shape or
form...
I've been told they
are doing "hot" backups
using Veritas...
HOWEVER, the alert log shows
no signs what so
ever of "alter tablespace
xyz begin/end
backup"...
Can it do a good
backup backing up live
DB files and
leaving
then, recovery is still not supported.
--- Michael Kline [EMAIL PROTECTED] wrote:
I found no signs of RMAN being used in
any way shape or form...
I've been told they are doing hot backups
using Veritas... HOWEVER, the alert log shows
no signs what so ever of alter tablespace
xyz begin/end
seems a bit like belt and suspenders
to me (how can you get a split block if the database
is quiesced?) but that's what we do. I'd guess Veritas
mirroring would require at least one of the two steps,
both of which should show up in the alert log.
From: Michael Kline [mailto:[EMAIL PROTECTED]
Sent
Let's
see... I remember dirt.. I remember UFI.
I
remember version 4.1.0 that ran on DOS... PC, PC-XT..
Oracle since 1983...
Good
loaded question.
Maks.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Goulet, DickSent:
Wednesday, July 23,
if there is absolutely NO
activity whatsoever in the database from the time the backup starts
until when it finishes. Even then, recovery is still not supported.
--- Michael Kline [EMAIL PROTECTED] wrote:
I found no signs of RMAN being used in
any way shape or form...
I've been told they are doing hot
: Michael Kline
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E
There seems to be
some big confusion if Veritas is
working or
not...
Based on Previous
discussions this customer has
the Oracle Veritas
agent running, and they do
nightly
backups.
How ever, I find
absolutely NONE of the RMAN
tables updated so
they are not using RMAN.
I also find that
.
-Original Message-
Daniel Fink
Sent: Wednesday, July 30, 2003 11:44 AM
To: Multiple recipients of list ORACLE-L
Michael Kline wrote:
There seems to be some big confusion if Veritas is
working or not...
snip...
Recovery has NEVER been tested.
Michael Alan Kline, Sr.
Principal
The database backup
is only export.
Once in a while
they are supposed to be doing a cold
backup.
Finally found
someone that said they can't use
the Oracle Veritas
agent with Oracle 9.0.2 and
Failsafe and/or
clustering. They have given them
a case number and
are working on it. When he
It's happening to a lot of us, but I had
one happen to me. One of my larger clients decided to go no DBA to save money.
On the average they were 10-12 hours a week. I could use something or a couple of small something to replace them one
of these days soon.
I work for a small company,
I'm trying to build
something like this:
select 'select
'''||TABLE_NAME||','||COLUMN_NAME||''', ''',''',
min('||COLUMN_NAME||'),max('||COLUMN_NAME||') from
' ||OWNER||'.'||TABLE_NAME||'
where '||COLUMN_NAME||' is not
null;' FROM
dba_tab_columns WHERE table_name
in
Anyone got a "1, 2,
3" for using transportable tablespaces?
Got a client that
thinks this might be a good solution to
transfer large
amounts of data.
This is HP/UX and
should be 8.1.7.4...
Any gotchas that
may kill this idea?
Thanks.
Michael Kline, Principal
Consulta
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
?
What solutions have
some doing this found to be "best practice"?
Thanks.
Michael Kline, Principal ConsultantBusiness To Business
Solutions, LLCRichmond,
VA804-744-1545
0310, x_200311,
etc.
Thanks.
Michael
Kline, Principal ConsultantBusiness To Business Solutions, LLCRichmond,
VA804-744-1545
52 matches
Mail list logo