Why 8.1.6.3 ? Go to 8.1.7.2 or 8.1.7.3. 8.1.6 has been desupported.
What is the OS version ? Solaris 2.5.1 ?
32-bit 8.1.7 is certified on 2.6 and above.
64-bit 8.1.7 is on Solaris 8 (2.8) of course.
That you have a Cluster -- is it OPS or single-instance database which
fails
over to the
Your date format should match the tns_date_format
in the machine that the export is run.
Maybe you could use also to_date().
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
-Original Message-
From: Seema Singh [SMTP:[EMAIL PROTECTED]]
Sent: Thu, March 07, 2002 2:24 AM
To:
Hello Mark
We did conversion from 7.3.4 to 8.1.6 with no problems on NT,
with smaller DB's.
Since the upgrade is mostly updates to the data dictionary
I do not think that the size of the data matters.
TAKE COLD BACKUP before the conversion.
Yechiel Adar, Mehish Computer Services
[EMAIL
Hi
I want to know how to how to use dbms_stats. package and get the statistics
This communication contains information, which is confidential and may also
be privileged. It is for the exclusive use of the intended
- Original Message -
From: [EMAIL PROTECTED]
I want to know how to how to use dbms_stats.
package and get the statistics
short answer:
begin
dbms_stats.gather_schema_stats(ownname = '',cascade=true); end;
for a detailed explanation take a look at
Hi
We have to go to 8.1.6.3 'cause we're using a case tool be CA (Computer
Associates) and that's the Oracle version they support.
In our cluster environment, we're not using OPS but a single instance which
fails over a second node.
Our first ideas (which are not acceptable) were import/export
Hi Gurus!
if any function which returns the collection
type , to show that collection object in tabular format we use "the"
operator with dual table which has one row and one column like
followings:
select * from the
(select cast( function name
l(parameters ) as return obeject type )
from
Bill,
In general terms, I would say that it is certainly suitable. That answer
is based upon the information you provide below. The real answer could
only be ascertained by evaluating other requirements:
A) Availability
B) Scalability
C) 'Cost' of each user - what do the transactions look like
Is there a query I can run to find out which PL/SQL packages are wrapped and
which are not?
Oracle 8.1.7
John
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Dunn
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San
It isn't an elegant solution but You can just look into source
Something like
SELECT
owner
,type
,name
FROM all_source
WHERE line = 1
AND upper(text) like '%WRAPPED%'
ORDER BY
owner
,type
,name;
Gints Plivna
IT Sistçmas, Meríeïa 13,
and this one doesn't really conflict with anything I want to see.
gotta get there early to get a seat in the front row so I can heckle
better :)
--- Joe Testa [EMAIL PROTECTED] wrote:
yeppers i'll be there and (he crosses his fingers) if all goes well
in
our testing(Susan and I) for the
Interesting, I wonder if this is 4000 bytes then for 9i and the
manual was not updated? I will ask about this.
So, this implies that my original answer would be b or c (depending
on 9i behavior). This is what I understood Oracle to be telling me.
RF
Robert G. Freeman - Oracle8i OCP
Oracle DBA
patch set number?
--- K Gopalakrishnan [EMAIL PROTECTED] wrote:
Jonathan,
Some intelligent person at MD forgot to add the tkprof (Trace Kernel
PROFile)
with the NT versions. OWS has a patch for that.
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Title: RE: IOUG : Was: PocketDBA
I'll be there (and presenting) again.
Matt Adams - GE Appliances - [EMAIL PROTECTED]
Another month has ended.
All goals met
All customers satisfied
All staff ready and enthusiastic
All pigs fed and ready to fly
-Original Message-
From: John
I will be at IOUG-A. Will be presenting Oracle Urban Legends on Tuesday
afternoon. I'd love to meet any of you folks that will be there.
RF
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette Smoking Man: Anyone who can appease a
I see a list get-together forming..
--- Stephane Faroult [EMAIL PROTECTED] wrote:
John Kanagaraj wrote:
Hi Ari,
I'll be at IOUG (and NYOUG and others) so please stop by to
say hello. I
now have a reputation for buying beer too, but I love meeting
new people and
Thanks for finding this I had searched high and low and somehow missed
this reference.
This doesn't quite jive with what Oracle has told me, so I'm following up
for more detail from them.
RF
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The
Thanks All for help!
I did not switch logfile after end backup statment.
Now everything working.
Thanks.
Greg.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Greg Faktor
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San
OK. Everyone. My 2 cents now. I am the Focus Area Manager for the DBA
Track at IOUG-A Live. Please encourage damangement (Gaja Terminology) to
facilitate your attendance at this great event. Please remember that if you
are a member of a local or regional user group, you receive a significant
How about a seat near the power outlets ?? Then, it will be a fun experiment
for Joe Susan ;)
I will be doing my first ever presentation at IOUG-A.. Just a Quick Tips
(Q31) - Wait Events in a Nutshell.. (bring your lunch with you, if they
allow it :) All Quick Tips Sessions are during lunch
Hi
The assumption is that every user of this system will have totally unique
requirements. There will be no data sharing and no commonality of purpose.
As far as alternatives I am not even thinking about multiple instances.
Other alternatives include - many schemas and one tablespace, or many
Hello Rachel,
I can't imagine IOUG-A without Marlene.
Like Milk without cookies snow without cold
RF
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take
HI list!
I want to lock a table on row level ( not
table level). how do we pass the pass that value in syntax which will lock
only those rows. plz make me understand by giving an example.
thanx in advance..
Shishir Kumar MishraAgni Software (P)
Ltd.,Bangalore-560055, Indiawww.agnisoft.com
Hi All,
I'm testing and planning implemetation of oracle names and would like some
advice/pointers/gotcha's to put into my plan for damagement.
Main reason:
Ease of maintenance (We now have tnsnames file all over the place)
Planned setup:
Two names servers both in physically seperated
Hi All,
From my names.log file I have the following error (?)
Where does it come from (Where did I mess up my configuration)
NNO-00807: Error: OCI_NO_DATA
NNO-00267: warning: configuration database contains no data for server
[root]
NNO-00315:
Gotta go see that!!
Live demo's. always fun!
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.
-Original Message-
Sent:
Title: Message
I'm looking for a
solution to attach to a database and create a visual representation of the
tables, columns and foreign keys. I'd prefer something that's free or try
to buy - anyone have any suggestions? (I tried something from download.com
called O-Schema, but it locks up
Jonathan:
Not at all related, but I could not help but think of my favorite
recommendation from Metalink.
As a workaround to a problem:
Workaround
~~
The best workaround is to prevent your database from getting into
this state
where it cannot be opened.
Joe,
You sly dog you! We've been trying to talk our manufacturing folks into
using a standby database as a fault tolerant solution. Of course like always
around here they want a proof of concept I was a little baffles at how to do
it. Your presentation environment popped on the light
We use Netbackup along with an STK 9710. The reason I mention this is that
with applications that have many tablespaces such as Oracle Financials the
backups take much longer regardless of the total size of the database. Each
datafile is considered a separate backup and takes a couple of
I am trying to connect from my 7.3.3 SQL*NET desktop to a new 8.1.7 database
on Unix. I am getting an ORA-03106 TWO TASK error. I can connect to any of
our 8.1.6 servers. Why is 8.1.7 different? Did I set up something wrong?
Ron
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
HI,
When we try to apply patch 9.0.1.2.0 on 9.0.1.1.1 oracle we got error:
There are no patches that need to be applied from patch set Oracle9i Patch
set 9.0.1.2.0.
Earlier we are able to apply the same patch on other machine.
What might be the possible reason for this error?
Thanks
I use one catalog for all my databases. You have to have a catalog in a
separate database if you are going to backup the catalog database using rman
but that is the only time I have ever heard of using more than one catalog.
I must say, most of the Oracle support analysts, at least, don't
I want to display V$SYSSTAT row values in columns. The current query:
-
select to_char(trunc(86400*(sysdate-to_date(
'01/01/70','mm/dd/rr hh24:mi:ss',
'stat38:stat39:stat40:stat41:stat44:stat105:'||
Shishir,
When
you make the select statement at the end add the clause FOR
UPDATE
SELECT
FIELD1, FIELD2 FROM TABLE
WHERE
FIELD1
= 40
FOR UPDATE
Luck,
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of ShishirSent: Thursday,
07 March, 2002
I asked the LIST to respond to the PROs and CONs of different RMAN catalog
configuration options - Below is the summary of the discussion.
By getting a good picture of the different configuration options and what
their PRO's and CON's are - I will be able to choose the best setup for my
It works great unless client connections use JDBC thin. There is a bug
that causes them to appear hung due to unacceptable SLOOO response.
Supposedly the bug was fixed in 8.1.5.2 8.1.6.3, but we still
experienced problems as of 8.1.7.0. Haven't tested this under 8.1.7.2
or 8.1.7.3.
We are testing Fine-Grained Access Control to export the complete schema
excluding some tables.
This works well for export but during import it try to import all tables.
Is there any way we can restrict import of some tables using Fine-Grained
Access Control
.We are using function as specified
I'm using CASEstudio.
http://www.casestudio.com/rksoft/download/rkscase2.zip
Cool soft, but it runs only on windows :-(
JP
On Thu 7. March 2002 16:03, you wrote:
I'm looking for a solution to attach to a database and create a visual
representation of the tables, columns and foreign keys.
Title: Message
Sent 2 hrs ago
- didn't get it yet, resending.
I'm looking for a solution to attach to a
database and create a visual representation of the tables, columns and foreign
keys. I'd prefer something that's free or try to buy - anyone have any
suggestions? (I tried something from
Does your tnsnames.ora have SID or SERVICE_NAME for CONNECT_DATA? It
should be SERVICE_NAME.
Peter Barnett wrote:
We are attempting to install SQLNet in a failover
configuration. The environment consists of two AIX
servers with version 4.3.3 OS, Oracle 8.1.7.2 on both
servers. These
Hi,
I was wondering why Oracle force minextents for rollback
segments to be two. Why can't we have minextents zero or
no minextents clause at all.
We can surely set initial extent to be large enough ourselves
and next extent sized accordingly.
Can someone enlighten me on the reason/thought
Hi Shishir,
This is oracle's default behaviour. As you update , insert or delete a row
oracle places a lock at the row level.
John HOugh
[EMAIL PROTECTED] wrote:
HI list!
I want to lock a table on row level
( not table level). how do we pass the pass that value in syntax which
I will share one example of where a lot of small datafiles come in handy. I
have a script that clones a database. Basically you supply a list of
volumes on the target server that are available for datafiles and it will
cycle through and decide where there is enough room for the file. If you
HI,
We have some history tables that are pointing to parent tables.
Parent tables has primary key.
Our developers are saying that we have foreign key from history table to
parent table and we don't need primary key on history table.
Does there are any benefits if we have primary
[EMAIL PROTECTED] wrote:
Gotta go see that!!
Live demo's. always fun!
copies, i need copies. how the heck can i learn if i work for a
bankrupt company that can't afford to either send me, or let me go to it
because for how few people are left.;-)
--
--
Bill Shrek Thater
The software inventory and the software itself do not
match up - if the software was copied from another
machine or subsequently moved, then this may happen.
hth
connor
--- Harvinder Singh [EMAIL PROTECTED]
wrote: HI,
When we try to apply patch 9.0.1.2.0 on 9.0.1.1.1
oracle we got error:
Since
there are so many options of Oracle that can be loaded when installing, maybe
there was nothing in the patch for the options that you loaded.
It
could be just what it is saying ... that nothing that you have loaded
has had a fix with this patch.
-Original
Please
correct me if I am wrong, but wouldn't you want
to use the following...
FOR
UPDATE NOWAIT
if the
row is being updated/locked,you can report that to the user, and re-query
the data to ensure they still want to update it. Otherwise, with just FOR
UPDATE, the first update gets
will that presentation and indeed other Quick Tips be out on the net at
some point in the future.
Regards
Lee
-Original Message-
Sent: 07 March 2002 14:13
To: Multiple recipients of list ORACLE-L
How about a seat near the power outlets ?? Then, it will be a fun experiment
for Joe
You can have a PK for your history table(like a sequence number) and add the
PK from another table as normal column for this history table.
There is no need for and Relationship to the history table.
-Original Message-
Sent: Thursday, March 07, 2002 9:13 AM
To: Multiple recipients of
Jack:
It appears that the names server is up and running. Try this:
1. Invoke the namesctl utility from a dos prompt.
2. Type services (I think) to see what service names are processed.
3. Type status to see the status of the names server.
Thank You
Stephen P. Karniotis
Technical Alliance
It is
my understanding that Shishir is SELECTing a record, viewing it, making a change
to thedataand then updating it. Normally, another user can
slip in and update the row, so he wants to make sure that no one else
does.
For
example, in a hotelroom reservation system, you would prompt
I know this has been mentioned on the list before, but for my sanity check, will this
Hot Backup Method work?
1) Alter system archive log current ; not really needed but can't hurt.
2) Check backup status.
3) Generate datafile listing to be used by step 5.
4) Alter tablespace tablespace_name
The the() operator, which changed to the table()
operator in 8.1 takes a single value that has to be
a nested table or varray as its operand.
What you are casting is the single row and single
column that you select from dual, but that single
item is the result of casting a result set into
a
Tracy,
For most applications I see no reason to use MTS, BUT there are a couple of
locations where I do use MTS on 8.1.7 and have had few if any problems. It is
actually a fair performer provided that you set the max_servers parameter rather
generously. In total I find that MTS has one
I would swap 7) and 8): backup control file then alter system archive log
current.
You also didn't mention step 9: copy archived logs onto backup destination
media.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
I will put some comments inline:
HTH,
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, March 07, 2002 11:03 AM
I asked the LIST to respond to the PROs and CONs of different RMAN catalog
configuration options - Below is the summary
Jared: The benefit is isolation. As much as possible keep the users from
affecting each other. Performance effects are unavoidable but separate
tablespaces would keep one user from gobbling up all the available
disk space. Will definitely have to watch out for the data dictionary
filling up
It will be at the IOUG web site...
If not already there yet, just like all other presentations.
- Kirti
-Original Message-
Sent: Thursday, March 07, 2002 11:19 AM
To: Multiple recipients of list ORACLE-L
will that presentation and indeed other Quick Tips be out on the net at
some
Sorry about being vague about what I am trying to do, I will try to explain
it better.
We are implementing a GIS system called Arc/Info, thats allows us to
store,manipulate spatially
referenced data, one of the layers of information is orthophoto's, these
are rectified aerial
photographs that
Step 7 8 has always generated difference of opinions :-). And you are right, I
forgot to mention step 9. Archives are backed up to tape 4x day (10gb/day). Thanks!
Gene
[EMAIL PROTECTED] 03/07/02 01:21PM
I would swap 7) and 8): backup control file then alter system archive log
current.
I understand the need for isolation.
Sounds like a problem with social skills. :-)
This could be symptomatic of TOO much contact with duhvelopers and
damagement. ;-)
-Original Message-
Sent: Thursday, March 07, 2002 11:09 AM
To: Multiple recipients of list ORACLE-L
Importance: High
Thanks for the summary. I prefer option 3. One advantage I see is upgrade migrations
of databases. For example:
1) You have many 8.1.7 databases that need to be upgraded.
2) You have 1 rman db for 8.1.7 and a sep. schema for each db.
3) You create a new rman db for 9.0.1.
4) As you upgrade
One other thought is that RMAN doesn't back up oracle passwd files, init.ora file,
oracle home files, etc. Also, RMAN does not back up redo logs.
[EMAIL PROTECTED] 03/07/02 01:03PM
I will put some comments inline:
HTH,
Ruth
- Original Message -
To: Multiple recipients of list
Kirti,
what's the IOUG web address ?
thanks
Santi
-Original Message-
Sent: Thursday, March 07, 2002 10:35 AM
To: Multiple recipients of list ORACLE-L
It will be at the IOUG web site...
If not already there yet, just like all other presentations.
- Kirti
-Original Message-
Get rid of select from dual! Hah, the next thing you will suggest is that we
convert to the metric system!
Marge: Now, I know you haven't liked some of my past suggestions, like
switching to the metric system --
Abe: The metric system is the tool of the devil! My car gets forty rods to
the
I work in a dev shop - most of the sql is canned and pretty basic. We've
been running CBO in all of our dev environments, but we have a few long txns
that just take forever. At the request of some savvy developers, I turned
on RBO, and it brought down execution times dramatically.
I've been
What is the discount? I saw only $85 discount for IOUG membership.
Alex Hillman
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Karniotis,
Stephen
Sent: Thursday, March 07, 2002 9:18 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Now:
Here is what worked for me this morning.
+ sqlplus -s
+ 0
sys/syss
set pause off feedback off pages 0 echo off
spool CCC_begin_hot_backups.sql
SELECT 'ALTER TABLESPACE ' || TABLESPACE_NAME || ' BEGIN BACKUP;'
FROM DBA_TABLESPACES;
SPOOL OFF
@CCC_begin_hot_backups.sql
EXIT
ALTER TABLESPACE
Everyone:
The address for the IOUG web site is www.ioug.org. The Conference site is
www.ioug.org/live2002.
Thank You
Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email: [EMAIL PROTECTED]
Web:www.compuware.com
How much have you played with Oracle Hints???
-Joe
--- Magaliff, Bill [EMAIL PROTECTED] wrote:
I work in a dev shop - most of the sql is canned and pretty basic.
We've
been running CBO in all of our dev environments, but we have a few
long txns
that just take forever. At the request of
I should have noticed you were using long raws. I would definitely move to BLOBS if
your system supports it. The lob segment should be in a different tablespace than the
data segment. This also allows you to name the lob segment which is quite useful.
I would suggest a 4MB uniform extent
It's the way of the future -
From 8.1.7.2 (or maybe 3) PL/SQL at the
server no longer does
select sysdate from dual;
when your code reads:
m_date_var := sysdate;
One down, six to go.
Anyway, why do we need DUAL when we have X$DUAL
which does take up any space or latching ?
Jonathan
Bill - Are you saying that you switched to RBO for everything? I thought the
better procedure would be to remain CBO and put hints into individual SQL
queries. Is this a possibility in your environment? You mention that you are
a development shop. Does this mean that you create software and sell
not much - desire is to keep sql ANSI compliant due to cross-platform issues
(want to be able to run the app on multiple db's)
-Original Message-
Sent: Thu, March 07, 2002 2:44 PM
To: Multiple recipients of list ORACLE-L
How much have you played with Oracle Hints???
-Joe
---
I believe someone else had asked this question before, but I did not see a
reply. Does anyone know the number of transaction slots in the rollback
segment header for block sizes of 4k, 8k, et all?
From what I have read, for a block size of 2K, its 21 transaction slots.
(Steve Adams at
Is your setting for db_file_multiblock_count too high? What's the optimizer
mode? Have you set any of the optimizer_index_ parameters in the
initialization file? These parameters might be driving Oracle to prefer a
full table scan over a index scan.
My 1.2 cents (after NY Taxes).
Raj
Interesting point . . . but the flip side of your argument is that by
putting hints in we, as the vendor, while not requiring you to use CBO
(since RBO will just ignore the hints) are saying, 'Hey, you had BETTER use
CBO if you want this thing to work the way we've designed it'
interesting to
have you tried adjusting optimzer_index_caching and
optimizer_index_cost_adj?
-Original Message-
Sent: Thursday, March 07, 2002 1:23 PM
To: Multiple recipients of list ORACLE-L
I work in a dev shop - most of the sql is canned and pretty basic. We've
been running CBO in all of our dev
So, do you think I'm making a mountain out of a molehill over the
PL/SQL %type stuff...?
RF
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.
The transaction slots are visible as KTUXESLT in X$KTUXE.
You can get them using this SQL..
select count(*) ktuxeslt from X$ktuxe group by ktuxeusn;
For a complete value you can get the slot size form V$TYPE_SZIE
and do a simple math.. Let me know if you can't. I will do that
for you
Best
To give credit where credit is due, this came from my friend
K Gopalakrishnan...
The transaction slots are visible as KTUXESLT in X$KTUXE. We can get the
number of transaction slots in the rollback segments by
select count(*) ktuxeslt from X$ktuxe group by ktuxeusn;
The # of transaction
Well, since hints are implemented within comments, I would assume that other
databases would simply ignore them. If anyone has direct experience, that
would be interesting. Being completely database-agnostic may play against
tuning.
Just a thought. I suppose you analyzed all tables when
It depends ... to quote my SA, 'You can never be paranoid enough about
security ... but you need to know when to stop and have a life.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion
Is my V$SESSION_LONGOPS view broken?
Check out the curious results below. Notice the changing SID-serial# and how
elapsed seconds gyrates. None of the below sessions are in V$SESSION. The
sql address and hash is not extant in V$SQL, V$SQLAREA, etc. (Note, we are
using PQO with timed
Rajesh,
The transaction slots are clearly visible in the Undo Header dumps. I
think this takes some 40 bytes space in the undo header block and this
limits the number of ***concurrent** transactions for that undo segment.
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original
Basically the total ITL size can't be bigger than 50 percent of the
available space for data for the block size. ((db_block_size - ovh) /2) /
itl size
Anjo.
[EMAIL PROTECTED] wrote:
I believe someone else had asked this question before, but I did not see a
reply. Does anyone know the
Tim Gorman wrote a good paper about using these parameters:
http://www.evdbt.com/SearchIntelligenceCBO.doc
Shaw John-P55297 wrote:
have you tried adjusting optimzer_index_caching and
optimizer_index_cost_adj?
-Original Message-
Sent: Thursday, March 07, 2002 1:23 PM
To:
No it is not broken, unless someone explicitly updates underlying
information it is not visible I monitor this when I am creating or
rebuilding indexes to importing ... at that time Oracle will populate
relevant fields, and that is really useful.
Raj
Hi all,
has anyone written a clean script to perform compiles in the order of
dependency in 9i db? Due to java objects if I join public_dependency and
dba_objects, it fails with ORA-01436: CONNECT BY loop in user data error.
When I write following script, it takes ages how do I tune this
always analyze - it's step 1 in any tuning I attempt
usually use compute, but if estimate it's at least 15 or 20%
-Original Message-
Sent: Thu, March 07, 2002 3:19 PM
To: Multiple recipients of list ORACLE-L
Well, since hints are implemented within comments, I would assume that other
Orr, Steve wrote:
I want to display V$SYSSTAT row values in columns. The current query:
-
select to_char(trunc(86400*(sysdate-to_date(
'01/01/70','mm/dd/rr hh24:mi:ss',
just changed index_cost_adj from 100 to 1
what is index_caching?
-Original Message-
Sent: Thu, March 07, 2002 3:04 PM
To: Multiple recipients of list ORACLE-L
have you tried adjusting optimzer_index_caching and
optimizer_index_cost_adj?
-Original Message-
Sent: Thursday,
[EMAIL PROTECTED] wrote:
Well, since hints are implemented within comments, I would assume that other
databases would simply ignore them. If anyone has direct experience, that
would be interesting. Being completely database-agnostic may play against
tuning.
it has been my experience that those
Steve,
I suspect this could be another BUG like your old V$sysstat.
By any chance you have set the _sql_exec_progression_cost to
lowest values?
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Sent: Thursday, March 07, 2002 12:19 PM
To: Multiple recipients of
You've already got the main answer from KG and RF.
The figures on Metalink look much too high - but they
might be from an earlier version of Oracle. The size
is strongly version dependent.
In Oracle 9 (automatic UNDO only) the figures are
closer to:
4K= 22
8K= 48
In
[EMAIL PROTECTED] wrote:
Hi,
I was wondering why Oracle force minextents for rollback
segments to be two. Why can't we have minextents zero or
no minextents clause at all.
We can surely set initial extent to be large enough ourselves
and next extent sized accordingly.
Can someone
Title: Message
Hi
there,
Does anybody know if
there's a list such as this one for DB2? Or, a link to DB2 documentation (maybe
something like the Oracle Concepts Guide)?
Thanks!
-
Jerry
Anjo,
Quick, correct you answer before anyone else
gets in there. The guy is asking about the
transaction table in the rollback segment header,
not about the ITL.
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Next Seminar - UK, April 3rd - 5th
http://www.jlcomp.demon.co.uk/seminar.html
Host
1 - 100 of 135 matches
Mail list logo