Not to mention, backups can take a REALLY long time, unless you backup
the raw volume image, in which case you can only restore at the
filesystem level.
On Tue, 2002-12-03 at 14:44, Connor McDonald wrote:
Exactly.
We had a system that used to drag emails (from qmail
so each mail was a
As Cary as mentioned, there's some new goodies in v9.
In our case, the controlling of attachments etc is
done before processing into the db. I can't remember
the specifics (read: I'm no longer at that site) but
we found some shareware (mimencode? + a few other
little things) we separated encoded
Hmm...not sure if this is what's biting you, but if you're out of ITL
slots on the block, Oracle will move to the next block on the free
list. If all the blocks on the free list have filled ITLs, Oracle will
add an extent to the free list. I don't suppose you have MAXTRANS set
to 1 or some other
Mark,
I didn't mean to turn this in to a tool discussion, I merely tried to point
out the down side to the original idea, due to not *fully* checking
availability, by showing what tools typically do.
Sorry
Mark
-Original Message-
Richard
Sent: 03 December 2002 21:45
To: Multiple
As a bit of light relief
John
Carry on til the end for the SAP toaster
If IBM made toasters ... They would want one big toaster where people bring
bread to be submitted for overnight toasting. IBM would claim a worldwide
market for five, maybe six toasters.
If Xerox made toasters
thank you very much for the reply. now my problem seems to be that I didn't install
appropriately - but I couldn't find any hint on metalink. find a short summary of my
situation - actually the same on linux or SunOS9:
===
$sqlplus / as sysdba
SQL*Plus:
I think that SQLBackTrack from Precise can restore a table from a backup.
Of course you will need to backup with it, not Rman.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday, November 30, 2002 12:39 AM
Hi Listers,
Is
Title: RE: Sr. Oracle DBA Position- Must be 8i and 9i Certified-
You
can also register with the Boston Globe to get an e-mail listing Oracle job ads
in the Boston area.
I use
it as a gauge of how well things are going in the market south of the
border.
At one
point there were a dozen or
Hello Murat
Export has a parameter Query that allow you to specify selection criteria
for exporting a subset of records from the table. Import also has parameter
Ignore=y and then the import ignore the error of the create table statement
and append the imported records into an existing table.
So
I always overlook things, so I'll just ask and hope it isn't already on
the thread: Exactly what kind of activity is going on against this
wonderful table? Is this table placed in an LMT? If yes, is it a Uniform
LMT? Could you trace the processes/users doing stuff to the table so
that we could
Alex - And the funny part is that the person who nailed the solution, Steve
Ollig, also works for us and isn't a part of our official Java initiative.
Do you think he'll ever get good enough to be sent to Java training?
-Original Message-
Sent: Tuesday, December 03, 2002 4:20 PM
To:
Hi,
you can recover a tablespace to a point in time. That's the only option you
would have using RMAN.
Regards,
Mike Hately
-Original Message-
Sent: 04 December 2002 11:54
To: Multiple recipients of list ORACLE-L
I think that SQLBackTrack from Precise can restore a table from a backup.
So do a select from a view based on sys.x$dual. That does not have cause
LIO.
I checked a few months ago.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, December 03, 2002 4:32 PM
and that select 'PING' from dual is
In order to use rman to restore a single table you have to restore the
tablespace to a clone and then export the table you need and import it to
the 'real' database. So yes, it can be done!
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent:
Rodd,
Where do you see evidence that Ziff-Davis is owned by Microsoft?
The links seem to lead to a UK publishing firm.
www.ziffdavis.com -- http://www.willisstein.com/ -- www.emac.com
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
Sent: Wednesday,
Both RMAN and manual methods exist but they're
tacky...Basically you create a new database, recover
just the appropriate datafiles, export the data and
then do what you want with it...
hth
connor
--- Hately, Mike (NESL-IT)
[EMAIL PROTECTED] wrote: Hi,
you can recover a tablespace to a point
Title: RE:
Red Buttons is a fine comedian and actor. He won an Academy Award and Golden Globe. Still I can't see how he can HELP in this case.
Oh - you said Button not Buttons.
Nevermind.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
I'd agree that you can achieve the same result. I think I'd argue that it's
not a feature of RMAN though.
I can also take that restored table, spool it a text file and edit it using
MS Word but I wouldn't claim that RMAN can generate Word files.
Mind you, this is probably word class pedantry on
David Coursey, one of their Editors/Columnists made the disclaimer some
time back when he was comparing different software offerings of some
type. He mentioned that MS had some type of ownership in them or their
parent company. I don't recall which.
Rodd
On Wed, 2002-12-04 at 08:03, Boivin,
Sorry, as Kirti pointed to me the product belong to BMC.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, December 04, 2002 1:53 PM
I think that SQLBackTrack from Precise can restore a table from a backup.
Of course
Hi,
We've hit Ora-600 [2103] on a production database
(oracle 8172/aix 4.3.3.0).
We already have aix patch IX 81863.
According to Oracle support, it's caused by IO
contention.
Anybody has faced this one ?
=
Stéphane Paquette
DBA Oracle et DB2, consultant entrepôt de données
Oracle and
Ok, thanks.
After trying to follow the trail of owners, I think tracking who owns what
is a full-time job...
Pat.
-Original Message-
Sent: Wednesday, December 04, 2002 11:14 AM
To: Multiple recipients of list ORACLE-L
David Coursey, one of their Editors/Columnists made the disclaimer
But since my case is a single package running, there's no end-user
interaction. If I understand you correctly, then I'm only collecting
response time. I guess I never thought of it in those terms for
non-interactive executions. If that's the case, then aren't the waits worth
investigating? Or
The 9i RMAN method is nicer, as the DUPLICATE TARGET
DATABASE command now has a SKIP TABLESPACES clause...
Both RMAN and manual methods exist but they're
tacky...Basically you create a new database, recover
just the appropriate datafiles, export the data and
then do what you want with it...
Whoa! Tim, thanks a lot for sharing this. Quite an
insight.
So SELECTs are not a concern. INSERTs are a come and
see DBA thing (physical design issue).
DELETEs are relatively infrequent and many get
translated into UPDATE (logical as opposed to physical
delete).
Application partitioning as you
And
And... if Enron had made toasters... The toast would have come out crooked,
and later 'magically' shred itself into croutons!
: Shiva
-Original Message-
Sent: Wednesday, December 04, 2002 3:39 AM
To: Multiple recipients of list ORACLE-L
As a bit of light relief
John
Carry
I have been looking at the Oracle web site for the
termination date of Oracle 8i certification tests.
There is nothing there. Only Oracle 8. Rumor has had
it that there is a termination date.
Does anyone have an authoritative answer?
=
Pete Barnett
Lead Database Administrator
The Regence
If...
1) you're collecting time consumption data for ONLY the session you care
about, AND
2) you're collecting the data for a time interval [t0,t1] that includes
ONLY response time that you care about eliminating,
...then the waits are worth investigating.
Cary Millsap
Hotsos Enterprises,
Okay, since I provided the original remark that provoked this line of
discussion, let me clarify. The organization I was asking whether they were
a shill for Microsoft is the Aberdeen Group, the people that did the report
that made Microsoft look great and Linux look bad. I don't think it matters
Hey Cary,
Yes and Yes. Which brings me back to my original question: How do I go
about tracking down single-task message waits?
Thanks!
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
I saw a video clip on our National News show here in Canada last night (The
National), they talked about corruption at Enron, etc.
Apparently the accounting consulting firms are still lobbying to let them
continue negotiating consulting contracts with firms they are supposed to be
auditing at
Peter,
I don't think a date has been announced yet.
When they do state a date they give 6 months notice though
John
-Original Message-
Sent: 04 December 2002 15:59
To: Multiple recipients of list ORACLE-L
I have been looking at the Oracle web site for the
termination date of Oracle 8i
Cool, thanks Connor.
Next week I will be dining with some of the other erstwhile (other than
email)
members of this list, past and present.
I'm planning to take my Digital Camera, better go pop it into my suitcase
now.
Jared
Connor McDonald [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
I went to the Oracle Certification page and looked at the NEWS
and the FAQ. Both had mentions of the retirement of various tracks
but neither mentioned the retirement of the 8i track. The abscense
of an announcement on the official web site would indicate to me that
it has not been announced
Hey people!
A friend of mine was just asking me about getting Oracle certified (I
completed the Oracle 8i cerfication exams last year),
he told me that to his knowledge Oracle requires that you've done Oracle
courses before you can be certified now.
I knew nothing about this, but can't believe
Title: RE: Import Table from Full Backup
From: Hately, Mike (NESL-IT) [mailto:[EMAIL PROTECTED]]
I'd agree that you can achieve the same result. I think I'd
argue that it's
not a feature of RMAN though.
I can also take that restored table, spool it a text file and
edit it using
I have a need to use a Secure Thin JDBC Connection from a 3rd party product
to a Oracle 9i database. The 3rd party product will only allow me to
specify a URL, User and Password for the connection. So, I would like to be
able to specify a URL like the following:
No triggers, no snapshots. Thanks for the thougth though.
Jay
-Original Message-
Sent: Tuesday, December 03, 2002 2:34 PM
To: Multiple recipients of list ORACLE-L
Hum.
My last thought would are there triggers or snapshots defined on the table?
Ron Thomas
Hypercom, Inc
[EMAIL
If you've installed Oracle 9i on RH 8.0, please let me know.
Also, please let me know of any difficulties and workarounds
you may have encountered.
Just put a new 40Gig HD in my laptop, and wondering if I
can install RH 8.0, or should use 7.2.
Jared:
I put together some notes when I
freelist groups is 1
-Original Message-
Sent: Tuesday, December 03, 2002 9:59 PM
To: Multiple recipients of list ORACLE-L
What is the FREELIST GROUPS for the table?
Waleed
-Original Message-
Sent: Tuesday, December 03, 2002 3:50 PM
To: Multiple recipients of list ORACLE-L
The activity is almost all inserts (there is also some minimal update
activity on two CHAR(1) columns later, but it was failing on the inserts).
Looking at it, I'm surprised that I have freelists=1 since so much of the
activity is insert related. I should probably increase that even if it
You are not required to take the expensive course if:
1) You are upgrading from 7 8 or 8i certification.
2) You took your very first 9i certification exam before Sept 1, 2002
3) You are only shooting for the Associate certification level.
--
Lyndon Tiu
Quoting Kieran Murray [EMAIL PROTECTED]:
My instructor in a recent Oracle Education class said that there were a
couple of smart alecs that caused quite a stir within Oracle. After
receiving their OCP, they couldn't log into a database, and claimed it was
because they had never actually used Oracle. The instructor indicated that
the new
Title: Ora 29540 error
I get the following when trying to use the utl_tcp package on 8.1.7 database.
The following error has occurred:
ORA-29540: class oracle/plsql/net/TCPConnection does not exist
ORA-06512: at SYS.UTL_TCP, line 537
ORA-06512: at SYS.UTL_TCP, line 199
ORA-06512: at
oh God, remind me to break that camera !
--- [EMAIL PROTECTED] wrote:
Cool, thanks Connor.
Next week I will be dining with some of the other erstwhile (other
than
email)
members of this list, past and present.
I'm planning to take my Digital Camera, better go pop it into my
suitcase
Title: RE: Are Oracle courses required for Oracle Certification now?
My understanding it is true for 9i but not for the upgrade test for 9i so I am feverishly getting certified (okay not so feverishly) in 8i so I can do the upgrade path. Question is: When do the 8i tests expire?
I'm barely done with my 9i certification track and I'm hearing of 10i coming out
soon.
All's too fast!
--
Lyndon Tiu
Quoting [EMAIL PROTECTED]:
Peter,
I don't think a date has been announced yet.
When they do state a date they give 6 months notice though
John
--
Please see the
Title: RE:
I believe that is the easiest/cleanest way to restore from patches esp. when you don't know what those patches contain.
-Original Message-
From: Scott Stefick [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 03, 2002 2:21 PM
To: Multiple recipients of list ORACLE-L
MAXTRANS is set to 255.
Thanks anyway :)
-Original Message-
Sent: Wednesday, December 04, 2002 3:54 AM
To: Multiple recipients of list ORACLE-L
Hmm...not sure if this is what's biting you, but if you're out of ITL
slots on the block, Oracle will move to the next block on the free
list.
Yes, these are definitely the questions to be asking.
And some of the freelist blocks are being written to since we had another
insert run night before last and the number of freelist blocks declined
somewhat although more extents were also claimed in the new datafile.
So sometimes it's writing
Title: RE: Recipe for application design to run on RAC
H... it is probably not an good example but we too have a (couple of) mission critical app (affects on air production) running on 9i RAC. One of which has two major schema. We logically partitioned the application such that, for two
Install the JVM...see MetaLink Note:156477.1
Jeff Herrick
On Wed, 4 Dec 2002, Randy Pace wrote:
I get the following when trying to use the utl_tcp package on 8.1.7
database.
The following error has occurred:
ORA-29540: class oracle/plsql/net/TCPConnection does not exist
ORA-06512: at
Hey William,
Why are you 40% OCP - does this mean you are an OCA? When did you take your very
first 9i certification exam? If you took it before Sept. 1, 2002, the you're a
50% OCP.
--
Lyndon Tiu
Quoting DENNIS WILLIAMS [EMAIL PROTECTED]:
My instructor in a recent Oracle Education class
Rich,
Well, at least we've cleared up the whether. Now the question turns to
the why.
Once you have identified a program's dominant response time contributor,
solving any optimization problem degenerates to a very simple strategy:
1. Reduce the number of times the dominant contributor's
Don't forget to handle connection attempts that hang and never return.
Jared
Post, Ethan [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/03/2002 02:04 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:
Title: RE: Are Oracle courses required for Oracle Certification now?
From: Kieran Murray [mailto:[EMAIL PROTECTED]]
Hey people!
A friend of mine was just asking me about getting Oracle certified (I
completed the Oracle 8i cerfication exams last year),
he told me that to his
This is unfortunate or maybe just it's just an urban legend?
Hands on training, may it be $$$ or self taught at home is necessary. But $$$ is
definitely not a requirement.
I use Oracle at work and do more Oracle at home for my certs. I am able to
log-in to Oracle on Linux and Solaris. Oracle
I got to thinking a little more about this.
If you have an oraInventory directory under your product directory, I think
you need to back that one up too ... at least it wouldn't hurt.
-Original Message-
Sent: Wednesday, December 04, 2002 12:14 PM
To: Multiple recipients of list
Title: Ora 29540 error
Hi,
Following code works in sql server but IF NOT EXISTS dosn't work in
oracle
how
can we modify this code so that it should work on both sql server and
oracleif not exists
(
select
col1
from
t_suspended_txn
wherecol2='A'begin
insert into
t_suspended_txn
I need some help running an Oracle education
CDROM.
I am taking the 9i Certification course via CDROM for
1Z0-007.
I attempt to start the installed CDROM with Start/ Run.
I go to the D: drive and it automatically selects autorun.exe. When I hit
run is asks if I want help? If I say no,
What is the average row length?
Waleed
-Original Message-
Sent: Wednesday, December 04, 2002 12:49 PM
To: Multiple recipients of list ORACLE-L
freelist groups is 1
-Original Message-
Sent: Tuesday, December 03, 2002 9:59 PM
To: Multiple recipients of list ORACLE-L
What is
1895
-Original Message-
Sent: Wednesday, December 04, 2002 2:34 PM
To: Multiple recipients of list ORACLE-L
What is the average row length?
Waleed
-Original Message-
Sent: Wednesday, December 04, 2002 12:49 PM
To: Multiple recipients of list ORACLE-L
freelist groups is 1
Hi all
Can I export from a Release 8.1.7.0.0 oracle db to a Release 7.1.4.1.1?
Is there a setting in the export utility to be backward compatible with V7?
Thanks
David
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bartolo, David
INET: [EMAIL PROTECTED]
Fat City
Hey Cary,
No magic bullet? I was afraid you were going to say that. :)
I see that there are some parsing issues from the first of many 10046
traces. Most of these high-parsing statements are generated by Oracle when
a Context index is used in a query. The good news, if TKPROF output can be
Hi Lyndon,
Well I don't know about your setup, but I can connect just fine with the connect
string you listed below on Win2K, Oracle 9.2.
--
Alan Davey
[EMAIL PROTECTED]
212-604-0200 x106
On 12/4/2002 2:09 PM, Lyndon Tiu [EMAIL PROTECTED] wrote:
This is unfortunate or maybe just it's just
How do you startup shutdown the database on NT/W2K ?
As I am able to, from the DOS Command Prompt
set oracle_sid=orcl
sqlplus /nolog
connect / as sysdba
startup pfile=initorcl.ora or shutdown immediate
Just fine, at least with O 9.2
-Original Message-
Sent: Wednesday, December 04,
Lyndon - I have completed 2 of the 5 Oracle8i exams.
Hey - when I took each exam, the testing organization says that I should
receive something from Oracle within a couple of weeks. Got nothing. Should
I be worried?
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original
We often need to refresh test and development databases with exports that
have extent sizing a lot bigger that what we want. In test and ESPECIALLY
dev, space and file system availability often require us to just get
something working without regard for performance. In these cases, extent
Randy,
I don't think the JVM is missing.
try installing the $ORACLE_HOME/plsql/jlib/plsql.jar file using sqlloader.
the class files from this file are what are missing.
hope this helps
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, December 04, 2002
Title: RE: Recipe for application design to run on RAC
So
when I access the fantasy football league on the espn web site-I go to schema2
because my team(s) are losing :-)
I guess thats what I get when I picked a group of guys
that are all on the injured reserve
Seriously though--What if
Alan, I think what Lyndon meant is this
SQLNET.AUTHENTICATION_SERVICES thing on MS Win that
toggles your ability to connect with the syntax
described. Comment it out and you might see something
like ORA-1031
--- Alan Davey [EMAIL PROTECTED] wrote: Hi
Lyndon,
Well I don't know about your
Thanks Sean.
I installed 9iR2 on both my laptop and a desktop, both
running RH 8.0.
Pretty straightforward, except for the usual failure in linking
intermedia. I would have thought they would fix that by now.
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/04/2002 09:44 AM
Please
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:
Hmmm. So it's a config issue then. I will certainly poke around a bit more. See
what happens if you send a Unix person to do a Windows job :
I'm 100% sure though that setting up Oracle on NT to work like Oracle onUnix is
different so it is still possible that a bunch of OCP Unix Oracle DBA's
Harvinder,
Let's see what we can come up with:
insert into t_suspended_txn
select 'A', 'B'
from dual
where exists (select col1 from t_suspended_txn where col2 = 'A')
Although I don't honestly know if dual exists in SQL Server (in Oracle
it's a single row, single column table - you could easily
Dennis,
IIRC you receive certificate from Oracle only after completion of all 5
exams.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, December 04, 2002 4:13 PM
Lyndon - I have completed 2 of the
Hi All,
Oracle 8.1.6, NT 4.0, Forms/Reports 6i,
Has anyone had any trouble using global temp tables in above environment or
elsewhere where it cause Oracle to complete lock up. Only way
out was to kill oracle.exe...not a good thing. I have found some postings
on MetaLink that may be related
Kirti,
Thanks for suggesting the Note, I'm reading it now. I tried replying to you
directly but my thank you was blocked by your company's spam filter. I'm
really curious to know what key word flagged it as spam. Oracle?
Jay
-Original Message-
Sent: Wednesday, December 04, 2002
I know I know (he says jumping up and down) Just did the 9i New Features
class.
The answer is lazy dynamic remastering. Over time, resources are gradually
moved to the instance that is using them.
More quotes from the manual:
Should an instance leave the group, the background processes only
When you say at least with O 9.2, does this mean we cannot do this in 8i ?
We have 8i on EnTee and WinTuKee.
Thanks.
--
Lyndon Tiu
Quoting Cornio, Georgette Ms USACFSC [EMAIL PROTECTED]:
How do you startup shutdown the database on NT/W2K ?
As I am able to, from the DOS Command Prompt
I certainly did not get anything after each exam, only after each level. I got
the OCA level certificate and a letter from some Veep two weeks after I
completed the second 9i exam (which I'm happy to say I did before the Sept. 1,
2002 deadline !!!).
--
Lyndon Tiu
Quoting DENNIS WILLIAMS [EMAIL
Title: RE: Recipe for application design to run on RAC
Greg,
FantasyFootball is a different beast and is not hosted on this database. This one deals with live scores and the bottomline ... g.
There are only few tables that are shared by both schema, 50% ownership .. hasn't happened yet. We
Title: RE: Are Oracle courses required for Oracle Certification now?
I
haveused the service level stuff also,but wanted
to figure out the DOS Sqlplus stuff,
soif there is a problem with the
database,
and need to do a startup mount or a recovery,
or do all those nice command level stuff that
David:
You always want to use the older export utility when exporting from an older DB version, and use the new import untility to import into the newer database.
To export from an 8.1.7 database, use the export utility from the version 7 database and export using a link to the new database (exp
OK. Thanks.
--
Lyndon Tiu
Quoting Boris Dali [EMAIL PROTECTED]:
Alan, I think what Lyndon meant is this
SQLNET.AUTHENTICATION_SERVICES thing on MS Win that
toggles your ability to connect with the syntax
described. Comment it out and you might see something
like ORA-1031
--- Alan
I guess this is reason.
pct_used and pct_free are very closed. after the deletion if the pct_free is
just below 75% it will join the free list.
Suppose the block header is Y bytes.
And you have pct_free = 10% and pct_used = 75%, this means if a block is 30%
free (70% used) it will have
(4096
Title: RE: Export from Oracle 8 to Oracle 7
Just use an Oracle7 client to do the exp
-Original Message-
From: Bartolo, David [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 12:49 PM
To: Multiple recipients of list ORACLE-L
Subject: Export from Oracle 8 to Oracle 7
Yah. That's what we do on EnTee/WinTuKee.
Also, on DOS prompt:
oradim -startup -sid=SID -pfile=PFILE PATH
But on EnTee, I think you can't do, at least I couldn't, maybe someone has tried
this and it worked for them 8i on NT4/W2K:
sqlplus /nlolog
connect / as sysdba
startup nomount
create
Give the man a cigar. (virtual one of course :)
That is what I was looking for and makes unix uptime and db_uptime.sql
report a compatible time frame.
Thanks Jared.
Stephen
[EMAIL PROTECTED] 12/03/02 04:02PM
Try:
col uptime format a40 head 'UPTIME'
select to_char(sysdate,'hh:miam')
Sorry, I've just seen these stats:
num_freelist_blocks: 2266966
avg_space_freelist_blocks: 3895
My message completely contradicts with that fact, so forget about it except
if the statistics are wrong.
Too weird! let's know what you find.
Is it partitioned? What is the extent size?
Waleed
Are you getting a sheet after each exam showing how many you got correct
for each section and your overall score? I received that sheet at the
testing center after each exam. Other than that, you won't get anything
from Oracle until you finish your final exam. It took me about a month 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,
Thanks, but I'd rather have a nice shot of Scotch.
:)
Jared
Stephen Andert [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/04/2002 03:39 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE:
Dennis, I hate to see do all this jumping up and down
but the dynamic re-mastering feature was not
implemented in 9i.
There is a view called V$GCSPFMASTER_INFO that is
supposed to show which node was the master, which node
is currently the master and how many times the
resource has been
Thanks, Raj.
H... it is probably not an good example ...
Why not? On the contrary. I am sure damanagement here
would love to here this. Besides it fully supports
Oracle's statement that application can be migrated to
RAC as is (as I think Hemant mentioned).
Wait... did you say 9i? release
comments inline...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, December 04, 2002 8:53 AM
Whoa! Tim, thanks a lot for sharing this. Quite an
insight.
So SELECTs are not a concern.
Well, not directly. They do not directly cause
Folks,
I know that when creating indexes a couple of settings such as
SORT_AREA_SIZE can have a big impact on duration. What settings apply
during online rebuilds? Are the rules the same? What tips do you have?
Basically we have some very large indexes in an OLTP system (several
indexes are
Hi Stephen
The program is functional but not necessarily
elegant. Of course, no guarantees about anything are made. If you make
any
improvements, I would be most appreciative if you sent them.
If you need this sort of thing you might consider having a look at the
freeware DBATool. It is
98 matches
Mail list logo