 | | | Oracle List | | If found this parameter
alter session set "_optimizer_cost_based_transformation " OFF
on 313746.1 metalink note.
But this reduced to 1.72s not to the original time.
I 'm asking if someone has anotherI did preferences/rules and then for the "out of box " stuff selected
"send email ". Did not get it.
Next did setup/rules did "subscribe to rule " - still no email.
Test email does work.
Any otDo any of the data dictionary tables show if a PLSQL object is compiled in
DEBUG mode?
Do any of the data dictionary tables show if a PLSQL object is compiled in DEBUG mode?
Snp processes restart automatically.
Igor
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)] On Behalf Of Alessandro Vercelli
Sent Friday March I have been out of the Oracle world for some time now (4 years to be
precise) and when I left we were not using RMAN.
So my advice to you from personal experience (in the last month)
is............Fred
What does services.ora tell you? does it contain entries for all the 10
databases?
you should find the file in $ORACLE_HOME/network/agent
cheers
anand
On 31/03/06 Mercadante Thomas F (LABOI am currently using OEM Grid Control 10g release 2. I could never get
it successfully loaded on a Solaris server. Instead we configured a Red
Hat Linux server specifically for it. The only problemYou can only do alter database ..
if csscan shows only changeless data with from and to characterset of your
desire.
Data is changeless only when the target characterset is a binary
superset of the
Some people call this consolidation. With IBM 's help
I tested 60 10g databases in a 14 node cluster (12 with 5
instances per and 2 servers for hot standby). There
were some lessons learned. I think Hi
We have a nice bunch of pl/sql code and perl to add drop all partitions
Range partitions on a weekly or monthly basis . I am looking for a data
driven model ... anybody know of examples out thereWe found the solution to our (own-created?) problem.
As I mentioned in this thread earlier we had upgraded
to 10.2.0.2 from 10.1.0.4 and found some of the
queries behave very poorly. When as suggeI have a largish (?) table that I wanted to export using expdp
(10.1.0.4). This table is partitioned and compressed and has about
700m rows.
Compressed size of this table is ~90gb when I used expdp On 3/30/06 Ken Naim <kennaim@(protected) > wrote
>
> Setting wrap off caused the first line of the header to be printed and
> skipped everything after the first chr(10) (header lines 2 and 3 and data
>Jay
I don 't see where anyone responded to your posting so I 'll give less than
expert opinion.
So you 're getting an "invalid number " error? Review this AskTom discussion.
Apparently this ORA-01772 cEven with specifying DEGREE 4 the dbms_stats
internally generates this Hint to use
no_parallel_index when processing the Indexes for the
table being analyzed. Any ways to force it to use
parallel or Company with locations in Atlanta Georgia and Illinois needs an Oracle DBA
for a 1-2 month contract position ( W-2 preferred)..could go longer.
**Candidates MUST have Oracle DBA experience in an manHi Larry
I implemented your requirements while developing an application
some years ago.
Here are some implmentation details
1)I wrapped the connectionpool class and the calls for
getting/releasidrc* log in bdump directory should list errors ...
"Upgrade the instances first " ? What is that ?
> > >-----Original Message-----
> > >From oracle-l-bounce@(protected)
> > >[mailto oracle-l-bounce@(protected)] On Behalf Of Tom Fox
> > >Sent Wednesd > Is there anyway to map sessionid (or any other parameter) from
> dba_audit_session to a specific process to get more information on what
> it actually is that is running? My system password keeps lHi I had decided to start a free project to desging partitioning
this is always free not open source.
I think the concept is too simple
And I askyou please to pointme some mistake or improvement inHi Younis
VLM can only work with DB_BLOCK_BUFFERS BUFFER_POOL_KEEP & BUFFER_POOL_RECYCLE
db cache advice doesn 't work with deprecated parameters DB_BLOCK_BUFFERS BUFFER_POOL_KEEP & BUFFER_POOL_REJust so that nobody remains uninformed
On Wed 29 Mar 2006 02 09 49 +0000 Mladen Gogala wrote
> On Tue 28 Mar 2006 10 06 31 -0800 Bart the bear wrote
>
> > Look instead on OTN and on this grouHarvinder
Take a look at GRANT SELECT ANY.
Unfortunately that doesn 't restrict them to just USER2.
Why not grant access when the table is created? You don 't need access before
the table is created.
Is anyone out there using the Oracle Text Classification or Clustering
technology? We are looking into to using this and there is only such
much you can find as far as documentation. Would like to kWhat 's wrong with trying metalink?
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)] On Behalf Of Jeffrey Beckstrom
Sent Tuesday March 28 2006 12 >I put this on some java forums and was told it wasn 't possible. We have
>background processes that wake up and do some data processing. These
>processes are in java and connect through the JDBC.
> Does anybody know the cost of the transparent gateway for MS SQL Server.
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)] On Behalf Of Juan Carlo
Brian
you can use SYS.USER_HISTORY$ if your database is configured to do so
otherwise no can do. See here
http //asktom.oracle.com/pls/ask/f?p 4950 8 F4950_P8_DISPLAYID 30443328681663
For |
|
|
