Mladen:
Prior to 8i (or 8) you see the multiblock sequential reads while doing
the reads from the sort segments or temporary segments. But in 8i sort
IO is done as direct IO and we see some other waits.
Starting from 8i the db file sequential read is always a single block
read which TYPICALLY
When I specify the STAR Hint in the Query
the Query runs OK.
Regards Munish
Bajaj-Original
Message-From: Munish Bajaj
[mailto:[EMAIL PROTECTED]Sent: Thursday, June 12, 2003
11:44To: Multiple recipients of list ORACLE-LSubject: RE:
Performance Problems Solaris Vs Windows
Both
Your query is not written properly
Try this one..
and try to use count(a.column_name) or count(b.column_name) instead of
count(*) whatever is ur requirement.
SELECT COUNT(*) FROM mam_assets a,
mam_asset_attr_domain_values dmv65549 WHERE a."ID" =
dmv65549.asset_id AND
Is there any way that we can change the optimizer_mode
for a running session ? [Oracle 8.1.7]
The session may have started with the instance-level
optimizer_mode=RULE [Oracle Apps R11.0] but I
want to change the optimizer_mode for subsequent SQLs
executed by the session, without killing and
hi,
We use Oracle 8 DB.
I am not a Oracle technical guy. So lemme try explaining the problem.
We need to create tables with columns, whose names(column-names) are
more than 30 characters long.
This is being restricted because, all columns of all tables have entries
in a table called 'col'.
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
SQL alter session set optimizer_mode = rule;
Session altered.
SQL
SQL alter session set optimizer_mode = choose;
Session altered.
SQL
HTH
Mark
Hi there,
I
have 3 CDs of
Oracle9i database Release2 (9.2.0.1.0) for Linux Intel with part
numbers as A99339-01, A99340-01 and A99341-01. I want to set up RAC on Linux
machine. I believe RAC option only
comes from Oracle9i Enterprise Edition CDs. Is it possible to know whether RAC
Title: ORA600 [2103] [0] [0] [1] [900]
Dear All,
I have encountered the following message during alter database backup controlfile to reuse after a hot backup.
We have opened a tar but still waiting. The strange think is that our Oracle versions range from 8.1.7.3 to 8.1.7.4 which
NO for all objects created in Oracle...
30 chars is the max.
R
-Original Message-
Sent: Thursday, June 12, 2003 11:30 AM
To: Multiple recipients of list ORACLE-L
hi,
We use Oracle 8 DB.
I am not a Oracle technical guy. So lemme try explaining the problem.
We need to create tables
KG,
What are the scenarios other than index scans when a single block read can
happen (8i as you said) and hence db file sequential read be reported?
Regards
Naveen
-Original Message-
From: K Gopalakrishnan [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2003 1:54 PM
To: Multiple
Dear Bhaskar,
You can modify col$.NAME to varchar2(60) and try.
If this fails, I'll give a procedure you can use that to change it to
whatever size you want.
Senthil Kumar
Sr Oracle DBA
Summitworks Technologies Pvt Ltd
-Original Message-
Bhaskar Viswanathan
Sent: Thursday, June 12,
Hi All,
When I start the listener, after sometimes the instance registers itself with
the listener. After this the status of the listener shows 2 service handlers
for the same service.
For the sake of clarity I'm pasting the output and listener.ora file.
Initial Status:
---
Services
=) Thanks. If you happen to read about me in FORTUNE or FORBES in the
future,
you'll know you helped make it possible!
=)
Jacques Kilchoer wrote:
I forwarded this to someone in our company. I hope that soon untold
riches will be yours!
-Original Message-
From: Maria Aurora de la
Oh, my bad.. ;)
Here you go:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
SQL select sid, serial#, username from v$session;
SIDSERIAL# USERNAME
-- -- --
What??
-Original Message-
From: Senthil Kumar D [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2003 5:05 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: db file sequential read [WAS:wait event puzzler]
Dear Bhaskar,
You can modify col$.NAME to
ORA-0942
At 09:15 AM 11-06-03 -0800, you wrote:
Request Denied...
Best Regards,
Ganesh R
DID : +65-6215-8413
HP : +65-9067-8474
===
Live to learn... forget... and learn again.
===
-Original Message-
Joerg
I ran the following and got an error. Any idea? I noticed after I ran it that my
DBA_TAB_MODIFICATION view has no records even though I ran gather_schema_stats
yesterdays
SQL exec
dbms_stats.gather_schema_stats(ownname='MASTER_TEST2',estimate_percent=20,degree=16,cascade=true,options='GATH
ER
Modifying data dictionary tables is definitely not a good idea and I
am sure Oracle will not support this.
CP
[EMAIL PROTECTED] wrote:
Dear Bhaskar,
You can modify col$.NAME to varchar2(60) and try.
If this fails, I'll give a procedure you can use that to change it to
whatever size you
Title: RE: db file sequential read [WAS:wait event puzzler]
And I assume this suggestion is completely approved by Oracle support ... so can we also have the Metalink Doc ID phleeze ??
Raj
Rajendra dot Jamadagni
Hi Senthil,
One thing I can see is that this object col is not a user-defined table.
Probably a system table.
I tried alter table col modify cname varchar2(60)
*
ERROR at line 1:
ORA-00942: table or view does not exist
But the object exists as I am able to do a select on it.
Please send me
What makes you think that the optimizer_mode is set to anything from your
example...??
Regis
-Original Message-
Sent: Thursday, June 12, 2003 1:09 PM
To: Multiple recipients of list ORACLE-L
Oh, my bad.. ;)
Here you go:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With
Thank you.
I had done a DESC DBMS_SYSTEM and used SET_EV but never bothered to look
for doc/notes on SET_BOOL_PARAM_IN_SESSION.
Hemant
At 04:08 AM 12-06-03 -0800, you wrote:
Oh, my bad.. ;)
Here you go:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
he is talking about altering the column in the data dictionary. Ive updated TS$ myself
and its not that big of a deal.
id be a bit concerned about actually altering a column. Oracle may have some
underlying code that you dont know about that assumes a maximum column length = 30 or
there is
DON'T DO IT !
Ur not supposed to Update Data Dictionaly Tables Directly ...
Oracle has A Limit of 30 Chrs and is Hardcoded.. So ReName your Columns
within 30 Chrs...
DON'T DO IT !
Best Regards,
Ganesh R
DID : +65-6215-8413
HP : +65-9067-8474
That is a Very Good Idea...
We will do away with DDL Stmts will start writing directly into the Data
Dictionary ...
Best Regards,
Ganesh R
DID : +65-6215-8413
HP : +65-9067-8474
===
Live to learn... forget... and learn again.
I ran
run
{
allocate channel c1 device type sbt format 'df_%t_%s_%p' maxpiecesize=2048M
PARMS=SBT_LIBRARY=/opt/oracle/dbserver/9.0.1/lib/libobk.so,
ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin/tdpo.opt);
restore archivelog sequence 9645 validate;
release channel c1;
}
And was successful,
why are you so focused on this view: DBA_TAB_MODIFICATIONS
It contains info on tables *modified* :
columns INSERTS, UPDATES, DELETES give you the number rows inserted or
updated or deleted since the last your tables was analyzed
Concerning your error, I ran it as SYSTEM and it
Really.
Anybody who takes this advice had better have another job lined up. Because
this is very dangerous behavior.
It's ok to play with stuff like this on a test database where you can throw
it away when the eventual crash occurs. But to suggest to someone that they
should try this on a real
From the Oracle SQL reference:
The following rules apply when naming schema objects:
1. Names must be from 1 to 30 bytes long with these exceptions:
n Names of databases are limited to 8 bytes.
n Names of database links can be as long as 128 bytes.
Hey Guys,
8.1.7.4, HP-UX 11, 16k block size, avg CLOB size is 4k to 32k (most are
less than 16k).
We have to load 3.5 million CLOBs into a table with 3 columns, two IDs
and the CLOB. I am new to using CLOBs and am unsure about what storage
parameters would be the best choice for this case.
If
Oh...God...any other short 'n' sweet's r there.
Senthil
-Original Message-
Ganesh Raja
Sent: Wednesday, June 11, 2003 10:39 PM
To: Multiple recipients of list ORACLE-L
It is a Big Procedure ;)
Sorry ...
Best Regards,
Ganesh R
DID : +65-6215-8413
HP : +65-9067-8474
encoded content removed -- binaries not allowed by ListGuru
The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists. If you want a copy of the attachment which was
removed, contact the sender
Title: RAC, fail over and timeout .. Big Question
Hi all,
here is a (hopefully) tricky one ...
We have a two node RAC (9202), two applications run on either side, no problems there. We have a business critical process that runs all the time on node T2. This process needs to have a set
I do agree with you. But some times we may need go beyond the scopes.
For testing purpose we can do these kind of RD's.
Nothing wrong in this.
Senthil.
-Original Message-
CP
Sent: Thursday, June 12, 2003 7:10 PM
To: Multiple recipients of list ORACLE-L
Modifying data dictionary
I must confess that I checked by using strace on Linux and, true enough,
for index read, I've got read calls and for full table scan, I've got
readv
(scatter/gather IO). Obviously, I'll have to re-learn some stuff from
version 7.
I successfully forgot versions 4, 5.0, 5.1.22, 6.0.36, 7.0.16,
Bhaskar,
Please don't modify any system tables.
You cannot overcome the 30 character limit of oracle. If only it was all that
easy.
Better change your naming conventions to abbreviate long words like customer
to cust etc.
Regards
Naveen
-Original Message-
From: Bhaskar Viswanathan
Yup. Your SID isn't found.
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, June 11, 2003 6:25 PM
To: Multiple recipients of list ORACLE-L
DBA's,
Has anyone ever seen this:
15:37:19 06/11 [DBUG] [ConnectionPoolC]
Title: RE: db file sequential read [WAS:wait event puzzler]
But it took them awhile to get 7.3.4 stable:-) Spent many an hours watching latch contention and spin count(as well as hash algorithms playing havoc, hard parses when not required, and the engine puking on the SGA memory
Firstly the person is new to oracle and so he should not be doing anything
with the DD other than querying. Secondly I don't think changing this 30
charcter limit can be as easy as modifying col$.name.
Even if it is independent of the software code and only a DD issue, and
someone has tested it
Hello ALL,
We have a plan to change the SYS and SYSTEM user's passwords. There are two DBLINKs
created for each user and I am not sure who is using them , Is there any way ( trace )
to check who is using these DBLINKs ??
Also you might have done the password changes many times for SYS/SYSTEM ,
1. Try writing the backup to another location
alter database backup controlfile to '/tmp/cntrlfilebk.dbf'
2. Try it again with the reuse clause
3. Is the file system '/hot_backup/siebelp1' local or
NFS mounted ?
Hemant
At 02:45 AM 12-06-03 -0800, you wrote:
Dear
All,
I have encountered the
He is a New commer to the Oracle World and ur telling him to do a Update
on COL$... He Ends up Doing that in his Production Database.. And he is
going to be in a HOT soup
Best Regards,
Ganesh R
DID : +65-6215-8413
HP : +65-9067-8474
===
Live to
I do agree with you. But some times we may need go beyond the scopes.
For testing purpose we can do these kind of RD's.
Did you try to go beyond the scopes? I tried this on a trashable DB
(8.1.7).
SQL*Plus: Release 8.1.7.0.0 - Production on Thu Jun 12 20:30:32 2003
(c) Copyright 2000 Oracle
Updating a data dictionary is simply not done. Remember, we're
the DBA (you will be assimilated) and not fun loving students
who can play with their alma mater's equipment. Updating the data
dictionary directly would cause the database to lose support from
Oracle Corp. and the perpetrator would
If it was a joke, its not nice to mislead someone who is new into the world
of Oracle. It might lead to a lot of problems for him.
If it wasn't a joke, please read the DOCs.
Regards
Naveen
-Original Message-
From: Senthil Kumar D [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12,
Dear List,
I have a table which partitioned on date range This table has 10 indexes
on it I just wondered do I have to Partitioned all the 10 indexes or NOT?
Example:
Create table test(col1 number,col2 number,col3 number,col4 date)
tablespace data
partition by range(col4)
( partition part1
Title: ORA600 [2103] [0] [0] [1] [900]
Check metalink Note:28045.1
-Original Message-From: Hatzistavrou John
[mailto:[EMAIL PROTECTED]Sent: Thursday, June
12, 2003 6:45 AMTo: Multiple recipients of list
ORACLE-LSubject: ORA600 [2103] [0] [0] [1]
[900]
Dear
All,
I
Dear Mogens,
When I arrived at my new job, I found RAID 5 everywhere, and a sys
admin who wanted to build my new database servers that way...I smote
the old systems and set the new ones on the right path. I would be
proud to be associated with your movement.
--- Mogens_Nørgaard [EMAIL
There are major tech stack and schema differences between 11.5.4 and 11.5.8. All I
can say is
follow the maintainence pack release notes and pull all the info you can from
metalink. Depending
on the size of your installation, plan on at least a two day effort, more if you have
multiple
Given the low elapsed time for each iteration of the query I wonder if
the problem might be susceptible to either of the following approaches.
1. Calling the query less often. I'm guessing from the object names etc
that this is some sort of scientific analysis program, and it may be
that you are
Madhu,
Changing the SYS and SYSTEM passwords is something we do periodically here and
we have no issues with it. It actually does not mess up your password file. What
would concern me is the database links. In my book SYS and SYSTEM should NOT have any
dblinks or any dblinks that
Today is a bad day.
I'm seeing lots of wrong advice, or maybe everyone is in a humorous mood :-)
Regards
Naveen
-Original Message-
From: Mark Leith [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2003 5:39 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: changing
Jared writes
At the meeting last week I wore my 'No RAID 5' hat.
Those of you at IOUG 99 in Denver may have seen it, I
wore it every day there. ;)
I'm curious now. Pictures required.
Meanwhile I have never understood why storage vendors would prefer
selling RAID5 over RAID10. More
Oh, be a man!
Write a compress / decompress algorithm that will take your 200-character
table names from the application and pass them to the database as = 30
characters; then uncompress them from the database back to the application.
It's soo simple.
--
Please see the official ORACLE-L FAQ:
8.1.7
I ran it again and it worked. I really have no idea why it failed.
From: Regis Biassala [EMAIL PROTECTED]
Date: 2003/06/12 Thu AM 10:09:52 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: DBMS_STATS error
why are you so focused on this view:
From the docs : Many active transactions can write concurrently to a single
rollback segment--even the same extent of a rollback segment; however, each
data block in a rollback segment's extent can contain information for only
a single transaction.
1) Now, when oracle writes to the last extent in
Title: RAC, fail over and timeout .. Big Question
Raj:
I am
afraid, there are not much alternatives you can think of. Even the SELECT fail
over
will takearoundfew seconds since it has to attach the
PGA to the second
instance and run the query from where it is failovered, though you can
Hmm, puzzling indeed.
For starters, your output log appear truncated. I would have expected a
resync catalog somewhere at the end. You could try resync catalog
manually and try again.
Second, all datafiles should be listed in the output. This listing contains
only 33+2*2 out of 92. Any clues
Hamid
On a partitioned table you can create either global (normal) indexes or
local (partitioned) indexes. There are advantages and disadvantages to each,
but you could start with normal indexes and then switch to partitioned
indexes as you find the need.
Dennis Williams
DBA, 80%OCP, 100% DBA
Hi ALL,
In a test server play what ever u want. Nothing wrong in this.
With out testing any thing , we should not give solns.
I've tested this in my test server.
But have a naming convention to avoid such probs.
thanx
Senthil
-Original Message-
Naveen Nahata
Sent: Thursday, June 12,
Title: RE: db file sequential read [WAS:wait event puzzler]
fun part
What part of 'Thou Shalt Not have a column name larger than 30 characters' we didn't understand?
/fun part
serious
Senthil, it would be a welcome idea to try out a new algorithm, but changing DD is a _BAD_ idea,
Senthil,
This is one of those items that you don't want to do even in RD. This is
what I call playing Russian Roulette with one chamber empty.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Thursday, June 12, 2003 11:30 AM
To: Multiple
I hope this isn't true, since I just gave a presentation listing 13.
Niall
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of John Kanagaraj
Sent: 11 June 2003 18:09
To: Multiple recipients of list ORACLE-L
Subject: RE: Rule Based Optimizer
Yup, I remember praying exactly the same thing!
Pete
Controlling developers is like herding cats.
Kevin Loney, Oracle DBA Handbook
Oh no, it's not. It's much harder than that!
Bruce Pihlamae, long term Oracle DBA.
-Original Message-
Jared Still
Sent: Wednesday, June 11, 2003 10:10
We are starting a project that will eventually have 500 laptops wandering
around in the wild. These will have an Access database for untethered use,
and will periodically connect to Oracle via Net8 to resynchronize itself.
The idea of changing 500 tnsnames.ora files sometime down the line is
Rajesh:
I am not sure which document you are referring here. If that documentation
says more than one transaction can not use a rollback segment data block
means, I would say the documentation is incorrect in this case. But this
can not happen concurrently. IT can happen serially.
Each rollback
Well, I didn't see you say do this in a test database only.
in your first e-mail, so he goes and do it in the production database.
In general, people on this list made sure advises like this
comes with a warning such as this is not supported by Oracle,
therefore, do it at your own risk. Make
Dennis...
1. Are any of you using the Oracle Names?
I am! :-)
2. Is it as easy to configure as Oracle makes it
sound, or is it difficult?
it is an easy task, Oracle has Net Manager on 9i, and
Net8 Assistant on 8i... both guides you through the
configuration, where you need to define
Title: FW: Happy Birthday, RAID
For the BAARF zealots of our list. :-) ok, now I'll duck down and avoid the shots.
Greg
-Original Message-
From: Storage Report [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 12, 2003 9:10 AM
Subject: Happy Birthday, RAID
Here are pics if interested.
http://www.cybcon.com/~jkstill/no_raid_5/no_raid5_1.jpg
http://www.cybcon.com/~jkstill/no_raid_5/no_raid5_2.jpg
I too do not understand why vendors push RAID 5 when
RAID 10 is clearly more profitable. I speculate that they
may be afraid of being accused of
It appears truncated because it is only the top of the log. I so indicated that by
specifying that only the beginning of the log was being posted. All files do show up
in the complete log. I don't presently have files larger than 2GB. The old backup
system would not handle them. I will
Please see the fine instructions for removing yourself from this
list that appear at the end of each and every email sent from
fatcity.com.
Sometimes more than once.
Jared
kam_bhatia [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
06/11/2003 09:54 PM
Please respond to ORACLE-L
Group,
Can someone please give me the steps to produce a listing of EE database
components installed, ie. partitioning option, data mining, etc. ???
I need to compare what is installed on two machines. Both are 9i, one is
Solaris and the other is HP.
THANKS,
Al Rusnak
DBA - WEB Team
Dennis,
For the same reasons that you mention, we implemented Oracle Names
here just last year, despite Oracle's proclamation that it is going away
in 10i.
( or whatever the next version is )
Since we will be upgrading to Oracle 9i later this year, I'm not too
worried about
the depracation of
I haven't been around that long, but the RBO stands for the Rule Based
Optimizer, it works on a set of rules - best thought of as a
mathematical precedence list. You know the sort of thing Full Table Scan
is worse than anything, a range scan isn't as good as an equality test,
etc etc.
Now the
Title: RAC, fail over and timeout .. Big Question
It
would be interesting to see if the pre-connect helps you out or not.. We are
getting ready to work thru similar issues/testing...
Greg
-Original Message-From: K Gopalakrishnan
[mailto:[EMAIL PROTECTED]Sent: Thursday, June 12,
Dennis,
We are using Oracle Names. It is very easy to set up and use. It typically
is run on a pair separate servers (think of a DNS Server) for redundancy.
It can run off of a TNSNAMES file or another Oracle database. Personally, I
would use a TNSNAMES file - one less DB to maintain.
I
I never liked names, but that's just me. I thought keeping the names
servers up to date, and making sure every client was configured to use the
name servers, was a pain in the butt. You can have multiple names servers
to eliminate a single point of failure.
The method I liked the best was to
Hi George,
Here's a starting point. For more detail, you can always fire the lovely Installer
and click on Installed Products.
Lisa Koivu
Oracle Database Stressmonkey
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063
Office: 954-935-4117
Fax:954-935-3639
Sorry Niall, there were 15.
http://download-west.oracle.com/docs/cd/A64702_01/doc/server.805/a58227/ch13.htm#13411
Jared
Niall Litchfield [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
06/12/2003 11:14 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
1. check your sort_area_size when you use distinct you need to sort. It might be too
small and you may be sorting to the temp tablespace which is very slow.
2. how much does querySeq.use='Y' and otehr where clauses like it limit the number of
rows you are looking for? I have found that if I
Title: RAC, fail over and timeout .. Big Question
Thanks KG, Greg,
What I visualize is this ...
Specify a (sort of) timeout value. If query doesn't come back within this
value, raise alert and fail over to the other side. If you get the same problem,
raise the hell out of everyone and go to
Thanks KG, for your reply. Well, it whets my appetite for more.
This surprises me. All the documentation I have read so far tells me that
multiple transactions cannot be write to the same rollback segment data
block.
My first question was basically well, if many transactions can write to an
we're looking to upgrade to 91 later this year, so the boss wants me to do
some research.;-) leads me to two questions:
1) are the docs online at technet? [i can't get to technet right now, needs
a little tuning on our security policies.;-)]
2) how does AUM work? instead of RBS? in
Title: RE: World premier performance of the BAARF party logo
So, this is how Jared looks ... cool ... someone likes hot wheels ...
update permanent_memory
set person_face=following_link
where person='Jared'
/
commit
/
Raj
(see answer below)
-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]
We are starting a project that will eventually have 500
laptops wandering
around in the wild. These will have an Access database for
untethered use,
and will periodically connect to Oracle via
The global indexes can also be partitioned - using a different partition
column or different ranges than the table partitions. The drawback with
global indexes (partitioned or not) is that they become invalid when you do
an exchange partition or drop partition. Personally I think local indexes
are
Re pushing the tnsnames.ora out to desktops:
I considered that, but there were too many versions of it out there,
and the users may have ODBC DSN' s dependent on the contents
of their tnsnames.ora.
Re the share drive: Considered that too, but it's too easy for
net admins to re-arrange drives
Use names...
We have two Linux oracle boxes onames1 and onames2 serving up names for
serveral hundred clients. In the past 40 days over 600,000 requests have
gone through these two boxes.
We alias the hostnames in DNS to onames1 and onames2 so in the sqlnet.ora
the preferred names section will
Yes, the push method is a viable option to names. And
you can just write a script that executes when user logon
to the domain to check for a new copy of tnsnames.ora.
Not very sophisticated yet effective.
-Original Message-
Sent: Thursday, June 12, 2003 3:02 PM
To: Multiple recipients of
Oracle names is actually a very stable software and it works very nice.
I have very good experience with that product. As for LDAP, it's huge,
incompatible, hard to administer and you must have 9iAS. It doesn't work
with
iPlanet, weblogic or websphere.It's a proprietary LDAP if such thing
A few more points:
1) If you use ONAMES, I think it's a good idea to use a region DB (we have
an Oracle DB that we use as a repository for a couple of non-related items)
for a few reasons. Primarily because I thought the concept of using one was
easier for me to understand from a recovery
Another thing we do here is to have the tnsnames.ora on a shared folder
mapped to a letter drive, and then have an ifile= in the local
tnsnames.ora
-Original Message-
From: Stephen Lee [mailto:[EMAIL PROTECTED]
Another method that works is to have the tnsnames.ora on a
share and
Among some of the Rube Goldberg applications around here, is one that has
multiple replication clients that subscribe to a master. For whatever
reason, we might have a client not update for a while and the MLOG table(s)
get big. Then, after that, every update has to read up to sky-high high
Dennis,
We use Names here, best thing since sliced bread for replacing tnsnames. We
have 5 name servers, 2 in each building in our Andover campuses (for fail over) and 1
in our Westcoast facility (they have only one server to run it on use one of ours as
a fall back). Net Assist
Hi All
May I know what is best interval to exec dbms_stats.gather_schema_stats on a
instance with 300 tables that updated everyday.
By the way, Anybody has any detailed command reference for dbms_stats. I am
not sure for the following such as degree?
execute dbms_stats.gather_schema_stats
(
Hamid,
You ae referring to decision between two types of indexes in case of a
partitioned table. You couls have a LOCAL index, in which case the index
will partitioned exactly in the same way as the table. The other one is
GLOBAL index, in which case you simple create an index (unpartitioned, if
When using names, always have more than one nameserver
and add these 2 lines to sqlnet.ora. It sure helps when one fails.
Been there :)
NAMES.INITIAL_RETRY_TIMEOUT = 5#Wait num seconds before
going to next nameserver,def=15
NAMES.REQUEST_RETRIES =
2 #Number of retries for
nameserver,def=5
Bill
1) Yes, they are on technet
2) AUM is a replacement from RBS. We initially sized our AUM tablespace
to be the same as our RBS tablespaces. We continued to see ORA-01555s until
we increased the retention period...then Poof! Gone. Don't use AUM in (early
version of?) 9.0 as it could
Hi
fellow DBAs,
This
is kind of the follow-up of my last E-mail on wait event.
I have
a query that is taking hours to complete and the plan looks ok. While one of the
tables is huge (267mil rows) it is being accessed using one of its
indexes.
I
recorded some stats from v$session_wait
1 - 100 of 138 matches
Mail list logo