I am not sure that this answers Mladen's question. A brute force solution, not
necessarily very efficient and questionable, security-wise, would be to make
user_dump_dest accessible through utl_file, check v$session and see for each session
whether there is a matching .trc file - and in fact
Ron,
there's not much choice in what you install in 9iAS. You pretty much select
a pre-defined type of install. If you choose an option that includes Portal
you should be fine.
regards,
Mike Hately
-Original Message-
Sent: 15 January 2003 20:35
To: Multiple recipients of list ORACLE-L
At 11:13 PM 1/15/2003, you wrote:
David
You might want to look at
select *
from t1
minus
select *
from t2
Note that if you don't know that one table is always a subset of the other,
you need to do
(select * from t1
minus
select * from t2)
union
(select * from t2
minus
select * from t1)
Larry,
As far as I am concerned my present problems are linked to an unpleasant tendency
of MTS to freeze, and, while looking at $ORACLE_HOME/rdbms/mesg/oraus.msg for a
possibly suitable event to set to get some information, I bumped into 10975 which may
possibly be useful in your case.
Tony,
Good to see your fingerprints here!
I had always gone on the theory that I would need at least two of the
licenses, one for production and one for the standby server. I hadn't
thought about one for the DR site, on the theory, that since DR was up
and running ONLY when production was not,
I was trying to make sure you went into writing with open eyes. I give
everyone who asks me about writing the same scare talk, if you still
want to write the book when I'm done, you're doing it for the right
reasons :)
--- Jared Still [EMAIL PROTECTED] wrote:
I can certainly echo the
A while back I posted a link to a website that has hundreds of Oracle links. It's a
site that is good for Unix and Windoze bigots, pick your flavor. Well, I lost my hard
drive and my internet favorites. If anyone has that link that I posted I would
greatly appreciate it if you can now post
Title: RE: Win2k/8.1.7/SQL Question
Have a look at the SQL
Referenceguide in the 8i docs. It says that 8i is broadly compatible with
the ANSI SQL-99 Core specification, that explains why the SQL listed below works
with 8i.
Ade
-Original Message-From:
Vergara, Michael (TEM)
Ron and Denis,
I discovered a parameter to do it, called cpu_count that I can limit the
number of processors used for Oracle. Now, my new question is: if I have a
server with 2 processors but i'm using only one for Oracle (with this
parameter), do I have to buy 1 or 2 processors license?
The
I've been saying all along that writing technical books is NOT the way
to early retirement :)
I've done both authorship and technical editing. Both have advantages,
both were done for several reasons, none of which included riches. In
the case of the authorship, I wanted to help spread knowledge
Richard,
The IDS has a deamon running in background (by the user netrangr) and every
5 minutes a IDS trigger is called and tries to connect to Oracle. He
generates an log error and the sqlnet.log is generated too...
Thanks
Flávio
-Mensagem original-
De: Richard Ji [mailto:[EMAIL
Hi all,
can anyone tell me, if the Oracle PID has to be the same as the Windos
process id ?
I ran the following script, to find ou, if a hanging process is still
connected to the database:
select
substr(a.spid,1,5) pid,
substr(b.sid,1,5) sid,
substr(b.serial#,1,5) ser#,
Good Article Dennis, and I am living proof that you CAN get a technical book
contract even in a soft market.
Rachel is right... isn't easy (I knew you were, Rachel, but I am doing it
anyway... it is still THE book that I wish I had in my hands a year ago).
I'm hoping to nearly pay off my trip to
Flávio - Well, Oracle warns you not to mess with the cpu_count parameter.
Also it seems to be very O.S. specific. My guess is that it is more of a
reference in case your program needs to know the number of CPUs.
Another issue is whether the O.S. would honor this setting. You haven't
mentioned
dbms_system.read_ev is mentioned in the Oracle Internals seminar entitled
Dumps, Crashes and Corruptions...
created by dbmsutil.sql
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Technology Services| Services
Was this it? http://www.orakle.com/
Greg
-Original Message-
Sent: Thursday, January 16, 2003 5:29 AM
To: Multiple recipients of list ORACLE-L
A while back I posted a link to a website that has hundreds of Oracle links.
It's a site that is good for Unix and Windoze bigots, pick your
It was demonstrated to me recently that if one used NT authentication with a non-IE
browser one's NT password was available to the writer of the ASP script. Encryption
between the browser and server is inmaterial. The password has already been
decrypted. If one used IE then credentials
This is great. I was wondering what happened to Atul's page.
Ken Janusz, CPIM
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 16, 2003 7:43 AM
Was this it? http://www.orakle.com/
Greg
-Original Message-
Sent:
Dave,
Is this the one that you were looking for. I don't recall where I picked it
up from but it was probably this list
http://www.orakle.com/
John
-Original Message-
Sent: 16 January 2003 10:29
To: Multiple recipients of list ORACLE-L
A while back I posted a link to a website that
Hi DBAs,
Has anyone had trouble installing Oracle 8.x on Win 2k Service Pack 3?.
When I tried installing 8.1.6 and 8.1.7 the installer does not start.
Oracle 9.x installs fine.
I do not know if it related to SP3 or not as I was able to install on
similar server with SP 2.
Thanks
Rick
--
Please
I don't know if this is it but, I find the following very useful:
Atul Mehta's o r a c l e World
http://www.orakle.com/
-Original Message-
Sent: Thursday, January 16, 2003 5:29 AM
To: Multiple recipients of list ORACLE-L
A while back I posted a link to a website that has hundreds of
Your Apache Jserv log files would be under
/export/home/u01/app/oracle/product/9.2.0/Apache/Jserv/log
At 07:43 AM 15-01-03 -0800, you wrote:
Hi!
I am trying to configure the Enterprise Manager Console to
be accessed from a web browser. Does anybody have any experience with
this?
My client is
Raj,
I had seen Note 97926.1. Unfortunately, error 25408 is not itself
mentioned. The example error is there is error 25401.
My developer has had to try to code to capture different errors and she
was stumped by error 25408. A search of
Metalink for error 25408 did not reveal much [although I
Title: RE: Database tracking
We were thinking of an automated message calling all damager types ... especially in the middle of the night ...
in a very thick voice ... Hello .. name this is your heartbeat calling, we have a problem !!
As none of us had our résumé's ready, this idea was
Title: Message
Dave,
Was it this one? You might be able to find what you need at this
site. http://web.singnet.com.sg/~petermag/oracle.html Dave-Original
Message-Sent: Tuesday, October 22, 2002 8:39
PMTo: Multiple recipients of list
ORACLE-LSHi,Does anyone know of any web site that
List,
I have to move data on a regular basis between two instances of 8.1.7 on
two different UNIX servers. The schema is exactly the same. There are 543
tables to be refreshed. It is only the new data on one of the servers
to move to the other. What is the best and easiest way to do this?
I just renewed our Cognos support. It took 2 emails and a 10 minute phone call (of
which 8 minutes were spent talking football - go Eagles!).
Contrast this with our Oracle support negotiations which have been going on since
SEPTEMBER! I'll spare you the details, but let's just say that I
I realize that a package can't be recompiled while a session has it open.
How do I identify which session has a package open?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
Jared,
why doesn't it seem right?
in the case where we are running a standby database, are we not using the
software? sure, the users are not directly connected. but every
transaction that they enter in the primary database is being posted to the
standby. if we were not required to pay for
TriState Oracle User Group November Meeting
DateLocation
Tuesday January 28, 2003 5:30 - 8:30 PM1200 Ross St Amarillo Texas
79102
Tentative Schedule
5:30Registration
5:45Welcome
6:00Materialized Views
List,
Oracle 9i supported multiple block sizes, I am wondering under what circumstancesone would setup a database with multiple block sizes?
Jos
Yahoo! Greetings
- Send your seasons greetings online this year!
For question 1.
(920)/oracle/app/oracle/admin rman nocatalog
Recovery Manager: Release 9.2.0.2.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
RMAN connect target sys/password@sid (NOTE: sid is 8.1.7)
Recovery Manager incompatible with TARGET database: RMAN
Title: event parm question
Good morning everyone,
Has anyone ever had new errors or performance problems pop up after setting an event parameter? I set event=1410 trace name errorstack in my 8.1.7/w2k database to catch ora-1410 errors. Since I have done that, one query in particular fails
And it was a good book you wrote (Perl for Oracle DBA).
Any extensions/2nd editions? What about C# for oracle DBA?
-Original Message-
From: Jared Still [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 15, 2003 11:54 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Ideas
Hi there
If this is being run a P4 have a look on metalink for Pentium 4.
There is a workaround you need to follow.
George
George Leonard
Oracle Database Administrator
Dimension Data (Pty) Ltd
(Reg. No. 1987/006597/07)
Cell: (+27) 82 655 2466
That is not the specific one I had but it looks good.
thanks,
Dave
-Original Message-
Sent: Thursday, January 16, 2003 7:44 AM
To: Multiple recipients of list ORACLE-L
Was this it? http://www.orakle.com/
Greg
-Original Message-
Sent: Thursday, January 16, 2003 5:29 AM
To:
Hi Rick,
maybe you are running in the P4 bug, if your server has a P4 processor, here
is the worarround:
1. Create a temporary directory on your server.
2. Copy the entire contents of the Oracle RDBMS Server CD
to the temporary directory created in step 1.
3. Search the
Jos,
Per the comment made by an instructor at a recent Oracle 9i class. Having
the ability to use multiple block sizes in the database is primarily there for
transportable tablespaces which may not be the same size.
Dick Goulet
Reply Separator
Title: RE: Important - Oracle Pricing on Standby/DR/Failover databases
and how about Oracle saying something like ...
And in return to you making excess payment to meet our unrealistic demands, we will deliver bug-free software ...
Raj
Title: RE: Installer does not run on Win 2k Service Pack 3
Hi Rick, are you on Pentium 4 Processor? If so check out note 1312999.1 This has happened to me many, many times.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 16, 2003 9:09 AM
I know I've really enjoyed the technical reviews that I've done. I have
done about a half dozen or so and I can say that I have learned things
from every one. I would like to write books, but the muse has not given
me a technical topic yet, so I try to stay involved in tech reviews when
I get
Well, actually 8.1.7 can run without COMPATIBLE.
Quoting from the 8.1.7 Reference Manual [which is actually the 8.1.6
Reference Manual] :
COMPATIBLE
Parameter type: String
Syntax: COMPATIBLE = release_number
Parameter class: Static
Default value: 8.0.0
Range of values: Default release to
at a former employer per damagement direction... we had a perl script named
pageme which was called by our monitoring scripts whenever they detected and
event that required the on-call DBA be paged. the author of pageme had the
forethought to add a nopage feature. it looked for a file called
Does their has way to check rollback segment has optimal setup?
Thanks.
_
The new MSN 8: smart spam protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail
--
Please see the official ORACLE-L FAQ:
Pardon me, but I don't think I have got the full version of what Ethan sent.
(See below..)
Also, when my yesterday's post appeared in the list, the text from 'begin'
onwards was missing.
Is it possible that 'begin' is a keyword for the mail server?
Thanks regards,
Charu
-Original
There
are other reasons for this but...
I
think the primary reason is to server data warehouse functions. i.e.
if you have an oltp database with a small block size and want that data into a
staging area as quickly as possible, you are now able to use transportable
tablespaces because the
This is from the message Bruce Reardon posted yesterday:
Take a look at Steve Adam's
http://www.ixora.com.au/scripts/sql/executing_packages.sql
This script lists the packages (and other stored code objects) that are
currently being executed, and the SIDs of the executing sessions.
It is listed
Flavio,
Oracle will never go for that.
The cpu_count is used mostly to set defaults within the database. Setting it
to a lower figure than your actual number of CPUs won't stop Oracle
processes from running on all of the available processors. That's under the
control of your OS not Oracle. You
I wonder. Keeping the licensing language and policies vague and convoluted has
got to be good for Oracle in that no one, including themselves, can really
determine when one is in or out of compliance. Makes it easier to squeeze more
revenue from existing customers. On the other hand more
Check v$open_cursor, I tested a procedure and it showed up.
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 16, 2003 9:14 AM
To: Multiple recipients of list ORACLE-L
I realize that a package can't be recompiled while a session has it open.
How do I identify which
Just wrote this now (9.2). Run it while the compilation is waiting:
select *
from v$session
where saddr in (select kgllkuse
from DBA_KGLLOCK
where kgllktype = 'Pin'
and kgllkreq = 0
and kgllkhdl in
This is interesting...
So in the event of a true DR where a DR center has servers co-located and
are available for hundreds of potential customers do we need to pay for the
license on the box we use at the DR center if it is used more than 10 days a
year? Does one pay after they have gone over
Title: RE: Database tracking
Steve,
Oh ... we use a nomonitor script ... the resident script-kiddies (aka Unix SAs) love that stuff. But to give you an idea, I am paying T-Mobile $2.99 extra per month so my monthly text message limit is 550 messages. The email goes to my Outlook and phone.
Just wondering what will happen in this condition
.
supposse I have two tablespaces data_large and
data_small . with datafiles data_large01.dbf and data_small01.dbf . some
transactions affects tables in both tablespaces . Now one day I lost
data_small01.dbf data files . I thought of
C# for the Oracle DBA?
Local cell dwellers are now looking for the
source of manical laughter. ;)
Extensions? Well, maybe.
I'm working on a sqlplus break/compute type of
module that is still rather crude. It's been quite a
process, as I'm using aspects of OOP I've never
used, and a few other
Ooops I forgot it is that P4 bug!!!
Rick_Cale@team
health.com
Hi David
It sounds like Advanced Replication to me. The question is: Will the data
you move from instance A to instance B also be changed on instance B ? Is it
necessary to propagate changes back to instance A ? - Master-Master
Replication.
Will the data on instance B remain unchanged and only be
You could try v$open_cursor by SID, but I also use an X$ table (X$KGLLK)
with the following SQL:
select *
from x$kgllk
where KGLLKSNM=sid
This shows what SQL objects a session has touched. It usually gives me what
I need.
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: 16 January
v$rollstat has an OPTSIZE column which indicates if OPTIMAL is set.
-Original Message-
Sent: 16 January 2003 16:09
To: Multiple recipients of list ORACLE-L
Does their has way to check rollback segment has optimal setup?
Thanks.
Hi
Jos
I used
that to store data with different row sizes in areas of the database where the
block size fits the row size best.
For
instance, you have an OLTP database with rows that fit perfectly fine into 4k
blocks. Then, you have some tables with "longer" rows.
So,
you can go ahead
I was not looking to pass the variable in when calling the script, but to
explicitly set it at the beginning of the script so that I could use it over
again in multiple statements. Kind of like what the preprocessor does, it
replaces all instances of the defined variable with a constant. The
Rick,
The problem is W2K on Pentium 4.
Check Amira's attached file for detailed information.
Ofer
-Original Message-
Sent: Thursday, January 16, 2003 4:09 PM
To: Multiple recipients of list ORACLE-L
Hi DBAs,
Has anyone had trouble installing Oracle 8.x on Win 2k Service Pack 3?.
As I said life is much easier:
select * from v$access where object = 'YOUR_OBJECT_NAME'
Waleed
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 16, 2003 10:14 AM
To: Multiple recipients of list ORACLE-L
I realize that a package can't be recompiled while a session
replication
-Original Message-
Sent: quinta-feira, 16 de Janeiro de 2003 15:09
To: Multiple recipients of list ORACLE-L
List,
I have to move data on a regular basis between two instances of 8.1.7 on
two different UNIX servers. The schema is exactly the same. There are 543
tables to
Is the server a Pentium4? If it is there is a problem with symcjit.dll.
Copy the installation CD down to the hard drive.
Rename the symcjit.dll
Run the installation from disk
Don Bricker
Database Administrator / System Administrator
Illinois Environmental Protection Agency
1021 North Grand
Hi,
I've missed some of this thread so apologies if this has been touched on
already. The info-from-Oracle below refers to Backup/Failover/Standby.
Backup : We're OK.
Failover: Hmm. Tru64 cluster. Think we're OK based on what I read...
Standby : I was shot down on this one because
Dave:
Sorry about your drive.
Obvious solution -- drink more beer.
Barb
--
You might be able to find what you need at this site.
http://web.singnet.com.sg/~petermag/oracle.html
Dave
--- Farnsworth, Dave
[EMAIL PROTECTED] wrote:
A while back I posted a link to a website that has
Title: RE: Who has package open
CREATE OR REPLACE PROCEDURE who_is_using wrapped
0
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
7
200f000
1
4
0
1e
c WHO_IS_USING:
8 OBJ_NAME:
8 VARCHAR2:
b DBMS_OUTPUT:
6 ENABLE:
7 100:
1 I:
1 B:
8 USERNAME:
3 SID:
3 SYS:
Title: RE: Ideas for future authors
care to share that method?? :)
-Original Message-
From: Stephen Andert [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 16, 2003 9:55 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Ideas for future authors
I know I've really enjoyed
-Obvious solution -- drink more beer.
Best tip I've read all day, I will take your advice.
Dave
-Original Message-
Sent: Thursday, January 16, 2003 9:25 AM
To: Multiple recipients of list ORACLE-L
Dave:
Sorry about your drive.
Obvious solution -- drink more beer.
Barb
--
You
After looking at my post, I thought maybe showing the contents of the
directories involved might help show the logic (??) of the script.
/u05/oracle/admin ls
ACP1/ HLPP/ HRP1/ INTP/ MOBP/ RCNP/ RSAP/ TIMP/
/u05/oracle/admin/ACP1/backup ls -l
-rw-r- 1 oracle dba3645440 Jan
One measure that users tend to scream about is:
Do you get frequent ORA-1555?
Other things to look at are extends/shrink ratios and many other things
I'm sure the wiser users on this list will add to my meager penny's
worth.
Stephen
[EMAIL PROTECTED] 01/16/03 09:09AM
Does their has way to
Hi Big
Planet,
They
db files are not consistence you can apply the changeswith archived redo
log since.
How
you recover your database is depend on how you backup your
database.
For
example you can use old "redundancy set" + latest exported dump
file
Sinardy
-Original
Title: Message
Hi all
-
We
have a data warehouse database that is very fragmented on the tablespace level
and a lot of space can not be reused because the space 'bubbles' are too small
to fit the tables. We would like to reorg and reclaim the space ( more than 13G
) by using the 'SAFE'
I'd argue that the business does get the 'insurance' value of knowing it's
got redundancy in place in case something befalls the primary server. But
all this talk about the equities of software pricing aside--I believe oracle
is legally entitled to charge whatever they like. I think the theory
Title: Message
YES
YES YES YES YES YES YES YES YES YES YES YES YES
YES
That's the
one!!
Thanks,
Dave
-Original Message-From: Sherman, Edward
[mailto:[EMAIL PROTECTED]]Sent: Thursday, January 16, 2003 8:35
AMTo: Multiple recipients of list ORACLE-LSubject: RE:
Tom,
I'm going to agree with both of you, but with reservations. When you have a
standby database during normal day to day operations, what value added does it
provide to your business? Assuming all is well, nothing it's just overhead.
Yes Oracle did do a pile of research and development
Title: RE: Database tracking
I concur with the recommendation to use STATSPACK but you might want to augment it. I take STATSPACK snapshots every 15 minutes and if there's a performance problem caused by a few bad queries I can usually isolate the offenders. But constant fined-grained
if your CPU has PIV;
Try taking a look at (for the pentium 4 install problem):
http://www.intel.com/support/processors/pentium4/issues.htm
The problem we encountered was that the installation would just
dissapear at some point with no explaination. Replacing symcjit.dll
solved it.
Ayhan
Kip,
in your situation (as I understand it), I think would fall into the
following scenario:
Don't ask and don't tell.
clearly, you are not intending on running your production system at your
data recovery site. your intent is to use the site to (as you said): test
recovery to make sure it
how about, database link
-Original Message-
Sent: 17 January 2003 01:46
To: Multiple recipients of list ORACLE-L
replication
-Original Message-
Sent: quinta-feira, 16 de Janeiro de 2003 15:09
To: Multiple recipients of list ORACLE-L
List,
I have to move data on a regular
I have found many great SQL scripts to identify segments whose next extents
will not fit into their tablespace and segments whose number of extents are
approaching the max number of extents. But, what I am looking for is a Unix
shell script that will run one of these scripts and mail alerts based
Didn't the now-infamous State of California deal involve a 3rd-party
reseller?
Roy Pardee
Programmer/Analyst
SWFPAC Lockheed Martin IT
Extension 8487
-Original Message-
Sent: Thursday, January 16, 2003 5:09 AM
To: Multiple recipients of list ORACLE-L
I just renewed our Cognos
Hello Everyone,
Is there anything, called an Average Response Time for an Oracle
database? I got a request from one of the application owners as under :
Snip
If I can get a log of AVERAGE response time for 1/2 hour periods starting
at 9am and running thru 5 pm I would be in heaven. If I
Using
transportable tablespaces to move data from the operational database to the ODS
or warehouse is one.
-Original Message-From: Jos
[mailto:[EMAIL PROTECTED]]Sent: Thursday, January 16, 2003
8:14 AMTo: Multiple recipients of list ORACLE-LSubject:
Multiple block sizes in
Is Excessive Redo Generated during RMAN OPEN Database backup using backup sets as
happens in case of HOT Backup ?
If NOT , Why ?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: VIVEK_SHARMA
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
Can the value used in bind variables be retrieved from V$ tables? The
reason I am interested is I'm trying to get use a subset of the SQL from
V$SQLTEXT from one 8.1.7 instance to run a comparative test on another
instance. However, most of the SQL contains bind variables. I checked out
Rajesh:
You can schedule statspack snaps at 30 minutes
interval and then compare the response times
at each interval.. But the question is
'what do you mean by average response time?'
KG
Best Regards,
K Gopalakrishnan
-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, January
absolutely.
-Original Message-From: BigP
[mailto:[EMAIL PROTECTED]]Sent: Thursday, January 16,
2003 11:29 AMTo: Multiple recipients of list
ORACLE-LSubject: one datafile lost.
Just wondering what will happen in this condition
.
supposse I have two tablespaces
Use the query= feature of export. This will work if there is a timestamp
column where you can determine which are the 'new' records.
-Original Message-
Sent: Thursday, January 16, 2003 11:49 AM
To: Multiple recipients of list ORACLE-L
how about, database link
-Original
Sounds like a lot of work if the only real justification is
to save 13G of space.
IMO the real justfication is moving to LMT.
Meng, Dennis [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/16/2003 07:44 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
maybe u should use orasnap from a windows client???
bye
Paulo
-Original Message-
Sent: quinta-feira, 16 de Janeiro de 2003 18:36
To: Multiple recipients of list ORACLE-L
I have found many great SQL scripts to identify segments whose next extents
will not fit into their tablespace and
No.
Because Rman is not placing the tablespaces in a HOT BACKUP mode. Rman is
simply reading the blocks, compressing them, and writing them to tape.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Thursday, January 16, 2003 12:35 PM
To: Multiple recipients of
Title: Message
WOW
this is awesome! I hope a lot of these links are still alive. Thanks for
sending this.
-Original Message-From: Farnsworth, Dave
[mailto:[EMAIL PROTECTED]]Sent: Thursday, January 16,
2003 10:50 AMTo: Multiple recipients of list
ORACLE-LSubject: RE:
Chris,
Sure, come to my session (#534) at IOUG grin.
But if you can't make it, O'Reilly published the book I reviewed and
the article I wrote about that at
http://oracle.oreilly.com/news/oraclesqlload_0401.html . Of course,
my e-mail address there doesn't work, and I don't know if they're
Rman uses the same construct to get the right data in a hot backup as
sqlplus, the SCN of the database. It reduces excess redo because you don't
have to put the datafile in backup mode with a begin backup and take it out
with and end backup.
HTH,
Ruth
- Original Message -
To: Multiple
Thanks Stephan. It looks like I will be using RMAN 8.1.6 8.1.7
to interface w/ the Legato Module for Oracle.
Gene [EMAIL PROTECTED] 01/16/03 09:59AM
For question 1.(920)/oracle/app/oracle/admin
rman nocatalogRecovery Manager: Release 9.2.0.2.0 -
ProductionCopyright (c) 1995, 2002, Oracle
Title: RE: Unix Max Extent Script
search for smenu in Google ... it is a bunch of scripts with all sh interface.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and
Title: RE: Database tracking
I concur, I have used MRTG for this in the past, now I
have an Access database that I connect to via ODBC and get my graphs. They
are very handy for trending and analysis, If someone says I had a problem
yesterday around 3 pm Igo look at the charts and I usually
RMAN does no compression on any blocks with data. The only compression that
occurs that blocks above the HWM are not included. No compression of data
occurs, and in fact empty blocks can and are backed up by RMAN.
RF
Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts
1 - 100 of 153 matches
Mail list logo