Steve has an a detailed artical on his website
http://www.ixora.com.au/tips/creation/online_log_files.htm
Rgds, Ken Heng
IBM GSA - Oracle DBA
Level 32, 201 Elizabeth Street
Sydney, NSW 2000
Phone: 02-9396 8298
Mobile : 0401-144 794
Email : [EMAIL PROTECTED]
Hi gurus
can you help.. I need to move one database from AIX to HP machine.
Is there any significance for the RECORDLENGTH parameter at the time
of export/import. I read somewhere it's important when operating systems
are different..
thanks
Banarasi Babu
-Original Message-
Sent: Frida
hi, friends:
From many oracle tuning manual, I found words like stripe the redo log on
different disks, this should boost redo performance.
But according to my experience, every single redo write(this size should not
be much larger than average transaction redo) is always quite sm
Hi,
I am using neither MTS nor RMAN. I set the large_pool_size to zero now. I
also set the java_pool_size to 32768 and it works in oracle 8173, although I
seem to remember the minimum java_pool_size was 1M in oracle 805. Also I had
ORA-04031 error during exp (in oracle 805) and I increased the
Huh!!!
If the backup was made while the repository was in use for
other backups, it may be in a logically inconsistent state from
the RMAN perspective.
That sent a shiver through the spine, Jared. I admit, I never tested the
recovery of the RMAN repository and never (shame on me!) considered t
Oracle needs some amount in java_pool_szie to startup; not sure how much.
From: "BigP" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: Re: v$sgastat question
Date: Thu, 09 Jan 2003 16:37:16 -0800
MIME-Version: 1.0
Received
It will default to 32k, even after setting it to 0 in init.ora file... (8.1.7.x)
- Kirti
-Original Message-
Sent: Thursday, January 09, 2003 6:37 PM
To: Multiple recipients of list ORACLE-L
Do you really need java pool ? If not get rid of it . set it to 0.
- Original Message
[EMAIL PROTECTED]> desc v$license
NameNull?Type
---
SESSIONS_MAX NUMBER
SESSIONS_WARNING NUMBER
SESSIONS_CURRENT NUMBER
SESSIONS_HIGHWATER
I don't think it's gonna make a big difference for him. He has 1mb.
Setting java_pool_size to 0, Oracle will still allocate a minimum
of 32k. Doesn't save a lot.
-Original Message-
Sent: Thursday, January 09, 2003 7:37 PM
To: Multiple recipients of list ORACLE-L
Do you really need java
Check your previllege !
> -Original Message-
> From: Kader Ben [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, January 10, 2003 5:56 AM
> To: Multiple recipients of list ORACLE-L
> Subject: fnd_global user_id
>
> Hi Listers,
>
> I'm running concurrent program to create user (that's
> ca
Steve - That was it. Thanks for the humor.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, January 09, 2003 6:14 PM
To: Multiple recipients of list ORACLE-L
Never heard of the q29_6 parameter. :-)
Looks like excess glue spilled
Do you really need java pool ? If not get rid of it . set it to 0.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, January 09, 2003 2:44 PM
> Guang,
>
> Earlier I posted a response to check java pool and large pool parameters.
> Any
Title: RE: RE : RMAN Repository
Never heard of the q29_6 parameter. :-)
Looks like excess glue spilled during a cut and paste operation.
-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 09, 2003 3:24 PM
To: Multiple recipients of list
Guang,
Earlier I posted a response to check java pool and large pool parameters.
Any progress on that?
Arup.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, January 09, 2003 3:15 PM
> Then you should look into statspack and get a copy
Hello all...
I'm running 9iRAC 9.2.0.2 on Linux 2.4.20 kernel. This is based on the
Oracle Linux+Firewire project:
http://otn.oracle.com/tech/linux/open_source.html
I'm getting the ORA-29702 during database create.
Any ideas?
Sean
-- sqlplus, create database --
SQL> onnect / as sysdba;
Conn
Title: RE: RE : RMAN Repository
Hey
Brian,
I only
talk about the way it SHOULD be... not what I actually do.
:-)
I
confess to presently using the suppository, er a repository but
anticipate just using control files
after we upgrade to 9i with its enhanced RMAN features. I have a shell
Hi ,
Some precisions :
If you have ONLY LOST the controlfiles after a clean shutdown
(normal or immediate) you can just :
1) startup nomount
2) recreate the controfiles (CREATE CONTROLFILE command)
3) open the database in NORESETLOGS mode.
If you have ONLY LOST the controlfiles after a shutdown
when I try to create recovery catalog I am getting following error , I have
100M datafile for rman tablespace . what should be problem ?
ORACLE error from recovery catalog database: ORA-01658: unable to create
INITIAL extent for segment in tablespace RMAN
Bp
--
Please see the official ORAC
Title: RE: RE : RMAN Repository
You can have a very large site and still do just fine without an RMAN
repository. RE the "non-database solution," Oracle has already done that,
it's called the controlfile. I tend to agree with Robert F. who "wrote the
book" on RMAN where, in another post he wro
Jeff,
You are right. It's still possible to create the controlfile by hand using
the CREATE CONTROLFILE command. You can do, in fact you *have* to do
incomplete recovery "recover database using backup controlfile until cancel"
However, a BIG however, here; you MUST know all the file names th
when are you going to put tablespaces back in
normal mode .
I think you should split the mirror and the put the
tablespaces in normal mode . Its not required to to suspend the db prior to
split .
disclaimer : Just thoughts no real
experience
- Original Message -
From:
Hot backup of the repository is fine as long as you can be
assured that all files needed for a complete recovery are
going to be available.
Recover a hot backup of an RMAN repository to another
server using imcomplete recovery, ( your RMAN server
burned to a crisp, drives and all ), and you may
Brian - You may want to be aware of the following parameter:
q29_6There are several new features that are present in the Oracle8 control
file, so that it is significantly changed from and larger than the Oracle7
control file. The Oracle8 control file stores information that is of use to
RMAN. Some
Hi,
We're getting
ready to implement split mirror backups for the first time and wanted to check
on what others are doing. The thought was to put the tablespaces in backup
mode, split the mirror, backup the mirror, and then resynch the drives.
The split mirror would be backed up using an
I shutdown the database and backup the oracle directories.
Jared
"Jay Hostetter" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/09/2003 12:54 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE
Mike,
Compaq SAN and Tru64 and direct I/O have been nothing but trouble in my
recent experience. I put in over 35 hours over Christmas and last
weekend working on recoveries of system crashes. Our problem appears to
have been relating to the fact that several machines had mount points on
disks
BTW, for those of you stuck with MS Lookout as your e-mail reader, you can
prevent the senseless download of images when viewing/previewing these HTML
messages, whose links often contain encoded IDs so the authors get better
ways to track you down and sell your e-mail addresses.
1. In IE, under "
Hi Listers,
I'm running concurrent program to create user (that's
call fnd_user_pkg.CreateUser procedure) on 11i but the
program fails because the fnd_global.user_id return
-1!
Can someone help me how resolve this problem?
Thanks you so much,
Ben
The database containing RMAN repository does not need to be up 100%, only
when the backup is going on restoring. Therefore, in many sites, DBAs can
actually shutdown the database and take cold backup, just for convenience
sake, if not anything else. Jared wanted to know if anybody used hot backup
f
1/2. Not necessarily. You only need to
suspend database if your hardware won't let you split the mirror
without
suspending IO. I worked on EMC which
doesn't require that. So all you need to do is put tablespaces
into
backup mode, split the mirror and end
backup mode.
3. Applicat
Rick,
There is no such view, but can be very simply obtained by turning on
auditing and placing auditing for connects for user. Later you can aanalyze
the connects and disconnects in a given time period to get max concurrent
access.
HTH.
Arup Nanda
- Original Message -
To: "Multiple reci
Not having used RMAN since it's inception, I'm a little confused. Why
couldn't you backup the DB hot, provided it wasn't using RMAN or at least
that repository?
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex
Title: RE: RE : RMAN Repository
I
agree Steve, and thanks for the info.
Do you have any procedures to cover backup logic
holes if you
have
to rebuild the controlfile for some reason (Ie.. maximum files reached
etc)
Do you
accept losing the backup history and cross fingers or ... have
pro
True, but how you associate thread# in PerformanceMonitore with Oracle's
spid?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, January 09, 2003 3:59 PM
>
> I believe you can if you use performan
Have any of you all
seen this error-and really understand what causes this type of
situation?
The scenario is
where we have several sessions up and running; and a couple will get this error
when we try to use the TAF functionality while ripping the legs out from
underneath an Orale instance
Yeah that's what I thought.
Thanks
Stephane
Farou
Jared,
I do. Actually, I back up the "other" master in the multi-master setup, in
order to reduce load on the main database. But now that you have asked the
question, I am beginning to wonder why I ever thought of that. Restoring
will not restore the untransmitted transactions (it's asynch replica
I believe you can if you use performance monitor and chart by thread.
Rick
"Igor Neyman"
[EMAIL PROTECTED] wrote:
>
> Hi All,
>
> V$LICENSE will show max # of concurrent users since instance startup. Is
> there another view or something to determine max # of concurrent sessions
> for
> each schema?
>
> Thanks
> Rick
>
AUDIT on connections, and good ol' SQL ...
--
Regards,
Step
Brian - Not disputing that at all. I even enjoy it when I had some spare
time to sit down and do just that. But why create and maintain something
when Oracle offers it built-in. I can even envision a manager saying "I paid
you for WHAT?? We'll consider that time as counting against your vacation".
Is it an old fashioned backup (non-rman)? I export our rman repository and ftp the
.dmp file to another server.
Jay
>>> [EMAIL PROTECTED] 01/09/03 03:30PM >>>
I do a cold backup of my repository daily.
Replication of it is not a bad idea, as Arup mentioned,
though I haven't tried it myself.
Title: Message
OK,
everything I've read so far on using Direct I/O with an Oracle database says
it's a bad idea. Either performance problems or block corruption may
occur. The notes on metalink (132391.1) refer to Tru64 5.0A and 5.1
but not 5.1A (to which we've recently upgraded). So is a
Ruth,
That's "Jack Sh&^".
Dick Goulet
Reply Separator
Author: "Ruth Gramolini" <[EMAIL PROTECTED]>
Date: 1/9/2003 11:19 AM
I thought that was Jack. Maybe you don't know Jack.
Ruth
- Original Message -
To: "Multiple recipients of list OR
I do a cold backup of my repository daily.
Replication of it is not a bad idea, as Arup mentioned,
though I haven't tried it myself.
Speaking of backing up the RMAN repository, does anyone
back them up hot?
Seems to me that would not be a good idea.
Jared
"Ruth Gramolini" <[EMAIL PROTECT
Umm I'll have to apologize for thinking too quick and letting my inner child
do the typing.
I haven't had to do a manual create of a control file yet (and hope not to).
My paranoia would not allow me to not have a backup control file and
init.ora file etc around.
If you have multiple instances of t
You can make up a universal script that logs into each an gets the
appropriate info. Just takes a little thinking -its a little more
time but can be done.
Brian
-Original Message-
Sent: Thursday, January 09, 2003 2:34 PM
To: Multiple recipients of list ORACLE-L
Gene - I would think yo
Wrong...I _think_ :)
If he rebuilds them using the correct file placements then
it will work. The only problem is that he will have to open
RESETLOGS and incomplete recovery will be impossible. But
if he has all of his datafiles and is only missing control
files then he can startup nomount and cr
Hi All,
V$LICENSE will show max # of concurrent users since instance startup. Is
there another view or something to determine max # of concurrent sessions
for
each schema?
Thanks
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat Ci
Guang - If you're not familiar with it, go to http://www.hotsos.com/ and get
Mogens Norgaard's paper, Introducing the V$ Wait Interface. Where is the
database spending it's time? What's the bottleneck?
-Original Message-
Sent: Thursday, January 09, 2003 1:05 PM
To: Multiple recipients
HTH
===
If someone ever says "You don't know Jack Shit", here is the perfect
response. Who is Jack Schitt?
The lineage is finally revealed. Many people are at a loss for a
response when someone says "You don't know Jack Schitt." Now you can
int
Then you should look into statspack and get a copy of "Oracle Performance
Tuning 101".
-Original Message-
Sent: Thursday, January 09, 2003 2:05 PM
To: Multiple recipients of list ORACLE-L
Hi:
My objective is to see if there is anything that I can change on db setting
to increase the pe
Gene - I would think your site would be just what the repository was
designed for. You could use a single repository for all 25 databases. Then
each day you could execute a simple query and receive an exception report
that tells you any backup vulnerabilities for any of the 25 systems. Without
the
Robert - Thank you! I will go with the KISS principle anytime.
Gene>>> [EMAIL PROTECTED] 01/09/03 11:45AM
>>>
I actually find the repository of little
use. If I have an enterprise with many databases then I will use it for
reporting but that's about it.
It just seems to complicate the overal
Ference,
Oracle on Windows runs as one multithreaded process, so you wouldn't get
specific session id sorting list of processes by CPU.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, January 09,
Steve - My theory is that if your site is sufficiently large to be worth
considering an RMAN catalog configuration, then you can easily find a
location for it. For us, that was easily solved. If Oracle had created a
non-database solution, then that would have become a development project all
its ow
I like using a repository because I hate to document. Every is there for
the asking.
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, January 09, 2003 1:49 PM
> Paula, i like it and the respository, cause its just my anal-
> retenti
No. It would be like getting amnesia and just using
the memories of someone that looks like you.
The data stored in the control files is unique to
that database. It contains location of files, database name, recovery info etc.
David L Phillips
Database Consultant (8i OCP)
Digital Concep
Hi:
My objective is to see if there is anything that I can change on db setting
to increase the performance, without modifying application code (BTW, we
already looked at all application code at least 5 times and would like to
see if our db setting is good).
Guang
-Original Message-
D
OID is the *ONLY* LDAP solution certified for use by Oracle software.
However, they do seem to support some sort of "replication" between OID and
other LDAPs. For example, if you want to use SunOne for Oracle names
resolution (as opposed to TNSNAMES.ORA or ONAMES) you will still need to
have OID i
But if u look at the control file dump script . It
doesn't say anything about creation date or scn or anything . All it has
is list of datafiles , logfiles .. etc. If my other db on another server is
layed out exactly same . wny can't I use that control file , just change db name
.
-Bp
> BigP wrote:
>
>
>
>
> If I loose all my control files can I restore them by using create
> control file dump from a similer database .
>
>
>
IMHO it is safer to do a manual 'create control file'. Similarity is
always just up to a point and gives you a false sense of security. And
BTW if y
Since you are on Weenie-doze:
go to task manager (3 finger salute [alt+ctrl+delete]), and order by CPU
descending, then look at the PID, make a note of it, and run this script,
entering the PID:
column log_tim format a18
col username format a12
col osuser for a12
set linesize 132
set verify off
I thought that was Jack. Maybe you don't know Jack.
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, January 09, 2003 1:44 PM
> For those not familiar with American Slang, saying "You don't know dick."
> means "You don't know anythi
The earlly versions of rman suggested that you put a 2nd recovery catalog
in one of the databases you are using the "real" recovery catalog for. Then
you use this to record the backups of the recovery catalog database. I
never headed this advice, altho I do use a recovery catalog for all
produc
Paula, i like it and the respository, cause its just my anal-
retentiveness coming out about having 2 places to easily be able to
recover(the repository and control file).
joe
> This message is in MIME format. Since your mail reader does not
understand
> this format, some or all of this messag
If you have good enough information about all your database
files.
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message -
From:
BigP
To: Multiple recipients of list ORACLE-L
Sent: Thursday, January 09, 2003 1:18
PM
Subject: lost control files
For those not familiar with American Slang, saying "You don't know dick."
means "You don't know anything."
It was a pun I just could not resist...
-Original Message-
Sent: Thursday, January 09, 2003 11:06 AM
To: Multiple recipients of list ORACLE-L
The first time I read this it did not
Title: RE: RE : RMAN Repository
>If I need a database to backup a database then do I need
another database to backup the database that backed up the original database?
Exactly my thoughts.
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message -
From:
Orr, Steve
Title: Message
Glad
someone is interested. My sister also did it for her kids with amazing
results..
http://images.amazon.com/images/P/0671631985.01.LZZZ.gif
Teach Your Child
to Read in 100 easy lessons.
Book : Teach your child to read in 100 easy
lessons.
If you
train a 4 year o
If I loose all my control files can I restore them
by using create control file dump from a similer database .
Title: RE: RE : RMAN Repository
Yeah but do you have to pay for another Veritas NetBackup license and server to backup the catalog? If just have one database server and one database license why should I have to buy another license and install another 1-2GB of Oracle software on another server?
The first time I read this it did not make sense, but now the light bulb has
finally come on. I'll just add these folks to the s&%$list.
Dick Goulet
Reply Separator
Sent: Wednesday, January 08, 2003 4:30 PM
To: Multiple recipients of list ORACLE-L
Tim,
* Leftover DLL's that can cause problems
* The directory structure is not Win2k
* I don't know what else, I trust my SA's judgement. :)
Jared
"Jackson Dumas" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/09/2003 12:03 AM
Please respond to ORACLE-L
To: Multiple recipient
Thanks, no problem. :)
Rachel Carmichael <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/09/2003 07:28 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:to subscribe to the ot list
I have been
I asked nicely once.
Please limit this to the OT list.
Jared
"Boivin, Patrice J" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/09/2003 04:53 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:
> The overhead of the repository database is more. With the initial
releases of RMAN (EBU) Oracle was rightly
> criticized for the fact that you had to backup the database that holds
information about the database you want to backup.
> Getting rid of this silliness seems reasonable to me.
Why
Dennis - I am now running 8.1.6 & 8.1.7 w/out RMAN, soon to upgrade to
9.2 then implement RMAN. I have 25 db instances. I am thinking of
using RMAN w/out a repository unless there are great reasons not to
:)
Gene>>> [EMAIL PROTECTED] 01/09/03 11:24AM
>>>Gene - Which Oracle version(s)? How
Actually for recovery of the control file, you have to be in nomount mode.
RMAN will connect to a database as long as the instance is up. So, to
recover
from square one you need to get the instance runninng. In 9i, it's generally
possible to start an instance without even a parameter file, which i
Title: RE: RE : RMAN Repository
The only things you can't do with
controlfile RMAN/database metadata is:
1) use previous "incarnations" of the
database for recovery;
Actually, you can, it's just a manual process. This is
documented in the RMAN book. Also, in 9i you can do automated backup/
One simple, and often helpful, option is to
query v$sess_io
Structure:
sid,
block_gets,
consistent_gets,
physical_reads,
block_changes,
consistent_changes
Look for any big numbers - if they are in
physical_reads, the user may have been
hammering the filesystem, the other figure
Here
is a quote from my Damager when I send him the link to this marvelous
product:
"
Where do I signup. At a buck and three quarters
an hour I'll replace all of you slackards."
And
told him he will probably get what he paid for :)
-
Kirti
-Original Message-From: Fin
Title: RE: RE : RMAN Repository
I find it useful for organizing and keeping track of my backups so that during recovery it is as simple as running pre-scripted queries to see what I have available - geez am I the only one who likes RMAN and doesn't think it makes things that difficult - really
Thanks Robert. I just checked your Oracle9i RMAN book and yes you do provide
the steps to recover the control file from the RMAN backup. I can see the
step I missed when I previously tried it myself. Thanks for mentioning that.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-
I actually find the repository of little
use. If I have an enterprise with many databases then I will use it for
reporting but that's about it.
It just seems to complicate the overall
administrative costs and thus, the burden/benefit ratio is not all that
good.
RF
Robert G. FreemanTechni
I hadn’t heard that the repository
was going away.
I did hear, however, at the IOUG meeting last
year, that the reporting mechanisms were going to be significantly enhanced, putting
it on par with the repository-based reporting. That came directly from
one of the Oracle RMAN strateg
Robert.. Using controlfile only recoveries...(not using catalog)
We have people spouting that we should only use controlfile
recoveries with RMAN because an Oracle instructor said so and
said this is the future direction...
I would love to do it..but what if I
Title: Message
Robert, I am scanning through your book now for the tape write error code
and I don't see it. I look at the documentation
and I cant
tell which will arise due to the bad tape error. I am on the
tail end of implementing RMAN on HP and
trying to
write some
Gene, i consider it a good redundancy method for recovery.
put the repository on a 24x7 machine, that way if you lose all of the
controlfiles you can still easily restore/recover.
my 2 cents worth.
joe
> This is a MIME message. If you are reading this text, you may want to
> consider changin
Title: RE: RE : RMAN Repository
If you aren't using a repository all you have to do is make sure control file backups are part of the routine. There are 2 ways to backup the backup metadata: 1) the RMAN repository database; 2) backup controlfiles.
Functionally and operationally they're prett
Title: Message
Keep in mind that our public school education system exists
for the purpose of training (with some education) brainless jocks. They
are trained to bounce a ball up and down or run around on a field of
grass. This exists so that colleges, TV networks, professional sports
team
Title: Message
"manual"?? Details?
-Original Message-From:
Spears, Brian [mailto:[EMAIL PROTECTED]]Sent: Thursday,
January 09, 2003 9:04 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: Orawomen
The
public education is so pathetic... I took the mannual produced by US
One question, don't you have to have the database in no mount state to
recover the controlfile in 8i? You do in 8.0.x.
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, January 09, 2003 10:24 AM
> 9i Offers automated recovery of the
Gene - Which Oracle version(s)? How many instances will you be backing up?
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, January 09, 2003 9:50 AM
To: Multiple recipients of list ORACLE-L
Interesting thread, since I am just embarki
And it keeps getting funnier every time I read it! :D
Rich
> -Original Message-
> From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 08, 2003 11:15 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Orawomen
>
>
> I prefer it to be Mary showing me
Title: RE: Which session is killing performance?
HI Craig, try these scripts
set linesize 200
column username format a15
column idle format a10
column machine format a22
column terminal format a15
column program format a15
select sid,
serial#,
username,
-- process,
Title: RE: Query optimization
Have you tried NO_EXPAND?
Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063
-Original Message-
From: Krishnaswamy, Ranganath
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 0
I have been getting requests on "how do I subscribe" to the oracle-l-ot
list. In order to help keep off topic posts OFF this list, if you wish
to subscribe to the OT list, please send an email to
[EMAIL PROTECTED]
my apologies to the list and to Jared for this admittedly off-topic
post
Rachel
Title: RE: Oracle DBA Profession hard?
Hard? Ha! Before getting into computers, I was an aircraft mechanic for 24 years. Nothing like changing 250 pound wheel and tire assemblies (12 was my record) on midnight shift outside in the cold and rain for LESS money than I got in my first job in IT.
Interesting thread, since I am just embarking on using RMAN. If the
repository is to go away then why bother learning the intricacies of it.
Has anyone else heard the RMAN repository was going away? It appears much
simpler to setup w/out the repository. Besides reporting advantages, what
In 9i Oracle can handle control file recoveries just fine without a
repository if configured correctly.
In 8i, you can actually recover the control file even without a repository
but you have to use the dbms_backup_restore package to do so.
I have not heard anything about the repository going away
1 - 100 of 124 matches
Mail list logo
