 | | | Oracle List | | what happens if you try and do this without parallelisation - or with a
lower degree?
On 7/18/07 genegurevich@(protected) <genegurevich@(protected) > wrote
>
> Hi all
>
> I think I have posted onYou might be able to use the -mmin qualifier to the find command
depending on the version of Linux.
Something like
find $DMPDIR -name "* " -mmin +1380 -exec rm {} \
Would delete all files older t
Folks
How are the Oracle Cluster Registry (OCR) & Voting Disk (VD) to be Made Concurrently VISIBLE / Shareable to BOTH Database (Solaris 10) Nodes?
Same is seemingly needed to initiate the CRS instaCould this be the note you 're looking for?
'Implementing Address Windowing Extensions (AWE) or VLM on Windows Platforms
<https //metalink.oracle.com/help/usaeng/Search/search.html#file >
Doc IDHello
In a RAC enviroment is it possible to have 3 network interfaces 1 for
interconnect 1 for public and 1 for backup if either public or interconnect
goes down is that possible? We are talking O The switch is no relevant to 64 bit platforms.
On 32 bit platforms any process can address 4 GB memory (this is 2^32 bytes) but has the right to use only the lower 2 GB (minus some kylobytes at thWe tried to setup ORACLE RAC under VMWARE. I follow
document
(http //www.oracle-base.com/articles/10g/OracleDB10gR2RACInstallationOnCento
s4UsingVMware.php) setup share disk under VMware and
use indehttp //www.oracle.com/technology/deploy/security/critical-patch-updates/cpujul2007.html
"Executive Summaries Oracle Database Executive Summary
This Critical Patch Update contains 20 new security fixOracle Heterogenous Services may be an option for you...depending on
your situation...
http //www.databasejournal.com/features/oracle/article.php/3442661
Hi all
I 'm finally getting ready to roll out OID here. Some of you may
remember my previous postings WRT OID a year or more ago. Well the
wheels turn slowly around here but if all goes well Mark
I think of the PL/SQL compiler as lint itself because it is so picky.
-) PL/SQL being a strongly typed language will refuse a lot of dubious
syntax. As I read the article you forwarded on lIs there any where I can download this version....I can only see
10.2.0.1 for AIX on Oracle Technology Network
John Dunn
Product Consultant
Sefas Innovation Limited
Direct Dial + 44 (0) 117 Hi Stefan
comments inline
On 7/16/07 Stefan Kuhn <skuhn@(protected) > wrote
>
> Hi all
> I am new to oracle and views and I have two questions
> 1. How can I add a new integer columns which canHi
Have you checked note
Subject Unable To Add A New Instance To Rac
Doc ID Note 264643.1
Fadi
-----Original Message-----
From oracle-l-bounce@(protected) [mailto oracle-l-bounce@(protected)Be very careful and definitely run csscan.
I worked with a customer in Thailand that had an applicaion where the
front end was cobol. The database had USASCII7 as the characterset and
for whatever reaHere is something i have been using for the last few years with
good results (pulled this one from asktom long ago .. worth its
weight in gold)
$ more getcode_all.sql
set heading off
set feedback off Hi
Apart from explicitly putting datafile or tabespace in offline
mode though alter database..... or alter tablespace..... command under
what circumstances would STATUS column in v$datafile List
There are datasheets available now on the 11g Diagnostics & Tuning Packs
(along with several other white papers and datasheets at
http //www.oracle.com/technology/products/database/oracle11g/inot sure what you are looking for I have used oraenv with rAC with
modifying anything?
if you wans a list just add cat oratab at the beginning of script
On 7/13/07 Charles Schultz <sacrophyte@(protected)Sounds like prefetching at work - I think it has been on by default
since 8i or 9i
http //download.oracle.com/docs/cd/B10501_01/appdev.920/a96584/oci04sql.
htm#428255
Privileged/Confidential InformAfter much deliberate (non guessing) work we think we know the reason
for the sudden change in the performance of some of our sql. I 'd like to
share it with the group since so many people added to tHello Sanjay
Have you looked into using IP Multipathing? We are not a Solaris shop.
But I have seen docs on the web (Google is your friend) on how to
configure it. You would need to run vipca and canyone know how to undrop objects after a bugger 'd recovery system tablespace is from after datafile. objects are not defined in obj$. all blocks in needed datafile show up in dba_free_space. The sysI get this error in the oracle alert log on AIX 5.2 after running
0racle 10.2.0.1.0 for approx 12 hours
Any idea what it means?
Memory Notification Library Cache Object loaded into SGA
Heap size I won 't provide all details as a lot depends on what you want and
what 's available. Ask specific questions if you want more details.
Are you going to use the same storage?
If so than you just need toIf all else fails
find / -type f -name oracle -ls
... and go have a cup of coffee or two )
Stefan
On 7/12/07 Sanjay Mishra <smishra_97@(protected) > wrote
>
> I got one AIX server where I want Cosmin
You can execute something like this
for x in (select y from z where ...)
loop
-- do processing
rowcount rowcount + 1
if processing_by_batch then
if error_was_detected theToo much to cover it all.
First indexes absolutely can be used by queries containing inequalities in
the predicate for the relevant columns. Whether they will be used depends on
your statistics (
probably more than you were looking for in regards to lat/lon queries but here you go.
>2. if you were to try how would you know the exact value and precision? -109.92638889 or -109.92639 PiBJZiB5b3UgaGF2ZSBhbHJlYWR5IGRvbmUgdGhhdCBleGVyY2lzZSBhbmQgYWxsIDMgZGF0YWJh
c2VzIHlvdSBtZW50aW9uIG1lZXQKPiB5b3VyIHJlcXVpcmVtZW50cyB0aGVuIG15IGJldHRpbmcg
aXMgdGhhdCBNeVNRTCB3aWxsIHdvcmsgb3V0IGNoZWFwZX |
|
|
