 | | | Oracle List | | Definitely off topic but because Instant Messenger is so popular I
thought I 'd forward a message IO received today from a coworker
"Today I got a popup telling me that the ViewPoint IE Toolba9i rman takes about 15 minutes to set up.
The testing is what takes time. I can 't see any reason to hire in
consultants to set up your b and r recovery. Setting it up yourself
will force yo
Wolfgang Breitling said
A commonly held belief is that histograms are useless i.e. have no effect
on the access plan if bind variables are used since the value is not known
at parse time This is actually something I 've never quite understood.
...so with 9i bind variables don 't completely prevent parsing correct?
...they just make a softer hard/soft parse? 20
-----Original MesNo - Each "root " in the PROVIDER_CONTRACT_STATUS table can have 0 to
many "leafs ".
I think the problem I have is that only the current
provider_contract_status_id (or "root ") has a tie back to geFolks
Anyone know what the necessary protection should be on the following Java
file under unix?
% ls -l /u01/app/oracle/jre/1.1.8/bin/jre
-rwxrwxrwx 1 oracle dba 2097 DHi Everyone
I have just added a page to my site that lists 596 default Oracle users
and their passwords. The list is available as HTML CSV SQL insert
statements to load the data into a table I guess it depends on oracle version (and platform?)
SQL > select file_name from dba_data_files
FILE_NAME
can 't find it in the docs
can 't get Itar drone to answer
can I nest NEAR clauses in NEAR clauses or NEAR clauses in AND clauses?
docs don 't say anywhere that I can find... and we have some of tWe have a 9.2.0.4/AIX 5.2 shipping database that experiences periodic
freezes
during "waves " when ship/print runs are generated. During these
freezes
we typically see between 100-200 sessions Justin
Thanks. 20
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
From Justin Cave (DDBC) [mailto jcave@(protected)] 20
Sent Tuesday November 16 200 > 50-pence coins or did you switch to EUR? I am asking because I have to know
> in which
> currency should I send my invoice GBP EUR or John Smith Extra Stout
> Yorkshire
> Bitter?
always invBruce
Thanks for your response. Btw our platform is HP-UX.
I put some comments inline below...
On Tue 16 Nov 2004 13 23 22 -0700 McCartney Bruce
<bmccartney@(protected) > wrote
> Didn 't help already tried it.
thank you
-----Original Message-----
From Zeng Lei [mailto LZeng@(protected)]
Sent Tuesday November 16 2004 3 39 PM
To oracle-l@(protected)
Subject RE DHi all 20
Am I the only one having major problems with 9205? Is anyone else
seeing the following behavior? I 'm on Windows 2003 unfortunately
ORA-12500 ORA-12540 etc. refused connections wiIt could work but i need know the id before insert. In whole
application there is many many places with the same algorithm 1. get
id 2. use it in insert query. This is unfortunately not possOkay
There have been a lot of deletes/inserts in an environment resulting in
a high db_file_scattered_read wait I believe on a small table when doing
a full table scan and retrieving a specific Lectori Salutem
after the NIGHTMARE we had over here with applying patches for security alert #68 (hundreds of them) we started
thinking more about 'hacking ' and what else could cause database serIt is exactly because it is so easy that I figure someone should have
done it and there is no need to reinvent the wheel. <g > But yes if
not then I 'll look at doing it myself another option ther
On 11/15/2004 11 07 45 PM phani krishna wrote
> Hi all
> 20
> i 'm not getting editor mode in aix.
> 20
> pls provide a solution.
> SQL > ed
> SP2-0107 Nothing to save.
> SQL >
>
You This sounds a lot like the Sybase Replication product.
Big surprise eh?
If it is it must operate via triggers which may put quite
a load on your system.
I took the Sybase Replication clasWhat 's wrong with "mainstream " boards? Are you trying to prevent people
from finding your posting?
on 11/15/04 4 41 PM Adam Donahue at adonahue@(protected) wrote
> Folks
> I posted a jobJared
IIRC you are correct but someone on Metalink noticed a few things
missing from 9206 that are in #68 e.g. mod_plsql patch. This caused
some of the confusion.
I don 't have the link in But who wants to hang out with Fusilli-Jerry?
hey folks
Looking for some concise doc on the changes to the init.parms related to
10g.. Does anyone know of some info related to
1. the new init.parms (ok - rtfm - and am in the process)
Hi Charu
There are two views on your problem there a theoretical and a practical
Theory first..
I suppose the formula you applied to calculate the join cardinality
(Metalink 68
-----Original Message-----
Hi guys!
Anyone have any success using the 9i File Mapping feature?
That is you used this tool to actually change the way your files were laid
out and improveAll it means that there is some other service running that depends on
oracle service.
The simplest way to find it is to go to ControlPanel/Service and try to
stop OracleService <SID >. It will shselect c.name u.name
from con$ c cdef$ cd user$ u 20
where c.con# 3D cd.con# and cd.enabled 3D 1 and c.owner# 3D u.user#
After some concern about a database running slower than desired anI 've noticed the same disparity and have also not found a later version.
Jared
On Fri 12 Nov 2004 15 13 06 -0500 Gogala Mladen
<mladen.gogala@(protected) > wrote
> Being one of those DBA ge |
|
|
