Hi All,I have been working with client, where the refresh of the reporting instance is happening every 12 hrs due to business needs. This process is very well defined and the users are very happy. Even the concurrent requests are xfr to new reporting instance. I would take it offline and the
Jared,
I would have preferred RAID 10, and that is what I has asked for, but did not apparently receive. I've lost RAID 01 volumes due to a failure of 2 drives, where a RAID 10 volume would have survived.
This reminds me of a crowded flight I took where I read reading an OCP study guide.
The 2
Hello! I have two win2000 servers with two oracle databases one by one on
each of them. Both servers has VirVit user in Administrator and ORA_DBA
group. In OEM Preferred credentials are set correctly (observing register).
So, why I got this error???
VNI-2015 : The Node preferred credentials for
Yep, I missed this userenv part totally, even though I posted the source
here myself as well.
Gotta get better eyes from somewhere ;)
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, November 19, 2003 5:10 PM
Tanel,
Raj must be
Set either ORACLE_SID or LOCAL to your default SID in either Windows
environment variables or registry.
The general difference between ORACLE_SID and LOCAL is that, with ORACLE_SID
you can specify only instances in local server, but with LOCAL you can set
any TNS alias (the same as TWO_TASK in
Grant Logon as Batch Job Windows privilege to your Administrator user.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, November 20, 2003 9:19 AM
Hello! I have two win2000 servers with two oracle databases one by one on
each of
Something our Unix admins tend to do is move the files along different
directories.
E.g. they start in dir1; after succesfull backup, move them to dir2, etc.
and after succesfull backup in dir4 delete them.
So they should always get backed up 4 times even if you miss a run.
Of course your backup
Ryan,
I took my exam yesterday and passed!! I used the Oracle Press - OCP Oracle
9i Database: New Features for Administrators Exam Guide book. Even though
there are a number of inaccuracies it was good preparation especially the
sample exams it provides. Regarding 9.2 vs 9.0 content in the exam
Paula
We are working with OEM that come with Oracle 9.0.1
(upgrade to 9.2.0.4 if the next week - hopefully).
We are working with the repository with no problems.
I defined a query that collect tablespace size and % free.
I just now used the OEM to display a chart and prepare HTML report of this
how does dimensional modelling used by datawarehousing fit into relational theory?
From: Daniel Hanks [EMAIL PROTECTED]
Date: 2003/11/19 Wed PM 04:35:03 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Any articles/books that take relational theory and make it
Title: Message
Hmm
The
small print on compaqSANS specifically states that you shouldn't pull
drives 'for testing purposes' but only do itin the event of a drive
failure. I wonder if other vendors say the same thing to avoid exactly this
stuff.
Mind
you however I think of itI still
Title: Message
Hi
I
*think* but I may have entirely misread the comment that point 4 is just wrong.
It sounds like you only have one raid 5 set (which is shared between 2
machines). If this is the case then the clustering has no effect on the fault
tolerance/performance of the raid 5 set.
Verification was easy. We just powered down the primary machine, changed the
db name in the external table, drop the replication on the backup server and
restart the application. Everything worked fine. After 2-3 days, over the
weekend, we rebuilt the replication again.
Yechiel Adar
Mehish
-
_wait_for_sync basically meant that a session is waiting for the sync of the
redo by the lgwr. Normally the redo log writer writes to disk and then
notifies the session that the transaction is completed. By setting this to
false, you no longer wait for the redo to go to disk.
That has no impact
This one is easy:
look in v$waitstat. That has the class numbers for all block classes. Then
add to that the undo segments. Each undo segment has two types of class. A
undo header class and undo block class. So by looking at v$waitstat you
should be able to tell that 36 is a undo block that
Hi Shibu-
Can we share your template so as to be able to fill in the gaps, and also get
an idea of what you think a healthy DB should be like?
CSW Simon.
-Original Message-
Shibu MB
Sent: Wednesday, November 19, 2003 4:50 PM
To: Multiple recipients of list ORACLE-L
Hi all,
Oracle has its own heap management, which will call sbrk(). So there used to
be no malloc() function call.
I think that it is a combination (ll and da).
Anjo.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, November 11, 2003 3:29 PM
my
I was at an Oracle usergroup meeting last week and a guy at Oracle said the following
happened. Can anyone confirm? Just curious.
1. Orbitz did an upgrade to some software other than Oracle. I think it was firmware.
They did NOT test it first. Did it directly in production.
2. This corrupted a
Anjo,
I also thought it affects only lgwr sync, but Jonathan Lewis once told that it affects
any disk writes...
If it affects only lgwr, then great, I can make Apps upgrades, which do really lots of
DDLs and small transactions, quite much faster that way...
Thank you,
Tanel.
_wait_for_sync
Gilles,
What about the OFA admin subtree (create, pfile, udump,bdump..) ?
Did you duplicate it on each node ?
Each node will have its own ADMIN subtree (/u01/app/oracle/admin/prod/). Make sure
the following parameters are configured in INIT.ORA file:
# First instance specific parameters
Well,
some disk writes need to wait for the LGWR to flush the corresponding redo
to disk. So now you can have a situation that the blocks that are dirty are
on disk (without a commited transaction) but the redo is not yet. So if you
crash in that period, you can't recover.
Anjo.
- Original
Tanel,
Did you observe better performance? By how much? Do please let us know!
From what I read, _wait_for_sync when set to false means LGWR immediately
notifies user (foreground) processes that redo record writes are done (even
though they're not). When you say the parameter only affects LGWR,
Wow. Restoring a control file from tape for this situation? Man, that's
not just wrong, it's fundamentally wrong. At a high-profile site that must
have Gold Support (or whatever they're calling it today), if this is true
someone was really not thinking that day.
Kinda interesting about the
The message I posted a minute ago may be wrong in one aspect.
From what I read, _wait_for_sync when set to false means LGWR immediately
notifies user (foreground) processes that redo record writes are done (even
though they're not). When you say the parameter only affects LGWR, you need
to
oracle support has a bit to be desired somedays,
sceanario: someone(CE) accidentally makes the prod SAN, a scratch pool
instead of the new SAN. Literally wipes it clean, think of fdisk like.
get OS reloaded, oracle binaries reloaded, need to do restore/recovery
via rman, repository wasted
I don't know whether this is true or not, but this case written here shows exactly why
RAC does not give you real high availability, the database itself remains single point
of failure.
Tanel.
I was at an Oracle usergroup meeting last week and a guy at Oracle
said the
following happened.
I think my understanding was wrong. _wait_for_sync actually only changes the
behavior of foreground processes. When set to false, they don't wait for LGWR
to write redo records to disk; instead they continue to do their work as if log
file sync already finished. It *does not* change any behavior
Title: Using miss-spelled hint changes explain plan ...
Okay,
I found this by accident ...
I was trying to get explain plan on a query that involved a in-line-query that selects from financials database. This in-line query was alias'd as A. Current cost of query was ~2800.
So, to test
:)
I admit, that I don't know either, which processes are affected by this parameter.
If foreground ones are, that should mean that after posting lgwr, they won't wait on
semaphore and continue their work.
If it affects lgwr, it means that lgwr posts the waiting processes immediately back
Hi!
Yup, I was bold enough to use this parameter during production upgrade only because it
worked well in several tests and simulations.
Cheers,
Tanel.
Well,
some disk writes need to wait for the LGWR to flush the corresponding
redo
to disk. So now you can have a situation that the
Hi,
In coming weeks I have to work on a project to Support Oracle databases on
NT/Windows 2000. I have unix background supporting Oracle adatbases on a
smaller scale hence not much skill was rqquired.
I shall appreciate your guidance/experience to point right resources for
NT/Windows 2000
I have not read through the entire thing but from what I have seen so far, I
like Data Modeling for Everyone by Sharon Allen (CurlingStome Publishing)
ISBN 1904347002.
It covers the theory to the implementation (Logical - Physical
transformation).
From: [EMAIL PROTECTED]
Reply-To: [EMAIL
Hello:
I'm looking at trying to tune a 3rd party app and was wondering if anyone
could tell me if my assumptions are on base. The table contains three
columns, each is part of the primary key, with about 1 million + rows. I
figured that it would be an ideal candidate for using a partitioned
Tanel,
Did you observe better performance? By how much? Do please let us
know!
Oracle Apps upgrade between major releases involves running hundreds of thousands
scripts in bigger cases. Some of there scripts execute bigger transactions, but
majority execute lots of small transactions and
The Orbitz fiasco and what happen was up on Public radio here about a week after the
mess. They interviewed the CIO who sounded like a trusting soul looking to get
screwed. According to her, she was informed it was a database problem by her smart
people. I therefore would conclude that
Title: RE: orbitz fiasco
On my Soapbox
My expensive free advice
RAC *can* provide a higher level of availability. It isn't the complete answer, but offers a level of improvement. But one needs to consider the complete infrastructure for high availability(Web servers, app servers, db servers,
RE: orbitz fiasco
On my Soapbox
My expensive free advice
RAC *can* provide a higher level of availability. It isn't the
complete answer, but offers a level of improvement. But one needs to
consider the complete infrastructure for high availability(Web
servers, app servers, db servers,
The infamous event log file syncwill basically disapear. So you can see
what this does to the system, by looking v$system_event to see how much log
file sync there is.
Anjo.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, November 20,
Title: Using miss-spelled hint changes explain plan ...
If you
miss-spell a hint,it is ignored.
select
/*+ FULL (PERSON) */ full_name from person where emplid =
'123456';
Execution
Plan--
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=56
Unfortunately according to Amazon.com this book is out of print.
Ken Janusz, CPIM
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, November 19, 2003 8:40 AM
Data Modeling Essentials by Graeme C Simsion is a very good book.
American
Hi All,
We are trying to access SQL Server data from oracle database. Am trying to use Oracle
Generic connectivity for the same. When I try to access the SQL Server table through
the link I get the error
ORA-2854: error diagnosed by Net8 when connecting to an agent
NCRO: Failed to make RSLV
Jay,
On the paper, your table is indeed a good candidate for an IOT - it will save you
the space used by the table (you will only have the primary key index). However, there
may be gotchas. I have noticed in the past that IOTs, being primarily indices, have a
tendency to be a bit 'sticky'
Title: Using miss-spelled hint changes explain plan ...
Did you see any
changes in the Execution plan?
Waleed
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]Sent: Thursday, November 20,
2003 10:20 AMTo: Multiple recipients of list
ORACLE-LSubject:
Just moving from HPUX with Oracle 7.3.4 to Win2K with Oracle 9i EE and 9iAS.
1) Connectivity Tools?
I am using PCAnywhere. Actually did a remote install and avoided the hassles
getting through security at the host site. (Server support uses Terminal
Server).
2) NT administration
Title: Using miss-spelled hint changes explain plan ...
Yes, see my latest reply ... please.
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly personal. QOTD: Any
Was this on AIX by any chance ??
Raj
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
The foreground process is affected. Instead of waiting for the LGWR, it will
return right away.
Anjo.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, November 20, 2003 4:24 PM
in parallel
:)
I admit, that I don't know either, which
The only thing high about 9.0.1 was the people who installed it to use in
production.
My 12-step process is now completed. And I didn't even mention OiD once.
:)
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex,
Nope, TRU64
Tanel.
Was this on AIX by any chance ??
Raj
--
--
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an
there are used copies for sale right on there.
From: KENNETH JANUSZ [EMAIL PROTECTED]
Date: 2003/11/20 Thu AM 11:20:15 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Any articles/books that take relational theory and make it
Unfortunately according to
At 05:40 20/11/2003 -0800, you wrote:
3. However, they chose to restore the control file from tape. This
invalidated their database.
Maybe I'm missing the obvious, but why does this invalidate their
database? Don't you just do RECOVER DATABASE USING BACKUP CONTROLFILE ?
(Agreed that it would
the guy who spoke from oracle said that 9.2 is much better than 9.0.1 RAC. anyone use
it?
From: Jesse, Rich [EMAIL PROTECTED]
Date: 2003/11/20 Thu PM 12:19:59 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: RE: orbitz fiasco
The only thing high about 9.0.1
Title: Message
Hi
I agree with you on point 4 and the
SA here also confirms that the Manager has his facts wrong on this point.
I havent seen much here in terms of
quantitative measurement of IO I can ask around. Id like
to do DBA work, but they have me working on an Data
we implemented RAC (not me personally --but my predecessors) It did not
work for us. Oracle RAC does not support TAF for sessions coming through
dblinks.(Yes verified this with Oracle product development). But that is a
application architecture issue. If your app does not require this feature,
I
According to a post in this subject several months ago ( from Cary Millsap I believe )
the storage vendors have huge investment in RAID 5 code, and therefor want to
push it as much as possible.
Jared
Niall Litchfield [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/20/2003 04:44 AM
Please
Hear, hear!
pb
--- Michael Milligan [EMAIL PROTECTED] wrote:
As Date is want to say, Theory is practical! (Chapter One,
Relational
Database Writings 1991-1994).
IMHO, a lack of understanding of relational database theory leads
directly
to database designs so flawed that they can't
Chris,
Care to share details on the inaccuracies?
Jared
Dunscombe, Chris [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/20/2003 02:44 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: RE: OCP 9i New
Why in an IT shop - do us DBA's only seem to understand this? As I see it most
programmers don't understanding data models at all! It makes it easier for them to
ignore the DBA's as being theoretical, academic
-Original Message-
Sent: Thursday, November 20, 2003 1:30 PM
To:
Well, Pascal has this to say about it:
http://www.dbdebunk.com/page/page/622521.htm
(This also links to some comments by Date on some articles by Ralph Kimball).
What it comes down to for me is this, the relational model provides a way (by being
based on set theory and predicate logic) to
Congratulations to the following folks that appeared in the 2003 Editors Choice Awards
( I finally received my issue of the mag )
Arup Nanda - DBA of the Year
Tony Jambu - Consultant of the Year
Mogens Nogaard - Educator of the Year
Tom Kyte - Oracle Book Author of the Year
There were many
Murali,
Could you point us to a document about the TAF and database link issue? Thanks.
Yong Huang
--- Murali_Pavuloori/[EMAIL PROTECTED] wrote:
we implemented RAC (not me personally --but my predecessors) It did not
work for us. Oracle RAC does not support TAF for sessions coming through
Yong,
That is the problem. It is not documented. I think that is the reason why
we went down that path of designing our application. I have an email from
oracle rep (RAC team member). He confirmed that with Oracle product
development.
We were running RAC on Tru 64. I was told that it is an
Congratulations to all the award winners!
Btw,
do they get any cash awards or just a piece of paper?
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Thursday, November 20, 2003
2:05 PMTo: Multiple recipients of list ORACLE-LSubject:
Oracle Magazine
Yes. We have a 9.2.0.4 test system based on the How to Build a $1000 RAC
whitepaper (www.bradmark.com/site2/products/pdfs/9irac_config.pdf), although
we spent about $1100. After much ado about everything, it's been up and
running on RH9 for almost a month uninterrupted (would've been 2 or 3
Me wonders if the optimizer ignores all the hints after the first
misspelled/malformed one. What happens if you change the order of the hints:
FROM (SELECT /*+ INDEX(C PF_EVENTS_N2) INDEX(G PF_ACCOUNTS_U2) ORDERED
driving_site(a) */
and
FROM (SELECT /*+ INDEX(C PF_EVENTS_N2) INDEX(G
Just a congratulations is nothing. For one, Arup should tell us the secret of
achieving the .03 second transaction goal on a 7-terabyte OLTP database. How is
that done? What advice can he give?
Yong Huang
--- [EMAIL PROTECTED] wrote:
Congratulations to the following folks that appeared in the
Sometimes Peer recognition is more important that pitiful
cash.
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly personal. QOTD: Any clod
can have facts, having
Paula - It may get worse. A noted O-O author said a database is just a
means to persist an object. I also see a lot of young developers that
haven't taken much Computer Science, so haven't been exposed to underlying
theories like relational modeling. Well, we DBAs just have to be lights
shining
BINGO !!
Thanks Wolfgang if I put the misspelled hint at the end, it is ignored ... all
plans look the same then.
Another (probably) undocumented feature.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All
We have been production on 9202 for a while and testing 9204. Our experience is good
... we run active-active.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly
No, I prefer the pitiful cash. You take the recognition, I'll take the money and run.
On 2003.11.20 14:50, Jamadagni, Rajendra wrote:
Sometimes Peer recognition is more important that pitiful cash.
Raj
Hi,
I'm experiencing an
ora-600 during migration of a 7.3.4 to 9.2.0.4
Error occurs during issueing alter database open resetlogs
migrate
All previous steps (all
according to the migrate manual):
Migprep
Mig
Alter database convert
Succeeded successfully
Details:
HP-UX 11.11
which noted O-O author said that about DBs?
From: DENNIS WILLIAMS [EMAIL PROTECTED]
Date: 2003/11/20 Thu PM 02:59:58 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Any articles/books that take relational theory and make it
Paula - It may get worse. A noted
what is TAF?
From: Jesse, Rich [EMAIL PROTECTED]
Date: 2003/11/20 Thu PM 02:45:19 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: RE: orbitz fiasco
Yes. We have a 9.2.0.4 test system based on the How to Build a $1000 RAC
whitepaper
OK, that's what I get for not R'ing all TFMs before opening my mouth -- is
active-active Oracle RAC-based failover as opposed to OS-based failover?
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
Transparent Aluminum Failover.
Whoops -- that's Application if you're not in Star Trek IV...
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
-Original Message-
Sent: Thursday, November 20, 2003
Jeroen - What priority did Oracle assign the TAR? Given the seriousness of
your situation, you should get it rated a priority 1. Is there any
possibility you can export/import your data instead of performing a
migration?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original
2 interesting comments on RAC from a well known financial institution in
the UK.
1. They didn't do TAF because it requires rewrites of the apps (and this
was a cost saving exercise) and in any case if one node fails the
affected end-users look at their neighbours who are still working (on
-Oorspronkelijk bericht-
Van: Jeroen van Sluisdam
Verzonden: donderdag 20 november 2003 21:41
Aan: 'DENNIS WILLIAMS'; '[EMAIL PROTECTED]'
Onderwerp: RE: ora-600 / ora-00604 during migrate
Dennnis,
Priority 2. I have tried export but after 3 days of experimenting
And not getting
Comments interleaved
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of M Rafiq
Sent: 20 November 2003 15:45
To: Multiple recipients of list ORACLE-L
Subject: NT/WINDOWS 2000 resources for ORACLE
Hi,
In coming weeks I have to work on a project
Hi
You can use the htp and htf packages and owa_util to generate HTML
around your queries and send to a file using utl_file. You can also use
sqlplus to generate html around your queries, just look at the -M
option.
kind regards
Pete
--
Pete Finnigan
email:[EMAIL PROTECTED]
Web site:
I don't think so ... by active-active I mean we have clients connected on both nodes
performing transactions. One some databases we have TAF implemented in the code, so if
client looses connection to one node, it immediately reconnects to the other node (and
in most cases users don't know).
I
Title: RE: Oracle Magazine Awards
Cash is King
Give the guy the pitiful cash:-) Now you need to setup a donation website;-)
-Original Message-
From: Mladen Gogala [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 20, 2003 3:10 PM
To: Multiple recipients of list ORACLE-L
Subject:
YOU may send the winners some cash
Tanel.
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent: Thursday, November 20, 2003 9:24
PM
Subject: RE: Oracle Magazine Awards
Congratulations to all the award winners!
Hi!
It seems that my post of performance gain by setting the parameter has got
lost somewhere.
Anyway, a step in Oracle Apps upgrade process, which involved running about
3 scripts (probably more than 10 DDLs and commits in it), ran about
3-4 hours, while without this optimization, it ran
we implemented RAC (not me personally --but my predecessors) It did not
work for us. Oracle RAC does not support TAF for sessions coming through
dblinks.(Yes verified this with Oracle product development). But that is a
application architecture issue. If your app does not require this
Transparent application failover. You can redo your code so that it is
rac aware and switches to another node in the event of a node failure.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of [EMAIL PROTECTED]
Sent: 20 November 2003 20:21
To:
Hi ,
Does anyone have a sample code to insert/update/delete a BLOB into a table
from a
stored procedure.
Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Basavaraja, Ravindra
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
Sorry,
I don't have that much "pitiful cash" :)
-Original Message-From:
Tanel Poder [mailto:[EMAIL PROTECTED]Sent: Thursday, November
20, 2003 4:26 PMTo: Multiple recipients of list
ORACLE-LSubject: Re: Oracle Magazine
Awards
YOU may send the winners some cash
Tanel.
Its windows - its all clicky clicky clicky - no skill required :(
Yeah, I tried to install a two-node Data Guard setup today - and go the
easy way and use OEM GUI.
I ended up with digging into intelligent agent traces and sniffing the
network traffic to figure out why the fck doesn't anything
What was wrong with export?
How big the database is?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Jeroen van Sluisdam
Sent: Thursday, November 20, 2003 3:45 PM
To: Multiple recipients of list ORACLE-L
-Oorspronkelijk bericht-
Van: Jeroen van Sluisdam
Verzonden:
We do
- we have bought their books!!
-Original Message-From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Thursday, November
20, 2003 4:50 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Oracle Magazine Awards
Sorry, I don't have that much "pitiful cash" :)
The _disable_logging parameter was invented by oracle to counter speed claims of the
databases which did not have such thing as logging (first version of Informix, Sybase
Ingres)
and which was known in the mainframe world as journaling (in the version 51.22, this
feature
was known as AIJ or
And
also an increase in the price ot their Oracle license.
;o)
Dave
-Original Message-From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Thursday, November
20, 2003 1:25 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Oracle Magazine Awards
Congratulations
Title: Message
One of
the issues in this situation is that the drive sleds usually have circuitry in
them to insure electrical isolation and that oncea disk is marked as dead,
the disk is spun down and kept from placing any traffic onto the backend
bus. When a disk is just pulled, problems
You can also check v$access and v$session for any active sessions accessing
that package.
Jay Miller
-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 18, 2003 5:34 PM
To: Multiple recipients of list ORACLE-L
This was discussed on 31-October and look in the archives
Yeah, tell me, too!
I'm about to teach a 5-day course for passing OCP
in January. Don't mind if I post completely inaccurate answers to this list at
this time, I just have to change my way of thinking for then ;)
Tanel.
- Original Message -
From:
[EMAIL PROTECTED]
To:
Well, it depends on how you mean a SAN - technically, all of the TPC-C
benchmarks use a SAN, as they're using a switched fabric fibre channel
architecture. Now, they're not using the big honking array type of SAN,
but its a meshed Fibre Channel fabric regardless.
In a small SAN, there's no
Yeah, there's basically the inherent RAC clustering - when a node dies,
another one takes over responsibility for recovery of its redo logs and
so-such. The cluster software prevents a node from magically rejoining the
cluster if it suddenly comes back (think of stop-a on a sun server, followed
Performance measurement on windows is done via a tool called perfmon,
which works on a 'counters' basis. That is you add 'counters' which are
performance metrics to the tool and display the results on screen or
write them to a log for later analysis. Counters include things like
%CPU,
1 - 100 of 107 matches
Mail list logo