 | | | Oracle List | | One initial area of disappointment in 11g is that pretty much every
"significant " new feature is now an extra cost option....
Real Application Testing
Advanced Compression
Total Recall
Active Data GLyall
Extents from temporary sort segments are allocated to one sessions at a time only and are not deallocated until that session frees them. They are not shared between sessions.
I think i
I can 't disagree enough with #4. Most of our customers who are the most successful with RAC do so with a mixed configuration of OCFS2 and ASM. OCFS2 is used for spfiles password files an archive I ran
SQL > audit insert table update table delete table
Audit succeeded.
Then I did some updates on a few tables owned by myself. But I see no entries in the sys.aud$ table recording my activitall
is there any possibilities create manual sql profile??
from DBMS_SQLTUNE package i could not found the procedure/function
to create it manually....
thanks for the sharing
--
regards
ujang
You 're right Mark.
thanks for the URL
Alvaro
> 1 > it depends on what you are going to use for the 'file system ' (ASM or
RAC)
Sorry little typo ASM or OCFS2
Torsten.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN " >
<HTMLHi Laura
reading the docs is a very good starting point... -)
do not forget to download the patches (10.2.0.3.0)
1 > it depends on what you are going to use for the 'file system ' (ASM or
RAC)
2 > NI was at an Oracle sponsored conference in Long Beach CA today.
Tom Kyte & some VP announced that V11 is/was officially released TODAY!
On 8/14/07 Peter McLarty <p.mclarty@(protected) > wrote
>
> On that same point there is a press release on Oracle 's website stating
the 11g is GA time is 5am on the 14th maybe your SR was just a
fraction too early
http //www.oracle.com/corporate/press/20See my earlier post. Kick support in the behind tell them to get with the
times. 11g IS Supported officially. Tell them the Beta office said it was
being supported and get a manager.
DO NOT TAKE NOI have talked to Oracle. 11g IS supported through official channels. Push
back on support if they are telling you that it is not as long as you are
licensed to use the product or any options.
RF
RoOK that all makes sense now i have another question. What should the
pctincrease be for a Temporary tablespace? In database creation scripts
i 've seen from Oracle Rollback Temp and User tablespaDoes this have to do with the platform you are listing
in the SR? Has anyone tried an SR listing LINUX as the
platform and gotten this error?
RF
--- Andreas Piesk <a.piesk@(protected) > wrote
> Allen A tempfile is not just another datafile. For one thing it 's initially
sparse. For another a tempfile tablespace does not need to be backed
up and at recovery time is simply (and quickly) recreatWe have a notice that Beta CSIs will cease to be usable as of September 7.
Infer what you will from that!
Regards
mwf
_____
From oracle-l-bounce@(protected) [mailto oracle-l-bounce@So I am tasked with installing RAC on a 2 node cluster. I am 1/3 of the way reading through the documentation and am scratching my head with OCFS OCFS2 ASM.
If anyone can take the time and verify aAllen Brandon schrieb
> Not sure if anyone else has had this experience but I opened an SR with
> Oracle for an 11g question and was told the following today (8/14)
>
> "11G production release iJust a dbfile like the others.
Just curious which Oracle release you run? 8i?
Alvaro
just ran an update that had some stupid huge joins and couldn 't allocate
anymore extents because the 4gb of datafiles were too small. So
my update errored. then no problem still just that my temp nah! error checking is for wimps...
more seriously the issue that I have is that opatch is for one-offs. Some
one offs require other setup steps than just opatch - and might require for
example earliNot sure if anyone else has had this experience but I opened an SR with
Oracle for an 11g question and was told the following today (8/14)
"11G production release is not yet out and so we from ProOn 8/14/07 Mandal Ashoke <ashoke.k.mandal@(protected) > wrote
>
> Greetings All
>
> Do you have an idea about a good study book for the following OCP test.
> 1Z0-045 *Oracle Database 10g DBA NewHi
Try something like that
for i in [0-9]* do cd $i opatch apply cd .. done
Of course test this out first in some dummy environment also you might want
to add some error checking to the The instructions are pretty specific on this. CD to the directory into which you copied the CPUJuly2007 file before expansion and run opatch with these arguments.
napply ./6079591 -skip_subset -s
Greetings All
Do you have an idea about a good study book for the following OCP test.
1Z0-045 Oracle Database 10g DBA New Features for Oracle8i OCPs
Thanks
Ashoke
What is a TEMPORARY TABLESPACE?
It is a tablespace that holds temporary objects used for sorts joins etc
when they don 't fit into memory.
Temporary tables are also stored there.
The TEMPORA temporary tablespace is what you want for TEMP.
I 'm curious as to how you think you blew it up and even more curious
as to how Oracle let you drop it. What version of Oracle are you
using?
Don.
Hi all So i blew up _the_ temp tablespace the other day with an update
query *pats himself on the back*. I found some down time and dropped it
looking up on the web how to recreate it i found CREIs there a way to force opatch to apply all patches with one command?
With the chagne in opatch it installs numerous directories like below
-bash-3.00$ ls -ltr
total 214
-rw-r--r-- 1 oracle dba |
|
|
