Hi,
We have a 3TB oracle db. 24x7 operation with data constantly coming in
to the DB. Users from all over the world use a web based applicaton to
query and work on the data.
Out transaction performance is quite good but our query performance
sucks. looking up by ids and some combinations of search critera
return ok but some never return. We indexed the db for a lot of
combinations and we materialized some views and that helped a little.
So far we haven't penalized our transaction throuput but if we
continue this path, our transaction performance will suffer.
We are looking into a third party indexing solutions. We are talking
to Omnidex.
Third party indexing solutions claim a dramatic performance
improvement for
people in our situations.
If any of you are using any third party indexing solutions on oracle,
please share your experiences.
Thank you very much,
Chuck Chekuri
DBA Manager
Vizional Technologies, Inc.
Santa Monica, CA - 90405 1 2198
"Chuck Chekuri" <cc******@vizio nal.com> wrote in message
news:ee******** *************** **@posting.goog le.com... Hi, We have a 3TB oracle db. 24x7 operation with data constantly coming in to the DB. Users from all over the world use a web based applicaton to query and work on the data.
Out transaction performance is quite good but our query performance sucks. looking up by ids and some combinations of search critera return ok but some never return. We indexed the db for a lot of combinations and we materialized some views and that helped a little. So far we haven't penalized our transaction throuput but if we continue this path, our transaction performance will suffer.
We are looking into a third party indexing solutions. We are talking to Omnidex. Third party indexing solutions claim a dramatic performance improvement for people in our situations.
If any of you are using any third party indexing solutions on oracle, please share your experiences.
Thank you very much, Chuck Chekuri DBA Manager Vizional Technologies, Inc. Santa Monica, CA - 90405
I'm going to ask a possibly stupid question, but what are your bottlenecks?
What leads you to believe that a 3rd party indexing solution will solve your
problem? (I don't know that it will not, but there isn't a lot of data to go
on in the posting.)
Jim This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: David |
last post by:
First, a question.
Is there a way to keep VS.NET from red lining elements from third party
controls with an error message that says 'the active schema does not support
the element ****'? Doesn't Microsoft know that there are third party custom
controls out there? It would be nice to have intellisense for third party
controls' elements and properties as well.
I am looking to get a suite of third party asp.net controls. Getting a...
|
by: Chris |
last post by:
Does anyone have any documentation on compact privacy policy
and asp.net session or http session cookies.
I have a third party app that relies on a session cookie to maintain
the state of my app in a users site.
Currently my P3P policy is causing IE6 to reject my third party session
cookie.
I have my P3P working and do not collect personal info, add headers
|
by: ronnotel |
last post by:
I have integrated APIs from a third party into my framework. The third
party is essentially a .Net wrapper on top of an existing set of C++
classes and structs.
I want to pass-around objects in these native structures as much as
possible - that is I don't want to fool around with object
serialization/deserialization. Data rates approach several hundred
thousand objects per second, hence I simply can't pay the performance
penalty this...
|
by: Ben Finney |
last post by:
Howdy all,
I'm improving an existing application that's partly written using
Python and the standard library. Many of the improvements I want to
make can be done by using third-party free software.
The immediate customer for this application is happy to install Python
on their machine, but I'd like to remove the hassle of asking them to
continually install new versions of great third-party Python software
that isn't packaged for their...
|
by: Daz |
last post by:
Hi everyone,
Sorry about the long thread name, I think that my problem is that I
don't know how to word it, which is why I have been unsuccessful
finding the information I require.
I am trying to execute an html document (to open in the default
browser), but as a result, my program waits for the document to be
closed before my program will terminate. What I need to find is a way
to run a third party app, and for my program to stop...
| |
by: m11533 |
last post by:
I am developing a large application with Visual Studio .NET 2003 using C#. We
recently added a new third party product with a native .NET library. I want
to place this third party product's dll in a VS Project of its own, and then
reference that project from those c# projects in my solution that are
dependent on the third party product.
I created a c# class library project, ThirdPartyDll. Placed the dll file in
question into that...
|
by: Amar |
last post by:
Hi All,
I need to select data from a database table containing huge amount of
data. Now I am storing data using one primary key and I am just using
simple select statement, and this process gives me the output but it is
taking long to execute the query. As much I had heared I want to use
some indexing or cluster indexing which might help me but I am not so
familiar with these things. So if any one having some solutions to
execute the...
|
by: rohitchawla |
last post by:
How is it possible to read the third party cookies if u have a valid p3p policy set in place
I have a server side application that sets the third party cookie and whenever the client visit any site with my js file attached to it, i want to read the values of my third party cookie
Is it possible to read it from client side as my server side can read the value of this third party cookie
|
by: Chuck Chekuri |
last post by:
Hi,
We have a 3TB oracle db. 24x7 operation with data constantly coming in
to the DB. Users from all over the world use a web based applicaton to
query and work on the data.
Out transaction performance is quite good but our query performance
sucks. looking up by ids and some combinations of search critera
return ok but some never return. We indexed the db for a lot of
combinations and we materialized some views and that helped a little....
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |