 | | | Oracle List | | Totally agree with this statement from Dick. Without wishing to hi-jack this
thread
I can foresee a time when Oracle will ONLY be used for
'business-critical-production-databases '
and everything I recieved this error when I bumped up the processes to 500 from 250. There
is one other database on the server with processes set a 200. The
/etc/system parameters are
set semsys seminfo_semmap 0Our redo logs are on raw devices - so I couldn 't possibly remove them.
Only links that are recreated quite easilly.
Also our mirroring is completely redundant - separate controllers -
separate SANsOracle 8.1.7.4 / AIX 5.2
How does dbassist determine the number of rollback segments to
create? It appears to give you the ability to choose the size of the
segments indirectly via the tablespHere 's a quick-n-dirty padding function I 've used in the past.
sub lpad {
return($_[1] x ($_[2] - length($_[0])) . $_[0])
}
To pad a string with spaces to 10 characters you 'd invoke it liHi
We have to provide a conversion of blobs to base64 in order to exchange data
with
a 3th party. I wrote the following function which is used to format an
xml-message.
Problem is the supplier rNo its slow for me too - maybe they upgraded to 10g on Linux -)
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)]On Behalf Of Boivin PatricMicrosoft has begun to remove support for other databases other than SQL
Server from some of its products such as Project Central. This is one
way of worming their way into shops. Identity Folks
Limitations of MSSQL Server Vs. Oracle OR simply otherwise General
limitations of MSSQL Server.
Need to give a presentation to Management on the same 20
Any Good Links docs etc?
ThI 'm no expert here but here *may be* a few things to think about
When Oracle is actually doing something it isn 't recorded as a wait event
e.g. getting a datablock that is in cache doesn 't generOk we are going to upgrade our NT prod db to 10g then use rman
to migrate to Linux Thanks Guys and Gals.
Howard
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracHi
unix has two converion utilities
unix2dos and dos2unix.
Have you already tried them?
Regards
Fabrizio
> -----Original Message-----
> From oracle-l-bounce@(protected) 20
> [mailNice cookbook approach of all the necessary steps
http //www.oracle-base.com/Articles/9i/TransportableTablespaces9i.php
--
http //www.freelists.org/webpage/oracle-l
As some of you know I assist in the DBA hiring process for a small
number of organizations. I am currently helping GetActive Software a
small company in Berkeley. I taught a seminar there a few Pete
You must be famous. -)
http //www.orasecure.com/security-white-papers.html
Regards
Mike
On Tue 23 Nov 2004 11 53 05 +0000 Pete Finnigan
<oracle_list@(protected)I 'm trying to CTAS a large table into another database and it 's failing
with 'Snapshot too old '. The source table is located in a readonly
tablespace so I 'm certain there are no changes occurringGreetings
Is this a DEAD Lock? Why don 't I see any error messages in the alert log.
Oracle 8174 on HP UX.
ADDR KADDR SID TY ID1 ID2
LMODE REQUES
Till a few years ago Oracle used to provide us a Licence Order Form
detailing the licences purchased.
Apparently for the past few years the only evidence of the Licences
purchased has beenDennis
We test backups of every of our databases restoring it on test systems
(another boxes). Every database is restored to at least one new
instance (up to 3 for some weeks). It proves that ou
Ok the finally answer is....
I had to increase by Hash_AREA_size to 50M!!!! from 2M.
Then the explain plan looks like it should. Guess they should add this to
the docs besides increasing thYes it was the discussion in the tech forum.
1 the original database is running on nt everything hosted by nt. D1
2 D2 runns on nt but is hosted on Linux using SAMBA
3 Target is D3 all on Linux
I have done export from one schema and then export to another schema.
I specified the fromuser and touser but still it gave me error as table
does not exist.
Any idea?
bash-2.03$ imp userid hermrepThanks for that Kirti. Much appreciated.
List sorry I don 't have Kirti 's personal
e-mail and I had to thank him.
If anyone knows what it is please be kind enough
to forward this to him.
Even better - consider using PL/SQL tables. We used global temporary
tables approach and we hit another problem - using temporary tables
generates lots of redo (Oracle confirmed that). So we reducedBtw for RAC versus Non-RAC I would first of all check if ASSM is
used. Otherwise check FREE LIST GROUPS and FREE LISTS storage
parameters. This is especially true for DML intensive applications
(INot enough info to even hazard a guess.
I would suggest a level 8 trace is in order.
--
Ron Reidy
Lead DBA
Array BioPharma Inc.
-----Original Message-----
From oracle-l-bounce@(protected)Hi
The answer is to connect to the rman catalog and enter the "reset database "
command.
This updates the catalog for the new incarnation of the database.
Regards
Pete
[END]
-----OriginSol
You should look at using the Devel Prof
(http //search.cpan.org/~jaw/Devel-Profile-1.04/Profile.pm) module to
rule out Perl problems.
You say you see nothing in the trace files that
On 11/20/2004 03 20 06 AM biti_rainy wrote
> hi all
> 20
> 20
> one or two days per week sometimes the run queue size is close to
> 20 many are close to 1 or 2
> but the load-1 is al
On 11/19/2004 09 29 55 PM Juan Carlos Reyes Pacheco wrote
> Hi I can 't filter a query what I 'm doing wrong please
Ehm this is an improvement over "DBA tips ". Much better. So let 's be 20 |
|
|
