 | | | Oracle List | | Google is my friend. It can be your friend also
http //www.orafaq.com/node/158
On 08/10/2006 04 08 01 PM Hostetter Jay M wrote
> I know there has to be a simple way to do this but my brain can 't put
> it togther this afternoon. I have a parent table (accounts) and a child
When I alter a job to do full logging I don 't see any additional
logging for the job in the *_job_log table compared to basic logging.
does anyone know what kind of logging is done? Where can I findHi all
A group of Solaris 8 servers that I support are experiencing some unusual errors. This occurs mostly in the middle of cron jobs. A User Signal 2 message is received prematurely terminatingI am surprised to see so many negative reactions to this feature. First off
I want to be able to do what I want to be able to do. Having a feature like
this is not a bad thing just because it can be Yes have a look at the procedures available in the dbms_stats package.
Quoting Syed Jaffar Hussain <sjaffarhussain@(protected) >
> Is there any way that we can set fake statistics to a particular
> pWanting to go from 32-bit Windows 10gR1 to 64-bit Windows 10gR2.
Saw this in the upgrade manual
If you are installing 64-bit Oracle Database 10g software but were
previously using a 32-bit Oracle Danyone ever restore a backup directly with dbms_backup_restore?
I 'm running 8.1.7 on winders(not my choice). The rman backup is true Omniback and is controlfile based there is no catalog. Normally I
> > > "Niall Litchfield " <niall.litchfield@(protected) > 08/10/06 04 37pm
> > >
> > normans point is excellent especially when you consider when a
resync
> > happens. niall
Norman 's spelling on the other h
Ok my RMAN skills are very very very waek but I think if you gzip the
dump files you are ok unless someone does a resync of the catalogue
(excue technical terms - which may be wrong) as I beleive
Morning Brian
> > Brian Lomasky <lomasky@(protected) > 08/10/06 01 55am > > >
> > An alternative to using Trace Analyzer to analyze a 10046 trace file
is
> > to use trace_report.
that is one sca
Juan Carlos Reyes Pacheco wrote
> Thanks a lot Dennis I know how big they are but if you want to
>start one you have to start from somewhre I know about accounting
>employee etc.
> Julian Dyke has a presentation logicalio.ppt.
there 's a slide that shows the different ways to set the prefetch
that Christian mentions.
Row Prefetching
Applies to
OCI OCI_ATTR_PREFETCH_ROWS
Pro*Jeremiah
Yep.. I had DULled an ASM instance long back. It works
Basically you need to provide the disk names in the controlfile and then DUL will be able to read and understand.
Have a nice da
In MS Access it 's File - > Get External Data - > Import (then choose the
ODBC Datasource option)
Thanks!
Doug
Well I 'm guessing you want Oracle to create those 700 users for you. Not
knowing more about your situation here is what I would tend to do
- System-level export with ROWS N.
- Import thaempty_clob() will use 16 bytes. while NULL just 1 byte
On 8/10/06 Greg Faktor <FAKTORG@(protected) > wrote
>
> Looks like I should look on default value for clob column. If it has
> empty_log() defauCharles
> So the next question how is that useful to dbms_stats?
They use it to compute the average row length.
Formerly that value was computed with the function VSIZE.
HTH
Chris
--
http //www.Hello
I installed the 'Netbackup for Oracle Advanced Client ' on a server with 3
databases. Currently I already have a master server with databases on it
and it backs up to the tape drive well. On 8/9/06 Riyaj Shamsudeen <rshamsud@(protected) > wrote
>
> Syed
>
> > >We are oftenly getting 'log file sync ' and 'log file parallel wait '
> wait event.
> How much time is spent on these waits by tThe following link was one of the best I found. There were a few
dependencies that needed to be installed IIRC and some direct grants on
some SYS objects.
http //www.psoug.org/reference/trace_analy
Hi
We are trying to do a Query and index modeling exercise by attempting to
MAP a significant portion of our Product 's Queries to corresponding
basic Standard SQLs for SMALL MEDIUM BIG & Very BMichael
You can backup to disk then move the backupset(s) to tape. If you need to
restore however you 'll need to dump your tape back to disk. There 's no way
(that I know of) RMAN can write or rHello
I have a 2 node cluster called "PROD " running 10.2.0.2 on ASM. I am
using flash recovery area.
I need to create a standby of this cluster. Do you think sharing the
ASM disk with the FRA (flaGlenn
This difference between EE and SE makes no sense to me so you may want to
investigate it further like try to create a compressed table in your SE
database.
I usually prefer to create theI 've run into a bit of a problem and I 'm looking for a work-around.
I have an export from a 9i EE database that I need to import into a
10gR1 SE database and the compress/nocompress keywords in the eHi All
I am in the process of reorganizing an IOT columns so the active columns (which
has been added later) can be grouped together and non active (future
enhancement) columns can be kept in the ovHas anyone successfully mounted an oracle database using freenas?
I have attempted to create a new database and clone one using a control file
to a directory on an NFS mounted FreeNAS drive and it juHi
on one of ours SF890 (Solaris 9 20GB RAM 20GB swap) with oracle
8.1.7.4 32-bit installed.
We experiencing memory leak there is less and less swap space from 20GB
free
to almost 0 in 5-6 dayJuan
You 've set a rather ambitious task for yourself. First of all ERP is mainly
a buzzword. It consists of whatever a company decides it should. As you have
stated an ERP consists of modules. The |
|
|
