How to unsubscribe to fatcity.
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: yerragudi reddy
INET: [EMAIL PROTECTED]
Fat
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other
RTFM - Read the following message ;-)
-Original Message-
From: yerragudi reddy [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 31, 2003 1:39 PM
To: Multiple recipients of list ORACLE-L
Subject: Help me to unsubscribe
How to unsubscribe to fatcity.
Hi,
Do you have to do any setting to run forms9i, it does not have any forms
runtime environment. It runs only in the web server. My forms are giving
this link
http://ciscow40s0249.cisco-temp.com:/forms90/f90servlet?form=C:\Prog
Title: RE: On TRUNCATE table does the indexes also get truncated.
Hello,
I
deserved that the comments that were made, it is after all logical that they
will be cleaned out. However in my defence, there are some funny thoughts
thatwent through through my mind just before I truncated that
Hello,
There is alot of talk about multi-skilling/reskilling going on here at my
company. We use Oracle and MSSQL dbs.
I have been wondering if anyone is aware of a resource that shows the oracle
programming technique and what the corresponding MSSQL programming technique
is.
ie
Oracle defines
Hi
Or run the extproc as another low privilege user such as nobody on
Unix. Then the hacker would not be able to run oracle owned libraries as
oracle and if he did the classic of creating a library using libc and
the system() call anything executed would be as nobody and not the owner
of the
Title: RE: rebuild index -initial extent - magic??!!
I did the following in Oracle RDBMS 9i:
_
SQL alter index xsc_uk rebuild tablespace ax_le_small storage (initial 128K
2 next 128K);
SQL select
Title: RE: rebuild index -initial extent - magic??!!
If this is true:
The rebuild creates a new temporary segment that is the same size as the
required extents in the old index. If there is insufficient space to create
this temporary segment you get this error.
It doesn't reuse the
My wife recommended that to me. She's American, I'm German. She definitely
likes English better ... now I can see why ;).
Stefan Jahnke
Consultant
BOV Aktiengesellschaft
Tel.: +49 201/45 13-289
mailto:[EMAIL PROTECTED]
http://www.bov.de
Abonnieren Sie unseren Newsletter: http://www.bov.de/enews
I know Microsoft is offering a new course called 'Microsoft SQL Server
2000 for Experienced Database Professionals'. It is aimed at DBAs with
experience with Oracle, DB2, Sybase etc. who want to know more about SQL
Server.
You can read more about this course at
Hi All,
Current Environment: Oracle Apps 11.0.3, OS Windows NT 4
Since Windows NT is being desupported by the end of this year, we are
planning to upgrade the OS to Windows 2000. Since 11.0.3 is not supported on
Windows 2000, we have to upgrade oracle applications too. We are planning to
upgrade
Title: RE: Any German here ? Character set
thanks all for all thoses relevant answers ;-)
Philippe Nguyen
CETELEM - Administration, Architecture Décisionnelle
Direction Customer Relationship Management
E-Mail : [EMAIL PROTECTED]
Tel
we have the same configuration, Metalink
recommend registering you're 32 bit instance with 64 listener (startup /
shutdown many times if necessary)
De: John Shaw
[mailto:[EMAIL PROTECTED]Envoyé: Mittwoch, 30.
Juli 2003 22:49À: Multiple recipients of list
ORACLE-LObjet: 64 and 32 bit on
I have a question re. these conversions...
If an Oracle database has 120 tablespaces, how does that translate in MSSQL
speak?
(One of the tablespaces is USERS, home of dozens of schemas; the others are
either RB, SYSTEM, TEMP or application tablespaces)
How many separate schemas-tablespaces can
We use a SAN.
Where does that leave me?
: )
Patrice.
-Original Message-
Sent: Wednesday, July 30, 2003 7:10 PM
To: Multiple recipients of list ORACLE-L
I'm constantly amazed (and relieved!) that there's disagreement on the
most fundamental principles.
First, I found myself nodding
Hmm, must be a one hour course then ;-)
On Thursday 31 July 2003 12:34, you wrote:
I know Microsoft is offering a new course called 'Microsoft SQL Server
2000 for Experienced Database Professionals'. It is aimed at DBAs with
experience with Oracle, DB2, Sybase etc. who want to know more
Not completely true.
If the dbwr is going to write a buffer, it will set a bit that the buffer is
being written. In the good old days, this meant that the buffer could be
changed until the block was written ('write complete waits'). However in 8.1,
cloning of buffers was introduced. So now
What was the activity on the database before you issued the alter
tablespace command? It could be that the server was busy finishing up
that activity. If you were creating massive indexes then the temporary
indexes have to be made perminent.
Ron
[EMAIL PROTECTED] 07/30/03 03:34PM
why does it
I am wondering... where do these questions come from?
There is a disclosure agreement at the beginning of each Oracle exam...
Patrice.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Boivin, Patrice J
INET: [EMAIL PROTECTED]
Fat City Network Services--
Hi!
I found out that these hanging problems were
version 9.0.1's problems. I wasn't directly involved with this setup. But in 9.2
they say these problems are fixed. (One instance hits ORA-600 with parameter
4519 and all instances would hang until restarted all instances).
This was on 3-node
Hi,
has anybody any experience of HP's Openview Storage Data Protector product
in relation to backing up Oracle databases? Any good or bad points to
comment on?
Am currently evaluating this product from Oracle RMAN perspective as well as
our overall centralised backup management process.
Using
Hi
This ques from a model examnothing to worry about disclosure and
all!!!
-Original Message-
Boivin, Patrice J
Sent: Thursday, July 31, 2003 6:24 PM
To: Multiple recipients of list ORACLE-L
I am wondering... where do these questions come from?
There is a disclosure agreement
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
Boivin, Patrice J
Sent: Thursday, July 31, 2003 12:59
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle to MSSQL conversion?
I have a question re. these conversions...
If an Oracle database
rant
Man, I hope not. The complete reversal of the security in TOAD from deny
all / grant some to grant all / deny some in 7.3 made maintenance a
nightmare (we're stuck at v7.2 for this reason). Security granted by
default is not security -- it's a welcome mat with the key tucked
underneath.
Hi!
The alter tablespace read only is waiting for every query which started
before the alter tablespace was issued to finish. Just in case one of
them might write to that tablespace and therefore fail.
Do you mean DML? Or transaction?
Anyway, I get following error on my 9.2.0.1 on Win2000
Please help resolve this dispute.
We have a query that runs over 5 hours. Sections of the query are
listed below.
The table QOH_DAY_FACT table had only on index and that was on the
TIME_ID column. I propose adding an index with PROD_ID, WHS_ID, LOT_ID,
WHS_LOC, TIME_ID and QUALITY_ID. My test
Title: RE: 9i-OCP Question
didn't you say it was a question/answer out of the book?
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
Few people really enjoy the simple pleasure of flying a kite
Adam Wells age 11
-Original Message-
From: Senthil Kumar
9.2.0.1 on Linux and my alter statement just waited to complete without
erroring out. We had both query only (select) and DML running. when I
rebooted the database, and no one was logged in, the alter tablespace
read only completed.
if you search the archives you can find the discussion thread.
Where can we get a list of the bugs in freeware TOAD?
Patrice.
-Original Message-
Sent: Thursday, July 31, 2003 10:50 AM
To: Multiple recipients of list ORACLE-L
rant
Man, I hope not. The complete reversal of the security in TOAD from deny
all / grant some to grant all / deny some in
Thanks to Wolfgang for spotting the problem. It was not the inlist iterator at all but
an outer join! The NOT NULL predicate invalidated the outer join, so the optimizer was
smart enough to make a different decision. I am still perplexed as to why the table
access information was so radically
http://www.toadsoft.com
I still think that the freeware version is excellent, just lacking in some
features found in v7.
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
-Original Message-
From:
Siddharth
Is your Http server running and can check it with
http://ciscow40s0249.cisco-temp.com:
If you got an error in it then it mean you need to start the OHS by using dcmctl utility or thru OEM which can be invoked by running
http://ciscow40s0249.cisco-temp.com:1810
Then check if
Ah. I never went to 9.0.1 I went from 8.1.5 OPS to 9.2.0.2
RAC, using Export-Import
and migrating to LMT, AutoAllocate, ASSM etc.
Hemant
At 05:24 AM 31-07-03 -0800, you wrote:
Hi!
I found out that these hanging problems were
version 9.0.1's problems. I wasn't directly involved with this setup.
All,
I have a question of how to auto start a standby database. IOW,
it seems the logs are only applies if I issue the command
Recover managed standby database;
With thatcommand, the logs are applied, however, if I (or someone else)
exits the cmd window the process stops
So, how can I
Title: RE: ORA-03115 (TOAD question!!)
Hi,
It
worked!! As suggested by Raj, I browsed the TOAD help on SQL*Net installation
and found out this piece of information:
**
When Oracle connects, it will look in ALL_HOMES for the
"LAST_HOME" value, which in this case is zero "0". It appends zero
Folks,
While we're on Veritas's backs, I recently (like Tuesday
night) heard from an Oracle employee (to remain nameless) that Orbitz will be
issuing a retraction of their claim that their Oracle RAC implementation was the
root cause of the outage they had. Seems the true culprit is, guess
Hi,
What version of Oracle and OS platform you're using?
The document you read refers to an 8i db so I assume you are in 8i.
In our Solaris box with 8i on it, I created a shell script like so:
#!/bin/ksh
sqlplus -s /nolog !
Connect sys/*** as sysdba
recover managed standby database ;
exit
!
Remember that initial_extent and next_extent in dba_indexes (and
dba_tables) records what you requested in your storage clause - NOT what
Oracle actually allocated. You need to look at dba_extents for tha.
At 02:34 AM 7/31/2003 -0800, you wrote:
If this is true:
The rebuild creates a new
You may find it easier to just run the Oracle Home Selector
that appears in the Startup-Programs-Oracle Installation Products
menu.
It has the benefit of also modifying the PATH variable.
Jared
On Thu, 2003-07-31 at 07:54, Charu Joshi wrote:
RE: ORA-03115 (TOAD question!!)Hi,
It worked!!
Our Prod SAP system has 4 RAID1's dedicated to redo of 500m each
on an Clariion CX600 SAN.
Several groups with 2 members each. That's 600 gig
of physical disk dedicated to redo, and nothing else.
Jared
On Thu, 2003-07-31 at 04:59, Boivin, Patrice J wrote:
We use a SAN.
Where does that
Rachel ,
Thanks for the Reply . On checking further I found that this session was
waiting on a lock from another session . But the table or object which was
locked by other session does not belong to this tablespace . Then why does
the read only operation waiting for the lock to release ?? Does
You might like to buy the ebook SQL Server 2000 for Oracle DBA's
by Chris Kempster: http://www.chriskempster.com/
I bought it, printed it and had it bound at Kinko's.
Appears to be a very good book, though I've only read parts of it.
Jared
On Thu, 2003-07-31 at 02:34, Denham Eva wrote:
Being more of a SQL 2000 DBA (I am experienced from SQL Server 6.5).
At my installation I have 5 SQL-2000 database machines and recently
acquired three Oracle 9i machines.
The limit is essentially a function of your storage area and the amount
of real memory available to the processor or
Title: Message
I set
the value to 2147483648 and it still does the same thing.
Oracle
database is open but when trying to connect through sqlnet I get
ORA-27101.
I do
shutdown immediate and startup and the problem is gone for a
while.
I now
stopped the archiver again and see if that
Title: Message
Thanks
for the " rumor gossip" Dick,
Is
this in reference to the Veritas clustered file systems technology? Or the
Veritas Cluster Manager product? Or a file systems manager
person?
Curiouser and curiouser...
-Original Message-From: Goulet, Dick
Just got this email from my SysAdmin when I asked for access to sar. Anyone
know what he is talking about? We are on AIX 4 and 5.
I cannot give you direct access to the sar command. Because of the
parameters
the command allows, it would be equivalent to giving full root access.
If you could
What we found is that it doesn't matter which tablespace the session
causing the wait is accessing. As explained to me (by Dan Fink I
believe), Oracle doesn't KNOW if that transaction will involve the
tablespace you are trying to make read-only or if it will not. So
rather than take a chance, the
While Metalink is up and working, it's sporatically
dropping out.
A word to the wise. If you're about to spend a chunk
of time updating a TAR, do it in a text editor, SAVE
it, copy it into your TAR, then update.
If you spend 30 minutes updating your TAR, push the
update button, and get an
Title: RE: rebuild index -initial extent - magic??!!
Rebuild will use the same initial extent as it was before but will change
the next extent size. Either drop and recreate index
orYou can also think about using Locally managed Uniform
Extent size tablespace, that way you dont have to worry
Hello:
Does anyone know if you can create a comment in a import parameter file?
If so could you provide a sample of the syntax.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jay
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
Beacuse of the outer join, the optimizer had to ignore the inlist predicate
and therefore the filter factor for the table became 1 (= all rows),
manifested in TB_SEL 1..
At 06:29 AM 7/31/2003 -0800, you wrote:
Thanks to Wolfgang for spotting the problem. It was not the inlist
iterator at
# your comment goes here
# another comment
# Bla bla
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Bob Metelsky
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web
Normally sudo is used to grant limited permissions.
The SA would allow you to use sar and for you to access it you would type
sar
and be prompted for a password and you would enter the appropriate password.
John
-Original Message-
Sent: 31 July 2003 16:45
To: Multiple recipients of
Jay - I don't think the exp and imp parameter files have provision for a
comment. But you could try common comment formats and see if you find one
that works. The person who wrote the parser might have added that but it
didn't end up in the documentation. I notice testing is a habit of the more
An Oracle database with multiple applications using different schemas in
the same database would be close to the SQL Server model.
Ron Smith
-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Thursday, July 31, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L
Being more of a SQL
Thursday, July 31, 2003, 12:09:24 PM, you wrote:
BB you're likely to say some VERY
BB bad words that might get you escorted out of the
BB building.
I thought those words were a necessary incantation, to make
our databases work. Else why would we say them so
oftengrin.
insert mental picture here
Maybe now is a good time for me to ask these question since it is
related to this thread's subject, can you say that an Oracle
instance is
essentially the same as a MSSQL database? I ask this because a MSSQL
server can support multiple databases which can be configured
different
ways.
But
An Oracle instance does not correlate to a SQL Server database.
An Oracle instance is a running Oracle server, i.e., a set of
background processes and a System Global Area in memory. It is what
permits applications to _access_ the database. The database is on
disk, the instance in memory.
An
Thanks John. I've used sudo, just not sure where sar is equivilent to 'full
root access'.
Henry
-Original Message-
Hallas, John, Tech Dev
Sent: Thursday, July 31, 2003 12:49 PM
To: Multiple recipients of list ORACLE-L
Normally sudo is used to grant limited permissions.
The SA would
Dennis:
I have tested through most of the common formats already, that is why I
asked for help from the list.
Your advise about testing is noted, but in this case based on incorrect
assumptions.
I used most of the major comments in PL/SQL, Java, etc.
Though I missed trying the #, which per
Hi!
Try:
recover managed standby database disconnect;
This should spawn a separate process for recovering.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, July 31, 2003 5:54 PM
All,
I have a question of how to auto start a
Hi!
I have used # for that.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, July 31, 2003 7:34 PM
Hello:
Does anyone know if you can create a comment in a import parameter file?
If so could you provide a sample of the
Is sar on AIX setuid? If so, that could be where the reluctance stems
from.
Thanks,
Matt
--
Matthew Zito
GridApp Systems
Email: [EMAIL PROTECTED]
Cell: 646-220-3551
Phone: 212-358-8211 x 359
http://www.gridapp.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Had a couple of minutes so ...
The syntax you need is (cryptically enough) :
# Comment
Cheers,
Mike Hately
-Original Message-
Sent: 31 July 2003 16:50
To: Multiple recipients of list ORACLE-L
Jay - I don't think the exp and imp parameter files have provision for a
comment. But you
I haven't heard of an SQL Server instance before... do you mean a SQL Server
server?
(this is getting a bit confusing)
Patrice.
-Original Message-
Sent: Thursday, July 31, 2003 1:19 PM
To: Multiple recipients of list ORACLE-L
Maybe now is a good time for me to ask these question
The same is not true when you take tablespace offline with normal option . I
just tested that if a transaction is pending then oracle waits before
marking tablespace rea only BUTTT if x-saction is pending and I issue
offline normal it succeds . Doesn't offline normal also checkpoints
datafile ?
I think I understand what you have said, Oracle runs an instance per
database where MSSQL is one instance running multiple databases. Is
this right thinking?
v/r
Stephen S. Wolfe, GS-11, DAFC
Data Services Manager
[EMAIL PROTECTED]
(813) 827-9974 DSN 651-9974
-Original Message-
Yes, MSSQL is running as an instance and you can multiple instances on
the same server (that is W2K or 2003 server), each instance is SQL
server consuming it's predefined resources. Each instance of MSSQL can
be servicing different databases.
v/r
Stephen S. Wolfe, GS-11, DAFC
Data Services
Hi,I want to get rid or
those special char in a number string to a pure number, for an instance, from
89_. or 99,9 to 89 and 999.Which function should I use in SqlPlus?Thanks
a lot,
Jack
Change nuber.+# to
number
Jared,
Yeah, I'm sure our Developers complain to their boss That dang DBA's
Jacking with my application again. ;-)
Actually, it would only take as long to generate the 50k triggers as it
would to loop through the list of tables in a PL/SQL procedure and
generate/execute the Dynamic SQL
Hi,
Is there an easy way to find out if a table or anindex is being used. I mean short of going thru all code or keeping looking at v$sqlarea. I mean even if code is covered there are always ad hoc SQL queries etc. Same for other objects like views etc. Is there a place where oracle stores
An SQL Server instance IS the Server...
-Mensaje original-
De: Boivin, Patrice J [mailto:[EMAIL PROTECTED]
Enviado el: jueves, 31 de julio de 2003 13:39
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Oracle to MSSQL conversion?
I haven't heard of an SQL Server instance
Title: Message
That
point was not disclosed. Personally, I vote for the
later.
Dick GouletSenior Oracle DBAOracle Certified 8i
DBA
-Original Message-From: Orr, Steve
[mailto:[EMAIL PROTECTED]Sent: Thursday, July 31, 2003 11:59
AMTo: Multiple recipients of list
Except that:
1) five disks was not one of the possible answers, and
2) we don't know that the database is in archivelog mode.
For the 9i OCP examination the correct answer is answer number 4 (4 disks). I'm
willing to bet on it!
-Original Message-
From: Ron Yount [mailto:[EMAIL
Does it make a deal?
SQL select translate('#33',
'1234567890#,_', '1234567890') from
dual;
TR--33
-Original Message-From: Liu, Jack
[mailto:[EMAIL PROTECTED]Sent: Thursday, July 31, 2003 2:10
PMTo: Multiple recipients of list ORACLE-LSubject:
Change nuber.+# to number
One way that might work is to use the translate function. For Example:
SQLr
1* select
translate('numberstring',1||translate('numberstring','0123456789','
'),'1') from dual
Enter value for numberstring: 89_.
Enter value for numberstring: 89_.
old 1: select
Title: Message
I'd
vote for the middle option. Veritas AC for RAC is hideously complex and
there's about a million ways to be running on it even though the configis
fundamentally broken. It could also be the clustered file system, of
course, since cluster file systems are Hard Problems
Without a platform, version or other info, it's hard to say. On an HP/UX
11.0 machine running Omniback II vA.04.10, at least, you can look thru man
omniintro to find the location of log files. However, those logs don't
generally contain what was backed up. That's stored in the Omniback
Hi,
We have a query which
uses
a "union all". After upgrading
to
a patch release of Oracle this query
no longer works. We get the
following error :
ERROR at line 1:ORA-03113: end-of-file on
communication channel
ORA-24323: value not allowedError accessing package
Internally, Oracle represents SCNs as a base and a wrap. The wrap is a 16-bit number
and the base is a 32-bit number. A dump of a redo log file would display the SCN as
0x.. However, the SCN is represented as a number in a number of the
dynamic performance views
Hi All,
I want to log the oracle error code and messages that will be generated
within a procedure/trigger
into a table.
I know i can write this in the exception block.Does anyone has any sample
code to help me out.
thanks
ravindra
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
So ya wanna do a little omniback eh?
Omnidb -rpt -last gets you all yesterday's backup sessions.
What you will see here depends on how your shop decided to setup
backups. Filesystem is one way. Basically omniback backs you up mount
point by mount point. Host based is the other way. Backup
Title: RE: logging oracle error code and message into a table within procedu
create or replace log_errors (in_errors varchar2, in_calls varchar2)
is
szerrors varchar2(1000) := dbms_utility.format_error_stack;
szCalls varchar2(1000) := dbms_utility.format_call_stack;
pragma
Hi,
have a look at $ORACLE_BASE/oraInventory/logs/installActions.log.
hth
kind regards
Pete
--
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.
--
Title: RE: logging oracle error code and message into a table within procedu
sorry
should be ...
insert into error_log (error_ts, ora_user, error_text, call_stack) values (sysdate,
user, szerrors,szcalls);
Raj
Ok It looks like the disconnect is for 9i
From metalink
This recover command must be ended from a different session with
recover managed standby database cancel. There is a timeout=n option
to the recovery command which will cause recovery to end if a new
archive log is not received in n
Jay
I hope my reply didn't sound harsh. You are right, it is always a good
idea to briefly describe what you've tried since that will allow everyone to
make better use of their time. I was just trying to point out one of the
great benefits I've derived from the experts on this list (and I don't
: )
So an MS SQL server = an Oracle instance
An MS SQL database = (roughly speaking) an Oracle schema.
An MS SQL file set = (roughly speaking) an Oracle tablespace.
and data files are data files.
Is that correct?
What would be the point of installing two SQL Server servers on the same
box?
Mladen you're crackin me up, dude! That looks good except for the
reading part...
-Original Message-
Sent: Wednesday, July 30, 2003 12:19 PM
To: Multiple recipients of list ORACLE-L
No, that's the wrong way. The right way is to read first 3 pages, then
try it out, using your production
If you look at the source of the ALL_TRIGGERS view (at least in 8i), you'll
see that the CREATE ANY TRIGGER priv is needed for a schema to see triggers
of another schema. Since this probably isn't what you want, you have some
options:
1) GRANT SELECT ON DBA_TRIGGERS TO your_schema;
2) Reverse
List:
I'm testing an upgrade of a database from 8.0.5 to
8.1.7.4 (Solaris 2.6).
I have 3 objects in the 8.0.5 database that are type#
10 in obj$. The objects do not show up at all in
dba_objects. The objects apparently came from someone
applying statspack to an 8.0.5 database.
8.0.5 doesn't
Please help resolve this dispute.
We have a query that runs over 5 hours. Sections of the query are
listed below.
The table QOH_DAY_FACT table had only on index and that was on the
TIME_ID column. I propose adding an index with PROD_ID, WHS_ID, LOT_ID,
WHS_LOC, TIME_ID and QUALITY_ID. My
Title: RE: HELP! Index Debate!
How does one know that only one column is being used in an index and others are being ignored ... ?? This is new to me.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views
Title: Message
No
answer for that.
-Original Message-From: Jamadagni,
Rajendra [mailto:[EMAIL PROTECTED] Sent: Thursday, July
31, 2003 3:44 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: HELP! Index Debate!
How does one know that only one column is being used
A - For tables, you can turn on auditing. If you are on Oracle9i, there is a
monitoring feature for indexes you can turn on.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, July 31, 2003 12:49 PM
To: Multiple recipients of
Ron,
It has been my understanding that in order for the conpound index to
be used the query had to match the order the index was created. Multiple
indexes would not do a whole lot of good for you just make the optmizer
work harder to figure things out. It would add a confusion factor other
wise
All my e-mail was sys$hosed last night so could you please resend any and
all responses to this since last night.
Anybody run into a situation where you see optimizer_mode equal
multiple_children_present when the optimizer_mode is set to choose in the
init*.ora file ?
If so, did you
Title: Message
do you have corresponding indexeson referenced columns on T1-5
tables ??
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly personal. QOTD: Any clod
1 - 100 of 136 matches
Mail list logo