 | | | Oracle List | | Hi guys
In control file trace I could not see DEFAULT tempfile and
dba_temp_files also does not have any record.
But if I added any new temp tablespace I could see
this in both?
Could someone putupgrading from 10.1.0.2.0 to 10.1.0.3.0 solved the problem...
special thanks to Gogala.
thank you all for your answers.
-----Original Message-----
From Gogala Mladen [mailto Mladen.GoOn Mon 25 Oct 2004 09 32 44 -0400 Sami Seerangan <dba.orcl@(protected) > wrote
> Hi All
>
> Any comments?
If management is willing to commit to a technology because
"somebody recommended it "Hi
Thanks for the replies on this. Directing an extra channel to the disk
getting less data sent to it helped. But it turns out that the disk unit in
question is having a cache problem due to a faHi Carel thanks for your other insight solution.
we are on oracle 9i. Unfortunately we use the 2nd db
for batch process (after the exp-imp).
regards
tomi
--- Carel-Jan Engel <cjpengel.dbDear all
this questiion is related to ibm tivoli usage.
i write a dmp file to tivoli using the dsmadmc command.
now i want to list the files in the dat.
how do i do this.
pls mail baHi
Is there any data dictionary which will help to find the procedures or
functions that are getting executed currently and from which node(IP address
or machine name) had invoked the execution?Something that has changed - just a tidbit nothing major.
I know that the controlfile block size used to be 8 KB in 8.1.7.
I didn 't really pay much attention to it in 9.2.
Here in 10.1 the controIn article <417D329E.000001.01420@(protected) > Juan Carlos Reyes
Pacheco <jreyes@(protected) > writes
>Tim I agree with you
>And his site is full of several useful things.
>
>http //oraHi.
exec DBMS_STATS.GATHER_SYSTEM_STATS(gathering_mode > 'INTERVAL '
interval >1/24)
Or this is a wrong way to get system statistics? and is better to gather
system statistics only in the momedont see any harm in putting this on oracle-l. cary probably just didnt do a reply to all.
the chart is very useful.
System stats give the CBO information about how fast your CPUs are how long
single and multi-block reads take and what the disk throughput is. It can
make a very big difference in the execution pAll these talks about why CPU usages should be
below 100% would make an experienced Mainframe
system programmer -that is an syste administrator
in unixspeach for self-respecting system administratoI am performing a ctas (create table as select ) and receiving the
infamous Snapshot too old error. I 'm not clear as to why because the
table that I am querying is not being updated. In fact iHello Edgar
you might (or better might not) want to try the NL_SJ hint inside each
subquery. This works but is deprecated in 10g and it 's slow (for your
example) since the subqueries are scanneJust a small test since the prev mail was unreadable...
--
http //www.freelists.org/webpage/oracle-l
I fiddled with this a while back. I believe you 'll find that maxpiecesize
will limit how large an actual file will become (handy if you 're trying not
to exceed 2GB). Maxsetsize will limit how largAll
We 're moving our Oracle Apps 11.5.6/8.1.7.3 single-node environment from
Tru64 5.1b to AIX 5.2. At one time it was 10.7 upgraded to 11.5.4 and
then 11.5.6. We 're following the Oracle Apps/On Fri 22 Oct 2004 10 36 35 -0700 Web Stalkers <webstalkers@(protected) > wrote
> Still getting used to the default reply to sender...
Yeah I find that very annoying. I have already written to GoBefore I resort to perl search the universe of directory walking does
anyone know off hand where to hack the .xml (or if it is somewhere else) so
that 10.1.0.2 grid runInstaller stop insisting thatHi all
This is for prospective IOUG presenters (and those of us who are
procrastinators!). The call for speakers has been extended to 29th. More
details at http //w3.ioug.org/call2005
RegardsStephen
I have found that when I have trouble with metalink letting the sales
rep know your level of disatisfaction works well at breaking things
loose.
>
> See Note 229773.1 - ALERT Applying Multiple Interim Patches Using
> OPatch Can Cause Inventory Corruption
>
Hi Paul
Here are the results from my linux server which has 8.1.7.4
9.2.John
We were running into the same issues on several of our servers (both linux
and windows). We discovered it was a password issue. The password for dbsnmp
was not right. We altered the passwor
From DENNIS WILLIAMS
Sent Friday October 22 2004 9 12 AM
To 'Peter.Hitchman@(protected) '
Subject RE rman backup to disk mismatch in amount backed up to each
channel
Peter - I could oDear Mr.Gogala
On Fri 22 Oct 2004 Mladen Gogala wrote
>and don 't post this elementary stuff on the
>oracle list. There are many other forums which
>would be much better fit for elementary UnixPrem
The ProFTP make this perfectly. I recommends !!!
Go to http //www.proftpd.org and be happy.
Fabio
Fabio Rodrigues
Unix System Administrator - DBA
Cetelem Servicos
55 11 3177-0321
SGVsbG8gRWRnYXIsDQogDQp5b3UgbWlnaHQgKG9yIGJldHRlciBtaWdodCBub3QpIHdhbnQgdG8g
dHJ5IHRoZSBOTF9TSiBoaW50IGluc2lkZSBlYWNoIHN1YnF1ZXJ5LiBUaGlzIHdvcmtzLCBidXQg
aXMgZGVwcmVjYXRlZCBpbiAxMGcgYW5kIGl0J3Mgc2xvI just received an email from Oracle Global Product Support
announcing that they had found a "problem " with the original
version of the patch. Has anyone else received this and
tried to install itHi
We back up an Oracle 8.1.7.4 database to disk using rman. Its about 900 Gb.
It does work but we find that much more data is getting sent to one channel
than the other. So when its done one fi |
|
|
