of time for a total amount not-to-exceed? Cant
think of any other metrics that matter...on 1/16/04 2:19 PM,
Thomas Jeff at [EMAIL PROTECTED] wrote:
If you
were to write up a RFP for programming services, what kind, if any,
metrics would
you include to provide some measurements
Title: SLA/metrics for RFP for programming services
If you were to write up a RFP for programming services, what kind, if any, metrics
would you include to provide some measurements by which performance of the contract
can be assessed? The tasks will typically be writing up ETL runs for our
Title: DB_WRITER_PROCESSES vs DBWR_IO_SLAVES
Running 9.2.0.2 on AIX 4.3.3. We recently experienced a situation where
a datawarehouse database crashed due to a bug dealing with DBWR_IO_SLAVES 0.
Oracle's recommended fix was to set the DBWR_IO_SLAVES to 0, which I did.
Now, my
://www.orafaq.net
--
Author: Thomas Jeff
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing
in there. That
is, not using bind variables.
A 10046 trace level 4 or 12 will show you what is
going on there.
Jared
On Mon, 2003-12-22 at 12:39, Thomas Jeff wrote:
We recently experienced a crash on our prod datewarehouse running
9.2.0.2 on
AIX 4.3.3.The cause of the crash was 4031 errors
for
it.
After bouncing the database and trying this again, I couldn't
duplicate it.
Maybe a couple of things to pursue here, but perhaps not
an abundance of help. :(
Jared
On Tue, 2003-12-23 at 04:44, Thomas Jeff wrote:
Jared,
Digging into it more, I found out
Title: STATSPACK interpretation
We recently experienced a crash on our prod datewarehouse running 9.2.0.2 on
AIX 4.3.3. The cause of the crash was 4031 errors generated by background
processes (Oracle support has confirmed there is a bug involved), however,
since that crash occurred, a
at:
http://gkmqp.tce.com/tis_dba
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Thomas Jeff
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Thomas Jeff
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
that number against the values
in
v$undostat as it runs. Remember, UNDO_RETENTION is not guaranteed. If the
space is needed by another segment, it may be taken even if the expire
time
has not been reached.
Daniel
Thomas Jeff wrote:
Thanks for the reply Dan.
Would you suggest setting
available at:
http://gkmqp.tce.com/tis_dba
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Thomas Jeff
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
to a high number. Once you are using AUM, keep a close eye on
v$undostat, though there are some known issues with it not populating
properly, keep an eye on the begin_time and end_time. However, for
estimation purposes it should work.
Daniel Fink
Thomas Jeff wrote:
I'm beginning the process
at:
http://gkmqp.tce.com/tis_dba
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Thomas Jeff
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list
-free christian music 24x7x365 at
http://www.klove.com
** The opinions and facts contained in this message are entirely mine and do
not reflect those of my employer or customers **
-Original Message-
From: Thomas Jeff [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 17, 2003 1:55 PM
Thomas
DBA
Thomson Information Services
Thomson, Inc.
Email: [EMAIL PROTECTED]
Indy DBA Master Documentation available at:
http://gkmqp.tce.com/tis_dba
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Thomas Jeff
INET
: Thomas Jeff
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send
://gkmqp.tce.com/tis_dba
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Thomas Jeff
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web
DBA Master Documentation available at: http://gkmqp.tce.com/tis_dba
-- Please see the official ORACLE-L FAQ:
http://www.orafaq.net
-- Author: Thomas Jeff INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San
Title: Can't run full exports due to SMON wait
Running 8.1.7.4 on RS6000/AiX 4.3.3. We noticed this weekend that all our
full exports performed via sqlbacktrack for a given database were hanging.
Killing the exports and restarting does not work.
Checking waits, it looks as though the full
Title: 8i databases under 9i listener?
RS6000 running AIX 4.3.3. We are experiencing the following issues with
our 8.1.7.4 databases under a 9.2.0.1 listener.
1) PL/SQL procedures utilizing UTL_FILE fail with INVALID_PATH errors when
attempting to open a file.
2) Database links from
al Message-From: Thomas Jeff
[mailto:[EMAIL PROTECTED] Sent: Wednesday, March 05, 2003
8:05 AMTo: Multiple recipients of list ORACLE-LSubject:
8i databases under 9i listener?
RS6000 running AIX
4.3.3. We are experiencing the following issues with
our 8.1.7.4 databases under a
Title: 8.1.7.4 databases going bad
This is on our RS6000 test server running AIX 4.3.3.
We've been gradually migrating our 8.1.7.x databases to 9i. We started by laying down
the 9i software 3 months ago. No problem. Then we started up the 9.2.0.1 listener as the sole
listener for the box 3
Title: Hanging query puzzle
We have a query from a 3rd-party tool that seems to either run very quick or crawls to a complete stop.
We can find no patterns to this behavior. The hang can be experienced even when there are no other
processes active in the database. Checking waits, we see a
Sorry, running 8.1.7.2 on AIX
4.3.3.
-Original
Message-From: John Shaw
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 05,
2003 2:09 PMTo: Multiple recipients of list
ORACLE-LSubject: Re: Hanging query puzzleWhat version
are you running - I have a similar problem on 9.2.0.2
: Wednesday, February 05, 2003 2:58 PM
To: [EMAIL PROTECTED]
Cc: Thomas Jeff
Subject: Re: Hanging query puzzle
What is the value for WAIT_TIME ? This may not be an IO problem
if 'WAIT_TIME' is not 0. A session is waiting only when 'WAIT_TIME' is 0. I
would suggest running some utility like
5 smon timer
0 WAITING 80
12 slave wait
0 WAITING 199
13 slave wait
0 WAITING 199
14 slave wait
0 WAITING 262
15 slave wait
0 WAITING 199
28 NIK db file scattered read
0 WAITING 20119
-Original Message-
Sent: Wednesday, February 05, 2003 2:58 PM
To: [EMAIL PROTECTED]
Cc: Thomas Jeff
Thomas Jeff [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/08/2003 02:14 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject: RE: Create Mat View uses DEFAULT TABLESPACE for temp segments?
You were right.
Tracing the operation did show
Title: Create Mat View uses DEFAULT TABLESPACE for temp segments?
This is 8.1.7.4 on AIX 4.3.3. When I try to create a materialized view in
the specified tablespace, I hit the following error. Is this a behavior of
the create materialized view statement, to create temp segments in the user's
-Original Message-From: Thomas Jeff
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 08, 2003 8:04
AMTo: Multiple recipients of list ORACLE-LSubject:
Create Mat View uses DEFAULT TABLESPACE for temp
segments?
This is 8.1.7.4 on AIX
4.3.3. When I try to create a materialized
Title: RE: Create Mat View uses DEFAULT TABLESPACE for temp segments?
You were right.
Tracing the operation did show at the end that there's a CREATE UNIQUE INDEX
statement with no tablespace specified. Checking the manuals a bit more
carefully shows that Oracle will create at least one
Title: RE: Replacing control chars
REPLACE/TRANSLATE. Go to http://asktom.oracle.com/ and query 'remove control characters'.
-Original Message-
From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 03, 2003 12:09 PM
To: Multiple recipients of list ORACLE-L
Title: RE: Row cache locks on INSERTs with a sequence
If I stated dc_segments in my original post, I apologize, I *did* mean to say
dc_sequences. At any rate, as usual, the problem was poor application code.
The row cache lock no longer shows up as one of the top 5 wait events per
statspack.
Title: RE: Row cache locks on INSERTs with a sequence
Jonathan,
The inserts were into a staging table. After the staging table was
loaded into the live tables, they were using delete and not truncate
to flush the staging table. So of course the table and index were
acquiring an excessive #
Title: Row cache locks on INSERTs with a sequence
We are continually seeing sessions hanging on row cache locks, which in
turn appear to be on dc_segments:
SID EVENT P1TEXT P1 P2TEXT P2 P3TEXT P3
- - -- -- -- -
29 row cache lock cache id
Title: RE: Row cache locks on INSERTs with a sequence
Thanks for the replies.
And, good guess Jonathan.
We've already made some changes to the stored procedure implementing the
INSERT statement.
Upon investigation, I found that the table involved is used as a staging table in a
batch
Title: Common PL/SQL package to truncate tables
We have a DSS database containing numerous datamarts, each stored in it's own schema.
Each datamart schema has a corresponding OPS$ batch account, which does the ETL work.
DML privs on all tables within a schema are granted to a
. The success of the procedure's execution would
depend on the invoker having the required privileges.
--- Thomas Jeff [EMAIL PROTECTED] wrote:
We have a DSS database containing numerous datamarts, each stored in
it's
own schema.
Each datamart schema has a corresponding OPS$ batch account
Title: RE: install of 64 and 32 bit
According to Metalink, 8.1.7 64-bit is not certified for AIX 5.1.
-Original Message-
From: Ehresmann, David [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 03, 2002 11:09 AM
To: Multiple recipients of list ORACLE-L
Subject: install of 64 and
Title: Performance consequences from downgrading from 64-bit to 32-bit?
We have an 8.1.7.4 64-bit 24x7 OLTP database currently hosted on an RS6000 s80 running
AIX 4.3.3 The database is scheduled to be migrated to a new box, RS6000 ip680, running
AIX 5.1. According to the compatibility matrix
Title: NIKU v6.0.0.12?
Anyone running NIKU, v6.0.0.12 using an 8.1.7.2 repository on AIX 4.3.3?
Jeffery D Thomas
DBA
Thomson Information Services
Thomson multimedia Inc.
Email: [EMAIL PROTECTED]
Indy DBA Master Documentation available at:
Title: OT: MIcrosoft Blackmail
This came to our DBA team today. I'd appreciate your thoughts. I'm not a business
guy, just a plain old Apps DBA, but this really pisses me off. Is it common practice
by MS?
It is important from an Architecture point of view that we understand all the
:
Mass inserts from TCL ?
Hi
Thomas,
hv u
checked oratcl?
metalink note 1017044.6
-Mandar
-Original Message-From: Thomas Jeff
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, September 10, 2002 5:23
PMTo: Multiple recipients of list ORACLE-LSubject:
Mass
Title: Mass inserts from TCL ?
I have a programmer inquiring as to the viability of having up to 10-15 concurrent client
sessions inserting orders that would contain anywhere from 100 to 6000 order line items each
via TCL. The orders are generated from a browser client and the whole shebang
Title: OT: Most trustworthy executives
Apologies if this has been posted before...
Crisis in corporate governance According to the newest survey by WhisperNumber.com,
investors ranked Berkshire Hathaway CEO Warren Buffett as the most trustworthy executive
in corporate America. The online
. If the sequence is
ordered (default) then Oracle must satisfy the first request for NEXTVAL
before it can go on to the next request. If order is not important try
NOORDER and see if the locks don't go away.
Thomas Jeff
ThomasJe To: Multiple recipients of list ORACLE-L
@tce.com [EMAIL
Title: RE: How do YOU use Java in the DB?
In our ecommerce databases:
1) Interface with LDAP
2) Email
3) Query for product inventory/pricing via MQSeries
4) Send customer orders to our fulfillment provider
-Original Message-
From: Jesse, Rich [mailto:[EMAIL PROTECTED]]
Sent:
Title: How to model DBA_SEGMENTS for trend analysis?
This is rather a simplistic question, but how would you model the DBA_SEGMENTS table
for trend analysis purposes? Simply duplicate the table and add a TIMESTAMP (which
is what I wanted to do.)
Even though it's *my* project, my boss,
Title: RE: Do programmers tune SQL?
Our developers tend to be of the 'Meet the Holy Deadline at all costs' school and
tuning is rarely perfomed; we've had some major resource issues due to bad SQL.
Our lead DBA got the idea of revising our migration process so that all SQL code migrates
Title: RE: Java permissions
Query DBA_JAVA_POLICY
-Original Message-
From: Mike Killough [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 4:28 PM
To: Multiple recipients of list ORACLE-L
Subject: Java permissions
Could someone please tell me how to see the java
Title: Using SQL*LOADER to import UNICODE?
We have an European SQL Server database where it's planned to extract files in UNICODE
with Cyrillic characters and load them into our local UTF8 database.
Is it possible to use SQL*LOADER to load these files?
We are still on 8.1.7.2, and
Title: STATSPACK impact?
Just curious, but if your shop uses STATSPACK, could you tell me how frequently you run it,
particularly in your OLTP databases; and whether you've noticed any performance issues with
generating frequent STATSPACK snapshots?
Thanks.
Title: RE: Connecting to 8.1.7.2 with Unicode Character set
I don't believe you can do it -- UTF8 wasn't implemented until v8 so 7.3.4 clients aren't
UNICODE-literate.
We had the same situation here, and had to upgrade everyone to 8i clients.
-Original Message-
From: Smith, Ron
Title: RE: mystery cartesian join
Maybe the optimizer thinks there's a many-to-many relationship between si_log
and sm_monitor? Try putting in an ORDERED hint and see if that helps.
Jeff T.
-Original Message-
From: Kempf, Reed [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January
Title: Oracle Online Training (OLN)???
Management is considering purchasing subscriptions to OLN as opposed to sending us
to instructor-led classes, supposedly more bang for the buck.
Is OLN worth the cost, or is it just worthless? What's your experience?
Thanks.
more $HOME/scripts/imp_arc.par # #
imp_arc.par # parameter file to import arcdb schema # #
userid=username/password fromuser=scotttouser=scottindexes=y
grants=n rows=y commit=y ignore=y feedback=10
buffer=400
- Original Message -
From:
Thomas Jeff
Title: Export via pipe ksh script
Could someone please send me a ksh script for doing imp/exp via a pipe.
We're running AIX 4.3.3.
Thanks!
Jeffery D Thomas
DBA
Thomson Information Services
Thomson multimedia Inc.
Email: [EMAIL PROTECTED]
DBA
Title: SELECT x FROM DUAL is bad for system performance?
On page 92 of Oracle Performance Tuning 101, there's a recommendation
to avoid the use of SELECT X FROM DUAL, claiming that it can '..use up system
performance in a hurry', but does not go on to elaborate as to exactly *why*.
Could
Title: FW: Antwort: RE: Antwort: RE: Buffer Busy Waits -- Sanity check please
The table has about 550,000 rows, and will be growing, currently about
230MB in size.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 27, 2001 7:25 AM
To:
-- Sanity check please
Thomas Jeff wrote:
We recently had a new website go live. Since then, I'm seeing
constant buffer busy waits
and after a period of time, I see sessions hung on the same block#.
The SQL query
is always a COUNT(*) (below). It's almost as though one session has
a lock
Title: Buffer Busy Waits -- Sanity check please
We recently had a new website go live. Since then, I'm seeing constant buffer busy waits
and after a period of time, I see sessions hung on the same block#. The SQL query
is always a COUNT(*) (below). It's almost as though one session has a
Title: Location of PLAN_TABLE
Rather a trivial question, but our DBA team is discussing how best
to implement the location of the plan table. My preference is
is simply create is as SYS, public synonym, and grant privs on
it to our developers. I'm being outvoted by the others, who
want to
.
-Original Message-
From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 29, 2001 1:45 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Location of PLAN_TABLE
-Original Message-
From: Thomas Jeff [mailto:[EMAIL PROTECTED]]
Rather a trivial
Title: ORA-600 when querying DBA_SOURCE, ALL_SOURCE.
And yes, I've got a TAR logged with Oracle on this, but I wonder if
any of you have seen anything like this before. Whenever we try to query
any of the *_SOURCE views we get an ORA-600. If you look at the
view text for DBA_SOURCE:
select
Title: RE: Alternatives to roles in procedures?
We don't allow granting IUD privileges to remote schemas at our site.
All DML to be applied on tables within a given schema is performed
only by stored procedures owned by that schema. We essentially have
just two roles (assume ABC schema):
Title: Full IMP hangs at the same spot
We're running 8.1.7 on RS6000, AIX 4.3.3. We are trying to do a
full exp/imp into a clone database. The imp hangs at the same location
every time, on a table that has only 2 rows in it, although the table does
have 2 VARCHAR2(2000) columns. We're unable
Title: Licensing cost for 1000 concurrent users?
We are in the process of negotiating our contract with Oracle.
I've been asked to inquire as to how much other sites are paying
for a license for 1000 concurrent users. We are looking in
the ballpark of $400-$500k according to the Oracle
Title: SMS and Net8 Client Deployment
Any shops out there using SMS to deploy Net8 clients?
If so, could you give me the gist of the mechanics?
Thanks,
Jeff T
[EMAIL PROTECTED]
Title: RE: SDU and TDU in SQL*NET
I believe the TDU parameter is now ignored in Net8.
Our tests seems to indicate that it's fixed at 32K.
Jeff T.
[EMAIL PROTECTED]
-Original Message-
From: Orr, Steve [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 20, 2001 5:23 PM
To: Multiple
Title: 7.3.4 Support
Can anyone tell me when Oracle officially ceased providing support
for 7.3.4?
Thanks,
Jeff T
[EMAIL PROTECTED]
Title: Database Links standards
We came up with the below standards with respect to database links (heavily
used in our environment). The result has been a billion complaints by
our developers, stating that the standards are unnecessarily complex. I'm
curious as to what others might think,
Title: SQL-Server Presentation/Reality Check
I have the privilege of being tasked to attend a SQL Server presentation to
be conducted by Microsoft at our site. Our company's current take on SQL
Server is that it's to be used only in the case where a packaged application
requires it, or when
Title: RE: Database Cache of Oracle9ias
What platform? On AIX there's a bug with respect to extproc that
will give you this error.
Jeff T
[EMAIL PROTECTED]
-Original Message-
From: Oracle DBA [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 13, 2001 5:21 PM
To: Multiple recipients
Title: Standard vs Enterprise Edition
Due to Oracle's licensing shenanigans, we are looking at the use of the Standard
edition to save . In fact, our management may even make Standard the de facto
standard while requiring justification for Enterprise.
If anyone is currently using
Title: RE: Standard vs Enterprise Edition
Thanks everyone for the replies.
-Original Message-
From: Suhen Pather [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 28, 2001 6:26 PM
To: Multiple recipients of list ORACLE-L
Subject: FW: Standard vs Enterprise Edition
Oops !!!
Title: RE: dbms_obfuscation package
FWIW: This is something I played with a long time ago:
DECLARE
v_input_string VARCHAR2(32) := RPAD('STRING TO BE ENCRYPTED', 32, ' ');
v_key_string VARCHAR2(32) := RPAD('JOXERTHEMIGHTY', 32, ' ');
v_encrypted_string VARCHAR2(2048) := NULL;
send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Thomas Jeff
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access
across all
these filesystems? E.G: Take a 8GB tablespace, distribute it in 2GB
chunks across 4 of these filesystems?
Thanks,
Jeff
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Thomas Jeff
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051
'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Thomas Jeff
IN
78 matches
Mail list logo