Title: Message
Does anyone have an
example of connecting to a remote database without a database link? I
think that I have seen it done before by putting in the username and password
and tnsnames connection information right into the select statement.
Can it be done?
Tom
I don't know about
Pro*Cobol, I would assume so. Database links between MVS and HPUX work
as expected.
Allan
-Original Message-From: Terrian, Tom
(Contractor) (DAASC) [mailto:[EMAIL PROTECTED] Sent: Thursday,
July 10, 2003 11:00 AMTo: Multiple recipien
Title: Message
We have a future
need to create an Oracle database on a mainframe (MVS) which will then pull
data from an Oracle database on an HPUX box. I know nothing about MVS so
does anyone know of any connectivity problems between the two boxes? For
example, SQL*Net does come with the
lf from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message
BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you
want to be removed from). You may also send the HELP command for other
information
PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Terrian, Tom (Contractor)
(DAASC)Sent: Tuesday,
February 25, 2003 12:13 PMTo: Multiple recipients of list
ORACLE-LSubject:
DBMS_STATS
I have never had good luck with
DBMS_STATS. It seems that the old analyze runs much
faster
Title: Message
I have never had
good luck with DBMS_STATS. It seems that the old analyze runs much
faster.
Runs in 45
seconds:
analyze table
log_trans partition (log_trans_20030104) estimate statistics sample 5
percent;
Takes over 2
hours:
execute
dbms_stats.gather_table_stats(o
overhead than a user.
just
my 2 cents but, good luck!
Tom Mercadante Oracle Certified Professional
-----Original Message-From: Terrian, Tom (Contractor)
(DAASC) [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January
15, 2003 1:59 PMTo: Multiple recipients of list
ORAC
e HELP command for other
information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Terrian, Tom (Contractor) (DAASC)
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- M
----From: Terrian, Tom (Contractor)
(DAASC) [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January
15, 2003 12:54 PMTo: Multiple recipients of list
ORACLE-LSubject: Database tracking
All, I would
like to track the performance of my production databases by
running the same SQL s
Title: Message
All, I would like to
track the performance of my production databases by running the same
SQL statement against each database every 5 minutes or so and
recording the results. For example:
sql> set timing
on;
sql> select
count(*) from dba_tables;
That was I would
know if t
by "SYSTEM" or owned by "SYS", just
making sure?
Waleed
-Original Message-----From: Terrian, Tom (Contractor)
(DAASC) [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January
08, 2003 9:19 AMTo: Multiple recipients of list
ORACLE-LSubject: Tr
on Oracle's Data
Unloader. But if it's a new database, it's probably simpler to recreate.
--- "Terrian, Tom (Contractor) (DAASC)" <[EMAIL PROTECTED]> wrote:
> ummm...I just truncated all of the system tables in a new database
> (that's not good). No
Title: Message
ummm...I just
truncated all of the system tables in a new database (that's not good). No
backups yet. Anyway to recover from this or do I have to recreate the
database?
Thanks,
Tom
Terrian
Title: Message
I run the following
query to compare the total waits for a session verses the seconds logged
on:
select
a.sid, a.ontime longon_secs, round(b.waittime) wait_secsfrom
(select sid, (sysdate - logon_time)*24*60*60 ontime
from v$session ) a, (select sid, sum(time_waited)
-
Sent: Tuesday, August 20, 2002 12:44 PM
To: [EMAIL PROTECTED]
Cc: Terrian, Tom
Tom,
How do you plan to use this ratio?
Jared
"Terrian, Tom" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/20/2002 10:37 AM
Please respond to ORACLE-L
To: Multiple recipient
tiple recipients of list ORACLE-LSubject:
RE: Number of SQL stmts.
I
think it also counts the recursive SQL statements issued
-Original Message-From: Terrian, Tom
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 20, 2002 9:08
PMTo: Multiple recipients of list ORACLE-LSu
Title: Message
I have one main
schema (ldgadmin) in my database (9.0.1.3) that I want to FULLY
audit. I want to know everything about itinserts, grants, connects,
everything.
I have already run
the following commands:
sql> audit all by
ldgadmin;
sql> audit all
privileges by ldgadmin
T spelling of '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 O
Title: Message
How is everyone
identifying hot tables? In my tool box I have the following two scripts
but I am looking for other options. How do you track frequently accessed
tables?
Script #1 -
Author unknown:
select obj_name,
sum(decode(action_name,'SELECT',1,0)) sel
,sum(decode(ac
I know I have seen this posted before...
We have a large range partitioned table that has duplicates
in it. What is the fastest way to remove the dups.? I have the
following scripts which do it but may be fast or slow. What do you guys
use?
DELETE
FROM tablename
WHERE ROWID NOT
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: Terrian, Tom
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
recipients of list ORACLE-L
tom,
This is interesting. How did you determine max
distribution and uniform distribution? Did you use
standard deviation and variance?
regards,
jack silvey
--- "Terrian, Tom" <[EMAIL PROTECTED]> wrote:
> John,
>
> I know in a previou
AIL PROTECTED] (note EXACT spelling of '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-
ist, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of '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).
--
None of them worked.
Tom
Tom Terrian
Oracle DBA
WPAFB - DAASC
[EMAIL PROTECTED]
937-656-3844
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 22, 2002 2:51 PM
To: Terrian, Tom
exec 2>&1
**I think**
Scott Shafer
San Antonio, TX
210-581-6217
"Comm
ial ORACLE-L FAQ: http://www.orafaq.com
--
Author: Terrian, Tom
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REM
Mladen, keep your OT post off of this list please.
Apparently the list is already too big and you only want to read about oracle
and only oracle.
-Original Message-From: Gogala,
Mladen [mailto:[EMAIL PROTECTED]]Sent: Tuesday,
August 28, 2001 11:52 AMTo: Multiple recipients of lis
11.0
Tom
Tom Terrian
Oracle DBA
WPAFB - DAASC
[EMAIL PROTECTED]
937-656-3844
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Terrian, Tom
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
ou 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: Terrian, Tom
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, Califo
age
to: [EMAIL PROTECTED] (note EXACT spelling of '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 th
n I change "table
or view does not exist" to something else?
Tom Terrian
Oracle DBA
WPAFB - DAASC
[EMAIL PROTECTED]
937-656-3844
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Terrian, Tom
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-50
Thank you, I will check it out.
Tom Terrian
Oracle DBA
WPAFB - DAASC
[EMAIL PROTECTED]
937-656-3844
-Original Message-
Sent: Wednesday, August 29, 2001 4:06 PM
To: Multiple recipients of list ORACLE-L
"Terrian, Tom" wrote:
>
> I think that this subject comes up now
r the other (still given 10
characters of fixed data)?
Thanks,
Tom
Tom Terrian
Oracle DBA
WPAFB - DAASC
[EMAIL PROTECTED]
937-656-3844
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Terrian, Tom
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051
ry CDROM burner. I
> > > couldn't wait to use it. I burned several game CD's (Age of
> > > Empires, Return
> > > Fire II, Roller coaster Tycoon) and none of them worked. The
> > > games just hung
> > > when I ran them. Bummer. Is it not poss
> > Return Fire II, Roller coaster Tycoon) and none of them worked. The
> > games just hung
> > when I ran them. Bummer. Is it not possible to make copies of my CD's
> > or am I
> > doing something wrong?
> >
> > Tom
> >
> > Tom T
command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Terrian, Tom
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
ake copies of my CD's or am I
doing something wrong?
Tom
Tom Terrian
Oracle DBA
WPAFB - DAASC
[EMAIL PROTECTED]
937-656-3844
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Terrian, Tom
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX:
You definitely have some Florida blood in you! :-)
Thanks,
Tom
Tom Terrian
Oracle DBA
WPAFB - DAASC
[EMAIL PROTECTED]
937-656-3844
-Original Message-
Sent: Monday, August 20, 2001 10:44 AM
To: [EMAIL PROTECTED]; Terrian, Tom
I'm gonna split my vote, is that allowed,
Oracle8I Data Warehousing, - 2 votes
Gary Dodge and Tim Gorman
Tom Terrian
Oracle DBA
WPAFB - DAASC
[EMAIL PROTECTED]
937-656-3844
> -Original Message-
> From: Terrian, Tom
> Sent: Friday, August 17, 2001 2:17 PM
> To: ORACLE-L (E-mail); LazyDBA mai
--
Author: Terrian, Tom
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list
did you get the Sybase software? We are currently studying the OTG option so we
don't want to pay for anything yet. Any ideas?
Thanks,
Tom
Tom Terrian
Oracle DBA
WPAFB - DAASC
[EMAIL PROTECTED]
937-656-3844
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Terrian
After looking at the top waits in my databases, I see "PX Idle Wait" pop up a
lot. Does anyone know what this wait means?
Tom
Tom Terrian
Oracle DBA
WPAFB - DAASC
[EMAIL PROTECTED]
937-656-3844
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Terrian,
(note EXACT spelling of '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: htt
EMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for o
Thanks,
Tom Terrian
Oracle DBA
WPAFB - DAASC
[EMAIL PROTECTED]
937-656-3844
-Original Message-
Sent: Thursday, July 05, 2001 11:26 AM
To: Multiple recipients of list ORACLE-L
Terrian, Tom wrote:
>
> Does anyone know of a way to determine which RBS extents have active
> tr
PROTECTED] (note EXACT spelling of '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
ation (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Terrian, Tom
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-
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: Terrian, Tom
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Di
SUB 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: Terrian, Tom
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858)
q.com
--
Author: Rachel Carmichael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
------------
To REMOVE yourself from this mailin
hor: Hawkins Family
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
------------
To REMOVE yourself from this mailing list,
51 matches
Mail list logo
