 | | | Oracle List | | Sorry missed to attach report file... here it is
Plz. help
--
Thanks & Regards
T. Onkar Nath
Ph +91-9826728111(Cell)
to_onkar@(protected)
onkarnath.tiwary@(protected)
--
htthow irked would you be if ..
you found appletalk protocol bound to the server nic on an oracle server
... and the users there were reporting a performance problem?
time for a walk perhaps.
Here 's a really bad query but one I need to figure out.
I want to query all columns in all tables in a schema for a string
value. I think I need dynamic SQL for this has anyone written So I just had to kill a process that was deleting the wrong data and
doing it far too slowly ) . It has been running for some time. 20
Anyone know how to tell how long it will take to rollback? It 's possible it 's applying undo to construct a CR image of the blocks y
ou need. If you trace it with event 10201 level 1 you can see if this
is the case. There will be a line that reads "ApI see Oracle has the Oracle 9iAS VoiceXML for converting XHTML to voice.
http //www.oracle.com/technology/tech/wireless/papers/q2-03/9iASW_Voice_twp.pdf
Does anyone know if Oracle has the capaHi
>Any hints?
You can use the hint RULE -) 20
Chris
PS ln -s "rm RULE based optimizer ! 3D GOOD IDEA " .
PPS I 'm curious as well... why you don 't want to use histograms?
--
http //wwOne should also look at the blog entry earlier in the month as well.
Also for those who have not found it http //www.orablogs.com/orablogs/
is an excellent site which gleans material from manWarning!!! This is some ugly SQL. It works but I know there has to
be a more elegant (and efficient) method.
Free space used space and total space is tracked for all databases by
tablespace. Hello list
We are facing performance issues with 'payroll rollback process '. Top
5 timed events are as follows
Top 5 Timed Events
~~~~~~~~~~~~~~~~~~ I love that script. Neat and concise. You automatically get a listener check
and last week it caught max sessions exceeded because of some wayward code.
Mike
----- Original Message -----
From "A Joshi wrote
> Hi
> We are currently using advanced replication with a primary and secondary. We plan to move to Logical standby. We are hoping logical standby will support more data types anStephen
We have a similar situation. What we do is this
Create a "ocella_available " table in your local database that indicates
whether the remote database is available. Run a cron job everJust a general question guys.
Have any of you been forced to use "myconfigs and projects " before you are
able to raise a tar through metalink.
--
http //www.freelists.org/webpage/oracle-l
I have few confusions
1) In my temporary tablespace space not getting released even if the
user has finished with the work. Ideally once the user using temporary
tablespace finished the job sThe link says 'an error occurred while processing this directive '
ANY IDEAS?
On 4/26/05 Kirtikumar Deshpande <kedeshpande@(protected) > wrote
> Thanks for sharing this Ian.
> 20
> This is quiHello
How do I uninstall or stop that annoying Oracle Servlet Engine (that
pink pig)?
Thanks.
--
Lyndon Tiu
--
http //www.freelists.org/webpage/oracle-l
I don 't think it 's a 9i issue at least not with 9.2.0.5.0 on HP/UX
11.11 using vxfs. I just tried this and the spool created fine up to
2154009964 bytes ( >2GB) before I killed it.
Make sureJust to follow up Oracle support said this is a know issue and will be
fixed in 10g. release 2. 20
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)Ray
I 've always felt that Oracle was a bit lazy in regards to stuff like this.
It always felt to me that they just didn 't want to have to validate security
access every time a view (or when you Anyone else experience this?
OS Solaris 8
DB 10g (10.1.0.3)
My delete returns an ORA-3113 when I execute this on my 10g databases
but it works fine on my 8.1.7 databases.
Here is my DML
Is anyone running 10g Standard Edition RAC in production? I have a client
who may migrate from 9i EE RAC to 10g SE RAC but are uneasy about it and
don 't want to be one of the first.
Thanks
On 4/25/05 Bellows Bambi <bbellows@(protected) > wrote
> Laura --
> 20
> This has been a historical problem. There are ways to work around the
> restriction but generally involve a temporary grantI am also going and mgmt wants some sort of official trip report when I
get back. I was wondering if anyone has done these?? Suggestions??
Examples??
TIA
-----Original Message-----
From oOracle intermedia will do this for you (except its now called
OracleText in 10g). So the keywords would be Intermedia or OracleText.
There are or have been a slew of bugs with the feature and
cWe 're going through a new RAC install here and I 'm a little curious
about something. The documentation doesn 't seem to be a whole lot of
help from what I 've been able to find so I 'm hoping some Ummmm... Did you look the error up in the documentation?
-----Original Message-----
From Ranko Mosic [mailto ranko.mosic@(protected)]
Sent Monday April 25 2005 8 47 AM
To oracle-l@(protected)
Hi all
I 've been working on trying to improve performance of our
busiest tables by tuning freelists. The results are not earth-shattering
however and wondered if I could get some feedback
Do not use uniform sized LMTs for volatile tables since you may end up
having a table/index with thousand of extents..
More important don 't blame LMTs for it.. 20
If you use AUTO extent alloWith Vertas CVM (on HP-UX but other should be similar) you can resize
logical volumes online. We are with Veritas 3.5.
2005/4/22 Stephen Andert <andert@(protected) >
> Q1. Is it possible that the |
|
|
