Title: Using dimensions
Query rewriting to use materialized views requires
dimensions to be defined.
Tanel.
- Original Message -
From:
Jamadagni, Rajendra
To: Multiple recipients of list ORACLE-L
Sent: Monday, September 29, 2003 7:14
PM
Subject: RE: Using
Raj,
what does TFM STFW mean ?!!
let me also get used to the list's acronyms :)
Jp.
- Original Message -
From: Jamadagni, Rajendra
To: Multiple recipients of list ORACLE-L
Thanks Scott, okay lets forget OLTP .. but I haven't seen any _actual_ uses
of dimensions ... where does
google gave me for example such an address
http://www.gaarde.org/acronyms/
I'm sure one of hundreds or even thousands
-Original Message-
From: Prem Khanna J [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2003 12:09 PM
To: Multiple recipients of list ORACLE-L
Subject: Re:
I've used Black Ice in the past as well Peter, and I know what you mean on
that count. I now user Sygate Personal Edition, which is a LOT better at
this. It won't let anything in, nor *out* without asking me if it's OK. It
also holds a log of incoming and outgoing traffic, showing accepted and
An expert is the one who fully understands all of the important
relationships between different parts of a system, I have a long way to go
for getting there.
But my sources are Oracle docs, Ixora, Internet, few training materials and
of course Oracle server itself with awesome tracing and
OwwThank God Raj hasn't replied yet :-)
Thanx Gints.
Jp.
30-09-2003 18:24:28, Gints Plivna [EMAIL PROTECTED] wrote:
google gave me for example such an address
http://www.gaarde.org/acronyms/
I'm sure one of hundreds or even thousands
-Original Message-
From: Prem Khanna J
Title: Message
You still can have row migration when pctfree is
set too low. ASSM doesn't resolve that. But yeah, ASSM removes the pctused and
freelist/group issues (and introduces others :)
Tanel.
- Original Message -
From:
Mladen
Gogala
To: Multiple recipients of
No, X$ tables exist even before a database is created - they are mostly
instance related structures, not database or data dictionary ones. Do a
startup nomount and select from x$ksuse or even dual for example and you
see.
You just can't select from these x$ tables which want to read physical
Title: Message
Hm, maybe you get something useful out using truss
or strace on your server process when creating the tablespace.
You should at least see the calls on what you're
waiting the most.
Tanel.
- Original Message -
From:
Mladen
Gogala
To: Multiple recipients
With pleasure Ranganath.
..and ur example,sure ,was useful.
Kind Regards,
Jp.
30-09-2003 17:47:38, Ranganath K [EMAIL PROTECTED] wrote:
Hi Prem,
I am also unable to reach it. The sight might be down. However
I hope you would have found the example useful. BTW Can you please send
me
Pete,
Which paper of Aarons are you referring to? Is the paper entitled
Encryption of data at rest?
Regards,
Craig Munday.
At 05:29 AM 29/09/2003 -0800, you wrote:
Hi Jp
On the specific issue of encryption your main concern will be hiding the
encryption key from any prying eyes. There is a
Hi there,
I've supported a number of systems implemented in Java running on Oracle
and on nearly all of the projects the developers have asked me to increase
the number of open_cursors. In most of the cases I have found that the
developers were not using the JDBC API efficiently. The main
I've encountered this problem so often that I decided to write a tool
(called JDBC Expert) that would help us DBAs (and developers) detect
Statement and ResultSet leaks in Java applications. I've found this
tool so useful and effective at finding resource leaks that I insist any
in
house
Craig,
CMI can send you a copy if you are interested -
CMyou will have to forward me your JDK version and details about any app
CMserver that you are using.
I would , sure , be very much interested in having a copy of that tool.
developers here use diff. versions of JDK apache/tomcat/jboss
Title: Re: Using dimensions
Query rewrite from materialized views does not require dimensions; they are only used in certain fairly obscure situations.
on 9/30/03 1:49 AM, Tanel Poder at [EMAIL PROTECTED] wrote:
Query rewriting to use materialized views requires dimensions to be defined.
I picked my copy up last night from my local Borders bookstore. They even
had a copy for the shelf. I'm assuming everyone else has theirs by now and
are busily reading. Please post any comments or observations. Leave it to
Cary to put exercises at the end of each chapter. A quick flip through
Hi Jp,
No its not the paper you mention from iDefense but the one you got is
not too bad. My paper was called Encrypting data in the Oracle
database - as i say if you email them you may be able to get it.
kind regards
Pete
In article [EMAIL PROTECTED], Prem Khanna J
[EMAIL PROTECTED] writes
Hi
Hi Tim,
I would suggest there are two key advantages to using automatic workspace
management.
The first and perhaps most important is that yes, unlike the manual method
by which sessions cling onto memory, automatic workspace management can
deallocate the tuneable portion of the PGAs (those
I've also picked up my copy yesterday but ...I'm assuming everyone else has
theirs by now and
are busily reading. ... I still not have finished Tom Kite Expert one on
one
Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tel. (514)
Title: Re: Statspack Report!
Without looking at other parts of the report, there is no way of telling if this information is important or not. There is not enough timing information displayed to understand whether these issues are a significant part of your databases performance or not.
Please
This adds the time in fractions...
## uniquefile.bat##
@echo off
for /f tokens=2,3,4 delims=/ %%a in ('date /t') do set pre=%%a%%b%%c_
FOR /F TOKENS=5-8 DELIMS=:. %%F IN ('ECHO.^|TIME') DO (
SET Hour=%%F
SET Mins=%%G
SET Secs=%%H
SET Mill=%%I)
set
I am running Oracle 9i R2 and want my RMAN files gzipped to save disk space.
Is is possible to either use this new DBMS_PIPE oracle has or just creates a script that uses a namped piped and compresses as rman is performing a backup?
If someone has done this before, can you let me know how ?
My
Title: Message
An brief overview
of Googles architecture
http://www.computer.org/micro/mi2003/m2022.pdf
Google does use Oracle,
but afaik only in-house for internal applications. The clustered search
engine is entirely custom code and engine. 10,000 servers would be a
pretty
Hi Steve and welcome back,
Thanks for that detailed answer BUT... A practical question from the
original post remains: What happens when these x$constructs begin to
consume large amounts of memory? From your explanation I'm assuming
that, beyond monitoring the SGA and PGA, memory consumption of
Hi,
A co-worker of mine is working on a tiny project.
Let say you have commission info and commission details, there are 7 types
of commissions.
The 7 types of commission shares common fields (from 100% to 30%)
From a conceptual point of view, you have 1 entity that is the commission
info and 7
Title: Message
Can
you figure out what to name the pipe in advance? Is there a way to reliably
determine what file name RMAN will create?
-Original Message-From: laura pena
[mailto:[EMAIL PROTECTED] Sent: Tuesday, September 30,
2003 8:45 AMTo: Multiple recipients of list
Title: RE: RE: Using dimensions
I am out sick today ... glad you found the acronyms ... the F is left to your own imagination.
Raj
-Original Message-
From: Prem Khanna J [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 30, 2003 5:45 AM
To: Multiple recipients of list ORACLE-L
I can use mknod and create a named pipe a head of time.
I do this when I use the exp or imp utilites (just wondering if I can do same with RMAN):
==
export EXP_DIR="/oracle/export"export PIPE_DIR="/oracle/export"export
Hello everyone,
I've come across an IBM whitepaper: improving database performance with aix
concurrent io. IBM have tested this with Oracle 9i R2 and claim performance
comparable to using raw-volumes.
Has anyone in the fatcity community ever tried this?
Does Oracle do an open of the database
Loney didn't write OFA, and methinks he was taking liberties with it.
--- Jacques Kilchoer [EMAIL PROTECTED] wrote:
Not commenting on the accuracy of the information, but Kevin Loney,
in the Oracle8 DBA Handbook (1998), says the following (Chapter 3
Logical Database Layouts), in a section
SET ORACLE-L
DIGEST
Unfortunately, we are always adding a new database.
The new SAN commission in June-July was supposed to hold 6 databases.
Then it became 7 databases in August. Now it is 8 this month and the
count will go up to 9 databases by December.
As the SAN Storage Admin and Unix SA roles are handled by two
Run the following sql statement to see whether there are duplicate
entries. Chances are that you will find duplicates hence you get the
above error. You may choose to remove the duplicates or create a
non-unique index otherwise.
select COMPANY, INVC_PREFIX, INVC_NUMBER,
(Reposting from yesterday morning since I had no takers! :)
Hello,
I wanted to give another user access to view my procedures packages (just
DESC capability), but it seems that the only way for him to be able to DESC
them is for me to grant execute. Is this correct?? (I guess I have never
I'd be very interested to know how many people have their index tablespaces on a
different backup schedule from their data tablespaces. If so how different? What
happens when a media failure occurs and you must restore from backup? You would need
to have on hand and apply more redo logs to
Hi Craig,
yes that is the one.
cheers
Pete
In article [EMAIL PROTECTED], Craig Munday
[EMAIL PROTECTED] writes
Pete,
Which paper of Aarons are you referring to? Is the paper entitled
Encryption of data at rest?
Regards,
Craig Munday.
At 05:29 AM 29/09/2003 -0800, you wrote:
Hi Jp
On the
I dont
think you can compress rman files while backups are running. RMAN doesnt support
external compression while backups are running 'cause RMAN has to validate
backups. You can compress all the files once your backup is completed. I tried
that in the past but didnt work. Infect thereare
the defrag paper was written back in 1998 I believe. Uniform extents were a good
solution pre-9i. We use them here on our 8i databases. I stick with an uniform 5m
extent size even though I have tables that can fit into 128k extents, but feel that
the overall time savings by using 1 extent size
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2003 12:50 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: RE: Separate Indexes and Data
the defrag paper was written back in 1998 I believe. Uniform
extents were a good
I didnt write this code and am not particularly familiar with this part of Oracle. We
are attempting to migrate some CLOB data. To do this we batch load it into DOM
objects, then user XMLPARSER to parse it, then do an insert.
We are finding that it sucks up so many resources that you cant even
From: Jesse, Rich [EMAIL PROTECTED]
Date: 2003/09/30 Tue PM 02:09:32 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: RE: Separate Indexes and Data
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30,
Nuh uh, not me... I have never used or experimented with auto-allocate.
I separate indexes and tables so that I can reclaim space by rebuilding
the indexes into smaller space.
I've just completed writing the scripts for the following:
we have a data warehouse, partitioned on the biggest table
Hi,
Is there a tool available to move data from COBOL to ORACLE directly? One way to do
is get COBOL data on a flat file and then use SQL*Loader to insert into ORACLE tables.
The second question is did anyone use DESIGNER to connect to COBOL to create an ERD
and then transform into ORACLE
there is nothing in the alert log,udump, or cdump on this. Im going to have them run
the package with a 10046 trace next. would a different trace be more appropriate?
From: [EMAIL PROTECTED]
Date: 2003/09/30 Tue PM 02:24:30 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
I don't generally get too involved in the x$ stuff, just because it
normally helps me very little in my DBA work.
Nonetheless, I have been following this one somewhat, and if my
understanding is correct, x$ tables are not actually responsible
for consuming memory, they are merely a mechanism for
Er ... No.
COBOL is a programming language. Oracle is a relational database manager.
The data used in a COBOL program can be stored in a variety of ways. It's
even possilbe to have a COBOL program using data from an Oracle database.
I'm not aware that Designer can translate COBOL file
You can also Execute SQL directly from Oracle using the precompilers - No
need to export the data and use SQL Loader.
Thank You
Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (313) 227-4350
Mobile: (248) 408-2918
Email: [EMAIL PROTECTED]
Web:www.compuware.com
Stephane,
From the limited information available, I will take a stab at what seems to
be going on here.
I don't think there are really 8 entities here first of all, at least not for the
details given. No mention is made of the person being paid the commission,
who the sale was too, the items
This link to AskTom may help.
http://tinyurl.com/p7o1
-Original Message-
Sent: Tuesday, September 30, 2003 12:29 PM
To: Multiple recipients of list ORACLE-L
(Reposting from yesterday morning since I had no takers! :)
Hello,
I wanted to give another user access to view my procedures
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2003 1:29 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: RE: Separate Indexes and Data
From: Jesse, Rich [EMAIL PROTECTED]
Date: 2003/09/30 Tue PM 02:09:32 EDT
Yes, that's correct.
Since the only privilege available on a code object is execute, it
doesn't make much sense to allow a user to DESCRIBE the call interface
if the user cannot run it.
--- Gary Jackson [EMAIL PROTECTED] wrote:
(Reposting from yesterday morning since I had no takers! :)
Hi!
In VLDB environments, it is mostly cheaper to restore and recover the index
tablespace datafile in case of block corruption. In my experience, I've been
lucky and have been able to get rid of corruptions that way, but I'm sure
some people have worse experiences, especially when redologs are
Like Thomas Day said, Oracle is an rdbms and COBOL a programming language.
You can use Sql*Loader to load flat files into Oracle or
use COBOL programs with embedded SQL, you'll need to use Oracle Pro*Cobol to
precompile the COBOL source before compiling them.
The last time I've used Designer it
All,
I'm being given a requirement to store a BLOB column in the database. I'm
being told that the average size of the file (it's a PDF) is 12,000 K. I'm
assuming that I should store this column in a separate tablespace from the
table data. If I use an LMT tablespace, what should I use for the
Hi
Jared,
Here
are more details.
One
commission detail must be one of the types:
manager override (12
fields)
first year commission (15 fields),
renewal service fee (10 fields),
charge back (9 fields),
vesting payment (1 field),
subsidy (2 fields),
supplementary commission
-Original Message-
Paul Baumgartel
Loney didn't write OFA, and methinks he was taking liberties with it.
Perhaps. However I notice that DBCA in Oracle 9.2 creates a tablespace called INDX.
http://download-west.oracle.com/docs/html/A97297_01/appg_ofa.htm#sthref807
Oracle9i
At our university, we are planning to use 9iasR2 in production in a near
future. What type of server do you people use for it? Does it need a lot
of memory, more than 1 cpu ?
It will mostly be used with modplsql procedure and we hope to deploy
Discoverer.
We are thinking about a X series
I also don't recall it being mentioned. Think
naming,cman,mts,dispatchers etc.
Niall
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of DENNIS WILLIAMS
Sent: 29 September 2003 22:35
To: Multiple recipients of list ORACLE-L
Subject: 8i OCP Net8 Exam
Title: Message
Hi,
We're
still on 817 but I was wandering about those new automatic features (Automatic
Undo Management, Automatic Segment Space management,..) how well they work
?
Anybody using in production with 9i2
?
Stéphane
-Original Message-From:
[EMAIL PROTECTED]
My criticism of the defrag paper was that it did not address what to do when a segment
grew large enough to belong in a tablespace with a larger uniform extent size.
Moving the segment creates holes in its original tablespace which may close only in
the fullness of time. Physical backups of
I always get a difference , the first one gives a value greater
than the
second by 12MB
I tried with different values of shared_pool_size .
What am I doing wrong here ?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, September 30, 2003
Hi!
On which version you are?
I would create fairly large extents, 64MB for example. LOBs are stored in
chunks anyway, extent size doesn't matter that much. One issue is, if you
create very large extent size, you might waste some space in LOB index which
is a separate, smaller segment (but is
Please , do tell
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, September 30, 2003 02:34
Yes.
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of [EMAIL
Unfortunately, you have to rewrite it to LISP or Oberon first.
On Tue, 2003-09-30 at 15:14, Muqthar Ahmed wrote:
Hi,
Is there a tool available to move data from COBOL to ORACLE directly? One way to do
is get COBOL data on a flat file and then use SQL*Loader to insert into ORACLE
tables.
Title: Message
Not in
production, but close to (as in two weeks). They seem to work just
fine.
Dick GouletSenior Oracle DBAOracle Certified 8i
DBA
-Original Message-From: Stephane Paquette
[mailto:[EMAIL PROTECTED]Sent: Tuesday, September
30, 2003 4:44 PMTo: Multiple
On Tue, 2003-09-30 at 16:19, Stephane Paquette wrote:
Like Thomas Day said, Oracle is an rdbms and COBOL a programming language.
COBOL *** WAS *** a programming language. Horse *** WAS *** basis of
transport. You should have used past tense, Stephane. I'm not really
that partial when it comes
You should go to OTN and not use the local copy. For some
reason, the 9.2 manual (Reference) left v$sort_usage out. On OTN
you have 8.1.7 docs available as well, and it is the same thing.
On Tue, 2003-09-30 at 16:49, [EMAIL PROTECTED] wrote:
Please , do tell
- Original Message -
To:
Here is a very interesting article on IDE's vs. code editors.
http://www.infoworld.com/article/03/09/19/37FEcodeedit_1.html
and the first thing that I do is to delete the INDX tablespace!!! As well
as dropping the ORD* users, SCOTT, Tim, Tammy-Fae, Jim Bob and all the other
crappy stuff that auytomatically gets installed.
I try and get it back to the original 8.0 install!!!
Tom Mercadante
Oracle Certified
Good question Ian. If anyone does have a different backup schedule for index tbs , I
would be interested to know how they ensure that the index TBS do not have any
data segments in them.
Jared
MacGregor, Ian A. [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
09/30/2003 10:34 AM
Please
So, you're not allowed to actually model this at all, but just
port over some VSAM structures and call it a database.
See the thread on COBOL.
Jared
Stephane Paquette [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
09/30/2003 01:24 PM
Please respond to ORACLE-L
To:Multiple
Thanks everyone for your input on this topic. Now if I can just get
motivated. ;-)
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, September 30, 2003 3:40 PM
To: Multiple recipients of list ORACLE-L
I also don't recall it
Tom
In this case, I would use a uniform extent size -- you know approximately
how large the data is today. Since there is no measureable overhead for
having multiple segments, I would go with something much smaller than a 12MB
extent size -- 512K to 1MB, depending on what your OS read size is.
Friends --
I find it weird that I've been consulting some 25 years and have never run
into this situation, and really could use your two cents. Here's the deal.
I am supposed to travel for a client. They have me on a plane Sunday,
expect me to work M-F onsite *and possibly the weekend*,
I have developers that would like to use Oracle's
nested tables capability. I have not dealt with this before, so I was
wondering if I could get information from those that are using them.
How stable are nested tables? Are there issues I need
to worry about? I will be using this in an
-- snip
If you're feeling frisky, consider replacing the router/firewall with a PC
(with 2 nics) running BSD or Linux. You can also find distros tweaked to
act as a firewall/router - that's what I've done.
-- snip
The Linux distro I used was www.smoothwall.com (which
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 country would be in a right bloody mess.
Rich Jesse,
People's Front of Judea
-Original Message-
From: Mladen
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 just skim through the material in the whatever book
you use (probably only possible if you have some miles on the clock as a DBA) and
Mladen:
I am not sure where I am failing to understand you ;). First of all X$
objects are NOT
tables, so there is no question of blocks or memory or dictionary cache.
They are some
C structures and their point in time (I am not finding a better word) values
are exposed
as table formats. That is
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 is configured correctly.
Also want to check out the URL http://grc.com/lt/scoreboard.htm about various PC
firewall products leaking
Mladen, maybe it is the past for you but it is quite the present for me.
We just decided between 2 packages (insurance industry): one in cobol using
flat files on AS400 and the other one where all jobs are in cobol but the
database is Oracle.
We have choose the second one. So, in the next week,
If you have to travel at the client's request / requirement, then you should be able
to bill for your travel time, beginning with the time you arrive at the airport and
ending with the arrival time. Any weekend work for the client should be billed for
the time onsite. (You may want to consider
Title: RE: COBOL TO ORACLE
COBOL still lives and breathes, though, in many MANY shops (this one included). Just like the Mainframe, it won't go away easily or soon...
I feel your pain, though, I lived through it too... and if I never have to figure out where an alter sends the program based
Hi Steve,
The X$ interfaces do not use memory persistently, and the memory usage of
the X$ tables is fixed and necessary to an instance. Thus memory growth is
not possible.
Memory growth is possible for the segmented arrays, which some of the X$
interfaces expose. However, it is very unusual,
Hi!
Yep, I also think that x$ tables have nothing to do with row cache, instead
their behaviour is hardcoded to Oracle executable.
I did a simple test just in case (but I'm not sure whether it was
sufficient), by parsing a select from x$kturd 10 times didn't see any
big increases in
Title: probe database using OEM event or job
Can someone help me with this?
Running Oracle 9.2.0.3 under win2000
I have an application server that occasionally looses connectivity with the listener on the database server although other application servers have no problems connecting.
I
But those holes of exactly the right size for new objects to fit into.
Since you'll presumably move it once it gets about 1,000 extents or so that
isn't a huge amount of space that's being wasted.
Jay Miller
Sr. Oracle DBA
-Original Message-
Sent: Tuesday, September 30, 2003 4:45 PM
In States things are probably different, but in few European companies I've
worked for, it's that you get paid for the hours you work (naturally), if
you work on the weekends you get paid as well - if don't then you don't. If
you arrive one day earlier for being able to start in the morning next
Bellow, Bambi wrote:
Friends --
I find it weird that I've been consulting some 25 years and have never run
into this situation, and really could use your two cents. Here's the deal.
I am supposed to travel for a client. They have me on a plane Sunday,
expect me to work M-F onsite *and
Title: probe database using OEM event or job
On unix you could do:
while true; do tnspingALIAS out || mail
[EMAIL PROTECTED] out; sleep
300; done;
(obviously you have to replace ALIAS and e-mail
address there)
It will send you the tnsping output ifit
happens to fail. (you'll get a
Is there a tool available to move data from COBOL to ORACLE directly? One way to do is get COBOL data on a flat file and then use SQL*Loader to insert into ORACLE tables.
If you are using SQL*Loader make sure to check the log after load. For larger loadsi would suggest
direct load.
The second
Are you using any trunc functions while querying.
Do this. SELECT column_name,count(*) from small_table group by column_name;
Run this for all the tables. My guess is that atleast 30% of the rows in the
small table is for the value that you gave. So the optimizer is forced to read
the index
You can always schedule a script which drops all
table segments from index tablespaces ;)
Tanel.
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, October 01, 2003 12:44
AM
Subject: RE: Separate Indexes and
Ive read the book. PCTINCREASE is basically set to 100% so
the extent sizes double. Thats 'basically' how it works. I
have seen some posts on dejanews saying it doesnt necessarily
work this way and some people are finding large extent sizes
with just a few extents and when tables are
Tanel,
I've implemented it as a JDBC driver that is installed as a layer between
your application and the vendor driver that you are using (eg. Oracle,
Postgress, SQL Server, etc.)
[Java application] - Layer 1
[JDBC Expert] - Layer 2
[Oracle Thin Driver] - Layer 3
|
network
|
[Oracle
Hi,
Can you just use the built in OEM event Database UpDown - though perhaps this only
comes with the Diagnostics Pack for OEM.
As for a user defined test - You could just do something like select user from dual
and hope it comes back if it can't connect - I haven't tried this.
However, I think
Take
Pepcid AC ... that might help in digestion..
Seriously your email should go to listguru @
fatcity.com
-Original Message-From: Frits Hoogland
[mailto:[EMAIL PROTECTED]Sent: Tuesday, September 30,
2003 12:10 PMTo: Multiple recipients of list
ORACLE-LSubject:
SET
Thanks for the answer.
Yep, it seems more like JDBC proxy with analyzing capabilities than a
regular traffic analyzer which sits aside sniffs some packets.
May I ask, how much time have you spent on writing such thing?
I'm planning to write something similar, but on SQL*Net level...
Tanel.
Title: Using dimensions
Got a
link for this requirement in the manual?
Raj
-Original Message-From: Tanel Poder
[mailto:[EMAIL PROTECTED]Sent: Tuesday, September 30, 2003
4:50 AMTo: Multiple recipients of list ORACLE-LSubject:
Re: Using dimensions
Query rewriting to use
This was the closest i could get.
set pagesize 60;set linesize 180;column position noprint;column sequence noprint;break on object_type skip 1;break on package_name skip 1;break on object_name skip 1;column object_type format A15 wrap;column package_name format A30 wrap;column object_name
1 - 100 of 113 matches
Mail list logo