Gurelei wrote:
Hi.
I found a query with a buffer hit ratio about 60%:
SELECT b.Name, a.Racf, c.Manager, fileds from STATS
table
FROM BT.Stats a, BT.Employees b, BT.Employees c
WHERE a.Stats_Date Between '13-Nov-02' and '13-Nov-02'
and a.Manager = c.Manager and
c.racf = 'RLEWI01' and
Shibu MB wrote:
Hi all...
What are the naming conventions u guys follow when
designing a database ???.Can anybody send me a general document on
this. I am trying to make the attribute name unique in my database
but i dunno what naming convention i have to
It's the count of a certain type of fetch operations of blocks from the
database buffer cache. See Why you should focus on LIOs instead of
PIOs at www.hotsos.com/catalog for details.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic, Dec 9-11 Honolulu
Hello guys,
I need to use two (or more) different client applications from the same
client workstation. Applications use different charactersets WE8PC858 and
WE8ISO8859P1. That's a sort of having different NLS_LANG for each session.
Maybe I can create a specific connect description in listener?
Title: Import from FoxPro to Oracle
Hi ALL,
Can WE IMPORT DATA from DBF files of Fox Pro into Oracle 8.1.7.
If yes how.
TIA
Hussain
Hussain Ahmed Qadri wrote:
Hi ALL,
Can WE IMPORT DATA from DBF files of Fox Pro into Oracle 8.1.7.
If yes how.
TIA
Hussain
I have done something of the kind in the past by writing a program
taking a .dbf file on its standard input and writing a control file
including the data to
Cary,
I read your wonderful article. What is the exact difference between CR and
CU, blocks fetched in Consistent and Current mode?
Regards
Naveen
-Original Message-
Sent: Friday, November 15, 2002 2:54 PM
To: Multiple recipients of list ORACLE-L
It's the count of a certain type of
Hi, list friends:
I wonder if we are using XA to connect to rac database, can i still use oci to
write it? I want to try Transparent failover with rac database so that when schedule
down, i need not bring the whole site down, just reboot one db server and some
middleware, so that my
Title: RE: RE: CONSISTANT GETS
Funny ... that Cary mentioned it
Some developers here think that by setting some magic instance parameters we can make all RBO tuned code run well under CBO ... (I just bought a 6 pack of Mylanta yesterday ...)
Raj
Alexandre Gorbatchev,
I think you can manually trigger alter session set nls_language ...
via some button in your application, or via logon trigger(if 8i+).
Or run os command export NLS_LANG= nls_lang1 etc and run your app:),
export NLS_LANG=nls_lang2 and run your
Hi, dba friends:
The following is what i get this afternoon and want to share my test result
with your friends, and hope to get your opinion about this result.
I am so surprised with my test result of Dell 6650 system vs Sun 3500.We are
running RAC 9.2 on Dell 6650 dual node,
Title: RE: Import from FoxPro to Oracle
Well at least this means that it can be done. But aren't there any tools like Oracle Migration Work bench or the Oracle Migration Assistant for Access . The odbc of WIn2000 doesn't support .dbf files, it goes to .DBC for visual foxpro. So is there any
OH, talk about cruel and unusual punishment!! For the fish that is.
Dick Goulet
Reply Separator
Author: Gogala; Mladen [EMAIL PROTECTED]
Date: 11/14/2002 1:38 PM
Well, once upon a time there was an event called Boston Tea Party
which dealt with too
All,
I have shutdown my database(but not the listener).
I notice that I have a number of kproc processes owned by oracle.
Why?
John Dunn
Sefas Innovation Ltd
0117 9154267
www.sefas.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Dunn
Hi, Anybody know how to combine multiple databases metrics into one
analysis chart? Thanks a lot.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
--- Stephane Faroult [EMAIL PROTECTED] wrote:
- How many rows does your query return ? If it's a
huge number I would
feel more comfortable with table scans than index
accesses in the plan.
It returns 8 rows in about 2-2.5 seconds.
- You seem to feed three things into your query,
Title: RE: RE: dumping microsoft desktop?
Mladen,
Actually the Boston Tea Party happened for the opposite reason. The tea on the ships was of LOWER price because it was not taxed. The 'patriots' owned tons of tea stored in warehouses that they could only sell at a profit with higher prices
Hi,
I installed oracle infrastructure 9iAS 9.0.2 on a
system (Redhat Advanced Server 2.1) where I am already
using a Oracle9i DB.
It installs successfully other than during database
creation instance and shows an error saying Database
Name not proper ORA-02084
But the database instance is
Foxpro has a upsizewizard to move data into an oracle database.
[EMAIL PROTECTED] 11/15/02 06:03AM
Hi ALL,
Can WE IMPORT DATA from DBF files of Fox Pro into Oracle
8.1.7. If yes how.
TIA
Hussain
We are testing the ORACLE 9iR2 client server connection. On PC side, we
installed ORACLE ODBC driver 9.2.0.2 and upgrade MS ODBC for ORACLE to
2.573.9001.000. After configuration, ORACLE ODBC driver work fine, but MS
ODBC for ORACLE have ORA-12154 (TNS name can NOT resolve) error. I
trouble
Any Good Docs , Links , sources ?
Need to present a paper to the Managers
Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: VIVEK_SHARMA
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
See alter session set nls_language in the SQL Reference manual.
Reply Separator
Author: Alexandre Gorbatchev [EMAIL PROTECTED]
Date: 11/15/2002 2:58 AM
Hello guys,
I need to use two (or more) different client applications from the same
client
Dennis:
OEM calculates the BHR for all the queries. I presume
it is being calculated using the same formula but only
using the disk reads and buffer gets for the single
query. I started with this query because it has the
lowest bhr in the database.
--- DENNIS WILLIAMS [EMAIL PROTECTED] wrote:
Raj,
I needed a 12 pack adter this one, it's from PeopleSlop:
SELECT 0001560265,OPL.BUSINESS_UNIT,OPL.PRODUCTION_ID,OPL.OP_SEQUENCE,
PID.INV_ITEM_ID,TMP.COST_ELEMENT,'04',0,0,0,0,0,0,PID.ORIG_UOM,PID.PRDN_AREA_COD
E,
PID.PRODUCTION_TYPE,OPL.QTY_SCRAPPED,OPL.PERCENT_COMP,' ',1,0,'
Tools like Powerbuilder/ Access can be used to import dbf files to Oracle
tables.
HTH
Sumathy Panicker
-Original Message-
Sent: Friday, November 15, 2002 8:54 AM
To: Multiple recipients of list ORACLE-L
Well at least this means that it can be done. But aren't there any tools
like
David - I really hope you succeed. I feel the key is your users. As an I.S.
person the differences between genuine Microsoft and these knock-offs may
seem small compared to the benefits. However, if this isn't carefully
explained to the users, they can easily revolt against what they view as
Has anyone heard of or experienced a successful
implementation of Advanced Replication between an
8.1.7 database and a 9.2.0 db?
__
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site
http://webhosting.yahoo.com
--
Please see the
Dick,
it's a beauty thing...
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, November 15, 2002 10:34 AM
To: Multiple recipients of list ORACLE-L
Raj,
I needed a 12 pack adter this one, it's from PeopleSlop:
SELECT
-Original Message-
So, what is the advantage of Sun? Redhat Advanced
server and 920 is also so much stable, and Sun T3 disk array
is also of poor performance. CPU poor, disk array not that
good, why sun?
--
One
Hi,
I think you can manually trigger alter session set
nls_language ... via some button in your application, or via
logon trigger(if 8i+).
No that will not set client's characterset.
Or run os command export NLS_LANG= nls_lang1 etc
and run your app:), export
List,
There was a question as to how to identify objects that will fail to extend?
This is what we do.
SELECT owner, tablespace_name, segment_name, next_extent
FROM dba_segments ds
WHERE tablespace_name != 'TEMP'
AND next_extent ( SELECT max(bytes)
FROM dba_free_space
Title: RE: RE: RE: CONSISTANT GETS
I've seen worse. My programmers don't know how to use NOT EXISTS even though I've explained it many times. And that's the least of my problems. Look at this mess:
SELECT *
FROM sar.pax_header_suspense_err_temp
WHERE manifest_type
||
Title: Import from FoxPro to Oracle
Hussain,
It's easy to
generate text files with delimiters from FoxPro and then load them with SQL
Loader.I did it 4 years ago for FoxPro 2.6 for DOS and that still works
there. I know you may do it directly from dbf's but this is not so
straightforward.
Dick,
I have already thoroughly RTFMed on this issue, but didn't find anything
suitable using ALTER SESSION SET NLS_*
Please, correct me if I'm wrong.
NLS_LAN consists of 3 parts: language, territory and characterset. Language
and territory can be set/changed at session level as parameters
Hussain - One thing to be aware in generating text files from FoxPro is that
Microsoft tends to be inconsistent with delimiters. Sometimes it thinks it
needs a delimiter, and sometimes it doesn't write a delimiter. Inconsistency
is hard to deal with. Often I find it is easier to deal with
Can WE IMPORT DATA from DBF files of Fox Pro into Oracle 8.1.7. If
yes how.
Take a look at the Perl DBI. You'll need the DBI package, and the DBD
modules for xBase and Oracle. There are many examples of use out there
on the Internet. You may also want to investigate the [somewhat
helpful]
Oracle 8.1.7.0.0 on Win2k (4 CPU, 4GB RAM)
A 3rd Party app. is experiencing very slow performance on one of our
databases. I think I've nailed it down to slow, row-at-a-time inserts.
The same app. performs very fast on another DB with LMTs. After switching
the tables and indexes in the slow DB
-Original Message-
I am also having a weird performance issue with a sun box - mine is a new
v880 4 cpu (900mz) with 16g of ram and a 2 T hitachi san.
-
My first suspicion would involve the SAN. We have one system here that, for
whatever reason, (sorry, I'm not
I am also having a weird performance issue with a sun box - mine
is a new v880 4 cpu (900mz) with 16g of ram and a 2 T hitachi san. For example -
I do an import of a table (partitioned 3 m rows ) and it takes almost 8 minutes
vs 3 minutes on my laptop. both running 9.2.0 . many reports take
Title: Performance consequences from downgrading from 64-bit to 32-bit?
We have an 8.1.7.4 64-bit 24x7 OLTP database currently hosted on an RS6000 s80 running
AIX 4.3.3 The database is scheduled to be migrated to a new box, RS6000 ip680, running
AIX 5.1. According to the compatibility matrix
We experienced the same problems at my work where dual P3 Xeons running at
1.133Mhz (Compaq Proliants) outperformed a SunFire280R 2:1 in I/O performance.
This means that the Proliant had twice more throughput than the 5x more
expensive Sun. I don't understand this and I have no explanation from
[EMAIL PROTECTED] wrote:
Oracle 8.1.7.0.0 on Win2k (4 CPU, 4GB RAM)
A 3rd Party app. is experiencing very slow performance on one of our
databases. I think I've nailed it down to slow, row-at-a-time inserts.
The same app. performs very fast on another DB with LMTs. After switching
the
On Fri, Nov 15, 2002 at 05:59:06AM -0800, [EMAIL PROTECTED] wrote:
OH, talk about cruel and unusual punishment!! For the fish that is.
It is interesting that so many people feel this way and yet the topic
is reduced to joking, as if it is not possible (or really desirable) to
replace
I have a request from a developer to determine if a column is computed,
has a primary key
has a foreign key.
Im looking through the dictionary tables eg user_tab_columns but these
firlds seem to be elusive.
Any ideas what views to querry ?
Many thanks
bob
--
Please see the official ORACLE-L
Stephen Lee,
To tell you the truth, sun 4500 is the most high end sun i have ever
touched:), so i do not have experience on concept like partition etc.
And talking about that excellent High Avaliable feature like
CPU/Memory corruption and the server still run,that
Jerry,
I suspect that the improvments are more likely due to your
rewriting the WHERE clause rather than the use of NOT EXISTS.
Especially if the database were 9i, where NOT IN actually
seems get a better execution path than NOT EXISTS.
That original WHERE clause is really a piece of work.
The Parse statistics are what caught my eye. The statement is being
parsed once per execution, which is puzzling because it does use bind
variables. Of more concern, though, is the difference between CPU and
elapsed times for the parsing, indicating that there is a lot of
waiting going on. I'd
Tom,
There aren't no beauty where the sun don't shine!! And that's where I
parked this one!! *-)
Dick Goulet
Reply Separator
Author: Mercadante; Thomas F [EMAIL PROTECTED]
Date: 11/15/2002 7:54 AM
Dick,
it's a beauty thing...
Tom Mercadante
Thomas Jeff£¬ÄúºÃ£¡
The main problem i think is that 32bit oracle has its sga size limit, if i
remember it correctly, it is only 1.75GB, which is not big enough for oracle running
on S80?
Maybe you can relink it to enlarge sga, i ever see document about
enlarge sga via
I checked for invalid objects and two of them came up. When I tried to
recompile them it says there was compilation errors. Yet show errors
doesn't show anything. Does anyone have familiarity with this particular
package or have an idea on how to fix this so it is valid?
SYS
Thanks, but the next extent is the easy one. As I mentioned, I'm already
running a similar query hourly.
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
From: [EMAIL
-Original Message-
And talking about that excellent High Avaliable
feature like CPU/Memory corruption and the server still
run
Maybe I should clarify. If you lose a memory module, the box will almost
certainly reboot itself and come back up with the memory module
Alex,
Humm, it would appear that you are right. After looking through the manuals
and MetaLink it appears that the only why you can change the charecterset is at
the client by updating the nls_lang environment (or registry if windoes)
setting. Seems that characterset is specifically for how
Ray,
Sometimes humor is the best medecine when one feels powerless. I for one
would love to dump this M$ desktop infavor of a Lindows or Linux desktop. But
we all have to suffer with the lack of applications that support those
platforms. Hopefully in a couple of years, now that Lindows is
Take a look at dba_cons_columns for primary and foreign key constraints
Jay Miller
-Original Message-
Sent: Friday, November 15, 2002 11:59 AM
To: Multiple recipients of list ORACLE-L
I have a request from a developer to determine if a column is computed,
has a primary key
has a
Bob,
Take a look at tables like user_constraints and user_cons_columns - the
constraint_type column would
definitely tell you whether it is a primary or foreign key, I am not sure
about computed.
HTH
Sumathy
-Original Message-
Sent: Friday, November 15, 2002 11:59 AM
To: Multiple
In my experience, show errors is unreliable. Select from
dba/all/user_errors instead.
--- Eric Richmond [EMAIL PROTECTED] wrote:
I checked for invalid objects and two of them came up. When I tried
to
recompile them it says there was compilation errors. Yet show
errors
doesn't show
try
SHOW ERRORS PACKAGE BODY DBMS_REPCAT_RGT
show errors may be showing there are no errors in the package spec!
Kevin
-Original Message-
Sent: Friday, November 15, 2002 12:40 PM
To: Multiple recipients of list ORACLE-L
I checked for invalid objects and two of them came up. When I
Look at DBA_CONS_COLUMNS
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, November 15, 2002 11:59 AM
I have a request from a developer to determine if a column is computed,
has a primary key
has a
Actually, I know that IBM has some boxes with redundant (RAIDed -- their
term) memory, although I don't know which class of machine.
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original
I had some issues on an import lately with replication packages. I have
recently gone from 8.1.7.3 to .4 and some of the packages would not compile.
The solution was to run repcatr.sql, repcat.sql and utlrp.sql.
-Original Message-
Sent: Friday, November 15, 2002 12:10 PM
To: Multiple
Hold the press. NOT IN better than NOT EXISTS? Is this theory or fact? If
so is there any supporting evidence out there? This is the first I have
heard of this.
Thanks!
-Original Message-
Sent: Friday, November 15, 2002 11:35 AM
To: Multiple recipients of list ORACLE-L
Jerry,
I
Quick question, Does anyone know of a location in the V$ tables where the
elapsed time of the current query is stored??
Dick Goulet
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
Naveen,
A CU block is fetched as-is; whatever's in the block at the time of
the read is what comes back from the LIO. CU mode is used when read
consistency is not an issue; for example, when reading your own
(private) sort blocks. I think if you DELETE without a WHERE clause,
you'll see CU blocks
And a note: Using bind variables is a necessary step but not a
sufficient step toward eliminating parse CALLS. Using bind variables
will only reduce the number of misses in the library cache (parse count
(hard)).
If the application still puts the parse call inside a loop, it still
gets the parse
Title: RE: CONSISTANT GETS
Jared,
I'm still on 7.3.4 but I'm sure that you are right about the WHERE clause in this case. It went from an INDEX FULL SCAN to an INDEX UNIQUE SCAN on the same index once the blasted concatenations were removed. One programmer says he likes to write it that
Is something dropped from that database relating to that package body?
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Fri, 15 Nov 2002 09:40:22 -0800
I checked for invalid objects and two of them came up. When I tried to
How can you tell if catrepad.sql has already been run on a database? I am
sure that catrep has already been run, but not catrepad.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Eric Richmon
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
If PCT_INCREASE is set to 0, then can't we simply compare
next_extent*2 ( sub-query )?
-Original Message-
Sent: Friday, November 15, 2002 12:40 PM
To: Multiple recipients of list ORACLE-L
Thanks, but the next extent is the easy one. As I mentioned, I'm already
running a similar
Look at DBA_CONS_COLUMNS
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
I see, thank you
select uc.constraint_type, uc.constraint_name, ucc.column_name,
uc.search_condition
from user_constraints uc, user_cons_columns ucc
where uc.owner = 'BOB' and
uc.constraint_name
I read that any given object can be in only one replication group. We already
have SNAPSHOT replication running from Server A to Server B. Now we want to
set up ASYNCHRONOUS replication to run from Server A to Server C. How can
that be set up so there isn't a conflict if the objects can only be
Whittle Jerome Contr NCI wrote:
Jared,
I'm still on 7.3.4 but I'm sure that you are right about the WHERE
clause in this case. It went from an INDEX FULL SCAN to an INDEX
UNIQUE SCAN on the same index once the blasted concatenations were
removed. One programmer says he likes to write it
Jerry,
I'll take better performing over nicer looking anyday.
Dick Goulet
Reply Separator
Author: Whittle Jerome Contr NCI [EMAIL PROTECTED]
Date: 11/15/2002 11:34 AM
Jared,
I'm still on 7.3.4 but I'm sure that you are right about the WHERE
Why not open the script up find an object created with that script ...
then log onto your database and see if the object is there. ?
-Original Message-
Sent: Friday, November 15, 2002 1:39 PM
To: Multiple recipients of list ORACLE-L
How can you tell if catrepad.sql has already
Hi all,
My developers are using a 9iR2 client and need to run exports
against a 9iR1 instance. Has anyone seen anything like this?
I seem to remember a descussion at one point saying that it
was possible to run the catexp from a later version in an
earlier release and have this work. We would
You can run asynchronos rep from server A to C, then
run a snapshot to B off of C (have C be the master to
B)
Make sure you have conflict resolution set-up!
--- Eric Richmond [EMAIL PROTECTED] wrote:
I read that any given object can be in only one
replication group. We already
have SNAPSHOT
Nope. If a segment has a NEXT EXTENT of 20M and the two largest contiguous
free spaces in it's TS are 30M and 15M, the second extent (i.e. two extends
to that segment) would fail, but would not show up in the query. That's
what spawned the complexity of my SQL.
Rich
Rich Jesse
Hi,
I read
somewhere that .NET application will only be supported with SQL
Server.
Is
this true or it can be run with any other database like
Oracle?
Thanks
--Harvinder
This is what I ended up doing...
select decode(constraint_type,
'C', 'Check Constraint',
'P', 'Primary Key',
'R', 'Foreign Key',
'U', 'Unique ',
'V', 'With Check Option for view',
'undefined')
constraint_name, column_name,
Catching up on e-mails ...as usual :-(
and I noticed no one had answered this question.
The ORA-3232 is usually not related to tablespaces
but to the relationship between the size of your
temp tablespace INITIAL and NEXT extent in relation
to sort_area_size (and hash joins).
This hit me not too
Does anyone on this listserv using Oracle on a mainframe?
I was asked today if I can use Oracle's extproc feature on the mainframe to
submit JCL. I said that I doubted it because the OS structure is so much
different than UNIX or NT, but I would look into it.
Has anyone tried to somehow have
I just found out today that we have a major development initiative that is
starting and they are planning on using Pro*Cobol to develop the
application. (my head is still shaking in disbelief!!!)
So we will have a Java front-end, invoking MQ series that will go across to
the mainframe for MQ
We have done something similar at our Ottawa
Oracle User group (for our DBA / Developer Day).
Over the past few years we have had many excellent
speakers come and present. However, in thinking about
them, I doubt they would have felt comfortable in
responding to this kind of e-mail. (perhaps
A while back someone mentioned that the two main causes of slow SQL are
excesive LIO's and excesscive database calls, which show up as excessive CPU
use and excessive network traffic, respectively.
Regarding the database calls, is there a classic reason for this problem?
My best guess is it's
Hold the press. NOT IN better than NOT EXISTS?
If so is there any supporting evidence out there?
I think you're joking, but if not there's a nice comparison chart of several
tests in Harrison, p. 268.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Greg Moore
Okay. Let me try this!
The largest column will have the biggest extent size that the tablespace can
accommodate next time. You might save this information in a temp. table and have the
other query to check against this.
select substr(a.tablespace_name,1,20) tablespace,
Title: Event 10046 and Performance
Okay ... here is a curved ball ...
This AM an application support person called and mentioned that we have a form that has become slow compared to 2 days ago. So we saw the slow behavior and then I did a 10046 trace on it.
After analysis, found that one
Hi, Has anybody experience the discrepancy between capacity planner and
statspack? Thanks.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California--
Harvinder - My experience is that Microsoft will try to imply that, just
like an Oracle sales rep will try to imply that Oracle works better with
Oracle9i AS. But the fact is that if Microsoft enforced that rule, it would
be excluded from a lot of big accounts that have a lot more committed to
Ethan,
A NOT EXISTS can be very expensive if returning large numbers
of rows from the driving table. It's a correlated subquery as
Stephane F. pointed out in another post.
Jared
Post, Ethan [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/15/2002 10:32 AM
Please respond to ORACLE-L
Are you using AIO? Then these may be AIX processes that are started by the
kernel (kproc - kernel procs) on behalf of 'oracle'. Are you sure that they
are owned by oracle. If so, can you shut the server down?
John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002
What would you see
Arrived on the last day, in time to see (free):
-- Ellison's talk
-- The Quest booth and a good demo of their products
-- Oak Table (I guess it was oak) and meet Mogens N., who was basically a
nice guy, but did play a little trick when he pointed out the elaborate
high-tech security system that
Greg,
I believe that the cultural root cause of the excessive LIO problem is
the conception that physical I/O is what makes databases slow. Disk I/O
certainly *can* make a system slow, but in about 598 of 600 cases we've
seen in the past three years, it hasn't. [Why you should focus on LIOs
Title: Event 10046 and Performance
Ah, the secret power of
event 10046 reaches the light of day at last!
J Just kidding Is there a chance that its coincidence,
that some workload variation that causes poor performance just happens not to
have occurred since you instrumented the form?
Microsoft has a .Net provider as well as Oracle ODP (OTN under Windows).
In my experience if you want to use the following data types use Oracles, if
not use Microsofts.
1) CLOB
2) BLOB
3) BFILE
4) XML Data type
The Oracle ODP does not allow you to build the Procedures or Functions
Parameters so
Hello All,
Is resizing the datafiles the only way of reducing the size of an RMAN full
backup? Oracle Version 8.0.6. We take RMAN hot backups to disk, and the
size of the backup has grown considerably. There's one large table which we
were considering truncating. But looks like that would not
Hi All !
I am new to Oracle Developer Application Tuning
i have the following queries:
0) where how to start?? the key areas in application tuning.
1) the tips techniques..
2)useful tools scripts
3) othere resources [docs, websites etc]
Best Regards
Do you Yahoo!?
Yahoo! Web Hosting - Let the
98 matches
Mail list logo