 | | | Oracle List | |
On 03/13/2006 05 49 28 AM Yechiel Adar wrote
> I am pleased to inform you that I signed a contract to buy a new house.
> We are moving to a private home from an apartment.
Congratulations. Don 't fKamus
>But can anyone prove if that block is dirty will
>DUMP action cause the DBWn to write this block
>into disk or not?
"prove " is big word... I 'll limit myself to show you that in my case theIf you are using McAfee antivirus software on your win32 Oracle servers -
check your logs.
It attempted to remove files such as Dell OpenManage Cygwin perl
Sysinternals pstools suite.
Basically aJ
> If I wanted to go back and do a restore only up to the point
Yes you would recover to the point in time that you select past the time
you took the hot backup. The archive logs from that timeA
I 'm guessing your concern of rcp vs. mounting it is one of synchronicity
not security.
I 'm guessing you are writing RMAN backup to disk rather than using an MML.
I 'm confident that RMAN won 't u
Not a shameful plug as it may appear. There were 20 something
folks on list that wanted to see this paper.
http //www.polyserve.com/pdf/Oracle_NFS_wp.pdf
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTMLHi!
What I want is something like select col1 ... xmltype(my_blob_col) from
tableWithBlobColumn.
Yet I have an oracle 8.1.7.4 db storing xml as blob. (yes yes it should
have been clob but it wasFor the record I actually ate it afterwards.
On 3/10/06 Jonathan Gennick <jonathan@(protected) > wrote
> Once again another Hotsos Symposium has come and gone. Many
> of us had dinner together on T >I have a 9.2.0.6 DB that was created with AMERICAN US7ASCII character
> set.
> When our heavy PC client inserts into a LONG type column and the number
> of characters is more than 2k we get
> ORA-031Folks
Is there anyone using this setting (_row_cr) with their 9i2 (9.2.0.6)
RAC environment? Could someone please shed some light on under what
circumstances this setting can help. We have a performaHi
I have seen this generally to be incorrect in 9.2 and I set it manually using dbms_stats.set_system_stat.
The default value is -1 but that happens when you do not have enough multiblocIf it threw you how come you didn 't just test?
--
http //www.freelists.org/webpage/oracle-l
You could create a table with
fields
range_limit_name
lower_limit
upper_limt
and join this table with table_name with numeric_value
where clause can have condition where Sorry if this is a bit off topic but I imagine that a few of you may
have encountered this in the past...
Recently I have observed a couple different Linux boxes (I 'm reasonably
sure both were RHELHi!
I see you make an correct use of rownum but I better like the use of analytic functions...
Greetings
Bjoern
----- Original Message -----
From Mercadante Thomas F (LABOR)
To bnsarma@(protected)Well since you brought up the subject of RMAN let me ask this what
version of the database will you be running? If it 's 10g you 'll
definitely want to look into using incremental backups in conjuAnyone have an e-copy of Bob Sneed 's "Oracle I/O Supply and Demand "
white paper? He mentioned it during his Microbenchmarking session at
Hotsos on Tuesday yet my googling and searches on Sun 's siteInteresting -- "wait-free " DB
http //www.eweek.com/article2/0 1895 1934569 00.asp
Funny I didn 't know a DB could implement infinite CPU capacity. )
Rich
--
http //www.freelists.org/webpage/oracI have seen the same thing.
If you do not put a decent load on a standalone server adding additional
servers in a cluster will cause things to run slower.
One customer POC I was on ran a single appHey all
In 9.2.0.5.0 I have a request to add 10s of thousands of rows of bogus
data to a table for a single report. Instead of fudging that data I
thought I 'd create a view. Here 's a sample of tOne minor correction to Brandon 's otherwise great post
Incremental backups are available with Standard Edition starting with
10gR2. DBAs working with
earlier releases of SE may find the upgrade toHi Pete
Looks like you probably already know this but in 9i CDC uses
row-level triggers. In 10g CDC has an asynchronous option which uses
Streams to get changes from the redo log with less impact That is a great paper Mike ault also has done some research in this field.
SSD is good for redo temp and undo.
I do not know how optimizer will handle other tablespaces. As currently the
On 03/09/2006 09 12 05 AM genegurevich@(protected) wrote
> I was refering to the fact that i had multiple tables in my query and they
> all have PKs. I should have been clearer though andSorry I forgot to send my Vmware confogurations (only the shared storage relevant part)
disk.locking "FALSE "
diskLib.dataCacheMaxSize "0 "
diskLib.dataCacheMaxReadAheadSize "0 "
diskLib.dataCaHi Listers
I am trying to setup 2 nodes RAC (10G R2 Linux) in VMWARE (for self-educational purpose of course).
After installing OCFS2 und mounting the "shared storage " in both nodes (Hostnames rolling back a large transaction
On 3/8/06 Ebadi Abdul <Abdul.Ebadi@(protected) > wrote
>
> We were forced to do a shutdown abort then started the instance up
> normal but a shutdown immediate rigI do believe that the answer is no data transferred between the client
and the database after logon is complete is not encrypted without the
Advanced Security Option. You would need to scope the linHi
On Wed 2006-03-08 at 10 51 -0800 Bob Robert wrote
> All
>
> We are planning to setup Oracle 10g RAC as a proof of concept. we would
> like to start with two node configuration first. Right Hi
> Our backup scritps use the traditional exp tool... and we found
> this in the log...
By the way... Remember that neither exp nor expdp exports the user XDB (and a couple more...) even if a ful |
|
|
