 | | | Oracle List | | Hello all
Is there a way (parameter event) to set that will prevent the optmizer from
materializing subqueries in a WITH clause ? A hint won 't help me because
the query is issued by apex itself a
Dave
> > CREATE INDEX me.attachment_IDX ON me.test_table(ATTACHMENT)
> > INDEXTYPE IS CTXSYS.CONTEXT
were you running as SYSTEM by any chance?
I have just create a context index on one of my test tAs others have pointed out there is no need to mount the filesystems
for your *datafiles* with cio - here is the documentation to back it up
that claim along with further recommendation to make sureGreetings
I 'm running a two node RAC cluster using Oracle 10.2.0.3.0 Enterprise
Edition on RHEL4. I am trying to resolve an issue with a database link.
I am using a local tnsnames.ora on each node. Here 's the statement
create MATERIALIZED VIEW STEVE_TEST3_MVW
refresh fast as (
select
ac.assess_case_seq_id
ac.violator_seq_id
ac.rowid ac_rid
vi.rowid vi_rid
from
base_host.baseTony
The answer is in your question. The subquery is correlated. The optimizer has to find all ITEMS (by company) - only then can it find all matching PARTS (dipping into the PART_IDX index to satisfHave you tried running the file command ie file abc.Z to see what unix
thinks of it if it says its text I guess you have a nice lot of rubbish
of which you may or may not be able to salvage anything Hi all
I recently cloned a DB that had 2 large read-only tablespaces. to
expedite the cloning process I did a 'skipp readonly '. Now my
auxiliary DB is open and running. I then copied the tablespaHi List
We are trying to recover a database using previous incarnation from rman
backup.
Our database is running on SUN Solaris
DB Version 9.2.0.6
We are tring the following but getting the fTake a look at the raw trace file and see if the STAT lines are there
for the particular cursor that executed the query you are interested in.
For example
PARSING IN CURSOR #7 select this from Have you tried uncompress through a named pipe? You might get something out
of it. Test by doing an import with show y
<html xmlns o "urn schemas-microsoft-com office office " xmlns w "urn schemas-miLooking for an entry level DBA candidate for a position in Sioux Falls SD. Please contact me directly for more information.
Paul
<HTML > <HEAD >
<META http-equiv Content-Type content "text/html chI think that you have the utl_smtp.helo set wrong. It is pointing to
an address where smtp is not running on port 25.
HTH
--
Magnus Andersen
Systems Administrator / Oracle DBA
Walker & Associates Also make sure your max_dump_file_size is big enough so that the file
doesn 't get closed by the size limit before the STAT lines can be
written to it.
Regards
Brandon
"contention "?
Memory? CPU? Disk? Latch? Something else?
http //www.catb.org/~esr/faqs/smart-questions.html
-Mark
--
Mark J. Bobak
Senior Oracle Architect
ProQuest/CSA
"There are 10Vivek
To me not having to perform a recovery because I assumed there was only one
table in the tablespace turns out I assumed wrong is what I call
efficient. So I would prefer to manually drop whaOn Tue Apr 24 3 11 "Ram Raman " sent
>Hi all
>
>I got a requirement from the developers to build a new table which has a column
that will hold every second of every business day. That is the I found a resolution to my LogMiner hanging issue. I was using the data
dictionary in my Logical Standby database for mining the logs since that
database receives the Production archived logs. My LoHi friends
Can someone here tell me how do we configure Hangcheck timer module in
Oracle 10g RAC implementation
which is on a RedHat Enterprise Linux AS 4 server which uses Oracle
clusterware as itI guess it is since Peoplesoft Peopletools 8.48 latest version is
using Server Express 4.0 and that is certified by PS to 10G 10.2.0.3
I suggest a sqlnet trace to confirm what you think you are seHi All
One of customer is upgrading their databases from 9i to 10gR2 because the
number of databases are more than 100 thats the reason customer is looking
for automatic
script to collect all pre-rHi
I may not be able to answer all of your questions. But in our
environment we follow the below script for Database backup to tape.
run {
set command id to 'ORACLE_FULL_BACKUP_ID '
Please read the documentation and create your own parfiles. It 's really
quite simple - see "Parameter Files " and "Export Modes " here
http //download-west.oracle.com/docs/cd/B10501_01/server.920/a9Not postive - never done it myself but I think he should be able to
make rman aware of the location of the missing backup pieces by adding
them to the recovery catalog with the CATALOG command
httOrasaurus (15 years plus) available April 30 onwards.
10.2 (AIX/Linux/Windows) and down including V.7 onwards.Shell scripting
OEM extensive datamodelling. Development and production experience.
ConOracle 10.1.0.5 RAC DataGuard RMAN Solaris 9 Veritas Hitachi SAN
I recently implemented LogMiner to use as a low-impact just-in-case auditing
tool and to get exact transaction counts for month-eAnand
Perhaps if you described your question more clearly. Your example seems
somewhat ambiguous. Can you provide more examples? Is the only difference
that one has no periods while the other has 2We are investigation if it is possible instead of using exp or expdp to use transportable tablespaces for moving tables with in them columns of type XMLType (CLOB storage) from one database platformdate_col < add_months(sysdate -24)
Jametong
DBA Team. B2B. ??????
delete table where record_timestamp < ADD_MONTHS(sysdate -24)
Regards
Mindaugas Navickas
Oracle&DB2 DBA
-----Original Message-----
From oracle-l-bounce@(protected) [mailto oracle-l-bounce@(protected) |
|
|
