I'm stuck in the mount section of the tutorial. I'm only trying to setup
one DB and I don't get how I should setup a mount point for the software and
one for each db file using /pm pattern. P is the string constant and m is
the fixed length key to distinguish between mount points.
- Original
Well, I already started on the SQL Server paper on the R=S+W thing, but I
needed help from guys that knew far more than I, and I didn't get it.
Here's the idea:
The formula can be used on statement, session and system level. So that's
3 x 3 grid where at least the R column and the S column
/*+ cardinality(t,N) */
where t is a table alias and N is a number
instructs the optimizer to use N as the
computed cardinality of table t without
going to the trouble of checking.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Coming soon one-day tutorials:
Cost Based Optimisation
Hi
Just give the mount points names you are happy with
The examples you normally see use U01,U02.
It basically means that your software should be installed on different mount
point/disk than your db files.
-Original Message-
Sent: woensdag 19 februari 2003 8:49
To: Multiple
Will sys Component of CPU Utilization be Higher on a RAID 5 Volume Versus a RAID
1+0/0+1 Volume on a Database Server ?
Under peak Hybrid Loads the CPU Utilization's sys component is 50 % usr
component is 50 % .
Our Hybrid Application DATABASE is setup on a Hitachi Storage Box configured such
OK, after reading many of the posts on RMAN (Robert Freeman's book is now on
the shopping list), I took the plunge and spent all day yesterday hacking
away with it. Fun, fun, fun (well, as fun as backups could be).
Couple of questions - tablespace backups. If I have a tablespace backup,
how
Null event is the bane of ORACLE 9.X. It pops up uner any
circumstance that you really really need to know what a session is
waiting on. Also, if you select your own wait event, it is always
Null event. Result is about 15 bugs filed with Oracle by us alone.
They promise it will get better in
Hi.
What sytax can I used to see when a table or
object was last updated/modified?
Thanks
Clint
Confidentiality
Warning===The contents of this message and
any attachments are intended solely for the addressee's use and may be legally
privileged and/or confidential.
I
wonder if I can throw in a further caveat to the choices people would
make?
If you
had to choose a programming language in which to write a program
orapplication in which you wished to conceal your intellectual property,
which would you use?
peter
edinburgh
-Original
You have to give commit after submit the job.
-Original Message-
Ling Catherine (CSC)
Sent: Tuesday, February 18, 2003 8:14 PM
To: Multiple recipients of list ORACLE-L
Hi Gurus,
I have submitted a job but it does not execute. Why? Does the owner
require any privileges ? However, I can
AFAIK
NOT
shell scripts
NOT
batchscript
anything else probably works for
you
Jack
-Original Message-From: Robson, Peter
[mailto:[EMAIL PROTECTED]]Sent: woensdag 19 februari 2003
12:34To: Multiple recipients of list ORACLE-LSubject:
RE: Programming languages that make
Have you set the job_queue_processes parameter in you init.ora file?
CHAN Chor Ling Catherine (CSC) wrote:
Hi Gurus,
I have submitted a job but it does not execute. Why? Does the owner require any privileges ? However, I can use DBMS_JOB.CHANGE command to execute immediately. I would like the
You have to run the job after you submit it.
SQL exec dbms_job.run(24);
Also make sure all init.ora parameters are set eg (job_queue_interval ,
job_queue_processes )
HTH,
Rajesh
-Original Message-
Ling Catherine (CSC)
Sent: Tuesday, February 18, 2003 8:14 PM
To: Multiple recipients of
Make sure job_queue_processes 0. Also check job_queue_interval.
Jay Hostetter
Oracle DBA
D. E. Communications
Ephrata, PA USA
[EMAIL PROTECTED] 02/18/03 08:28PM
Hi Gurus,
I use the following command to execute immediately.
Connected.
SQL BEGIN
2 DBMS_JOB.RUN(1);
3 END;
4 /
A customer of mine has recently decided to purchase
BRIO but the process of checking references on the producthas
been(ahem!)pretty discouraging. Specifically, they have gathered
the following comments:
1. There are no
aggregate functions available on the BRIO client. For example,
Ken,
Do all the following as a way to minimize MTTR (Mean Time To Recovery) for
a variety of scenarios and, by the way, they happen to use a lot of disk:
;-)
1. Mirror your online and archived redo logs to multiple drives
2. Put backup copies of drive A' datafiles on drive B (or C) and vice
Sounds
like BRIO requires on a significant effort on the server side to prepare data in
the database first(hmmm just every other DSS tool out
there)
All
DSS tools require a thoughtful server side approach.Some of the best DSS
toolsare people who can build good data structures, PL/SQL
Title: RE: DBMS_JOB : Can submit but does not execute
Also as a practice, I always submit sysdate + 5 seconds instead of sysdate.
Raj
-
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD:
I'm continuing to introduce myself to 9i. I've been reading about Automatic Segment
Space Management, and I just wondered if anybody had any positive/negative experiences
with it. I got some good info at:
http://www.dbazine.com/burleson11.html
Thank you,
Jay Hostetter
Oracle DBA
D. E.
Create a massive tempspace :)
Brian
-Original Message-
Sent: Tuesday, February 18, 2003 6:24 PM
To: Multiple recipients of list ORACLE-L
Hi,
I was wondering how DBAs are coping with these new large disks that are
availableyou can purchase 36gb, 72gb, etc. You can fit a whole
Hi All,
Oracle 8.1.7.4 WinNT
Is there a way to have ops$account privs to shutdown/startup database?
Oracle does not allow granting sysoper to external accounts.
Thanks
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network
Klingon.
-Original Message-
If you had to choose a programming language in which to write a program or
application in which you wished to conceal your intellectual property, which
would you use?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
Title: Service startup on Windows 2000 fails
Good morning everyone,
Windows 2000 sp3, ver 8.1.7.2
I have NO IDEA what is going on here. I can't start any of the services associated with Oracle, not with my logon, not with local admin, not with a local account with appropriate
Jonathan,
Could you provide more information on this hint ? I couldn't find it in
the 9i Performance Tuning
Guide and Reference, although there is the DYNAMIC_SAMPLING hint.
Hemant
At 12:28 AM 19-02-03 -0800, you wrote:
/*+ cardinality(t,N) */
where t is a table alias and N is a number
That shouldn't matter. Look at DBA_JOBS when you startup an instance after
it's been down for a while (not that it would ever happen!). All pending
jobs (nextdate = SYSDATE) should be firing, at least as many
job_queue_processes as you have in the init.ora.
Rich
Rich Jesse
Title: GR OWS
Are these people at Oracle Support always this stupid??! I'm having an argument with an analyst regarding the permissions to the listener.log (which is set to full control) but keeps blowing errors!!!
G
Lisa Koivu
Oracle Database Administrator
Fairfield
I would say not doable as such but what I would do would be extract the
whole database onto a test server...then perform the transportable
tablespace
magic.
The Transportable tablespace handles the dictionary information. Now if
someone
comes back and says its possible and it is.. I will fall off
On Wed, Feb 19, 2003 at 06:08:53AM -0800, Stephen Lee wrote:
Klingon.
so you can speak to the sysadmins...
-Original Message-
If you had to choose a programming language in which to write a program or
application in which you wished to conceal your intellectual property,
Hey all,
Since we've added a datafile, our Tablespace Full event in OEM has been
hammering the DB. Waits go high on Controlfile I/O when the following is
running (no doubt from the v$datafile scan):
select sum(f.bytes)/:SYS_B_0, floor(sum(f.bytes)/:SYS_B_1)
from sys.dba_free_space f,
Vivek
Since I don't see where anyone has responded to your questions, I will make
a try and maybe my feeble answers will provoke the more knowledgeable on
this list to come to your assistance:
1. This varies slightly by Oracle version. For Oracle9i, the LGWR writes out
the redo log from the redo
The same way as you do perl: external library
-Original Message-
From: Jesse, Rich [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 18, 2003 4:44 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Programming languages that make DBA's lives easier
Cool! How'd you
Title: Message
Can
you start the service via oradim?
CMD
oradim
C:\oradim -STARTUP -SID -USRPWD -STARTTYPE srvc,inst -PFILE
C:\your_path\
can
you start the db via svrmgrl?
CMDset oracle_sid=mysid
svrmgrl
connect internal/*
startup pfile=.
have
you tried rebooting
- Original Message -
From:
Clinton Naude
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, February 19, 2003 5:53
AM
Subject: Checking when a table was last
updated.
Hi.
What sytax can I used to see when a table
or object was last
You can so a tablespace point-in-time recovery to a clone and
export the data and import it into the origina database. I think this is
what you're asking.
Ruth
- Original Message -
From:
Grant
Allen
To: Multiple recipients of list ORACLE-L
Sent: Wednesday,
Actually, those disks are only marginally larger in the one statistic
that counts. The number of I/O's per second is the driving performance
statistic for production databases. I usually point out to them that if
all you had was a 4 cylinder engine for your vehicle then buying dump
trucks just
Title: RE: Automatic Segment Space Management
In a very isolated test scenario with RAC; it removed a tremendous amount of free list contention(as well as header block..). In addition, we removed latch contention for a couple of specific latches as well..
But keep in mind; this was a very
I'm curious as to how others with smaller databases deal with it as well..
You can't even buy under 18GB hard disks for some brands of servers anymore..
My production databases are all relatively small i.e. 5 GB - 7 GB, but yet
I'd still want several independent physical disks to spread
Try looking in the Event Viewer. For Win 2K that's under START - SETTINGS
- CONTROL PANEL - ADMINISTRATIVE TOOLS. Hopefully it will tell you
something.
how exactly would I assign the the mount points? I mean I don't which
directories to actually mount where... ?sorry if this is a dumb ? THnaks.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, February 19, 2003 12:48 AM
Hi
Just give
Title: Service startup on Windows 2000 fails
Lisa,
Just a thought - did you try starting the listener
from the command line - lsnrctl start?
Arup
- Original Message -
From:
Koivu, Lisa
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, February 19, 2003 9:08
Do I create the mount points after I install Oracle or before? I'm not this
stupid in windows, trust me... ;)
- Original Message -
To: Les Ayudo [EMAIL PROTECTED]
Sent: Wednesday, February 19, 2003 7:44 AM
I did:
/DB/O92iBase/O92iHome - for my Oracle binaries
/DB/O92iBase/db92i -
Title: Service startup on Windows 2000 fails
Lisa,
Just
re-read your note and realized that you are not able tostart
anyOracle service.
Is the
server a Pentium IV (just a thought)? Is this a new install? Or did it
juststart happening?Does a re-boot of the server make any
difference?
Lisa,
What error do you get when you try
lsnrctl start
from the command line?
Have you tried oradim from the command line to start the DB service?
Jack C. Applewhite
Database Administrator
Austin Independent School District
Austin, Texas
512.414.9715 (wk)
512.935.5929 (pager)
Title: RE: Lgwr , CKPT - Some Misc. Puzzlers ?
This piece is also the same in the older versions... for sure 8 and 8i too...
-
5. New in 9i, when 1M is reached, which means if the buffer is large, the
1/3 mark will never be reached.
-
Nick
-Original Message-
From: DENNIS
Frighteningly enough, Damian Conway has produced some wonderfully hideous
Perl modules that allows you to write your code in Klingon. It even does
it in object-oriented style (method overloading in Klingon - ack!).
I have a different way of justifying it. It seems that everyone still
assumes the one application = one database mentality. I have chosen to
implement a different strategy. Multiple applications = one database. I
see no reason to use the file server approach anymore. The issues with
downtime,
Does it matter which version of Oracle 8i I install
on solaris 9? 32bit or 64bit?
Title: RE:
ever thought of NAS or SAN devices?
-Original Message-
From: Wayne Straughn [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 19, 2003 6:49 AM
To: Multiple recipients of list ORACLE-L
Subject: RE:
I'm curious as to how others with smaller databases deal with it
Title: Lengthy Table and/or column names
Are there any issues to consider when naming tables and/or columns (length of column name)? I know the max length is 30 but some of the table names that my client wants to add (against my recommendation) look like Cobol and are pushing 30 characters.
Hello all,
HPUX 11.11 Oracle 8174, 9201 and 9iAS 90201
I have all three versions in their own homes and I have a login script that
asks what I want the environment to be set as upon login (ORACLE_HOME,
ORACLE_SID, etc) but I always set
TNS_ADMIN=/u01/app/oracle/product/9201/network/admin for
On Wed, Feb 19, 2003 at 06:08:54AM -0800, Koivu, Lisa wrote:
--
tell the sysadmin to look in the event log for system, apps,
and security. Probably some hints in there.
===
Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC
Lisa,
Pick your favorite sid on that server ex. lisa
delete the password file associated with sid lisa. It will be in your
oracle_home\database directory.
At the command prompt delete that instance. This will not delete the
database
oradim -delete -sid lisa
Recreate service using
oradim -new
Lisa,
Have you checked the .log files in %ORACLE_HOME%/network/log ? From my
experience, I get this error every time there's an Oracle config problem
with the service, instead of a Windows config problem.
HTH! GL!
Rich
Rich JesseSystem/Database Administrator
[EMAIL
Title: Service startup on Windows 2000 fails
lsnrctl80 start
might need to prefix it with the listener name, too...
April Wells Oracle DBA Great spirits have always encountered violent
opposition from mediocre minds -- Albert Einstein
-Original Message-From: Arup Nanda
Live long and prosper!
-Original Message-
From: Stephen Lee [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 19, 2003 9:09 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Programming languages that make DBA's lives easier
Klingon.
-Original Message-
Lisa,
I'd suggest checking the application log in Windows event viewer - usually
contains something even if the on-screen response suggests no error
returned. You should see things like
Audit trail: ACTION : 'SHUTDOWN' DATABASE USER: '/' PRIVILEGE : SYSDBA
CLIENT USER: SYSTEM CLIENT TERMINAL:
Dan,
I am looking for an inexpensive hotel for Training Days. What
should it be near? What is the address of the Convention Center?
Thanks,
Ruth
- Original Message -
From:
Fink, Dan
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, January 14, 2003 11:14
what happens if try starting the listener from the command line.
[EMAIL PROTECTED] 2/19/03 9:08:53 AM
Service startup on Windows 2000 fails
Good morning everyone,
Windows 2000 sp3, ver 8.1.7.2
I have NO IDEA what is going on here. I can't start any of the services associated
with Oracle, not
Ramon - I believe you are correct. OMF files are automatically deleted when
the file is dropped in Oracle. OMF log files are treated just like the other
OMF files. Try it and let us know. But try your test database. :-0
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
Check to make sure Oracle is not using NT PDC authentication. Maybe
you do not have a PDC in the network and Oracle would not start
becauise of this.
--
Lyndon Tiu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Lyndon Tiu
INET: [EMAIL PROTECTED]
Fat City
You need to change your ORACLE_HOME for the 8.1.7.4 environment. Look for
the ORACLE_HOME_SELECTOR. Mine is under ORACLE_INSTALLED_PRODUCTS.
Title: Message
Lisa
Sorry, I misread your message, I had theimpression the db would
notstart... not that the listener would not
start.
Is it possible you/someone installed oracle that was
not an administrator, at the time of install. Sounds like a permissions
problem.
possible solution
Title: Service startup on Windows 2000 fails
Hi
Wayne,
Thanks
so much for responding.
I
guess my lack of knowledge of Windows 2000 administration has just bit me in the
ass. A description of a paintbrush-style change applied to our servers by
the network support people in another
Best to do your mount points first, and then mount the partitions on
those mount points that you expect to use.
-Original Message-
Sent: Wednesday, February 19, 2003 10:35 AM
To: Multiple recipients of list ORACLE-L
Do I create the mount points after I install Oracle or before? I'm not
Jay,
I have been using ASSM for last five months in our Datawarehouse
environment. Haven't had a chance to play with the OLTP side, yet.
Inserts are way faster as compared to system managed extent allocation. I
read Don's article on DBAZINE. However, I would like to add one caveat here:
ASSM
Stephen,
Out of curiosity, how do you deal with application testing (or for that
matter compatibility) when upgrading the Oracle version?
Henry
-Original Message-
Stephen
Sent: Wednesday, February 19, 2003 12:29 PM
To: Multiple recipients of list ORACLE-L
I have a different way of
Jay - My impression from the Oracle9i New Features class is that it is most
useful when you are doing intense inserts into a table. Based on that, I
said to myself that I should remember this when I need to tune heavy
inserts. Nothing past that.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch,
Title: GR OWS
Yes, yes they are.
you having listener problems too? Mine is looking for
host=insert unprintable characters here
trade ya!
April Wells Oracle DBA Great spirits have always encountered violent
opposition from mediocre minds -- Albert Einstein
-Original
Shell - I have used Unix Shell Programming revised Edition by Kochan and
Wood extensively. It's really all I use for shell programming problems.
It's well-written and not a dry read.
Perl - most everyone I can think of will point you to the O'Reilly library
of Perl books, starting with Learning
COOL Thanks. I'll get to this right nowTHANKS!!
- Original Message -
To: Les Ayudo [EMAIL PROTECTED]
Sent: Wednesday, February 19, 2003 10:11 AM
Hmmm,
It took me about two months of reading and trying before I got this
right.
I do not have my play db with me at the
Title: Message
Yes,
in general since they moved most support to India, you get analysts that are
more interested in playing the blame game than solving problems.
Sigh, I miss the Aussies. I sometimes used to wait to submit a TAR
until they were on shift just because I got better. faster
Hi Charlie
Can u pls. send me the publisher name or any more details about this book,
as I am new Oracle DBA field.
I am very thankful to u for this co-operation.
Thanks
Lucky
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, February 14,
If this is for you to play with, it doesn't really matter. Put it all on
/u01. But if this is a db for practical use (dev/test/prod), follow the best
practices and keep them separated. ie:
/u01 binaries, log files, etc...
/u02/oradata/SID/
/u03/oradata/SID/
/u04/oradata/SID/
and so on...
The
On Wed, Feb 19, 2003 at 08:14:13AM -0800, Thomas Day wrote:
Try looking in the Event Viewer. For Win 2K that's under START - SETTINGS
When you are forced into using a toy operating system (read: unix
bigot) like this you need to have tools that show you what the toy is
doing to you. Kind
I think it would be more appropriate to say.
Today is a good day to die!
From: Gogala, Mladen [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Programming languages that make DBA's lives easier
Date: Wed, 19 Feb 2003 09:59:12
Title: Message
I had
a meeting once with the VP in charge of support for the south when I worked for
my last job in Texas. We had been having major support problems with
Oracle and were tired of paying such high prices for crap.
One of
the things he told me was that you can always tell
Title: Message
From the Fine Manuals
Theoperating systemfiles are deleted
too, when an Oracle Managed logfile grup or member is dropped.
HTH.
Arup Nanda
- Original Message -
From:
Ramon E. Estevez
To: Multiple recipients of list ORACLE-L
Sent: Wednesday,
See Jonathan Lewis' paper on ASS Management:
http://www.jlcomp.demon.co.uk/bustbits.html
HTH,
A~
Jay Hostetter wrote:
I'm continuing to introduce myself to 9i. I've been reading about Automatic Segment Space Management, and I just wondered if anybody had any positive/negative experiences
Lyndon, I wish I knew what caused the problem. And I have no idea how the monkey that
broke it solved the problem. I think it had something to do with removing folder
shares, but I'm not sure.
I am so busy whipping out volumes of pl/sql code that I can't stop to understand why.
I have to
No, just give it a little test.
Anjo.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, September 04, 2002 10:58 AM
At 02:03 AM 9/4/2002, Anjo Kolk wrote:
Yep and you have given the answer yourself. It is the number of indexes.
I
think
Title: Message
Tks
Arup
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Arup NandaSent:
Wednesday, February 19, 2003 2:19 PMTo: Multiple recipients of list
ORACLE-LSubject: Re: Question about log files
From the Fine Manuals
Title: RE: Question about buffer cache
I have indexes in a 16k page size tablespace.
I have the following init.ora parameters:
db_block_size=4096
db_cache_size=600M
db_keep_cache_size=200M
db_16k_cache_size=200M
If I alter an index to put it in the keep pool, how does Oracle hande the
Rich,
Was your sys schema accidentally analyzed? It may pay to drop stats on all
the sys objects using BOTH
(1) analyze
and (2) dbms_stats
HTH
Arup
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, February 19, 2003 11:03 AM
Hey all,
In a very limited tests that I performed with ASSM (quite some time ago), I found that
it tends to use a bit more space than non-ASSM. Something to keep in mind when FTS is
used to access tables.
Not sure if this changed in 9.2.0.2.x.
- Kirti
-Original Message-
Sent: Wednesday,
My manager asked me to assess how much smaller our backups would be if we
were doing incremental backups of our database files, instead of the usual
hot backups.
We are running 8i on UNIX.
I know that the answer is it depends and you can't really know 'till you
try, but we are just looking for a
Perl for Oracle DBAs
By Andy Duncan, Jared Still
Publisher : O'Reilly
Pub Date : August 2002
ISBN : 0-596-00210-6
Pages : 620
Their next book will be .NET for an Oracle DBA, so called bigfoot book
-Original Message-
From: Lucky Sharma [mailto:[EMAIL PROTECTED]]
Sent:
You forgot to export new ORACLE_HOME.
-Original Message-
From: Scott Stefick [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 19, 2003 12:04 PM
To: Multiple recipients of list ORACLE-L
Subject: lsnrctl status
Hello all,
HPUX 11.11 Oracle 8174, 9201 and 9iAS 90201
I
Please tell us what caused the problem and how you solved it.
--
Lyndon Tiu
Quoting Koivu, Lisa [EMAIL PROTECTED]:
Hi Wayne,
Thanks so much for responding.
I guess my lack of knowledge of Windows 2000 administration has
just bit me in the ass. A description of a paintbrush-style
Great list, but don't forget Tom Christiansen et al.'s Perl Cookbook.
One of the best books written about anything, in my opinion.
If someone's already a ksh or C programmer, then I think the beginning
Perl library should include Wall's Programming Perl and the Perl
Cookbook. To connect to
Arup,
Just picking up the thread on the BBWs. (Btw, I asked this question in this
list - never got an answer!) The following undocumented parameter limits the
numbe of CR copies in the Block buffers.
Name Value
Title: Message
Some
of the staff know what they are doing.
Once
in a while you will fall on one that is still learning... ?
Patrice Boivin Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et
Exploit. des systèmes Technology
Services | Services
technologiques
Actually assuming you checkpoint or commit at least once between backups it would not
make any difference at all. An incremental backup catches changed files since the
last backup which will typically be all your data files. SCN's get updated in all
headers if any thing changes.
Allan
Patrice,
Another list participant may verify or nullify this, but I think that both will take
the same space/time. In either case, it should be backing up the entire datafile.
Doing incremental backups with RMAN stands a good chance of saving you space/time as
it can back up only changed
The ORACLE_HOME is being exported.
Here is the contents of the script that I call to set the 8174 environment
upon login:
/*
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/817
ORACLE_SID=FPRD
LD_LIBRARY_PATH=$ORACLE_HOME/lib
TNS_ADMIN=/u01/app/oracle/product/9201/network/admin
repeat after me I want to speak to the duty manager. Keep repeating
until they GIVE you to the duty manager.
It still works.
or, easier, make friends with someone in Support who actually has a
clue or two... then have them check on your Tars. This also works but
you need a large slush fund for
Title: yapp_pack.zip
List,
I've recently run this EXTREMELY useful set of scripts from miracle A/S to chart various info from my statspack snapshots. They work without modification on 8.1.7 but not on 9.2.
I was just wondering (before I attempt to modify myself) if anyone had updated these
We are just ramping up a version 9.2 OLTP database on Sun Solaris 2.6.
We didn't see any issues with a small number of users but we are seeing a
lot of resource manager waits with a large number of external clients.
We are wondering if perhaps we should turn Resource Manager off. It
defaults
How do you rename files in RAC databases?
When dealing with single instance db
1. shutdown
2. startup mount
3. copy file to new location using OS util.
4. alter database rename file...
5 startup.
But now we have gsdctl, srvctl... So, what is the procedure ti rename file?
We are using Tru64, so
Title: Message
Perhaps my luck has been poor. In truth, I find most of what I need
on Metalink, requiring ITARS infrequently. Also given that we pay for this
I am not entirely patient with the less informed among them.
-Original Message-From: Boivin, Patrice
J [mailto:[EMAIL
Allan, I disagree. From what I remember, rman incremental backups are also
block-level, hence the savings in tape/disk and time. The tradeoff is at restore
time.
Unless you are talking about a Veritas utility? There's no other way I know of in
Oracle to execute an incremental backup
1 - 100 of 155 matches
Mail list logo