Dear All,
Here we have about 14 Oracle devlopers and some times they run a
sript which down grade the database performance. I nicely asked for a script
that a developer has run for testing but sometimes they won't give away it
so easily. So I would like to know that is it possible to get
With the advent of quantum microbiology and the
like, most informed
people agree that 21st medicine is a science.
However, medicine as
practiced in the 17th century was definitely an
art, not a science. The
argument that tuning is an art--that it is
subjective like a
symphony or like cooking--is
Hi Lisetrs,
I have enough free memory from shared_pool_size and
I run stats every week but the BD still shows up the
low hit ratio and some times the later full down to
15%!
Here is some informations:
Are any of the users complaining that their business functions are
performing poorly?
I'd say start with DBI and the DBD for ORACLE. to be found at CPAN.Thread trough, but
its easy. Look out for matching versions. Some have prerequisites.Then check the
manpages coming with these things. man DBD, man DBI,...
hope it as useful - used to get them this way before I started using the
Does anybody out there use U2 databases?
http://www.theregister.co.uk/content/53/29457.html
Mark
===
Mark Leith | T: +44 (0)1905 330 281
Sales Marketing | F: +44 (0)870 127 5283
Cool Tools UK Ltd | E: [EMAIL PROTECTED]
All other things being equal (and there
are a couple of pages in the performance
tuning guide outlining some things that
are not equal - like joins conditions, indexed
columns, subqueries, user-defined functions
etc.) the 'final' predicates against a single table
are evaluated from the bottom up
Robert:
There is no single LRU (if you want to call LRU lists) in Oracle9i.
There are 7-8 replacement lists in 9i and they are like LRU, LRUW,
CKPT Q lists (like thread checkpoint, file checkpoint and recovery
checkpoint lists), LRU list for OPS/RAC ping blocks, and some other
lists.
And also
I had Unidata at my last job.
Dave
-Original Message-
Sent: Wednesday, February 26, 2003 4:44 AM
To: Multiple recipients of list ORACLE-L
Does anybody out there use U2 databases?
http://www.theregister.co.uk/content/53/29457.html
Mark
Yeah,
fond memories of a totally reliable system.
Anyone
heard of a means of making emacs emulate this editor? I believe ithas beendone.
peter
-Original Message-From: Mogens Nørgaard
[mailto:[EMAIL PROTECTED]Sent: 26 February 2003 04:19To:
Multiple recipients of list
A lot of traffic on this one. Sorry if I missed this point, but it seems
important to me, and appears not to have been mentioned.
Ensure that the work you do on the db is focussed on meeting your company's
business objectives.
Then start reading the list of predominantly technical do's and
Sorry for the delay in replying; something more urgent popped up.
Nope, the x$uganco doesn't show the db_links opened by other sessions. The
inst_id field looks like it would be useful only in Parallel Server
environments. Any other ideas?
I can't believe Oracle doesn't keep track of open
I'd prefer a procedure as it is likely that this will have to be run
every week.
FYI: I'm not looking for you to write the code for me, just give me some
general direction as I am new to PL/SQL and now I've been asked by
management to script this. This is what happens when your IT department
is
My bad.
I should also have posted the 10046 trace. I did a 10046 trace and also a
STATSPACK report. Of the total time, more than 50% of the time is spent
waiting on DIRECT PATH WRITE and around 40% of the time it waits on
DIRECT PATH READ. This is what prompted me to do a truss and see what it
The U2 databases were alsways known to me as PICK databases since that is
their origin. I worked with a higher ed administrative system called AIMS
that was ported from a PICK system to Universe. AIMS is no longer being
sold, but a company called Datatel sells software for higher ed institutions
I think the thing that is clear throughout this thread is that this DBA
business is a complex one, and very very hard to categorize in a list of 10
simple do's and don'ts :-)
Cheers!
Robert
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 2/26/2003 5:59 AM
A
Are you working with archive log?
I saw this behavior when there was a problem in writing to an archive log
and the arch process stopped.
I think that instead of renaming you should copy the file and then deleting
all lines from it.
Yechiel Adar
Mehish
- Original Message -
To: Multiple
Title: RE: trace (get) sql script
Hi,
If you've asked nicely; tried reasoning with the developer; and talked to management without success, use this:
REVOKE CONNECT from developer_user_name;
Works for me!
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
Run STATSPACK at Level 5 (default). It will capture most of the offending
SQL Statements
Babu
[EMAIL PROTECTED]
Chao, Connor, Sanjay, cary, mark, richard:
Thanks for your input. I didn't think of creating
a new table and then renaming it as many of you
suggested this may take les time.
thank you all very much
Gene
--- chao_ping [EMAIL PROTECTED] wrote:
Gurelei,
I suggest your create your
When is the best time to gather Global Stats? Using the old ANALYZE command, I
would analyze each partition as it accumulated data. Now that we have global stats,
should I be gather global stats each time I analyze a partition? That would naturally
increase the length of time to gather
CHeck your yahoo mail I sent you some psuedo code you can flesh out.
BRad
-Original Message-
Sent: Wednesday, February 26, 2003 6:34 AM
To: Multiple recipients of list ORACLE-L
I'd prefer a procedure as it is likely that this will have to be run
every week.
FYI: I'm not looking
I have seen some folks record the performance data and then play it back in
OEM. I think it is there in the performance manager add in. Is that what
you want?
How different you expect this to be from STATSPACK?
Babu
So -
My shortlist of Don'ts
1)Don't try to do things by lists.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Coming soon one-day tutorials:
Cost Based Optimisation
Trouble-shooting and Tuning
Indexing Strategies
(see http://www.jlcomp.demon.co.uk/tutorial.html )
Title: RE: Query failing in CBO mode
Okay ... Rule Number 1.
Always convert the data type of the *variable value* to that of table column you are comparing with, and not the other way. The later part causes the problem.
Raj
-
Team,
Our tables are partitioned by 52 weeks. We would like to know the name of
the partitions that are growing/increasing.
Are there storage parameters for Partitions in Oracle 7, 8i, 9i ?
Where can I find supporting documentation?
Or. Where can I find excellent documentation about partition ?
Hi All,
I am starting to play with rman in a test environment, however I seem
to be hitting a really basic problem starting rman.
I have oracle 9.2.0.1.0 installed on Redhat AS 2.1
When i issue the command:
rman target='backup_admin/backup as [EMAIL PROTECTED]' nocatalog log=test.log
rman:
We had a session with an expert on Monday and he recommended export to
\dev\nul to detect errors in the database.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, February 24, 2003 10:41 PM
I had the same belief that RMAN
Thanks. But neither statements work. hl1_cost is never populated for any
of the -OR items.
whse_code and item_num are the primary keys.
Thanks again for your help.
Saira
-Original Message-
Sent: February 26, 2003 12:29 AM
To: Multiple recipients of list ORACLE-L
Do these SQL
Title: RE: update 30mil rows
You did enable parallel dml right?
=alter session enable parallel dml;
-Original Message-
From: Gurelei [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 25, 2003 3:27 PM
To: Multiple recipients of list ORACLE-L
Subject: update 30mil rows
Hi all:
Does anyone happen to remember when
Juan Loaiza and Bhaskar Himatsingka first
published their paper called:
How to stop defragmenting and start living:
the definitive word on fragmentation.
Thanks
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Coming soon one-day tutorials:
Cost Based
Hi
I don't think you need to have 'as sysdba' in your connect string.
(But it's been a while)
Jack
-Original Message-
Sent: woensdag 26 februari 2003 14:29
To: Multiple recipients of list ORACLE-L
Hi All,
I am starting to play with rman in a test environment, however I seem
to be
The current copy I have says copyright 1998. But thinks it's an updated
version and the original was around 1996-97.
Jonathan Lewis wrote:
Does anyone happen to remember when
Juan Loaiza and Bhaskar Himatsingka first
published their paper called:
How to stop defragmenting and start
On Wed, 26 Feb 2003, Yechiel Adar wrote:
We had a session with an expert on Monday and he recommended export
to \dev\nul to detect errors in the database.
Well the expert isn't going to find any corruptions in indexes that
way.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
--
Please
This is odd. If you goto $ORACLE_HOME/bin and run ./rman nocatalog, does it
work?
RF
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 2/26/2003 7:28 AM
Hi All,
I am starting to play with rman in a test environment, however I seem
to be hitting a really basic problem
Hi Freeman,
Wednesday, February 26, 2003, 2:39:20 PM, you wrote:
FRI This is odd. If you goto $ORACLE_HOME/bin and run ./rman nocatalog, does it
FRI work?
FRI RF
FRI -Original Message-
FRI From: Ceri Townsend
FRI To: Multiple recipients of list ORACLE-L
FRI Sent: 2/26/2003 7:28 AM
FRI
There is no generic answer to that question.
Global Stats on partitioned tables do take a
long time to collect - and you do need them
to be reasonable because any query that the
optimizer cannot pin down to exactly one
partition at parse time is optimised according
to the global stats.
The best
Ceri, I know the problem, on RH, do a which rman, you're probably
hitting the binary that does Reverse MANpage.
do a $ORACLE_HOME/bin/rman instead and all should be well.
joe
Hi All,
I am starting to play with rman in a test environment, however I seem
to be hitting a really basic
search.cpan.org
look for database or oracle or dbi
On Tue, 25 Feb 2003, sstefick wrote:
I've done some basic Perl programming for UNIX Sys admin kinda tasks, but now
I'm looking to get more into the DB functionality of it. I was wondering if
anyone could give me a list of Perl Modules I
I'm dealying with the same RMAN not checking corruption -- on 9.2.0.1
and Solaris. and it's a data warehouse.
So far I've got 9 corrupted datafiles and over 40 corrupted objects.
fortunately most are indexes.
it's going to be a good day. NOT
--- Yechiel Adar [EMAIL PROTECTED] wrote:
We had
The connect string looks invalid. Please try:
rman target='backup_admin/[EMAIL PROTECTED] as sysdba' nocatalog log="test.log"
Have Fun :)
Ceri Townsend wrote:
Hi All,
I am starting to play with rman in a test environment, however I seem
to be hitting a really basic problem starting rman.
An export is a great method for catching corruptions in tables. However,
it does not read indexes, so it misses those corruptions. Analyze and dbv
will.
Yechiel Adar wrote:
We had a session with an expert on Monday and he recommended export to
\dev\nul to detect errors in the database.
Seems like 1999 around OOW.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Wed, 26 Feb 2003, Jonathan Lewis wrote:
Does anyone happen to remember when
Juan Loaiza and Bhaskar Himatsingka first
published their paper called:
How to stop defragmenting and start living:
the
Sorry, no more ideas.
Allan
-Original Message-
Sent: Wednesday, February 26, 2003 6:19 AM
To: Multiple recipients of list ORACLE-L
Sorry for the delay in replying; something more urgent popped up.
Nope, the x$uganco doesn't show the db_links opened by other sessions.
The inst_id field
One thought to add to the Create as select nologging
suggestion that you've had.
It is likely to be quick - and if you have enough
spindles in play it may be even quicker it you
make it execute as a parallel create.
If you do, be careful of your choice of extent size,
as each separate PX slave
-Original Message-
rman target='backup_admin/backup as [EMAIL PROTECTED]'
nocatalog log=test.log
rman: can't open target=backup_manager/backup as [EMAIL PROTECTED]
Get rid of the as sysdba. rman will automatically connect however it
needs to connect. Be sure you have granted
This worked:
SELECT A.WHSE_CODE,A.ITEM_NUM,B.LAST_COST FROM ITEM_W A,(SELECT DISTINCT
(LAST_COST),SUBSTR(ITEM_NUM,1,6) ITEM_NUM FROM ITEM_W WHERE
LAST_COST0) B WHERE SUBSTR(A.ITEM_NUM,1,6) = B.ITEM_NUM AND
RTRIM(A.WHSE_CODE) NOT LIKE ('CD%');
A suggestion from someone on the COGNOS mailing
According to a quick search on google, it came out in '97
do you need finer detail on the date?
--- Jonathan Lewis [EMAIL PROTECTED] wrote:
Does anyone happen to remember when
Juan Loaiza and Bhaskar Himatsingka first
published their paper called:
How to stop defragmenting and start
LOL... well you have not effectively put me in my place! :-D
RF
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 2/26/2003 8:18 AM
So -
My shortlist of Don'ts
1)Don't try to do things by lists.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Coming soon
Perhaps someone on the list will know the answer as I have not found
anything in the manual (though I might have missed it).
If a procedure is performing file i/o to more than one file and an exception
is raised related to the utl_file package how can I determine which file had
the exception?
Don't need the as sysdba bit
RF
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 2/26/2003 9:54 AM
The connect string looks invalid. Please try:
rman target='backup_admin/[EMAIL PROTECTED] as sysdba' nocatalog
log=test.log
Have Fun :)
Ceri Townsend wrote:
Hi
Try v$sql, v$sqlarea, and v$sqltext. They should get
you everything you need.
--- [EMAIL PROTECTED] wrote:
Dear All,
Here we have about 14 Oracle devlopers and some
times they run a
sript which down grade the database performance. I
nicely asked for a script
that a developer has run
Glad to help!
Robert
Author Oracle9i RMAN Backup and Recovery
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 2/26/2003 8:49 AM
Hi Freeman,
Wednesday, February 26, 2003, 2:39:20 PM, you wrote:
FRI This is odd. If you goto $ORACLE_HOME/bin and run ./rman nocatalog,
November 1998. And don't forget Rosanne: it was Juan Loaiza, Rosanne
Toohey, and Bhaskar Himatsingka.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- RMOUG Training Days 2003, Mar 5-6 Denver
- Hotsos Clinic 101, Mar 25-27 London
-Original Message-
Lewis
Jonathan,
I have a copy of the paper in Word.Doc format but it isn't
dated.
However, to quote from it
Most of this material was written
before Oracle7 release 7.3 became available and commonly used. New
functionality in Oracle7 release 7.3 reduces fragmentation issues and
allows different
Required:
DBI
DBD::Oracle
After that, check out http://search.cpan.org/modlist/Database_Interfaces
and see what strikes your fancy.
I've recently installed DBI::Chart along with GD and other supporting
modules to create charts from YappPack data derived from statspack
data. Very nice to have
-Original Message-
I'm dealying with the same RMAN not checking corruption -- on 9.2.0.1
and Solaris. and it's a data warehouse.
I've seen it detect corruption, and not detect it. I think it detects some
kinds, but not all kinds. It seems to do better with finding it in
Their presentation slides are dated Nov 1998. One of slides refers to the paper as
'accompanying paper'. It could be 1998 OOW Conf.
- Kirti
-Original Message-
Sent: Wednesday, February 26, 2003 10:05 AM
To: Multiple recipients of list ORACLE-L
Seems like 1999 around OOW.
--
Jeremiah
I have to agree that it was the most entertaining Oracle presentation I have
ever seen - and yet with lots of good stuff to take with you home from a
guy who knows a lot about Oracle. Please re-consider your decision to move
to Australia, Connor. Come back.
Connor McDonald wrote:
"Connor
I've asked Juan.
Jonathan Lewis wrote:
Does anyone happen to remember when
Juan Loaiza and Bhaskar Himatsingka first
published their paper called:
How to stop defragmenting and start living:
the definitive word on fragmentation.
Thanks
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Coming soon
Always take what you need and leave the rest.
...and don't take any list comments personally.
-Original Message-
Sent: Wednesday, February 26, 2003 11:29 AM
To: Multiple recipients of list ORACLE-L
This worked:
SELECT A.WHSE_CODE,A.ITEM_NUM,B.LAST_COST FROM ITEM_W A,(SELECT DISTINCT
I have that paper, Jonathan, and the second one too.
Would you like a copy?
Ruth
- Original Message -
From:
Jonathan Lewis
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, February 26, 2003 9:53
AM
Subject: History
Does anyone happen to remember
Welcome to my week :)
Rachel Carmichael wrote:
I'm dealying with the same RMAN not checking corruption -- on 9.2.0.1
and Solaris. and it's a data warehouse.
So far I've got 9 corrupted datafiles and over 40 corrupted objects.
fortunately most are indexes.
it's going to be a good
Some to the graph does not appear properly for some reason.
In any case, this may be a bug. Please read MetaLink Document 166924.1
In part it says:
1. Self Deadlocks
It occur when one session tries to get a lock on a resource that he
already has in some way.
Normally, the Oracle
here's the fun part in this:
this is being handled by the hosting company who manages our production
data center.
apparently rman detects corruption on the restore and writes error
messages to the alert log, not the rman log. Except the monitoring
software didn't look for the word corrupt
---
The failed KAIO calls normally happen very quickly and
have little impact on your system. I did run into some buggy
Hitachi/Solaris/Vxfs configuration once that took a very long
time to fail the KAIO calls.
You could always just set disk_asynch_io=false in init.ora.
Jared
[EMAIL
Quote from one of the listers:
With free advice, you get what you paid for it.
If you bite the hand that feeds you,
you may just go hungry the next time you ask for a handout.
NOBODY owes you an answer;
regardless of how dire a situation you find yourself.
HAND!
I will end this message thread
Rachel -
Do you actually have the error text from the alert log?
Looks like I have something to add to my Perl script... :)
Brian
--
| Brian McGraw /* DBA */ Infinity Insurance |
| mailto:[EMAIL PROTECTED] |
In addition to DBI and DBD::Oracle, which allows you to access Oracle
databases directly, we have found MIME::Lite very useful. It allows us to
create and send e-mail messages with attachments and make use of HTML in the
message formatting. With MIME::Lite, your monitoring processes can send you
I confirm, end of 1999.
-Original Message-
Wilton
Sent: Wednesday, February 26, 2003 11:05 AM
To: Multiple recipients of list ORACLE-L
Seems like 1999 around OOW.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Wed, 26 Feb 2003, Jonathan Lewis wrote:
Does anyone happen to
Babu,
Most people assume that the only way to fix something like this is to
improve the per-call latency time. But response time equals number of
calls (N) times the average latency per call (C): R = N x C. Your goal
is to reduce R. Reducing N often provides far superior leverage in
meeting this
Brian,
Can I get a copy of that Perl script once you've added that check?
Rachel
--- Brian McGraw [EMAIL PROTECTED] wrote:
Rachel -
Do you actually have the error text from the alert log?
Looks like I have something to add to my Perl script... :)
Brian
Agree with Jared. However, if you have determined that the synchronous IO
and all that is slowing you down, and you want to proceed to direct IO, and
Qio is what you want, I would suggest that you get Veritas to help you. It
will take about 1 - 2 hours to set up for a 100 GB DB. I have a document
Here you go:
***
Corrupt block relative dba: 0x024a (file 9, block 10)
Bad header found during buffer read
Data in bad block -
type: 32 format: 0 rdba: 0x20202020
last change scn: 0x2020.20202020 seq: 0x20 flg: 0x20
consistency value in tail: 0x20202020
check value in block header:
Ruth,
Thanks for the offer but I have access to the
paper (from OTN) - I was just interested to
get a fairly accurate idea of when it went
public as there was no date on the paper
itself.
Cary,
The paper on OTN carries only the two names -
perhaps you should suggest a correction.
Everyone
Thanks Jared !!
My DB is running on Version 8.1.6.2.0 ( 64 Bit )
I have browsed through the code, I did not find anything specific which can
cause the deadlock , may be a BUG as you mentioned ..
Thanks
Madhu
-Original Message-
Sent: Wednesday, February 26, 2003 12:21 PM
To: Multiple
Hi,
Can I use the program DBV on a production datafile (read and write),
without take offline the tablespace ?
--
Breno A. K. Magnago mailto:[EMAIL PROTECTED]
Mercantil de Alimentos Soares
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Breno A. K.
Hi,
Can I use the program DBV on a production datafile (read and write),
without take offline the tablespace ?
New Info : Windows 2000 Oracle 9.0.1.1.1
--
Breno A. K. Magnago mailto:[EMAIL PROTECTED]
Mercantil de Alimentos Soares
--
Please see the official ORACLE-L FAQ:
Yes, you can. It may report that a block is influx if the block is being
written while dbv is looking at it. If you encounter this error, run it
again. If it does not report the same block, you are in the clear.
As with any i/o intensive process, run it off-hours.
Dan Fink
Breno A. K. Magnago
I have a quick
question..
In a SUN environment,
how would one place the oratab and oraInst.loc files within a directory that
would be self-contained within the $ORACLE_BASE directory tree instead of
/var/opt/oracle
I seem to remember a
method on making that happen...But I have either
The quick and dirty way would be to use soft links.
Or you can change the oracle startup scripts (I think).
Might there be a line like:
ORATAB=/your/favorite/spot
in the startup/shutdown scripts??
-Original Message-
I have a quick question..
In a SUN environment, how would one
Understand that this is all secondhand reporting:
I don't believe maxcorrupt was set. It appears that the backup itself
is fine, that the problem is hardware corruption. The hosting company
DBAs are telling me that 'no errors were written into the RMAN logs'
(this is a direct quote). However
Ferenc
Thanks for the document. I am working with the SAs to try to implement it.
Will update the results once complete..
Thanks a lot...
Babu
What do you mean by the Rman log rachel? Are you talking about the
v$backup_corruption view?
From the Oracle RMAN Reference:
If the server session encounters a datafile block during a backup that has
already been identified as corrupt by the database, then the server session
copies the corrupt
That's the cutest corruption I've ever seen -
it looks like someone has been practising
there C programming with How to write direct
to an Oracle data file without using Oracle
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Coming soon one-day tutorials:
Cost Based Optimisation
Hi,
So my boss comes over this morning and tells me that the users are having a
performance problem with a 3rd party application that have recently began
using. This is an oracle database where they bought the software and had
the system admin install the software which included the vendors
- Original Message -
From:
Loughmiller, Greg
To: Multiple recipients of list ORACLE-L
Sent: Thursday, February 27, 2003 7:00
AM
Subject: Oracle and SUN config
question...
I have a quick
question..
In a SUN
environment, how would one place the
Dan,
That must be new for 9i, since my 8.1.7 docs say it is an offline
utility. I remember hosing an entire 7.3 test database years ago when I
first ran DBV on it while it was up and open - can't remember the errors,
but the DB was unusable. One of the (too) many times I learned to read the
If you have a table partitioned, can you specify the storage size of each
partition in that tables
I looked at dba_tab_partitions and dba_segments views.
Although the show me storage information, I am unable to create a table
where I can specify the storage size for each partition.
Am I doing
Congrats to all of you at Hotsos Cary
Robert
--- Cary Millsap [EMAIL PROTECTED] wrote:
Many of you attended our Hotsos Symposium in Dallas
earlier this month.
You might be interested in an article (below) that
was published in the
Dallas Morning News about a week ago.
Thanks,
Title: ODBC and password expire messages
Hi listers:
In another moment you'll be able to tell I'm not ODBC literate. I can query a UNIX 9i DB using SQL*Plus from my PC using a Oracle9i client, and get ORA-28002: the password will expire within 10 days. The 8i client (to a 9i DB) does not
Sorry, folks - I have to recant.
I was right the first time, oracle can be
expected to waste space across N-1
extents - although it gets put on to
the free list, of course.
Forget all the fancy traces, and the
problems they give - if you have a
16 block extent size, and after the
create table
I keep
a copy close by my side to bring out when a developer is telling
everyone that compressing extents will solve ALL the performance
issues
associated with their code...don't laugh..Its happened several
times...some
guy
going off afterlooking up old information or the web or a book.
Larry,
You're right - I'm out of date.
Oracle 8.1.7.4 (which is what I've been
fiddling with for the last couple of hours)
seems to be doing something a lot smarter
than earlier versions.
I'm still trying to figure out what happens
when - but I'm having a lot of trouble because
the 10046 level
-Original Message-
My tuning skills are still pretty basic. Since I have no
control over the
application is there anything I can do to increase the performance of
running the query thousands of times?
More hardware.
GET MORE HARDWARE!!
--
Please see the
what do you mean by storage size? if you mean the initial, next and so on -
yes you can.
if you are talking about how big it should be - i dont think you can do
it...
Babu
H
grep
http://www.cs.washington.edu/homes/wolman/nt-tools/gnugrep.zip
wchttp://www.cs.washington.edu/homes/wolman/nt-tools/wc.exe
cat
http://www.cs.washington.edu/homes/wolman/nt-tools/cat.exe
mailx (use Blat)http://www.interlog.com/~tcharron/blat.html
You may also
dbv is not crashing my 7.3.4.3.1 instance on hp-ux 10.2 :)
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 26, 2003 1:19 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: DBV
Dan,
That must be new for 9i, since my 8.1.7
I had a scheduled job that ran dbv on Solaris 8.0.4 databases once a week.
Never a problem. It has been awhile since I used it on Windows, and I don't
recall using it on 7.3 (not that I did not, but my memory is starting to
go...). I have never had a problem with it, either with the db up or
YES, here's an example:
create table ate_headers(module_id varchar2(13),
session_number varchar2(16),
test_group number(4),
test_date date,
first_record char(1) default 'F',
Yes you can. Check the storage option of the partition clause.
Something like:
create table (sales_yr varchar2(4),)
partition by range (sales_yr)
(partition p1 values less than ('1996')
tablespace blah_p1
storage (initial 100M next 100M pctincrease 0),
partition p2 values
1 - 100 of 130 matches
Mail list logo