Question for those who have gone before...
Is there a consensus on the best book to use to teach myself SQL tuning
under the cost-based optimiser, particularly the use of hints.
I have lots of experience under the rule-based optimiser, so I need
hard-core info on use of hints and other features,
I personally find the turn the argument is taking rather dispiriting. I have, like
everybody who has been working with Oracle for some time, used BCHR in the past (and
queried X$KCBRBH and its twin, X$KCBCBH). To be honest, I even have had some quite
interesting results - which I would get by ot
Hi gurus
My SQL_TRACE is on for instance. What will happen to trace file if it
reaches MAX_DUMP_FILE_SIZE.
wether it is truncated? or it will start writing into another file?
Is there a way to recognize, which trace file belongs to which session?
Please help me this is urget requirement?
thanks
On Mon, 13 Jan 2003, BanarasiBabu Tippa wrote:
> My SQL_TRACE is on for instance.
For the whole instance? Usually, we only run SQL tracing for one or a
few sessions at a time. Turning it on for the whole instance makes
for a whole lot of tracing and greatly decreased performance. What
are you
Guy Harrison's "Oracle SQL High Performance Tuning" - really good one
You can get it for under 20$ at:
http://www.bookpool.com/.x/aii6z8nb34/sm/0130123811
-Original Message-
Sent: ? 13 ? 2003 11:39
To: Multiple recipients of list ORACLE-L
Question for those who have gone before...
List,
I'm interested to
know the minimum required parameters to startup the
database.
Pls anybody list out
that?
Nirmal.,
my main question is about the file size... Thank you very much...
-Original Message-
Sent: Monday, January 13, 2003 4:49 PM
To: Multiple recipients of list ORACLE-L
On Mon, 13 Jan 2003, BanarasiBabu Tippa wrote:
> My SQL_TRACE is on for instance.
For the whole instance? Usually, we
Need to Do a Comparative analysis of General Characteristics of HOT , COLD , exp ,
RMAN
backups
What additional Headings can be Explored ?
Some Feadings below :-
1) Database Status during backup - UP / Down
2) Time of Backup
3) Restoration effort & time
4) Reovery facility
5) Dependency on
Trade you users, Rachel... we still have one that thinks that silly 1000
column limit is something that I made up to make her life difficult.
April Wells
Oracle DBA
Great spirits have always encountered violent opposition from mediocre minds
-- Albert Einstein
-Original Message-
Sent:
Nirmal - I believe there are four:
db_name
control_file
db_block_size
compatibility
This is from John Hibbard, a great Oracle Education instructor.
But why not try for yourself? Save off your init.ora, then create a new
init.ora with just the above parameters. If Oracle comes up,
Vivek - I believe you are off to a good start. I'm assuming you are
considering the database to be in archivelogmode in all the scenarios.
Also, keep in mind that export is not a valid sole backup method for a
production database. There are many situations that having an export alone
will not en
2 + 2 = 4
Todd
-Original Message-
[EMAIL PROTECTED]
Sent: Friday, January 10, 2003 12:46 PM
To: Multiple recipients of list ORACLE-L
OK, this is a little off topic, but if MicroSlop gets this to work, how
long
before OEM will have a link into the same technology?? I always thought
that
Sorry, I forgot this additional infromation...
Oracle created invalid objects when we ran rebuild. The odd thing was that
the trace file showed an invalid object but the all_objects table showed a
valid object.
-Original Message-
Sent: Monday, January 13, 2003 9:39 AM
To: [EMAIL PROTE
Team,
I have a Oracle 7.3.4 database on a AIX box that is in Archive Log Mode.
While the users were on the system, we Re-Indexed our tables.
Situation: The users complained, that they were unable to process their
orders.
Although, the log file showed that the re-indexing was successful, the users
"compatibility" or "compatible" is not a mandatory init.ora parameter.
I would think that only the first three are required.
Hemant
At 06:08 AM 13-01-03 -0800, you wrote:
Nirmal - I believe there are four:
db_name
control_file
db_block_size
compatibility
This is from John Hibba
To add to your list:
13) Is an additional volume of redo generated, resulting solely from being
in backup mode?
14) Is backup capable of any other purpose, such as checking for corruption
in database blocks and/or archivelog files?
15) Additional hidden costs of integrating with tape subsystem (i.
Title: Internet file system
as per usual, technet website is confusing as heck. I am trying to locate the latest release on IFS. I am on the products website and see the following on the IFS webpage:
Content Management Software Development Kit (CMSDK)
Version 9.0.3
(Note: this rele
List,
I recently tried to set the compatible=8.1.7.0 parameter in a 9iRel2 Solaris
8 database. If you bounce the instance the
sql>show parameter compatible=9.0.0 stays the same, it does not change. If
you shutdown and reboot the server you get an:
ora-01033: Initialization or shutdown in pro
Check out this white paper by Tim Gorman:
http://www.evdbt.com/SearchIntelligenceCBO.doc.
There is (somewhere, don't remember URL) also a white paper by Mark Gurry,
the author of the book you bought. BTW, I think the book is very good.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Me
Conrad - What command did you use to re-index? Drop index / create index?
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, January 13, 2003 8:44 AM
To: Multiple recipients of list ORACLE-L
Sorry, I forgot this additional infromation...
O
Greetings all,
I'm trying to support a COTS application that is back-end agnostic & makes
only minimal use of security on the db. In particular, it requires that
users be granted a default role that has *very* heavy permissions--enough to
do some major mischief should they ever figure out how to
Hemant - I was just going from my hastily written class notes. Sorry about
misspelling the parameter. However, just tried it and 8.1.6 won't start
without the COMPATIBLE parameter set in init.ora.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Mon
David - What are you trying to accomplish?
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, January 13, 2003 8:44 AM
To: Multiple recipients of list ORACLE-L
List,
I recently tried to set the compatible=8.1.7.0 parameter in a 9iRel2 Sola
The only one parameter.. control_files.
Rest are optional.
Best Regards,
K Gopalakrishnan
-Original Message-
WILLIAMS
Sent: Monday, January 13, 2003 7:44 AM
To: Multiple recipients of list ORACLE-L
Hemant - I was just going from my hastily written class notes. Sorry about
misspellin
Hello All
I saw that piece of code a few times and still think that even if you can
bump up the BCHR it has it's place. How can you tell that you need more
space in the buffer pool? Bad BCHR is an indication that you need to check
this. It is also an indication that you do a lot of FTS or missing
Hello Anjo
I just had a tuning session with Dov Hit, from ACS in Israel.
He used some of the scripts that you showed him 2 years ago when you did
some work for Amdocs.
Anyway, after doing some search on the waits, he checked the BCHR and found
out that this database has only 40%. That led us on fu
It seems like I remember misspelling 'control_file' once and discorvering
that even it has a default. Of course with Oracle, it could depend on the
version, O/S, patch level, phase of the moon, etc.
Keith
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
ALTER ...REBUILD..
Thanks
COnrad..
-Original Message-
WILLIAMS
Sent: Monday, January 13, 2003 10:19 AM
To: Multiple recipients of list ORACLE-L
Conrad - What command did you use to re-index? Drop index / create index?
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
Has anyone ever seen a similar message to the following showing up in the
alert log and creating dump/trace files:
Mon Jan 13 09:45:22 2003
found dead shared server 'S000', pid = (9, 13)
Mon Jan 13 10:13:46 2003
Errors in file /u01/app/oracle/admin/ndi/bdump/ndi_s000_3556.trc:
ORA-07445: exception
hi!
a DBA inteds to speed up a script that is looping and
sending hundred thousands of sequential update statements like:
UPDATE ISIS_DOCAR SET STATUS = 2000 WHERE ID = n;
he suggests copying the table to a file, change it and then
load it into the DB again. i am strongly convinced that this
is
Title: RE: 8.1.6: possible to set role in db's logon trigger?
Hi Roy,
Note 122230.1 will answer your first question about session id's.
Lisa Koivu
Oracle Dogbone Administrator
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063
-Original Message---
>We have a new datawarehouse project. I didn't involve in this project at
>beginning. Right now, I was assigned to the group for picking a front
>end reporting tool. So far I know the manager prefer brio, cognos and
>business intelligent product.
>
>Does anyone familiar with those tools? Can you gi
To solve your first problem, correctly identifying the current session from
v$session, in your login trigger include:
client_info_str := 'SOME_LITTERAL_' || LTRIM(dbms_random.value,'.');
DBMS_APPLICATION_INFO.SET_CLIENT_INFO(client_info_str);
Then you can:
SELECT program, user
Well, I just tried it on 8.1.8, and here is what I receive:
SVRMGR> !cat inittest816.ora
control_files = ("/oracle8/oradata/test816/control01.ctl",
"/oracle8/oradata/te)
SVRMGR> startup
ORACLE instance started.
Total System Global Area142688680 bytes
Fixed Size
Daniel - Can you explain the two alternatives in a little more detail,
especially the difference between the two. What types of systems are
involved (Unix, Windows)? Thanks.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, January 13, 2003 1
>hi!
>
>a DBA inteds to speed up a script that is looping
>and
>sending hundred thousands of sequential update
>statements like:
>
>UPDATE ISIS_DOCAR SET STATUS = 2000 WHERE ID = n;
>
>he suggests copying the table to a file, change it
>and then
>load it into the DB again. i am strongly convinced
>
Title: RE: 8.1.6: possible to set role in db's logon trigger?
Roy,
this is in 9202 ... check the custom code for hash joins ... it has been working fine for us for > 2 months ...
CREATE OR REPLACE TRIGGER "SYSTEM".DBT_USERS_LOGON
AFTER LOGON ON DATABASE
--
DECLARE
CURSOR cur_sess IS
SELECT
David - Try COMPATIBLE=8.1.0
See the following link (you may have to patch it back together)
http://www.csis.gvsu.edu/GeneralInfo/Oracle/server.920/a96530/migcompa.htm#1
009871
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, January 13, 200
I am trying to apply a "fix" for some developers here. They used this fix
in 8 and 8i by changing the compatible parameter and running their sql
script. I just want to be able to tell them that they need to fix their
application now that we are using 9iRel2. I tried this morning and got the
ORA-
Conrad - I haven't used 7.3.4 in quite some time, so my knowledge is a
little rusty. If you search METALINK, you will find quite a few issues with
this command on various Oracle versions. I believe that the basic principle
is the same - Oracle builds a new index in the background, syncs up any
tabl
Hi List
Is there a tool for removing duplicate entries from a table - except that
the key field is not the same. I ran some data imports more than once and
was hoping someone could point me in the direction of a way to undo my
mistake.
Any help will be most appreciated
Thanks
Mark Warner
__
"How can you tell that you need more space in the buffer pool?"
...You can notice when this is true by observing summarized extended SQL
trace (event 10046) data. If the LIO count for a session is small, but
the PIO count is large, then you have the problem.
So, sure... Checking a session's BCHR
Title: RE: dw tool question
This is something I am currently dealing with.
We have two products here: Business Objects and BRIO. It depends on what kind of end-user you expect to support. The main difference I see between these two is that Business Objects can easily hide the metadata de
I too think the BCHR has its place, as a problem indicator. It can tell me
theres something wrong with my database. Say, I have this database
performing well, the users are happy, the BHR is mostly at 90%, and now it
suddenly shoots down to 70%, or it suddenly increases to 98. Somethings
amiss. It
The Pocket Reference has been helpful to many people. The book appears
to be at least a handy summary of some relevant aspects of Oracle's
documentation. However, various colleagues have convinced me that there
are many statements in the book that you can disprove using careful
tests.
Cary Mills
Hi,
following metalink documents may help you.
Note:65080.1 Using SQL To Delete Duplicate Rows In A Table
PR:1015631.6 HOW TO SELECT DUPLICATE ROWS WITHOUT USING ROWID
PR:1004425.6 HOW TO FIND OR DELETE DUPLICATE ROWS IN TABLE
Murat
I had a 9.2/solaris database that I could set compatible 8.1.7 on - but
since I have done the 9.2.0.2. upgrade I can't set compatible below 9 either -
never really needed it so I haven't bothered with metalink/tar.
>>> [EMAIL PROTECTED] 01/13/03 11:16AM >>>I
am trying to apply a "fix" for som
Andrey,
Perhaps you could tell us what paper, and where to obtain it.
>From the context, it sounds like a reference to physical modifications
rather than DML.
Jared
On Monday 13 January 2003 07:54, Andrey Bronfin wrote:
> Dear gurus !
> A ( maybe ) stupid question : I always thought that bitma
Though I'm not sure, I *believe* that in 7.3 indexes must
be taken offline during a rebuild.
That being the case, your users queries would not have
executed properly. i.e. FTS would take place for queries
that normally used indexed access.
Jared
On Monday 13 January 2003 08:14, Conrad Meertin
On Monday 13 January 2003 06:03, Tim Gorman wrote:
> Another question: should SQL BackTrack be included for consideration?
What does SQL BackTrack to that RMAN doesn't do?
Jared
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat
In a nutshell, it is better to put your code
in a stored procedure outside of the trigger.
Why? Modular code is easier to reuse. You can't
reuse code blocks that are in a trigger. There are
other reasons, but this is the biggy IMO.
As Ferenc recommended, get the Feurstein book.
Jared
On Su
Have you used parallel clause while rebuilding? What version of 7.3.4 ?
Check alert_SID.log for any possible index corruption
If any , then you have to check for table and all indexes on that. Find
index/es with multiple keys , save their defination through export , drop
those indexes and cr
So, if I coerce the developers into writing better code that
does less logical IO, and the BCHR goes down, I should
then investigate and fix the problem? ;)
Jared
On Monday 13 January 2003 08:09, Yechiel Adar wrote:
> Hello All
>
> I saw that piece of code a few times and still think that even
You need to create the database with compatible set
to 8.1.7.0. You can't create a database at one version
and then lower the compatible level without downgrading
or recreating.
Jared
On Monday 13 January 2003 09:16, Ehresmann, David wrote:
> I am trying to apply a "fix" for some developers he
Daniel,
Your gut reaction is right on-target. It is always a struggle to keep
certain folks from killing the entire village while trying to cure a single
case of the sniffles. What's worse is that such folks are usually quite
bright and talented. After, very few mediocre folks can either cure t
Even with this little bit of information, it's obvious your DBA
is on the right track.
Any script that loops and executes 'hundred thousands of
sequential update statements' is total nonsense.
This will bring most any database to it's knees in a hurry.
Oh yes, I've had developers pull this one
Woah--free code! A thousand thanks--this looks really close to what I'd
like to do. If I can wrestle some extra privs on our test db I'll report
back as to whether I was able to get this going on 8.1.6.
Thanks also to Lisa & Thomas for responding.
Cheers,
-Roy
Roy Pardee
Programmer/Analyst
SW
:)
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Steve Adams's Miracle Master Class, Jan 13-15 Copenhagen
- 2003 Hotsos Symposium, Feb 9-12 Dallas
-Original Message-
Still
Sent: Monday, January 13, 2003 11:45 AM
To: Multiple recipients of list ORACLE-L
Title: RE: compatible in 9iRel2
Curious minds want to know what bugs you are trying to fix ??
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't re
Were you using any of the new tablespace
features or using dictionary managed tablespaces?
David Ehresmann
-Original Message-From: John Shaw
[mailto:[EMAIL PROTECTED]]Sent: Monday, January 13,
2003 11:41 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: compatible in 9i
We are running 9.2.0.1., do you think that
could be the reason. the .1=component specifiec Release
Number? Was your 9i 9.2.0.0.0?
David Ehresmann.
-Original Message-From: John Shaw
[mailto:[EMAIL PROTECTED]]Sent: Monday, January 13,
2003 11:41 AMTo: Multiple recipients of
List,
We use the following script to identify recent full table scans or full index scans.
This result set will be used to identify the potential queries that could benefit by
creating any new indexes or modify the existing index structure as needed.
Our intention is to run this query against
Has anyone else seen this or can you explain
it?
I have 7 tablespaces in USER_TABLESPACES that don't
exist in DBA_TABLESPACES. These have been dropped, but somehow did not disappear
from USER_TABLESPACES. They have a status of INVALID.
The database is version 8.0.5 (Yeah, I know, we'll
b
system is data
dictionary - the rest lmt's with uniform extents>>>
[EMAIL PROTECTED] 01/13/03 12:35PM >>>
Were you using any of the new tablespace
features or using dictionary managed tablespaces?
David Ehresmann
-Original Message-From: John Shaw
[mailto:[EMAIL PROTECTED]]Sent: M
Title: RE: How to identify full table scans?
Govind,
Just curious why you are attacking the full table scans. I implemented something like this in the past utilizing Steve Adams' script expensive_sql.sql. It was very telling and very very useful.
Lisa Koivu
Oracle Database Administrator
I was curious about this parameter
I have an application that is certified on
8.1.7 only
Could I create a 9i database set compatible
to 8.1.7 and essentially call it an 8.1.7 database?
-Original Message-
From: Ehresmann, David
[mailto:[EMAIL PROTECTED]]
Sent: Monday, January
> Keith Moore wrote:
>
> Has anyone else seen this or can you explain it?
>
> I have 7 tablespaces in USER_TABLESPACES that don't exist in
> DBA_TABLESPACES. These have been dropped, but somehow did not
> disappear from USER_TABLESPACES. They have a status of INVALID.
>
> The database is version
Dennis,
Here/ in this senario '
'ANALYZE INDEX VALIDATE STRUCTURE' will not help or reveal anything except
to anlyze table with cascade structure which will reveal any index
corruption relating to that table. There was a bug in 7.3.4.3 where index
rebuilding with parallel clause was resulting i
Daniel,
After some of the younger folks in the audience have had a say, Let's let
the "old fart" have one.
While on the one hand I can see what your DBA is croaking on, I can also see
where you are too. Your approach is easy to code, but can wreck hell on the
database especially if each
Title: ioug.org web site
Is anybody else having trouble with the www.ioug.org
web site. I can get to the home page, but cannot
log in, or register for IOUG-A Live.
Is it just me?
Matt Adams - GE Appliances - [EMAIL PROTECTED]
My computer beat me at chess, but I won
when it came to ki
Hello:
I have a third party application which seems to have alot of unbound SQL
statements, several of which do not seem to be very effective queries.
Unfortunatelly the code is locked.
My Parse to execute ratio is around 72% and I was wondering if anyone has
any ideas on how I can decrease t
Hi:
Today I did some small testing on our db (Oracle 8173 on Solaris 2.8) to
test index rebuild (with nologging) performance vs sort_area_size. I used
"alter session set sort_area_size = " to set the sort_area_size value.
Nothing else was changed. The temp tablespace is 8G. There is no other
a
I wasn't. I actually am still trying to look at the varchar2. The downside
is the huge amount of data they want to keep in a compressed format hence
the RAW or BLOB format.
Regards,
Bill Burke
"The Kinder and Gentler DBA"
IOUG University Master Class Faculty 2001-2002
"iDBA Management, High Per
Thanks Rafiq. As I said, my 7.3.4 knowledge is too old by now (but man, was
that a great version).
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, January 13, 2003 1:22 PM
To: Multiple recipients of list ORACLE-L
Dennis,
Here/ in this s
David - No. This just ensures you don't use any "9i" only features.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, January 13, 2003 1:22 PM
To: Multiple recipients of list ORACLE-L
I was curious about this parameter
I have an appli
Success with using CURSOR_SHARING depends on your Oracle version.
In earlier versions it's buggy.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, January 13, 2003 3:00 PM
> Hello:
>
> I have a thi
I don't know if it's just you, but I'm ok. I just logged in and went to
the Live 2003 page without any problem.
Check with your network folks.
Stephen
>>> [EMAIL PROTECTED] 01/13/03 12:49PM >>>
Is anybody else having trouble with the www.ioug.org
web site. I can get to the home page, but ca
Jay - Here are the possibilities:
1. The vendor is stupid. Or doesn't understand Oracle.
2. The product was incorrectly installed. Some products are sophisticated
enough to have a configurable interface, which may be misconfigured or need
tuning over time.
3. You are missing a key piece o
Yes, it is as of today...We are still having 7.3.4.5 for our Oracle
Financials 10.7 Application. This may be the last year for this version...
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Mon, 13 Jan 2003 12:38:39 -0800
Tha
Don't know really. Just thought that it should probably be included, then I
was hoping to find out... :-)
- Original Message -
To: <[EMAIL PROTECTED]>; "Tim Gorman" <[EMAIL PROTECTED]>
Sent: Monday, January 13, 2003 10:49 AM
> On Monday 13 January 2003 06:03, Tim Gorman wrote:
> > Anot
Mark,
About how many rows are we talking about? Just curious...
Log Miner might be a viable option. It comes with 8i but if the database in
question is v8.0.x then you can still read them from an 8i database. From
Log Miner you can extract the UNDO_SQL for the rows you want to delete.
If you
We have not seen any performance gains after setting the sort_area_size in excess of
50Mb. We have set this as a
standard in our re-indexing scripts to set this to 50Mb maximum.
HTH.
-Original Message-
Sent: Monday, January 13, 2003 3:00 PM
To: Multiple recipients of list ORACLE-L
Hi:
Hi Matt,
I registered last week without a problem, except they insisted on a credit
card number even tho I owed $0. Looking forward to seeing you again!
Ruth Gramolini
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, January 13, 2003 2:49 PM
My colleagues call it CURSER_SHARING :)))
"Igor Neyman"
Bill - Will you need to search for information that will be compressed? If
yes, then performance could be really, really bad.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, January 13, 2003 2:07 PM
To: Multiple recipients of list ORACLE-L
Title: RE: How to identify full table scans?
This
helps to identify the queries that could be tuned for LIO and/or PIO from a
SQL Tuning perspective. We can give this list to the development or
application teams so that they could independently work off this list
(hopefully!).
-Origi
Is SQL BackTrack a product like RMAN (from Oracle Corp. or 3rd party )?
-Original Message-
Sent: Tuesday, January 14, 2003 2:09 AM
To: Multiple recipients of list ORACLE-L
Don't know really. Just thought that it should probably be included, then I
was hoping to find out... :-)
rdist is a good way to keep files (sql, tools, tnsnames) synchronized
between servers, in my case I need to replicate
/db01/foo/* to /u01/foo/*
Going from /db01/foo to /db01/foo on a different server is easy but I can
not find any examples of going to another directory structure. The docs are
n
I *think* that RMAN does everything SQL Backtrack does.
Can't be positive, as I haven't used it for awhile.
RMAN seems to have everything I recall SQL BT having, and then some.
Jared
On Monday 13 January 2003 12:38, Tim Gorman wrote:
> Don't know really. Just thought that it should probably
Curious, for which platform is 8.1.8 available? And *why*?
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
> -Original Message-
> From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
> Sent: Mond
We're upgrading from Solaris 2.6 to Solaris 8 and 8.1.6 to 8.1.7 on one of
our boxes.
I want to know if it's possible to do the OS upgrade first and then the
database upgrade (e.g., I'd be running 8.1.6 on Solaris 8 for a day or so).
The Oracle certification matrix only says that 8.1.6 is desuppo
I spoke with Matt and he is able to register / log in. As it usually
happens, he got it working right after he sent the email.
Take care,
-Ari Kaplan
-Original Message-
Andert
Sent: Monday, January 13, 2003 3:29 PM
To: Multiple recipients of list ORACLE-L
I don't know if it's just you,
The increase in performance of course comes from
sorting in memory and avoiding disk writes.
Try running this bit of SQL before and after your tests,
and record the numbers:
select
stat.sid,
name.name name,
stat.value
from v$sesstat stat, v$statname name, v$session sess
where
stat.si
1) Large Export Dumps , if Directly Exported to TAPE Devices , Can Import be safely
Done therefrom ?
FILE=
OR is it advisable to compress / Split the Export Dump Files onto Storage Box &
thereafter backup the Same onto Tape ?
2) With Oracle 8i & 9i
Does export backup fired at a certain Ti
Jay,
Take a look into using stored outlines. If the problem is with the vendor's
code not using bind variables, I don't know that this will help, but you may
find some instances where it might be useful.
I heard recently that a book should be written with just one chapter on bind
variables.C
In fact, in 8.1.7.2, it can cause *incorrect* results in certain queries
without reporting an error! 8.1.7.4 is supposed to be a little more stable
(applying that minipack to production as this is typed), and 9iR2 is
reported to be even better.
For us, it was CS=F or die (dead server, die trying
Does anyone have some perl code that will return an error if it take longer
than a certain number of seconds to connect to or return the results from a
database? I'd like to have some of my queries connect to an alternate database
if there is a problem connecting or returning results within 10 seco
And of course to calculate you'll need to know your block size and your
extent size.
-Original Message-
Sent: Saturday, January 11, 2003 10:34 AM
To: Multiple recipients of list ORACLE-L
UNIFORM SIZE clause of Tablespace, if it is LMT.
--- Igor Neyman <[EMAIL PROTECTED]> wrote:
> INITIA
CURSOR_SHARING won't reduce the "parse count (total)" count; only
eliminating parse calls from your application can do that. Using
CURSOR_SHARING will reduce the "parse count (hard)" count (and maybe
some shared pool latch contention), but at the expense of more user-mode
CPU consumed during each p
1 - 100 of 125 matches
Mail list logo