 | | | Oracle List | | Hi Dennis
Thanks for the comments. No this is Oracle bug in the implementation of
the provider since if we use (for example) Microsoft OLEDB provider
these queries are not generated.
AnywaThe Rocky Mountain Oracle User Group (RMOUG) will be holding it 's 18th
Annual Training Days conference in Denver Colorado USA on February
13th and 14th 2008. This event draws almost 1 000 attendeAlvaro
I am not an OLE / ADO programmer so I can 't explain this properly. At a
previous job I had a good VB programmer accompany me and explain this
situation in terms that other VB programmers coulPatrick
The certification process seems like a never-ending treadmill. By the time
you get certified that is no longer the newest version of Oracle so your
certification means less. If you choose VanZanen J (Jacob) wrote
>
> Hi All
>
>
> I just moved to Australia and was wondering what is around sydney the
> best/cheapest place to get my hands on Oracle books?
>
> Just amazon or are there oI 'd suggest that there is enough reward in going to ASM in a single instance
server. Your most obvious benefits will be even distribution of data across
all spindles. Its like folding all your filesysThat should work just fine. Oracle will only use blocks it has initialized
so everything outside that range will be ignored.
Randy Johnson
-----Original Message-----
From oracle-l-bounce@(protected)Well after reading Tom 's comments I 'd say there is not enough room in here
for his ego anyhow.
Good riddance Tom. Go masturbate your ego somewhere else.
Ooo. Is it getting hot in here?
__What are you seeing in your ASM alert log? Try starting it just using
sqlplus and check the alert log.
-Randy
_____
From oracle-l-bounce@(protected) [mailto oracle-l-bounce@(protected)I 'd recommend ASM. There is safety in numbers and that is where the numbers
are. I also get the feeling that ASM is Oracle 's strategic direction for
shared storage. I know I 'm going to take some flak Hi All
I just moved to Australia and was wondering what is around sydney the
best/cheapest place to get my hands on Oracle books?
Just amazon or are there others?
Thx
Jack
In this situation you could add the column allowing nulls AND add also add
triggers to reject any insert / update that leaves the new column null.
When a table gets to the state where every row has Not sure what version you 're on but I ran into a debilitating bug related to
exactly this situation in 9i. I needed to add a column added it as suggested
by others (alter table add column populateOn 9/4/07 Joe Smith <joe_dba@(protected) > wrote
>
> Can somebody tell me what is
>
> "Oracle Enterprise Linux 5 "
> "Oracle Enterprise Linux 4 "
>
> Under the OS columns in the cert martix for Linux xHello OCP 's.
I have some free time at night and I 'm looking for a good book to read/study from geared toward the OCP exams.
I believe these exams are the 1Z0-042 and 1Z0-043. Any suggestions wouNot sure why you would use it when there ocfs2 is widely available on Linux.
-----Original Message-----
From oracle-l-bounce@(protected) [mailto oracle-l-bounce@(protected)] On Behalf Of ryanOn 9/4/07 Jost J?rg <Joerg.Jost@(protected) > wrote
>
> At some important points this application locks rows with dbms_lock.
>
> The lockname is the rowid of the row. Sometimes an evil user stays
>Oracle providing Linux support and their own Red Hat-based distribution
was THE big announcement at OpenWorld last November.
http //www.oracle.com/technologies/linux/index.html
Note that they 're nI thought that the reason Gene wasn 't doing that was to avoid wholesale row
migration. What you 've suggested certainly will work but it has the
potential to adversely affect performance. Whether that
Alter the table adding nullable column
Populate column
alter the table modifying column to be not null
Update statistics
-- Mark D Powell --
Phone (313) 592-5148
-----Original Message-----
From Can somebody tell me what is
"Oracle Enterprise Linux 5 "
"Oracle Enterprise Linux 4 "
Under the OS columns in the cert martix for Linux x86 and x86_64 these
entries are present. Along with entries So this explains nicely DBA Deepak 's test case.
But back to one of the the original questions - is the log buffer
managed dynamically
by ASMM that is can its (real) size change after instance boot Hi all
I have several medium to large fact tables to which I need to add a NOT
NULL column. In the past I would do the following
- copy the data from the fact table to a backup table
- truncate theNot sure why you would use it when there ocfs2 is widely available on Linux.
-----Original Message-----
From oracle-l-bounce@(protected) [mailto oracle-l-bounce@(protected)] On Behalf Of ryanIf I 'm not mistaken log_buffer will be automagically sized at instance
startup if using ASMM effectively ignoring the setting of the log_buffer
parameter. This is eluded to in the paragraph below ywould you recommend GFS?
Hi John
As per your notes on 32-it windows the granule size is 4M which I verified
on my system. But the log_buffer size that Oracle did set (in my example
below) is not equal to the granule size. John
The other option is to populate your fields using javascript. That approach
is not as straight forward but avoids the overhead of performing the
submit. There is a lot of information availablLog_buffer sometimes cannot be specified exactly as it depends on what
chunk or granule of memory is available. See the notes below re granules
With dynamic SGA the unit of allocation is called a |
|
|
