Hemant, Group,
Could not resist: here is my 0.02 Euro.
(0.05 by the time I re-read it)
Start with a Disclaimer:
Limited SAN experience:
HP-(ex cmpq) storageworks (EVA3000?) and
Dell/EMC/Clarion only.
Here is How I try to approach SAN:
Me, the DBA, wants;
- focus on mountpoints
-
Hi Kaing,
Have you check the degree of fragmentation?
have you check your extent size?
Sinardy
-Original Message-
Sent: 01 October 2003 14:20
To: Multiple recipients of list ORACLE-L
Hello everyone,
Env: 8.1.7.4, SunOs 5.8 64 Bit
We seem to hitting bug 1262161. The bug seems to
Hi
I'm
basically doing the same: We're using PL1 programs to do an "unload" of VSAM
files by hand. That actually takes care of multiple record structures and the
like. It's a poor-man's normalisation of VSAMs ;). Then, just load the data as
it is into a staging DB (Oracle), transform it
Hi all,
I've read on ixora.com.au and other sites that the optimal block size for
AIX is 4K, because JFS pages are 4K also.
Has anyone of you ever experienced performance problems on AIX due to a
larger blocksize? What exactly are the 'read ahead' issues and cpu problems
regarding double
In 9i you could issue an drop tablespace temp including contents and
datafiles.
(First make sure that this tablespace is not a default temporary
tablespace).
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, October 01, 2003 5:54
Hi All,
I am trying to figure out what and why to monitor in a 9i RAC environment.
Could any of you guys please comment on the following:
Hi Govindan
Good thought!!, I was going to suggest the same idea, just to go and get
the description of the package / procedure / function from the
dictionary and then grant access to the dictionary views needed.
One slight flaw with your code though, you have selected from user_%
views but the
GC_FILES_TO_LOCKS? Sounds familiar from some other times. Why do you use
hashed (static) locks? I thought that releasable locks are default in 9i?
Is there a reason to revert to the Oracle 7 OPS behvior?
On 2003.10.01 06:13, Jack van Zanen wrote:
Hi All,
I am trying to figure out what and why to
Couldn't you do this with a simple:
select
owner, table_name
from
all_tables
where
tablespace_name= 'index_tbs';
?
Or of
course use IN for a list of tablespaces?
Or am
I missing something?
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of
Actually, 5 blocks wasn't completely hardwired, there was an undocumented
parameter (_walk_insert_threshold or something like that. My notes from
Scott Gosset's course are largely unreadable. What has hapened to my
handwriting? ) which was utilized to define the number of blocks that will be
5 is the number of blocks (probably defined in a header file) that is gotten
for creation.
it could be that the blocksize matters, but haven't seen it any other way
than 5.
after that, the HWM is bumped with 5 blocks too
(_bump_highwater_mark_count)
_walk_insert_threshold is the number of blocks
Anybody with a quick and dirty (elegant would be nice too), to munge output from a nslookup output file to a delimited file?
'File content:
Server: dns1.mci.comAddress: 199.249.19.1
Name: WCOM-4NXZGAPWY5.mcilink.comAddress: 166.50.73.209
Delimited file should have the following line(s); (using |
Hi!
But if this procedure runs in definer rights under schema where the objects
exist, then it should be possible?
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, October 01, 2003 1:59 PM
Hi Govindan
Good thought!!, I was
LOL
Of course the spent a lot on money on veterinarians to inoculate the horses
against the Y2K bug.
Mladen Gogala
Anybody with a quick and dirty (elegant would be
nice too), to munge output from a nslookup output
file to a delimited file?
'File content:
Server: dns1.mci.com
Address: 199.249.19.1
Name:WCOM-4NXZGAPWY5.mcilink.com
Address: 166.50.73.209
Delimited file should have the following
I'm trying to create a table using 'Create Table...As Select...'
The contents will then be exchanged into a partitioned table, so they need
to have the same names and datatypes.
Some of the columns in the created table are populated with zeroes will
be updated after the partition exchange,
Hi,
I have a table that I would like to perform a vertical search on. For eg.
Table X
---
IDCOL1 COL2
1 apple orange
1 mango banana
1 grape pineapple
2 mango banana
2 guava lemon
I would like to display records that meet
I hope not,
This is from the Oracle documentation (quite a lot is about RAC so to get
the general idea is OK but details are difficult to grasp).
Since the note: said setting that parameter to anything else but the default
would disable cache fusion in Oracle 9i RAC clusters, My question was if
I supposed if you send to a file, we can read it using ORACLE to parse
it w/plsql and then using utl_file write it back out but seems like
overkill to use oracle for that, but then again this is an oracle list,
so i'll have to assume thats what you wanted, anyone up for the task :)
joe
Johan
I was creating some trace files yesterday and came across one of these
problems that shows up occasionally (then I forget about it).
When I ran my query using ALTER SESSION SET sql_trace=true (sqlplus;
8.1.7.4), I got the STAT line in the trace and the associated 'row source'
information after
Tanel Kevin,
Thanks for the replies. Very helpful. I am using version 9.2.0.3. You
both confirmed what I thought I should do.
thanks again.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Tuesday, September 30, 2003 5:04 PM
To: Multiple recipients of list
I'm trying to create a table using 'Create
Table...As Select...'
The contents will then be exchanged into a
partitioned table, so they need
to have the same names and datatypes.
Some of the columns in the created table are
populated with zeroes will
be updated after the partition exchange,
COBOL isn't dead, it just smells funny. You know what COBOL stands for,
don't you? COBOL=Completely Outdated, Badly Overused Language.
On Tue, 2003-09-30 at 17:24, April Wells wrote:
COBOL still lives and breathes, though, in many MANY shops (this one
included). Just like the Mainframe, it
Hi,
I have a table that I would like to perform a
vertical search on. For eg.
Table X
---
IDCOL1 COL2
1 apple orange
1 mango banana
1 grape pineapple
2 mango banana
2 guava lemon
I would like to display records that
Hi Jeff,
Stealing extents is normal when there is no free space available to grow the active
undo segment.
If expired extents are getting stolen, I would not worry too much about adding more
space to the
undo tablespace, but monitor how much undo space the segment takes up.
If unexpired
9.2i [EMAIL PROTECTED] 09/30/03 08:54PM
What is the Oracle version?At 06:24 PM 9/30/2003 -0800,
you wrote:Hi!!I am trying to change the size of my tablespace
TEMP, I am not an Administrator but we really need to make this
tablespace smaller.Already the size is 13214 Mgs, and this tablaspace
List , thanks to you all I passed my oracle 9i performance tuning exam today
with good marks.
Thank you
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
Title: RE: STAT from trace
I get STAT lines no matter how I enable the trace. Make sure you wither close the session or stop the trace so that all pending STAT lines will be written to the file.
Raj
-Original Message-
From: Henry Poras [mailto:[EMAIL PROTECTED]]
Sent: Wednesday,
Whilst the vast majority of extents will be the
published ones - 64k, 1m, et al, you occasionally
get variants.
I have only three gripes with auto-allocate:
a) you can't perform the can I extend check on your
tablespaces. You cannot predict with 100% certainty
what the size of the next extent
#!/usr/bin/perl -w
use strict;
use bytes;
my ($NAME,$IP,@LB);
while () {
chomp;
@LB=split /\s+/;
if ($LB[0] =~ /^name:/i) {
$NAME=$LB[1];
}
if ($LB[0] =~ /^address:/i) {
$IP=$LB[1];
write;
}
}
format STDOUT=
@ ,@
$NAME,$IP
Btw, I did some testing on ASSM (9.2.0.4) a while ago and it seems there is
only 2 blocks required for ASSM when talking about small number of 5 block
extents. 2 for ASSM + one for header and rest two get formatted for data
when first row is inserted into table (using conventional mode, when doing
This table do not have any file, how I understood this is the
table space that the queries uses.
They tell me that if I run a query that need mode that the
actual space it will be made that the TEMP tablespace grow.
[EMAIL PROTECTED] 09/30/03 10:09PM
If the TEMP tablespace is a temporary
Stephane,
Apologize for not being clear on my question.
The query you have provided will only return one record, ie.
1 mango banana.
I need two records to be returned:
1 mangobanana
1 grape pineapple
You're right that by 'vertical', I meant filtering according to conditions
on OTHER
Hi
Just wondering: How did you implement the transparancy aspect ?
Interceptor pattern (as in CORBA) ?
Your tool seems to be a very good thing to use during dev-cycle to log
certain aspects you're interested in (maybe log4j might do the job ?).
Stefan
-Ursprüngliche Nachricht-
Von:
-Original Message-
From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2003 7:34 PM
To: Multiple recipients of list ORACLE-L
Subject: locally managed autoallocate (was: Separate Indexes and Data)
Ive read the book. PCTINCREASE is basically set to 100%
If you can stop the users then simply drop the
tablespace and remove the datafile, then crate new smaller temp.
If you can not stop the users do:
1) Create newsmall temp;
2) Alter all users to use the new
temp.
3) Drop temp , after you are sure that none of the
users is using it.
Yechiel
I received an e-mail from Oracle saying that I won a PHP cookbook from
Oracle (http://otn.oracle.com/products/jdev/temp/rules.htm) Anyone here get
my PS2?
Now maybe I'll be able to get PhpWiki working against Oracle on Alpha
Linux... :)
Rich
Rich Jesse
Faan
Thanks. Yes I totally agree that the practice exams are very helpful. In
my case I chose Couchman's book of practice exams. Usually my exam score has
been higher than my practice exam scores. My current study method is to
record quiz questions on an audio CD so I can study during the time
Hi!
This is the problem, that everything else was identical. If you executed
exactly the same query again, it didn't get hard parsed anymore, thus no
STAT lines were generated. Either flush shared pool or just add some bogus
comment using /* */ into your query to get parsing and STAT lines.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, October 01, 2003 8:39 AM
Dennis,
Do you have good practice exams?
I have found that the best preparation for the OCP exams are good practice
exams.
I have reached the point where I
Leng,
I recall a similar scenario some months ago. It had to do with the average row size
(quite large) and the block size. The average row size was just under 1/2 of the block
size, so the chances of a new row finding a spot in an existing block was slim. Add in
that there is a limit (5 I
Hi!
I'm trying to create a table using 'Create Table...As Select...'
The contents will then be exchanged into a partitioned table, so they need
to have the same names and datatypes.
Actually they do not have to have same column names, only the datatypes and
column order has to be the same
I'm trying to create a table using 'Create
Table...As Select...'
...
I don't think that there is any problem here. Specifying the number of
digits is largely cosmetic - consider it asa default mask. It doesn't
affect how data is stored inside the tables AFAIK.
Regards,
Stephane
Where did you look for this file? Use v$tempfile or
dba_temp_files.
Anyway, your case is a good reason why not to
enable autoextend in temp and rbs tablespaces without extra care.
If you got DBA access to your database, you
could:
1) create temporary tablespace
new_temp
2) alter database
Good for you! :)
Cheers,
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, October 01, 2003 5:24 PM
List , thanks to you all I passed my oracle 9i performance tuning exam
today
with good marks.
Thank you
--
Congrats!
How did you find the exam, Easy? Tough? Ambigous?
Regards
Naveen
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 01, 2003 7:55 PM
To: Multiple recipients of list ORACLE-L
Subject: exam
List , thanks to you all I passed my oracle
I have Oracle 9.2i
I already run the query and the tablespace TEMP have
CONTENTS=TEMPORARY AND EXTENT_MAN=LOCAL
Can I run this line to fix the size of my
tablespace?
SQL alter database tempfile
'/data/oradata/system/temp01.dbf' resize 128M;
I mean is the same or I have to change
I second that
https://grc.com website. It is a great
resource for testing your vulnerabilities!
[EMAIL PROTECTED] 09/30/03 06:54PM Whatever you use go to https://grc.com/x/ne.dll?bh0bkyd2
and http://grc.com/lt/leaktest.htm
for testing your firewall product and make sure that the basic stuff
-Original Message-
From: Jesse, Rich
Sent: Wednesday, October 01, 2003 9:49 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: locally managed autoallocate (was: Separate Indexes and
Data)
Theoritically, perhaps, but what if an existing table needs
to auto-extend
at 1M
Title: RE: exam
Congratulations ... so what was your Hit ratio ...
Raj
-Original Message-
From: [EMAIL PROTECTED]
Subject: exam
List , thanks to you all I passed my oracle 9i performance tuning exam today with good marks.
Thank you
I don't need to test my vulnerabilities. I know my vulnerabilities are
working well.
On Wed, 2003-10-01 at 11:09, Gene Sais wrote:
I second that https://grc.com website. It is a great resource for
testing your vulnerabilities!
[EMAIL PROTECTED] 09/30/03 06:54PM
Whatever you use go to
Yes you can.
On Wed, 2003-10-01 at 11:29, Teresita Castro wrote:
I have Oracle 9.2i
I already run the query and the tablespace TEMP have
CONTENTS=TEMPORARY AND EXTENT_MAN=LOCAL
Can I run this line to fix the size of my tablespace?
SQL alter database tempfile
Kirti,
I had upgraded a database from 8.1.7.4 to 9.2.0.4. Before the upgrade,
performance is good. After upgrade, one query run time from 2 min to 12
hours. Of course, I re-analyzed all tables and indexes. The explain plan
changed from hash join to nested-loop. All the parameters are same. So I
Title: RE: STAT from trace
Thanks. I tried both disabling the trace and quitting from the session.
No luck with 10046, just sql_trace.
Henry
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Jamadagni,
RajendraSent: Wednesday, October 01, 2003
Richard - My apologies that concern for passing the exam has caused some of
us to exchange tips that you find offensive. And I truly admire those who
have been able to just walk in the exams and pass. And I had similar gripes
against the exams until I was felt the need to pass the exams. I
Congratulations. Do you feel you learned anything from this exam?
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
List , thanks to you all I passed my oracle 9i performance tuning exam today
with good marks.
Thank you
--
Please
Hi Ron,
We tested out a FAStT-900 a few months ago. I was happy with the
performance results, although we were testing it to replace an HP AutoRAID
12H, so I'd imagine *any* other storage solution would have been better. :)
Unfortunately, our test 900 wasn't able to be hooked up to an HP
- Original Message -
I don't need to test my vulnerabilities. I know my vulnerabilities are
working well.
Hehehe! As we'd say in my local newsgroup:
Check yuor settings!
I second that https://grc.com website. It is a great resource for
testing your vulnerabilities!
Too true.
How about
for /L %i IN (1,1,250) do start /min sqlplus user/[EMAIL PROTECTED]
@script.sql
Id try it with less than 250 as it can kill the machine opening 250
windows!
;-)
to run form a batch file you need to %%i the variable
hth
bob
If on windows, type
start /min sqlplus user/[EMAIL
Joan, what is the difference in the plans? What specific feature
made the difference? Are the values of
optimizer_index_cost_adj and optimizer_index_caching same on both
versions? How about histograms? What is with
db_file_multiblock_read_count,sort_area_size and hash_area_size? Is
everything same
:31
I'm trying to create a table using 'Create
Table...As Select...'
...
I don't think that there is any problem here.
Specifying the number of
digits is largely cosmetic - consider it asa
default mask. It doesn't
affect how data is stored inside the tables AFAIK.
Regards,
Joan,
Can you post the query with the plan in 8.1.7 and 9.2; We ran into certain types of
queries that had totally different execution plans and got work-arounds.
Thanks,
Govind
-Original Message-
Joan Hsieh
Sent: Wednesday, October 01, 2003 11:55 AM
To: Multiple recipients of list
I don't think that you can reduce temp datafile much below bytes_used value
in v$temp_space_header. I could reduce the file few kilobytes, but not much
compared to it's size. In order to reduce bytes_used, you need to bounce
instance (if there isn't any nifty tricks for releasing temp segment
Stephane,
Apologize for not being clear on my question.
The query you have provided will only return one
record, ie.
1 mango banana.
I need two records to be returned:
1 mangobanana
1 grape pineapple
You're right that by 'vertical', I meant filtering
according to conditions
on OTHER
Try these queries.
/*
Rows returned below mean that UNDO_RETENTION needs to be increased
*/
select * from v$undostat where UNXPSTEALCNT 0 or SSOLDERRCNT 0;
/*
Rows returned below mean that space needs to be added to the undo
tablespace. All space
in the tablespace was used and no free space
Is anyone using Oracle database with IBM disk storage FAStT?
I was wondering if you had any performance problems, pitfalls
and any-
other stories that you might want to
inform me about? Before we commit
ourselves in purchasing this SAN your info
would be appreciated.
We are a
Execution plans would be helpful.
If optimizer_index_* parameters are unset, CBO tends to prefer full table
access more, which doesn't seem to be your case (but exectution plans are
needed in order to be sure in that).
As Mladen asked about histograms - do you use bind variables in your
queries?
Wonderful race, the Romans. Just super! sniff!
on 9/30/03 3:34 PM, Jesse, Rich at [EMAIL PROTECTED] wrote:
Crucifixion is a perfectly viable form of punishment, but only for the first
offense.
Best thing the Romans ever done for us. Oh, yeah. If we didn't have
crucifixion, this
Hi Joan:
Is your hash_area_size parameter the same in both situations?
Guang
-Original Message-
Joan Hsieh
Sent: Wednesday, October 01, 2003 11:55 AM
To: Multiple recipients of list ORACLE-L
Kirti,
I had upgraded a database from 8.1.7.4 to 9.2.0.4. Before the upgrade,
performance is
One of the undocumented init.ora parameters that changed from 8 to 9 is
_UNNEST_SUBQUERY (from false to true). You could try if that is the
culprit. Of course, since it is an undocumented parameter, get the blessing
from Oracle support before using it in a production database.
At 10:09 AM
Part of the problem is self-inflicted. We currently use separate tablespaces for each
major project. For instance: chemical inventory gets its own data and index
tablespaces, dosimeter data gets the same, network configuration data as well. For
many projects once the design has matured
Title: RE: Huge optimization costs with 9.2
yeah ... and setting _unnest_subquery=true also gave WRONG results when you used a aggregate function in a sub-query without a group by clause.
That was a bug ...
Raj
-Original Message-
From: Wolfgang Breitling [mailto:[EMAIL
Thanks to everyone who responded to this thread -
Option A is now to persuade the designers to remove the Number formatting
from the parttioned table,
Option B is to pre-create the working table and populate it with Truncate
and Insert /* Append */
Option B will be slower, I think, due to the
Thanks to everyone who responded to this thread -
Option A is now to persuade the designers to remove the Number formatting
from the parttioned table,
Option B is to pre-create the working table and populate it with Truncate
and Insert /* Append */
Option B will be slower, I think, due to
Mladen,
It worked!
Heartfelt thank you from the evangelized perl crowd (now watch the list-owner grin).Mladen Gogala [EMAIL PROTECTED] wrote:
#!/usr/bin/perl -wuse strict;use bytes;my ($NAME,$IP,@LB);while () {chomp;@LB=split /\s+/;if ($LB[0] =~ /^name:/i) {$NAME=$LB[1];}if ($LB[0] =~
I've read on ixora.com.au and other sites that the optimal block size for
AIX is 4K, because JFS pages are 4K also.
Isn't JFS block size changeable?
Has anyone of you ever experienced performance problems on AIX due to a
larger blocksize? What exactly are the 'read ahead' issues and cpu
Wolfgang, you're a genuine cornucopia of useful knowledge. This is
another email of yours that I'll have to save for later as people's
exhibit S.
On Wed, 2003-10-01 at 12:54, Wolfgang Breitling wrote:
One of the undocumented init.ora parameters that changed from 8 to 9 is
_UNNEST_SUBQUERY
Richard,
Thanks for the detailed explanation!
As a C programmer of some 20 years, I can only assume that Oracle has done
away with the use of the malloc(), free(), etc UNIX library calls and is
now calling the UNIX system call brk() directly?
It was the underlying heap-extent management in the
On Wed, 2003-10-01 at 13:24, Johan Muller wrote:
Mladen,
It worked!
Did you have any doubts? That's precisely what perl is good for.
Note:
This message is for the named person's use only. It may contain confidential,
proprietary or legally privileged information. No
No, option B is as fast as CTAS (as long as you don't have any indexes on
the table).
Just make sure that your append hint works...
Also you have to specify NOLOGGING on table or tablespace level when doing
insert /*+ APPEND */ or use NOLOGGING hint if you're on 9i.
Tanel.
--
Please see
Our exchange hiccupped...
How about
for /L %i IN (1,1,250) do start /min sqlplus user/[EMAIL PROTECTED]
@script.sql
Id try it with less than 250 as it can kill the machine opening 250
windows!
;-)
to run form a batch file you need to %%i the variable
hth
bob
If on windows, type
start
Yes, they are same. Basically I didn't change any parameter after
upgrade.
Guang Mei wrote:
Hi Joan:
Is your hash_area_size parameter the same in both situations?
Guang
-Original Message-
Joan Hsieh
Sent: Wednesday, October 01, 2003 11:55 AM
To: Multiple recipients of list
Henry,
What happens if you issue another query after the query of interest?
(something like "select 1 from dual;") STATshould be emitted when
the cursor is closed.
Daniel
Henry Poras wrote:
Thanks.
I tried both disabling the trace and quitting from the session. No luck
with 10046, just
Malden,
They all same. I didn't change any parameters after upgrade. The
difference in the plans are one used all hash join vs nested loop to
join tables. The histograms are all same. db_file_multiblock_read_count
is 8, sort_area_size is 1mb, hash_area_size is 40096.
optimize_index_caching and
this is the explain plan for the 9i, sorry it is long sql.
Rows Row Source Operation
--- ---
1 LOAD AS SELECT (cr=14674449 r=2275 w=1831 time=787991194 us)
42647 NESTED LOOPS OUTER (cr=14673991 r=2273 w=0 time=5081221102 us)
Thank God for Perl and Mladen ;)
Tanel.
- Original Message -
From:
Johan Muller
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, October 01, 2003 8:24
PM
Subject: Re: UNIX : script
help/input
Mladen,
It worked!
Heartfelt thank you
That's not true. The STAT lines in the 10046 trace have nothing to do with
parsing. But you must close the cursor for them to be written to the trace.
If you are using sqlplus, either close the trace or the session, otherwise
sqlplus keeps the cursor for the most recent sql open.
Here is an
Funny
.. I am currently sitting in a Perl class, so I can actually read what MG has
written. I'll be soon Perl-literate ...
Raj
-Original Message-From: Tanel Poder
[mailto:[EMAIL PROTECTED]Sent: Wednesday, October 01, 2003
1:35 PMTo: Multiple recipients of list
Could it be that the optimizer uses different algorithms since 9.2 value
would default max permutations to 2000 instead of the 8
--
Oracle9i Database Reference
OPTIMIZER_MAX_PERMUTATIONS
Parameter type
Integer
Default
Stephane,
Fantastic! Appreciate the help.
Thanks!
susan
From: Stephane Faroult [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: RE: vertical serches on a table - how to
Date: Wed, 01 Oct 2003 08:04:31 -0800
Stephane,
Apologize
Sure, you could do that.
It just doesn't seem like a good way to deal with
the possibility of an index tablespace possibly
having data segments in it when backing up only
data segment tablespaces.
Unless you have *really* large databases with very
generous restore time requirements , I don't see
Richard,
I agree that the OCP is a laughing matter among experienced DBA's but to those that
are pressurized by their non-technical management, especially HR, to obtain
certification for various reasons, there is very little choice than to get it or get
out...:-(
I can definitely see that
Tried
that. Also queried on open_cursors in a parallel session.
Henry
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Daniel FinkSent:
Wednesday, October 01, 2003 1:59 PMTo: Multiple recipients of list
ORACLE-LSubject: Re: STAT from
Joan,
Can you post the query in question?
Thanks,
GOvind
-Original Message-
Joan Hsieh
Sent: Wednesday, October 01, 2003 2:00 PM
To: Multiple recipients of list ORACLE-L
Malden,
They all same. I didn't change any parameters after upgrade. The
difference in the plans are one used all
Then perhaps you can help me . . .
We are suffering through a Pro*Cobol / Oracle on the mainframe implementation for a
newly developed in house application.
We have a mainframe with 1.7GB - 2GB REAL memory.
4 CPU machine - we have two logical CPUs in our LPAR
We have 8 instances running (each
:)
On Wed, 2003-10-01 at 10:24, Johan Muller wrote:
Mladen,
It worked!
Heartfelt thank you from the evangelized perl crowd (now watch the list-owner grin).
Mladen Gogala [EMAIL PROTECTED] wrote:
#!/usr/bin/perl -w
use strict;
use bytes;
my ($NAME,$IP,@LB);
while () {
chomp;
Eeep! Reminds me of my CICS programming in school on a 4MB (MEGA bytes) IBM
4341 with the student partition on the lowest priority. For some reason,
the operator got really mad at me when I forgot to put an unexecutable EXIT
statement in my code...
Barring any OS stats, have you tried a 10046
The way I do it is to print the articles to a .PDF converter like Win2PDF
(http://www.win2pdf.com/download/download.htm) that installs a printer driver to which
you can print anything you could have printed to a regular printer. The free version
has a popup dialog but given the usefulness, is
Do you get the PARSE, EXEC and FETCH entries for the sql?
You gave us your Oracle version, but what is your platform?
Would you care to try the following: since sql_trace = true corresponds to
event 10046, level 1, why not set event 10046 at level 9. Maybe that'll
do the trick.
At 12:59 PM
Tanel, that's not correct. 10046 10053. To get the STATs lines the
trace buffer has to be flushed i.e. the cursor has to be closed and
the next statement is processed (or user closes the session) -- depends
on the nature of the application, types of opened cursors and
instance/session settings.
1 - 100 of 140 matches
Mail list logo