Dan ,
The problem was only in one log file .Now I took a cold backup and is
trying to bring my standby up. After bringing the standby ..i am
planning to monitor it closely for somedays ...to see if any corrupted
files are getting generated or not .
Thanks a lot
Shibu
OK, this is even more confusing to me. According to the following page:
http://www.redhat.com/download/products.html
You can download Red Hat Linux for free from http://ftp.redhat.com or
ftp://ftp.redhat.com. To access the Red Hat FTP site, use anonymous as you
user name and your email address
Yong:
I was not joking. Actually there is a command to rename tablespaces in 9i
and that is undocumented. IIRC it is with some FROM and TO options or
something similar to that.
Let me check that come back to you offline..
KG
- Original Message -
To: Multiple recipients of list
As well as Redhat Enterprise Linux, there will be a free version called
fedora. See http://fedora.redhat.com formore information.
Eddie Watkins
The Moray Council
-Original Message-
Sent: 04 November 2003 09:24
To: Multiple recipients of list ORACLE-L
OK, this is even more confusing
There are more than you can poke a stick at.
One wonders...
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message -
Google is your friend. Just search for Oracle dba mailing lists and a whole slew
of results are returned.
--
Please see the official ORACLE-L FAQ:
And more in the thread:
http://www.theinquirer.net/?article=12481
RED HAT has told its customers that it will no longer support a version of
Linux for the desktop, signalling that it believes its enterprise products
stand more chance of bringing in the shekels.
The firm emailed its customers
I was not joking. Actually there is a command to rename tablespaces in 9i
and that is undocumented. IIRC it is with some FROM and TO options or
something similar to that.
Let me check that come back to you offline..
^^
Gopal, please let us all
Hi All,
How can I determine who is using temp tablespace? I have a 1 gb tablespace
and it is almost full. I want to know who and what sql is using most
of it.
Thanks
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City
v$sort_usage and v$session should give you that.
Pawan
-Original Message-
Sent: Tuesday, November 04, 2003 6:49 PM
To: Multiple recipients of list ORACLE-L
Hi All,
How can I determine who is using temp tablespace? I have a 1 gb tablespace
and it is almost full. I want to know
Rick ,
This query will help you to find who is using the space
SELECT
a.username, a.osuser, a.sid||','||a.serial# SID_SERIAL, c.spid Process,
b.tablespace tablespace, a.status, sum(b.extents)* 1024*1024 space
FROM v$session a,v$sort_usage b, v$process c, dba_tablespaces d
WHERE
Hi friends ,
I am getting the following error when trying to take the database to nomount
state . I am trying to create a new database .
$ svrmgrl
Oracle Server Manager Release 3.1.7.0.0 - Production
Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
Oracle8i Enterprise
Tim Gorman scribbled on the wall in glitter crayon:
Yes! RMOUG Training Days is going to be an incredible event this
year! A 2-day conference in Colorado during ski season with a lineup
of speakers that rivals the major international conferences,
including keynotes by Bill Inmon and Sue
Hi Shibu
(Still going to GOA at new year then ??)
I would get your shm-max upped.
Regards
Lee
-Original Message-
Sent: 04 November 2003 13:39
To: Multiple recipients of list ORACLE-L
Hi friends ,
I am getting the following error when trying to take the database to nomount
state .
Hi List ...
Anybody having pointers for preparation for 9i Introduction to SQL
--OCP paper.
TIA
Pawan
This message contains information that may be privileged or confidential and
is the property of the Cap Gemini Ernst Young
For the time being there are Linux ISO'S at http://www.linuxiso.org/
including the RED HAT consumer linux.
Ron
[EMAIL PROTECTED] 11/03/2003 10:44:27 PM
Well, if RedHat starts exhibitting tendencies of becoming another
Microsoft,
there are Mandrake, Debian , SuSE and (don't shoot, I'm just
Jonathan,
Here's the text of the article [I can't find it on the WebSite, it
is in the regular Oracle emails that I
receive from Builder.Com]
Understand SYS_GUID and sequences as primary
keys
Oracle8i introduced the concept of SYS_GUID, which had several advantages
over a conventional sequence
Ive read the stuff on OTN. I read rene nyffenegger's stuff on his page. any other docs
on this out there you can recommend? Id prefer not having to hunt through google.com
for them.
i dont create databases at work. Look for stuff on Windows and Linux so I can play
around at home.
--
Please
I suspect that Oracle will continue to support RH AS. That is the only
version they ever supported officially. So the pay status of RH and
Oracle is a moot point. However, those of us who play with it knew that
with a couple of adjustments it would run on the free version. What
will happen
Well, I'm planning on being there too Bill, so there will be at least
one non-deity in the audience.:)
--Walt Weaver
Bozeman, Montana
On Tue, 2003-11-04 at 06:49, Thater, William wrote:
Tim Gorman scribbled on the wall in glitter crayon:
Yes! RMOUG Training Days is going to be an
No. But the free download of RH9 looks to end in March 04. Then there
will only be the three pay versions starting at USD $179.00. All
support for previous versions is GONE. Sounds like another Micro$oft in
the birthing stage.
Rodd
On Tue, 2003-11-04 at 03:24, Mark Leith wrote:
OK, this is
And now novell is eating up Suse, http://www.slashdot.org 8:45A today.
joe
Rodd Holman wrote:
I suspect that Oracle will continue to support RH AS. That is the only
version they ever supported officially. So the pay status of RH and
Oracle is a moot point. However, those of us who play with
Walt Weaver scribbled on the wall in glitter crayon:
Well, I'm planning on being there too Bill, so there will be at least
one non-deity in the audience.:)
seriously cool! we'll have to go find a corner out of the god light and
have a few beers.;-)
--
Bill Shrek Thater ORACLE DBA
What I dont like about Suse is no ISOs unless you're willing to pay for
the software. maybe i'll just buy the WS version and write it off on my
taxes to run oracle on., hmm
blah.
joe
Rodd Holman wrote:
I suspect that Oracle will continue to support RH AS. That is the only
version
Hi list,
I have problem connecting to target DB using account SYS with connect string. But
SQL*Plus works fine.
For example,
SQLconnect sys/[EMAIL PROTECTED]
connected.
but in RMAN (using same OS account and server)
==
RMAN connect target
This just came in on the suse-oracle-announce mail list:
Dear SUSE Oracle customers,
SUSE LINUX is to be aquired by Novell:
http://www.novell.com/news/press/archive/2003/11/pr03069.html
We will of course continue our Enterprise Server product line and our
close relationship with Oracle!
Agree with you
Ramon E. Estevez
[EMAIL PROTECTED]
809-535-8994
-Original Message-
Sent: Tuesday, November 04, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L
I suspect that Oracle will continue to support RH AS. That is the only version they
ever supported officially. So
On Tue, 2003-11-04 at 08:04, Thater, William wrote:
Walt Weaver scribbled on the wall in glitter crayon:
Well, I'm planning on being there too Bill, so there will be at least
one non-deity in the audience.:)
seriously cool! we'll have to go find a corner out of the god light and
Hope this is not getting too off topic, but I thought this may also be of
interest to those reading this thread:
http://www.theregister.co.uk/content/4/33770.html
Novell bags SuSE for $210m
Linux company SuSE was today acquired by Novell in a $210 million all-cash
deal.
The transaction is
Novell? Now there's a company that doesn't have a clue. Let's see, they
bought Cambridge Technology Parters to ummm let Jack Messman run
Novell??? If I'm wrong maybe it's because I Don't Know Jack
(http://www.novell.com/info/forms/wwsmc2001/jak.html)
Henry
-Original Message-
Joe
Tuesday, November 4, 2003, 10:14:25 AM, you wrote:
JT What I dont like about Suse is no ISOs unless you're willing to pay for
JT the software. maybe i'll just buy the WS version and write it off on my
JT taxes to run oracle on., hmm
This is something I'm struggling with. I want to run
Title: RE: char(1) VS varchar2(1)
got my alternate status. There will be 2 non-deity entities in the crowd.
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
/\
/ \
/ \
\ /
\/
\
\
\
\
Few people really enjoy the simple pleasure of flying a kite
Adam Wells age 11
Sami,
RMAN connects as SYSDBA. The password may actually be different.
The good one is that works
SQLconnect sys/[EMAIL PROTECTED] as SYSDBA
HTH
Vadim
-Original Message-
Sent: Tuesday, November 04, 2003 10:15 AM
To: Multiple recipients of list ORACLE-L
string
Hi list,
I have
Well, there'll be other non-gods there as well. I had two papers accepted -
guess I better start writing something for them now! :)
Pete
Controlling developers is like herding cats.
Kevin Loney, Oracle DBA Handbook
Oh no, it's not. It's much harder than that!
Bruce Pihlamae, long-term Oracle
Sami - You may also need to create an orapw file in order to connect as
SYSDBA remotely.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, November 04, 2003 9:59 AM
To: Multiple recipients of list ORACLE-L
str
Sami,
RMAN connects as SYSDBA. The
All, I have the issue with setting a basic format in sql plus
In my login.sql I have set line size 1000
Say I have a have a table with 20 columns and I
select * from table where rownum =2
What happens is I can't scroll the data... (The horizontal scroll is
locked)) Unless I go into
RHAS Developer Edition, £40 a pop for download. Best money I've spent this
year.
Mike Hately
-Original Message-
Sent: 04 November 2003 15:45
To: Multiple recipients of list ORACLE-L
Tuesday, November 4, 2003, 10:14:25 AM, you wrote:
JT What I dont like about Suse is no ISOs unless
Hello All,
I've been connecting to a customers server via VPN.
I've been able to connect to the database on the server via SQLPLUS Toad
but when I try to do an import or connect via SQLPLUS /NOLOG I get an
ORA-24314 error (no service handler).
I've tried looking for an answer on the web but
Joe Testa scribbled on the wall in glitter crayon:
And now novell is eating up Suse, http://www.slashdot.org 8:45A
today.
joe
so now that Linux has made it are we going to have a Linux provider melt
down? with no open source/free versions left?
--
Bill Shrek Thater ORACLE DBA
Mladen,
Save yourself from RPM hell and try Gentoo. I ended up converting a box at
home from RH8 to Gentoo after much prodding by a co-worker or two. I admit
it's mch easier to install/build packages under Gentoo because of
portage's dependency list that RPMs somehow seem to lack. I gave
I am still curious to see when linux will make it on the desktop, despite
the hype now we know that Red Hat is dropping that initiative.
Patrice.
-Original Message-
Sent: Tuesday, November 04, 2003 1:14 PM
To: Multiple recipients of list ORACLE-L
Joe Testa scribbled on the wall in
OK KG, the cat is out of the bag.
Now you have to tell all of us. Especially Raj. :)
Jared
K Gopalakrishnan [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/04/2003 01:29 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
I'll second that recommendation for Gentoo. I'm running Oracle 9.2.0.3 on my
Gentoo based laptop and I just installed OWB on it too.
Installing Gentoo can take a long time but once it's done you'll have a
sweet system.
Cheers,
Mark Stahlke
Denver Newspaper Agency
-Original Message-
Interesting finding here
ORCL9 SQL Store set C:\oracle\ora92\dbs\login.sql
Or if the file exists
ORCL9 SQL Store set C:\oracle\ora92\dbs\login.sql append
That generates a substantial config file, much more than a standard
login
I have to test if it actually keeps the buffer width and length. I
what is meant by OP,tanel..
Original Poster.
Tanel.
Oh My ...
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly personal. QOTD: Any clod
can have facts, having an opinion is an art !
-Original
Jared,
I don't see how index skip scans could benefit more
from a rebuild than from coalesce (providing the index height remains the same).
Skip scan doesn't scan the whole index like FFS does, it just does several scans
for each value set in beginning of concatenated index (+some more
Hi!
Which version? RMAN automatically logs on as sysdba, IIRC.
Try to log on to your database using sqlplus with
sys/[EMAIL PROTECTED] as sysdba
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, November 04, 2003 5:14 PM
Hi list,
No problem. I do have some very bad experiences with SuSE. Software
was nowhere to be found, they were pushing their own alternatives and the
icing on the cake was when a member of SuSE support stuff has told me that
building kernel is for experts only. I was trying to install OSS sound on my
Tuesday, November 4, 2003, 11:49:33 AM, Hately, Mike (LogicaCMG) ([EMAIL PROTECTED])
wrote:
HML RHAS Developer Edition, £40 a pop for download. Best money I've spent this
HML year.
What's the URL? You're not the first person to tell me this,
but so far I've not been able to find anything about
I cant sql trace it now. I hae run statspack. this query is running now and I dont
want to run another copy with a trace on until this finishes, since I dont want to
suck up resources. Im at a loss as to where the 20 billion rows comes from in this
explain plan? Everything including the indexes
Debian.
http://www.debian.org/social_contract
"Thater, William" [EMAIL PROTECTED] wrote:
Joe Testa scribbled on the wall in glitter crayon: And now novell is eating up Suse, http://www.slashdot.org 8:45A today. joeso now that Linux has "made it" are we going to have a Linux provider meltdown?
Yup, out of bag, definitely. I already scanned
through v$reserved_words to find anything usable with alter tablespace (or
perhaps database), but no luck. However, words such "undrop" and "disk group"
are already reserved in 9.2.0.4 ;-9
Tanel.
- Original Message -
From:
some more info.
I checked distinct values in those two tables. and there are 366,000 records in one
table and 5,000 records in another however, the column that is joining to only has 4
distinct values. I added a bitmap index to the columns and its using it on the smaller
table.
Im willing
Red
Hat To Drop Free Linux Products In Favor Of Enterprise
The
company is offering users two upgrade paths, either to the stable Enterprise
Linux product or to its developer-oriented Fedora Project, which is a free
download.
It's not 20 billion rows but 20 billion bytes. It's only 1 billion rows.
The cartesion product of 5K rows and 366K rows is 1830M rows or 1.8G. If
the join predicate is not very selective, .5 or .33 for example, that would
yield an estimated join cardinality of 1G (after rounding).
At 11:34 AM
Hi List,
One of our databases was terminated due to error 600. Below is the error
message from alert log file:
Tue Nov 4 12:00:25 2003
Errors in file /oracle/admin/adminp0/bdump/adminp0_pmon_24501.trc:
ORA-00600: internal error code, arguments: [106], [], [], [], [], [], [], []
Tue Nov 4
i figured it out. I use the ordered hint. Its actually a 3 table join and I took that
out for simplicity in my question. I drove off a more selective join. Got it to run in
1 minute.
i almost never have to use ordered hint
From: [EMAIL PROTECTED]
Date: 2003/11/04 Tue PM 01:34:26 EST
To:
Jonathan, i got the developer version of RHAS 2.1 on CD, if you dont
find it downloadable(which unless you paid for it, i dont think you
can), let me know, i'll burn copies and send out to ya.
joe
Jonathan Gennick wrote:
Tuesday, November 4, 2003, 11:49:33 AM, Hately, Mike (LogicaCMG) ([EMAIL
Hi, Ryan,
Where's the 20 billion rows? There's 1 G rows and 20 G bytes.
What are the values of NUM_ROWS in xxx_INDEXES for PK1 and xxx_TABLES for
TABLE2? Did you analyze using ANALYZE command or DBMS_STATS?
Yong Huang
--- [EMAIL PROTECTED] wrote:
I cant sql trace it now. I hae run statspack.
I gather that the SQL within functions that are called in top-level SQL
statement are not considered recursive, and therefore do not conform to
Cary's rule
A database call with dep=n+1 is the recursive child of the first
subsequent dep=n database call listed in the SQL trace data stream.
But the
David,
First of all, fortunately, your database was not terminated--your
_instance_ was. Your database lives on disk and can't be terminated
so easily, lucky for you.
ORA-00600 denotes an Oracle internal error (aka bug). Open a TAR
with Oracle Support; optionally search MetaLink for the text
David
http://metalink.oracle.com
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, November 04, 2003 1:04 PM
To: Multiple recipients of list ORACLE-L
Hi List,
One of our databases was terminated due to error 600. Below is the error
message
Nuala
This was discussed recently on this list, but not to a definite
conclusion. The speculation is that is probably a firewall issue. Your VPN
probably has to go through a firewall, which is probably open for normal
telnet type activities like a terminal connection. But connecting to
Oracle
there is an ora-600 query screen on metalink. it has limited amounts of information.
ora-600 is not documented anywhere else.
you need toopen a TAR immediately. ora-600 is not well documented. if you dont have a
support plan, you may have a problem.
From: David Boyd [EMAIL PROTECTED]
Date:
Thater, William wrote:
so now that Linux has made it are we going to have a Linux provider melt
down? with no open source/free versions left?
I doubt it. Redhat or any other company can't lock up GPL'd software. The only
thing they can keep you from copying/distributing is any proprietary
Boivin, Patrice J wrote:
I am still curious to see when linux will make it on the desktop, despite
the hype now we know that Red Hat is dropping that initiative.
Patrice.
As far as I'm concerned, it has already made it. It's my primary desktop at
work,with windows for those pesky apps that only
did someone by chance set any event for pmon process? There seems to be a bug 2329767
reported. Metalink has lot of information ...
type in ora-600 106 in the search box.
Raj
Rajendra dot Jamadagni at nospamespn
Btw, bold guys fromPolishOracle
UserGrouphave put out Oracle's 10g New Features beta documentation
at their website...
http://www.ploug.org.pl/konf_03/Oracle10g_New_Features.pdf
I already sent a notification to PLOUG to remove
this doc immediately, because I'm affiliated with European
Beware that the RPMs are SRPMs -- source. You still have to roll it
yourself. Given that, I'm sticking with Gentoo for home/development,
although it would make an interesting project. A consultant here with some
mid-hurricane RH training-cut-short tells me that AS can be built from the
SRPMS
Will Oracle 9iR2 run on fedora do you think?
Tonight I will check from home where I can download Fedora from, I am a
little fed up with XP's memory management (that half kernel, half user
process nonsense).
Patrice
-Original Message-
Sent: Tuesday, November 04, 2003 3:24 PM
To: Multiple
Actually the Novell initiative probably has the best shot. With Novell
now owning NDS, Ximian Gnome, and SuSE they have a good combination for
success. That's assuming boneheadded management decisions don't screw
it up. The technology is there.
On Tue, 2003-11-04 at 11:24, Boivin, Patrice J
AFAIK, you can download RH AS, just not is ISO form. The RPM's are
available on
their FTP site.
To be precise, SRPMs are available on ftp site...
Tanel.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tanel Poder
INET: [EMAIL PROTECTED]
Fat City Network
bad news. 106 is an unreported error in the metalink/ora-600 site.
you need to submit a tar with Oracle.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Tuesday, November 04, 2003 2:20 PM
To: Multiple recipients of list ORACLE-L
did someone by chance set any
Now that I think about it, you're probably right.
I'll test it anyway, I like to see numbers. :)
Jared
Tanel Poder [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/04/2003 10:04 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
everything is analyzed. For all indexes, for all indexed columns.
I used analyze. its the same as dbms_stats, just not as robust. I use it when I dont
feel like typing out dbms_stats.
Are there optimizer parameters that help the optimizer determine join order? Ive never
had to use the
IF you set your ORACLE_SID to the target database as the Oracle user, all
you have to do is say RMAN connect target and it will automatically
connect. If you are working from the command line you connect
user_with_sysdba_privs/[EMAIL PROTECTED] and you will be connected. If
does not recognize
Could you please post the entire sql and plan and statistics of the tables
and indexes so that we can comment on it rather than letting us guess on
selective bits of the entire problem.
At 01:29 PM 11/4/2003, you wrote:
everything is analyzed. For all indexes, for all indexed columns.
I used
The link is dead. :(
But thanks to the googlecache effect, you can still see the doc:
http://216.239.57.104/search?q=cache:UVsNMDV-OBIJ:www.ploug.org.pl/konf_03/Oracle10g_New_Features.pdf+Oracle10g_New_Features.pdfhl=enie=UTF-8
Jared
Tanel Poder [EMAIL PROTECTED]
Sent by: [EMAIL
Thanks all of you who replied. Your help is highly appreciated. I'll open
a TAR with Oracle.
David
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: database terminated
Date: Tue, 04 Nov 2003 11:19:33 -0800
there is an
Mary,
This topic is better handled over at /. than here. (http://slashdot.org).
RedHat should have communicated more effectively that they are indeed still supporting both Libre and Gratis software (read: free as in speech, free as in beer).
For now, I'll sit on RH8.0 for Oracle 9i R2 development
Hi,
In a SQL statement I want a certain where clause to be done first. Is it enough to
list it first as follows or do I (and can I) do something else to make it get checked
first before other WHERE/AND clause are looked at. Thanks :
SELECT emp_id FROM emp
WHERE select_sen_emp_chk_first =
Hmmm, equally tragic: www.fakednews.com was shut down. I wanted to create a
little spoof for this group about Red Hat being bought by Microsoft and
starting to work on the new enterprise version of Linux called Longnose, which
would blend Linux with the unique Windows ability to propagate
This topic is better handled over at /. than here
True enough in the general sense, though I don't necessarily
think it off topic here, as many of us use it to run Oracle.
And there is usually far too much garbage as /. to get
involved in the discussions, at least IMO.
Jared
Paul
List,
Please forgive the repetitious nature of this query, but I haven't yet
found an answer that satisfied me.
Environment: AIX 5.1 Oracle 8.1.7
Trying to create an SQL script which calls a procedure to update a
record based on information provided by the user via a screen prompt. I
know
Why do you want a certain predicate evaluated first?
At 02:34 PM 11/4/2003, you wrote:
Hi,
In a SQL statement I want a certain where clause to be done first. Is
it enough to list it first as follows or do I (and can I) do something
else to make it get checked first before other WHERE/AND
First I would take a look at the papers posted at Wolfgang Breitling's site
http://www.centrexcc.com/ Next, try and compare the number of rows the
optimizer expects to bring back at each step (cardinality as seen in explain
plan), to the actual number returned (rows as seen in sql_trace=true --
Jared,
Try browsing at +3, or set it to sort highest first.
You'll lose the ascii art that slips by the lameness filters, but see the stuff that matters.
Paul[EMAIL PROTECTED] wrote:
This topic is better handled over at /. than here True enough in the general sense, though I don't necessarily
A Joshi wrote:
Hi,
In a SQL statement I want a certain where clause to be done first. Is it enough
to list it first as follows or do I (and can I) do something else to make it get
checked first before other WHERE/AND clause are looked at. Thanks :
SELECT emp_id FROM emp
WHERE
Wolfgang,
I want it (select_sen_emp_chk_first) evaluated first because it is a prog (PL/SQL) variable. I assume it would be faster than others. Since : It does not have to go to table data to evaluate that like it would have to for dept or salary. Thank YouWolfgang Breitling [EMAIL PROTECTED]
If you already have shell script front end, would it be acceptable to prompt
for the input in the shell script rather than in the procedure?
#!/bin/ksh
echo ENTER LOGIN
read USER
echo ENTER PASSWORD
stty -echo
read PASS
stty echo
echo ENTER WHAT IT IS
read INPUT
sqlplus -s -XXX
Stephane,
Here is my SQL :
SELECT emp_id FROM emp
WHERE :select_sen_emp_chk_first = 'Y'
AND dept = :dept
AND salary :min_sal
Hi, Joshi,
The only hint that may affect the evaluation order in the WHERE clause is
ORDERED_PREDICATES. But I don't know who actually got it to work. The chapter
Optimizer Hints in Performance Tuning Guide talks about it. It also says if
you don't have this hint, there's a certain order in which
Exactly, until the doc is in google's cache, you
still can get the HTML version.
I thought that anyone keen enough to have this doc
would figure it out :)
Tanel.
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent: Tuesday,
Suppose I have the following settings which happen to be
the defaults as well:
PCTFREE 10
PCTUSED 40
I am trying to figure out what PCTUSED is really used for.
My book is telling me that is used so that Oracle knows
whether to keep a block in the free-list.
My point is this: If PCTFREE is 10%,
This should get you started
HTH
Jared
SQLPATH=''
USER_INPUT=''
while [ -z $USER_INPUT ]
do
echo Please enter a table owner:
read USER_INPUT
done
echo $USER_INPUT
sqlplus /nolog EOF
set echo on
connect scott/tiger
select
... and now printed and nicely bound. :)
Tanel Poder [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/04/2003 02:59 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: 10g new features
Exactly, until the doc
Ditto. (But what about OS X? :)
Got Oracle9.2 server and client running on my RH9 desktop. Found the
following link somewhat informative even though there are some
weirdities:
http://www.oreillynet.com/lpt/a/4141
Got the RH9 desktop machine a couple of weeks ago but am still
struggling to get
PCTUSED comes into play when rows are deleted from the block. If enough
data is deleted from a block to cause the block to fall below 60% used
(PCTUSED), the block goes back on the freelist for subsequent
inserts/updates.
-Original Message-
Sent: Tuesday, November 04, 2003 3:09 PM
To:
Your example block can be 60% full and not be on the free list.
Once your block reaches 90% full, it is removed from the free list.
It will not be put on the free list again until used space in the block
falls below PCTUSED, which is 40% in your example.
So, a block fills up, it is removed
To use your numbers, the block can fill to 90% (100-PCTFREE) at which
time it comes off the freelist.
If you delete rows until the block falls below 40% used (PCTUSED), the
block will go back on the freelist.
-Original Message-
Sent: Tuesday, November 04, 2003 3:09 PM
To: Multiple
1 - 100 of 121 matches
Mail list logo