 | | | Oracle List | | Hi
A related question. Will ODM on raw devices give better performance than just raw devices - because it shares file descriptor tables ?
Thanks
Joseph Amalraj
Steve Adams <steveAnyone have a good way of managing output from
V$LOGMNR_CONTENTS.SQL_UNDO when the undo statements span 3 rows within
V$LOGMNR_CONTENTS?
I 'm on Oracle 9.2.0.6 and need to undo about 200 000 INSERTs fHi Brandon
I agree that under normal circumstances this should not be an issue for
Oracle datafiles. But just because the filesystem is configured to use DIO/CIO
does not mean all IO against that
FYI The following was released by IBM today and was classified as a HIPER (High
Impact/Highly Pervasive).
APAR Number IY78323
A cached write to a JFS2 file resulting in a non-page-aligned
file sizCarefully document his incompetance (down time reasons email chains
warnings not to do that again etc...) and make sure all users have
his home phone and pager number. Besides that you are doing tYesterday afternoon our SA rebooted the server 10.2 on RedHat/VM Ware
with out insuring the database had shut all the way down. They still
haven 't let me modify the root shutdown script it 's still shi
We have got one client who is running oracle 7.3 and developer 1.2 (forms
4.5 & reports 3). now they want just to upgrade the backend to oracle 10g
but not willing to upgrade the developer until Charlotte
I 'm not familiar w/ the problem you 're having but isn 't this
http //www.oracle.com/pls/db102/portal.portal_db?selected 21 10.2 OEM
documentation?
--
Mark J. Bobak
Senior Oracle ArchitHi
As far as I understand from some research there are the following options
for connecting
Progress to Oracle
- use progress gateway for oracle
- use heterogenous services from oracle with odbc
- Does anyone know the script that is called from within Database Upgrade
Assistant (DBUA) that performs the backup?
<html xmlns o "urn schemas-microsoft-com office office " xmlns w "urn schemas-micros
--- tim.x.brown@(protected) wrote
> Oracle version 9.2.0.6 Enterprise Edition
> Solaris 2.8
>
> Can someone please definitively clarify if it is
> mandatory for foreign
> keys (not necessarilHi List
We are at Oracle 9.2.0.5 and using IIS and .NET for the webservices. The
development team planning to use the AQ feature. Here are some questions and
I believe the answer is YES for the fidba_tables.num_rows is just the count that was recorded the last time stats were gathered (e.g. with dbms_stats.gather_schema_stats or analyze table). You can find the date & time this happened last Based on the documentation which is still available on technet by
default EBU backs up the catalog after any backup operation. Not sure
why it 's disabled but when we used it (a long time ago) we I 've used SQL*Loader for years to load various data.
My current project requires a largish daily update to
a database table. Is there any way to do this with
SQL*Loader? If not I 'm looking at load
--- Jason Heinrich <jheinrich@(protected) > wrote
> I am attempting to create a function that will
> return a string from a text
> file based on a user-specified delimiter such as a
> page-break or "
Ah yes the wonderful encrypted password. The hashed string is stored in the listener.ora file so if you forget the listener password you can simply copy and paste the hashed string that was generatI think this is plaform dependent.
On HP-UX i created a file under user "oracle " tmp.ksh
> cat tmp.ksh
#!/usr/bin/ksh
date
then ran
chmod 7711 tmp.ksh
> ls -l tmp.ksh
-rws--s--x 1 o
If you have many users in the dump file you can do this
fromuser user1.user2 user3 user4
touser user1 user2 user3 user4
or even this
fromuser user1.user2 user3 user4
touser Fred BAnother (maybe not so) subtle difference is that
DELETE/INSERT will hit *every* index while updates
will touch only indexes on changed columns. (Won 't
they? I really shouldn 't be so daring with suOS Sun Solaris 2.8
Database Oracle 10.1.0.4
We plan on implementing the ODM (Oracle Disk Manager)
on our database in a few weeks. The datafiles
currently are on vxfs-based filesystems. AppaI am getting reports of a slowness issue so I ran a STATSPACK report. Ran
it through ORAPERF 75% of the response time is WAIT. 70% of the WAIT time
is virtual circuit status <http //www.oraperf.comHi
I use jdbc 9205 (for jdk 1.4) it 's ok.
On 2/16/06 sol beach <sol.beach@(protected) > wrote
>
> When jdbc oracle thin is used to connect to an Oracle database
> V$SESSION.USERNAME is blank & V$Hi All
If application running on Windows using OLE DB to connect to the Oracle database does I need to install Oracle Client on Windows Server? OLE DB not using tnsnames.ora file correct?
WhaLarge stable growing Systems software Consulting firm. They are in
search of an Oracle applications DBA to join a team that is implementing a
very Large Oracle Portal for a large government agencBased on information from Steve and other noted wait performance icons
I frequently warn customers about the dangers of an oversized shared
pool. Of course with each version of Oracle things change. DOracle 9i. I am running an update statement from one schema to update some data in another schema. The update statement in pl/sql block was successful (test1). But if I use dynamic sql (test2) to do I don 't have the actual answer to your question but I 'd suggest trying
out the latest JDBC driver from 10.2 even if you are connecting to 9.X.
Supposedly a lot of stuff that was being done using PHi Luca
not many chances for a multipath there.
But you can rely on the failover capabilities of qlogic driver.
Not many changes are necessary.
Regards
Fabrizio
> Storage is on FC arrays attacheHello see questions below ....
select low_optimal_size/1024 low_kb (high_optimal_size+1)/1024 high_kb
optimal_executions onepass_executions multipasses_executions
from v$sql_workarea_histo |
|
|
