10-05-2009
Did you run tkprof? ( alter session set sql_trace true
then run tkprof on the dump?
if the subselect returns thousands of hits from the db, or PT.specl_comp_cd is not indexed and the table contains millions of rows then you have a problem. Is employee id indexed in the payroll_tbl?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi-
I am trying to achieve the following in a script so I can schedule it on a cron job. I am fairly new to the unix environment...
I have written a shell script that reads a flat file and loads the data into an Oracle table (Table1) via SQLLDR. This Works fine. Then, I run a nested insert... (5 Replies)
Discussion started by: rajagavini
5 Replies
2. Programming
I have a stored procedure that is failing. The current query behind it is:
SELECT DISTINCT
<many, many values>
FROM
table1
LEFT OUTER JOIN table2 ON
(table2.key =
(select max (table2.key) from table2
where table2.key = table1.key) or
... (0 Replies)
Discussion started by: Elric of Grans
0 Replies
3. UNIX for Dummies Questions & Answers
Hi guys,
I am new on here, I have a function in oracle that returns a specific value:
create or replace
PACKAGE BODY "CTC_ASDGET_SCHED" AS
FUNCTION FN_ASDSCHEDULE_GET
RETURN VARCHAR2
AS
BEGIN
DECLARE
ASDSchedule varchar2(6);
ASDComplete... (1 Reply)
Discussion started by: reptile
1 Replies
4. Shell Programming and Scripting
Hi techies ..
This is my first posting hr ..
Am facing a serious performance problem in counting the number of lines in the file. The input files i get will be in some 10 to 15 Gb of size or even sometimes more ..and I will load it to db
I have used wc -l to confirm whether the loader... (14 Replies)
Discussion started by: rajesh_2383
14 Replies
5. Shell Programming and Scripting
Hi!
I would like to do a single connection to sqlplus and execute some querys.
Actually I do for every query one connection to database
i.e
echo 'select STATUS from v$instance;
exit' > $SQL_FILE
sqlplus user/pass@sid @$SQL_FILE > $SELECT_RESULT
echo 'select VERSION from v$instance;... (6 Replies)
Discussion started by: guif
6 Replies
6. UNIX for Advanced & Expert Users
Hi Experts:
I have a shell script that's kicked off by cron. Inside this shell script, I need to kick off two or more oracle sql scripts to process different groups of tables. And when both sql scripts are done, I will continue in the shell script to do other things like checking processing... (3 Replies)
Discussion started by: huasheng8
3 Replies
7. Programming
Greetings all,
Hopefully there is someone out there on this forum who can help with this Oracle SQL Developer issue I have.
Here is the code:
CREATE OR REPLACE VIEW
SALES_OVER_30000_WITH_TOTAL
AS
SELECT
E.FIRST_NAME || ' ' || E.LAST_NAME AS EMPLOYEE_NAME,
... (2 Replies)
Discussion started by: U_C_Dispatj
2 Replies
8. Solaris
Is there any other editor, installed by 'default' in Sparc Solaris10, besides vi?
I'd like to avoid installing anything new.
If not, how to make vi more user-friendly?
thanks. (8 Replies)
Discussion started by: orange47
8 Replies
9. Shell Programming and Scripting
Hi,
I have a large number of input files with two columns of numbers.
For example:
83 1453
99 3255
99 8482
99 7372
83 175
I only wish to retain lines where the numbers fullfil two requirements. E.g:
=83
1000<=<=2000
To do this I use the following... (10 Replies)
Discussion started by: s052866
10 Replies
10. Shell Programming and Scripting
Hi All,
I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise.
Eg :
Select 'Query 1 output' from dual;
Select 'Query 2 output' from dual;
I want to... (3 Replies)
Discussion started by: Rokkesh
3 Replies
LEARN ABOUT OPENSOLARIS
mlib_imagelookup
mlib_ImageLookUp(3MLIB) mediaLib Library Functions mlib_ImageLookUp(3MLIB)
NAME
mlib_ImageLookUp - table lookup
SYNOPSIS
cc [ flag... ] file... -lmlib [ library... ]
#include <mlib.h>
mlib_status mlib_ImageLookUp(mlib_image *dst, const mlib_image *src,
const void **table);
DESCRIPTION
The mlib_ImageLookUp() function maps the source image to the destination image by using the user-specified lookup table.
The source and destination images must have the same width and height. The source image can be a single channel image or can have the same
number of channels as the destination image. One of the following equations is used accordingly:
dst[x][y][i] = table[i][src[x][y][0]]
dst[x][y][i] = table[i][src[x][y][i]]
The source and destination images can have different data types. See the following table for available variations of the table lookup func-
tion on image types:
Type [*] BYTE SHORT USHORT INT FLOAT DOUBLE
----------------------------------------------------------------------------------------
MLIB_BIT Y
MLIB_BYTE Y Y Y Y Y Y
----------------------------------------------------------------------------------------
MLIB_SHORT Y Y Y Y Y Y
----------------------------------------------------------------------------------------
MLIB_USHORT Y Y Y Y Y Y
----------------------------------------------------------------------------------------
MLIB_INT Y Y Y Y Y Y
[*] Each row represents a source data type. Each column represents a destination data type.
PARAMETERS
The function takes the following arguments:
dst Pointer to destination image.
src Pointer to source image.
table Pointer to lookup table. The data type of the lookup table is the same as the destination image. The number of entries in the
lookup table is determined by the type of the input image. The format of the lookup table is:
table[channel][index]
The MLIB_BIT type entries are indexed from 0 to 1. The MLIB_BYTE type entries are indexed from 0 to 255. The MLIB_SHORT type
entries are indexed from -32768 to -1, then from 0 to 32767. The MLIB_USHORT type entries are indexed from 0 to 65535. The
MLIB_INT type entries are indexed from -2147483648 to -1, and then from 0 to 2147483647.
If a table covering the full range of input data type is not available or not realistic, which is mostly true for doing table
lookup with an MLIB_INT input image, a smaller table can be used. In this case, the pointer to the table has to be adjusted as if
it is pointing to the element for the smallest value of the input data type. For example, to use a table covering input data
range of [-65536, 65535], the pointer needs to be adjusted as follows:
table_16_32[0] += MLIB_S32_MIN + 65536;
This might cause a pointer arithmetic overflow in 32-bit mode, but probably works if the overflow is handled as a wrap-around. If
possible, function mlib_ImageLookUp2() should be used instead.
RETURN VALUES
The function returns MLIB_SUCCESS if successful. Otherwise it returns MLIB_FAILURE.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Interface Stability |Committed |
+-----------------------------+-----------------------------+
|MT-Level |MT-Safe |
+-----------------------------+-----------------------------+
SEE ALSO
mlib_ImageLookUp_Inp(3MLIB), mlib_ImageLookUp2(3MLIB), mlib_ImageLookUpMask(3MLIB), attributes(5)
SunOS 5.11 12 Sep 2007 mlib_ImageLookUp(3MLIB)