 | | | Oracle List | | David
Well put. Myself I tend to think of cloning as the actual act. A word
meaningful to a DBA. Cloning might occur a single time or may be repeated.
Once a cloned database exists then the DBA mayJuan
So you 're saying that you already have the OCP and you would like to get the
Oracle Master 's? How expensive would it be for you? What benefits would you
gain? Do you have clients that would be How can I tie a specific process to a cpu on sun solaris? mpstat gives cpu
stats but does not tell me which process is running on a given cpu.
thanks.
Hi
Current Hardware HP N Series machine HP-ux
database is on raw devices.
Migrating to HP-ux on itanium 2
would it be possible to just reopen the database datafiles from new
OS/Machine.
or would wEmail to help desk.
rr
Hi Anurag
> > Could you please let me know how to check the
> > OCI (Oracle Call interface) version I am using in my Oracle client
or
> > server installation??
Does this help (from the 10gR2 docs) Hi
> The error probably relates to the PLAN_TABLE.
If the plan table isn 't available an ORA-2402 or if the INTO clause is used an ORA-2404.
>When I select the data from a view I can get the resTry Metalink note 118847.1.
Also if the rest of the Oracle Apps 11i clients are working and one
isn 't try this
With admin rights to the PC
- Uninstall JInitiator with Add/Remove ProgramsGreetings
You need to monitor at v$session_wait you should look at
db_file_direct_io_count
large_pool_size string
db_block_size integer
tape_asynch_io
backup_tape_io_slaves
dbwr_io_slaves integer
> > > > at the moment i am in 2 minds between create table as ...
> > >and insert
> > > > /* Append...
I do huge parallel insert as select * from external tables and
+APPEND is most critical.
> > >Make sur
The error probably relates to the PLAN_TABLE. Do you have a PLAN_TABLE
in your account (the account running the query) ? Create one with
$ORACLE_HOME/rdbms/admin/utlxplan.sql
Hemant
At 10 34 AM MoHi
we all know to build large indexes using many fast methods like parallel
nologging etc.
how can i speed up dropping large local index partitions with sizes
exceeding 400GB? it takes a couple oHi!
We had an similar problem with some sql where parse-time was multiple seconds.
One of the 'solutions ' (there must be a better way...) could be using
select /*+ OPT_PARAM( '_optimizer_cost_based_tHow do I figure out the cause of objects (Procedure Package Trigger) became
INVALID?
Any pointers will be greatly appreciated....
--
http //www.freelists.org/webpage/oracle-l
Have you checked your pga_target_advice and sga_target_advice views to
see if one of them could be reduced w/o severely impacting performance?
Can you scale down the apps for the development environmshutdown abort is fine.
Shutdown immediate sometime succeeds. I mean the SELECT automatically fail
over to the second node and continues to run.
The confusion is that why it is failing sometime
OThis works... but I do not see point of doing that since you are not returning
your cursor to any code/variable
declare
a sys_refcursor
Begin
-- Insert into table....
open a for
select taWhat happens if you do a shutdown abort instead...?
--
Mark J. Bobak
Senior Oracle Architect
ProQuest Information & Learning
Ours is the age that is proud of machines that can think and suspicHi Anurag
Which exact version of 9i is it? i have had nightmares with various versions
for a simple TAF test with no load balancing broken connection etc.
TAF should and will work when configuredNiall
Are you sure about that? Yes I know that the Diagnostic (etc.) modules
for OEM that make use of AWR are extra cost options. But is AWR itself a
separately licenseable product? I poked aHi all
I 've recently inherited several large Solaris servers that need to be reconfigured for Oracle databases starting with the the kernel settings.
In HP-UX it 's possible to set the value of shBrian
Let me ask a stupid question.
If they are not allowed to use these tools to make a connection (I am
concluding this because of the error message you are issuing) then why
not simply give > The netapp you propose seems tempting but you need 3 boxes.
> I presume you uses vmware to simulate virtual Linux boxes or
> you have really 3 boxes?
With a bit of configuration you could set youHi
May be somebody faced this issue before and knows how to solve that.
We have a CSV file where text fields enclosed witrh ( "). The issue is that text
fields might contain \n (new line - 0x10) chEver since moving to 9i and 10g databases in the last couple years the
most common performance problem I see is queries that are optimized by
the CBO based on one set of bind variables but subsequenThis one works
Maxtor
MFG# E01G300
On 8/24/06 Hameed Amir <Amir.Hameed@(protected) > wrote
>
> Folks
> Is there anyone using the "Maxtor OneTouch III FireWire drive " with
> Linux and 10G RAC?
I/O intensive work. Can you tell us a bit about the
storage and runtime I/O characteristic you 've monitored?
> > >
> > >This is on oracle 10.2.0.1 / AIX5.3L on IBM P595 machine
> > >which has got 64 CI am looking into RAC on a Windows system. Right now we have two
servers 1 active and 1 passive using Microsoft 's clustering services
to mange the cluster. This works fine with Oracle v9 Fail SafeHi John
Looks like transitivity.
1) The join condition "itemtype.sm29_logo_seat_num (+)
tsm66.sm66_seat_num " indicates these two columns should be considered
equal thus the where condition "sm66 |
|
|
