On 2004.01.19 23:39, Jonathan Gennick wrote:
I used to use a SQL Module compiler. Not with Oracle though.
It's rare for me to run into someone else who likes that
approach. Actually, it's rare for me to encounter someone
who's even heard of it...
Jonathan, I've been around for a long time.
[EMAIL PROTECTED] wrote:
Firstly, apology if this question sounds silly.
I am intrested in setting up a RAC configuration at my home with
a few desktop PC's. I would run either Win2K or Redhat Linux for the
same. I am not sure whether I would be able to setup the RAC using a few
desktop
I added the parameter to registry OSAUTH_PREFIX_DOMAIN=true
but it didn't help.
Any other place where i can see..?
Thanks and Regards
B S Pradhan
---
On Mon, 19 Jan 2004 Jared Still wrote :
You must set OSAUTH_PREFIX_DOMAIN=true in the registry to
use externally identified domain
Cary,
Good answer. The problem is most people concentrate on bytes because it's
relatively easy and everyone understands it. IOs per sec is much harder to
calculate for a new system and hence it's not normally done.
Cheers,
Chris Dunscombe
Quoting Cary Millsap [EMAIL PROTECTED]:
I don't
- Original Message -
Jonathan, I've been around for a long time. I've seen things like
DataLens for Lotus123, SQL*Calc, Easy*SQL, then there was an Oracle
Beat ya: Oracle Add-In for Lotus 123.
Using Ora*Net (Async), V4.1.4.
1987. And demoed to the press that same year.
g,dr
Write in C ("Let
it Be")
When I find my code in tons of
trouble,
Friends and colleagues come to
me,
Speaking words of
wisdom:
"Write in
C."
As the deadline fast
approaches,
And bugs are all that I can
see,
Somewhere, someone
whispers:
"Write in
C."
Write in C, Write in
C,
Write in
If you want to work out how much difference there
is in different code paths, then you have to do some
very patient testing.
Run your test program for lots of different array sizes,
say 1, 2, 3, and so on up to 100M.
On each run, disconnect and reconnect your session,
and check
Hi
The bad news is that I don't believe that calculating IO/Sec *can* be done
for a *new* system. At least I'd like to see how it is done. I'm willing to
bet that any formula for doing it will include (x%) for 'overhead', which
actually means 'stuff I don't know about'. Of course if the *new*
Or use Data|Import Data|New Database Query to import via ODBC. This is
especially useful for Pivot Tables etc since the dataset (but not the
display set) can be larger than the number of rows in an Excel sheet.
Niall
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL
Hi All,
I asked this question before, but that was during Xmas holidays, and I got
not much response:
Has anyone experience in using IBM's WorkLoad Manager on RS/6000 with AIX
5.x? I'm especially interested in the use for managing several Oracle
instances on one server, including sharing
Oh, but it is done, you only need to ask. EMC routinely measures how many I/Os
per second can they perform and they even have tools to measure it. Speaking of
monitoring I/O, there used to be an old OS, which is mostly dead today and it used
to have command monitor io/item=queue which would show
Someone is messing with standard package ... so it would seem.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an
if Oracle is offshoring its develeoping of its database, everyone else will also... so
much for job security.
anyone I heard postgre sql has multi-versioning? Is it implemented like Oracle?
So UDB is the new DB2? Oracle claims that DB2 is not one database but a different
database for
Mudhalvan,
I generate files that excel can open all the time. they are not actual
real excel files, but Excel can deal with them quite easily.
Here is a tablespace report I run every week. Note the use of the CHR(9)'s.
This is a TAB character. This forces each column into a new cell in the
Mladen Gogala scribbled on the wall in glitter crayon:
On 2004.01.19 23:39, Jonathan Gennick wrote:
I used to use a SQL Module compiler. Not with Oracle though.
It's rare for me to run into someone else who likes that
approach. Actually, it's rare for me to encounter someone
who's even
Title: RE: MS Access
ACCESS-L. For subscription/signoff info and archives, see
http://peach.ease.lsoft.com/archives/access-l.html .
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: viraj2 [SMTP:[EMAIL PROTECTED]
Ahhh.
Sql*Calc, Sql*Graph, Sqr EasySqr. Those were the good old days.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Tuesday, January 20, 2004 8:05 AM
To: Multiple recipients of list ORACLE-L
Mladen Gogala scribbled on the wall in glitter crayon:
On
I'm going down that path right now. I'll keep you all posted.
hardware: 2.0G, 1G of ram, 40G internal, 2 of those. external 120G
firewire HD.
waiting on the HD to continue, relatively new hardware so had to ditch
the whole RHAS 2.1 and aint willing to pay RH for AS3.
joe
Marcin
@?/rdbms/admin/utlirp
On 01/19/2004 05:00:37 PM, Hamid Alavi wrote:
All,
I have an strange problem, most of the packages under SYS user are
invalid
when I compile it it's compile without error but when I back again
the
package still is invalid, anybody have any idea?
Thanks in advance
Hamid
Well, PostGreSql has all of those features, but handling 100GB? Not sure not sure
I'd trust it that far.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Wednesday, January 14, 2004 2:10 PM
To: Multiple recipients of list ORACLE-L
I think he is talking
Oradebug is the right way to go because, for some reason,
alter system set events='904 trace name errorstack forever, level 10';
doesn't do anything. The only way to activate trace is to go to
oradebug,
attach the session (of course, one needs to do gymnastics with V$SESSION
and V$PROCESS to find
Prem, congrats good luck!
On 01/20/2004 12:54:27 AM, Prem Khanna J wrote:
When I was doing my OCP exams, I didn't have Dennis to cheer
me up, only Heineken.Not that I'm complaining.
but Mladen , i can't stop with just one : ))
so i better stay away from it during exams.
Regards,
Prem.
--
AMEN!!
Dick GouletSenior Oracle DBAOracle Certified 8i
DBA
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Monday, January 19, 2004 8:42
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Oracle vs MysqlIf MySQL
comes to have the same
Is queue message an idle or an non-idle wait event? I have looked through
the docs at tahti and metalink and can't find much info on AQ. Does anybody
know where there are resources on this topic?
thanks,
David Ehresmann
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Then here's a rare treat for you! I *loved* SQL mods in RDB. I could make
a program in MACRO, BASIC, FORTRAN, BLISS, Ada, DIBOL, or Mladen's favorite
COBOL, and could effortlessly have them do DB work. I also didn't have to
hunt thru all the source for a single SQL statement since they were in
Do you remember IBM System 3/10? RPGII flat files? 120 col. punch cards?
No hard drives?
My $0.02 worth,
Ken Janusz, CPIM
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, January 20, 2004 8:39 AM
Careful Mladen, your revealing your
The RPT RPF Oracle class was what made me go looking very quickly for a
batch Oracle tool. Then I found SQR. (This was all before PL/SQL and the
current versions of Oracle Reports). We bought it and the rest was history.
Why Oracle didn't buy SQR when they had a chance amazes me.
Tom
Title: Message
Most
people only use a fraction of Oracle's featuresand some are deceived
bythe Oracle Marketeerswho tell themthatthey NEED them
all. Maybe the 80/20 rule also applies to technology purchases... Especially
when the cost differential is huge.
My 4X4
pickup works just fine
help
Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail!
http://login.mail.lycos.com/r/referral?aid=27005
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Bill Gentry
INET: [EMAIL
It is defined as below in the Reference Guide:
The session is waiting on an empty OLTP queue (Advanced Queuing) for a message to
arrive so that
the session can dequeue that message.
I would treat it as an Idle Wait, similar to, SQL*Net message from client.
- Kirti
--- Ehresmann, David
I've got my GX21-9129-9 right here in front of me. It should be in a
museum...
I'll take Obscure Geek References for $800, Alex.
Rich
Rich JesseSystem/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
I do indeed. Rumor was that rpt/rpf was written by Larry himself.
On 01/20/2004 09:39:34 AM, Goulet, Dick wrote:
Careful Mladen, your revealing your age!! Bet you remember RPT
RPF
as well!!
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Tuesday,
On 01/20/2004 08:04:33 AM, Thater, William wrote:
Mladen Gogala scribbled on the wall in glitter crayon:
oh damn, have we been at this too long?;-)
Yes, we probably have. I must say that the spirit of Oracle Corp.
has changed significantly since the days of Geoff Squire, Chris Ellis,
Richard
Probably because they were dropping RPT RPF SQR smells a lot like it, YUCK!
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Tuesday, January 20, 2004 10:09 AM
To: Multiple recipients of list ORACLE-L
The RPT RPF Oracle class was what made me go
[snip]
120 col. punch cards?
You had a high-density model. Mine only had 80 cols, of which 72 were usable for my
goto-happy Fortran statements.
SF
No hard drives?
My $0.02 worth,
Ken Janusz, CPIM
- Original Message -
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Mladen,
Well, I'll agree with you over 90% of your post. Oracle is extremely feature
rich, to my vast enjoyment. BTW: We use pl/sql objects and Java stuff in production,
mostly Oracle's pre-canned Java, but we do have a production application with it's own
Java function too. As for
Hello,
I'm trying to add description in my $ORACLE_HOME/network/admin/tnsnames.ora,
but it seems that the client (ie. sqlplus) wont use it. Whenever I try to
connect to the service using sqlplus, I got :
$ sqlplus
Enter user-name: [EMAIL PROTECTED]
Enter password: *
ORA-12154: TNS:could
Careful Mladen, your revealing your age!! Bet you remember RPT RPF as well!!
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Tuesday, January 20, 2004 2:04 AM
To: Multiple recipients of list ORACLE-L
On 2004.01.19 23:39, Jonathan Gennick wrote:
I
On 01/20/2004 10:09:34 AM, KENNETH JANUSZ wrote:
Do you remember IBM System 3/10? RPGII flat files? 120 col. punch
cards?
No hard drives?
My $0.02 worth,
Ken Janusz, CPIM
I've never done anything with System/3. My first IBM was 3084
with MVS and IMS, running on 8M RAM. After an upgrade, it was
a
Tuesday, January 20, 2004, 9:19:44 AM, Goulet, Dick ([EMAIL PROTECTED]) wrote:
GD Well, PostGreSql has all of those features, but handling 100GB? Not sure not
sure I'd trust
GD it that far.
You know, I talked to someone at last year's MySQL
conference who was using MySQL to manage three
Hello,
On Tuesday 20 January 2004 11:01 am, Mercadante, Thomas F wrote:
Reuben,
If the normal connection is throwing an error, then it stands to reason
that the seond one would not connect either. You need to get a connection
working first before you try something else.
I can confirm that
Abandon hope, all ye who enter here
(Dante Alighieri)
On 01/20/2004 10:24:27 AM, Bill Gentry wrote:
help
Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos
Mail!
http://login.mail.lycos.com/r/referral?aid=27005
--
RPT was great stuff. In addition to SELECT statements it could do full
DML, DDL, and DCL (I think.) Like Unix it was just particular on who it
was friendly with. :-) Then there was RPT2C. Now there's perl.
Eschewing the pointy-clicky stuff.
-Original Message-
Sent: Tuesday, January
Tuesday, January 20, 2004, 9:34:25 AM, Jesse, Rich ([EMAIL PROTECTED]) wrote:
JR Then here's a rare treat for you! I *loved* SQL mods in RDB. I could make
JR a program in MACRO, BASIC, FORTRAN, BLISS, Ada, DIBOL, or Mladen's favorite
JR COBOL, and could effortlessly have them do DB work.
Yep!
Reuben,
If the normal connection is throwing an error, then it stands to reason that
the seond one would not connect either. You need to get a connection
working first before you try something else.
The Oracle error you are getting is complaining about the service_name
entry. Is this the same
Are you using Oracle Services? I've seen this happen before and we
change SERVICE_NAME to SID and everything works fine.
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
Life is like a sewer, what you get out of it depends on what you put
into it. - Tom Lehrer.
-Original Message-
Reuben
All this talk about SQL Modules has got me to wondering.
Does Oracle provide a SQL Module compiler at all? I seem to
recall seeing mention of one for use with Ada. Does such a
think exist for Oracle?
Best regards,
Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com *
On 01/20/2004 09:19:44 AM, Goulet, Dick wrote:
Well, PostGreSql has all of those features, but handling 100GB? Not
sure not sure I'd trust it that far.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
Given the price, I believe that some testing would be warranted, don't
you think?
--
However...
do not blindly treat SQL*Net messages as Idle waits. They can be
important indicators of networking issues.
Stephen
[EMAIL PROTECTED] 01/20/04 08:24AM
It is defined as below in the Reference Guide:
The session is waiting on an empty OLTP queue (Advanced Queuing) for a
message
If you have a line like this on your sqlnet.ora
names.default_domain = world
Then try putting an entry like this in tnsnames.ora
dbname.world=(etc. etc.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City
Inprocess actually.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Tuesday, January 20, 2004 10:54 AM
To: Multiple recipients of list ORACLE-L
On 01/20/2004 09:19:44 AM, Goulet, Dick wrote:
Well, PostGreSql has all of those features, but handling 100GB?
YES!
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Tuesday, January 20, 2004 10:10 AM
To: Multiple recipients of list ORACLE-L
Do you remember IBM System 3/10? RPGII flat files? 120 col. punch cards?
No hard drives?
My $0.02 worth,
Ken Janusz, CPIM
There's a new-ish RAC/Linux install guide on OTN:
http://otn.oracle.com/tech/linux/pdf/RAC_1030.pdf Interestingly enough the
guide specifically shows *not* to alias localhost at all (page 9).
Hmmm...
Rich
Rich JesseSystem/Database Administrator
[EMAIL PROTECTED]
On Tuesday 20 January 2004 11:20 am, Scott Canaan wrote:
Are you using Oracle Services? I've seen this happen before and we
change SERVICE_NAME to SID and everything works fine.
That does not work for me either.
RDB
-Original Message-
Reuben D. Budiardja
Sent: Tuesday, January 20,
I agree wholeheartedly. This is why I think that anyone who attempts to
size a system with formulas alone (that is, without testing) is almost
100% certain to either overspend miserably or downright fail.
There are two things that are really important about testing. One is
that it shows you how
so what's the solution?
-Original Message-
Sent: Tuesday, January 20, 2004 4:10 AM
To: Multiple recipients of list ORACLE-L
Someone is messing with standard package ... so it would seem.
Raj
Rajendra dot
On Wed, 14 Jan 2004, eric king wrote:
I think he is talking about 100GB database. Can PostgreSQL and MySQL handle
that size? We used MySQL in some of the web projects, but it just stores
small set of operational data and later on those data are moved to Oracle as
a permenant store. For small
Chris,
Thanks.
When people do what you say, it's kind of like what would have happened
if NASA had used the following assumption throughout the Apollo project:
Assume adequate quantities of breathable air...
It would have made the planning phase much simpler, but it would have
been a touch more
If you're keen on Perl, the Spreadsheet-WriteExcel module is very handy:
http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-0.42/
With that you could slurp data out via DBI, and then build a customized spreadsheet
based on the data.
But I'd agree with what others have said. Dumping to
Either that or someone ran dbmspool.sql out of ORACLE_HOME/rdbms/admin.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Tuesday, January 20, 2004 12:45 PM
To: Multiple recipients of list ORACLE-L
so what's the solution?
-Original Message-
Sent:
what is the listener status??
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
-Original
The old IBM System3 machines used 120 col. punch cards. And initially they
had no HD's. Everything was done with cards and a reader/sorter. To
compile a program you took the code you wrote, punched it into cards and
then put it behind a stack of cards that was the compiler. The machine read
Tuesday, January 20, 2004, 12:44:43 PM, Daniel Hanks ([EMAIL PROTECTED]) wrote:
DH nd to be fair, MySQL _does_ offer foreign key constraints (it used to not,
though), but only
DH (iirc) if you use the 'Innodb' table type.
My experience recently was just the opposite. I could create
foreign key
Back to MySQL and whether Postgres is the way to go,
I can recall editorials debating whether Unix/Oracle would ever be
industrial strength enough to support critical applications.
The point the book The Difference Between God and Larry Ellison tries to
make is that the technically superior
encoded content removed -- binaries not allowed by ListGuru
The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists. If you want a copy of the attachment which was
removed, contact the sender
I've never used it before, but there is a piece to Excel called Microsoft query
that allows you to query the database directly.
Check help in Excel, search for query - ways to retreive data from external
sources.
HTH,
Mike
Please, let's not turn this into a bulletin board.
Spontaneous humor in a conversation (thread) is one
thing, cutting and pasting completely non-relevant articles
is another.
For those of you that are non-native English speakers, the
one thing... another thing phrase means don't do this.
Jared
Huh???!?? What did you search for? I get many hits searching for
postgresql.
Rich
Rich JesseSystem/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
Sent: Tuesday, January 20, 2004 12:29 PM
To:
On 01/20/2004 01:29:25 PM, DENNIS WILLIAMS wrote:
Back to MySQL and whether Postgres is the way to go,
I can recall editorials debating whether Unix/Oracle would ever be
industrial strength enough to support critical applications.
The point the book The Difference Between God and Larry Ellison
I found myself working with some larger databases in the 500-800 GB range that also
spawn into multiple test databases.
I take a df -k or bdf and bring that into excel. Then I take a query on all
autoextend and break that out by disk.
then I put that all together and tell what's left on disks.
If you are interested in latest report of CSPP(Computer Systems Policy
Project)...
http://www.cspp.org/reports/ChooseToCompete.pdf
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
One of our production DBAs does not want to use pga_aggregate_target on a 9.2.0.3
instance due to a possible memory leak. The only note on memory leaks and
pga_aggregate_target I can find on metalink is: 334427.995
doesnt seem to apply to pga_aggregate_target. We are on sun solaris. Dont know
--- Niall Litchfield [EMAIL PROTECTED]
wrote:
Hi
The bad news is that I don't believe that
calculating IO/Sec *can* be done
for a *new* system. At least I'd like to see how it
is done. I'm willing to
bet that any formula for doing it will include (x%)
for 'overhead', which
actually means
I've inherited a system that has a whole lot of indexes set to degree 10 and many
tables set to 2 4.
The users are complaining that Precise is showing a whole lot of time in Parallel
Sync Wait.
It is an HP box running 8.1.7.4 with 16 processors. The box is normally not very busy.
Are there
Tuesday, January 20, 2004, 1:29:25 PM, DENNIS WILLIAMS ([EMAIL PROTECTED]) wrote:
DW I can recall editorials debating whether Unix/Oracle would ever be
DW industrial strength enough to support critical applications.
I admit to not being involved in databases that far back,
but I've read enough to
This may be more on that parallel being set too high, but looking for ways to improve
insert speed. I've seen the APPEND hint mentioned, but not sure if that speeds
things up or simply says Insert at the end.
Also, a co-worker found a PL/SQL on a degree=4 table that has a cursor, then one
I have used Microsoft Query in Excel. The syntax is a little tricky but
it works pretty good.
-Original Message-
Sent: Tuesday, January 20, 2004 12:50 PM
To: Multiple recipients of list ORACLE-L
I've never used it before, but there is a piece to Excel called
Microsoft query
that
I have set up a profile where the passwords expire in 30 days, 6 characters
minimum, grace period before the account locks to 6 days. It works as
expected when the user logs in to our web site and tries to change the
password. Users receive error messages whenever their password doesn't
Hi!
Note that when you set an event with alter system, it will only apply for
new sessions created, not for any existing ones.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, January 20, 2004 4:19 PM
Oradebug is the right way to
[EMAIL PROTECTED] wrote:
One of our production DBAs does not want to use pga_aggregate_target on a 9.2.0.3
instance due to a possible memory leak. The only note on memory leaks and
pga_aggregate_target I can find on metalink is: 334427.995
doesnt seem to apply to pga_aggregate_target. We
Hi.
I am looking at the bstat/estat report and see a high
number of enqueue timeouts in the statistics section
of the report. How do I tackle that? In the Niemec's
book he receoomends increasing the enqueue_resources
parameter. Metalink says that these may be related to
DISTRIBUTED_LOCK_TIMEOUT
On Tue, 20 Jan 2004, Mladen Gogala wrote:
I have a book devoted to PostgresSQL at home. When I come home, I'll
post the information.
O'Reilly has Practical Postgresql, the full text of which is also available online:
http://www.commandprompt.com/ppbook/
I know there are a couple of others
Hi!
I think what Kirti meant here, is that from only database's point of view
(scope), the SQL*Net message from client waits do not indicate any
database bottlenecks.
Anyway, when you have network bottleneck, from my experience you usually see
other SQL*Net message waits, like more data to/from
What RPT and RPF exactly are? Are they some sort of reporting tool?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, January 20, 2004 11:19 AM
RPT was great stuff. In addition to SELECT statements it could do full
DML, DDL, and DCL (I
On 01/20/2004 02:59:35 PM, Tanel Poder wrote:
Hi!
Note that when you set an event with alter system, it will only apply
for
new sessions created, not for any existing ones.
And that, exactly is the problem. First, when you set event using
alter system, the setting is system wide. Second, if you
On 01/20/2004 02:34:45 PM, Ana Choto wrote:
I have set up a profile where the passwords expire in 30 days, 6
characters
minimum, grace period before the account locks to 6 days. It works
as
expected when the user logs in to our web site and tries to change
the
password. Users receive
Hence why Sql*Server is out there.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Tuesday, January 20, 2004 1:29 PM
To: Multiple recipients of list ORACLE-L
Back to MySQL and whether Postgres is the way to go,
I can recall editorials debating whether
Gene,
This is the problem with high-level aggregate reports like
BSTAT/ESTAT and STATSPACK. A possible problem is
highlighted, but there is no detail on the possible cause.
One way to get more info is monitor V$SESSION_EVENT view
searching for sessions with lots of waits on enqueue
wait-event:
Jonathan,
The only reason MySql is known better is that big mouth equal to Bill Gates
in Finland. Otherwise PostGreSql is the much better product.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Tuesday, January 20, 2004 1:49 PM
To: Multiple
Yupp. RPF=report formatter or some such.
-Original Message-
eric king
Sent: Tuesday, January 20, 2004 1:19 PM
To: Multiple recipients of list ORACLE-L
What RPT and RPF exactly are? Are they some sort of reporting tool?
- Original Message -
To: Multiple recipients of list
Eric,
They were the precusors to Oracle reports. RPT was the report extraction
tool, and RPF was the report formatter.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Tuesday, January 20, 2004 3:19 PM
To: Multiple recipients of list ORACLE-L
You can also use DBMS_SYSTEM.SET_INT_PARAM_IN_SESSION and
DBMS_SYSTEM.SET_BOOL_PARAM_IN_SESSION, in lieu of oradebug.
-Mark
Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
Imagination was given to man to compensate him for what he is not, and
a sense of humor was provided to console him
Strange, no one has mentioned OWA_SYLK.
Do a search on SYLK at asktom.oracle.com
There are 2 versions, one for web output and one for excel output.
SYLK allows cell references, etc, if needed, which you won't get with CSV.
Jared
Mudhalvan, Moovarkku [EMAIL PROTECTED]
Sent by: [EMAIL
But, unless you have old diskettes... you'll never see them. They died with
the demise of v5.
-Original Message-
Sent: Tuesday, January 20, 2004 2:29 PM
To: Multiple recipients of list ORACLE-L
Yupp. RPF=report formatter or some such.
-Original Message-
eric king
Sent:
We're using pl/sql gateway and the Apache server. We've set up a default
DAD on the gateway configuration screen, the connect string is our server
name. Basic authentication, Package/Session Management Type:
Stateless(Reset Package State).
I've tried the profile by setting up a test user
But you can't set events with it :(
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, January 20, 2004 10:39 PM
You can also use DBMS_SYSTEM.SET_INT_PARAM_IN_SESSION and
DBMS_SYSTEM.SET_BOOL_PARAM_IN_SESSION, in lieu of oradebug.
On 01/20/2004 03:29:33 PM, Goulet, Dick wrote:
Jonathan,
The only reason MySql is known better is that big mouth
equal to Bill Gates in Finland. Otherwise PostGreSql is the much
better product.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
Dick, when you are talking about big
"SYLK allows cell references, etc, if needed, which you won't get
with CSV.
"
Ahh. but you can with my method! If you use
tab separated columns, you can also generate formula's that look like text, but
work just fine in the spreadsheet!
Tom Mercadante Oracle Certified Professional
I know I used to set up RPT and do all sorts of complex updating things. At the State
and with things coming from mainframes, the data organization seemed to lend itself
well to RPT.
Since the organization was like of loops within loops, I could take the high order
update and then loop through
If you are using Linux, you can use NBD's (network block devices) that will
allow you to use a third PC as a storage device. You can download the
drivers at http://nbd.sourceforge.net/
There's a pretty good paper out there as well, at
http://www.fi.muni.cz/~kripac/orac-nbd/ that will walk you
1 - 100 of 149 matches
Mail list logo