Dear All,
Iam entitled the responsibility to come out with a plan for Backup (using RMAN) for our
forthcoming data centre operations. Could someone help me on this?
I would also like to know the steps for Recovery in the case of a Redo Log member failure,
using RMAN and the traditional Recovery
list, once our client decides to buy SAN,
here's what i'm going to propose for high availbility
we have 2 servers HP-UX and two databases, storage
is internal, once SAN is in place, i propose to
put both the DB's on the same server (one of the DB
isnot busy,less than 10 concurrent users)
In 8i we set utl_file_dir = * because otherwise we have to specify lots of
individual directories. It was not possible to just specify a top level
directory.
Has this changed in 9i? Is it possible to specify a top level directory
and then utl_file can write to subdirectories?
John
--
Hi,
1) check job_queue_processes and job_queue_interval parameters in your
init.ora file
2) have a commit after dbms_job.submit
3) if you want the procedure to be executed every second, then the next
date should be 'sysdate+1/86400' =
dbms_job.submit(:job_num, 'myprocedure;',sysdate,
1. I suggest U buy the
book on RMAN by I believe O'Reilly Backup Recovery by Rama
Velpuri
2. Come up with a list of all
possible failures/crashes
3. Document a recovery scenario for
all points
4. TEST Them.
Redo
log member failure. How do you see that?? It should be OK because it is
Hi,
I have RadHat AS2.1, oracle 8.1.7.4 (with OPS)
oracm, oranm, watchdogd are running
create database fails with ora-29702
lmon trace contains:
/usr/oracle/admin/OPS/bdump/lmon_1164.trc
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning and Parallel Server
Mike Ault's DBA book has some good DBA questions. Its a really good book.
--
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--
Jay, I've got pretty much a common framework written in unix shell
scripts to do most backup/restores for RMAN. I'm finishing up the front
end(text menus for unix) but the back end scripts are pretty much
solid. I'll be releasing the whole thing under GPL(for those of you who
don't know what
Arup:
NO FLAMES
The second condition is not quite true. It is 2/3 full in the current
versions.
/NO FLAMES
It is very easy to test with the event 10046^8.
KG
--- Arup Nanda [EMAIL PROTECTED] wrote:
AK,
If the log buffer is at least 4MB, then increasing it will not help,
rather it may
Title: RE: utl_file_dir and 9i
John,
In 9i, Oracle is recommending that you make use of 'CREATE DIRECTORY' rather than UTL_FILE_DIR ... firstly because a directory can be created dynamically, so to adda new sub-directory you don't have to bounce the instance.
Plus instead of '*', you can
Hi,
Is there a way to disable ODBC access to an Oracle database from the database
side? Perhaps an init.ora setting or something?
TIA
Dwayne
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Dwayne Cox
INET: [EMAIL PROTECTED]
Fat City Network Services--
Post a message to the list where they can be found when your ready. I'd like
to take a look at them.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, March 14, 2003 6:53 AM
Jay, I've got pretty much a common framework written in unix shell
We are currently using Patrol. We just upgraded to version 3.4 so that we
could be 9i compatable. We experience less than 2% impact at the worst of
times. Most of the time, it just hums along.
Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX: 816-300-1800
-Original Message-
Thank you, Jonathan,
No need for apology, all you input is very valuable. Note about
update/select for update just great, didn't realize this.
About chache chains. Taking real-time snapshots revealed breathtaking
FILE# DBABLK COUNT(*)
-- -- --
9
I don't think so.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, March 14, 2003 8:18 AM
Hi,
Is there a way to disable ODBC access to an Oracle database from the
database
side? Perhaps an
Yep, if you buy ide drives from wholesalers. I want 4 disks of 73GB capacity for an
HP storage network. $5600 for the first quote. Proprietary architectures generate
expensive parts.
-Original Message-
Sent: Thursday, March 13, 2003 5:25 PM
To: Multiple recipients of list ORACLE-L
Oracle 8.1.6 on Solaris 5.8.
We have a read-only standby database for one of our production databases.
Each night, the standby is shutdown and the previous days archive logs from
production are applied. Then the database is brought backup in read-only
mode. To get the archive logs, a hot backup
Good points, also consider the security issues that exist because of 'util_file_dir=*'.
With that, any user that can run a procedure and write (or overwrite) files in
locations that should be accessible only by oracle.
[EMAIL PROTECTED] 03/14/03 07:08AM
John,
In 9i, Oracle is recommending
Thnks Michal for your input,
All seems right for me:
SQL show parameter job
NAME TYPEVALUE
---
--
job_queue_interval integer 90
job_queue_processes integer
Thanks Jacques,
Yes I did:
VARIABLE jobno number;
BEGIN
DBMS_JOB.SUBMIT(:jobno,
'fixed_date_proc.getSystemDate;',sysdate, 'sysdate',
true);
commit;
end;
/
Ben
--- Jacques Kilchoer [EMAIL PROTECTED]
wrote:
After calling dbms_job.submit, did you issue a
commit?
-Original
List,
We seem to be losing our client connection with a JDBC thin driver
connection. The client and the developer say after a while the connection
just goes away. This is 8.1.7 64bit and HP11. It does not happened on AIX.
Is there something I need to configure, maybe in sqlnet.ora? Could it
True, but any DBA who puts utl_file_dir=* into their parameter file
should be hung, drawn and quartered anyway! Just imagine what the
effect is - you've now given people rights to open system01.dbf, write
to it and close it. Hmm, could that cause any problems? :)
Pete
Controlling developers is
KG,
Thanks for the response. Just for my curiosity, is it documented somewhere
that the log buffer if flushed when 2/3rd full? From the Manual
/server.920/a96524/c09procs.htm#3158 (please check the URL in OTN, the first
part is not complete), here is an excerpt
MANUAL
LGWR writes one contiguous
Which is why I want to know if in 9i I can specify a top level directory
John
-Original Message-
Sent: 14 March 2003 14:19
To: Multiple recipients of list ORACLE-L
Good points, also consider the security issues that exist because of
'util_file_dir=*'.
With that, any user that can run a
Terry,
what's chances the your scrit copy the archive logs the main database to
standby database on a same
moment when de database is saving the archive log file?
Adriano
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, March 14, 2003 11:19
All...
A developer working on a Solaris 2.6 server running Oracle 7.3.4 desires
a nightly backup (by simply copying them to a backup directory) of the
datafiles of an active instance. I explain that it will be a waste of
tape because the files will be corrupt and useless. He counters, As
long
Is this a good query to find segment where this block (
259186 ) belongs ?
select
segment_name
from dba_extents
where block_id= 259186 and 259186 = block_id+blocks
-ak
Do you guys think , adding more log file can help ? I think it should not ,
cuz any way logwriter is going to write in one datafile at a time , correct
?
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, March 14, 2003 4:32 AM
Arup:
Ben,
If this problem has not been fixed, check something else.
Run:
select job, what, broken, failures from dba_jobs;
I don't know how many, but after a certain number of failures, a job is marked as
broken and won't run automatically.
Darrell
[EMAIL PROTECTED] 03/14/03 08:38AM
Thanks
Add one more condition:
New in Oracle 9i, it will write when 1 meg is reached, so the 1/3
criteria is never reached if you use a big buffer.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, March 14, 2003 8:59 AM
To: Multiple
Jay
If you want a good book to get up to speed on RMAN, buy
Oracle9i RMAN Backup Recovery by Robert Freeman and Matthew Hart
If you want to compare the steps for various recovery scenarios between RMAN
and user-managed recovery, get Oracle Backup Recovery 101 by Smith and
Haisley. It
Actually /var/adm/messages on hpux is the message file, which my solaris 8(2.8)
machine is also using /var/adm/messages, maybe I changed this, I don't remember.
/var/adm/syslog/ is the default syslog directory equivalent to /var/log/ on solaris.
-Original Message-
From: Nelson, Allan
Title: RE: utl_file_dir and 9i
The answer is still NO
Raj
-
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !!
-Original
no no no no no no
If he is REALLY lucky, and no one is using the database at the instant
he does all the copies (and I mean the OS as well), then MAYBE,
POSSIBLY, if the Tooth Fairy and Easter Bunny are present and bless the
copy, he might have a valid backup.
But I wouldn't bet my job on it.
Title: RE: utl_file_dir and 9i
Pete,
At-least that way to can verify that your backup and recovery scenario's are up-to-date 8:)
Raj
-
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD:
Is anyone using Veritas Quick I/O for Oracle? We are purchasing some new
Solaris systems with fiber channel and Veritas File System, and the Veritas
salesperson is claiming up to 400 times faster. I would like to know if
anyone else has discovered this miracle and what benefits you are seeing.
Access is very appreciated by our end users here.
On the most sensible systems we worked with the dev teams on the login
procedure.
We usually enable a role in the login procedure so the users can only
connect to the database via the application.
Another way we had implemented security is that we
Title: RE: a DIFFERENT sql question
SELECT DISTINCT
t1.category CAT
,t2.type TYP
,SUM(DISTINCT t1.amount1) OVER(PARTITION BY t1.category) Sum1
,SUM(t2.amount2) OVER(PARTITION BY t1.category, t2.type) Sum2
FROM
t1
,t2
WHERE
t1.mykey1 = t2.mykey1
/
CAT TYP SUM1 SUM2
AA x 8 27
AA
What's the size of your log buffer, and the redo log file?
Do you see any errors/messages in alert.log file that are related to 'checkpoints' or
'log switching'?
- Kirti
-Original Message-
Sent: Friday, March 14, 2003 10:14 AM
To: Multiple recipients of list ORACLE-L
Do you guys
Are there any equations which can say log buffer is
small or large ? I mean how to find the proper size of log buffer .
-ak
- Original Message -
From:
Deshpande, Kirti
To: Multiple recipients of list ORACLE-L
Sent: Thursday, March 13, 2003 5:13
PM
Subject: RE:
Dick...
Thanks very much for the reply!
Only if 1) The database is shutdown prior to the copy of the
datafiles, and everything else that compromises the database (online
redo, control files, etc...)
I hate second-guessing myself, but this is what I've been trying to tell
him.
or 2) the
Ron - As a solo DBA shop, I can't be much help except to point out that most
of what I've heard involves the DBAs specializing between production work
and development work. Some DBAs administer the production databases, others
work with the developers. This also seems to suit the personality
I think the only ways adding more log files might help is if your app is
waiting on log file switch (%) events.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic 101, Mar 25-27 Oxford
- Hotsos Clinic 101, Apr 8-10 Chicago
-Original Message-
I thought I'd repost to see if I could get a response. Anyone?
--- Paul Baumgartel [EMAIL PROTECTED] wrote:
I'm looking at a client's tkprof output, showing among other things
that the insertion of about 135,000 rows taking 450 seconds of CPU,
and
with current mode buffer gets numbering
AK,
Could you provide the redo log sizes and the log_buffers parameters, please.
Also let us know the log switch frequency, too.
Thanks.
Arup
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, March 14, 2003 11:14 AM
Do you guys think ,
This link is about installing on Red Hat Advanced Server. What
differences will I face trying to install on Red Hat 7 (or 8 if I can
get my video card working in 8)?
Thanks
Stephen
[EMAIL PROTECTED] 03/10/03 09:28PM
I installed 9.2 on redhat 8.0 with great luck. I installed on a 700 PC
with
As with all backup and recovery plans, you should test, document, and
perhaps automate the process, with particular emphasis on the recovery.
What your associate describes sounds like an very expensive BR plan.
On Fri, Mar 14, 2003 at 07:44:01AM -0800, Gary Chambers wrote:
All...
A
Precisely
But wouldn't it be nice if Oracle made '*', in the utl_file_dir specification, an
unacceptable parameter value?
- Kirti
-Original Message-
Sent: Friday, March 14, 2003 9:19 AM
To: Multiple recipients of list ORACLE-L
True, but any DBA who puts utl_file_dir=* into
Gary,
I had a similar engineer managed DB around here for a while. The problem
was that 'someone' deleted a couple of the datafiles by 'mistake'. (Ever see
that CDW commercial concerning the full file server?) Well I got asked the
same question to which I had a very good laugh told the
Gary,
Only if 1) The database is shutdown prior to the copy of the datafiles, and
everything else that compromises the database (online redo, control files,
etc...) or 2) the effected tablespaces are put into hot backup mode before the
copy, in which case when you restore the files Oracle
Join the file_id as well as follows
select segment_name
from dba_extents
where file_id = 123
and 259186 between blocks and
blocks+block_id
HTH
Arup
- Original Message -
From:
AK
To: Multiple recipients of list ORACLE-L
Sent: Friday, March 14, 2003 11:03
AM
Here is a part of trace file . I am finding that
oracle is trying to read 8 or 3 or 7 blocks at a time . But block numbers are
all sequential i.e. it will read 3 blocks starting from 14706 and then 8 blocks
starting from 14710 ( 14706+3 ). Why it doesn't read 8 blcoks always it
Oh, Gods forbid the sysadmins would have to gulp do their job...
HAHAHAHAHA!!!
Scott Shafer
San Antonio, TX
210.581.6217
-Original Message-
From: Mogens Nørgaard [SMTP:[EMAIL PROTECTED]
Sent: Thursday, March 13, 2003 5:25 PM
To: Multiple recipients of list ORACLE-L
Subject:
You can't call a job every second via DBMS_JOB.
I believe that at best the resolution is 1 minute.
You could just open another session and run
something like this:
declare
fd varchar2(50) := '01/01/2010 00:00:00';
v_sql varchar2(200);
begin
loop
v_sql := 'alter system set
Any way to do that?
Fast answer is appreciated.
TIA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Thomas Day
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web
Title: Re: segment from block#
You also need to specify the file_id in the predicate. However, on anything
but a micky-mouse (T) database this query will take a long time which is
why I run a nightly job to populate a extent_to_object table which will
give me that answer quickly (except
This seems to be a good idea. I will see if this is acceptable to my people.
Earliar I suggested to change to date field, and was not acceptable for them
as there seems plenty of code needs to be changed. I will see if this change
is acceptable for them.
One thing I could understand clearly from
Chances are excellent, that you/oracle would not be able to
recover.
Oracle support might bring the super tool with the
swat expert for 5000 bucks an hour...and then
it might still be a mess. They would love you doing this
stuff..
Brian
-Original Message-
Sent: Friday, March 14,
Now, you could put the tablespaces in read only mode, then the copy would
work. But then again, could you put all the tablespaces in read only mode
?
h, don't think so :). [EMAIL PROTECTED] 03/14/03
11:54AM Gary, Only if 1) The database
is shutdown prior to the copy of the datafiles,
we recently moved from t64 to sun and had io related perf issues w/o quick
io. once the veritas db version (which which quick io comes) was installed,
the performance was back on par with t64...
babu
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent:
you are right and the developer is not. cold backups taken with the db open
are worthless. you cannot use them to open it back to a consistent state
babu
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, March 14, 2003 10:44 AM
All...
A
My
company is currently considering using Oracle 9i RAC. One of the proposed environments
is to have multiple oracle instances (3 or more) configured on a 4-8 node RAC
cluster. Does anyone have any insights as to the viability of this
implementation? Will the high speed inter connect be
In a previous life, I worked at WilTel (very well managed), which became
WorldCom (so-so), which became MCI WorldCom (no comment). I started out in
WilTel's Engineering Department which (wisely) kept all of IT operations
separate and independent from the grand and glorious (and huge) company IT
I have seen lower sequence logs complete archival after higher sequence
logs. Usually coinciding with some sort of I/O bottleneck where multiple
archiver processes are competing for limited bandwidth. I have not seen any
sort of log corruption as a result of that process though. If the logs
Title: RE: Veritas Quick I/O for Oracle
got a copy, benchmarked it. No discernable
difference for our application. Others I
know swear that it's great. So I guess it varies by
the application.
Matt Adams - GE Appliances - [EMAIL PROTECTED]
Another month has ended.
All goals met
All
This was my first thought.
On Friday 14 March 2003 10:48, Stephane Paquette wrote:
Access is very appreciated by our end users here.
On the most sensible systems we worked with the dev teams on the login
procedure.
We usually enable a role in the login procedure so the users can only
connect
Really? I thought that condition was there pre-9i as well. Maybe I'm
mistaken.
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
-Original Message-
WILLIAMS
Sent:
Gary - send the developer to backup and recovery school.
he is wrong. as Rachel said, *maybe* it will work once. but as a DBA, you
personally can *never* support this in a real environment. you will not be
able to guarantee the same results every time.
Tom Mercadante
Oracle Certified
Title: Message
RAC is a multiple instance one database configuration. Different
instances on different nodes accessing a single database on shared
disk.
Can you have multiple RAC databases running in a cluster? Sure, if
the machine has enough resources. That's about as close as we can say
Many thanks Jared,
Definitely I think this is only one away to resolve
my problem.
Have nice week end,
Ben
--- [EMAIL PROTECTED] wrote:
You can't call a job every second via DBMS_JOB.
I believe that at best the resolution is 1 minute.
You could just open another session and run
Humm, must of missed this one on the rebound. Anyway, here Disk space is an
admin nightmare. Each time we want to reassign disks from one server to another
here comes EMC to re-program the Symmetrix array otherwise the SA has the
possibility of assigning 2 servers to the same disk. OOPS I
Oracle 9.2.0.2
Can the Oracle JDBC thin driver be used with RAC to setup
failover and load balancing between instances in the same way the thick driver
can?
Thanks,
Rick Stephenson
This email and any files transmitted with it are confidential and intended solely for the
alter system set _system_trig_enabled = false;
Jared
Thomas Day [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
03/14/2003 09:04 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Bypassing startup
Title: RE: log buffer space
I think this might help...
http://www.ixora.com.au/tips/tuning/log_buffer_size.htm
-Original Message-
From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 14, 2003 11:19 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: log
Gary,
I second this user's comments. Is it possible to get a valid backup while the
database is up? Yes, it is but it is just plain silly (at the very least), to plan to
do so. Whether or not this backup is good depends on no activity and if there's no
activity, why not just shut it down
You might try putting
_system_trig_enabled=FALSE
in your init file. I'd test this though to make sure.
(or disable the triggers in question)
[EMAIL PROTECTED] 03/14/03 11:04AM
Any way to do that?
Fast answer is appreciated.
TIA
--
Please see the official ORACLE-L FAQ:
Dennis,
The 1MB condition was in 8i as well, at least in 8.1.7, as I mentioned in my
original post.
I was always under impresssion that the flush is triggered by the buffer
being 1/3rd full; but KG mentioned it was 2/3rd, not 1/3rd and I was
wondering where he got that information from and if
What can I say? Shoot the danged developer!
No, no, no, no, no. The backup is as much use as the proverbial on
a bull. Period.
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
Todd,
RAC is a multi-instance database. If you have n
nodes in a cluster then you generally have (although not necessarily that many)
n instances accessing the same database. When you mention 3 or more Oracle
instances, perhaps you mean 3 or more "databases" each in a separate cluster of
4
Nah, can't do that! It would make our training courses that use it too
difficult to set up! :)
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
-Original Message-
That wasn't the problem at all.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Thomas Day
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
Maybe finger stutter. I've never seen it mentioned anywhere except as
1/3.
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
-Original Message-
Sent: Friday, March 14,
How about
alter system set _system_trig_enabled =false
chaim
Thomas Day [EMAIL PROTECTED]@fatcity.com on 03/14/2003 12:04:33 PM
Please respond to [EMAIL PROTECTED]
Sent by:[EMAIL PROTECTED]
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Any way to do that?
DENNIS WILLIAMS wrote:
Is anyone using Veritas Quick I/O for Oracle? We are purchasing some new
Solaris systems with fiber channel and Veritas File System, and the Veritas
salesperson is claiming up to 400 times faster. I would like to know if
anyone else has discovered this miracle and what
Ron,
I think you are starting at a good place.
Production DBA's worry about different things than Development DBA's.
Mostly they are concerned with (in priority order) Backup schedules
Validations (make sure they are working), disk usage (make sure there is
enough) and on-going tuning issues.
All of the places I've worked its been sysadmins fat-fingering that has
hosed or cross mounted disks. Then again, we've never had EMC... HP arrays
are enough trouble.
Scott Shafer
San Antonio, TX
210.581.6217
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]
Sent:
It takes 16 failures to mark the job as broken.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, March 14, 2003 11:24 AM
Ben,
If this problem has not been fixed, check something else.
Run:
select
Hi,
We have open Time for every order, ef:
Open Time
--
03/12/03 11:08:07
How to calculate the working hours (8am - 5pm, no
weekends) that a file remain open until now? (Sysdate
- Open_Time) returns all the hours including weekend
and 8am, 5pm hours. We only like to know the
For the answer to your first question, see
Jeff Holts Predicting
Multiblock Read Size at www.hotsos.com/catalog.
Prior to Release 9, the statistic ela= 1 means that the syscall lasted
somewhere between 0.005000 and 0.014999 seconds in duration. Full details
forthcoming in
You will need FILE_ID as well.
Here is what I use:
-- find_segment.sql
-- Finds segment name based on file_id and block_id
set Lines 132
col Owner for a10
col Segment_name for a30
col Segment_type for a20
col Tablespace_name for a30
select Owner,
Segment_Name,
Segment_Type,
Title: RE: File Restoration/Recovery
Schema level export can fix the *thinking*
Raj
-
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any clod can have facts, having an opinion is an
Thanks!!
Darrell Landrum
Database Administrator
Zale Corporation
[EMAIL PROTECTED] 03/14/03 12:44PM
It takes 16 failures to mark the job as broken.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday,
Title: Message
No, that's why it's the thin driver. If you want TAF capability,
you have to use the JDBC thick driver instead.
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
They have been removed due to my rman framework scripts taking the disk
space.
Sorry.
Joe
I have found Joe Testa's site has a good set of RMAN scripts (I think
they came from Jack van Zanen off this list), quite simple but they
give the syntax for most of the commands you will want
The link
I have found Joe Testa's site has a good set of RMAN scripts (I think they came from
Jack van Zanen off this list), quite simple but they give the syntax for most of the
commands you will want
The link was http://www.oracle-dba.com but that is no longer working
Where have you put them Joe??
Hello,
Env: Oracle 9.2.0.2.0 on Solaris 9
I suspect this is a foolish question, but I will ask anyway:
(It's Friday; my brain stops working after Wednesday)
How much does the presence of constraints influence the optimizer,
if the indexes are present?
We are developing a method for
Arup
I have a busy day, so the only resource I can quote without research is
the Oracle Education Oracle9i Database Performance Tuning Student Guide.
Lesson 5-3 reads: When the redo log buffer is one-third full. Hope that
answers your question.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch,
The counts are inclusive:
14706 / 3 means
14,706 14,707 14,708
so you have to skip one then start
again at 14,710.
Yes, 'ela' is the elapsed time in 1/100 of a second.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Now available One-day tutorials:
Cost Based Optimisation
What version of HP-UX?
Here is what I get on HP-UX 11.0:
df2hp105 [IWHA]: ll /var/adm/me*
/var/adm/me* not found
- Kirti
-Original Message-
Sent: Friday, March 14, 2003 10:44 AM
To: Multiple recipients of list ORACLE-L
Actually /var/adm/messages on hpux is the message file, which my
I remember seeing documentation on it for 8i as well.
--- Pete Sharman [EMAIL PROTECTED] wrote:
Really? I thought that condition was there pre-9i as well. Maybe
I'm
mistaken.
Pete
Controlling developers is like herding cats.
Kevin Loney, Oracle DBA Handbook
Oh no, it's not. It's much
1 - 100 of 129 matches
Mail list logo