 | | | Oracle List | | Use this simple SQL to generate the Tables list of your *.par file. Just
remove the comma from the first table in the list.
Select ' ' || Table_Name
See Metalink 1944773 and 264174.999. I suggest you log a TAR.
2006/6/15 Alfonso Le?n <aleon68@(protected) >
> Hello Everyone
>
> I have a internal query that is executing does anybody has saw it befoHi All
Is there any specific dynamic performance table to find out whether my database is
RAC database or NON-RAc database.
We can do a count on gv$ tables but when i lost all nodes Hi All
When my porgramme tries to write to a file using the utl_file.putf ()
it is writing only 15000 records only. and after that it is erroring out.
I checked the mountpoint. it has perhaps your use of 'skip locked ' is playing a role here??
Have you tried it without using the 'skip locked ' option (which last time I
checked was not supported).
Raj
Hi All
This is a compulsive tuning disorder question. I 'm
just curious if anyone has experimented/benchmarked
the use of the swappiness parameter on Linux 2.6
kernel with Oracle running?
On a dediHi folks
Does anyone know what "lru_flag 6 " means in x$bh view? I can interpret
0 1 2 4 and 8 but not 6. I am running 9.2.0.6. Any help will be
appreciated.
Thanks
^Amir
--
http //www.freelists.orOn 6/15/06 Ray Stell <stellr@(protected) > wrote
>
> Got a query that will map an mview to a tablespace? I don 't.
>
> SQL > drop tablespace fred including contents and datafiles
> drop tablespace FRERunning VNC X server on the host and connect via VNC Java applet to
the remote desktop. Will need quite "think " internet pipe.
OEM... well 10g OEM might work for some tasks but it 's not enough.
HoweveWell if your requirement is to free up the disk from one diskgroup
than instead of creating new diskgroup you might consider just adding
disks to DtDg1 and removing disk that you need to use for someHi Larry
I looked at that a while ago. If I recall correctly as of 9i
prespawned dedicated servers are deprecated and Oracle recommends using
Shared Server instead.
That didn 't make a WHOLE lI think Oracle Wait Interface Chapter 6 is helpful.
On 6/15/06 genegurevich@(protected) <
genegurevich@(protected) > wrote
>
> Hi all
>
> I 'm looking for any tip as to runing cFound a bug in testing on 10.1.0.5 with the 10.1.0.5 patch 3 applied on
win32 standard edition w2k server sp4.
The bug is fixed in 9.2.0.8 and 10.2.0.2.
See note 342197.1
This error (ora-7445 [qeesLet 's say in Oracle 8i 9i or 10g we have a proc like
Procedure P1( p number)
Is
x1 number 12
x2 number(2 0) 34
x3 BINARY_INTEGER 56
begin
-- do something but not do any calcHi
The subject really says it all. We 're looking to move some databases
from 9iR2 on Solaris/Sparc to 10gR2 on Opteron w/ either Solaris x86-64
or Linux x86-64.
One showstopper we seem to be runn
> Hi All
> Our production database which is a 2-node RAC on Linux
recently threw an error which is given below
> CRS-0184 Cannot communicate with the CRS daemon
> Hi Mark
I think is necessary since CSS is (among other things) the foundation for
interprocess communication in a cluster environment and as such used to
handle interaction between ASM instance and r > I 'm stuck. Pulling my hair out.
Grant insert delete on sys.aux_stats$ to ssmith.
Regards
Dimitre
--
http //www.freelists.org/webpage/oracle-l
Testing can be your friend here.
rr
Well established company in the Nashville Tennessee area has a position
available for
an Oracle DBA to support their SAP and SAP BASIS environment.
Salary up to 95k and great benefits.
Prefer locaHi
How do they compare MS to Oracle
In Oracle term a database would be what a MS/Sybase call a "SQL Server ". They have lots of databases - a thing that compares to a combination of schema/tablespacErm......a rare skill indeed !!!!!
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected) "according to some coder in Oracle Corp there are 1024 milliseconds
in a second "
This made me seriously laughing! 8-))))
> http //www.freelists.org/archives/oracle-l/10-2005/msg01140.html
--
Best
On 06/12/2006 11 47 39 PM Dean Paul wrote
> Hi
>
> How to migrate code/applications between development test & production
> environments?
> Thanks in advance.
What is the airspeed velocity ofnot enough info really you could put 25 users on XE if they dont do
much.What type of system TPS estimated memory usage.
Is you 9i server underpowered?
On 13/06/06 Gleisson Henrique <gleissonbrHi
The correct variable is _USR_ORA_DEBUG
#_USR_ORA_DEBUG 1
#export _USR_ORA_DEBUG
Thanks
Fairlie
Alex Gorbachev <gorbyx@(protected) > wrote
There is commented out env. var.
> > >I actually really like the NetApp model - its very easy to manage
very flexible and the multi-protocol piece works
> > >great for us. We have several hundred systems (mix of real and
virtual) thOne of the things I love about this list is that not only do some really
sharp and experienced folks dwell here but they are willing to share
from their depths of knowledge and help expose Oracle int
On 06/12/2006 04 55 03 AM Stephane Faroult wrote
> an Oracle Manual on the topic). Even the terrible Mladen doesn 't seem to
> have spotted you yet.
I have spotted him but I didn 't care. He didHi there
yes ASM is useful - but you cannot compare CBO and ASM. If there is a bug in CBO - you still get your data. But if there is a bug in ASM ...?
Felix
-----Urspr?ngliche Nachricht----- |
|
|
