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 tnsnamesconnection information right into the select statement.
Can it be done?
Tom
Title: Message
We have a future
needto 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*Netdoes come with the
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 recipients
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.net
--
Author: Terrian, Tom (Contractor) (DAASC)
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
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 statisticssample 5
percent;
Takes over 2
hours:
execute
] [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
All, I would like to
track the performance of my production databases by runningthesame
SQL statementagainst 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 they
__
Rajendra
Jamadagni
MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN
dot com
Any opinion expressed here is
personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have facts,
but having an opinion is an
art!
-Original Message-From: Terrian, Tom (Contractor
(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-- Mailing list and web hosting services
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
ORACLE-LSubject: RE: Database tracking
I
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
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 backups yet. Anyway to recover from this or do
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
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)/100
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-LSubject
: 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 recipients of list ORACLE-L [EMAIL
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;
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
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 Lists
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 IN
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 previous job, we determined that
histograms where
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 Lists
(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) 538-5051
).
--
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 Lists
://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 REMOVE yourself from this mailing
PROTECTED]
937-656-3844
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 22, 2002 2:51 PM
To: Terrian, Tom
exec 21
**I think**
Scott Shafer
San Antonio, TX
210-581-6217
Common sense will not accomplish great things. Simply become insane and
desperate.
-Original
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 list
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 Lists
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-- Public
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 Lists
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-5051 FAX: (858
or 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 FAX
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 and then, but I
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-- Public
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: (858) 538-5051
://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 REMOVE yourself from
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 mailing list (E-mail
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, even
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, Tom
containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Terrian, Tom
INET: [EMAIL PROTECTED]
Fat City Network
') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Terrian, Tom
INET: [EMAIL
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, Tom
INET
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
transactions?
Specifically:
select
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 Lists
(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) 538-5051
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, California
). 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, California-- Public
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 Lists
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 Lists
49 matches
Mail list logo