 | | | Oracle List | | Hi all
I 'm using Oracle9204 and we have been running into a following problem
lately. My users execute the following
command
alter table owner.table exchange partition part1 with table
owner.xchg_tI believe there is an option in VMWare Workstation 5 to keep the clock of the virtual machine synced with the host. If you can 't find the option you could use an ntp server on each virtual machine toI notice under Oracle 10 when I run lsnrctl status I see
SECURITY ON
How is this set. Can I turn it off?
John
John Dunn
Product Consultant
Direct Dial +44 (0) 117 373 6122
Sefas Innovation Ltd EMC is recommending a min. of 2 disk groups so that you can balance I/O 's
across two Logical Volumes (Metas in your DMX). This way you will stripe at
the ASM level and at the host level as well and yoAmit
Sometime it may happens if tcp/ip QUEUESIZE is small on OS level.
I am not sure about linux OS parameter which probably you can get from your
system administrator.
For other OS these paramet
On 03/07/2006 08 44 07 AM Hemant K Chitale wrote
>
> Recently we have been testing a database migration to a new server.
> During the scheduled day for the "stress " testing I found that user rWow. Laughed out loud! Well said Mladen!
For those who didn 't bother to look up and read RFC1149 (I couldn 't
resist and I 'm glad I looked!) it describes a method for "Internet
Protocol over AvianI notice under Oracle 10 when I run lsnrctl status I see
SECURITY ON
How is this set. Can I turn it off?
John
--
http //www.freelists.org/webpage/oracle-l
Hi
I 've traced a long running piece of SQL and observed the following in the trace
file (only a small sample)
WAIT #3 nam 'direct path read ' ela 3 p1 202 p2 641041 p3 1
WAIT #3 nam 'direct pathOn Tue 2006-03-07 at 10 54 +0100 LiShan Cheng wrote
> Hi
>
> I am going to install a 10gR2 RAC in a couple of weeks. It will be
> RHEL 4 Update 2 and I will be using ASM for all database files.
> Traditional approach Statspack OEM AWR etc. are
already out there but if you want to drill-down
starting from Unix (Solaris in our case) coming into
oracle you could do this (we use this approachHi
Oracle Standard RAC 10.2.0.1
Windows 2003
We are having continuos system state dumps
Mon Mar 06 12 57 01 2006
Trace dumping is performing id [cdmp_20060306125701]
System State dumHi
adding a node metalink Doc-id 270901.1 (How to Dynamically Add a New
Node to an Existing 9.2.0 RAC Cluster)
removing a node doc.id 269320.1 this is for 10g but perhaps
helpful.
Don 't knoHi
As said earlier in list.
If you have duplicate object.
Better to delete one of them.
I have seen sometime double objects cause Oracle internal 600 errors also.
Thanks
-Harish Kalra
On 3/7/06 dHave you gathered system stats ?
Kevin Lidh <kevin.lidh@(protected) > wrote Wow thank you Juan for those. They are explicitly set by the CRM application to caching 0 and adj 1. When I changed them Can anyone please suggest initialisation sizing parameters for a small
database on 10G R2 on linux.
I seem to have problems getting anything like the response times I get for
Oracle 9i
John
--the problem is senior managers are the targets of this marketing hype
and buy into it at face value. they believe oracle is unbreakable. they
believe linux is free. and they believe 10g will renderHi
We run on Red Hat no problems with performance (and I don 't think
performance will be that different between the distributions).
The main advantage with running Red Hat is that oracle gives you On 06/03/06 Tony Jambu <tjambu_freelists@(protected) > wrote
> Hi all
>
> Looking for best practice for allowing Oracle Network (functionality)
> thru a firewall.
>
I 'd agree with Paul best pracicI entirely agree with you.
My main concern is whether Oracle has reached critical mass in terms of size. i.e. Has the Software become too big and is doing too many things to become maintainable
The external procedure listener PLSExtrProc is started as part of the of the
standard listener start up.
Is there a way I can test (in a shell script) that the external procedure
listener is runningHello list
I was reading Jonathan 's great book at least for me 'CBO
Fundamentals ' and I got confused of frequency/height based histograms
though he explained in a great way.
What I understood is Hello List
Platform is AIX 5.3 ML3 64 bit on IBM p550. Install
type is Forms and Reports Services 9.0.4.0.1 with
9.0.4.2 patch release applied.
Opmnctl stopall does not shut down the reports serverHello gurus
I searched on this list for ADDM. I did not find the answer on this topic.
Are ADDM and its successors going to put DBAs out of jobs? or reduce the
number of DBAs required? I read aboutHello
I have become involved with a project that is replatforming a HR8.8 system
from SQL Server to Oracle 10gR2 RAC with DataGuard on AIX.
It is a fairly high intensity system with a significant selHi
9205 on AIX4.3.3
I have 3 databases running on a 2 CPU system.
I need to figure out what percentage of the total 'load ' on the system is
being contributed by each of the databases.
How would I d
You can also look at the option of using quick i/o or ODM.
I normally set both disk_async_io to TRUE and value of db_writer_processes > 1 after ensuring i/o is balanced using some type of logical/p <html > <div style 'background-color ' > <DIV class RTE >Runining the SCRIPT ESTIMATE SHARED POOL UTILIZATION from Note 105004.1 of metalink shows Shared pool utilization more than allocation and shows fre
Hi
I was wondering if anyone has a perl hotbackup script they might be
willing to share.
I am going to make it multi-platform and adapt it for some of our larger
database with multi-threading etHappy Friday !!
Article Title Active Lots Of Library Cash Pins Since Upgrade From
9204 To 9207
Doc ID 340041.1
Now now don 't go telling Oracle they mis-spelled ... the document
status is moderat |
|
|
