We have a product that runs on Oracle. The version of Oracle I'm
working with is 8.1.7. I should also note that I'm relatively new to
Oracle.
I'm troubleshooting one particular database that is having performance
problems when we try to run various quireies and peform inserts or
updates.
Unfortunately this particular product "requires" that "OPTIMIZER_MODE
= RULE".
Of the research I've done on analyzing tables, it seems that analyzing
queries and tables only effect a database if you're running a Cost
Basis system vs. Rule.
Given that we have to run RULE, are there any options that will assist
us in troubleshooting and tuning this database?
Thank you for your time!
Virgina
Field Engineer vl*****@nai.com
***NO SPAM PLEASE**** 10 3375
Virginia wrote: We have a product that runs on Oracle. The version of Oracle I'm working with is 8.1.7. I should also note that I'm relatively new to Oracle.
I'm troubleshooting one particular database that is having performance problems when we try to run various quireies and peform inserts or updates.
Unfortunately this particular product "requires" that "OPTIMIZER_MODE = RULE".
Of the research I've done on analyzing tables, it seems that analyzing queries and tables only effect a database if you're running a Cost Basis system vs. Rule.
Given that we have to run RULE, are there any options that will assist us in troubleshooting and tuning this database?
Thank you for your time!
Virgina Field Engineer vl*****@nai.com ***NO SPAM PLEASE****
Plenty.
No offense, but I'd try to get an expert in; would probably be done
within a day. See claims from hotsos.com
--
Regards,
Frank van Bortel
Virginia wrote: We have a product that runs on Oracle. The version of Oracle I'm working with is 8.1.7. I should also note that I'm relatively new to Oracle.
I'm troubleshooting one particular database that is having performance problems when we try to run various quireies and peform inserts or updates.
Unfortunately this particular product "requires" that "OPTIMIZER_MODE = RULE".
This sounds like Siebel. Of the research I've done on analyzing tables, it seems that analyzing queries and tables only effect a database if you're running a Cost Basis system vs. Rule.
Given that we have to run RULE, are there any options that will assist us in troubleshooting and tuning this database?
Enable SQL_TRACE & use TKPROF for troubleshooting.
You may have limited options for "tuning".
see my replies inline...
"Virginia" <vl*****@nai.com> wrote in message
news:84**************************@posting.google.c om... We have a product that runs on Oracle. The version of Oracle I'm working with is 8.1.7. I should also note that I'm relatively new to Oracle.
I'm troubleshooting one particular database that is having performance problems when we try to run various quireies and peform inserts or updates.
Unfortunately this particular product "requires" that "OPTIMIZER_MODE = RULE".
common with off the shelf products. they were made a while ago and never
tested against CBO. so they tell you not to use it.
Of the research I've done on analyzing tables, it seems that analyzing queries and tables only effect a database if you're running a Cost Basis system vs. Rule.
dont analyze in rule mode. Given that we have to run RULE, are there any options that will assist us in troubleshooting and tuning this database?
yes, learn how to use the explain plan. go to metalink and otn.oracle.com
and do a search on that and 'autotrace'. this gives you a chart of your
query.
you can install it by running the script in
ORACLE_HOME/rdbms/admin/utlxplan.sql
Thank you for your time!
Virgina Field Engineer vl*****@nai.com ***NO SPAM PLEASE****
I have to deal every day with such a ------ product (Siebel). What I
found is that pretty much the only "tuning" option that these bastards
agree to let us perform is to create new indices when that helps. They
won't even allow us to remove the indices containing one single value,
that the RBO thinks is useful! Post the query and the execution plan,
and we might be able to give more advice.
Daniel We have a product that runs on Oracle. The version of Oracle I'm working with is 8.1.7. I should also note that I'm relatively new to Oracle.
I'm troubleshooting one particular database that is having performance problems when we try to run various quireies and peform inserts or updates.
Unfortunately this particular product "requires" that "OPTIMIZER_MODE = RULE".
Of the research I've done on analyzing tables, it seems that analyzing queries and tables only effect a database if you're running a Cost Basis system vs. Rule.
Given that we have to run RULE, are there any options that will assist us in troubleshooting and tuning this database?
Thank you for your time!
Virgina Field Engineer vl*****@nai.com ***NO SPAM PLEASE**** da*************@hotmail.com (Daniel Roy) wrote in message news:<37************************@posting.google.co m>... I have to deal every day with such a ------ product (Siebel). What I found is that pretty much the only "tuning" option that these bastards agree to let us perform is to create new indices when that helps. They won't even allow us to remove the indices containing one single value, that the RBO thinks is useful! Post the query and the execution plan, and we might be able to give more advice.
Daniel
Having attended the Siebel Core Consultants Course and worked closely
with Siebel since Nov-2002, recent discussions with them have revealed
there is an option that allows Siebel session to be MT on the Siebel
server. If so this should reduce the number of sessions to the DB and
hence reduce the amount of resources used on the DB server, as well as
not having to resort to using dedicated sessions because MTS reaches
the maximum number of connections that a dispatcher can handle (max
sessions reached). Basically increasing DB performance. www.DBtune.com su*****@DBtune.com da*************@hotmail.com (Daniel Roy) wrote in message news:<37************************@posting.google.co m>... I have to deal every day with such a ------ product (Siebel). What I found is that pretty much the only "tuning" option that these bastards agree to let us perform is to create new indices when that helps. They won't even allow us to remove the indices containing one single value, that the RBO thinks is useful! Post the query and the execution plan, and we might be able to give more advice.
Daniel We have a product that runs on Oracle. The version of Oracle I'm working with is 8.1.7. I should also note that I'm relatively new to Oracle.
I'm troubleshooting one particular database that is having performance problems when we try to run various quireies and peform inserts or updates.
Unfortunately this particular product "requires" that "OPTIMIZER_MODE = RULE".
Of the research I've done on analyzing tables, it seems that analyzing queries and tables only effect a database if you're running a Cost Basis system vs. Rule.
Given that we have to run RULE, are there any options that will assist us in troubleshooting and tuning this database?
Thank you for your time!
Virgina Field Engineer vl*****@nai.com ***NO SPAM PLEASE****
Daniel, what about using the outline feature to provide optimizer
hints without touching the vendor code?
HTH -- Mark D Powell --
> Daniel, what about using the outline feature to provide optimizer hints without touching the vendor code?
HTH -- Mark D Powell --
I heard of a Siebel project where they implemented this suggestion,
and it worked OK. I'm not sure if it was "approved" by Siebel or not.
The problem with Siebel is that for any database change, if the Siebel
guys have not heard of this feature, then instead of saying "That
sounds great, let's try it!", they become defensive and threaten to
not support our Siebel if we implement that change. That creates a
very closed-minded environment, where everyone is scared to do
anything. The only time that they agree to make any change is when the
application is so slow that all the users are complaining non-stop.
Daniel
if Siebel is this hostile, why do people buy their product? Are there
competing products?
"Daniel Roy" <da*************@hotmail.com> wrote in message
news:37************************@posting.google.com ... Daniel, what about using the outline feature to provide optimizer hints without touching the vendor code?
HTH -- Mark D Powell --
I heard of a Siebel project where they implemented this suggestion, and it worked OK. I'm not sure if it was "approved" by Siebel or not. The problem with Siebel is that for any database change, if the Siebel guys have not heard of this feature, then instead of saying "That sounds great, let's try it!", they become defensive and threaten to not support our Siebel if we implement that change. That creates a very closed-minded environment, where everyone is scared to do anything. The only time that they agree to make any change is when the application is so slow that all the users are complaining non-stop.
Daniel
> if Siebel is this hostile, why do people buy their product? Are there competing products?
They're a good marketing machine, who don't show their real color
until the customers are "locked in". They do some very good pre-sales
presentations (the product performance on the sales guy's laptop is
always acceptable, as opposed to many customers' implementations!).
During pre-sales, they don't say anything about the constraints
(database and OS-wise) they will put on the customer afterwards. And
after a company invested millions of dollars in Siebel, they won't get
rid of it because of Siebel's stubberness. Possibly other CRM products
are doing the same, I don't know (I'm a Siebel "specialist", and don't
know other CRM products).
Daniel
Daniel Roy wrote: Daniel, what about using the outline feature to provide optimizer hints without touching the vendor code?
HTH -- Mark D Powell --
I heard of a Siebel project where they implemented this suggestion, and it worked OK. I'm not sure if it was "approved" by Siebel or not. The problem with Siebel is that for any database change, if the Siebel guys have not heard of this feature, then instead of saying "That sounds great, let's try it!", they become defensive and threaten to not support our Siebel if we implement that change. That creates a very closed-minded environment, where everyone is scared to do anything. The only time that they agree to make any change is when the application is so slow that all the users are complaining non-stop.
Daniel
Sounds like they took a page out of the SAP book. "You can't change it
without our permission; you can't discuss it without out permission;
you can't ..." This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Andreas Lauffer |
last post by:
I changed from Access97 to AccessXP and I have immense performance
problems.
Details:
- Access XP MDB with Jet 4.0 ( no ADP-Project )
- Linked Tables to SQL-Server 2000 over ODBC
I used...
|
by: Roger Green |
last post by:
I have inherited a complex database that has many dozens of queries that derive data from a people
table.
I now need to be able to run these queries (from within a significant number of forms)...
|
by: NeilAnderson |
last post by:
I'm a fairly new user of access & I've never had any training, so I'm
wondering if I'm doing the right thing here, or if it matter at all.
I'm building a database for room booking purposes and I'm...
|
by: Jerry Hull |
last post by:
I'm working with a database developed by an untrained person over
several years - and on a network that has recently been upgraded with
a new server installed and MS office upgraded from 2K (I...
|
by: Greg Strong |
last post by:
Hello All,
Is it better to create a query in DAO where a report has 4 sub-reports
each of whose record source is a query created at runtime and
everything is in 1 MDB file?
From what I've...
|
by: Joe Ross |
last post by:
(Apologies in advance if there is a better forum for asking advice on this
topic).
Our ASP.NET application occasionally starts spitting out OutOfMemory
exceptions. When this happens, the memory...
|
by: Greg Stark |
last post by:
I have a query that is taking too long when run from a larger plpgsql function
(40-50s). However when I explain analyze it under psql it runs fine (4-5s).
This is with the same parameters, and I've...
|
by: loosecannon_1 |
last post by:
Hello everyone, I am hoping someone can help me with this problem. I
will say up front that I am not a SQL Server DBA, I am a developer. I
have an application that sends about 25 simultaneous...
|
by: Virginia |
last post by:
We have a product that runs on Oracle. The version of Oracle I'm
working with is 8.1.7. I should also note that I'm relatively new to
Oracle.
I'm troubleshooting one particular database that is...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |