Oh, how I've missed these discussions between bittet, old men and women :).
Usually people just ARE more productive with linemode or text based applications
compared to GUI and webstuff. It could - theoretically - be connected to the
response times of the applications and the need constantly t
One of the funnier arguments for raw I heard a year ago was this (from a
DBA): "I always use raw files, because it makes it highly unlikely that
anybody will delete a datafile by accident, since it's so hard to get
rid of raw devices." :-).
Dejam, Ruth wrote:
>I had responded to Witold privat
Certainly. I had forgotten about the attachment policy. Please find James'
paper on
http://miracleas.dk/DBF/Morle/Sane_SAN_WP.pdf
.
I've CC'ed James, who's an old friend of ours. He's the guy who wrote Scaling
Oracle8i which is not a half bad book.
Mogens
C.S.Venkata Subramanian wrote:
Hello Rene
Can you explain more?
What exactly happened, what errors you get etc.
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
> -Original Message-
> From: MightDuck [SMTP:[EMAIL PROTECTED]]
> Sent: Fri, January 18, 2002 5:20 PM
> To: Multiple recipients of list ORACLE-L
>
Yep. And we also found logoff-triggers in 8i to be useful for the same
(and additional) purposes.
But if I had to guess, I'm sure the answer would be 42 :-).
Mogens
[EMAIL PROTECTED] wrote:
>Raj,
>Maybe another option would be to "audit session" for the database. For
>each logon/logoff you w
And in 8i there's a column in x$bh which counts the number of times the buffer
is touched (as I recall) called XNC or something?
Rachel Carmichael wrote:
you could turn auditing on on the table and count the number of timesit was selected--- Whittle Jerome Contr NCI <[EMAIL PROTECTED]> wrote
Hello Shreeni
I you are talking about Magic - application development tool, we are working
with it.
It is used in Israel and somewhat in Europe.
It usually use Btrieve but can use Oracle as a database.
In fact, the question that I posted about partitioning on part of a field is
converting
one of
If you can't use a DW idea look into Snapshots. If you don't need an up to
the second view of the data that is. or schedule the report run time. Most
reporting packages have the ability to do so.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent:
Agreed.
[EMAIL PROTECTED] wrote:
>I believe in your case no since the browser is not connected to the database,
>but the web server is and is alive. The real issue is does the web server know
>that the client closed his/her browser and terminate the session. I doubt it.
>
>Dick Goulet
>
>-
To be truly contrary to anyone else :) here are some thoughts we've been
trying to think recently here at Miracle regarding clusters and OPS/RAC from
Oracle:
There can be three main reasons for using clusters (I think):
- High availability. But how often does a Unix or Windows2000 server crash
Diego,
I agree with you 100% and didn't express myself correctly in my email. The
more spindles the better. What I meant to say was that you must never buy
disks by taking your total needed amount of space and divide by the number
of big disks you can get hold on :). It's the number of IO's req
And finally: Why do you want to reclaim the space?Yes, too high a HWM
will be wasteful w.r.t. table scans, but if you're so lucky as to have
mostly indexed access to the table it doesn't matter. If you have space
problems on the disk, that's of course another matter. And finally, in
9i, there
Funny. IBM is currently winning the Unix processor war, I think, with
new designs that HP, Compaq, HP and others will not catch up with for a
couple of years. But a Pentium 4 often outruns a couple of Unix
processors, and that's pretty scary to an old VMS fan. So running Linux
on Pentium 4's o
Kind of a broad question. Along with PeopleSoft SA, GL and Financials, we just implemented HRMS HR and Payroll 7.5 and 7.6 for E&G. The interface with GL was hairy, and we're still dealing with clean-up issues from legacy. Expensive? Yep, so we always recommend minimal modifications. Change
-- Mogens Nørgaard <[EMAIL PROTECTED]>
> Funny. IBM is currently winning the Unix processor war, I think, with new
> designs that HP, Compaq, HP and others will not catch up with for a
> couple of years. But a Pentium 4 often outruns a couple of Unix
> processors, and that's pretty scary to an
I
don't complete disagree with you but it is possible to design front end
interfaces to have a choice between mouse and keyboard. As a general rule
of thumb I do not use my mouse unless I have to. It annoys me when I am
not given a choice. I am sure there are some tools that make this har
Hi Jared
> I've seen some pretty ugly schemas in Oracle, from third
> party apps in particular.
>
> It would be most interesting if an automated tool could
> subset these.
They do get ugly don't they - however, I would be very suprised if DataBee
was not able to cut a subset.
DataBee is quite s
Environment NT4 4Gb RAMPage Filesize
4.5GbOracle Version 8.0.5.1.1
We have recently been experiencing intermittent
TNS-12500 Listener unable to create a dedicated server process
messages. It does occur when we have around 300 + processes, but
even then it appears hit and miss.
It has all
Chuck,
Yeah, I enjoy complexity and challenging work as much as
most DBA's. I spent a couple of weeks fooling around with
'instead of' triggers last year at the behest of the Chief Data
Architect ( at Enron, guess it won't do them much good now )
and I didn't like them too much.
This was wi
On Sunday 20 January 2002 06:45, Mogens Nørgaard wrote:
>
> Here's something else I've been wondering about: If the rather smart
> folks at the various Unix vendors (they're hardly any stupider than us
> on this list, do you think?) cannot get this stuff to work after having
> tried for many years
Do you know if anyone has successfully used this tool
on an SAP database? That would be *truly* impressive.
Jared
On Sunday 20 January 2002 10:55, Dale Edgar wrote:
> Hi Jared
>
> > I've seen some pretty ugly schemas in Oracle, from third
> > party apps in particular.
> >
> > It would be most
Mogens,
In regard to the number of spindles issue: James Morle has some
excellent discussion on that in 'Scaling Oracle 8i'. ( I think it's that
book )
When some of the newer larges drives are used in a given configuration,
they mabe be able to outperform older drives in a similar configur
My experience in going from Oracle CASE 5 to Oracle Designer 2000 made
it very clear to me that character mode was much faster, at least in this
case.
Using the same functionality in Designer 2000 took *much* longer in D2k
than it ever did in CASE 5.
Part of this was due not to the move from
> Environment NT4
> 4Gb RAM
> Page Filesize 4.5Gb
> Oracle Version 8.0.5.1.1
>
> We have recently been experiencing intermittent TNS-12500 Listener
> unable to create a dedicated server process
> messages. It does occur when we have around 300 + processes, but even
> then it appears hit and miss.
If the question is "Which episode of Star Trek was 'The Trouble with
Tribbles'", then yes. ;)
Jared
On Sunday 20 January 2002 01:30, Mogens Nørgaard wrote:
> Yep. And we also found logoff-triggers in 8i to be useful for the same
> (and additional) purposes.
>
> But if I had to guess, I'm sure
Speaking of "42" ...
"In the beginning the Universe was created. This has made a lot of people
very angry and been widely regarded as a bad move. "
--Douglas Adams
Cheers,
JoJo
-Original Message-
Still
Sent: Sunday, January 20, 2002 1:30 PM
To: Multiple recipients of list ORACLE-L
Bunyamin,
Are
the clients connected directly to the database or do they connect through some
type of application server like JBoss or Web Logic? If they are connecting
to an application server then you can get away with a lot less connections
and use dedicated servers. The theory goes th
or, of course, the answer to life, the universe and everything is?
--- Jared Still <[EMAIL PROTECTED]> wrote:
>
> If the question is "Which episode of Star Trek was 'The Trouble with
> Tribbles'", then yes. ;)
>
> Jared
>
> On Sunday 20 January 2002 01:30, Mogens Nørgaard wrote:
> > Yep. And
It's well know that Oracle#s state of the art database server can
rarely tell the difference between an empty string and a NULL
(I presume that's not changed recently, though I'd be very happy
to be told otherwise).
So people who don't want empty strings being stored as NULLs in
their fields tend
I would not say any vendor. I have yet to have an issue with HP and
failover.
Its worked every time and is relatively easy to setup and use.
I have no experience with any other vendor in that area though.
-Original Message-
Sent: Sunday, January 20, 2002 1:35 PM
To: Multiple recipients o
Jared,
Good thought! We're running our annual Miracle Master Class (this year with
Jonathan Lewis) this week and Cary Millsap (and his gang), Jonathan and James
will arrive tomorrow (Monday), while Steve Adams, Lex de Haan, Stephan Haisley
and a bunch of other guys will arrive on Tuesday. I'll
Hi All
We have got two Oracle Databases physically connected.We want to replicate
one database with the other database.We are quite new to this
subject.Kindly guide us with the procedure of replication and the
conditions to be considered for replication.
Thanks in advance
Regards
Systems
Oracle 8i Replication Manual
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76959/toc.htm
;-)
-Joe
At 10:15 PM 1/20/02, you wrote:
>Hi All
>
>We have got two Oracle Databases physically connected.We want to replicate
>one database with the other database.We are q
Firstly I would go read all Oracle Documentation regarding Replication before doing anything else, This is an area that need a high level of understanding.
Do you want a hot standby, are you trying to replicate GL entrys from a database into Financials. After a read of the documents and when you
Hi list,
Our developers are having problems with Developer 6 while
printing simultaneously at 2 printers,
Basically it's a pharmacy module and after entering
the data INVOICE is sent to one printer, while the Labels for the medicine are
sent to the other (label printer). Now
the probl
Oracle Magazine have alot "Oracle for HP" articles, I think they are
switching from Sun to HP
-Original Message-
[EMAIL PROTECTED]
Sent: 19 January 2002 06:16
To: Multiple recipients of list ORACLE-L
Sergey,
I asked my SA to add his 2 cents, guess he's not inclined. Anyway, I'v
Hello All:
I have a situation where emails sent to an Email Id should get inserted into
a database 1,e some part of the email should get inserted as records in a
particular table. Like for example the Person's Name(who sent the email)
should get inserted in the Name field of the table, Subject
Title: OT:Developer 6 Problem
Hi list,
Our developers are having problems with Developer 6 while printing simultaneously at 2 printers,
Basically it's a pharmacy module and after entering the data INVOICE is sent to one printer, while the Labels for the medicine are sent to the other (label
Hi,
What do u want to achive by replication ??
HA - High avilability OR
LB - Load Balancing
For HA what you can do is go for a standby. For LB u hv to go to OPS or even
OPFS can do both
Regards
OraEtM!!
>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of lis
Sorry, you missed.
The question is: what is the meaning of life, the universe and all the rest?
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
> -Original Message-
> From: Jared Still [SMTP:[EMAIL PROTECTED]]
> Sent: Sun, January 20, 2002 11:30 PM
> To: Multiple recipients of
Hi,
I think of JAVA.
Sinardy
-Original Message-
QURESHI
Sent: 21 January 2002 14:30
To: Multiple recipients of list ORACLE-L
Hello All:
I have a situation where emails sent to an Email Id should get inserted into
a database 1,e some part of the email should get inserted as records i
43 matches
Mail list logo