 | | | Oracle List | |
Hi.
I wonder if anyone has experiences on running Oracle 10g on FreeBSD using
Linux emulation and Linux 10g port.
I have been using FreeBSD for years and I am not sure if I have to switch
toMark & Graeme
You got the wrong guy. I 'm not having the problem. Peter is.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
From Mark W. Farnham [mailto mwf@(protected)
Hi a nice new paper
http //www.orapub.com/cgi/genesis.cgi?p1 sub&p2 abs158
Mr. Rogers I agree with most of what you say but this statement of
yours seems to me to be something that has often been disputed on this
list with some people opining that number of extents does
On 06/22/2004 01 39 12 PM Stephen.Lee@(protected) wrote
> > -----Original Message-----
> > It alwys comes out no? Anyway to get around this?
>
> There are different versions of the real ksh (i.
On 06/22/2004 11 27 12 PM Tim Gorman wrote
> Sorry my friend but that doesn 't work...
>
> $ if [ 1.2 > 1.0 ] then
> > echo "yes "
> > else echo "no "
> > fi
> yes
>
bp may have been specific to Dynix/PTX. I can 't seem to find it anywhere
else. I 'm pretty sure I used it on to operate on various SUN boxes but that
may have been via NFS mount from a Sequent.
PIf you are not in Arizona USA this week please feel free to hit the
DEL key )
-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
CHANGE OF VENUE FOR THIS AZORA MEETIN
Your original post about type# 10 was correct -
I did post something a long time ago about Oracle
keeping obj# rows intact as type# 10.
I think at the time that it was keeping two or threI 've used Oracle on a MVS mainframe. Performance was horrible. There wasn 't enough memory and the machine couldn 't support more without a costly upgrade. It pages out your sga if you don 't have it means what it says. insufficient memory in shared pool. in 8.1.7 (base
release) there is a bug in which fixed memory is leaked but this is usually
a gradual leak exacerbated with usage over time.
Allowable objects for KEEP-ing...
-- Value Kind of Object to keep
-- -----
Notice that there has been some hard parsing
on the first tkprof output - so the statement
is not sufficient popular to be implicitly locked into
memory.
Is it possible that the cursor was invThanks!
G > This is a known bug in Oracle which ought to be fixed in 9i.
G > Gudmundur
G > ----- Original Message -----
G > From "Robert Eskridge " <bryny@(protected) >
G > To <oracle-l@(protected)Graeme
I ran the trace with 10046 8 for this session and following are the wait
events using tkprof. Any advice will be highly appreciated. Also I
modified the procedure and instead of using ranHi all
I have the following query which is running very slow as it takes few minut
es to complete.
SELECT sum(nvl(as_ofcsh 0)) sum(nvl(as_offxd 0))
sum(nvl(as_ofeqty 0)) oracle-l-bounce@(protected) wrote on 06/22/2004 02 18 58 PM
> Thanks Jared I know do you know which release exactly I suppose it was
> from 9i or I 'm wrong. 0D
9i
just google for it.
Stephen - To quote Monty Python "And now for something completely different
. . .
Consider switching to autoextend. It is scary I know. Won 't work in
every environment. But it can achieve yourMaybe you could
create another tablespace (say tablespace XYZ) and move the objects to TS
XYZ drop the old (and empty) tablespace re-create it with uniform extents
move back objects from XYZ
On 06/21/2004 03 59 49 PM "Nguyen David M " wrote
> He asks me is there a way to query SCOTT object without typing "SCOTT. "
> in front of table name?
There is this little known SQL command I 'm on a list at http //www.sswug.org/. There are a couple people from this
list on it as well. It is a very good resource.
--Chris
-----Original Message-----
From J. Dex [mailto cemail4@(protected)
On 06/21/2004 02 44 51 PM J. Dex wrote
> Can anyone who works with both Oracle
> and SQL Server give me the name of a good SQL Server listserv?
I believe that the best lists to discuss qualiBen
As I remember the training about PCTFREE and PCTUSED when you create
a table the settings and part of the original table and blocks used up
until the time you make a change in the PCTFREE an
On 06/22/2004 02 21 16 PM Ron Thomas wrote
>
> And it is now owned by Quest (as of January) and has seen no updates since 1.3.13 alpha (January
> build). Not sure where the product is headed
In the case of the index Oracle generates a startkey
and a stop key (even for a unique index scan) so
has to call the function twice.
In theory you could declare the function to be
determiniI will be out of the office starting 08/07/2004 and will not return until
08/10/2004.
If this is urgent please contact Susanta Panja.
This is sinle node.
I cant insert somethink (at least ir belive so) because it is 3 party
soft - ?PLSQL Developer?who executing PBSDE.DEBUG_LOOP commnad then
situation have place. I even not faBy default plsql developer compiles with the debug option set on (check dba_procedures and
dba_stored_settings). You can turn it off from one of the preferences/options in plsql developer
hth
cHi
Looks like you are doing too many IO 's for fetching 8 rows and 112 rows
respectively. Might be you are using a non selective index for the query.
Cheers
Sriram Kumar
On 1/10/06 BN <bnsarma@(protected)We 've been using this product for quite some time.
It is quite reliable. I believe it is the basis for what RMAN does
today only it 's got 10 years of maturity
Built in.
It 's not cheap thoug |
|
|
