05-30-2008
I assume you are logging in oracle database from unix by sqlplus command and once you enter to oracle database you run your sql query.
Hence the problem is with your query and certainly not a unix problem.Try to run your query from sqlplus directly and see the performance.you might need to tune query.
8 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I am trying to develop a script that can connect to a DB2 database mainframe and Query the database and display the results. I've been researching, but I have yet to find a definitive solution where I can enter in the Mainframe DB2 address db2:// and query the database and return the results. If... (2 Replies)
Discussion started by: developncode
2 Replies
2. UNIX for Advanced & Expert Users
I am trying to develop a script that can connect to a DB2 database mainframe and Query the database and display the results. I've been researching, but I have yet to find a definitive solution where I can enter in the Mainframe DB2 address db2:// and query the database and return the results. If... (2 Replies)
Discussion started by: developncode
2 Replies
3. HP-UX
Hello, all...
I've got an older HP-UX 11i machine hooked up to an HP VA array. I've never worked with VA arrays, so I was wondering if anyone could point me in the direction of some documentation on querying and manipulating VAs (HP VAs for Dummies or something).
I'm used to EMC arrays, so... (2 Replies)
Discussion started by: kknigga
2 Replies
4. AIX
Hello,
I've created new DNS servers and changed all of the clients /etc/resolv.conf to point to them, but when I check the old DNS logs, I see that the clients are still querying it. Does anybody know why?
thanks, (2 Replies)
Discussion started by: ctcuser
2 Replies
5. Solaris
Hi all
Got another strange one. If I try to enquire about the hardware, the command hangs implying Ive got a hardware issue. So, if I execute :-
iostat -en
sysdef - ( stops at the devices part )
format
cfgadm -al
Anything that searches the devices, then the command hangs.
... (4 Replies)
Discussion started by: sbk1972
4 Replies
6. Red Hat
Hi,
We have one application running where there is Linux Machine. For some some process I found the following message came,
error 5.8/116455-02/116455-02.zip
Error in querying file information:
Permission denied
:confused:
If anybody has any idea for this please let me... (2 Replies)
Discussion started by: sptr
2 Replies
7. Shell Programming and Scripting
I have a few databases that i need to get some basic output from... so I'll be returning 1 or 2 records from a variety of different databases and the input queries will always differ.
What im looking for is a generic script that I can use across of the databases. Theory being i have:
... (2 Replies)
Discussion started by: atelford
2 Replies
8. Shell Programming and Scripting
Hi All,
I'm using below code
entry_data_control=`sqlplus ${sysuser}/${syspwd} << data_control
whenever sqlerror exit sql.sqlcode;
whenever oserror exit failure;
INSERT INTO LSHADMIN.STUDY_LEVEL_TABLE(SESSION_SID,SESSION_SERIAL_NO,FILE_NAME)
... (3 Replies)
Discussion started by: Pratiksha Mehra
3 Replies
LEARN ABOUT REDHAT
execute
EXECUTE(7) SQL Commands EXECUTE(7)
NAME
EXECUTE - execute a prepared query
SYNOPSIS
EXECUTE plan_name [ (parameter [, ...] ) ]
INPUTS
plan_name
The name of the prepared query to execute.
parameter
The actual value of a parameter to the prepared query. This must be an expression yielding a value of a type compatible with the
data-type specified for this parameter position in the PREPARE statement that created the prepared query.
DESCRIPTION
EXECUTE is used to execute a previously prepared query. Since prepared queries only exist for the duration of a session, the prepared query
must have been created by a PREPARE statement executed earlier in the current session.
If the PREPARE statement that created the query specified some parameters, a compatible set of parameters must be passed to the EXECUTE
statement, or else an error is raised. Note that (unlike functions) prepared queries are not overloaded based on the type or number of
their parameters: the name of a prepared query must be unique within a database session.
For more information on the creation and usage of prepared queries, see PREPARE [prepare(7)].
COMPATIBILITY
SQL92
SQL92 includes an EXECUTE statement, but it is only for use in embedded SQL clients. The EXECUTE statement implemented by PostgreSQL also
uses a somewhat different syntax.
SQL - Language Statements 2002-11-22 EXECUTE(7)