releasable locks.
Fixed fixed locks are not really eliminated, but it seems
that using them will disable cache fusion entirely.
It will be interesting.
-Don Granaman OraSaurus
Jenner Mike wrote:
Isn't the concept of a private RBS only applicable to parallel server
setups?
- Mike
overriding it disables the main new advantage of RAC over OPS.
However, the clarification is useful.
It seems that we agree on the best practices though and if they are
followed, the points of contention (pun intended) are largely moot.
Don Granaman OraSaurus
PS: Now that we have put everyone
than a computer search - and with a lot less extraneous
(click/point/scroll/type) activity.
6) Highlighters, margin notes, and sticky-note bookmarks don't work at all
with CDs
I miss hardcopy manuals!
Don Granaman
[certifiable OraSaurus]
- Original Message -
To: Multiple recipients of list
or unique key constraint indexes
in BAD_ONE, etc.). There are a few variations on the theme for step 5 - for
example, recover datafile perhaps if all the datafiles for the tablespace
are not corrupted.
Don Granaman
[certifiable OraSaurus]
- Original Message -
To: Multiple recipients of list
several times per week! (The most recent,
about 48 hours ago, was because nts hiccuped and the clocks on the two nodes
got about 1/2 hour out of synch.)
Don Granaman
[OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 16, 2002 9
the listener on a node other than the one intended? This kind of stuff
probably happens a million times more often than things like SQL injection
attacks.
Sound security practices make both accidental and malicious damage much more
difficult.
Don Granaman
[OraSaurus]
- Original Message
is something we are reserving as a last,
temporary resort.
Don Granaman
[OraSaurus]
BTW: Hi Mike!
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 24, 2002 7:23 PM
Mike,
What is the version of the database? Some versions of 8.1.7 had a few
Unfortunately, we have no choice but to use the java-infested, half-baked
ruinStaller.
Don't even get me started about the DataBase Cremation Assistant!
Don Granaman
[OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002
. However, public synonyms can be a performance
issue and *may* be undesirable for other reasons.
Don Granaman
[OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 01, 2002 11:28 AM
try this:
rather than granting specific privs
needed to be very
positive. Granted, that was over a year ago and the product may have
improved since then, but as recently as a few months ago a registration
for a trial download on the web lead only to a marketing call.
No thanks... I feel a bit queasy even now just thinking about it.
Don Granaman
on Linux - exclusive and RAC - but not yet production. On the
9.2.0.1 RAC nodes, I'm getting tons of trace files with CMInit warnings, but
support said Don't worry. Be happy. Its OK Searching for patches for
9.2.0.1 on Linux, I get 22 hits. Most are related to some bug ;)
Don Granaman
[certifiable
salary
from the list.
Don Granaman
[OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, May 22, 2002 8:28 PM
...and you have to share a single motel room with 11 other people (3 shifts
of four), surrender accumulated frequent-flyer
To steal a quote from Matt Adam's white board (sorry Matt!):
You gotta stop thinking logically, and start thinking Oracley - Jim Droppa
Don Granaman
[OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, May 22, 2002 2:00 PM
considering it.
Don Granaman
[OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, June 04, 2002 1:09 PM
Cache? What is cache?
-Original Message-
Sent: Tuesday, June 04, 2002 1:44 PM
To: Multiple recipients of list ORACLE-L
About Us -
Careers - DB2/Oracle DBA ... or:
http://www.cabelas.com/cabelas/en/templates/community/aboutus/career-details
.jhtml?contentId=MIS_DB2_Oracle_DBAhierarchyId=10708
Don Granaman
[OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent
, 2002? September 2002?
Don Granaman
[OraSaurus - with more disdain than ever for the evil vampire Larry's OCP
DBA tax]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, June 21, 2002 12:23 AM
I thought employees were not allowed to write things
, and a control file. Just
slap them down, copy redo members control if necessary, and startup. Very
handy for repeating variations of tests from the same consistent known
state.
Don Granaman
[OraSaurus - Oracle 6 backup habits die hard!]
- Original Message -
To: Multiple recipients of list
Developer Programme?
Evidently, it didn't turn out to be the cash cow it was expected to be, so
it quietly disappeared. Don't know about anyone else, but I didn't get a
refund.)
Don Granaman
[Curmudgeon OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
was the granddaddy of OPS]. I don't know about 6.1, but if there
ever was such a critter, I suspect that it was VMS-only also.
Don Granaman
[OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, June 25, 2002 12:08 PM
There was a 6.1
I missed this part in my previous response...
Does anyone remember why there never was a 9.1?
We seem to have gone directly from 9.0.x to 9.2.0!
[Did I miss somethng while taking a nap sometime recently?]
Don Granaman
[certifiable OraSaurus]
- Original Message -
To: Multiple
that the app isn't submitting
any/much work.]
Another possible alternative is the Etch-a-Sketch approach. Give them
whatever kind of nonsense appeases them to get them off your back so you can
do useful work ;-) Of course, there are potential issues with this as
well!
Don Granaman
[certifiable
Two words: wait events
I'll forward, in private mail, a posting I made here on April 21, 2002 with
some pointers to sites...
(The subject line was Re: ioug-a question)
Don Granaman
[certifiable OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED
for modularity) to
create a large iapx (?correct name for version?) executable within a
segmented 16-bit architecture. [These young whipper-snappers today have it
SO easy!]
Don Granaman
[OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday
. I always seem to get chances to drag them off for a little
one-on-one time or at least some ad hoc small group discussion. (Its nice
to have friends in low places!)
Don Granaman
[certifiable OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent
[...]
Don Granaman
[certifiable OraSaurus - nOCP]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, June 26, 2002 6:25 PM
Work experience is better than certification but ...
Getting certified is hard work. Takes a lot of time and effort
certification was more
like a chauffeur's license.
Don Granaman
[OraSaurus - Just say NO(CP)]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, June 26, 2002 9:33 AM
Well that explains a lot. In a separate post Rachel also said Oracle
From my experience with a few DBAs that waved their OCP around like it was a
Nobel prize, some probably should have malpractice insurance. Lots of it.
Don Granaman
[Certifiable OraSaurus - NOCP]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent
with the best deer in the headlights look I've ever seen.
[It must not have been in the Self Test Software Practice Exams or the Exam
Cram books.]
BTW: Grant: Can I buy that .sig from you?
Don Granaman
[OraSaurus NOCP]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
I thought is was BOB -(Big Orange Button). As in systems administration
by BOB.
Don Granaman
[OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, June 26, 2002 3:54 PM
the little red button is my favorite
-Original
artifical value
of being a common checklist item for hiring authorities now) is to get
people to study, learn, and try things out. However, those things don't
really require a certificate, ILT classes, or checks made out to Oracle.
I agree that this thread is worn out.
Don Granaman
[OraSaurus
like me out there who feel the
same way.
Don Granaman
[OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, June 27, 2002 4:33 AM
I've been pretty quiet while you all said that the OCP program was pretty
worthless because I can see
policy.
Don Granaman
[OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, June 27, 2002 10:13 AM
One of the constant comments regarding rollback segments is not to set
optimal. I am wondering why this setting is often discouraged. I
be in
effect!
Don Granaman
[certifiable OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday, June 29, 2002 9:38 PM
Don,
9i has system managed undo -- you don't think it works yet?
Rachel
--- Don Granaman [EMAIL PROTECTED] wrote:
I
majority of cases, (2) is preferred.
Don Granaman
[certifiable OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday, June 29, 2002 11:53 PM
Hello,
Running Oracle 7.3.4.4 on Win2k.
Trying to implement unlimited extents of the same size
Absolutely! I should have read more closely!
Don Granaman
[Orasaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, July 01, 2002 1:41 AM
For the reported problem, (1) is the only option as (2) is not possible with
7.3.x database
Application Support
Tel : +49 2162 500-576
Fax: +49 2162 41497
E-Mail: [EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Don Granaman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
sure it existed then also.
Don Granaman
[OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, July 07, 2002 5:13 PM
at least... I can't remember now, but I think there was a version of
copy at least as far back as version 5, when I
') and in
the message 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.com
--
Author: Don Granaman
INET: [EMAIL
(on several different platforms, with
several different versions of Oracle8 8i), I simply decided that I
wouldn't bother attempting another cluster install with ruinInstaller again.
Don Granaman
[OraSaurus and command line curmudgeon]
- Original Message -
To: Multiple recipients of list ORACLE-L
column -
98% 'Closed', 2% ('New' | 'Pending' | 'Whatever...'). Change the logical to
interprete NULL as 'Closed' and create an index on ORDERS.STATUS. Queries
for open orders - ('Closed' | 'Pending' | 'Whatever...') become very fast.
Don Granaman
[OraSaurus]
- Original Message -
To: Multiple
versus more
reasoned wait-based tuning.
(setq minor-rant-mode ON)
This is my main complaint about the OCP program. The tests are almost
exclusively knowledge based. The old Chauncey exams had a much higher
understanding requirement.
(setq minor-rant-mode OFF)
-Don Granaman
[certifiable Orasaurus
they may
be seen at more traditional feeding places, but seem to prefer those with a
nearby watering hole.
-Don Granaman
[omnivorous OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, August 15, 2001 12:52 PM
I have a simplistic view
than fire prevention mode,
will most likely find OPS and/or raw devices to be inappropriate choices.
It is my considered opinion that this is why both (OPS and raw) have long
suffered in reputation.
-Don Granaman
[certifiable OraSaurus]
- Original Message -
To: Multiple recipients of list
fewer problems with raws over the last decade+
than with any type of filesystem - far fewer corruptions, mysterious
disappearances, bugs, etc.
A very thorough discussion of all aspects of this would be huge - perhaps a
book (but undoubtedly a very poor seller)!
-Don Granaman
[certifiable Orasaurus
It gets worse... Partitioning is an additional cost option
- even with Enterprise Edition.
-Don Granaman
[certifiable OraSaurus]
- Original Message -
From:
Kevin Lange
To: Multiple recipients of list ORACLE-L
Sent: Monday, August 20, 2001 12:32
PM
Subject: RE
, and stopora in the local bin
directory and call them from /etc/init.d/dbora. This is rather rare though.
-Don Granaman
[certifiable OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, August 24, 2001 9:40 AM
In fact almost all
, it might generate some interesting discussion. It
seems that space management is sometimes almost a religious topic. I
converted to the uniform extents philosophy early - about 1990 - and
confess to being an evangelist.
-Don Granaman
[certifiable OraSaurus]
- Original Message
Yes. People-staff is harvesting email addresses from the list.
-Don Granaman
[certifiable OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 30, 2001 11:16 AM
Uh-oh - anyone else get this ??
-Original Message
of before their call.
-Don Granaman
[certifiable Orasaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, August 31, 2001 4:05 PM
http://www.computerworld.com/cwi/story/0,1199,NAV47_STO63459,00.html
Demand still exceeds supply for IT workers
oesn't it?
Unfortunately, its true. I have references and the complete lack of an
outside life to prove it! Since I left, I've been decompressing and going
through social rehabilitation ["Hi, my name is Don. I
haven'tbeen on a bridge call in over two months." (Smattering of
applause...
never heard of before this. Most likely those particular recruiters got my
name from calling professional aquaintances. It was the sheer volume of
calls in such a short time about a single opening that struck me as
unusual... Like they didn't have anything else going on.
-Don Granaman
[certifiable
and often
outrageously exaggerated statements claiming 99.999% availability and think
that everybody else actually has it (when they don't), so it can't be that
difficult.
-Don Granaman
[certifiable Orasaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED
I would like to see it also. A few months ago,I wrote a whole space management reporting
thing("spaceman"),but it didn't (doesn't?) yet accomodate
partitioning well.
-Don Granaman
[certifiable OraSaurus]
([EMAIL PROTECTED])
- Original Message -
From:
JO
.
The other was better, but won't come across well here since I don't remember
the specifics. Essentially, when starting a new project, Wally and Dilbert
were discussing what they needed - a catchy project name and a database.
When asked why the database, one replied We like databases.
-Don Granaman
. To balance out
I/O, you MUST know the physical layout underneath the logical volumes and
balance the I/O against that.
-Don Granaman
[certifiable OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, September 09, 2001 9:55 AM
Hi Joe
.
-Don Granaman
[certifiable OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, September 11, 2001 8:30 AM
List,
Environment: Solaris 7 : Oracle 817 : OLTP system with stringent throughput
requirements
A transaction inserts
whitepaper on RAID at http://www.quest.com/whitepapers/Raid1.pdf
.
Don Granaman
[certifiable oraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, April 10, 2002 10:38 AM
Hi all,
We are running both a Hitachi 7700E and a 9960 disk
spawning faster than I could kill them, even with a script... It was admin
by BOB time. (BOB=Big Orange Button.) Fortunately, it was on a development
server!
Don Granaman
[certifiable OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday
I don't know about performance, but thick and OCI add one important
element - TAF. I am working now on converting an exclusive Oracle8i system
to 9i RAC, but the front end is thin client (i.e. no TAF).
Don Granaman
[certifiable OraSaurus]
- Original Message -
To: Multiple recipients
Recursion - it called itself endlessly. $HOME/bin (where it lived) was the
leading element of $PATH. After a minute or less, it was thousands of
processes deep. After changing it to /bin/rm -i $* it worked as intended.
Don Granaman
[certifiable OraSaurus]
- Original Message
on
it immediately with a somewhat critical database and has just received all
the hardware this week. I am likely going to try to defer a production date
until after the June release comes out.
Don Granaman
[certifiable OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L
). It will likely go into production within 2-3 months.
Don Granaman
[certifiable OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, April 18, 2002 7:38 AM
Jonathan,
At the seminars I have attended it was pointed out that the :true RAC
, PCTFREE can be set extremely low (1,5,?) for some kinds of objects -
static tables, indexes with strictly inorder data (CREATE_DATE, SEQUENCE#,
etc.).
I agree with always setting PCTINCREASE =0
Don Granaman
[OraSaurus - Honk if you remember UFI !]
- Original Message -
To: Multiple recipients
]
=
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Don Granaman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
-A 2002.
Don Granaman
[OraSaurus - Honk if you remember UFI !]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Don Granaman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access
Craig Shallahamer's anallogy - in the grocery store, one
waits in line, then gets serviced by the checkout clerk. Even if the
wait is moderate, overall response time (grocery store checkout line enqueue
to checkout completed) may be poor because of a slow clerk!
Don Granaman
[OraSaurus - Honk
Do these qualify?
* Far too much emphasis on Oracle's GUI tools (OEM, DBCA, etc.)
* Too little emphasis on understanding too much on knowledge (i.e. rote
memorization)
* Treating ratios as the holy grail of tuning
* etc...
Don Granaman
[certifiable OraSaurus]
- Original Message
(Oracle Certified Wizard) exams - the only ones that will still REALLY mean
anything two years from now. ;-)
Don Granaman
[OraSaurus and curmudgeon in good standing]
PS: I just found my medication (Jack Daniels) and shouldn't have another
relapse soon. My apologies...
- Original Message
%.
Any CEO waits are considered unacceptable.
Don Granaman
[OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, April 23, 2002 3:33 AM
[...]
I would also like to point out that not all 'hit ratios'
are bad. The FAN hit ratio
bias.)
Don Granaman
[OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, April 24, 2002 11:03 PM
I think an excellent Oracle kernel enhancement would be to bias in the
LRU scheme against SQL that uses literals, just like the buffer
survival. And,
obviously, it did nothing to avoid the wildly excessive parsing.
In other words, I agree - flushing the shared pool is curing symptoms, not
the disease.
Don Granaman
[cranky old OraSaurus with enough war stories to publish a multi-volume set]
- Original Message
* clueless, then what might be? I tried to
explain to them that anyone who said they were qualified should be
disqualified - as blatantly dishonest.
Don Granaman
[OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, April 29, 2002 1:48
years experience to anything mentioned in the posting. The recruiters,
with their astounding knowledge of the IT industry, simply typed it up and
submitted it to the web sites. (That is what those big commissions are for
isn't it? ;-)
Don Granaman
[OraSaurus]
- Original Message
ation
internal to compilers and other tools. In Oracle, DIANA is an intermediate
representation of a PL/SQL program unit, generated by the compiler (SYS.DIANA
package). The Diana includes syntactic and semantic information for a compiled
program unit."
Don Granaman
[OraSaurus]
(uh.. RAC), etc.
Don Granaman
[OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, April 30, 2002 12:59 PM
Chris,
alphabet soup, XML, XDK, XSQL, XSLT, XPath, SOAP, ASP, ADO, EJB, BC4J,
JDBC,
SQLJ, PSP, JVM, JSP, J2EE, EAD, RMI
to discuss the current hot topics on the list. Some of the best technical
sessions this year were essentially ad hoc gatherings of ORACLE-L members -
on the sun deck, in Starbucks, and in the hallways.
Don Granaman
[OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L
it up and connect it to a database before you turn it over). It
could be days, perhaps weeks!
Don Granaman
[OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, May 01, 2002 12:48 PM
ERWin and ERStudio are basically in the 3,000
v$database will always show one and only one database - the database to
which the instance you are running the query against is attached. As for
how to find out on Windows, I'll leave that to someone who knows Windows
better than I.
Don Granaman
[OraSaurus]
- Original Message
at www.orafaq.com .
Thanks!
Don Granaman
[OraSaurus]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Don Granaman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
. Unfortunately, they are also constrained by the corporate culture.
---
Don Granaman
[OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, May 09, 2002 11:52 AM
Unfortunately, I don't have a copy of it. This was a number of years ago
Outstanding response!
Don Granaman
[certified skeptic]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, May 09, 2002 9:13 AM
no - DBAs would be skeptical of conspiracy theories.
-Original Message-
Sent: Thursday, May 09
is
sometimes blamed on conspiracy is often the result of natural entropy - aided by the
catalytic
agents stupidity, ignorance, greed, et cetera.
Don Granaman
[OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, May 09, 2002 9:58 AM
I'd
o you have an aps7 or other aps* directory in the tree under
$ORACLE_BASE? Are there other aps* objects that might shed a
clue?
-Don Granaman
[OraSaurus]
- Original Message -
From:
Nirmal Kumar
Muthu Kumaran
To: Multiple recipients of list ORACLE-L
Sent: Friday, N
. The concepts can be adapted to other components (e.g.
WebLogic and/or Tuxedo instead of iAS).
-Don Granaman
[OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, November 28, 2001 5:35 PM
Quick question. Is it a fair statement
/RAC - which shares a single database.
It could be a standby database, geo-mirroring, ...
The term mirror accessible sounds like it came from one of those
pseudo-technical trade magazine articles that are famous for
misinforming senior IT management. ;-)
-Don Granaman
[OraSaurus]
- Original
...
Of course, Julian date (%j) is not what you asked for. See: $ man
date The possibities are endless.
-Don Granaman
[OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, December 04, 2001 11:01 AM
RK - The system nicely timestamps
against instance or system failure
and none against media or site failure. It can be part of a hybrid
solution to provide complete protection.
-Don Granaman
[OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, December 05, 2001 1:35 PM
obsolete.
-Don Granaman
[OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, December 06, 2001 3:55 PM
Informal survey: Datawarehousing.
Limiting Assumption: A necessary and sufficient condition for
defining
something
the file list dynamically from
v$datafile - so no new datafiles are overlooked. They also do
archive log cleanup, can verify the backup by reading it off of the
tape, and some other stuff. These scripts may or may not be
appropriate for your case.
Don Granaman
[OraSaurus]
- Original Message
was comic exaggeration.
I have since come to the profound realization that it is subtle
understatement.
-Don Granaman
[OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, December 06, 2001 1:50 PM
I hear you. Some one came up with the idea
need the
performance immediately, than wait until its a crisis and only then
frantically rebuild everything.
See Gaja's paper on RAID at http://www.quest.com/whitepapers/Raid1.pdf
.
-Don Granaman
[OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED
: Don Granaman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E
information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Don Granaman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
$$$ for an ODP subscription, ODP just
disappeared - no web site, telephone disconnected, etc.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Don Granaman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
This is correct - $ORACLE_SID is a host environmental variable and cannot be
obtained from the data dictionary. However, you can get the instance name
from v$instance.instance_name in 8.x or from v$thread.instance in v7.
-Don Granaman
[certifiable OraSaurus]
- Original Message
when?
But, more important, WHY???
-Don Granaman
[certifiable OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, May 29, 2001 1:28 PM
And Where.
Terry
Boivin, Patrice J wrote:
When and how
Patrice Boivin
Systems
a long ways towards
proving that assertion - as do their occasional spam posts to the list.]
-Don Granaman
[certifiable OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, May 29, 2001 2:52 PM
Jim,
Um, if that is the Eyal I know
. Copying files around seems primitive at best. Am I
missing something? [OK, OK! I'll reform and use the environmental
variable!]
-Don Granaman
[certifiable OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, May 29, 2001 2:01 PM
Dave
if=raw device of=some file
2. munge the file with an editor - hex or otherwise
3. dd if=some file of=raw device
)
The best way, in my opinion, is to shut all instances down, edit the
datafile, then restart the instance(s).
YMMV
Happy hacking!
-Don Granaman
[certifiable OraSaurus
to do
that mankind's greatest challenge would be to find something to do with all
that leisure time. I'm still waiting...
-Don Granaman
[Certifiable OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, May 31, 2001 12:40 PM
I need
1 - 100 of 174 matches
Mail list logo