Is anyone using this
new init.ora parameter? Does it really seam to help recovery
times? Does anyone have any good or bad stories about this?
Thanks!!
Nick
Title: RE: select sequence.nextval from dual contributes to poor performan
you might want to try increasing the 'cache' size of the sequence.
If order is not important, and it is being used so often that it's having locking issues, you may want to create a couple different sequences, and
Title: RE: RE: RE: Double Take and Oracle
A little clarification
---cut---
The reasons for this are wrapped around Oracle's write as little as needed and
do so as seldomly as possible idea.
---end cut---
is not really true.
When a tablespace is placed into hot backup mode, Oracle
Title: RE: ROWID question?
Yes, Oracle can re-use a rowid.
-Original Message-
From: Mark Richard [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 22, 2002 4:39 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: ROWID question?
Denham,
At the risk of going slightly
Title: RE: Streams
The supplemental logging information adds quite a bit of into to each record.
1) it writes the actual column offset, rather than the logical offset (which it needs to query to find)
2) it writes the original head rowid for the row in addition/or instead of the rowid for
Title: RE: Oracle Internals course
rumor has it that this course is not going to be offered/modified for the 9.2 release of Oracle. Can anyone confirm or deny it?
Nick
p.s. Had a close friend take this class, and they also came back extremely pleased with it.
-Original Message-
Title: RE: analyze table takes forever
what's the structure of the table?
And try taking an export of this partition and import it into it's own table in a development box... see if you can analyze it there.
Nick
-Original Message-
From: Andrey Bronfin [mailto:[EMAIL
Title: RE: SharePlex core dumps - help
Call Quest Software technical support. They will be more than happy to help you.
I think there is already a patch out to fix this.
Just call 1-800-306-9329 and once you speak with an operator, ask to place a support call for SharePlex.
Nick
Hannah,
Increase the cache value. The only time a sequence change get's
recorded in the redo logs is when it goes to grab another set of values.
If you look at the sys.seq$ table, that's only updated when you run out
of cache values, and oracle needs to grab another one.
Nick
quot; who specialize on
OPS/RAC andtend to know IBM HACMP and SP issuesfar better than
IBM...
Yes, you can reuse the space within a VSD same as
you reuse the space within an LV. From the Oracle perspective, just treat
VSDs like LVs (a.k.a. "raw" devices)...
- Original Message --
Is the
JA16EUCcharacter set, a subset of
the WE8ISO8859P1 character set?
That is, will
all the JA16EUC characters exist in the WE8ISO8859P1 character
set?
Nick
Wagner
Title: RE: Why does my insert creates so many logs?
is the tablespace in hotbackup mode?
-Original Message-
From: Gurelei [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 11:24 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Why does my insert creates so many
Title: RE: How to locate who dropped a view using log miner?
take a look at the
sys.ind$ table for indexes
sys.view$ for views
sys.source$ for stored procedures
HTH
Nick Wagner
Quest Software
www.quest.com
-Original Message-
From: Mario Alberto Ramos Arellano [mailto:[EMAIL
Title: RE: HELP - How can I limit what program users use to connect?
One thing you can try
TOAD includes a module name... so select from v$session where module = 'T.O.A.D.'
It will give you a list of users... and you could probably create a DBMS_JOB to go around and kill any user
Title: RE: Disaster Recovery Fallback Sites
Qs. IF THE DATABASE CRASHES IN THE PRIMARY STORAGE ARRAY BOX , WILL IT
BE COPIED TO THE 2nd REPLICATION ARRAY THEREBY CAUSING IT TOO HOLD A
CRASHED COPY OF THE DATABASE TOO ?
Yes, if the filesystem replication is synchronous then the target
' but this list is for helping people, and trying to solve their problems... I see this as a solution.
Nick Wagner
Technical PM
Quest Software
-Original Message-
From: Ed [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 28, 2001 3:35 PM
To: Multiple recipients of list ORACLE-L
Subject
Title: RE: Has anyone heard of Mirror Accessible?
Just got back from OOW and that 'might' be available in Release 2 of 9i. Which is due out in Spring 2002.
Nick.
-Original Message-
From: Miller, Jay [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 30, 2001 1:45 PM
To: Multiple
Title: RE: virus alert (OT)
You can read more about this virus at:
http://www.antivirus.com/vinfo/virusencyclo/default5.asp?VName=WORM_GONE.A=T
Nick
-Original Message-
From: Anne Yu [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 04, 2001 12:36 PM
To: Multiple recipients of
Title: RE: truncate or drop
If they have thousands of extents... it might be better to truncate first, then drop. I've seen it take up to 4-5 hours to drop a table with thousands of extents (not my database... but a clients.) :)
If you are going to rebuild entire datafiles/tablespaces... it
Using the following
procedure, I'm getting a ora-22992 error.
declarelocator_var clob;amount_var
number;offset_var number;output_var
varchar2(20);beginamount_var:=16;offset_var:=1;buffer_var:='This
is not text';select b into locator_var from
lob_test@to_features where a =
Title: RE: Converting from ASCII7 to UTF8
This can be done pretty easily using SharePlex for Oracle. It's able to replicate between different character sets, platforms, DB versions.. It can also handle your long columns as well.
As for the concern of database space... you'll probably gain
Title: RE: What's Oracle Trying to Hide ???
because the list is so slow today, I'll add my response to it...
I agree with Jared... but have one other thing to mention.
Working for a company that continually delves into the internal structures and workings of Oracle I learned to respect
Title: RE: VLDB backup policy
check out SharePlex for Oracle. The target system is completely open and available while it is applying the changes from the source. If you are expecting 25 GB of redo generation per day, it will usually be under 15 seconds latency. And it's a LOT cheaper than
Title: RE: upgrade strategy
Use SharePlex for Oracle. Users can continue to do their activity on the primary machine, while you upgrade and test the secondary. Once the upgrade is complete, shareplex then applies the waiting transactions to the target. It's nice, because it can replicate
Title: RE: Crystal Report as an ad-hoc tool
if you are dead-set using crystal... I feel your pain. In a previous life (job) I was a report writer/integrator... we used a Delphi front end, and Crystal provided us a couple of nice utilities to get into the structure of the application and
Title: RE: cannot update or edit in a view -- question
What is the front end? I've seen cases in Delphi and VB where the user tries to modify a field in a grid, but the underlying query is a view... Oracle interprets it as someone trying to modify a field and reports the error. It may be
bleak... or blank? or perhaps it's a bigger
statement, that 'we'don't know as a whole...
hmmm..
-Original Message-From: Johnston, Tim
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 08, 2002 2:32
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Oracle Future???
So
you're
.
Nick
-Original Message-
From: John Kanagaraj [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 10, 2002 1:35 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: replication
Bill,
If you have the $$, then you should look at Quest's Shareplex. Nick Wagner
from this list
Title: RE: RPAD problem
try this...
RPAD(nvl(A.SSN,' '),9)
Nick
-Original Message-
From: Rod Clayton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 9:17 AM
To: Multiple recipients of list ORACLE-L
Subject: RPAD problem
I am trying to create fixed length records
Title: RE: SAME, WAFL and RAID
good question... RAID and WALF -- see below. SAME... no idea...
RAID - (from http://www.uni-mainz.de/~neuffer/scsi/what_is_raid.html )
What does RAID stand for ?
In 1987, Patterson, Gibson and Katz at the University of California Berkeley, published a paper
Title: RE: How to set DBWR_WRITE_PROCESSES in Oracle8i?
Since I didn't see this yet, I thought I might add it in.
Try increasing the PCTFREE, perhaps there are two many transactions happening in the same block, and oracle is locking the entire block until the other transaction if
Title: RE: SPACE FREE HOW?
24x7... that does make it tough.. you might want to try LiveReorg from Quest Software... it allows you to reorganize those tables while users are still accessing them. It will even tell you which tables to reorg to free up the most space... without even deleting
Title: RE: Re: Backup Strategy
here is a pretty good one as well... The paper is on building a 24x7 database.
http://www.quest.com/whitepapers/Building_WP.pdf
-Original Message-
From: Jan Pruner [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 24, 2002 6:10 AM
To: Multiple
Title: RE: Mirroring REDO logs to an nfs drive
Also, I'd like to know the performance impact of this. Some of our customers have expressed interest in this, and I'd like to know if the number of redo latches increase. Or if the redo log buffer has any problems flushing out.
Nick
Title: RE: ORA-01555 Mystery (Help)
would Set transaction read only help here?
-Original Message-
From: Baker, Barbara [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 25, 2002 2:35 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: ORA-01555 Mystery (Help)
I think you
:00am PST
TO PARTICIPATE CALL: 800.967.7150 (Domestic); 719.457.2712 (International)
CALL LEADER: Nick Wagner
POWERPOINT SLIDES REQUIRED: http://www.quest.com/shareplex/docs/shareplexconfcall.ppt
For additional information visit our web page at: www.quest.com/shareplex
I look forward
/shareplex/
On the left hand side, click on the 'white papers' link. There are a couple by Gaja, and Steven Feuerstein (PL/SQL guru), Eyal Aronoff, and even Kevin Loney.
Some even talk about maintaining and working in a 'large' environment.
pretty interesting reading...
Nick Wagner
Title: RE: Database writer
you can download a free fully functional trial version of Spotlight on Oracle from the Quest Website at http://www.quest.com/spotlight_oracle/
there is a link to 'download trial' on the left hand side. You can click on the screenshot to get a full size image... but
Title: RE: Veritas Quick I/0 and Oracle/ Asycnchronous I/O
It works just fine, but I think you will actually get more performance out of a solid state device. Take a look at platypus.com, they have a SSD device that plugs into the PCI board in your computer... They claim over 60 MB per second
Title: RE: logminer in the 9i world, etc
Either way... I tried it with 9.0.0.0.0 beta 3 and I got the normal DML to work just fine. However I could not get the DDL to work.. I set the parameters just like the doc says, but all my DDL queries just seamed to go out to lunch on me...
My log
Title: another security issue with Oracle 9.x
There
is also the
sqlplus "/ as sysdba"
breach
as well... make sure you have your password files set up.
-Original Message-From: Jacques Kilchoer
Sent: Thursday, February 14, 2002 3:58 PMTo: Multiple
recipients of list
Title: RE: Oracle Advanced Replication
All this talk of replication is really nice.
SharePlex for Oracle, can handle master to master replication. Conflicts are handled via pl/sql procedures inside the database, where you can determine exactly what happens when there is a conflict.
Replication
Nick,
DoesSharePlex supportuser definedobject
types?
Richard
-Original Message-From: Nick Wagner
[mailto:[EMAIL PROTECTED]]Sent: Friday, February 15, 2002 2:09
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Oracle Advanced Replication
All this talk
Title: RE: Need some white papers on replication
Here are a couple
http://www.quest.com/whitepapers/shareplex/
Not OAR... but a better solution.
Nick
-Original Message-
From: Khedr, Waleed [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 26, 2002 12:55 PM
To: Multiple
Title: RE: EXTENTS?
I'm going to say 1. I don't think you can have multiple tables in the same DB block.
-Original Message-
From: Seema Singh [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 04, 2002 10:19 AM
To: Multiple recipients of list ORACLE-L
Subject: EXTENTS?
Hi
If DB
Situation: Sun
Cluster, or VERITAS Cluster. Oracle 8, 8i, or 9i
2 node Sun E6500s w/
8 CPUs
If the primary node
fails, how long does it take before a user is able to connect to the secondary
node, and continue their activity? I'm sure reality, and marketing
times are different... I'm
Nick:
On our SunCluster 2-node E4500's with 8 CPU's (Oracle 8.0.5)
it takes us around 12 to 15 minutes.
HTH.
Barb
--
From: Nick Wagner[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Monday, March 04, 2002 2:23 PM
To: Multiple recipients of list ORACLE-L
Subject
Title: RE: Restrictions returning a Long field
There is a pl/sql limit of 32k for long columns, you must parse it into a piece-wise transaction to pull all the information out of it. It's one of the reasons Oracle switched to LOB's... Long's are just so difficult to work with.
How to make
in Unix Format' is unchecked.
If this doesn't work, let me know.
Nick Wagner
www.quest.com
-Original Message-
From: Post, Ethan [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 06, 2001 2:42 PM
To: Multiple recipients of list ORACLE-L
Subject: TOAD = NOTEPAD
Anyone know how to a .sql file
Title: transportable tablespaces
Only
if the datafiles are the same between the two systems. As far as I have
been able to test, this only works with Sun and HP.The datafiles in
both cases are thesame, and Oracle will not complain about
them.There are probably some caveats.. suchas 32 vs.
Title: RE: ORA-12705 - REALLY URGENT
you can also try using the 'N' inside the statement
If you are modifying data in an NVARCHAR2 or NCHAR... or something similar using the following notation
insert into table_name (col1,col2) values ('col1 is regular varchar2',N'col2 is an
Title: RE: Determining Oracle status
tnsping $ORACLE_SID works pretty well...
Nick
-Original Message-
From: Barry Deevey [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 18, 2001 8:46 AM
To: Multiple recipients of list ORACLE-L
Subject: Determining Oracle status
Hi all,
Title: RE: List of changed objects in the DB
you might want to take a look at Schema Manager from Quest Software (www.quest.com)... it will not only show you what has changed since the last time you used it... but also build you the code to apply and rollback those changes to different
Title: RE: Please help! Recover a database on another server
sometimes the error message is a little strange...
when it comes back 'media recovery complete' you can usually just do a 'alter database open;' command and not worry about resetting the logs. If you backed up the controlfiles,
Title: RE: Sr. Oracle DBA Position- Must be 8i and 9i Certified-
Does a 24x7 DB demand a higher salary than a 9am-5pm DB?
-Original Message-
From: OraStaff [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 03, 2002 3:10 PM
To: Multiple recipients of list ORACLE-L
Subject: Sr.
Title: RE: Are Oracle courses required for Oracle Certification now?
if the DOS command prompt doesn't work, try starting it at the services level.
-Original Message-
From: Cornio, Georgette Ms USACFSC
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 12:27 PM
To:
With Oracle 8.1.7,
Solaris 8 OS.
I have a shared
storage device for storing all my datafiles, control files, redo logs, archive
logs, etc.. everything except for the ORACLE_HOME and Oracle
binaries.
If I have the file
system and database mounted to one machine, and have a fully open,
is running without errors then do not worry.
To make sure try to restart the database.
Regards,
Waleed
Try, recreate the controlfile
- Original Message -
From: Nick Wagner
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, December 04, 2002 10:09 PM
Subject: DB
Title: RE: Increase size of data files and rollback segments
ORACLE ORACLE ORACLE ORACLE SQL*NET
Just bringing it back on topic :)
Nick
-Original Message-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 10:21 AM
To: Multiple recipients of
Title: RE: SQL question avoiding 2 views and not in
OLS -- Oracle Label Security... I think that's the key you are looking for.
-Original Message-
From: Stephane Paquette [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 13, 2002 11:59 AM
To: Multiple recipients of list ORACLE-L
Title: Message
SQL*Plus: Release 9.2.0.2.0 - Production on Tue Dec 17 17:19:55 2002
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.2.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer
Title: RE: password
why isn't there a program available that can reverse engineer the code used to encrypt passwords...
if username XYZ always has password (encrypted) CBA, you think that it would be easy to figure out the pattern... once you have the pattern it's easy to go back and forth
We've
done a few tests here with chained vs. unchained rows, and the impact is
anywhere from 50-200% overhead. So if it took about 10 seconds to do
a query it will now take 15 to 30 seconds. It seamed to depend most
on which rows we were returning... not hitting the chained rows as much
Title: RE: Row Migration
also, what version of Oracle and how many columns on the table?
-Original Message-
From: Nick Wagner [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 27, 2002 9:39 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Row Migration
We've done a few
If I
get a 'sales critter' type email, and it takes me 4 or 5 tries before I can
decipher their version of English, then you can guarantee I won't buy their
product.There is also a very good chance that I will actually recommend
people NOT to use it.
-Original Message-From: Fink,
Title: RE: strange SQL with TOAD
Also, you might try turning off the 'editable queries' in the options. That causes it to do a select rowid, * from table, so that once you edit the grid, it will use the rowid to go back and actually make the update to the data.
-Original Message-
shareplex
Quest Shareplex is a replication software.
Nick Wagner from Quest is on this list and he is been very helpful
and I am sure he will be glad to provide you info on it. Right Nick? :)
-Original Message-
Sent: Friday, January 17, 2003 11:14 AM
To: Multiple recipients of list
Title: RE: quest SharePlex
You provide a 'configuration file' which is just a flat file of table names on the source machine and table names on the target machine. Then we go through an activation process that takes the table name on the source and grabs the object id from Oracle and the
Title: RE: quest SharePlex
This is actually part of the 'magic' of SharePlex. The way we obtain the PK information from the database if the PK was not modified is very tricky.
I can tell you some of the 'magic' but not all of it. (NDA type stuff)
In all updates the redo logs contain the
Title: RE: quest SharePlex
Would the same thing work if you shut down the
Shareplex processes after the row had chained,
and restarted them before you updated the chained
piece ?
-- Yes
And does Shareplex guarantee that it will
never report a 1555 error regardless of how long it
is shut
Title: RE: Debate on rc commands Solaris and Oracle
Do you
have Oracle 9i Supplemental logging turned on?
Also
information about high water mark, and extent information, data dictionary
upkeep... what are the stats of the table storage clause?
-Original Message-From: Steve
Title: Which rollback segment is currently active?
select rs.usn, xacts
active_transactions, gets, waits, writes, name from v$rollstat rs,
v$rollname rnwhere rs.usn = rn.usn
This
may help...
-Original Message-From: Nguyen, David M
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, February
Title: RE: RAC on linux?
Anyone have ideas on this?
http://story.news.yahoo.com/news?tmpl=story=/cmp/20030206/tc_cmp/iwk20030206s0012
Sun is now going after the intel market too. Is this just a new version of their Solaris x86, or a completely new build?
-Original Message-
From:
Title: RE: SETGID
what are the permissions on the oracle binary in $ORACLE_HOME/bin...
make sure it reads
-rwsr-s--x
-Original Message-
From: Ehresmann, David [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 07, 2003 8:59 AM
To: Multiple recipients of list ORACLE-L
Subject:
Title: RE: Re[2]: Re[2]: RMAN: I don't trust it
Two words - Speed and Performance.
-Original Message-
From: Lyndon Tiu [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 11, 2003 10:34 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Re[2]: Re[2]: RMAN: I don't trust it
Title: RE: View HELP Please!
I remember some parameter about Query re-writes... it may be only for Materialized Views... but could be the culprit here.
Also, do you have Oracle Label Security set on this table, or Fine-Grain Auditing?
-Original Message-
From: Freeman Robert - IL
Title: RE: Database naming conventions
how about just an 'o'
od24x7
op24x7
you could then use 'u' for udb and 'm' for MySQL, and 's' for SQL Server.
-Original Message-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 14, 2003 10:44 AM
To: Multiple
you
can take the (more unix friendly)
ksh
c
c++
Java
path,
all those languages are very similar, or the (more windows
friendly)
pl/sql
Delphi
path...
if you
know pl/sql... delphi should come pretty easily. If you know ksh, or c,
then c++ and Java will come pretty easily...
Title: RE: Programming languages that make DBA's lives easier
If you are just learning Korn Shell programming, I'd recommend
The Korn Shell (3rd edition)
by Anatole Olczak
it's better than others I have seen, but basic... you won't get deep enough to make any huge programs, but it
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
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: RE: Oh Where Oh Where Is My Redo Coming From
Since SharePlex for Oracle and LiveReorg are dependant on redo log volumes, transaction sizes, and things like that we have developed a free utility that parses through the redo logs for some pre-defined amount of time, and let's you know
Title: storing credit card numbers in a database
it
would be safer to encrypt the credit card number at the application level, and
insert that string into the database, because anyone with a decent sniffer would
be able to pick it out of the SQL*Net code.Whether or not they even have
access
This is somewhat
related tothe question earlier about how to encrypt a password in a
script... however, what I want to do is also be able to start that database
through a script.
(Oracle
9.2.0.)
Essentially I have a
database that I want to shut down at 5pm every night, and start it
Title: RE: Purely for your amusement
Misery loves company. Thank you!
By the way... how long does this take to finish?
-Original Message-
From: Barbara Baker [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 27, 2003 10:24 AM
To: Multiple recipients of list ORACLE-L
Subject:
Title: RE: MS SQL hasn't given up!
He's
got a good point, performance at that point doesn't matter if your system
must be rebooted weekly, and crashes every couple of days.
The
tests should be run 24x7 for 350 days... to get a real idea on what kind of
reliability and performance you can
Title: RE: Purely for your amusement
hmmm...
ok, let's give one of the largest known hacking/cracking/virii producing countries in the world, the source code to the most common desktop in the world for 'security' purposes?
Bill has got be to smokin' something...
Any bets on how long it
Title: RE: PLSQL stored procedure
our go get TOAD freeware... even has a line by line debugger with watches.
-Original Message-
From: Darrell Landrum [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 05, 2003 7:06 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: PLSQL
Title: RE: Tablespaces - datafiles
are you using VxFS?
-Original Message-
From: Johnston, Tim [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 11, 2003 12:14 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Tablespaces - datafiles
Create the tablespace and look at it with
and these can "bite you" if you are not
careful...
Out of
curiosity, why did you ask?
Tim
-Original Message-From: Nick Wagner
[mailto:[EMAIL PROTECTED]Sent: Tuesday, March 11, 2003 3:57
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Tablespaces - datafiles
Can I take a hot
backup of an 8.1.7 instance... and then upgrade the backup to 9.2.0
(upgrading data dictionary tables and everything) and then apply logs created by
the 8.1.7 instance to this 9.2.0 backup?
Please answer as
soon as possible...
Thanks!
Nick Wagner
nevermind... I found the answer... 'No'. :)
Thanks!
-Original Message-From: Nick Wagner Sent:
Monday, March 24, 2003 12:24 PMTo: Multiple recipients of list
ORACLE-LSubject: Quick Question -- 8.1.7 logs applied to 9.2.0
database instance?
Can I take a hot
backup of an 8.1.7
Title: RE: Veritas Quick I/O for Oracle
Just
be careful using the convosync=delay and convosync=closesync
options.We have seen this corrupt redo log
records.
Nick
-Original Message-From: Aponte, Tony
[mailto:[EMAIL PROTECTED]Sent: Wednesday, March 26, 2003 2:09
PMTo: Multiple
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Nick Wagner
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http
BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Nick Wagner
INET: [EMAIL PROTECTED
check
out www.goldengate.com, the
product can replicate from Sybase to Oracle, and do any kind of
mapping or transformation that is needed.
Nick
-Original Message-From: Jay Krishnan R
[mailto:[EMAIL PROTECTED]Sent: Tuesday, July 08, 2003 3:39
AMTo: Multiple recipients of list
In a RAC environment, what is the best way to synchronize the time clocks on the
nodes? It seams I came across a case where select sysdate from dual; produced two
different values.
Thanks!
Nick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Nick Wagner
INET
Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !
-Original Message- From: Nick
Wagner
that evaluate to as a single
number?
Thanks,
Nick Wagner
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Nick Wagner
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web
Thanks... I think... except I'm not sure how to calculate that?
Nick
-Original Message-
Sent: Thursday, July 31, 2003 2:00 PM
To: Multiple recipients of list ORACLE-L
Hi,
It is just combination of Base and Wrap. So your number will be
8589934593
KG
--- Nick Wagner [EMAIL
1 - 100 of 102 matches
Mail list logo