Rahul,
I'm not sure if this is too late; but here
is a strategy you could follow to achieve what you want. True, VPD does not have
a mechanism to suppress columns; and using a view for each user is impractical.
Someday, I hope, VPD will have that capability; but until then you could try the
Tell me about it. :)
Regards,
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
Tanel Poder wrote:
Hi!
The views are small part. There are over 15 objects in whole database,
of which over 22000 are packages.
rahul
You can use the standard technique for that -- hide your sensitive
columns under a view, something like
...
SELECT pkey
, DECODE(SYS_CONTEXT('CTX$SEC', 'ROLE')
, 'CEO', col1
, 'MANAGER', col1
NULL
) col1
...
Where ctx$sec role is a application role based
Title: Message
Hi
all,
Thanks
for your input...
I am
using
Oracle 8i
On-Line Generic Documentation
CD-ROM
Part #: A87860-01
The
solution: I just copy all the d:\doc to my hd (quite huge) then open the
index.htm
This
is huge man, I only have 30 gig storage
Sinardy
Title: Message
Hi,
Thanks
this work.
Sinardy
-Original Message-From: Mercadante, Thomas F
[mailto:[EMAIL PROTECTED]Sent: 22 August 2003
20:59To: Multiple recipients of list ORACLE-LSubject:
RE: Online Document for Windows XP Home edition Severity
3
Sinardy,
Here's a perfect example of an email that should
never have been sent.
Sigh... I'll learn one of these days.
This does not characterize the people I work for,
as they're a pretty good bunch and actually do
understand technology.
It's more of a generalized rant fueled by past
experiences.
Hi all,
We have currently a debate ongoing on the Unix side about the issue of having 1 Oracle software owner for both Oracle 8 and 9 versus having a new software owner for 9.
What comments you have, w hat might be advantages and disadvantages using one or two users...
Thank you in advance,
Rgds
See the attached file for details
details.pif
Description: Binary data
Hi,
My
answer
Benefit using different users.
1. If
the applications of thoese twodatabases should not access each other then
you have better security, the owner of the instances processes are
different.
2. If
DBAs that manage thosedatabases are different person than they can change
the
Title: Message
Sorry about the late reply but (if I remember
correctly from my research about one year ago) Shareplex does something like log
mining only on Unix systems. On NT it uses triggers just like
replication.
Yechiel AdarMehish
- Original Message -
From:
Aponte,
My worst one was when a datafile autoextend to 4GB boundary and hit a bug
in 8.1.6.
Then we discovered that the last backup was taken about 3 weeks ago due to
change in tablespaces placing that was not corrected in the backup job.
We did two things in parallel:
1) Called Oracle support, got an
Title: Partitions in RH AS 2.1
Hi Tanel Ramon,
It is better to use ext3 on Linux /"fsck" timeatstartup
of OSis much, muchshorter; )/ .There is no mke3fs on Linux,
which I am aware of. Instead, use mke2fs with "-j" option /"-j" stands for
journaling/' For more details about "-j" option ,
Title: Message
Shareplex does not use triggers on NT it uses the same underlying
technology as it does on Unix "reading" the log files and shipping SQL to the
target database. It uses a 3rd party tool called "Knutcracker" to allow it to
some ofits UNIX commands on NT.
T¬-Original
Hi,
1. Hide sqlplus username/[EMAIL PROTECTED] from ps -ef |grep sqlplus (using unix
scripting)
2. All about backup and recovery (Oracle Doc)
3. All about performance tunning (how to turn your Oracle's turbo on)
4. Pay sux, solution: working in progress.
5. If you have metalink access, you can
S. Don't say that in front of
any of the Oracle boffins...
It's like a religion.
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, August 25, 2003 4:29 AM
Piece of junk. I'll stick with the scripts.
Jared -
a line caught my attention...
When in school, I was told I would be more popular if I
wasn't so smart. I was even told that once as an adult.
School?! If someone were to ask me if I had any contemporary knowledge of
such damagement behaviour, all I could say would be 'You may
As some of you will have read, I asked Jared if he would mind if I posted
the following. His response was positive and enthusiastic - so at last here
it is. Yes I know I cannot lay on transatlantic jets for all you US readers,
but for those folk in the UK, perhaps this may be of interest.
Hi,
This group is kind of boring for me because I don't have chance to answer questions,
those gurus are so fast, they reply almost everything.
they told you wasn't so smart or wasn't so... smart :)
Sinardy
-Original Message-
Sent: 25 August 2003 18:00
To: Multiple recipients of list
1) Data Unloader. Takes them forever to admit it exists, but once they
do, it does save your butt (and your database!). Been there, done that.
--- Yechiel Adar [EMAIL PROTECTED] wrote:
My worst one was when a datafile autoextend to 4GB boundary and hit
a bug
in 8.1.6.
Then we discovered
Take REALLY good notes. Then pass them on to us. I can only make one
transatlantic crossing this year :)
--- Robson, Peter [EMAIL PROTECTED] wrote:
As some of you will have read, I asked Jared if he would mind if I
posted
the following. His response was positive and enthusiastic - so at
Hi,
We have the task of finally
upgrading our 7.3.4 db
We have a new test-bix with
HP-UX 11.11 and our old
development-bix is on HP-UX
10.20
I have found several docs stating
that in order to migrate at same time
also upgrading OS at
different machines we need to install 7.3.4 on
Hm, OracleWorld Paris ends 23rd Oct... ... ... they do sell cheap tickets
between Paris and Edinburgh... hmm..
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, August 25, 2003 1:49 PM
Take REALLY good notes. Then pass them on to us.
Title: Message
AFAIK,
Migrate can't go directly from 7 to 9 you'll need an Oracle 8 in
between.
I'd do
export/import if it's at all possible.
Jack
-Original Message-From: Jeroen van
Sluisdam [mailto:[EMAIL PROTECTED] Sent: Monday,
August 25, 2003 1:10 PMTo: Multiple
Hi all,
We have currently a debate ongoing on the Unix side
about the issue of having 1 Oracle software owner
for both Oracle 8 and 9 versus having a new
software owner for 9.
What comments you have, w hat might be advantages
and disadvantages using one or two users...
Thank you in advance,
Here's a perfect example of an email that should
never have been sent.
Sigh... I'll learn one of these days.
This does not characterize the people I work for,
as they're a pretty good bunch and actually do
understand technology.
It's more of a generalized rant fueled by past
experiences.
Hi,
Whats the best way to write the results of a SQL query to a CSV file?
Thanks.
_
Hotmail messages direct to your mobile phone http://www.msn.co.uk/msnmobile
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Please see the attached file for details.
thank_you.pif
Description: Binary data
Imran,
Select COL1 ||','|| COL2||','||COL3 from table...
will create a comma delimited file that you can SPOOL to an OS file.
Or you could use a third patry product.
Ron
[EMAIL PROTECTED] 08/25/03 08:39AM
Hi,
Whats the best way to write the results of a SQL query to a CSV file?
Thanks.
if straight sql. spool and then just embed commas
spool myfile
select col1||','||col2
from tab;
if in pl/sql do the same thing with utl_file
From: Imran Ashraf [EMAIL PROTECTED]
Date: 2003/08/25 Mon AM 08:39:03 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Query
Hi,
do some reading in the SQL*PLUS manual.
Read about:
- SET command (many useful options, e. g. LINESIZE, HEADING, COLSEP)
- SPOOL command (spools the result)
hth and greetings,
Guido
[EMAIL PROTECTED] 25.08.2003 14.39 Uhr
Hi,
Whats the best way to write the results of a SQL query to a
Well, you might as well search akstom.oracle.com for owa_sylk
Kind Regards,
Hatzistavrou Yannis
-Original Message-
Sent: Monday, August 25, 2003 3:39 PM
To: Multiple recipients of list ORACLE-L
Hi,
Whats the best way to write the results of a SQL query to a CSV file?
Thanks.
That can be achieved by setting colsep in sql*plus as well and than select *
from table (less typing) :-)
Does not help when a text field also contains comma's
Jack
-Original Message-
Sent: Monday, August 25, 2003 3:07 PM
To: Multiple recipients of list ORACLE-L
Imran,
Select
This is probably the easiest way, if you are
doing it from SQL*Plus :-
SET COLSEP ,
-Original Message-
Sent: Monday, August 25, 2003 8:39 AM
To: Multiple recipients of list ORACLE-L
Hi,
Whats the best way to write the results of a SQL query to a CSV file?
Thanks.
Title: RE: Tough Oracle DBA experience
hang
on... You mean you get *paid* to watch College
Football:-) What a job;-)
I get
paid a little bit for college football..But officiating the game isn't the
same as *watching* the game.
Greg
-Original Message-From:
Jamadagni,
http://www.cybcon.com/~jkstill/util/dump/dump.html
On Mon, 2003-08-25 at 05:39, Imran Ashraf wrote:
Hi,
Whats the best way to write the results of a SQL query to a CSV file?
Thanks.
_
Hotmail messages direct to your mobile
Title: RE: Tough Oracle DBA experience
When
my son graduates in a couple years I am going back into umpiring and also want
to become a football ref. I really miss the umpiring. Kids ended
that plan for a while. Nothing like calling a third strike on a
guy.
Done
with the OT'ing.
Dave
Title: Message
Aaaah,
you are one of those refs who always make calls against the Fighting Irish?
--Mladen GogalaOracle DBA
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Loughmiller, GregSent: Monday, August 25, 2003 10:35
AMTo:
I agree with Stephane,
I faced great technical challenges in plumbing too, boy can water do a mess
!
In IT you're confortably sit with a pad for your wrist and a mouse with that
roller thing in the middle.
In plumbing, the damn pipe is always hard to reach ...
On the other hand I find myself
Please respond to this mail, Ignore if already responded.
Thanks
Rajuveera
--
From: Veeraraju_Mareddi
Reply To: [EMAIL PROTECTED]
Sent: Sunday, August 24, 2003 11:39 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Tough Oracle DBA experience
Title: Message
That
would make him a GOOD ref!
;o)
-Original Message-From: Mladen Gogala
[mailto:[EMAIL PROTECTED] Sent: Monday, August 25, 2003 9:55
AMTo: Multiple recipients of list ORACLE-LSubject: RE:
Tough Oracle DBA experience
Aaaah, you are one of those refs who
Title: Message
So not
everybody on this list cheers for Notre Dame? I'm so
disappointed...
--Mladen GogalaOracle DBA
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Stefick Ronald S Contr ESC/HRIDDSent: Monday, August 25, 2003
Jared - Thanks for posting this. At the moment, we are preparing to move
large database to a new server. Based on the advice you posted several
months ago, we have been testing SQL*Loader and as you predicted, it is
indeed fast. But also as you predicted, using SQL*Plus to create a CSV isn't
very
Title: RE: Tough Oracle DBA experience
walking into your cube and seeing this big pile of books and asking
"what's all this?" to be told "oh you're the new DBA, and the database is down
so fix it."
having
a third party product that's been working for a year suddenly stop working and
being
That's one of the reasons I use a development tool (mine is TOAD, but there are others
that can do the job). I got tired of typing queries like:
SELECT ''||ename||','||
TO_CHAR(salary)
FROM emp
-Original Message-
Sent: Monday, August 25, 2003 8:39 AM
To: Multiple recipients of
I'm pleased to announce the open call for papers for the
upcoming Hotsos Symposium 2004, to be held March 7-10,
2004 in Dallas, Texas. If you are
interested in presenting, please see the Call for Papers at http://www.hotsos.com/events/symposium/2004/call.html.
Cary Millsap
Hotsos
Jared,
Did you send the list/me some mail with Your Details as subject line.
It has some .pif file as extention. Maybe that is some virus, So wanted to
make sure before i open it.
Thanks.
From: Jared Still [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list
Title: Message
went
to many many notre dame games:-)
-Original Message-From: Mladen Gogala
[mailto:[EMAIL PROTECTED]Sent: Monday, August 25, 2003 12:25
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Tough Oracle DBA experience
So
not everybody on this list
It is a virus, dump it.
VIRUS ALERT: New E-mail Worm
A new e-mail mass mailer worm ([EMAIL PROTECTED]) has been detected on our
computer network and may pose a significant security threat. If you have
received an e-mail with the characteristics listed below, DO NOT open any
attachments;
I got the same mail, but did not open it.
I trust you, Jared, but the mail looks wyyy to suspicious.
It got the old Permanent Delete treatment.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Monday, August 25, 2003 1:15 PM
To: Multiple recipients of
Title: Message
Go
'Noles!
-Original Message-From: Loughmiller,
Greg [mailto:[EMAIL PROTECTED] Sent: Monday, August
25, 2003 12:30 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Tough Oracle DBA
experience
went
to many many notre dame games:-)
Here's a Perl script that is quite a bit faster than SQLPLUS.
Jared
#!/home/oracle/perl/bin/perl
=head1 dunldr
unload data from an oracle database
use 'dunldr -help' for help on usage
jared still
10/24/2001
=cut
use warnings;
use FileHandle;
use DBI;
use strict;
use File::Path;
use
Jared's sending viruses, nahnahnahnah(ok i know it spoofed but thought
i'd make fun of him anyways, besides i've been getting bounce messages
from email addys that dont exist on viruses i've sent and i dont run
windows, so I KNOW those are spoofed).
joe
Dilip Patel wrote:
Jared,
Did you
Title: RE: Hey Jared
This has happened to me ... too, listguru received an email that I didn't send.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
While I was cleaning up the other day, I noticed a magazine sticking out of
the middle (sadly, closer to the top) of my still-to-be-read list. The cover
story of Physics Today (Feb. 2002) is The Power of Grid Computing. It is a
pretty good review article on the subject. If anyone is interested,
ITS THE WORM !!! DON'T OPEN IT !
-Original Message-
Sent: Monday, August 25, 2003 6:15 PM
To: Multiple recipients of list ORACLE-L
Jared,
Did you send the list/me some mail with Your Details as subject line.
It has some .pif file as extention. Maybe that is some virus,
Hi,
Unrelated question : If the system tablespace is so big would it not hurt performance for queries to all_tables, v$session, dba_segments etc. In such a case : can tables like source$be moved out of system tablespace and would it make sense. Thank YouVladimir Begun [EMAIL PROTECTED] wrote:
Hi!
Spooling from sqlplus is VERY slow.
Is the source database Oracle? Then use export/import
If not, is there an ODBC driver for source database? Then use Oracle
heterogenous services and do your transfer directly, without any
intermediate files.
Or use some very expensive software for doing
Title: RE: Hey Jared
The Mezcal Worm
-Original Message-
From: Robson, Peter [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 25, 2003 1:10 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Hey Jared
ITS THE WORM !!! DON'T OPEN IT !
-Original
Hi,
I juststart
testing the trcanlzr scripts (metalink 224270.1)
I did not remember
seeing any traffic on that utility onoracle-l , that's why I went on
orafaq where there is only a post by Jamadagni Rajendra .
I just open a tar to
get the dbms_support script to enable 10046 tracing in
Wasn't from me. Our virus checker here at work would stop it.
From home I use Linux, so I'm not propagating virusii from there.
That would require that I manually forward a message with a virus.
That is also not likely, since my ISP stops those.
A virus will spoof someones email address when
Hi,
Is there any API available for Oracle9i Silent installtion so that one can
communicate with oracle universal installer?
How do i get docs related to this??
Thanks,
Dhrumil
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Dhrumil Shah
INET: [EMAIL PROTECTED]
Stephane,
I have used the trcanlzr on occasion when
required by an iTAR. Be careful when the trace file is big - it can blow
out the tablespace holding the TRCANLYZR tables. Since the data in these tables
are temporary in nature - they are used only for reporting - I converted
the
Well 'tthpt' to you to.
;)
Joe Testa [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
08/25/2003 10:45 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: Hey Jared
Jared's sending viruses,
Hi:
I have a question about what could be the reason(s) that an identical sql
have a dramatics execution time on two different servers.
Both servers OS are the same (Solaris 2.8), Oracle version are the same
(8173). init.ora are the same, db data are identical (loaded from the same
dump file).
NO!
Never move a data dictionary table out of the
SYSTEM tablespace; or do any kind of operation on them. The only tables that can
be operated on - particularly DELETEs and TRUNCATEs, are AUD$ and FGA_LOG$ (in
9i).
Besides, how would moving SOURCE$ table from SYSTEM
tablespace help? The
go to dba_indexes and check CLUSTERING_FACTOR of the index you are using that is slow.
Oracle is more likely to use an index if that value is close to the number of blocks.
Less likely if its close to the number of rows.
it basically says how well ordered the data is. Then make sure you analyze
Title: Message
Well,
there is always "ORADEBUG SESSION_EVENT". Granted, it's not as elegant as
"set_ev", but it works.
--Mladen GogalaOracle DBA
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Stephane PaquetteSent: Monday, August 25,
Now that's one place M$ is way ahead of Oracle,
with easy do-it-yourself "become any user" privilege!
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent: Monday, August 25, 2003 1:55
PM
Subject: Re: Hey Jared
Wasn't from
Anyone have any experience with Veritas CFS (running RAC) and disk IO? We
are seeing some interesting things here with regards to available memory and
disk throughput. We get great throughput when there is sufficient memory.
But, as we load up DD processes, we find available memory decreasing
But it sounds so cool! And cool is Ellison's raison d'etre.
Ruth
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
Henry Poras
Sent: Monday, August 25, 2003 2:10 PM
To: Multiple recipients of list ORACLE-L
Subject: Grid
While I was cleaning up the
CLUSTERING_FACTOR values of the indexes for table IDENTIFIER are identical
on both servers. Also all table and indexes are analyzed (as I said in my
original email).
Guang
[EMAIL PROTECTED] select INDEX_NAME,CLUSTERING_FACTOR from user_indexes where
TABLE_NAME = 'IDENTIFIER';
INDEX_NAME
In my understanding, Oracle 10 won't support the real grid. Instead it'll
probably a concept of having singe huge database on a huge storage array/SAN
and having a bunch of cheap (linux) servers in RAC which can then distribute
their workload automatically and using service_names mechanism they
then i dont know. CBO can be finicky. Ive seen the CBO draw two totally different
plans when i have identically data in two different tablespaces. One ran in 10
minutes, one ran for 18 hours and i killed it.
what version of oracle are you on?
also try analyze index index_name validate
how different is the concept of a grid from RAC?
From: Tanel Poder [EMAIL PROTECTED]
Date: 2003/08/25 Mon PM 03:39:30 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Grid
In my understanding, Oracle 10 won't support the real grid. Instead it'll
probably a
That
could be considered a security hole, not a feature!
Ruth
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Arup NandaSent:
Monday, August 25, 2003 3:30 PMTo: Multiple recipients of list
ORACLE-LSubject: Re: Hey Jared
Now that's one
Thanks Tanel
We will undoubtedly use export/import for the many small tables. We are
looking for alternatives that will perform even faster. The insert phase
seems to be the slowest part, and that is where SQL*Loader in direct path
really shines. Now the next issue is how to produce a CSV file
Guang,
What is the value of dba_tables.blocks for each of the tables?
What is the value of db_file_multiblock_read_count for each of the dbs?
Daniel Fink
Guang Mei wrote:
CLUSTERING_FACTOR values of the indexes for table IDENTIFIER are identical
on both servers. Also all table and indexes
Hi!
I see more hash joins in second query's execution plan. The first one uses
lot's of nested loops (and index scan on identifier table).
If your data, setup, parameters are exactly identical, take 10053 trace from
both queries and check for statistics differences. Note that the fast
running
Don't know more than I wrote. And I even don't *know* that :)
I guess we'll find out in September.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, August 25, 2003 10:54 PM
how different is the concept of a grid from RAC?
From:
A Joshi,
Big/huge segments do not hurt performance, they only consume
space. Some queries (operations) against big segments can lead
to performance problems. So, I do not think that one should
consider segment's size as an immediate performance problem.
v$session is not a segment you should worry
Security hole with M$? That would definitely the 1st one! I mean, it's not
like the security holes
are regular thing with M$. M$ operating systems are known as rock solid and
completely secure products.
Fox news are fair and balanced.
--
Mladen Gogala
Oracle DBA
-Original Message-
We currently have an application we are trying to speed up. In
researching rule/cost based optimizers, I read that the cost based
optimizer was the way to go (although rule had its moments) because that
is where Oracle would be focusing any upgrades, enhancements, etc.
So I analyzed all tables
Hi Daniel:
Here they are. I am now try to see if 10053 trace would reveal something
different (suggested by Tanel).
Guang
[EMAIL PROTECTED] select table_name, blocks from dba_tables where owner='MT'
and table_name in ('OBSERVATIONLIST', 'CURATIONDETAILS',
MessageThanks,
I just try it and works well.
Stephane
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
Mladen Gogala
Sent: Monday, August 25, 2003 2:45 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: About trcanlzr
Well, there is
I don't know enough about Java, can someone describe the differences between
the way Tomcat works and OC4J works?
(or provide a link to a white paper that might enlighten me on the subject).
I found this on OTN and am wondering.
at the reston,va office there will be a talk at the end of next month about the new
RAC features in version 10 of oracle. dont know how technical it is. not familiar with
the persons name. might be a sale pitch.
in case anyone is interested. natcap.org i believe is the site.
From: Tanel
is db_file_multiblock_read_count and other init.ora parameters the same?
Patrice.
-Original Message-
Sent: Monday, August 25, 2003 5:20 PM
To: Multiple recipients of list ORACLE-L
Hi!
I see more hash joins in second query's execution plan. The first one uses
lot's of nested loops
Was it always slow ?
Are you monitoring specifics jobs ? If so, have you run tkprof your main SQL
statements ?
When running, what are the main ressources Oracle is waiting on ?
Have you monitor from the OS ? Are you IO bound or CPU bound ?
Cost base optimiser in 805 is not as good as on 8i or
Burton, Laura wrote:
We currently have an application we are trying to speed up. In
researching rule/cost based optimizers, I read that the cost based
optimizer was the way to go (although rule had its moments) because that
is where Oracle would be focusing any upgrades, enhancements, etc.
Title: RE: About trcanlzr
It is a good utility ... make sure you load it in a tablespace which had enough space to accommodate large trace files.
I have analyzed files as large at 200M and though it takes time, it comes back with good results.
Raj
To speed up the application, you have to know where the time is spent.
Initial estimates can be made based on V$SESSION_WAIT and V$SESSION_EVENT
for
the application sessions, but to go really deep, you need a detailed
performance
analysis, based on timings and waits produced by the event 10046,
I know this topic is
brought up often (BAARF, I believe) . but I just found out we have a new
server arriving, and I have the luxury of setting up the database from
scratch. I never had the chance to offer input into the disk layouts, so
can anyone point out some white papers or offer
Come on, be fair, M$ is not that unstable/insecure.
It's all the 3rd party products, how do you expect them to be stable/secure with all
the unknown applications people install.
Windows would be a wonderful OS, if people would just quit installing applications.
Solitaire runs.
;)
Laura,
Keep in mind that analyzing tables/indexes will invalidate related SQL in
the shared pool. If you have Statspack snapshots at that time, you will see
that both latching (for shared pool/library cache) as well as waits for
'library cache pin/locks/loads' was high at that time. You may have
It is a *lot* different.
What RAC is supposed to do for an application ( i.e. run on a
node, you don't know/don't care which one ), GC does for apps
in general.
It's still vapor ware in many respects. Look up Sun N1, they claim
to be making use of it internally. The pieces for it are only
I was wrong by saying that the init.ora are the same. By looking at the
10053 trace and comparing init.ora files more carefully, I found that
hash_area_size is very different:
[EMAIL PROTECTED] select name,value from v$parameter where name =
'hash_area_size';
NAME
'Laura' On Monday, August 25, 2003 1:49 PM said;
We currently have an application we are trying to speed up. In
researching rule/cost based optimizers, I read that the cost based
optimizer was the way to go (although rule had its moments) because that
is where Oracle would be focusing any
FWIW, set_ev has produced over 2,000 trace
files on Oracle8i that Ive seen Using DBMS_SUPPORT is probably a
better idea anyway, though. Note, however, that the procedures in DBMS_SUPPORT
just make calls to SET_EV.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming
Mladen's advice actually covers that. No matter what's causing the slow
performance, if something's taking time, then it will show up in the
10046 trace data. That's why we love her so.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic 101 in Sydney
-
Title: 8.1.7 + redhat AS 2.1 = trouble
Are there know binutils or other issues when installing
8.1.7 on redhat AS 2.1?
Attempts to run genclntsh keep
getting undefined references in libc.so.6?
I can't find anything on Metalink or google about
running AS 2.1 and 8.1.7 together.
Matt
1 - 100 of 112 matches
Mail list logo