') 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.net
--
Author: Aponte, Tony
INET
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.net
--
Author: Aponte, Tony
INET: [EMAIL PROTECTED]
Fat City Network Services
') 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.net
--
Author: Aponte, Tony
INET
Title: RE: Veritas and disks
This note may describe the behavior you are observing.
www.sun.com/blueprints/0400/ram-vxfs.pdf
HTH
Tony Aponte
-Original Message-
From: Freeman Robert - IL [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 25, 2003 3:34 PM
To: Multiple
e-From: Aponte, Tony
[mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 4:40
PMTo: [EMAIL PROTECTED]Cc:
[EMAIL PROTECTED]Subject: RE: SharePlex
info
Your bandwidth requirements will be the rate of
changes to the actual data. The traffic consists of the a
Title: Message
Your
bandwidth requirements will be the rate of changes to the actual data. The
traffic consists of the actual data and control information needed to reassemble
the transaction on the target. The source database's other redo payload
(i.e., index operations, rollback segment
Title: RE: Tracing a user session with multiple database connections
It may need some changes for the Alter Session syntax but the trigger should help you isolate the activity by these session.
HTH
Tony Aponte
CREATE OR REPLACE TRIGGER sys.trap_conversion_connect_trig
AFTER LOGON ON
Title: RE: Veritas Quick I/O for Oracle
Dennis,
The benefits of QIO are realized not only by Oracle but also by the storage administrators. Oracle improvements come from kernelized async I/O, elimination of UNIX double-buffering and single-writer file header locking in the O/S. Storage
: 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.net
--
Author: Aponte, Tony
INET: [EMAIL PROTECTED]
Fat City Network Services
Title: RE: a DIFFERENT sql question
SELECT DISTINCT
t1.category CAT
,t2.type TYP
,SUM(DISTINCT t1.amount1) OVER(PARTITION BY t1.category) Sum1
,SUM(t2.amount2) OVER(PARTITION BY t1.category, t2.type) Sum2
FROM
t1
,t2
WHERE
t1.mykey1 = t2.mykey1
/
CAT TYP SUM1 SUM2
AA x 8 27
AA
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.net
--
Author: Aponte, Tony
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538
Title: RE: Rolling up Sums
create table genledg (budget number(4),week number(2)) tablespace tools
insert into genledg values (100,1)
insert into genledg values (100,2)
insert into genledg values (100,3)
insert into genledg values (100,4)
commit
Select sum(budget) over (order
FAQ: http://www.orafaq.com
--
Author: Aponte, Tony
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE
Title: RE: using obfuscation
I was wondering if this was of any help.
Tony Aponte
-Original Message-
From: Aponte, Tony
Sent: Tuesday, September 17, 2002 7:04 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: RE: using obfuscation
I've been developing
Title: RE: urgent help: replication, shareplex
I suggest you take a peek at the waits for the Shareplex process on the source system. We found that the sp_ordr processes query the source tables via the rowid mined out of the redo stream. Sp_ocap also issues queries as well as perform DML on
Title: RE: Spool Oracle Tables into Excel Format
There were some posts recently suggesting the spooling of the columns using a comma as a separator. But check out this article in XML Journal (http://www.syntelinc.com/syntel/english/0072/SYNT_XMLjrnl.pdf). It shows how to build
Title: RE: using obfuscation
I've been developing a solution for a similar requirement. Although I reached a dead-end with this thread I think it solves your problem.
I'm picking it up from the point where the data in encrypted_data of sensitive_table needs encryption. I did that with an
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
Title: RE: Constraints problem
I
remember a Y2K testing parameter for setting the database date. It still
might work. Search for FIXED_DATE to see what NLS date format to
use.
HTH
Tony
Aponte
-Original Message-From: Karthikeyan S
[mailto:[EMAIL PROTECTED]]Sent: Wednesday,
Title: RE: Re:RE: Re[2]: controlling CPU usage through Oracle
Just some thoughts. Does your OS have any domain partitioning features that you can use to create separate servers? You could carve out a portion of the CPU resources into a small domain and dedicate it to your problem child. The
What
kind of SAN?
Tony
Aponte
-Original Message-From: Gulamabbas Sikiladha
[mailto:[EMAIL PROTECTED]]Sent:
Monday, August 26, 2002 3:08 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: DB Refreshes
Thanks for the response Dennis, I got a very good idea from your
Title: RE: Analyzing a Trigger for Performance
Hi Hannah,
Have you looked into the DBMS_PROFILER and DBMS_TRACE packages? They can be used to trace PL/SQL execution and performance.
Tony Aponte
Home Shopping Network, Inc.
-Original Message-
From: [EMAIL PROTECTED]
Title: RE: db locking quandry
We had a similar situation that ended up being a network setting issue. The server was showing blocking locks. It turned out to be that the client application was getting a network error. After the error it re-established the database connection and re-submitted
Here's
an answer I posted to a similar question a few weeks ago.
HTH
Tony
Aponte
I hope this is not to late for you. Anyway, this questions
comes up often. Below is the solution to pivot rows for up to 12 values of
field1. Just adjust to fit your range of values.
HTH Tony Aponte Home
I pivoted the result set on the
WO column. This example works for up to 12 distinct values for the CP
column. I don't know if you need to pivot it again to get back to the
original result set but at least it gives you the sort order you
described.
HTH
Tony Aponte
Home Shopping Network,
Title: RE: Delete performance
I would use your method to CTAS but combine it with partitioning in order to overcome the unavailability issue. The new table would be a single-partition (MAXVALUE) object that would enable the use of EXCHANGE feature. I posted a nugget a while back describing
Title: RE: Select Query - Help required
I posted an answer on a similar question about 2 weeks ago. The underlying concept is how to pivot a result set. I've attached the thread below.
HTH
Tony Aponte
Home Shopping Network
-Original Message-
From: Aponte, Tony
Sent: Tuesday
Title: RE: SQL Query
I hope this is not to late for you. Anyway, this questions comes up often. Below is the solution to pivot rows for up to 12 values of field1. Just adjust to fit your range of values.
HTH
Tony Aponte
Home Shopping Network, Inc.
create table tab1 (field1 number,field2
Title: RE: Where is Oracle 9.2 init.ora?
On my version of UNIX (Solaris) moving/removing a file that is in use only affects the directory entry and not the actual payload on disk. I suspect that the spfile was held open by your sqlplus program and it executed the I/O operation using the open
Engineering Melbourne, 3000,
VIC, Australia Only
Robinson Crusoe had all his work done by Friday
-Original Message-From: Aponte, Tony
[mailto:[EMAIL PROTECTED]]Sent: Monday, 24 June 2002 7:58
AMTo: [EMAIL PROTECTED]Cc:
[EMAIL PROTECTED]Subject: RE: Virtual drive
Title: RE: Virtual drive on Solaris
Here is the command sample:
mount -f tmpfs -o size=800m swap /ramdisk
We use it to run a small database totally in memory. We decided that staying within the Oracle product suite was better for us vs. using a real memory-only rdbms. The mounting of
Title: RE: SESSION_CACHED_CURSORS and shared_pool sizing.
I don't recall where I read this but I remember a few things about it. As you noted, the use of SESSION_CAHED_CURSORS has an impact on the UGA. If you are using MTS then that becomes part of the SGA in the shared pool (or large pool
I
would love to join a list were we can post all of the colossal dumb-isms emitted
by OracleSupport.
Tony
Aponte
-Original Message-From: Brian McGraw
[mailto:[EMAIL PROTECTED]]Sent: Thursday, June
20, 2002 11:29 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: what
Title: RE: RE: Advance Oracle Trigger Writing Advice
Hi Hannah,
I think you could use a simpler feature to brute-force a trace of your trigger's execution path. The SYS.DBMS_SYSTEM.KSDWRT procedure provides output facilities for the alert.log and session trace files.
. i.e. orders taken for our Order Entry app.,
packages shipped forFulfillment, IVR calls, outbound calls placed,
etc.)
HTH
Tony
-Original Message-From: Vergara, Michael (TEM)
[mailto:[EMAIL PROTECTED]]Sent: Thursday, June 13, 2002 12:26
PMTo: Aponte, Tony; [EMAIL PROTECTED
One
more link with a complete package. http://www.quest-pipelines.com/Pipelines/PLSQL/archives.htm#code35
Tony
-Original Message-From: Aponte, Tony
Sent: Thursday, June 13, 2002 12:29 PMTo: Multiple
recipients of list ORACLE-LSubject: RE: oracle error
logging
produce
SQL. I'm surprised they haven't suggested it already...
:-)
- Original Message -
From:
Aponte, Tony
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, June 13, 2002 8:47
AM
Subject: RE: I/O contention with
external p
Title: RE: Replication question
Another potential HA use of AR is that you can use different platforms in an HA configuration. You can fail over to another platform with some idle capacity or a workload that can be shifted around until the failed services are restored.
Yet another is during
Title: RE: I/O contention with external process reading the oracle logs (online redo logs)
I think Yechiel is referring to a statistical claim by Quest that only 30% of the redo stream is usable in re-assembling the SQL statement. The rest is like you suspect, index maintenance, rbs segment
Title: RE: Any Good , Complete Docs , Source , Links on OUTLN ?
Chapter 11 in Tom Kyte's Oracle one-on-one Export (start here if you can and save yourself time)
Metalink Note 92202.1 How To Specify Hidden Hints in SQL
Oracle Corporation paper by David McElhoes, Stabilizing Query
Title: RE: oratcl
I use TCL/TK Tools by Mark Harrison. It has a chapter on Oratcl. There's also good information in the OEM's Intelligent Agent Users Guide.
HTH
Tony Aponte
-Original Message-
From: Arslan Bahar [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 13, 2002 11:29 AM
Title: RE: Management Reports
Is your management looking for real-time charts or are they looking for higher-level scorecard-like info (i.e.. number of transactions yesterday, last 7 days, yada yada yada?)
Tony Aponte
-Original Message-
From: Vergara, Michael (TEM) [mailto:[EMAIL
PL/SQL
Tips Techniques from Oracle Press hasa few sections that may
interest you. There's one on encapsulating exception blocks, with code to
set up an infrastructure for exception routines. Another good on is a
complete package to encapsulate UTL_FILE exception handling.
HTH
Tony
Aponte
Title: RE: RMAN NETBACKUP recovering from say 6 MONTHS ago
The
logs are usually located in /opt/openv/netbackup/logs. The instructions on
how to activate logging for each of the Netbackup components is in
/opt/openv/netbackup/logs/README.debug. The process you are looking to
debug is
Title: RE: Diagnose Slow System
I apologize if I missed the final post. Did you discovered the cause of the problem?
Tony Aponte
-Original Message-
From: Baker, Barbara [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 23, 2002 6:13 PM
To: Multiple recipients of list ORACLE-L
Title: RE: Complex Integrity Checking
Sorry for the delayed reply (I type with 2 fingers.) The section starts on page 685.
rip
Database Changes
Now, this is were things get interesting - database changes. Here, things can get a little murky. Database changes made, but not yet
e, then we are in agreement.
regards,
Waleed
-Original Message-From: Aponte, Tony
[mailto:[EMAIL PROTECTED]]Sent: Monday, June 10, 2002 10:16
AMTo: [EMAIL PROTECTED]Cc:
[EMAIL PROTECTED]Subject: RE: Complex Integrity
Checking
Sorry for the delayed rep
Title: RE: Wrong Results Bug in Oracle 8.1.7.1
We had a similar issue, although it always resulted in an ORA-600. It was with descending indexes as defined in the Peopletools repository. We had to set _IGNORE_DESC_IN_INDEX=TRUE (and _DB_FILE_NONCONTIG_MBLOCK_READ_COUNT=1 to comply with the
Title: RE: RMAN NETBACKUP recovering from say 6 MONTHS ago
Netbackup has a repository that keeps track of what files are on which tapes, dates, sizes, volumes, serial number, etc. Depending on how you are restoring the files, Netbackup gets a request to get a file name (as it is know on
Title: RE: I/O contention with external process reading the oracle logs (online redo logs)
I think they are alluding to UNIX file system contention. If the redo logs are in regular file systems (not raw, Veritas Quick I/O, etc.) then UNIX (at least in my Solaris environment) needs to lock
of one
Attn: DENNIS WILLIAMS [[EMAIL PROTECTED]], Aponte, Tony
[[EMAIL PROTECTED]]
- I did make a function:
FUNCTION check_for_overlapped_intervals (
p_start_time IN NUMBER,
p_end_time IN NUMBER)
RETURN NUMBER
Title: RE: Complex Integrity Checking
With the introduction of Autonomous Transactions this is no longer entirely true. If you call an autonomous transaction procedure, it is executed in a separate transaction context. This gives you the ability to probe the mutating table without inducing
Title: RE: Complex Integrity Checking
I would look into combining a before-insert row-level trigger with an autonomous transaction procedure. The procedure would execute the validating query using parameters passed by the trigger. If your new row values would cause an overlap then return a
Here's
a quick-n-dirtySQL that pivots the result set into one row. It has
its limits (you must know the number of rows that would be returned so that you
can adjust the grouping columns value01 through value12.
SELECT
g1
,MAX(DECODE(line_no,01,value,NULL)) value01
Title: RE:
There is a solution in Tom Kyte's Expert One on One book. It implements as SQL Loader in PL/SQL with UTL_FILE.
Tony Aponte
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 22, 2002 11:38 AM
To: Multiple recipients of list
I
think you are running into the stampeding herd phenomenon. I'm
suspicousof the low value for the spin count. It seems timid.
Could you truss one of the shadow processes with the timing option and post the
output? Just enough to identify the repeating pattern. Also, please
run the trussin
: http://www.orafaq.com
--
Author: Aponte, Tony
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
Steve Adams' site is a good
start. http://www.ixora.com.au/
Tony Aponte
-Original Message-From: Anand Prakash
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, April 17,
2002 5:29 PMTo: Multiple recipients of list
ORACLE-LSubject: Script for identifying objects having freelists
Title: RE: How to test BCV and backups
Are you going to use RMAN or only OS utilities?
Tony Aponte
-Original Message-
From: Seppo Kaasalainen [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 25, 2002 12:40 PM
To: Multiple recipients of list ORACLE-L
Subject: How to test BCV and
Title: RE: EMC's DBTuner
We've been using Precise/SQL since its early days. We also are using DBTuner for our servers that have Symmetrix devices attached. As far as we know it attaches to the SGA for read-only but you can probably verify that with pmap. But we've never had any problems with
We
have several 2-way VCS clusters with 16 and 10 CPU's per server. We found
that the failover time was proportionate with the number of file systems that
need to be mounted by the take-over node. We consolidated the file systems
containing the datafiles down to 1 and each database takes
had posted
previously:
"Aponte,
Tony"
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
et
cc:
Sent by:
Subject: RE: providing 24*7 database
---
[EMAIL PROTECTED]
om 10/22/01
09:05
AM
Please
respond
to
ORACLE-LWe
use a modified version of your
Could it be that the standby is
auto-registering itself with the listener for the production database?
We've had a couple of incidents where a development DBA copied the init.ora file
from a production database configured forMTS. But the listener
parameters were not changed and all new
: Aponte, Tony
Sent: Friday, February 08, 2002 11:32 AM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: RE: Help !! Password Encryption/decryption ??
How about right-padding the string to a multiple of 8 bytes. I think 8-MOD(LENGTH(string),8) will give you the number of characters
Title: RE: Where does a DBA go from here?
I haven't read the Tuning 101 but it sounds like it lets you know where you are waiting. The Internals book will give you in-depth knowledge of why by diving deeper into some of the algorithms used to implement those waits. Break out the aspirin
Title: RE: Help !! Password Encryption/decryption ??
How about right-padding the string to a multiple of 8 bytes. I think 8-MOD(LENGTH(string),8) will give you the number of characters to use in RPAD(string,...). E.I.. to pad with blanks:
SELECT RPAD('123456789',LENGTH('123456789') + 8
Title: RE: URGENT Help on tracking unauthorized login to Oracle Database
I have an idea for a poor man's version of what you are looking for. Turn on listener logging to a level high enough where you can see the text of the net traffic. With some creativity or a copy of Sed Awk you'll be
Title: RE: HOW TO KNOW INDEX NOT IN USE?
Nope. Same behavior for me.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 05, 2002 11:01 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: HOW TO KNOW INDEX NOT IN USE?
Can anyone
Title: RE: HOW TO KNOW INDEX NOT IN USE?
Another option you have if your Oracle version is high enough is to use Stored Outlines. Enable automatic generation of stored outlines for a full processing cycle as defined by the application (full month, Qtr, etc.) Then extract all of the indexes
Title: RE: Hm
I just had another idea. Maybe you can use UPDATE table SET column=column+1 RETURNING column INTO somevariable instead of the SELECT FOR UPDATE. This will add 1 to the current value and return the result to the caller.
Tony Aponte
-Original Message-
From: Aponte
Title: RE: Hm
What you are observing is the concurrency mechanism as implemented in the Oracle rdbms. I couldn't explain it better in an email so I suggest you get a hold of Expert One-on-one Oracle by Thomas Kyte, chapter 3 on Locking and Concurrency. Another thought I have is that it
Title: RE: How can i receive name of the running procedure
Take a look at DBMS_UTILITY.FORMAT_CALL_STACK. You can parse out the caller from the return value. Here's a short example of an anonymous block:
DECLARE
stack_info VARCHAR2(4096);
BEGIN
stack_info:=DBMS_UTILITY.FORMAT_CALL_STACK;
Title: RE: Freeable memory
Hi Mike,
I did a test on one of our 7.3 databases. It seems that some (but not all) freeable chunks get coalesced by flushing the shared pool. I tested it on a database with no other users logged in and took before/after pictures of the chunk breakdown.
SQL
Title: RE: SPACE FREE HOW?
Nick,
I have
a question regarding LiveReorg's method that prevents modifications to the
original table when it's time to switch to the newly reorged one. AS the
mechanism to prevent DML,LiveReorg createsa temporary trigger
on Insert, Update and Delete. It
Title: RE: How to calculate user load on the system
Raj, sorry for me being confused. Are you trying to measure what the application executable is doing outside the database (i.e.. host system load) or the activity inside the database (i.e.. per user/program/module DB stats)?
Tony
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: Aponte, Tony
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 16, 2002 5:53
PMTo
Title: Socket directory under solaris
Try
/ver/tmp/.oracle
Tony
Aponte
-Original Message-From: Adams, Matthew (GEA, 088130)
[mailto:[EMAIL PROTECTED]]Sent: Monday, January 14, 2002 9:00
AMTo: Multiple recipients of list ORACLE-LSubject:
Socket directory under solaris
Title: RE: VLDB backup policy
What type of application is it (OLTP, DSS, mixed, etc.)? Also, is it monolithic or can the functionality be broken down into usage profiles (i.e. mostly read, high velocity update, etc.)?
-Original Message-
From: Andrey Bronfin [mailto:[EMAIL
Title: Install of two client versions on same box
This
is very easy if you follow OFA standards for software installation. The
different versions are installed as sub-directories of the $ORACLE_BASE
directories (i.e... /oracle/app/oracle/product/8160,
/oracle/app/oracle/product/8172). You
Title: RE: sql query
add NULLS FIRST after the ORDER BY CAR_MAKE:
select
to_number(null) as id,
to_char(null) as car_make
from
dual
union
select
id,
car_make
from
carmake
order by
car_make NULLS LAST;
Tony Aponte
-Original Message-
From: Steven Hovington
Title: RE: sql query
Oops. The statement was wrong. I'll try it gain:
select
to_number(null) as id,
to_char(null) as car_make
from
dual
union
select
id,
car_make
from
carmake
order by
car_make NULLS FIRST;
Tony Aponte
-Original Message-
From: Aponte, Tony
Title: RE: Lookup table design thoughts needed
I would start by considering how the application is deployed. For code that is easily deployed (E.I.. executables are located on a few application servers or a shared drive) I would consider compiling the rule data along with the logic. It
Title: RE: Retek ERP ORacle
Yes. Still on 7.3.4.
-Original Message-
From: MRaval [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 07, 2001 12:10 PM
To: Multiple recipients of list ORACLE-L
Subject: Retek ERP ORacle
Anyone in this forum working with Retek ERP. Thanks.
--
Title: Help in deciphering the values for flag in systemstate dump
I'm troubleshooting a discrepancy between v$session_wait and Precise/SQL 3.1. Oracle reports that sessions waiting on SQL*Net message from client but the tool shows some of them in MTS wait. Since Precise/SQL parses the SGA
Title: RE: CROSS TAB QUERY
What Oracle version? Also, is the requirement for pure SQL or can there be some PL/SQL?
Tony Aponte
-Original Message-
From: Moses Ngati Moya [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 28, 2001 3:15 AM
To: Multiple recipients of list
Title: RE: Email through trigger
UTL_SMTP.
-Original Message-
From: Aldi Barco [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 11:05 AM
To: Multiple recipients of list ORACLE-L
Subject: Email through trigger
Hi Listers,
What is the oracle procedure / package
Title: RE: CROSS TAB QUERY
I gave it a whack and came up with the following solution (I needed the distraction). For demo purposes each statement build upon the previous ones. But first a little reality. There are some problem boundaries that can be declared. The first one is that there are
Title: RE: exp a big tablespace
Here's a tip I mined many moons ago from I don't know where. It's a script to split the compressed file into smaller chunks using the standard UNIX split utility.
HTH
Tony Aponte
January 16, 1998
Exporting a Database That's More Than 2GB When
Title: RE: Oracle and MQ
I believe Oracle sells an MQ-to-AQ bridge that just moves messages between queuing systems. We use VB to pull messages out of MQ and issue SQL to get it into the database.
HTH
Tony Aponte
-Original Message-
From: YTTRI Lisa [mailto:[EMAIL PROTECTED]]
Title: RE: Internal Benchmarking
I've had some luck with the tools described in Scaling Oracle8i by Morle. It has and awk script to parse out 10046 event trace sql and bind variable information and produce a tcl script suitable for dbaman. Dbaman is an extended tcl shell sotra-likea oratcl.
Title: RE: Oracle Text (ConText/InterMedia) and realtime updates
I would suggest researching an Autonomous Transaction fired from the trigger to get around the commit executed by CTX_DDL.SYNC_INDEX.
Another approach I would pursue is to evaluate the use of Catalog Indexes (8.1.7). If your
Title: RE: Sockets and Pl/SQL
Tom Kyte's book Expert One On One Oracle has a very informative chapter on using UTL_TCP. Well worth the $ for this chapter alone. We had a developer waste the company's time trying to create the same functionality using external procedures.
HTH
Tony Aponte
Title: RE: IP address for a session without audit enable
I can do this in 8.1.6:
SELECT SYS_CONTEXT('USERENV','IP_ADDRESS') from dual
Tony Aponte
-Original Message-
From: Khedr, Waleed [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 30, 2001 11:35 AM
To: Multiple
Title: RE: Works interactively but not in procedure
This is a privilege issue. The stored proc runs with the security of the connected user except for those inherited via roles. Try adding the pragma for current user as follows to see if this is what you want:
CREATE OR REPLACE
procedure
wouldn't go that route.
-Original Message-
From: H elp_me [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 30, 2001 3:38 PM
To: Aponte, Tony; [EMAIL PROTECTED]
Subject: RE: Works interactively but not in procedure
Hello Tony,
I tried with 'authid current_user' and giving direct
Title: RE: Base table of materialized views
I have a few questions that you can answer with by post of the snapshot creation command. Also, the refresh type and any other relevant info. (i.e. snapshot log, etc.)
Tony Aponte
-Original Message-
From: [EMAIL PROTECTED]
Title: RE: Temporary table
Harvinder, I'm a little confused. The requirements you describe (up to the last sentence) are a classic example of what Global Temporary Tables are suited for. The last sentence puzzles me since you would only be creating one GTT before deploying the code, not each
Title: RE: Object-Oriented Tools
We used it many moons ago with version 7.32. It turned out to be more complicated to administer and code than we ever anticipated so it was put to pasture. You're right in that many of the OO functionality is included in the newer versions, and what's not can
Title: RE: Commit trigger
This triggered a thought. Why not use a trigger to insert a row into a commit notification table. The row will be visible only upon commit. A separate session can poll the commit notification table.
Also, how about Advanced Queues? I believe the messages can be
...
naren
-Original Message-From: Aponte, Tony
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, 23 October 2001
05:06To: Multiple recipients of list ORACLE-LSubject:
RE: providing 24*7 database ---
We use a modified version of your duplicate schema
idea. But we don't have
1 - 100 of 122 matches
Mail list logo
