 | | | Oracle List | | The problem is that it 's another layer of software that you have to go through on the client side. I 'm not exactly sure what happens inside the ODBC layer but the developers here have recorded delay
Create a table with 5 000 rows e.g.
create table t1 as
select object_type rownum n from all_objects
where rownum < 5000
select count(*)
select sum(n)
select avg(n)
Executi
OK I 'm just going to bite the bullet and claim total
ignorance here and see if someone takes pity on me (
(sad face a nice touch eh?)
Someone has accidently updated 378 records in the
custoI am having trouble using stored outlines. I have created an outline and I can see it in DBA_OUTLINES and see the plan in DBA_OUTLINE_HINTS. When attempting to run the stored_outline I do an "alterOn 03/23/2004 01 05 14 PM Carel-Jan Engel wrote
> Be sure your temporary tablespace is
> - temporary -)
> - locally managed
> - contains only temporary files
>
Sorry the point of the laIf I understnd correctly the validate command only verifies that the database can be restored to a consistent state bsed on the latest level 0 backup assuming incremental backups are used. It doesSomething like this ought to do it
create table test_user(userid varchar2(2) refdate date)
insert into test_user values( 'U1 ' to_date( '6/3/03 2 27 ' 'mm/dd/yy hh24 mi '))
insert into test_user valI want to see the "wait events " along with my cost for a particular query.
My environment
Sun Solaris (SUNOS 5.9)
Oracle 9.2.0.7
TIMED_STATISTICS is not set in the parameter file....
So I am doi
what I did (regardless of what I should or shouldn 't) was
made a cold backup of a 92030 instance. for the sake of explanation call it DEV-site
moved it to a 92040 site let 's call it PROD-sitEven if there is DB2 (UDB) CPU licensing it 's still significantly cheaper
then Oracle. For two small tables DB2 will perform more then adequately.
In addition to that the last time I checked IBM
You don 't have CPU usage in the stats.
The second run may be using far more CPU
than the first despite doing less latching.
Regards
Jonathan Lewis
http //www.jlcomp.demon.co.uk
The Co-oHi!
I have a SQL*Plus script that rolls back whenever an error occurs
... whenever sqlerror exit SQL.SQLCODE ROLLBACK
Is there a way to get an exit code AND roll back when an error occurs?
On 03/23/2004 01 41 10 PM Chris Stephens wrote
> I wholeheartedly agree. ...but I think it is also true that even among
> non-dba types the legitimacy of the ocp is declining
Can we talk aboHi All
DB 9i
Oracle apps 11.5.9
We have installed 11.5.9 oracle apps (vanilla version) from CDs. Now we want
to bring it to current patchlevel.
Can somebody through some light on thisThanks for sharing the info.
GovindanK
On Fri 19 Mar 2004 12 29 31 -0600 "Jesse Rich "
<Rich.Jesse@(protected) > said
> Always always ALWAYS have at least one of your control files sYep it works fine. And the advantage of having context variables is that they can be accessible globally in all sessions in an instence.
Tanel.
> Remember this?
>
> Instead of using packSeems like you should be able to do this by setting up 10g OEM...
I 've only installed 10g on Red Hat ES 3.0 so far and explored the default
web page administration for a single instance. By the
--- "Jesse Rich " <Rich.Jesse@(protected) >
wrote
> Came across this while debugging Oracle
> (dis)connections with "tusc " on
> Oracle 9.2.0.5.0 / HPUX 11.11 (apparently similar to
> "truLarry
One *small* modification that you might want to do Modify TRCAREPO.sql to
change the type of larger tables from permanent (default) to GLOBAL
TEMPORARY. You will find that the data is useHuascar
Are you on Unix or MS? Was the file you are loading created on Unix or
MS? Are you loading variable-length data or fixed-format?
Dennis Williams
DBA
Lifetouch Inc.
dwilliams@(protected)
Check
http //www.dbazine.com/jlewis17.shtml
Regards
Jonathan Lewis
http //www.jlcomp.demon.co.uk
The Co-operative Oracle Users ' FAQ
http //www.jlcomp.demon.co.uk/faq/ind_faq.html
Denise
Well just when you think you 've heard it all! After all the talk about
password security and ensuring passwords are changed regularly. I couldn 't
follow your description completely so I1) Ken you will find more help in a windows admin forum
2) selecting 'best performance ' does not typically fix memory leaks.
"Juan Cachito Reyes Pacheco " <jreyes@(protected) >
Sent bThat depends on the version and whether or not you specify UPDATE GLOBAL
INDEXES
With it "Oracle updates the global indexes on the table whose partition is
being exchanged. Global indexes on theWhy is it "horrible "?
What 's wrong with this quote from oracle docs?
Igor Neyman OCP DBA
ineyman@(protected)
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto orThere was a different named thread on this topic just last week. The
primary answer is it depends on how much data will exist in the initial
load how much data will be added in X time and what tythought I know how people feel when they get that error...
just about an hour ago
1. I get an email stating that an object doesn 't exist. It 's because the developers are looking in the wrong daOK here is the alternative http //www.obdev.at/products/sharity
Now stand still how do you think I 'll be able to shoot the messenger
if you keep moving around.
On 03/22/2004 12 32 34 PM ApMichael
It should be in the alert log. That 's where I found my errors. Check your
init.ora BDUMP parameter to make sure you are looking in the correct place.
You can always start commentinYes that 's true. One thing to remember when talking about developers is
that work liberates or in German "Arbeit Macht Frei ". Good organization
is the final solution of the developer problem. Of |
|
|
