 | | | Oracle List | | The most significant thing in dba_ddl_locks is
the x$kgllk structure which is the thing that
associates sessions with the objects in the
library cache that they are interested in.
Technically I tHello
I have a table with 2 text columns (varchar2(80) varchar2(4000)) and about
10 numeric colums (and some unreleated to this post).
version 10.1.0.4 linux 2.4
Our users can search with the moscopy the statistics from the dev/tst database to production
1) on dev/tst run dbms_stats.export_schema_stats
you need to create the stattab table if you have not already done so
Notes in-line
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
March 2004 Hotsos Symposium - The BThe internet is asynchronous.
"Juan Cachito Reyes Pacheco " <jreyes@(protected) >
Sent by oracle-l-bounce@(protected)
03/03/2004 02 01 PM
Please respond to oracle-l
All this looping is making me nauseated
)
"Juan Cachito Reyes Pacheco " <jreyes@(protected) >
Sent by oracle-l-bounce@(protected)
03/03/2004 01 07 PM
Please respond to oracleBefore using an element in the collection you should extend collection
(initialize collection element)
First
Tabla.EXTEND
Then
Tabla(1).ntotal 1
And so on...
Igor Neyman OOn 03/03/2004 04 30 33 PM Tanel P?der wrote
> Google is really a killer app at least for me.
>
Now we know that Google doesn 't use Intermedia. Shame on Google.
We have a low transaction oltp here that we replicate via mv 's to a
reporting database.
We have a refresh group set up to refresh all mv 's every 2 hours.
We have log tables on the base tabSai
I recall others on the list mentioning something similar with Netapp.
Something inherent in the Netapp design. I would google oracle-l netapp and
read the old threads.
The other possibiElain
This code is ugly but should work with 8.1.6+. Be aware that the code may
perform horribly and the best solution is a pl/sql block.
** This is the return_name.sql script referenced **
Juan - Metalink has an ORA-00600 lookup feature. I tried it and your error
wasn 't there. I think you need to file a TAR and see what Oracle has to say.
When you file the TAR the ORA-600 lookup willEd
After quite some analysis my evaluation team is leaning toward the
following tools
Golden32(Benthic)
http //www.benthicsoftware.com/down/goldensetup57418.exe
35/-)
Active+lite(IrajeWednesday March 3 2004 7 13 28 AM Jesper Haure Norrevang (jhn.aida@(protected)) wrote
JHN > By the way On MetaLink Kathy from Oracle Support
JHN > Services is asking you what the solution was.
JHNHi List
I did not find any one document that
guides you thro ' physical standby
database configuration (maximum protection).
So i 've gathered info ' from the docs and
some metalink notes and
Check dbms_stats.convert_raw_value.
I don 't know when this set of procedures
was introduced but they can be used to
take a raw input (e.g. your c403135456)
and decode it into a variable of thNote that mirroring can also be done in the LVM layer. Though I 've used LVM I 've never implemented mirroring but it is supported. Also SuSE published a most excellent whitepaper covering LVM rawGene
In a read only database I would be surprised if you generated *any* archive
log files. So asking if they would be usefull during a recovery is
non-sensible.
As to whether it should beHi
Is it possible to post the listener.ora (with hostnames blanked out of course).
Niall Litchfield
Oracle DBA
Audit Commission
+44 117 975 7805
> -----Original Message-----
> From sjaffHi
Some time back someof you asked me to send the cook book for loading
9iAS on Redhat 7.1 so this is it Plz be carefull while using the said
method though I use this for Prod server setup but stGudundur - How are you backing up the datafile? What is producing the error
- Oracle? Do you receive an error message? If so please post.
Dennis Williams
DBA
Lifetouch Inc.
dwilliams@(protected)In version 10 one doesn 't need to use dbms_support (although the file to create it exists)
there is the following procedure
DBMS_MONITOR.SESSION_TRACE_ENABLE(
session_id IN BINARY_INTEGHi
I am trying to load Oracle 10g in a RH9 Box having 256Mb RAM and 1 Gb Swap
I modified the redhat-release file to fool the OUI.The prerequisites check
suceeded it was smooth till linking 71% thei made link between oracle and db2
i have problem it is return zero for any filed number !!!
is it need parameter ??
Look into sql_trace or more accurately 10046 trace.
> -----Original Message-----
> From jaysingh1@(protected)
> Sent 03 March 2004 02 41
> To jaysingh1@(protected) oracle-l@(protected)Hi
Just got an email from Novell regarding SuSE LINUX.
"The SUSE LINUX READY Program gives you free download
access to Novell 's SUSE LINUX Enterprise Server (SLES)
8 for 32-bit processors aI have a threaded batch process running in which all the threads are pretty
much doing the same thing. I have another report which shows total IO CPU
REDO and more by session. When you look at tHi
Could you post the structure of the tables your using?
Thanks
Stefan
-----Urspr?ngliche Nachricht-----
Von Saira Somani-Mendelin [mailto saira_somani@(protected)]
Gesendet Tuesday MarYou figures are correct. I don 't think you have to.
Regards
Rafiq
From "Martin Alan (Contractor) (DLIS) " <Alan.S.Martin@(protected) >
Reply-To oracle-l@(protected)
To " 'oracle-l@(protected)Dear All
Recently we upgraded from 8i client to 9i client (DB is still 8.1.7.3 only client has been upgraded to address FAILOVER issue).
ATG appserver is a client which conects to DB using OCI |
|
|
