Title: Safe Database Environment
Hi all,
Can any of you suggest the configuration for a safe, fault proof, and minimum downtime Database environment? (In terms of how many servers, RAID or disk ARRAY or any combination. A minimum configuration is what I am looking for).
Right now we have
I never said CBO came up with smarter plans...what I
said was that you get a optimizer decision that is
very similar to rule-based (which is where the
original posted is migrating from) and as a bonus,
rather than just choosing any old index as the rule
based optimizer does, the cbo will hopefully
No - it means you have monitoring set on (at least)
207 tables, and the 207 of them have had a
modification (ins/upd/del) since the monitoring was
enabled.
This data is used to determine whether the stats are
stale or not. Its documented somewhere, but I think
its around the 10% mark before
Title: Safe Database Environment
Real
Application Clusters?
-Original Message-From: Hussain Ahmed Qadri
[mailto:[EMAIL PROTECTED]]Sent: Thursday, November 21, 2002 1:43
PMTo: Multiple recipients of list ORACLE-LSubject: Safe
Database Environment
Hi all,
Can any of you
The configuration will be:
Regular servers - NAS
Database servers - SAN
I looked inside and they have connectors for fiber channel.
The nice thing about it is that I can as many mount point as I like.
No more one big raid-5 logical drive.
Yechiel Adar
Mehish
- Original Message -
To:
Title: Safe Database Environment
Hello Hussain
We are working with oracle 8.1.6 on wintel
machines.
We had the same problem and we solved it using advance
replication - synchronous.
We have scripts ready that drop the replication on each
computer if one become unavailable.
The databases
Have you tried to put a DD card for internal reader and write to this DD
with utl_file?
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, November 21, 2002 1:49 AM
Thanks but EVERYTHING is on the mainframe (including
You can upgrade the 816 catalog to be 817 compliant with the command
RMAN upgrade catalog
You need to be connected to an 8.1.7 target first to do this. It effectively
recreates two packages
DBMS_RCVMAN and DBMS_RCVCAT
John
-Original Message-
Sent: 20 November 2002 16:39
To: Multiple
Okay, it's early here, I'm fuzzy.
I think I meant the same thing (I'd had one of those user calls in
the middle of the night)
what I think I meant to say was that any operation that would end up
adding blocks above the HWM if it COMPLETED would do it by creating
TEMP segments that are converted
Sounds Like a perfect time Mark.
I UKOUG'd the year before last and stayed in Broad street. The conference
was well worth it.
For my two nights I had food at an Indian and a TGI's both in Broad street.
I'll be flying into Heathrow from Washington early Monday morning and
getting the train to
David,
For ease of tablespace management and backups we created tables based
on the year. ex: tab_curr, hist99,hist01,etc and then created a view
that selected from each table with a union. Then the developers could
select from the view and not be concerned with the actual table name. As
each
Hello all
We have a VB application that works with oledb supplied by Microsoft,
msdaora. We noticed that a batch program is working very slowly. We changed
the program to work with Oracle oledb and it run much faster. However we
can not use Oracle oledb due to problems with Hebrew.
Anyone can
Title: RE: converting to the cost based optimizer
Me thinks (based on my conversion from RBO-CBO) over last two months ... ) one major factor is achieving success is as follows
1. Train your developers/designers
2. See point one
3. Lather - rinse - Repeat
Some people just don't get it ...
You could FTP to 127.0.0.1
127.0.0.1 is the universal IP address of the system you are on. That is you
would FTP to yourself and then send the FTP file, the JCL, to the JES
reader. Give it a try it seems to work on our installation.
Greg
-Original Message-
Sent: Wednesday, November
Gurus,
Desperately need some ideas to solve this one.
Following is the sequence of events as it happens:
1. Front-end application (VC++) queries from a view V. V fetches data from a
remote database RD via a database link.
2. Front-end inserts a row in a local table LT.
3. The Insert trigger on
Title: RE: export in full mode but exclude particular user?
anybody know the views for 9.2?
-Original Message-
From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 20, 2002 10:58 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: export in full mode but
Title: RE: Testing
We regret to inform you that your test has failed, please try again.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN
We had a discussion about a year ago here and if I remember correctly the
best stripe size is a function of number of concurrent users. With a
small number of users you want a small stripe size so that each read i/o
will utilize the maximum number of heads. It will also tie up the RAID
device
Gurus,
Sorry, forgot to mention one very important fact - this error doesn't occur
always - sometimes (but rarely) it's succeeds as well.
Thanks,
Charu
-Original Message-
Sent: Thursday, November 21, 2002 2:22 PM
To: '[EMAIL PROTECTED]'
(Distributed transaction)
Gurus,
Desperately
Raj,
Can you elaborate on the process that you used to determine the optimal
value for db_file_multiblock_read_count?
We are doing some performance testing on a new generation of our product
with some new databases. We increased our database block size from 8k to
16k (on Sun Solaris 2.6).
Charu,
I guess the error you are getting is Table or Trigger is mutating. and
perhaps you are using an after insert row trigger. This is a common and
expected problem. There are ways to get around it. You have not mentioned
the version of Oracle; I would assume 8.1.7 or later.
Inside an after
Title: RE: export in full mode but exclude particular user?
It's the same - exu81obj and exu8usr.
HTH
Arup Nanda
www.proligence.com
- Original Message -
From:
Chris
Stephens
To: Multiple recipients of list ORACLE-L
Sent: Thursday, November 21, 2002 9:18
AM
Monday night sounds great.
-Original Message-
Sent: Wednesday, November 20, 2002 10:08 AM
To: Multiple recipients of list ORACLE-L
The best time is most probably Monday evening. There is always a gala
evening on the Tuesday night that a lot of people attend (and speakers
always get
Title: RE: converting to the cost based optimizer
Cherie,
We are actually stuck at a value of 32 ... don't know how it got in there, but it was probably us who made the mistake. That's how we tested it and that's how we are staying put. We have initiated a test process to bring it down to a
That suits me.
Mark, I'd like to say how much I enjoyed reading the phrase plenty of booze
to go around.
Mike
-Original Message-
Sent: 21 November 2002 15:34
To: Multiple recipients of list ORACLE-L
Monday night sounds great.
-Original Message-
Sent: Wednesday, November 20,
Raj,
I'm just curious whether you also have reset your optimizer_index_
parameters in these databases where you have changed and/or are considering
changing the db_file_multiblock_read_count? In particular, has it been set
on the production database where you set db_file_multiblock_read_count
Title: OT: Password Generator...
Hey folks-
I have a question that was presented to me by a web development team..
Does anyone know of products,procedures,etc that would generate a random password for a user? For example-similar to that at MetaLink when you forget your password-and they
I have a query in which the predictate is like this:
WHERE ln.metro_id = i_metro_id AND
l.metro_id = :b1 ANd
eld.metro_id(+) = :b1 AND
ln.status_desc = 'ACTIVE' AND
ln.daset_id = ld.daset_id (+) AND
Oracle 8i and HP-UX, 9i and SCO Unix
I have a customer who wants to MERGE into his 9i database from my 8i
database across a dblink. On his side, the merge takes nearly an hour ( one
SQL merge statement across 10Mbit Etherlink processing 2,600,000 records).
I'd like to know how to test and
Title: RE: converting to the cost based optimizer
No I should have clarified ... so far we have made changes to o_i_c_a parameter at session level only ... we haven't dared it change at system level. I read through Tim's paper ('Searching for ...') and try to came up with an appropriate
From Tom Kyte's site...
ops$tkyte@8i declare
2 function digest( p_username in varchar2,
p_password in varchar2 ) return varchar2
3 is
4 begin
5 return ltrim( to_char(
dbms_utility.get_hash_value(
upper(p_username)||'/'||upper(p_password),
6
Title: RE: Password Generator...
We use this ...
PROCEDURE Generate ( USERID VARCHAR2 ) IS
newpass VARCHAR2(20);
dbname VARCHAR2(10);
/*
connect system
grant execute on admin_passwd to sys;
create synonym sys.admin_passwd for system.admin_passwd;
*/
BEGIN
DBMS_OUTPUT.ENABLE(10);
newpass
Great opportunity for a Sr. Oracle DBA with 8i AND 9i certification to join
this software
industry leader in Charlotte, North Carolina.
Base salary is in the 90-120K range and depends on experience.
Relocation Assistance is provided.
PLEASE Do Not send your resume for this position UNLESS you
Title: RE: converting to the cost based optimizer
Are you sure TIMED_STATISTICS = TRUE?
I dont have time right now to check
V$FIXED_VIEW_DEFINITION, but check how the AVERAGE_WAIT column is calculated. Just
from querying V$SYSTEM_EVENT (I have 9iR1, by the way, not R2), it looks like
Hi Arup,
Thanks for the reply.
I have checked the trigger code thoroughly and surely it's not a mutating
trigger. Nor is there any cascade effect or the trace files would have shown
the statements within that trigger.
There is some other error occurring, but we are not able to trap it because
-Original Message-
Does anyone know of products,procedures,etc that would generate a random
password for a user?
--
Bang on the computer keyboard with the palms of both hands and see what
comes out.
This random password generator has been around for a long
what language?
random() or rand() is usually a part of every language.
On Thu, 21 Nov 2002, Loughmiller, Greg wrote:
Hey folks-
I have a question that was presented to me by a web development team..
Does anyone know of products,procedures,etc that would generate a random
password for a
Folks,
Can someone direct me to a source of good information on this topic. Is there wor will there be Oracle client for OS X? Any leads are very much apreciated!
Thanks!Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now
39 matches
Mail list logo