Dear List,
When I query dba_extents , Iam getting response after half an hour to 40
minutes, but when I query any other dictionary view it is spontaneous.
Everything else is fine in the database and there are no problems, except
the above problem. Iam not getting any clue how to fix this. Iam
Sounds like a fragmentation problem.
This will help you identify the segments with a large number of
fragments. They are good candidates for reorganization.
HTH,
Beth
select a.tablespace_name as tablespace,
cast(a.segment_name as char(30)) as segment,
a.partition_name as
[EMAIL PROTECTED] wrote:
Exactly. ;)
Jared
geez, guys, you know he's going to believe every word you say.;-)
--
--
Bill Shrek Thater ORACLE DBA
[EMAIL PROTECTED]
You gotta program
Scott - I think that Rachel offered better advice, and I'm sure you've read
her note by now. I have some experience with missing files when cloning a
database :-), but I haven't had the rollback tablespace missing, and that
would be different. One thought would be to create an extra rollback
Hi
I checked wait in my database and found the following are top 5 waits.
Event Waits
single-task message 1,411,047
log file sync 326,222
SQL*Net more data to client
Babu,
We had a similiar problem, and setting optimizer_mode
= choose in our session solved it. Something to do
with optimizer and DD access. Give that a try. I had
the same problem with DBA_INDEXES and that fixed it.
hth,
Jack
--- Janardhana Babu Donga [EMAIL PROTECTED] wrote:
Dear List,
Babu,
Do you have any locally managed tablespaces? I'm wondering if this could be
caused by scanning for extents within LMTs.
Regards,
Mike Hately
-Original Message-
Sent: 09 May 2002 18:58
To: Multiple recipients of list ORACLE-L
Dear List,
When I query dba_extents , Iam getting
Babu - Wow, never had that one. Of course, I don't use that table much. How
many rows are in this table? Mine has 12,937 rows, and is kinda slow to
respond compared to the other system tables. Do you have a test database to
compare with? Is it possible that your system tablespace has become badly
I thought there was a rollback segment in system that would be there. It should
be enough to get things started. After all, there isn't a separate one when you
create a database, until you create it.
DENNIS WILLIAMS wrote:
Scott - I think that Rachel offered better advice, and I'm sure
that's interesting... since the data dictionary is NOT analyzed, setting
optimizer_mode=choose would force the query against dba_extents to RULE which it
what it is supposed to be doing anyway, Hm. The question now is, what is the
optimizer_mode set to when the problem happens? Did any of the
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 12:47 PM
To: Multiple recipients of list ORACLE-L
Subject: Re:RE: Good DBA vs. Bad DBA
snip
Now I've also got some real good SA's who likewise do not
appreciate system
The Optimizer_mode is already set to CHOOSE. Any other ideas?
Thanks,
--Babu
-Original Message-
Sent: Thursday, May 09, 2002 11:18 AM
To: Multiple recipients of list ORACLE-L
Babu,
We had a similiar problem, and setting optimizer_mode
= choose in our session solved it. Something to do
Jerry,
Aw, come on! Try handling a radar radome on a B-4 stand in a 10 MPH wind,
now that's fun!!
Dick Goulet
Reply Separator
Author: Whittle Jerome Contr NCI [EMAIL PROTECTED]
Date: 5/9/2002 9:47 AM
Database crashes don't worry me too much.
There are no LMTs in the database.
Pl. let me know if you have any other ideas.
Thanks,
-- Babu
-Original Message-
Sent: Thursday, May 09, 2002 11:29 AM
To: Multiple recipients of list ORACLE-L
Babu,
Do you have any locally managed tablespaces? I'm wondering if this could be
caused by
Seema - The SQL*Net more data to client means Oracle is waiting for the
client to send something back so Oracle can do something more. I looked
single-task message up on google and received:
single-task message
When running single task, this event indicates that the session waits for
the client
This is definitely not a fragmentation problem. I have just created a new
table
create table x1 (col1 number) tablespace data_ts; and run:
select * from dba_extents where segment_name = 'X1'; It is still sitting
there. Hope to get response after 30 minutes.
Any other ideas??
Thanks,
-- Babu
There is a vital piece of information missing, namely how long
was the accumulated wait time for each wait, and over what
period of time?
Jared
Seema Singh [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/09/2002 11:18 AM
Please respond to ORACLE-L
To: Multiple recipients of
[EMAIL PROTECTED] wrote:
Nope. We _know_ the conspiracies are real...
and so are the black helicopters.
--
--
Bill Shrek Thater ORACLE DBA
[EMAIL PROTECTED]
You gotta program like you
what does netstat -i tell you, on both client and server.
On Thu, May 09, 2002 at 10:18:31AM -0800, Seema Singh wrote:
Hi
I checked wait in my database and found the following are top 5 waits.
Event Waits
single-task message
Babu,
What does this query return?
select count(*) from dba_extents;
Jared
Janardhana Babu Donga [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/09/2002 10:58 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
In some versions of Oracle, you need a SECOND rollback segment created in the
SYSTEM tablespace in order to create another tablespace. It can't hurt to add
it (you can drop it immediately after you get the rollback tablespace created)
but it could be the solution.
Since you didn't include the
I did write an awk script to summarize the wait events in a 10046 trace
file. It lists the SQL, and sums the count and time of the waits for the
SQL.
Henry
# Script for analyzing Oracle Trace files with WAIT statistics
# Usage: wait_scan.awk filename
# Written:Henry Poras
#
Hi,
If my memory is good, it was in 1998-99 with Oracle 8,
we were using stored proc with dynamic pl/sql. I do
not recall that it was taking long. Everything was
done with dynamic pl/sql : tablespace creation,
partition creation,...
Our partitions were not big, between 200M and 800M.
Stéphane
Any one got this message?
Forbidden
You don't have permission to access
/~melody/courses/Spring2002Backup/BackupPPTS/les on
this server.
--- Sherman, Edward [EMAIL PROTECTED] wrote:
Here's the slides!
SQL/PL-SQL
Jared,
It is taking 30 to 40 minutes to respond. I just issued again and is sitting
there. Iam sure it would respond after 30 minutes as happenned many times.
I would E-Mail after getting the response.
Thanks,
-- Janardhana Babu
-Original Message-
Sent: Thursday, May 09, 2002 11:54 AM
Dennis,
It is happenning for any table in the database. I have just created a new
table:
create table x1 (col1 number) tablespace data_ts, inserted one row and run:
select * from dba_extents where segment_name = 'X1'; It is still sitting
there. The response to any other dictionary view is
I've been looking for that in Designer , where it is ?
I've used a lot Power*AMC in the past and it has that
feature .
We're using Oracle Designer 6.5.52.1.0
TIA
--- [EMAIL PROTECTED] a écrit :
Stephane,
We have the same objects, etc. in both dev and prod.
We only have a single
I have recently changed the analyze script. Earliar it was
dbms_utility.analyze_schema(...) statement, It is now changed to
dbms_stats.gather_database_stats();
Is this a problem?
The response time for select count(*) from dba_extents is also 30 minutes.
It is not specific to any table.
Jared,
It is taking 30 to 40 minutes to respond. I just issued again and is sitting
there. Iam sure it would respond after 30 minutes as happenned many times.
Thanks,
-- Janardhana Babu
-Original Message-
Sent: Thursday, May 09, 2002 10:45 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Thanks Anjo/John:
Anjo, I agree, Unknown297
might be a post/wait call asking for KAIO.
John, you
have to configure AIO servers separately using
SMIT AIO. (And possiblly bounce
the server?)...If you are going to use Threaded Async I/O with FS, If you
want to use
Kernelized Async I/O
Well why do you want to do something ? To look busy ? Or are there
complaints about response times or throughput problems ?
Anjo.
Seema Singh wrote:
Hi
I checked wait in my database and found the following are top 5 waits.
Event Waits
Hi,
I am installing oracle 9.0.1 on Sun Sparc Solaris 5.6, I have the next
error:
make: Fatal error: Command failed for target `ntcontab.o'
/usr/ccs/bin/make -f ins_net_client.mk nnfgt.o ORACLE_HOME
=/u02/app/oracle/prod
uct/9.0.1
(if [ -d /u02/app/oracle/product/9.0.1/lib32 ] ; then \
sh... _They'll_ hear you.
-Original Message-
Sent: Thursday, May 09, 2002 2:49 PM
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED] wrote:
Nope. We _know_ the conspiracies are real...
and so are the black helicopters.
--
--
Bill Shrek Thater ORACLE
Yes, I got that one too. I suspect that the current courses are locked to
all but current students?
Ron
-Original Message-
From: Steven Joshua [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 3:00 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle
Yes, that's bad. You have analyzed the data dictionary tables. You
need to delete the statistics for them.
-Original Message-
Sent: Thursday, May 09, 2002 3:04 PM
To: Multiple recipients of list ORACLE-L
I have recently changed the analyze script. Earliar it was
Aw. Looks like it got shutdown? :( And the URL you stated was the
truncated version, but even the full URL gets this message.
They probably weren't prepared for the grunt of the list hitting 'em...
Rich Jesse System/Database Administrator
[EMAIL PROTECTED]
what does
select count(*) from uet$
return?
-Original Message-
Sent: Thursday, May 09, 2002 2:54 PM
To: Multiple recipients of list ORACLE-L
Dennis,
It is happenning for any table in the database. I have just created a
new
table:
create table x1 (col1 number) tablespace
Or flying an F-16 in Afghanistan at night...
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
E-Mail: [EMAIL PROTECTED]
-Original Message-
Sent: Thursday, May 09, 2002 3:39 PM
To: Multiple recipients of list ORACLE-L
Jerry,
Aw, come on! Try handling a radar radome
or more accurately -
select count(*) from sys.uet$;
-Original Message-
Sent: Thursday, May 09, 2002 2:03 PM
To: '[EMAIL PROTECTED]'
what does
select count(*) from uet$
return?
-Original Message-
Sent: Thursday, May 09, 2002 2:54 PM
To: Multiple
True enough. Allow me to say that since I've got all of the drives mirrored,
I'm fairly immune to a single drive failure. BTW: There was one stock broker in
the World Trade Center that I've heard of who was impacted by the previous years
bombing subsequent database crash. So they put one of
I got the response from the count(*) query. It has returned 4855 and took
nearly 30 minutes to respond.
Thanks,
-- Babu
-Original Message-
Sent: Thursday, May 09, 2002 11:54 AM
To: Multiple recipients of list ORACLE-L
Babu,
What does this query return?
select count(*) from
Is it possible that some of the system owned tables were accidently
analyzed? You might try running:
select table_name
from dba_tables
where owner='SYS'
and last_analyzed is not null;
-Original Message-
Sent: Thursday, May 09, 2002 1:59 PM
To: Multiple recipients of list ORACLE-L
Thank you Connor,
but I need a script that backups over 20 raw devices
datafiles to a TAPE without using a FS to store these
datafiles first.
TIA
___
Do You Yahoo!?
Yahoo! Messenger
Comunicación instantánea gratis con tu gente.
Yep.
I believe you have to be a registered member of the class to see the
class material.
Ron
ROR mª¿ªm
[EMAIL PROTECTED] 05/09/02 02:59PM
Any one got this message?
Forbidden
You don't have permission to access
/~melody/courses/Spring2002Backup/BackupPPTS/les on
this server.
--- Sherman,
You are not using the full url, check the next line for the rest of the url
01_files/v3_document.htm
you need les01_files/v3_document.htm
-Original Message-
Sent: May 9, 2002 12:00 PM
To: Multiple recipients of list ORACLE-L
Any one got this message?
Forbidden
You don't have
I used to run the following analyze every week:
dbms_utility.analyze_schema(...) statement which included SYSTEM schema,
Two weeks back it was changed to
dbms_stats.gather_database_stats();
Is there anyway to de-analyze SYSTEM schema?
Thanks,
-- Babu
-Original Message-
Sent:
Me too.
JP
On Thu 9. May 2002 20:59, you wrote:
Any one got this message?
Forbidden
You don't have permission to access
/~melody/courses/Spring2002Backup/BackupPPTS/les on
this server.
--- Sherman, Edward [EMAIL PROTECTED] wrote:
Here's the slides!
SQL/PL-SQL
There seems to be a perfectly good theoretical reason
for this. But it would be interesting to know:
Number of blocks below HWM
Setting for db_file_multiblock_read_count
Maximum usable value for db_file_mbrc
The cost given by Explain Plan for the tablescan
before I confuse the
So, a developer asks me Why can't I grant user CHARLIE access to my view in
schema ALPHA?
I look in our 8.1.7.2 DB and see this setup:
Schema ALPHA:
-- Simple table.
CREATE TABLE my_table
(col1 VARCHAR2(10),
It returned 4855. The response is immediate.
Count(*) from dba_extents also returned 4855 but took nearly 30 minutes.
Thanks,
-- Babu
-Original Message-
Sent: Thursday, May 09, 2002 12:14 PM
To: Multiple recipients of list ORACLE-L
what does
select count(*) from uet$
I thought using DBMS_STATS is much more efficient than the old method. I
have recently read an article about it in Oracle magazine, Jan/Feb 2002 Page
32, then I changed the analyze script.
I would appreciate if anyone sends me a script to delete the SYS/SYSTEM
statistics.
Thanks,
-- Babu
It responded with 197 tables.
Is it not the correct way to analyze?
dbms_stats.gather_database_stats();
I have recently been using the above statement to analyze the database.
Thanks,
--Babu
-Original Message-
Sent: Thursday, May 09, 2002 12:24 PM
To: Multiple recipients of list
Jack,
Output from show parameter optim:
Optimizer_cache_optimal_size 102400
optimizer_features_enable 8.1.7
optimizer_index_caching 0
optimizer_index_cost_adj 100
optimizer_max_permutations8
optimizer_modechoose
optimizer_percent_parallel0
Immediate
dbms_stats.gather_database_stats has a bug, it analyzes SYS objects.
From Metalink:
Bug:1422285 is a severity 3 bug that was logged for the
dbms_stats.gather_database_stats collecting statistics on the data
dictionary objects (FET$ was the example). This bug is fixed in 9i. A
workaround is to
Babu,
issue this in your sqlplus session:
show parameter optim
and then this:
alter session set optimizer_mode=choose;
and then this:
select /*+ RULE */ count(1) from dba_extents;
and then this:
select count(1) from dba_extents;
and let us know what happens.
Rachel: we were running
Babu,
While you're waiting, run this query to see what you're waiting on.
Jared
select
s.username username,
e.event event,
s.sid,
e.p1text,
e.p1,
e.p2text,
e.p2,
e.wait_time,
e.seconds_in_wait,
e.state
from v$session s, v$session_wait e
where s.username is not
Oracle Version 8.1.7.3 64-bit
OS Solaris 8 10/1
Server platform Sunfire 38000
Client Platform WIN2k
I have somehow created a black hole in my database. While installing
designer 6i my process freezes while creating the RM_ELEMENTS view. I do not
have any errors in my alert logs. If I create a
Yes, I ran the query from the SYS schema and it returned the same
number:4855, the same as count(*) from dba_extents.
-- Babu
-Original Message-
Sent: Thursday, May 09, 2002 12:14 PM
To: Multiple recipients of list ORACLE-L
or more accurately -
select count(*) from sys.uet$;
It is waiting on the event: db file scattered read.
Thanks,
--Babu
-Original Message-
Sent: Thursday, May 09, 2002 11:33 AM
To: [EMAIL PROTECTED]
Cc: Janardhana Babu Donga
Babu,
While you're waiting, run this query to see what you're waiting on.
Jared
select
s.username username,
Hi,
We are trying to use function based indexes in our application but it looks like
optimizer is not using them.
So we created a sample table emp with 3 columns empno,ename,sal and populate
this table with 10 rows and created function based index on upper(ename).
we try to run simple
Ken,
The opening was stated incorrectly. HR
doesn't know the difference between a DBA a DA. We are looking for
someone to do logical design data modeling, not to administrator a
database. The platform is Oracle.
Bill GentryDBAAllina Health SystemMinneapolis, MN
55403612-775-1190[EMAIL
I'm sorry, and I should know better. We are on 8.1.7.0.0 on Sun Solaris 2.6.
[EMAIL PROTECTED] wrote:
In some versions of Oracle, you need a SECOND rollback segment created in the
SYSTEM tablespace in order to create another tablespace. It can't hurt to add
it (you can drop it immediately
This was not always the case. We must have flooded the server and they shut off
public access. There are other sites that have the slides. The slides are actually
provided BY Oracle as part of some educational deal (ie. pre-marketing campaign!). But
I have found these on the net in the
I have just now deleted the 'SYS' schema statistics and executed select
count(*) from dba_extents, and there is no improvement. It is still sitting
there.
Thanks,
--Babu
-Original Message-
Sent: Thursday, May 09, 2002 12:45 PM
To: Multiple recipients of list ORACLE-L
It is waiting on the event: db file scattered read
Thanks,
--Babu
-Original Message-
Sent: Thursday, May 09, 2002 12:41 PM
To: Multiple recipients of list ORACLE-L
Babu,
While you're waiting, run this query to see what you're waiting on.
Jared
select
s.username username,
but I need a script that backups over 20 raw devices
datafiles to a TAPE without using a FS to store these
datafiles first.
To a single tape or multiple ones? If it's a single tape
then you are in for a real fun time trying to restore the
stuff...
This is skeletal but should give you a
analyzing SYSTEM is not the same as analyzing SYS, which is what you have done
by using gather_database_stats
run dbms_stats.delete_schema_stats('SYS') to remove the statistics
then either always run the delete after the gather_database_stats or switch to
gather_schema_stats
I tried to see whether JInitiator would be certified for XP, the only item I
found on MetaLink stated that Jinitiator was still at version 1.1.8.14, no
news re. XP yet.
JInitiator doesn't appear in the Certification matrix.
Am going to check the technet software download site, maybe they have a
I have deleted the statistics from 'SYS' and SYSTEM' as suggested by Suzy
and made sure that they were gone by issuing the query:
select table_name,owner
from dba_tables
where owner in ('SYS','SYSTEM')
and last_analyzed is not null;
It returned no rows this time. But why is my query: select
you don't need the upper(ename) in your where clause... that forces oracle to
NOT use an index
|+-
|| |
|| |
|| Harvinder.Singh@met|
|| ratech.com
Looks like she took away the permissions.
I never took a class here.
I stumbled on the site several months ago using the Google search engine
with the search string Using Oracle Blocks Efficiently.
Back then that site was the first one returned by Google.
Sorry the links were so short lived.
God Bless google.com and the American higher educational system!
http://www.sdsc.edu/~oracle/training/intro/syllabus.html
This one, you'll have to do the HTML conversion yourself, though...
Rich Jesse System/Database Administrator
[EMAIL PROTECTED]
I'm running 1.1.8.14 on XP Pro to run Developer 6 forms via the web.
Joe
Joe LaCascio
Oracle DBA, Unix Administrator
Wheaton College, MA 508.286.3405
On Thu, 9 May 2002, Boivin, Patrice J wrote:
I tried to see whether JInitiator would be certified for XP, the only item I
found on MetaLink
Hi Johnathan,
here is the skinny:
db_file_multiblock_read_count = 64
number of rows=15m
blocks=251071
empty_blocks=0
db_block_size=16384
total plan cost=4924
tablescan cost = 4924
Jack
--- Jonathan Lewis [EMAIL PROTECTED]
wrote:
There seems to be a perfectly good theoretical
reason
(Embedded image moved
to file:
pic28253.gif)
Try this: dbms_stats.delete_database_stats();
Janardhana Babu Donga wrote:
I have deleted the statistics from 'SYS' and SYSTEM' as suggested by Suzy
and made sure that they were gone by issuing the query:
select table_name,owner
from dba_tables
where owner in ('SYS','SYSTEM')
and
I've found out how to generate without the storage
clause.
--- paquette stephane [EMAIL PROTECTED] a
écrit : I've been looking for that in Designer ,
where it is
?
I've used a lot Power*AMC in the past and it has
that
feature .
We're using Oracle Designer 6.5.52.1.0
TIA
--- [EMAIL
that's why we are using function based indexes...
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 4:49 PM
To: Multiple recipients of list ORACLE-L
you don't need the upper(ename) in your where clause... that forces oracle to
NOT use an index
Another requirement is that your compatibility init.ora parameter must
be set to 8.1.7 or higher, I believe, but check the doco.
If that doesn't fix it, then trying using a hint to force the use of
that index. If it doesn't work with the hint, then you know you have an
environment problem that
Babu,
Your query is using cost algorithms to access the data
dictionary, and that is why it is so slow. The RULE
hint makes it use rule-based optimization, which is
the way that the data dictionary is supposed to be
accessed.
If you remove all stats from the data dictionary, your
query should
Do you have a lot of locally managed tablespaces? Doing a read from
dba_extents can cause quite an I/O with locally managed tablespaces.
My 2 cents.
Raj
I thought that's what told the optimizer to use the FBI?
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Thursday,
Thanks for all those who helped me in fixing the problem.
I deleted the SYS schema statistics using
dbms_stats.delete_schema_stats('SYS') and I need to restart the database.
Iam changing my analyze script from database analyze to schema analyze.
Thanks,
--Babu
-Original Message-
Sent:
I respectfully disagree. In order to use a function based index
you do need the upper. If optimizer doesn't pick it up straigt
away, he should give a hand with a hint (/*+ INDEX(alias,index) */)
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Thursday,
Natalia, follow the 9i Installation Guide very carefully, especially the
parts about setting up the DBA user and group accounts, permissions, etc.
Also, on UNIX you have to set the kernel parameters in /etc/system, among
other things. All of this is in the Installation Guide.
HTH,
david
I think the point Rachel made is the query should instead be:
where ename=upper('abc98');
Harvinder Singh wrote:
that's why we are using function based indexes...
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 4:49 PM
To: Multiple recipients of
and stats have to have been collected on the index and base table as well
just checked the 9i docs... I was wrong you do need the upper on the column, my
bad.. but you need the stats, the compatibility set (as Beth says)
|+--
||
SAME MESSAGE
--- Browett, Darren [EMAIL PROTECTED]
wrote:
You are not using the full url, check the next line
for the rest of the url
01_files/v3_document.htm
you need les01_files/v3_document.htm
-Original Message-
Sent: May 9, 2002 12:00 PM
To: Multiple recipients of list
Have they included a DECODE function yet?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, May 09, 2002 11:51 AM
Exactly. ;)
Jared
Anjo Kolk [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/09/2002 10:03 AM
Please respond to
My site has some stuff up at
http://www.freetechnicaltraining.com/Oracle/Free_OCP/Architecture_and_Admini
stration/
I have not had time to work on this stuff so the site will be coming down in
a few weeks. Creating training with audio and stuff is pretty easy just
very time consuming. Use
I take it back... the query was correct as originally written. Just
tried similar queries on my database and the FBI was used for:
upper(ename)=upper('abc98')
upper(ename)='ABC98'
It's been a LONG week...
[EMAIL PROTECTED] wrote:
and stats have to have been collected on the index
I think enough has been said already - I didn't intend to name the company at all.
Actually, I
don't think that I said that all the managers were incompetent. (A select few in the
wrong places
perhaps.) Since the cat is out of the bag though, I will try to end this here and now.
I had a
Greetings listers,
Ever worry about wrinkles, loss of hair, and bad
breath?
Well, the following script can't help you with THAT,
but it CAN show you a heirarchical list of objects
that depend upon the given object! Just pass in
1=owner and 2=object name, and viola! No more
changing objects
We have an 8.1.7 SE database on a server which is currently NT4 SP6. The
System Admin group wish to upgrade the server to W2K and propose doing so by
recreating the C: partitition. Our Oracle software resides on E: (same
physical disk) and database files on other disks/partitions. Are there
Babu,
execute dbms_utility.analyze_schema('system','delete') this would do.
-Shaibal
From: Janardhana Babu Donga [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: DBA_EXTENTS problem
Date: Thu, 09 May 2002 11:41:16 -0800
I
Your
environment is much different from our test which was one-tier, but did
use Oracle 9i. We had no indexes on the partition in which the
insert was taking place. We did no special tuning other than to balance the I/O
load. We employed Veritas and its direct IO capability. That's
direct
Sankar,
For starters,
SQL set autotrace trace explain
Now run your SQL and you'll get an explain plan.
Send another email to the list showing both: the SQL statement, and the
explain plan. These may reveal your problem quickly.
- Original Message -
To: Multiple recipients of list
Outstanding response!
Don Granaman
[certified skeptic]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, May 09, 2002 9:13 AM
no - DBAs would be skeptical of conspiracy theories.
-Original Message-
Sent: Thursday, May 09,
Undocumented behavior:
setting optimizer_index_cost_adj = 1 is simply begging the optimizer to use
any index, just kidding :}
I think it's simply b/c the total cost which is = cost of sequential read *
number of reported rows in the index (adjusted by optimizer_index_cost_adj)
is the lowest
I am not able to display the bmp stored in the
BFILE.Ifollowed the following steps.I have been following the
NOTE from metalink and the oracle app dev
guide.
CREATE TABLE empbfiles (id NUMBER PRIMARY KEY,
empname
VARCHAR2(20),
photo BFILE); / CREATE OR REPLACE DIRECTORY
empbfiles AS
1 - 100 of 119 matches
Mail list logo
