Hi
syed...
srw.run_report ('d:\test.rdf destype=file
desname=try.out desformat=dflt batch=yes');
The
above will work fine. You should not mention 'report' keyword in the command
line. This is the
mistake in reports help.
Nirmal.
Prior
Deveoper, Current OCP DBA.
-Original
Eric Richmond,
hi, try to set it in regedit, or click my
computer-property-advanced-enviroment variable-add nls_date_format.
Regards
zhu chao
Eachnet DBA
86-21-32174588-667
[EMAIL PROTECTED]
www.happyit.net
=== 2002-09-09 11:18:00 ,you wrote£º===
On NT/2000, how can
Chuan,
If I remember right, you're supposed to turn the outlines on and then
run your sikvel or procedure to catch the offensive statement(s).
Regards,
Ed
Hi, All,
From Oracle Doc: if the SQL text of the incoming statement
exactly matches the SQL text in an outline in that category,
Title: OEM: Is there a test to find broken dblinks?
Hi All,
I'm looking for an event test in OEM to find broken dblinks.
Anyone know such?
Thanks.
For those who are not enlightened
yet
http://www.taobackup.com
Title: OEM: Is there a test to find broken dblinks?
That
would be useful, as import drops package bodies when there are invalid db links
in packages.
Short
of testing them manually one by one, I don't know of one. Import must be
doing it though, when it tries to compile packages.
Regards,
MS will make XML part of the OS... they are the first to bundle XML into an
OS... They mention IIS
Did anyone review the J2EE and .NET comparison paper on Oracle's site? Do
Oracle's conclusions in that paper seem plausible?
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Can you post a link? I've just been reading an article in Oracle mag about
Oracle implementing XML directly in to the database (XML DB), and another
article talking of Oracle integrating more tightly with the .NET platform in
9iR2 (as well as support for VLM via Windows' AWE's)..
Just wondering
On Tuesday 10 September 2002 13:58, you wrote:
MS will make XML part of the OS... they are the first to bundle XML into an
OS... They mention IIS
Really??? What about Mac OS X?
Did anyone review the J2EE and .NET comparison paper on Oracle's site? Do
Oracle's conclusions in that paper
This may be opening a can of worms, but has anyone on the list used Oracle Support's
Online DBA for Applications or Patch Management services for Oracle Apps 11i? If so,
what particular services did or are they performing for you? Were or are you
satisfied with their work?
Thanks,
Bob
I do have an index on the unencrypted SENSITIVE_DATA.
Does it look something like
select *
from original_table
where decrypt(sensitive_data) = 'CLEAR TEXT'
Yes but the call to decrypt(sensitive_data) is embedded in the view.
An index on the function means the unencrypted sensitive data
OK... I did a search at www.oracle.com:
Overall web page comparing the two:
Oracle9i and J2EE vs. Microsoft .NET
Comparing Oracle9i to Microsoft .NET can be difficult because Microsoft .NET
is a combination of marketing hype, product branding and technology
re-architecture. In contrast,
I wasn't making a statement, just reporting what was in the article.
: )
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
Sent: Tuesday, September 10, 2002 10:03 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: Here we go again!!
What I found interesting in MicroSoft's marketing hype was their inference that
the OS would provide all of the functionality of an Application server. Now
they just were in court for bundling the OS and browser. Are we in for a new
round of court battles as they bundle the application server
zhu chao,
Thanks for checking this out. I tried it again this morning and it worked
like your example. At first I thought there might be a difference when
creating a view on all rows (*) versus creating the view on a subset (x, y,
z) but under both conditions a view was created successfully.
Beth,
This seems to be it. If I disable to PK, the ignore for everything else
is happy...so, the question becomes...
I have a table that represents quarterly data. The data in it is
basically the same for every quarter...adding the period is what
makes things unique. What is important from a
Hello List
I got a message about Hotsos Tuning seminar in Dallas. Scheduled in February
2003.
The lecturers list include among others: Tom, Anjo, Gaja.
http://www.hotsos.com/events/symposium/
I also know that there is an IOUG Live meeting on May 2003, and many of you
recommended going.
What about...
create view my_data as select de_encrypt(sensitive_data) as
clear_sensitive_data where
sensitive_data = encrypt('CLEAR TEXT') ?
This lets you create an index on the sensitive data without decrypting it, and
the function need only be called once on the clear text.
Caveat: no idea
MS will make XML part of the OS...
But will it really be XML? They have a history of bending
the standards to the point that anyone else's products
break with M$. I'd wait to see how well they conform to
buy-the-book XML before depending on it for anything.
For a good example of this look at
To set it at the session level, You need,
Alter session set nls_date_format='DD-MON- HH24:MI';
You can give any valid format string.
If you want this to happen automatically in your sqlplus session you can add
this to your glogin.sql script.
Hope this helps.
Viral.
From: Farnsworth, Dave
hi, list friends:
We know statspack can gather history data and let you compare statistics from
different time snapshot.But it is something difficult, for you must make multiple
report and open them one by one and compare data between different reports.
Now i want to gather some
Don,
It seems like a real good idea, but what am I putting inside my call to the
encrypt function in my Create View statement?
Randy
-Original Message-
Sent: Tuesday, September 10, 2002 10:13 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: using obfuscation
I've been tasked to ensure only certain app programs access the
database.
I'm thinking on-logon trigger, check the program field from
v$session. unfortunately v$session is for all sessions, i can't seem to
find the view that tells me only MY info during login. I only want the
sid, serial#,
Hi,
We are
creating a 45GB database from a restore of a current system. My boss has
requested that I reorganize the entire new database. I have my doubts that
this will provide as much benefit as he seems to expect, but they are adamant
that this is what they want. One of the desired
Joe,
I use the following with decent success on a
logon database trigger:
-- Set a unique string for the session
and update the session info.
client_info_str :=
'WTWLOGIN_' ||
LTRIM(dbms_random.value,'.');
DBMS_APPLICATION_INFO.SET_CLIENT_INFO(client_info_str);
-- look into the
Zhu - You can use STATSPACK to gather the statistics into its tables and
then query those tables directly. In the book ORACLE High-Performance Tuning
with STATSPACK, Don Burleson describes how to do this in detail and provides
many example queries. He advocates gathering STATSPACK statistics over
Title: RE: using obfuscation
Can you create a Function based index on that column? That could be of use ...
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and
Depends on what you are looking for.
The Hotsos Seminar will be strictly tuning, will be very intense on
that, will not have vendors
The IOUG conference will have a vendor hall, will have a much wider
variety of presentations on all topics
It's sort of like deciding between a meal at a buffet,
Title: RE: Ioug meeting or HOTSOS Seminar
Since performance tuning is just one aspect (although extremely important) of my DBA role I would choose IOUG thinking that I would get performance info. as well as other aspects of my role covered and could pick/choose. Although a conference with
I am attempting to install 9ir2 on a Red Hat 7.2 Linux
box. Part way through the first attempt I decided to
changed the Oracle home value. I stopped the install,
deleted the previous Oracle home directory tree, built
the new directory and restarted the install.
Oracle has stored the value of
Title: RE: Table Locks
Call me crazy if you wish. But I would take a process or system state dump and navigate the locking session's object hierarchy. Yes, I know, ugly as Sin and potentially life-shortening.
HTH
Tony Aponte
-Original Message-
From: Alan Davey [mailto:[EMAIL
Given that you will probably see Anjo, Cary, Tom and potentially Gaja, at
the event, I would recommend IOUG Live!
Reason 1: Significantly more presentations
Reason 2: More opportunities to network with other people in your
position
Reason 3: Greater opportunity to share your
use v_$mystat - it has the sid - then do
your join with v$session
-Original Message-From: JOE TESTA
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, September 10, 2002
10:58 AMTo: Multiple recipients of list ORACLE-LSubject:
methodology to keep only certain programs to connect to
Yes. This works great. You posted your logon trigger before and I've used
it with considerable success (and modification). We (will) use the logon
trigger to ensure that a particular Oracle userid is logged on only from
one machine (no sharing of userids). We also allow certain exemptions,
Russ,
This is OT relative to your question
slightly, but Be sure to take some good response time measurements (10046
level 8) before the rebuild so that you can make objective before/after comparisons.
If youre right about your prediction that all this work wont
provide much of a
Joe
You can use the sys_context function to get
the auditing session id -
select * from v$session where audsid =
sys_context('USERENV','SESSIONID');
David Lord
-Original Message-From: JOE TESTA
[mailto:[EMAIL PROTECTED]]Sent: 10 September 2002
16:58To: Multiple
Hi All,
I am facing problems with a database with some very irresponsible users who
just connect
to the database from their applications and simply dont logout. Apart from
the usual
chidings I have been giving them, could any of you please tell me whether
any
parameter exists which can be put
Can you use the USERENV or SYS_CONTEXT
function?
-Original Message-From: JOE TESTA
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, September 10, 2002
9:58 AMTo: Multiple recipients of list ORACLE-LSubject:
methodology to keep only certain programs to connect to
I've been tasked
zhu chao wrote:
hi, list friends:
We know statspack can gather history data and let you compare statistics
from different time snapshot.But it is something difficult, for you must make
multiple report and open them one by one and compare data between different reports.
Now
Are we taking votes?
From what Cary/Gaja/Anjo/Tom etc have contributed so
far on list, I'd say Hotsos.
Hey Cary, when are you planning to present in the
Washington DC area?
mkb
--- [EMAIL PROTECTED] wrote:
Since performance tuning is just one aspect
(although extremely important)
of my DBA
Why not issue queries against the statspack tables to get your info?
(if you are using statspack that is)
-Joe
--- zhu chao [EMAIL PROTECTED] wrote:
hi, list friends:
We know statspack can gather history data and let you compare
statistics from different time snapshot.But it is
I don't think you can really compare them. I haven't been to
a HOTSOS seminar, but it is in depth tuning of Oracle.
IOUG is a smorgasboard of Oracle topics and an excellent
networking opportunity.
Jared
Yechiel Adar [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
09/10/2002 07:23 AM
Yechiel,
Just to clarify... There are actually two different event types here
that I think Jared might have blended together in his response.
1. The Hotsos Clinic is a 3-day course, taught by Jeff Holt and me,
dedicated to the single purpose of teaching Oracle performance problem
diagnosis and
I'm trying to use SQLLDR Oracle 8.1.6 on a UNIX box but I'm getting:
Fatal Error: cannot map libwtc8.so
My environmental variables are:
ORACLE_BASE=/m1/oradec1/app/oracle
ORACLE_HOME=$ORACLE_BASE/product/8.1.6
LIBPATH=$ORACLE_HOME/lib
CLASSPATH=$ORACLE_HOME/jlib
Select sid
from v$msystat
where rownum = 1
Gary Kirsh
Next Extent Consulting
-Original Message-From: JOE TESTA
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, September 10, 2002
11:58 AMTo: Multiple recipients of list ORACLE-LSubject:
methodology to keep only certain programs to
With a setup like this, how do you stop a
user from simply renaming the program they are using to match what you expect to
see and, therefore, getting past your security ??
-Original Message-From: Shaw John-P55297
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, September 10, 2002
Goto Both
-Original Message-
Sent: Tuesday, September 10, 2002 7:23 AM
To: Multiple recipients of list ORACLE-L
Hello List
I got a message about Hotsos Tuning seminar in Dallas. Scheduled in February
2003.
The lecturers list include among others: Tom, Anjo, Gaja.
Hi All,
I want to load PDF files into the database and view the content of the lobs column. Below is what I did step by step. Anyone please point out what did I do wrong in my procedure. I am still unable to view the content of the Lobs column. I need you all for your help.
Please note that I
Joe,
you may try:
select sid, serial#,
username, program from v$session where audsid = userenv(
'sessionid')
Regards,
Catalin
Nastase
-Message d'origine-De: JOE TESTA
[mailto:[EMAIL PROTECTED]]Date: mardi 10 septembre 2002
17:58À: Multiple recipients of list
try removing the /etc/oraInst.loc and the oraInventory file(the location of
it is in the .loc file).
Joe
Check your LD_LIBRARY_PATH setting.
-Original Message-
Sent: Tuesday, September 10, 2002 1:13 PM
To: Multiple recipients of list ORACLE-L
I'm trying to use SQLLDR Oracle 8.1.6 on a UNIX box but I'm getting:
Fatal Error: cannot map libwtc8.so
My environmental variables are:
How about the oraInventory?
-Original Message-
Sent: Tuesday, September 10, 2002 12:18 PM
To: Multiple recipients of list ORACLE-L
I am attempting to install 9ir2 on a Red Hat 7.2 Linux
box. Part way through the first attempt I decided to
changed the Oracle home value. I stopped the
Russ - Why don't you consider this:
- Create a new tablespaces LMT and uniform sizes (please read the
documents to understand this concept clearly).
- Move tables into the new tablespaces using ALTER TABLE MOVE. This is
MUCH faster than export/import.
- If you have space issues, just
Hi all:
I have been trying to use the until_cancel option in
BMC Backtrack 3.3.00 to do until cancel recovery.
But in the maual the description of this option
is applies archive logs until there are no more.
This is not exactly until cancel IMO. Is there any
way to do a real until cancel via
Kevin,
That has been my point in the past. It
is really not feasible to establish connection policy this way.
For example: anybody can change the
name of the sqlplus.exe executable on their desktop, run it, and connect to the
database. v$session.program now reports the new executable name
Joe,
Try this:
select
s.username,
s.sid,
s.serial#
from v$session s
where userenv('SESSIONID') = s.audsid;
Jared
JOE TESTA [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
09/10/2002 08:58 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
Hi All,
I ve a JSP application. Each time I query database ( oracle 9i) from the
page, I see that the no.of cursors increments by one. I m accessing database
using JDBC, I close resultset and statement objects after query. But I m not
closing Connection object since I use a Connection Pool.
Can
I've seen this type of thing done using domain indexes, i.e. defining your
own indextypes. Looked like a bit of work, though.
HTH,
Gary
Gary Kirsh
Next Extent Consulting
-Original Message-
Sent: Tuesday, September 10, 2002 11:58 AM
To: Multiple recipients of list ORACLE-L
Don,
It
I stand (sit?) corrected... the Hotsos Seminar will have vendors.
Possibly a more selective list of vendors, but there will be vendors
there.
--- Rachel Carmichael [EMAIL PROTECTED] wrote:
Depends on what you are looking for.
The Hotsos Seminar will be strictly tuning, will be very
Thomas:
Try setting the LD_LIBRARY_PATH environment variable. Typically for
Solaris it is set to the following:
export
LD_LIBRARY_PATH=/lib:/usr/lib:/usr/ccs/lib:/usr/dt/lib:/usr/ucblib:$ORACLE_HOME/lib:$ORACLE_HOME/network/lib
export LIBPATH=$LD_LIBRARY_PATH
If you still get that error, try
Jared(and others)
thanks, a bunch you all had what i was looking for perfectly.
joe
[EMAIL PROTECTED] 09/10/02 12:55PM
Joe,Try this:select
s.username, s.sid, s.serial#from v$session
swhere userenv('SESSIONID') =
s.audsid;Jared"JOE TESTA"
[EMAIL PROTECTED]Sent by: [EMAIL
Thomas
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, September 10, 2002 1:13 PM
To: Multiple recipients of list ORACLE-L
I'm trying to use SQLLDR Oracle 8.1.6 on a
DEGREE=1
-Original Message-
Sent: Monday, September 09, 2002 8:38 PM
To: Multiple recipients of list ORACLE-L
What is the DEGREE setting on the table?
-Original Message-
Sent: Monday, September 09, 2002 4:48 PM
To: Multiple recipients of list ORACLE-L
alter table
Did you delete the OraInventory directory? It's location is specified in
/var/opt/oracle/oraInst.loc file.
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
If A = B and B = C, then A = C, except where void or prohibited by law. -- Roy Santoro
Samir,
Yes there is, 1st set resource_limit = TRUE in the init.ora file. 2nd bounce
the database. 3rd create a profile for those who are the inconsiderate bunch and
set idle_timeout = x where x is in minutes. Their session will show up in
V$session as sniped. You can then easily put
On a RH7.1 test box that I'd hosed, I needed to manually delete and
reinstall Oracle. To do this, I needed to remove the
$ORACLE_BASE/oraInventory directory (along with all the old $ORACLE_HOME
dirs) as this contains all the fun stuff that the installer uses.
But one shouldn't nuke directories
I'm working with an application that uses a combination of encrypted
seed numbers and password protected roles to limit access to the
application tables to the specific application and version.
In this database, any external application (sqlplus, etc) cannot provide
access to the application
I am trying to tune a SQL query on Oracle 8.1.6. I have tried several
optimizations, but
so far have made no improvements. I would appreciate any suggestions.
SELECT am.lid, am.name
FROM am, so, sa
WHERE so.lid = am.lid
AND so.key_ = sa.so_key
AND am.active = 1
AND so.code = 11
AND sa.ret = 'SB'
Joe,
Create a view over V$SESSION with the condition
where audsid = SYS_CONTEXT('USERENV', 'SESSIONID')
call it USER_SESSION and grant SELECT TO PUBLIC on it.
--
Regards,
Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
what are the drawbacks with such a trigger,
what if the code went invalid and would not compile is
it possible that you could lock yourself
out, or would the base login functionality still work regardless
or the status of this trigger?
-Original Message-From: Mercadante, Thomas F
More thoughts :
SQL*Plus fills MODULE in, don't know about TOAD (I think it does),
but typically a number of PC clients may appear as the name of a DLL. I
think that you shoud rather allow in than exclude out, and (ab)use
DBMS_APPLICATION_INFO in the programs which are allowed.
--
Regards,
You
can drop/re-create users and tablespaces, and import users. Down timealso
depend on i/o bus and disk system.
inka
-Original Message-From: Brooks, Russ
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, September 10, 2002
11:44 AMTo: Multiple recipients of list ORACLE-LSubject:
I've done something similar in the past (move a database to a new machine
and go to uniform extents). I didn't find any quick and easy methodology.
Basically you have to pre-create the tablespaces where you want them and
with the storage parameters that you want.
Then import the database to
RANT
I've just spent 30 minutes with our SAP administrator trying to
convince her that we really don't need to reorganize the tables
in our production SAP database.
Due to some misinformation in an Oracle Press book, 'Oracle Unleashed'
I think, she is equating number of extents with
I hope this isn't overly simplistic but, is it because of the larger
extent size?
For instance, if it was in 4m extents before and used 26M, it would have
fit in 7 extents with 2M of free space.
But when moved to 25M extents, it would use 2 extents with 24M free
space.
How many segments is
Sorry about the previous incomplete mail !
We've been trying unsuccessfully to get the OEM console to launch from OEM's website
hosted on a Windows 2000 server running IIS (not oracle HTTP). The EM 9.2.0.1.0 readme
clearly states that MS IIS 5.0 is can be used to serve the EM 9.2.0.1.0
Dennis,
If you use the ordered hint and have sa then so then am and also hint to use
the index on sa(ret) then I think that would be about the best as you'd be
starting with the best filter ie 1.3m/281 giving less than 5000 on average
(assuming ret is indexed). I don't know if you'd have to
I don't see LD_LIBRARY_PATH in there.
It should be set to $ORACLE_HOME/lib
Jared
Thomas Day [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
09/10/2002 11:13 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:
I have always thought this was the best way to implement a security package.
Nice to see you implemented the seed number for changing encryption.
-Original Message-
Sent: Tuesday, September 10, 2002 1:49 PM
To: Multiple recipients of list ORACLE-L
I'm working with an application that
Title: RE: using obfuscation
Wouldnt
that store the sensitive data in the index?
-Original
Message-
From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 10, 2002
12:13 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: using obfuscation
Can you
My experience is that an invalid trigger doesn't fire --- no effect.
Also, userids with the DBA role don't fire the trigger. So you can't lock
yourself out of the database. Just go in with a DBA role userid and drop
the logon trigger.
You can't.
This is one of the reasons I haven't tried to use this.
Jared
Kevin Lange [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
09/10/2002 10:53 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:
Hi Richard,
A couple of questions.
What version of Oracle?
What version of Solaris?
Are you using asynch I/O?
Are you on filesystems? If so, which one (ufs, vxfs, vxfs with quickio)?
Have you specified ioslaves? If so, how many?
How did you determine how many threads you were using?
Is the
Is there a
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kawatra V (Vikas) at Aera
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
DENNIS WILLIAMS wrote:
I am trying to tune a SQL query on Oracle 8.1.6. I have tried several
optimizations, but
so far have made no improvements. I would appreciate any suggestions.
SELECT am.lid, am.name
FROM am, so, sa
WHERE so.lid = am.lid
AND so.key_ = sa.so_key
AND am.active = 1
Dennis,
What is the distribution of sa.ret?
I didn't see it included in an index.
Jared
DENNIS WILLIAMS [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
09/10/2002 12:18 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Dennis,
You're better off not having an index on the AM table. With 220,000 out of 250,000
rows having the same value, an index will do you more harm than good. You're not much
better off on the SO table with only 12 different values out of 1.3 million. The final
table SA has 281
With the end-goal of doing a character set conversion from US7ASCII to
UTF8, I have run csminst.sql to create work tables and then run the CSSCAN
utility from rdbms/admin on my test database.
We have written a C program to identify and alter exceptional characters
identified by the CSSCAN
Title: RE: methodology to keep only certain programs to connect to
Revoke all roles from all apps. You will have to change some code in authorized apps to enable roles after they log in to allow them to access the database. All stray applications won't do this, so even if they log in they
So, did you bend to her wishes?
ltiu
[EMAIL PROTECTED] wrote:
RANT
I've just spent 30 minutes with our SAP administrator trying to
convince her that we really don't need to reorganize the tables
in our production SAP database.
Due to some misinformation in an Oracle Press book, 'Oracle
Title: RE: using obfuscation
I wouldn't worry about that ... unless you dump the index blocks, you won't see that data anyway. OTOH, why don't you set your view to select based on a PK and then apply the function on selected rows??
Raj
__
I am trying to upgrade Oracle 8.1.7 on MS2000 to patchset 8.1.7.4.1. I keep
getting a message that says a component
that the installer needs to update is busy. It would be too easy to tell me
what it is. I have stopped everything
related to Oracle but I still get the message. Can anyone tell
Jared,
What version of the database does this book refer to? I do remember back in
Version 6 and early 7 that having all of your data for a table and/or index all
in the first extent was a performance benefit. Regrettably that idea had been
proved false more than once after 7.2 hit the
You have my profound sympathies, having been there and done that.
Russ
-Original Message-
Sent: Tuesday, September 10, 2002 4:29 PM
To: Multiple recipients of list ORACLE-L
RANT
I've just spent 30 minutes with our SAP administrator trying to
convince her that we really don't need to
Thanks everyone for your wonderful suggestions. And thanks for leaving the
hey stupid off your reply header :-)
Rachel - Thanks for the bitmapped idea. These tables don't change often, so
that may be a good alternative.
Iain - Thanks so much for the detailed suggestions.
Rick - Good sanity
Doing Phil Hartman's impression of Bill Clinton
'We feel your pain'
end impression
-Original Message-
Sent: Tuesday, September 10, 2002 2:29 PM
To: Multiple recipients of list ORACLE-L
RANT
I've just spent 30 minutes with our SAP administrator trying to
convince her that we really
Kawatra V (Vikas) at Aera wrote:
Is there a
No.
--
Regards,
Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroult
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San
I feel your pain. You got the publisher right, but it's not Oracle
Unleashed. It's from p109 of the best-selling but utterly reprehensible
Oracle Performance Tuning Tips Techniques book.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic, Oct 1-3 San
Oops, sorry for the mis-attribution, and my unintended slight on
the author of 'Oracle Unleashed'
Jared
Cary Millsap [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
09/10/2002 02:23 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Have you brought to that meeting some basic storage statistics? If she is a decision
maker, the only thing to do is to provide solid and dry technical information.
Expected outage time of SAP including.
inka
-Original Message-
Sent: Tuesday, September 10, 2002 4:29 PM
To: Multiple
1 - 100 of 130 matches
Mail list logo
