 | | | Oracle List | |
At 02 33 AM 5/24/2005 Barr Stephen wrote
>I 'm trying to resolve how the CBO has come up with the cost of 9131 in the
>10053 extract below.
>
>
>If the formula is blevel + FF*leaf_blocks + FFHowdy
Does anyone know if there is a solution to using the JDBC thin driver
for TAF prior to 10g? Our vendor is complaining about RAC although they
said they were "certified " when they marketedHave a HUGE table that I do NOT want to EXPort
but other that I would like *everything* else...FULL Y.
Any ideas?
Thanks in advance
Chris Marquez
Oracle DBA
--
http //www.freelistsPaula - If you are going through a client you may also want to check
the CHARSET of your client.
--
http //www.freelists.org/webpage/oracle-l
Hi! Jared
How about editing the spfile in Notepad/Wordpad removing the first
and last squiggly lines and changing the parameters such as remote_pass...
and writing a new pfile. Then start the Hi guys
I am doing some rearranging of a 9i database (9.2.0.4 but will be
upgraded shortly to 9.2.0.6) on AIX 5.2. I have 5 objects in a
tablespace that needs to be dropped so I want to move Something like this
select record_key
max(decode(id 31 value ' ')) start_time
max(decode(id 19 value ' ')) shift
max(decode(id 10 value ' ')) rate
from t1
group by record_key
or this
seNeat. Nice bit of lateral thinking there.
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)] On Behalf Of Charlotte Hammond
Sent 23 May 2005 1Thank you very much for your update Connor.
Regards
Prem J
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)] On Behalf Of Connor McDonald
Hi all
I had been using OEM for some time OMS but unfortunately I forgot the
password of OEM-OMS user - SYSMAN. Any suggestion for this situation...
--
Thanks & Regards
T. Onkar Nath
Ph We are considering implementing 10g RAC on IBM p5 series running AIX 5.2
or 5.3. Probable configuration is 3 or 4 nodes. Quick review of the
documentation suggests we can use ASM and avoid the HACI was wondering what everyone was using in terms of automated capacity planning reports for Oracle on Unix?
I wish to automate something that would populate a report or spreadsheet across all boxes
10046 doesn 't change behavior of server process (only adds small
overhead). So answer to you Q is - your statements will be executed in
the same way as without tracing.
2005/5/21 The Human Fly <We often use alter session set parameter_name value to tune some specific
SQL.
But for example we have such a case
select a.id <http //a.id > b.name <http //b.name > from a@(protected) b
where a.col19i Stream does mine online redo logs. From the manual 20
"A capture process reads online redo logs whenever possible and
archived redo logs otherwise. "
Sandeep Dubey
On 5/22/05 Sami SeeranI 've come up with a query (below) to identify high water mark of
datafiles and tempfiles. The problem is it works most of the time but
not _all_ the time for datafiles belonging to "permanent " Related to my thread earlier this week. I have a range partitioned table
that i want to drop partitioning on. can someone validate the following
steps im taking or refer me to a good doc? im goingAnyone no if any/all Oracle datatypes that are NOT supported by "insert into select... ".
How about "insert into select...from t1@(protected) " over db link?
insert into SCOTT.B_[LOB_TABLE | XMLTYPE_TAI *always* fully qualify and never seem to have issues!?
/usr/bin/perl /o04/oracle_software/OPATCH/OPatch/opatch.pl apply /o04/oracle_software/Oracle_Patch_3119415/3119415
Chris Marquez
Oracle DBWe have an application that makes use of port 1521 for an oracle
listener. The port is totally blocked outside of a domain and so the
security level is set to 'request ' for encryption.
But now
You 're not alone I saw this weirdness in a recent 10046 trace observe
WAIT #40 nam 3D 'db file sequential read ' ela 3D 53 p1 3D90 p2 3D145793
p3 3D1
WAIT #40 nam 3D 'db file sequential reaKristen
Seems your question is
Veritas BackupExec Oracle Support (non Oracle/RMAN api)
or
Veritas NetBackup Oracle Support (using Oracle/RMAN api and using RMAN Syntax)
not
Veritas
Since you said "I requested a log of user logins " I 'm going to assume
the users log directly into the server to access sqlplus...
Some ways to approach this from the O.S. side
Does your SA hAll
We are just starting a project using Oracle Financials (General Ledger &
Chart of Accounts). Is it appropriate to install this software on the
same machine as our other Oracle Database ServHi
Any of you Oracle-L people use Mathematica 5.1?
Do you know of any tricks or tips to establish
a JDBC connection between Mathematica 5.1 and Oracle 10g?
I tinkered with my setup for a coDid you insert rows manually through one session
without commit and do the max(id) from another
session?
> select max(id) from mytable
> It will not return 95 instead it will return value 5
> I 've set up a couple test systems to try out Oracle 's
dataguard and for the most part I like it but I have
been having a really bad time with the broker. I have
hit several bugs and sometimes the
I am having issues with execution plans changing even though the
statistics on tables are kept static. Can anyone give me any information
on the dynamic factors which are taken into account by tChris
This usually means that some piece of code committed a bounds violation
trying to read from or write to memory which it did not own.
HTH
Peter Schauss
-----Original Message-----
Good day.
We 're looking to make a decision on a SAN storage solution shortly. I
was wondering if anyone had any insights or preferences regarding these
two products. We 'll be using snapshot fun |
|
|
