John/Tim,
The 'direct path read/write' are for cursor #14. The delete is cursor #15.
Check the trace file for the preceding cursor #14.
Paul
-Original Message-
Sent: Thursday, October 30, 2003 1:40 PM
To: Multiple recipients of list ORACLE-L
Tim,
As you have seen, this is due to wr
select to_char(sysdate, 'W') from dual;
Paul
-Original Message-
Sent: Thursday, December 19, 2002 10:54 AM
To: Multiple recipients of list ORACLE-L
Hey Folks,
Looking for the simplest of queries to find the week number, given a date.
For example, 19th December 2002 falls in the 3rd we
use
execute immediate 'alter session enable parallel query';
Paul
-Original Message-
Sent: Wednesday, October 02, 2002 11:24 AM
To: Multiple recipients of list ORACLE-L
Hi guys
I am trying to create the following trigger.
The user in question is logging in using siebel app
Totally agree.
I didn't make the point of accessing the production OLTP system, as I didn't
think that anybody is still doing that :)
Any serious reporting should be off of a database setup specifically for
that purpose.
Through a proper meta-data layer, the joins between dimensions and fact
Currently going through a migration from 8.1.6.0.0 to 8.1.7.4
1. Had 8.1.6 installed.
2. Install 8.1.7.0 into new ORACLE_HOME
3. Apply pathset to get to 8.1.7.4
4. Upgrade database to 8.1.7.4
You only need to upgrade once, with only 2 oracle homes.
Paul
-Original Message-
Sent: Th
Cognos notwithstanding, isn't the objective in the case of Data
Warehouse/DSS/Reporting/BI (or whatever the latest buzzword is for
generating reports) to give end-users access to the data. These end-users
then generate the own reports, without the need for IT every time they need
a new total on a
Yeh, but he is the Prez ... :)
Paul
-Original Message-
Sent: Wednesday, June 26, 2002 12:39 PM
To: Multiple recipients of list ORACLE-L
> if you are a lousy presenter, giving bad information,
> you get horrible scores, and...
Unfortunately, there is no reliable correlation between gi
Title: RE: using a lot of temporary tablespace with large sort area size
What
about hash_area_size?
Paul x3704
-Original Message-From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]Sent: Friday, June 07, 2002
10:58 AMTo: Multiple recipients of list ORACLE-LSubject:
RE:
I had the pleasure of meeting some of the oracle-l list members during the
recent IOUG in San Diego.
I also brought my family with me to San Diego, to combine my business with
their pleasure. The IOUG (rightly perhaps) did not cater for any
family-related events (although the Big Bash may have b
>From the 'Data Management and Storage Internal" notes,
Bitmapped Tablespace File Structure
A new bitmapped tablespace file has the following structure:
File Header 1 block
Bitmapped File Space Header 1 block
Head portion of of Bitm
Following on from my previous note:
Jeremiah,
>From your bitmap control,
You have FF occurring 3 times followed by 3F which is
255, 255, 255, 63 which is
0011
So, least signficant bit first,
1100 which is
used, used, ... (30 t
Assuming that the application "knows" the real username, let the first
thing that the app does is call dbms_application_info.set_client_info passing
the real username as a parameter. This sets v$session.client_info to the
real username.
T10-PARTS> select client_info from v$session 2 wh
Try and determine what it is doing/waiting for. Set up a 10046 trace at
level 8. You may get lucky and see the problem within the first few minutes
rather than wait the full 7 hours.
Paul
-Original Message-
Sent: Wednesday, March 27, 2002 11:04 AM
To: Multiple recipients of list ORACL
This does make you wonder about the recently awarded Master's certification
given by Oracle. (Not taking anything away from Jeremiah though)
Paul
-Original Message-
Sent: Thursday, March 14, 2002 3:20 PM
To: Multiple recipients of list ORACLE-L
"..increasing the buffer hit ratio fro
Also,
optimizer_search_limit (I think hidden in 8.1) defaults to 5, which means,
consider all permutations, including Cartesian product joins, if the # of
tables in the from clause is 5 or less. For more than 5 tables, Cartesian
products are not considered initially.
Another parameter is optimi
It has to be that "unless your data is all in one extent, you would
experience bad performance"
Paul
-Original Message-
Sent: Tuesday, March 12, 2002 3:43 PM
To: Multiple recipients of list ORACLE-L
I'm putting the final touches on my IOUG-A presentation (I got an extension
for those
Set you 10046 trace at level 4 or 12, and then check the trace file.
Paul
-Original Message-
Sent: Friday, February 22, 2002 3:53 PM
To: Multiple recipients of list ORACLE-L
Hi Listers,
I got the following statement in the tkprof output file :
update EMP set "ENAME"=:V001,"EMPNO"=:V
How about :
select num
from NUMBERS,
( select begin, end from RANGE)
where num between begin and end;
Paul
-Original Message-
Sent: Friday, February 22, 2002 10:14 AM
To: Multiple recipients of list ORACLE-L
You are right that the range aren't necessarily contigous.
I'd probably
Patrice,
The only reason I can think of creating a column with a datatype of ROWID,
is in order to store a rowid. Why you need to "store" the rowid escapes me
as the rowid is available as a pseudocolumn anyway.
It is also dangerous to "store" this rowid in a column, as it can change.
During and
Hi Larry,
the lb (lock byte) in the row piece of the block points to an ITL entry.
As for the ITL entry, there is a slight confusion in that the headings don't
line up exactly with values. In your case, when uncommitted, the contents
are :
Itl 0x01
Title: RE: Number of Transactions per 24hr period? - Urgent
Denham,
Craig
Shallahamer explores this issue in a paper on www.orapub.com about Response Time
Analysis.
In
essence, one way of calculating the no. of transactions can be from 'user
commits' + 'user rollbacks', but it appears
Which version? Does it have the case clause?
-Original Message-
Sent: Wednesday, November 14, 2001 4:50 PM
To: Multiple recipients of list ORACLE-L
Hi all,
Can decode work on a range, like if Code is > 100 and
< 200, then name is A; if code>200 and code<300, then
name is B; I hav
Roland,
You are missing a comma and a quote. It should be
(KAMPANJTYP_ID "DECODE(:KAMPANJTYP_ID,'?','98','!','97', :KAMPANJTYP_ID)",
not
(KAMPANJTYP_ID "DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID)",
See the difference?
Paul
-Original Message-
Sent: Tuesday, November
!! Please do not post Off Topic to this List !!
Hi List,
I am trying to calculate the average database response time for a data
center audit currently underway. Without "expensive" monitoring tools, is
it possible to determine this from database statistics. So far, I'm using
(Service Time + Wa
t; also send the HELP command for other
> information (like subscribing).
__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
formation in
> it, and can't make sense of
> it.
>
> I thought perhaps I could figure out what this
> is by looking in the Oracle
> Internals book by O'Reilly, but no success. It
> does say that KS is a layer
> used by the other layers for memory manageme
Adams
> @ http://www.ixora.com.au/
> @ http://www.christianity.net.au/
>
>
> -Original Message-
> From: Paul Parker
> [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, 13 February 2001 8:41
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Consistent Gets?
&
1 SQL*Net roundtrips to/from
> client
> > 0 sorts (memory)
> > 0 sorts (disk)
> > 0 rows processed
> >
> > 12:09:38 T10-SERVCBO-CH> spool off
> >
> >
> > What am I missing here? Any help
> appreciated.
> >
&g
--
> To REMOVE yourself from this mailing list, send
> an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling
> of 'ListGuru') and in
> the message BODY, include a line containing:
> UNSUB
yas" Shamsudeen
> Certified Oracle DBA
> "This is my opinion and does not bind my
> employer. Use at your own risk"
>
>
>
>
>
>
> Paul Parker
yas" Shamsudeen
> Certified Oracle DBA
> "This is my opinion and does not bind my
> employer. Use at your own risk"
>
>
>
>
>
>
> Paul Parker
_
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Parker
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858)
32 matches
Mail list logo
