 | | | Oracle List | | Tony
Some basic questions
Is this a common problem? Or did it happen just this one time?
What is the application configuration?
Would it be possible to get more lines from the trace file?
I > 1. ... is better to have only one return
That is not necessarily true.
It depends on which guru you listen to.
Steven Feuerstein says 'only one return '.
Larry Wall says 'why? '.
I agreeFYI
MS Security bulletin may cause Oracle 8i to hang on startup.
http //support.microsoft.com/default.aspx?scid kb en-us 841180
Seema
It is quite normal to have free memory to hover around this low.
Read on if you are interested in knowing why.
From Solaris 2.6 onwards Virtual Memory Manager will use as much
as memory avHi
How much maximum SGA we can allocate if MEMORY on SUN Solaris is 1.5gb?
When sga alloacted to 220mb top command show 46mb free.when I bumped sga to
225mb it 's still showing 46m is free.
th
What do you mean by 'working ' ?
Column usage monitoring is enabled by
default. It doesn 't "do " anything it simply
exists so that the AUTO option for generating
histograms has some data of whiThere are none. People stopped writing them because the market is small. I liked Paul Dorseys advanced forms and reports books but its not a 'how to use forms or reports book '.
Most of them are prHi all
I will be taking a training class on Oracle Reports for Oracle 10g
and I just finish taking a training class of Oracle Forms for Oracle 9i.
Now I am a beginner and I want to get a book Hi
I am using a global temp table in my application and doing a sort on that. Generally the temp table size is small (within 100 rows) but in really exceptional once in a month cases it can go up I 'm testing an update process using MERGE. For reasons too complicated
to go into (can you say "corporate politics "?) I have a login app in
one database and the "real " admin users tables in another > Now when a run a 10046 level 12 trace on my test program (which does
1000
> such inserts) I see that it executes the SELECT 1000 times but fetches
> 2000.
Mike
I don 't know the answer to Even when I tried it before when I saw a function called recursively
several times I tried to encapsulate as a subquery but I didn 't got an
important improvement
The trick comes from Connor McDoHi David
I think the function is part of an 'emerging standard ' called SQL/XML
(http //www.sqlx.org/) and may not behave the like native Oracle
functions where we can interchange literals with varia
Latch Free as the wait event due to
increased activity on the various library
cache latches and the shared pool latch.
You would also see extra CPU usage
because of the extra latching.
Hi
I 'm trying to install htmldb on a 9.2.0.4 database. I get invalid
username/password on
the second screen htmldb configuration. This must be either for sys user or
htmldb
Listener.log confijust in case this doesn 't fix the dbase id thing there is a command line
tool to give a database a new db id. 20
rman 's duplicate does it without furhter tweaks. check it out in
Metalink. 20
I checked it out again (dinkum). This is the ORA-00600 lookup tool. I just
saw that there are some "D " that shouldn 't be here in the link.
If you can 't access pls understand I can 't simply copActually why do you need rman? If you use the the cloning tool
known as "cp " or "scp " if the clone needs to be on another node
you can get the desired result with a FS-based database. The DBID
Hi
I 've a table that stores pdf doc html images in blob and I 'm using
Forms9i to display the files.
The records look like
fileid filetype filename
1 word mydoc.Are you using Java and XML on 8.1.7? As far as I can remember
it was caused by some java soft limit but I wasn 't the
guy that fixed it. I remeber thqat there were some bugs
in 8.1.7 and I even
Hi
I have installed NET 8 and I want to install SQL*Loader. Is it possible
to install only this utility? How?
Thank you!
Hu E1scar
Shouldn 't make a significant difference.
The undo and redo would only be about
the data dictionary.
There may be some versions of Oracle where
the different actions produce a different number
Clearly someone from Oracle has been reading
my seminar notes - chapter 11 page 7 I think.
I think it great !! Now if only they change
autotrace so it doesn 't do the delete bit
and waste resoThis paper seems to have a likely explanation for a sudden performance
hit when developers did a 10x number of calls to the database in an
application (most calls return 0 rows).
http //developerCould that be the "common subquery elimination " optimization bug?
I believe it was supposed to be fixed in 8.1.7.4.
Try setting optimizer_features_enabled 8.1.6 and see if that makes a
difference.Ron
I have WS_FTP pro installed on my desktop and I can see all of the 4
GIG files on my server. Check out www.ipswitch.com There is a free
version available but for the small price I purchasedA few weeks back I posted a question about the reason for having
multiple Listeners. Well I found a big one
On HP-UX we 're preparing to move our 8.1.7.4 DBs to 9.2.0.4/5 so we
installedGuys
I have been coding stored procs in SQL Server - not by choice - but by
wanting to be employed - so......
I am using a cursor variable to go through each row and verify values of
certai
Are you connected as SYS ?
Until 9.2.0.X (where X is somewhere
around 2 or 3) autotrace doesn 't collect
statistics other that row counts for SYS.
Regards
Jonathan Lewis
http //www.jlcompBased on the error information for the listed codes it would appear that
Oracle should clean this up given some time. Did Oracle manage to clean
this up or are repeated error messages showing in th |
|
|
