 | | | Oracle List | |
googled in to some old list archives
http //www.mail-archive.com/oracle-l@(protected)/
Handy for people running unsupported versions
and those that are just nostalgic.
Current archives of oOn Tue 22 Mar 2005 08 46 45 -0800 (PST) A Joshi <ajoshi977@(protected) > wrote
> Hi
> How do I find what is the latest 9i 10g release and dates released. And possibly upcoming releases. I am seraOn Tue 22 Mar 2005 10 50 36 -0600 Ehresmann David
<David.Ehresmann@(protected) > wrote
>
> Does anybody know of a shareware or inexpensive X-windows server to work
> with Windows XP Professional?
Hi
How do I find what is the latest 9i 10g release and dates released. And possibly upcoming releases. I am seraching on metalink patches advanced search etc. Thanks in advance.
------------I 'm currently evaluating Data Guard for our DR setup and initial tests seem to work fine. However I made the mistake of asking Oracle about the licensing of the failover machines and was shocked by Hi Mladen
>Does anybody know the where clause used to select columns which 20
>will have histograms? Is there a fixed cutoff number
(EQUALITY_PREDS >x)?
>Percentage?
Honestly I don 't know exHi
>How would i know what id number get 's created ? Izzit
>by issueing seq_emp.currval ? If i issued this select
>seq_emp.currval from my trigger how can i pass this
>value to my web applicationDoes anybody know if there is a limit to the number of UNION operators
allowed in a SELECT?
Could not find any mention of an upper limit in the documentation or
issues with queries using a large
I haven 't got around to testing it yet
but I think your guess about index
block splits is correct.
If you check v$segstat and v$segstat_name
you will find that they depend on x$ksolsfts
andWe have been doing application load testing lately and I found enq TX
index contention being the top contender among other waits. The table
with 5 indexes all it 's index columns gets updated via anHello All
One of our client have upgraded their database from 9.2.04 to 9.2.0.6. They
are using a CRM software which is generating the below mentioned SQL. Oracle
is unable to parse this SQL inAnyone tried installing 10g on RHEL4 or CentOS v4 yet (Whitebox 4 isn 't out yet) ? I see a challenge to try it in the List archives but no takers yet. And since Werner Puschitz doesn 't have it documDid you look at the verify function that oracle supplies? There is a
verify_function.sql that needs to be executed.
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oraIs anyone aware of how to find all available hints in an oracle release
(including undocumented)? Thanks
--
http //www.freelists.org/webpage/oracle-l
I am copy/pasting this from the archives
>For portability reasons our Unix SAs would like us to run one listener /
>instance on the same port of each server.
Yes you can have multiple listenerI am still looking for answers for this problem.
We have 3 servers. Oracle 9i was installed via same user with same
rights in all cases.
Server 1 -
- no existing Oracle install
- installHow did you get your plan?
> The fix was to identify the process holding the latch and kill it.
> MetaLink gives some information on how to identify a process holding a
> latch (the v$ views do not as it is never supposed totest
--
http //www.freelists.org/webpage/oracle-l
All
This is not a product spam message - we 're interested in hearing peoples
opinions on something.
We 're looking at the topic of table and tablespace reorganisations at
the moment. As time h > I was under the impression that this utility could consolidate trace
> files generated by versions of Oracle earlier than 10g I cannot
> however get the utility to consolidate on the basis of modHello list
One of my colleague has dropped one datafile using 'alter database
datafile '.... ' ofline drop ' command and removed the datafile
physically from OS.
As we all know that the entry stHi
as far as I know port redirection on unix happens only if you enable MTS.
Giovanni
> Hi!
>
> I have a rather basic question is it true that under Unix all
> dedicated server processes Kean
LTRIM trims from the left and RTRIM trims from the right. So they are sort
of the same but from different directions.
Tom
-----Original Message-----
From Kean Jacinta [mailto jacintI thought all the DBA_ views are global(will dipplay all nodes
information) in OPS/RAC environment. Is it an expetced behavior?
INST1
SQL > select * from dba_jobs_running
no rows selectedI am not sure if I have understood your problem ... see if this helps ...
Hi all
I 've installed 10g (10.1.0.3) on RH linux ES (2.4.21-15.EL) for some
reason i couldn 't get ASM working.
I chose the ASMlib path as opposed to creating raw fs. Installed
following librI just got pinged from one of our development directors about a possible project coming up in the next fiscal year and I need your input on storage options. This is going to be a massive 40TB+ projecI am following the Oracle 9i Database Performance Guide for Moving Outline
Tables and it isn 't working. After importing the tables they are still
showing up as being in the system tablespace. IOn Fri 18 Mar 2005 02 16 51 -0800 (PST) Kean Jacinta
<jacintakean@(protected) > wrote
> Hello
>
> Need some help on this. I have 2 table
> I need to insert into emp table first and then get
> |
|
|
