Oracle

Differences in Range Scan Performance between Binary and NLS Indexes
I have a table set with about 340k rows in it. User's execute queries against this table for arbitrary search strings which are resolved against the name table in the column. The table contains mixed case, but the users expect to match their search regardless of case. So, for example, both of these should match a s... 7 May 2008 15:53

Oracle8.1.7 : Very high CPU load but NO alert.log record
Hi, two of our DB server suffered very high CPU load today. we could not identify the exact reason for it. We run a main DB whose table content update frequently. Both of the two questionable servers maintein Snapshot of main DB, they refresh snapshot every 5 min. The OS of two stallite server is HP ... 6 May 2008 22:21

Grid control problem
We recently migrated several servers from one physical location to another. The host names remained the same but the IP addresses changed. Accessing any of those servers or the databases on them from Grid Control now is painfully slow. It can take 15 minutes to bring up the home page for either the databases or... 6 May 2008 22:21

moving tables from system tablespace
On 4ÔÂ30ÈÕ, ÉÏÎç5ʱ25·Ö, GS <G...(a)GS.com> wrote: Checking out a new vendor installed database I see that there are several tables residing in the system tablespace, non have any LOB or BLOB columns. There is also a few indexes that have somehow ended up in the same tablespace. Having never had to use "alter... 6 May 2008 22:21

EXPDP consistency error
On 5ÔÂ1ÈÕ, ÏÂÎç6ʱ22·Ö, gazzag <gar...(a)jamms.org> wrote: On 30 Apr, 21:38, macdba321 <macdba...(a)gmail.com> wrote: I exported a large schema using EXPDP today for the first time. When I IMPDP'd it into another server it imported fine. No errors. The application we use started giving a few errors, an... 6 May 2008 22:21

Hot Shop Swatch Chronograph Watches - Swatch Minimum Price
Hot Shop Swatch Chronograph Watches - Swatch Minimum Price Hot Watch Shop : http://www.hotwatchshop.com Swatch Watches : http://www.hotwatchshop.com/Swatch-Watches.html Swatch Chronograph Watches : http://www.hotwatchshop.com/Swatch-Chronograph-Watches-Watch.html Swatch Chronograph Watches All Products : Swa... 6 May 2008 22:21

DBPITR and ORA-16005 Error: database requires recovery.
On May 2, 7:04 pm, "gba...(a)ravenpack.com" <gba...(a)ravenpack.com> wrote: Hi, I am trying to test database point in time recovery scenarios in which I want to Open read-only the database before using RESETLOGS clause. The test was ran on a Oracle 10gR2 single instance. 1) Perform backup using RMAN ... 6 May 2008 23:24

Welcome back HJR
On May 3, 10:38 am, hpuxrac <johnbhur...(a)sbcglobal.net> wrote: On May 2, 8:37 pm, hpuxrac <johnbhur...(a)sbcglobal.net> wrote: He's alive and posting and well putting out scripts and offering downloads that don't require passwords. I for one wouldn't count on this being permanent so if you find ... 6 May 2008 22:20

Oracle 10g Express Connection Limitations?
On May 6, 10:34 am, yossarian <yossaria...(a)operamail.com> wrote: Jason D. wrote: I used Oracle 10g XE a lot last summer and will likely be using it again this summer. My database is essentially for experiment purposes and most connections to it are VIA ODBC. I noticed last year after so many (lik... 6 May 2008 22:20

HELP - Oracle 8.05
On May 6, 9:39 am, Closerwalk <closerw...(a)gmail.com> wrote: On May 5, 10:25 am, "fitzjarr...(a)cox.net" <orat...(a)msn.com> wrote: On May 5, 11:39 am, Closerwalk <closerw...(a)gmail.com> wrote: On May 1, 12:17 pm, hpuxrac <johnbhur...(a)sbcglobal.net> wrote: On May 1, 1:49 pm, close... 6 May 2008 23:24