Hi listers,
Configuration :
Hp-ux 11i
Oracle 9iR2 with RAC (2 nodes)
OSD clusterware : MC/Service Guard 11.15
Oracle software is installed on each node and
the database is on shared raw devices.
Any experience/gotchas implementing OFA on RAC without cluster file systems?
In
Bingo!
I did pretty much the same thing for an 8i DW with plenty of ad-hoc queries.
I had no way of knowing what those ad-hoc queries might look like, and they
will change over time. So I set up a polling process to do a textual parse
of v$sql for those SQLs with highest disk_reads and/or
We are doing Interest processing on a SET of 10,000 Bank A/cs using a
Single Database connect process.
SQL Query :-
select field names,rowid into :b0,:b1,...
from TBA_ENTITY_INTEREST_TBL
where (entity_id=:b105 and entity_type=:b106)
for update of same (above) field names
nowait;
Above SQL
(B--
(BPlease see the official ORACLE-L FAQ: http://www.orafaq.net
(B--
(BAuthor: Prem Khanna J
(B INET: [EMAIL PROTECTED]
(B
(BFat City Network Services-- 858-538-5051 http://www.fatcity.com
(BSan Diego, California-- Mailing list and web hosting services
Vivek,
as others have pointed out before, Statspack is instance wide snapshot. Trace file is
session specific.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly
Title: col_usage$ question
Thanks Tanel,
I also found that whenever one issues
dbms_stats.flush_database_monitoring_info(), it updated some info in col_usage$
as well with mon_mods$ of course. That's where I found this reference and hence
my original email.
Thanks everyone.
I am currently
I swapped emails with a member of the list and Im having trouble seeing how you can
take 3NF, BCNF, etc... and turn that into DBA speak. One of the guys told me that BCNF
essentially means you have a key that you can put a unique constraint on. Well that
makes this much easier to understand.
MG,
AFAIK v$object_usage is ONLY for current user ... you have to hack it to see remaining
data.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any
Hi all,
I am looking for a template where i can fill the health
of the databases daily and send it to my boss .Though i have prepared one
i still doubt i have missed some thing :). If anybody has any format for
such a report please share it .
Well, it's code is:
select io.name, t.name,
decode(bitand(i.flags, 65536), 0, 'NO', 'YES'),
decode(bitand(ou.flags, 1), 0, 'NO', 'YES'),
ou.start_monitoring,
ou.end_monitoring
from sys.obj$ io, sys.obj$ t, sys.ind$ i, sys.object_usage ou
where io.owner# =
these are bogus. its just about giving your boss some BS, so he goes away. Been there,
done that.
the only useful stuff to send him would be polling the alert log for 'ORA' errors,
checking for chained rows as a percentage of total rows, and check to see how much
free space is in each
Grant,
You can simply use the file command to find out the ELF class. If it reports
32-bit, it's ELFCLASS32; if it's 64-bit, i's ELFCLASS64. When you say client
shadow process, I assume you mean the shadow process on the server (as a
shadow of the client in dedicated configuration).
You may want
Title: RE: Any articles/books that take relational theory and make it english?
Ryan,
I often recommend Database Design for Mere Mortals by Michael J. Hernandez for my students, new database developers, and especially for programmers that I work with. It's a step above something like
Gilles,
RAC Configuration:
1. ALL DATAFILES SHARED (RAW FILES) - both nodes should have access
2. ARCHIVE LOGS are not shared - Each node will have its own ARCHIVE LOGS (File
System)
I have configured ARCHIVE LOG as FAILOVER FILE SYSTEM.
3. UNDO (RAW FILES) - Each node will
I think Ixora website had the list with 9i stuff in it, but you also can get
some of the class definitions out by checking gv$waitstat's source:
select inst_id,decode(indx,1,'data block',2,'sort block',3,'save undo
block', 4,'segment header',5,'save undo
header',6,'free list',7,'extent map',
Data Modeling Essentials by Graeme C Simsion is a very good book.
American Express made the following
annotations on 11/19/2003 07:36:46 AM
--
Is anyone else getting messages like this, just the footer added by Fat
City? Thanks.
Ben Schilling
Wis Insurance Commission
608-266-1615 [EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, November 18, 2003 12:34 AM
To: Multiple recipients of list ORACLE-L
--
Please see the
Tanel,
Raj must be talking about userenv('SCHEMAID'). Change that to another user's
user_id as seen in dba_users, you should see that user's object usage:
SQL select * from v$object_usage;
no rows selected
SQL select io.name, t.name,
2 decode(bitand(i.flags, 65536), 0, 'NO', 'YES'),
Tanel,
Thanks for the info, unfortunately it does not explain what I am seeing
(almost, but not quite). I'll see if I can figure it out.
Daniel
Tanel Poder wrote:
I think Ixora website had the list with 9i stuff in it, but you also can get
some of the class definitions out by checking
List,
Any one else get word of this new virus?
Ron
Mar-D Greer 11/19/2003 9:34:44 AM
There is a new virus that has surfaced since last week. This virus
reports that users need to update their PayPal accounts. Do not open
this, delete the e-mail as PayPal has not issued this e-mail and the
Sure have I don't have a PayPall account.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Wednesday, November 19, 2003 10:40 AM
To: Multiple recipients of list ORACLE-L
List,
Any one else get word of this new virus?
Ron
Mar-D Greer 11/19/2003 9:34:44
Group,
If this was discussed before, I missed it.
There is a discussion going on trying to define the duties of a development
vs. production DBA and where in-depth DBA involvement should occur. Is there
any papers that anyone can share w/me on this subject. IMHO a DBA should be
involved early on
I received such e-mail from PayPal, didn't bother to follow
instructions, just deleted it. I'm not using PayPal anymore.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Ron Rogers
Sent: Wednesday, November 19, 2003 10:40 AM
To: Multiple recipients of list ORACLE-L
List,
Any
Title: SAN configuration for Banner
Hi List,
We are approaching the cusp of a decision
on how to store Oracle data files on our SAN. We dont have the SAN
yet, but it is due to arrive any week (if not any day).
I passed Carys Is RAID 5
Really a Bargain? paper to our Sys Admin,
The last statement here is not always true under CBO, at least in 8i. All
unique indexes (no PKs, no FKs) on our 3rd-party ERP tables are segmented,
and the last segment is always company code. Even though there is only one
company code value for all rows in all tables, some queries that do not
Group,
If this was discussed before, I missed it.
There is a discussion going on trying to define the duties of a development
vs. production DBA and where in-depth DBA involvement should occur. Is there
any papers that anyone can share w/me on this subject. IMHO a DBA should be
involved early on
I don't know about a paper, but I've always made a distinction
between these types of DBAs as well.
Development DBA responsibilities:
- initial DB design
- data modelling, data dictionary creation
- naming standards, datatype standards
- sql development
- working w/ front end developers, tuning
On Wed, 19 Nov 2003 [EMAIL PROTECTED] wrote:
I swapped emails with a member of the list and Im having trouble seeing how you can
take 3NF, BCNF, etc... and turn that into DBA speak. One of the guys told me that
BCNF essentially means you have a key that you can put a unique constraint on.
Thanks for reply everybody ,
I was not closing the file , which was causing write not to flush . Solved
now
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, November 18, 2003 10:59 AM
AK,
Do you get INVALID_MAXLINESIZE
George,
Early involvement and advice are certainly in my view essential to the success of a
project. However, concerning the creation of packages, etc. I fear I don't share your
views. Involvement is justified if it adds value. If it's just adding another layer of
red tape, forget about it.
You can try advanced replication. It has overhead of about
10% on multi master synchronous replication on the live system. Use this only if
you can put the servers near enough so you can directly connect then with high
speed network cable.
Yechiel AdarMehish
- Original Message -
We are doing exactly that. We use multi master synchronous replication. In
case the regular server dies, we drop replication from the backup machine.
Change one parameter in the application ini file (what db name to use in
connections), start the application again. About 5 minutes turn around
Agree with Stephane on this. Finding a balance of productivity, trust and
security would be the goal...
-Original Message-
Sent: Wednesday, November 19, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L
George,
Early involvement and advice are certainly in my view essential to
Yes
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, November 18, 2003 7:24 AM
What will happens if I remove all occurence of IPC protocol from
communication level, i.e. Listener? Can U work only over TCP/IP?
--
Since, I believe, Paypal is owned by eBay, has any that's received this
sent a message to safeharbor? I would think they should be made aware
of it.
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
Life is like a sewer, what you get out of it depends on what you put
into it. - Tom Lehrer.
What version are you on?
If less then 9i use the method posted by Hemant K Chitale.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, November 18, 2003 6:44 AM
Well, I mean that OS (w2k) file size of temp01.ora grows
I will ditto Stephane's and Brad's opinions on this.
If the DBA is a competent PL/SQL developer, then sure.
If not, then don't try to write the PL/SQL.
Being a competent PL/SQL developer is *much* more difficult
than it was a few years ago.
I can write PL/SQL all day if I can stick with
George - The earlier discussion was What is a Production DBA, and I found
the links by Googling Oracle-l production dba. Excellent topic.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, November 19, 2003 10:20 AM
To: Multiple recipients of list
Yechiel - So how do you verify your backup environment? My gut feeling is
that simpler systems are less prone to catastrophe, and multimaster
replication definitely adds a lot of pieces compared to conventional
backups.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original
encoded content removed -- binaries not allowed by ListGuru
The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists. If you want a copy of the attachment which was
removed, contact the sender
As I moved from development to DBA, I am trying to keep up with pl/sql
... it is FUN !!
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly personal. QOTD: Any clod
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
Oh boy.
I'd first challenge the I disagree..RAID 5 is a proven technology.
Ask him for credible research and/or statistics that support his
position. Sure, RAID 5 is a proven technology...so are floppy disks,
and so what?
Second: clustered systems with failover mitigate disk array
performance
Ryan:
I think the presentation on data modeling may help you understand and
explain thoroughly to your team. If not, I would obtain a copy of Robert
Barker's CASE*METHOD - Entity Relationship Diagramming book. The Data
Modeling Essentials book is very technical and often hard to follow for
Shibu
I agree with Ryan, that in a technical sense this is bogus. But I also
feel there is a grain of truth in it. Often at its core the question has to
do with comfort, and if recent incidents have caused a loss of comfort, then
you get some sharp questions to answer. My strategy would be to
To me, CJ Date is the one who makes it crystal clear. Not in his main book,
but in his Relational Database Readings books, which I have most of.
I have also seen some good articles by Fabian Pascal.
I also have a new book called Data Modeling for Everyone by Sharon Allen,
published by
Guys,
For management reporting has anyone considered OEM V9?? Has anyone installed it - do
you know that it provides a number of reports already defined that can be setup to be
run periodically and available on the web - all with the installation of the OEM V9?
I was thinking this would
Hi,
I have had loads of them so far in the last few days, they are a hoax,
it is being discussed on the incident list on security focus. I guess
the anti-virus product manufacturers will have details by now as well.
kind regards
Pete
--
Pete Finnigan
email:[EMAIL PROTECTED]
Web site:
I have been using the following setup.
Windows 2000 Prof. / Oracle 9.0.1 / OEM 9.0.1
While using OEM console, when I want to view the database report, it just
popup a DOS windows, but it does not show the report in the web browser. But
on the other hand, I can view the reports by opening the web
Sam,
Dell was perfectly happy to configure the following for me on a CX200 unit:
(2 trays of 15 drives, 1 tray 36 GB 15K, 1 tray 73 GB 10K, 1 hot spare per tray)
3 x RAID 1 for online redo logs (members a,b,c, 6 drives total)
2 x RAID 01 for datafiles (8 drives each, 16 drives total)
1 x RAID 1
[EMAIL PROTECTED] scribbled on the wall in glitter crayon:
Guys,
For management reporting has anyone considered OEM V9?? Has anyone
installed it - do you know that it provides a number of reports
already defined that can be setup to be run periodically and
available on the web - all with
I want to store some files. I make a new copy every night. I want to archive it back 4
days. So after 4 days, I want to delete the old copy. How do I do this?
However, if i miss a nightly batch and have less than 4 copies, I do not want to
delete any?
--
Please see the official ORACLE-L
Anyone change character sets recently?
I've got a cust that wants to take a small database from US7ASCII to UTF8 I believe it
was.
It sounds like they have all the steps down pat and are pretty much ready to go, but
are there any gotchas they may have missed?
Will this affect the RMAN backups
I obviously can't speak for the list, but I find Fabian Pascal to be
very interesting, but quite academic. What I *think* that I mean by this
is that a lot of what he says seems to make theoretical sense, but I'm
unsure how applicable it is to practice. IOW the general feel that I get
from Fabian
I did using OEM Version 2 something on 8i databases. Multiple agents - got it running
- agent management was rather a pain in the ##$$%%% I agree. Still I am thinking this
new version with its bells and whistles might be better.
-Original Message-
Sent: Wednesday, November 19, 2003
How about something like ...
find /your_dir_name_here -name '*.log' -mtime +4 -exec \ rm {} \;
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any
Jared writes
Being a competent PL/SQL developer is *much* more difficult
than it was a few years ago.
I can write PL/SQL all day if I can stick with stuff that is 5+ years
old. :)
A job with an ERP vendor awaits
Niall
--
Please see the official ORACLE-L FAQ:
How about something like
dir=foo
if [ `ls -1 $dir` -lt 4 ]; then
find $dir -mtime +4 | xargs rm
fi
On Wed, 2003-11-19 at 15:20, [EMAIL PROTECTED] wrote:
I want to store some files. I make a new copy every night. I want to archive it back
4 days. So after 4 days, I want to delete the old
There's a whole spread of stuff on MetalLink about changing
character sets. There is even a utility program called 'csscan'
that scans the DB to find potential trouble spots.
In short, though, if this DB only has 7-bit ASCII characters in
in, then a switch to UTF-8 will have no immediate effect.
USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE.USE
WITH CARE.USE WITH CARE.
COUNT=`ls -lrt dir/name|wc -l`
if [ $COUNT -ge 4 ] ;
then
find dir -name name -mtime +4 -exec rm -f {} \;
fi
USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE.USE
WITH
Agreed. And I think you'll admit it's better to be familiar with and aware of the
theory, even if current db products don't live up to the model 100%, so you know to
bring up the kinds of issues you mention in the first place. In that sense, I think
the knowledge to be gained from Date, Darwen,
The following statement will delete all files older than 5 days:
find . -name 'files_you_want_to_delete*.log' -mtime +5 -exec rm {} \;
To test it, change the name of the file name and change the 'rm' to
'ls'.
It should just list the files older than 5 days. That way you know it
is working.
Ron
Vivek did mention single DB connect process, so this should increase the possibility
of statspack matching the trace file
Did you have parallel query occurring - as then the single trace wouldn't have caught
everything.
Are you SURE no other users were active at the same time - eg look at
Hi!
I've sometimes used setting _wait_for_sync=false during Apps upgrade
projects, to upgrade performance. (As long as your database doesn't crash
during the parameter is set to false, no problems should occur).
I just started wondering, what would be the case if a parallel query starts
during
Hi Muqthar ,
thanks for you reply.
Some more precisions :
What about the OFA admin subtree (create, pfile, udump,bdump..) ?
Did you duplicate it on each node ?
What are the steps in Service Guard to configure failover File system ?
Do you use RMAN for backups ? if yes with autolocate 9i
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 possibly allow their
application to accomplish their goals. If you don't
Paul, just curious why RAID 01 rather than RAID 10.
RAID 10 is much more resistant to disk failures that RAID 01.
10 drives in a RAID 01 with drives having a MTBF of say 100,000 hours.
( don't know if the 100k is low or high )
Each stripe in the RAID 01 has a MTBF of 20k hours, which is 10k
I am lookingfor autility package for
throwing output in html format from a query . This should use utl_file to write
the file ( no sqlplus markup ). Is there any package /procedure oracle has
to do this job? This is just a html report and it will be sent to
users by email. ( this is not a
Maybe use HTP, HTF and OWA_UTIL packages? You still need to do some writing in
using them.
Yong Huang
--- AK [EMAIL PROTECTED] wrote:
I am looking for a utility package for throwing output in html format from a
query . This should use utl_file to write the file ( no sqlplus markup ). Is
Have you tried using SET MARKUP HTML SPOOL ON from SQL*plus itself? It
creates a neat HTML report and you canplace most of the formatting.
HTH.
Arup
- Original Message -
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, November 19, 2003 6:50 PM
I am looking for a utility
sqlplus -M "html
on"
-Original Message-From: AK
[mailto:[EMAIL PROTECTED]Sent: Wednesday, November 19, 2003
6:50 PMTo: Multiple recipients of list ORACLE-LSubject:
html output
I am lookingfor autility package for
throwing output in html format from a query . This
Hello!
I have next problem: I've setup Listener and TNS Names and I can connect to
database but only when SID is specified. I want to specify default database
to connect to.
D:\Backup\oraclesqlplus cheques/cheques
SQL*Plus: Release 9.0.1.3.0 - Production on ? 20 08:33:55 2003
(c) Copyright
Oh well, even though we're not talking about RAID-F anymore, let's break
the rule now and then :-).
It's funny to see how the technical guys say the correct things, the
vendor guy says some rubbish, and the manager guy decides to do as the
vendor says. Maybe that sort of interesting decision
VirVit,
Looks to me like ORACLE_SID isn't specified in your windows environment.
Check the registry under HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0 for a string key
called ORACLE_SID. If it's there, set it to your SID. If it's not, add it and set it
to your SID. Alternatively, set an
74 matches
Mail list logo