Hi All
I have problem related to listener. On my machine I have Oracle
8.1.5 on RH 6.2. When I issued the command $ lsnrctl I got the
following error message
lsnrctl: error in loading shared libraries: libskgxp8.so: cannot
open shared object file: No such file or directory
I have downloaded t
HI List
I've small problem in booting the server...it's Unixware 7, Release
7.1.1..the error while booting is "FATAL BOOT ERROR: Can't load stage3"
so pls can u suggest what could be the problem??..
Regards
Chinna
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: chi
Hi all,
For Oracle 8.1.6.0.0 for SPARC
Is there any CD so call Partner CD distributed to customer, that only allow limited
number of concurrent Process (in my case 160).
And if there is how can I know installed DB is Partner version.
Thank you
--
Please see the official ORACLE-L FAQ: http://w
-- Tim Gorman <[EMAIL PROTECTED]>
> find -name "MATERIAL.*" -mtime +30 -exec rm -f {} \;
Main problem with this is forkatosis if there are too many
files. Using xargs breaks the rm's up into fewer proc's
and tends to run faster since the rm command can access
top-level dir's a single time for
There's nothing secret about the meaning and format of Oracle 10046
trace data. See MetaLink document 39817.1 for one example of a publicly
available, detailed description.
We wrote the Hotsos Profiler trace file parser in Perl in about 4 hours.
We hand out much of the Perl to do this in our pape
You can create an access db that acts as a passthrough from excel to
oracle, access uses the odbc driver and excel is using the ole method (or
something like that). Works well once you get it going.
find -name "MATERIAL.*" -mtime +30 -exec rm -f {} \;
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, May 09, 2002 6:43 PM
> Hello!
>
> In my unix system (hp ux 10.20) I have one particular
> file will be generated from some applicat
I think the interesting thing is, why did it look at
an index not in select/where/sort operations at
all?Best idea I have heard so far is that somehow it
thinks that gathering the rowids from the index and
doing a table lookup is better than a fts. LElking
floated the idea that it might have to do
Aw, DANG, I knew I was gonna get that one. Same story,
give someone a script named after an adult
incontenence device, get ready for the teasing!
Don't even ask for the viagra script.
--- [EMAIL PROTECTED] wrote:
> > create table depends as select * from
> > sys.dba_dependencies;
>
> Depends?
> In my unix system (hp ux 10.20) I have one particular
> file will be generated from some applications every
> day.
>
> File name "MATERIAL.20020508225043"
>
> I usually deleted one month old files with *200203*> command ( I need to keep last month files 04
> and delete all older than that).
Sounds good in theory.
What if the upgrade destroys some DLL in the SYSTEM32 directory that
Oracle is dependent on?
There may be none Oracle registry entries set such as:
HKLM\SYSTEM\CurrentControlSet\Control\WaitToKillServiceTimeout
This is sometimes set to a much higher than default value t
> create table depends as select * from
> sys.dba_dependencies;
Depends? Like the adult diaper?
Doing a little CYA?
Jared
Jack Silvey <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
05/09/2002 04:03 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMA
Hello!
In my unix system (hp ux 10.20) I have one particular
file will be generated from some applications every
day.
File name "MATERIAL.20020508225043"
I usually deleted one month old files with command ( I need to keep last month files 04
and delete all older than that). Can any one please
Yechiel :
I will take a look at options.
Well, for use replication i need to set some parameters, right?
So, I didn't do it.
It means that i don't use replication.
but i will check others otpions.
Thanks
Regards
Eriovaldo
- Original Message -
To: "Multiple recipients of list ORACLE-
I believe that Waleed's response is essentially correct.
The numbers still don't make sense, but ...
a) 250,000 blocks with the mbrc = 64. The t/s cost
(according to my observations on 9.0.1 and
8.1.7) should be based on an adjusted mbrc
of 15.5
250,000 / 15.5 = 16,000
b)
That's nice to know Oracle 9i has this feature now.
Regards,
Waleed
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 7:13 PM
To: Multiple recipients of list ORACLE-L
Henry,
Thanks for the script..tkprof in 9i has some enhanced functionality which
includes th
Jonathan,
And here is some more info in addition to what Jack said. This was discussed
a while back but don't remember if you were involved. I know Waleed was.
Anyway, here are some parts from the 10053 trace files:
OPTIMIZER_INDEX_COST_ADJ = 1
<<>>
Access path: tsc Resc: 9696 Resp: 9696
In general There are two problems in using the "top five waits" out of statspack: it
reports idle waits; no matter how well-tuned your database there will always be a top
five. The numbers presented show total time-waited in csecs for the time period. As
Jared said we don't know the time per
"Never attribute to malice that which can be adequately explained by stupidity."
- Hanlon's razor
I've also seen variations that used "incompetence" or the more benign "ignorance"
instead of
"stupidity".
I agree. Effective conspiracy would require efficient planning and execution. Most
of wh
Henry,
Thanks for the script..tkprof in 9i has some enhanced functionality which
includes the wait events from the trace file..which is very similar to what
your script does in addition to regular tkprof statistics..
I have installed and used 9i tkprof with 8i generated trace file. Works
fine.
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 calcu
I am not able to display the bmp stored in the
BFILE.I followed 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 R
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
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 lis
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
dir
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 -0
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 any
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 wi
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 numb
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
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 produ
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
> P
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 recipie
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)
|+-->
||
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 recipie
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
Davi
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,
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 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
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
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 be
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
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
|---
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
>
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')
(Embedded image moved
to file:
pic28253.gif)
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
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
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] Quad/Te
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
you don't need the upper(ename) in your where clause... that forces oracle to
NOT use an index
|+->
|| |
|| |
|| Harvinder.Singh@met|
|| ratech.com
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 co
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 knew someone on the list would have it :) thanks Suzy.
actually, I'd do dbms_stats.delete_schema_stats('SYS') this time through to fix
the problem and then change the dbms_stats command to
dbms_stats.gather_schema_stats instead of database
|+--->
||
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
|+
> 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 re
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,
e.even
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
dbms_stats.gather
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 past.
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 immediatel
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[EMA
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 query
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,
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$;
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 new
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 null
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 all
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
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 r
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 OR
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 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$
return
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),
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 is
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
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: Thursday
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 permissi
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.
--- "She
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.
http:/
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
Dear
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 dba_ext
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 t
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 recipients
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
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 dat
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]
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
dbms_utility.analyze_
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 Pres
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 ORAC
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 \
/usr/cc
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
> singl
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
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]
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.
Thanks,
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 d
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 sponta
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
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
>
http://www.ecst.csuchico.edu/~melody/courses/Spg2001Oracl
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
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
# Written:Henry Poras
# 5/16
1 - 100 of 122 matches
Mail list logo
