Title: RE: RE: Development vs. Production DBA
Just
don't grant execute. ;-)
-
Alan Davey Senior
Analyst/Project Leader Oracle 9i OCA; 3/4
OCP w) 973.267.5990 x458 w) 212.295.3458
-Original Message-From: April Wells
[mailto:[
:54:33 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: RE: Development vs. Production DBA
>
>
> But if you make them stored procedures, you might be giving up some vestige
> of control. CAN'T give up control...
>
> April Wells
>
Title: RE: RE: Development vs. Production DBA
But if you make them stored procedures, you might be giving up some vestige of control. CAN'T give up control...
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo
icr.com> cc:
Sent by: Subject: RE: RE: Development vs.
Production DBA
I don't normally like to get into these turf battles, but in this case I have to agree
with Patrice. Most developers are looking strictly at their current project with no
regard for anything they've done in the past or that others around them are doing.
Also I find that a significant number of
not arrogance, experience.
Granted, there are good developers out there.
The tendency is to think only on a project by project basis in development
because of the way developers sometimes get funding to sustain themselves.
No offense was intended, it was a cautionary note nothing more.
Patrice.
the arrogance here is troubling. though there seems to be more incompetent developers
who do not know the database I have worked with my share of incompetent DBAs. Havent
used anything since versoin 5.0 and so on. Dont know anything at all about
development.
If a production DBA knows developme
Zhu/SF:
Thanks for your insight. I was under the impression that Oracle did not
recommend IOT for tables that where not fairly static.
Would the reasoning for this not being an issue in this case be due to
oracle now having to only maintain the IOT table blocks instead of the table
blocks and the
Zhu Chao,
You are right to say that with a heap organized table you also have the index to
encumber the SGA and indeed you are right to say that, as I put it, what I said is not
totally correct. I should have been more specific.
The reference to _partitioned_ IOTs implicitly associated them
c:
Subject:RE: RE: OCP 9i New Features for DBAs
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 esp
20, 2003 3:30 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: RE: orbitz fiasco
>
>
> 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 failo
TED]
To: Multiple recipients of list ORACLE-L
Sent: Thursday, November 20, 2003 8:35
PM
Subject: RE: RE: OCP 9i New Features for
DBAs
Chris, Care to share details on the inaccuracies?
Jared
"Dunscombe, Chris" <[EMAIL PROTECTED]>
3 20:21
> To: Multiple recipients of list ORACLE-L
> Subject: RE: RE: orbitz fiasco
>
>
> 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 <[
|
> | | Please respond to|
> | | ORACLE-L |
> | ||
> |-+>
>
>---
---|
> |
|
> | To: Multiple recipients of list ORACLE-L
<[EM
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 i
Murali_Pavuloori/[EMAIL PROTECTED]
> Sent: 20 November 2003 18:15
> To: Multiple recipients of list ORACLE-L
> Subject: RE: RE: orbitz fiasco
>
>
>
> we implemented RAC (not me personally --but my predecessors)
> It did not work for us. Oracle RAC does not support TAF for
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
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
-Orig
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
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.
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 personal.
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
mon
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 throug
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 ensur
TECTED]>
cc:
Subject: RE: RE: OCP 9i New Features for DBAs
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 especial
|
| To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
|
| cc:
|
| Subject:
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: or
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 accordin
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, havin
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,
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, wh
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 M
The infamous event "log file sync"will 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
> RE: orbitz fiasco
>
>
>
> 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, storage, fiber switches, SAN,
>
> 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 an
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
:)
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"
bef
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 of
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
> t
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,
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 M
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
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
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 mak
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 i
there arent that many new pl/sql features. 90% of the time your using the generic
stuff. the new stuff is nice, but not always that special. Or maybe its just because I
do it everyday. But how much is new? PL/SQL tables? Bulk binds? Dynamic SQL? That
stuff is all basic. Its minor syntax differen
Since "making love is simpler", should they start with outsourcing it?
-:)
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Mladen Gogala
Sent: Tuesday, November 18, 2003 12:44 PM
To: Multiple recipients of list ORACLE-L
On 11/18/2003 11:54:41 AM, "Bellow, Bambi" wrote:
> > [
On 11/18/2003 11:54:41 AM, "Bellow, Bambi" wrote:
> > [EMAIL PROTECTED]> uname -a
> > dgux orion R4.20MU06 generic AViiON PentiumPro
> > [EMAIL PROTECTED]> make love
> > Make: Don't know how to make love. Stop.
>
> Raj --
>
> That's fbulous!
>
> Thanks,
> Bambi.
> --
Actually, it really
>There is no fun ... my favorite quotes used to be in Apple MPW compiler ...
the one I like most is ...
>"You can't modify a constant, float upstream, win an argument with the IRS,
or satisfy this compiler"
> Raj
Raj --
I fear this will get off-topic'd pretty quickly, and, I further fear that
> [EMAIL PROTECTED]> uname -a
> dgux orion R4.20MU06 generic AViiON PentiumPro
> [EMAIL PROTECTED]> make love
> Make: Don't know how to make love. Stop.
Raj --
That's fbulous!
Thanks,
Bambi.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Bellow, Bambi
INET: [
Bambi,
in earlier versions of unix, it would reply "don't know how to make love" like ...
[EMAIL PROTECTED]> uname -a
dgux orion R4.20MU06 generic AViiON PentiumPro
[EMAIL PROTECTED]> make love
Make: Don't know how to make love. Stop.
but now ...
[EMAIL PROTECTED]> uname -a
AIX ariel 1 5 002
$ make lovemake: *** No rule to make target
`love'. Stop.
- Original Message -
From: "Bellow, Bambi" <[EMAIL PROTECTED]>
To: "Multiple recipients of list ORACLE-L"
<[EMAIL PROTECTED]>
Sent: Monday, November 17, 2003 9:24
PM
Subject: RE: Re[2]:
No, sorry, that is the correct answer. The original question was "Does
anyone remember TECO?" In TECO, if you entered the command "make love", it
would respond "not war".
Two points to Bill and thanks for the smile to both,
Bambi.
-Original Message-
Sent: Monday, November 17, 2003 2:14
Bill, that's a wrong answer. The correct answer is "make love, not children".
On 11/17/2003 02:54:42 PM, "Thater, William" wrote:
> Bellow, Bambi scribbled on the wall in glitter crayon:
>
> > make love
> not war
>
> --
> Bill "Shrek" Thater ORACLE DBA
> "I'm going to work my ticket if
Bellow, Bambi scribbled on the wall in glitter crayon:
> make love
not war
--
Bill "Shrek" Thater ORACLE DBA
"I'm going to work my ticket if I can..." -- Gilwell song
[EMAIL PROTECTED]
The knack of
We've purchased nuTPU from aSoft:
http://www.asoft-dev.com/tpu_info.htm
It's very good, although most of my low level EVE replacements don't work
(e.g. off-screen cursor handling, custom comment handling, etc.).
Development appears to be stopped as there have been no new patches or
versions in a
Well, not all hope is lost. Look at the following URL's:
http://www.makalis.fr/~bertrand/FreeVMS/indexGB.html
http://www.bosbc.com/
The second one is a commercial product, but certainly provides a
familiar layer.
On 11/17/2003 02:04:25 PM, "Thater, William" wrote:
> Bellow, Bambi scribbled on
make love
-Original Message-
Sent: Monday, November 17, 2003 1:04 PM
To: Multiple recipients of list ORACLE-L
Bellow, Bambi scribbled on the wall in glitter crayon:
Do you know how SQL*Plus was called during Oracle V4? (And maybe
earlier, but this is as far as my history with
Bellow, Bambi scribbled on the wall in glitter crayon:
Do you know how SQL*Plus was called during Oracle V4? (And maybe
earlier, but this is as far as my history with Oracle goes)
They called it UFI, which means User Friendly Interface!
>
>
> And that dreaded afiedt.b
P was Program... it was the Y/N program file.
-Original Message-
Sent: Monday, November 17, 2003 11:54 AM
To: Multiple recipients of list ORACLE-L
IAD was the executable (on VMS) that the Sql*Forms command ran (D for
Designer). IAG was to generate a form (G for Generate). IAP to execut
IAD was the executable (on VMS) that the Sql*Forms command ran (D for
Designer). IAG was to generate a form (G for Generate). IAP to execute it
(P for something that I can't remember). This was SqlForms 3.0.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Monday,
Hope you don't mind the intrusion... I used HLI back in 5.0.20 days, and the
big problem converting in 5.1.22 when everything had to go to IAPXIT. When
were IAP|IAG replaced with IAD? I thought that came in around 1.3... was it
later? Because by v2 it was SQL*Forms...
Bambi.
On 11/17/2003 06:1
> >>
> >> Do you know how SQL*Plus was called during Oracle V4? (And maybe
> >> earlier,
> >> but this is as far as my history with Oracle goes)
> >>
> >> They called it UFI, which means User Friendly Interface!
> >>
And that dreaded afiedt.buf came was a copy of the "Advanced User Friendly
Inter
I do. I thought that IAD (graphic interface which came with 2.0
in version 5) was a solution to all problems. Version 4 was used
for training purposes only. First real apps were developed with
5.0 and 5.1.22.
On 11/17/2003 06:14:24 AM, Carel-Jan Engel wrote:
> Mladen, we must have started in the
Helmut,
Seems a bit high to me as well. Concerning the PGA issue, what about running
something like :
col name format A25
select n.name,
round(min(s.value) / 1024) "MIN K",
round(avg(s.value) / 1024) "AVG K",
round(max(s.value) / 1024) "MAX K"
from v$statname n,
v$ses
Mladen, we must have started in the same era. You're describing the
environment I started with, however, our disk was 10MB. So you remember
SQL*Forms 1.3 (IAC/IAG/IAP) and HLI as well?
> Carel, I know that. That was my first oracle version. I installed V4 on an
> IBM
> PC/XT with WD 20MB hard driv
Carel, I know that. That was my first oracle version. I installed V4 on an IBM
PC/XT with WD 20MB hard drive and two 5.25 floppy drives which could
each hold 360k of information. Yes, you read it correctly. It was 20 MB
hard drive, not 20 GB. OS was the unforgettable DOS 3.0 and the graphic
card
Hi Mladen,
At 06:19 12-11-03 -0800, you wrote:
SQL*Plus has a ghastly and disgusting user interface,
implemented without "readline" or equivalent, which would give a command
history.
Littering the system with those @#$%! afiedt.buf files is bad enough but line
editting commands are an indicator o
Facetious, but correct. What you need
is auditing. Not clipping userids.
Achieves nothing.
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message -
> What I was saying is that having a different username for each DBA helps you
> identify the WHOM. Of course a hacker
could always cut kno
> -Original Message-
> Nuno Pinto do Souto
>
> I don't want to know that SYSTEM or SOUTON with a subset
> of its rights stuffed up my database or exported my main accounts
> and clients tables. What I want to know is WHY, WHEN, HOW and
> by WHOM.
What I was saying is that having a diffe
Jonathan,
You are welcome. Another time for the syntax table (partitoion) comes handy
is while dropping, merging or doing some other partition maintenance work.
This will quickly check is the partition is empty or not, othewise you have
to ge the hig values of the partition and one prior to it and
Thanks Bambi,Rachel and Jacques.
- Original Message -
Date: Friday, November 14, 2003 2:19 pm
> Yes. Instead of using a procedure, create a function or a package
> that does the truncate. Grant execute on the function or package
> to the user doing the truncate.
> Without creating a pro
Stephane,
This is what I was exactly looking for. Thank you so much.
- Original Message -
Date: Friday, November 14, 2003 8:59 am
> Jay,
>
> Check http://www.oriole.com/aunt_2001_0.html
> and look for the 19th. March 2001 entry.
> Otherwise look for a snp*.trc in either bdump or udump (
-Original Message-
Sent: Thursday, November 13, 2003 10:49 PM
To: Multiple recipients of list ORACLE-L
>Stopping someone from using a given set of accounts achieves preciously
>nothing in terms of security (or auditing) IF the functionality of those >accounts
>is then replicated to ot
> Arup Nanda <[EMAIL PROTECTED]> wrote:
> I'm not sure that's what the OP wanted. He wanted to know if stopping
> use of
> SYS and SYSTEM on a regular basis will be acceptable, not "disable"
> them. It
> sure is.
> Besides, how does one disable the account? Lock it? SYSTEM can be
> locked but
> SYS
Merci beaucoup Monsieur. I agree with your point in the second paragraph.
> -Original Message-
> Stephane Faroult
>
> My personal preference is with solution 2 - moving the
> current information to JOB. The scheduler can quietly insert
> into JOB_HISTORY when it is done with a job, and
My personal preference is with solution 2 - moving the current information to JOB. The
scheduler can quietly insert into JOB_HISTORY when it is done with a job, and update
the current line (do it through triggers if you like). Solution 3 violates the beloved
KISS principle ...
Moreover, when you
]Sent: Thursday, November
13, 2003 3:34 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: Re: Logical StandBy
question
I am
just planning a LOGICAL data guard installation in an important
client.
They
need it for reporting and backup (primary is 24x7x365 and we have hot
Nuno Pinto do Souto" <[EMAIL PROTECTED]> wrote:
> And that's why I feel disabling SYS or SYSTEM purely on
> "security" grounds makes no sense whatsoever
I'm not sure that's what the OP wanted. He wanted to know if stopping use of
SYS and SYSTEM on a regular basis will be acceptable, not "disable"
oles, 12 de noviembre de 2003 19:59
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Re: Logical StandBy question
Walt, drop me your email-address, and I send you the handouts of a
special I presented about DG for Oracle University in
Stockholm.
I'm going out now for a few hours (it&#
not explicity say
>that)
> -Mensaje original-
> De: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED] nombre de
>Carel-Jan Engel
> Enviado el: miercoles, 12 de noviembre de 2003
>19:59
> Para: Multiple recipients of list ORACLE-L
> Asunto: RE: Re: Logical StandBy quest
:59Para: Multiple recipients of list ORACLE-LAsunto:
RE: Re: Logical StandBy questionWalt, drop me your
email-address, and I send you the handouts of a special I presented about DG
for Oracle University in Stockholm.I'm going out now for a few hours
(it's 19.30 over here)
> Jacques Kilchoer <[EMAIL PROTECTED]> wrote:
> In my case I also enforce the "don't sign on as SYS/SYSTEM" rule. The
> reasons I do that:
> - The default tablespace for SYS is SYSTEM, and I don't like to
> change that. There are probably reasons why you wouldn't want to
> change that. But when I s
> -Original Message-
> Nuno Pinto do Souto
>
> Fact is: an admin user MUST have access to an admin
> privileged account.
> Call it whatever you want, root or role, who cares.
In my case I also enforce the "don't sign on as SYS/SYSTEM" rule. The reasons I do
that:
- The default tablespace
> Arup Nanda <[EMAIL PROTECTED]> wrote:
>
> Whoa! That came out pretty strong :)
Fed-up with these new-fangled security "experts" popping
up all over the place. Pretty soon we'll have another marketing
driven lot of bullshit going round. With the usual crap associated with it.
Next "big thing",
Walt, drop me your email-address, and I send you the handouts of a
special I presented about DG for Oracle University in
Stockholm.
I'm going out now for a few hours (it's 19.30 over here), but I'll
respond later this evening.
regards, Carel-Jan
At 09:19 12-11-03 -0800, you wrote:
Stephane,
What
Walt,
I'll step in here--my experiment with Logical Standby convinced me that
it is not ready for prime time.
1. Major bugs caused apply process to crash repeatedly.
2. Difficulty filtering out DDL from apply stream.
3. Horrendous performance of apply process--frequently the elapsed
time to ap
im going to take it soon. I was going to just read howard rogers guide then the otn
one.
you think that is enough? I just want to pass it and get my piece of paper. I already
know the 9i stuff that is useful to me.
>
> From: DENNIS WILLIAMS <[EMAIL PROTECTED]>
> Date: 2003/11/12 Wed PM 12:19:
there was a thread -- Paul Baumgartel started it looking for
information on logical standby.
IIRC, he found that there were a few "gotchas" -- check the fatcity
archives.
I do know that since it's based on Logminer technology, it has the same
limitations that Logminer does
--- Walt Weaver <[EMA
Hi all,
As Stephane told, logical standby (LSB) has a lot of tiny little
exceptions and special issues to cope with. I've done one implementation
in production until now (did appr. 20 Physical Standby sites as well).
But, even that site uses 2 LSB's as reporting systems, and has a PSB for
the HA
Stephane,
What sort of problems can one expect from logical standby?
I'm toying with the idea of using it as a replication database -- no
additional schema objects will be created, but users will have read-only
access to it. It's one of the options I'm looking at.
Seems to me like there was a th
Jose Luis,
What you say refers to the physical standby database (which works well), not to the
logical standby database (which on the paper looks great, allows you to open the
database, create additional tablespaces, create additional indexes on replicated
objects etc) but which in practice s
I never use those. I find it better not to be overly smart with sqlplus.
Sqlplus is a program for ad-hoc queries from the command line and for
the administrative functions (startup/shutdown, alter database/system),
nothing more and nothing less. If I need a program, I can either write a
PL/SQL bl
I never use those. I find it better not to be overly smart with sqlplus.
Sqlplus is a program for ad-hoc queries from the command line and for
the administrative functions (startup/shutdown, alter database/system),
nothing more and nothing less. If I need a program, I can either write a
PL/SQL bl
my 'C' isnt very good, but I would assume CGA is allocated with malloc right? they are
just dynamic allocations.
do you know what type of data structures oracle uses to sort? dynamic arrays or linked
lists?
>
> From: "Steve Adams" <[EMAIL PROTECTED]>
> Date: 2003/11/11 Tue AM 08:14:26 EST
> T
Hi Stephane,
The way you put it here would mean that the internal format of the
tablespaces will be big/little-endian independant.
That would mean either an extra amount of overhead in the low level IO,
or
Oracle-specific arithmatic everywhere in the kernel. I doubt
whether
Oracle would do that.
CTED]>
> Date: 2003/11/10 Mon PM 02:09:27 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: Re: passing an array variable from a .Net middle tier to a da
>
> Given that I've been developing in .NOT for the past 6 months, I figured
I'd
&g
sounds like your not a fan of .net, with the .not reference? why?
>
> From: Kevin Toepke <[EMAIL PROTECTED]>
> Date: 2003/11/10 Mon PM 02:09:27 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: Re: passing an array variable from
Given that I've been developing in .NOT for the past 6 months, I figured I'd
chime in here
.NOT can call PL/SQL just fine. If you use Oracle's ODB.NET (that's Oracle
Data Provider for .NET -- a free download from otn.oracle.com), you can use
bind an array to a PL/SQL call. In fact, if you look
ignore most of my last question. I didnt see pl/sql 'table' just saw pl/sql
my bad. sorry
>
> From: David Hau <[EMAIL PROTECTED]>
> Date: 2003/11/10 Mon PM 01:44:27 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: passing an array variable from a .Net middle tier
301 - 400 of 2928 matches
Mail list logo
