Long And Short Connection In Oracle?

Feb 6, 2013

what's long connection and short connection in Oracle ?

View 4 Replies


ADVERTISEMENT

PL/SQL :: Single Long Connection Vs Multiple Short Connections To Oracle Server

Oct 8, 2012

A DB server (Oracle 11g) on Linux will support a Web Application Server (Java based) for hosting a public web site.For sending multiple INSERT statements over from the Java Server to Oracle Server, I have two ways to do it:

1) Wrap those insert statements together and send it over with one connection to Oracle

2) Send each insert statement separately to Oracle. As the result, multiple insert statements are sent and accordingly multiple connections to Oracle are needed.

Advantage of option 1 is just using one Connection. Disadvantages are that Oracle will then need to parse the statement string into multiple separate insert statements, and then loop through them to execute each. This may be costly in CPU sense.

While the option 2 may have quicker execute of each insert statement, but will need to create multiple connections.If the number of users is known and stable (such as intranet), I would prefer option 1; while for the internet there could hundreds concurrent users at the peak, I lean towards the option 2.

View 2 Replies View Related

PL/SQL :: Select On View Takes Long On Definition Short - No Difference In Exec-plans?

Aug 20, 2012

[URL]...

I have a quite complex view that selects from approx 10 long tables (approx 4M records each) and build one "customer sentence" pre customer id. I will be always getting just one row from this view, eg. select * from my_view where party_id = XYZ. I'll NEVER EVER select the whole view.

The problem is that running a query:
select * from my_view where party_id = XYZ takes really long time, while putting the party_id = XYZ condition directly into the view executes in 0.0 seconds.

After putting a ORDERED FIRST_ROWS(1) hint into a view the execution plans seems to be the same (or very similar) for both queries. Unfortunately, I can not transfer anything but screenshot from the environmnet - therefore I paste the exec plans as screenshots only - pls follow the link: [URL]...

View DDL:
create or replace view my_view as
select /*+ ORDERED FIRST_ROWS(1) */  pt.party_id
           pt.party_id as id_klienta_mdm,
           pt.master_reference_no as id_klienta_ref_mdm,
        
[code]...

View 6 Replies View Related

Semantic Technologies :: Can Bind LONG Value Only For Insert Into LONG Column

Dec 22, 2012

I got an exception when I was using sesame adapter to dump a turtle file which contains long texts as objects into oracle semantic database. The exception information is:

org.openrdf.repository.RepositoryException: org.openrdf.sail.SailException: java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column

ORA-06512: in "SF.ORACLE_ORARDF_ADDHELPER", line 1
ORA-06512: in line 1
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802) ...

View 1 Replies View Related

Client Tools :: Several Short Fetch To Retrieve Records

Dec 28, 2010

I have a big database, I want to retrieve its records in several tries; first I use "select * from dbname where rownum <1000" but for 2'th try how can I get next 1000 records but not previous records?

View 1 Replies View Related

Performance Tuning :: AWR Report Generation For Short Duration

Nov 5, 2012

Is it possible to generate AWR report for the duration of 5 min? As we know that snapshots are generated for every 1 hour, which we specified in parameter.

By changing the parameter to 2 min, what could be the impact on database?

View 7 Replies View Related

ORA-01461 - Can Bind LONG Value Only For Insert Into LONG Column

Sep 26, 2012

resolve problem with move lob objects ? I move table partition and lob (BLOB) from one tablespace to another :

alter table EBIF.APO_T_VER_DISP_ACC_RESP MOVE PARTITION P1M20120901 LOB(SIGNATURE_PATTERN) STORE AS (TABLESPACE tmp) t
able EBIF.APO_T_VER_DISP_ACC_RESP MOVE PARTITION have : pbeb_ap1.SYS>select partition_name , tablespace_name from dba_lob_partitions where table_name='APO_T_VER_DISP_ACC_RESP';

PARTITION_NAME          |TABLESPACE_NAME
------------------------------|------------------------------
P1M20110901          |TD1M20110901
P1M20111001          |TMP
P1M20111101          |TMP
P1M20111201          |TMP
P1M20120101          |TD1M20120101
[code]....

I used skrip to generate move :

select 'alter table '||table_owner||'.'||table_name||' MOVE PARTITION '||partition_name||' LOB('||COLUMN_NAME||') STORE AS (TABLESPACE TD_PART_RW) PARALLEL 4;'

from dba_lob_partitions where tablespace_name='TMP';

when I started loadink into dis table I get : ORA-01461: can bind a LONG value only for insert into a LONG column

when I recreate this table ALL work ok , but new table is not partitioned .

View 2 Replies View Related

PL/SQL :: Java Long Date In Oracle

Jan 10, 2013

One of the java developers put a java long date in an oracle table. How can I report it in the usual dd-mon-yyyy format?

field in the table:
ISSUE_DATE     NUMBER     Yes          4     

some sample data:
1211567760081
1211576585400

View 5 Replies View Related

How Long Does Content In Oracle Recycle Bin Stay

Oct 10, 2012

Using oracle 11.2.0.3...How long does the content in recycle bin stay?

e.g is it dependant on size of undo tablespace and expires after certain time? Also if drop table, then recreate table with same name will this wipe the dropped table from the recycle bin automatically?

View 4 Replies View Related

SQL & PL/SQL :: Oracle Connection On XP

Dec 25, 2010

I have installed ORACLE 11g on RHEL-4, where the RHEL is installed on VM.ORACLE is working fine on RHEL but i am not able to connect oracle on my XP.

View 1 Replies View Related

Connection To Oracle 11GR2

Jul 15, 2013

How to connect to database with windows authentication:

OS system: 2008 R2 windows
oracle : 11.2.0.3

sqlnet.ora set to NTS.

also user is created on database externally "domain/username"

i want to connect to the database with my windows account!

View 4 Replies View Related

Oracle Connection Manager

Apr 30, 2013

I've a problem with Oracle Connection Manager and I've read the Oracle topic about it at URL.....but it doesn't work well...This is an image describes the diagram I want to configure URL.....

The IP for each machine is
Database Server : 192.168.0.150
Proxy Server : 192.168.0.153
client : 192.168.0.159

And these are the files for each machine.

1.Proxy server has 1 file

cman.ora
CMAN=
(CONFIGURATION=
(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.153)(PORT=1521))
(RULE_LIST=
[code]....

2.Database server has 3 file, and for each one I've added some lines as following

tnsnames.ora
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
[code].....

3.Finally the client has 2 files

tnsnames.ora
orcl=
(DESCRIPTION=
(SOURCE_ROUTE=YES)
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.153)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.150)(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=orcl))
[code]....

ORA-12154: could not resolve the connect identifier specified: where I actually define my DB service (orcl) in the tnsname.ora...The output is showen here URL.....

View 1 Replies View Related

ODP.NET :: Oracle Connection From Pool?

Jun 22, 2012

How do i test if a OracleConnection came from the pool or was created for the first time?

View 2 Replies View Related

Forms :: Connection Between 6i And Oracle Database 11g

Jun 8, 2011

I´m just having a problem whit the connection between Oracle Forms 6i and Oracle Database 11G. Is just when i login to the database schema i cant log in using Forms.

TNS Names its already configured, No problems when i log in using Toad and using the TNS Names from Developer's 6i tool. I can log in just when i change the schema(user) password from the database (thats the rarest thing) and log into the application.

So whenever i want to login to the application i must to change the schema password, i need to use it directly.

View 2 Replies View Related

OLE DB :: Establish Connection To Oracle With Application In Win 7?

Jan 11, 2013

I have an application in VB6 that connects to an Oracle Database 10g with Oracle native ole db but win7 can not make the connection with a standard user, only makes the connection to a user with administrator permissions. The error that shows the application's rubbish eg @, H, etc.. only rare characters.

View 7 Replies View Related

Windows :: Error Regarding Oracle Connection?

May 20, 2013

error regarding oracle connection

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim oradb As String = "Data Source=CallTaxi; UserName = SCOTT; Password=TIGER ;"
Dim conn As New OracleConnection(oradb)
conn.Open()
Dim cmd As New OracleCommand

[code]...

Error msg:
The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception.

View 1 Replies View Related

Forms :: Oracle 10g And Database Connection

Aug 8, 2011

Toady i have installed oracle forms 10g and oracle 10g db when i run my form it gives me this error how can i resolve it

"ora-12154 tns could not resolve the connect identifier specified"

View the image below:

Here are the values in forms 10g tns

# tnsnames.ora Network Configuration File: C:DevSuiteHome_1
etworkadmin nsnames.ora
# Generated by Oracle configuration tools.

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
[code].......

and here the values of forms 10g SQLnet

# sqlnet.ora Network Configuration File: C:DevSuiteHome_1
etworkadminsqlnet.ora
# Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, EZCONNECT, ONAMES, HOSTNAME)
(description =
# (address=(protocol=tcp)(host=localhost)(port=1383))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(connect_data=(rpc=on))
)

What changes should i make to overcome this problem.

View 1 Replies View Related

Windows :: Oracle Connection Not Working?

Jun 23, 2012

I'm having great difficulty connecting to two separate databases on my PC. Here are the details.

c:>echo %TNS_ADMIN%
C:TNS_ADMIN
#C:TNS_ADMIN nsnames.ora
XE =
(DESCRIPTION =

[code]...

View 22 Replies View Related

Utl-tcp Connection - Oracle Generic Network Error?

Aug 26, 2010

I have a client program that needs to communicate with another server program. My client program is implemented in PL/SQL using utl_tcp running on Oracle 9 while the server program is a 3rd party software running on Windows server 2003.

Basically my client program needs to send a request to the server, waits for the response (wait for the incoming string which ended /w chr(3) ) and then acknowledge (sending chr(6) ).

My problem is that if I wait for the chr(3) and then acknowledge. My send routine (l_sent := utl_tcp.write_text (g_conn, p_content) will raise a Oracle generic network error. It seems like the connection is closed. I checked /w the vendor and they said it might be I am taking too long to response ( I question timeout is the problem). I have also attempted to change my read routine from read_line to read_raw but it only make things worst. I cannot even read the complete string. At least with read_line, I can read back the entire string.

My current work around is to send out the ack before I receive the chr(3) (which is not recommended by our vendor).

View 5 Replies View Related

Client Tools :: Oracle Connection To SQL Server

Mar 2, 2011

I am using dg4msql to connect to SQL server from Oracle(10.2.0.4, with AIX 5.3).

#from my laptop sqlplus (10.2.0.2)

SQL>select count(*) from table1@mssql; #works
SQL>select * from table1@mssql; #ERROR

ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Oracle][ODBC SQL Server Driver]String data, right truncation
{01004}[Oracle][ODBC SQL Server Driver]String data, right truncation {01004}

#from my laptop, TOAD
Both queries works fine.

i have compared

"select * from nls_session_parameters;" values , TOAD and sqlpus gives same result.

View 3 Replies View Related

Precompilers, OCI & OCCI :: Oracle Connection Not Getting Closed

Apr 26, 2010

I have Multi-threaded application using pro*c to connect to oracle.

I am using the following piece of code to create a connection to oracle database and preserver the context of created connection.

struct sqlca * tempSqlca = new sqlca;
struct sqlca & sqlca = * tempSqlca;
EXEC SQL BEGIN DECLARE SECTION;
SQL_CONTEXT localContext;

[code].....

I am using the following piece of code to close the connection to the oracle database, I am using the context created in the previous step and passing it to the below code(connection.context)to release the connection.

if (connection.context == 0 || connection.ca == 0)
return true;
// Multithreading: get the communication area of the context
struct sqlca & sqlca = *(connection.ca);
EXEC SQL BEGIN DECLARE SECTION;

[code].....

When the above code is executed there is no exception thrown but the connection is not getting close. I am using the V$SESSION system views to monitor the connection created.

I there anything I am missing in my code for the connection closing to fail.

View 1 Replies View Related

Client Tools :: Oracle SQL Developer Connection

Feb 1, 2011

I have installed Oracle 11g R1 and have problem in connecting Oracle SQL Developer.

I have given user name: ora; pswd: ora.

In command prompt it works fine if I gave as below.
uid: ora as sysdba
pswd: ora

But when I am trying to connect to Oracle SQL Developer it says TNS listener does not know SID.

So I reinstalled this since i have doubt on myself whether I made mistake first time. Also I have doubt whether the un installation completely clears all the files from Registry. - What should I do to clear all the files from registry when un-installing.

1] What is SID. Is it session ID. If so how to find it.
2] Is there any way to confirm the values such HOST NAME: localhost, PORT: 1521, SID: (By default it has 'xe') which I gave for data base connection are correct.

I tried with SID value:135 (I got this value by executing [Select distinct sid from V$mystat;])

3] Is there any editor for practicing sql & pl sql queries. where I can download it.

View 6 Replies View Related

Networking And Gateways :: Using Oracle Connection Manager

Dec 4, 2011

I was trying to connect to a remote database from my client machine. Client machine runs a jsp code to connect to the database and execute a query. I have got oracle jdbc on my machine but still unable to connect to the database.

When checked in Google, i found that oracle connection manager has to be used to connect to the database from jdbc if the web server and database reside on different physical servers. But couldn't gather any further information regarding download and installation.

I do not have oracle connection manager on my system. I read in internet that it is shipped along with oracle 11g software. But i am not sure if that was the case in earlier version as well.

My question is where should i install oracle connection manager? (on database server or client machine) and is it possible to download and install only the connection manager as a stand alone so that i can connect to database from application?

View 3 Replies View Related

Security :: Windows Authentication And Connection In Oracle?

Jul 15, 2013

I have been using oracle based database security but company now wants to handle with windows authentication.I have windows os 2008 R2 and oracle 11.2.0.3.

I also have set up the SQLNET.AUTHENTICATION_SERVICES= (NTS).I created user with create user "domainusername" identified Externally! but now how can i connection from application to database!

View 1 Replies View Related

Enterprise Manager :: Connection Of Oracle Server With EM

Apr 5, 2011

I am trying to connect my oracle server with enterprise manager. But i have no network connection. What will be the probable listener config. ?

View 2 Replies View Related

ODP.NET :: Application UnhandledException Not Caught When Using Oracle-connection

Oct 18, 2012

i have a Windows Forms .Net 2.0 App which defines AppDomain.CurrentDomain.UnhandledException handler.When an app thread throws an exception this exception is caught or handled by this method.

The problem is that if i define an OracleConnection, open and close it and then the thread throws the exception this is not handled and app finishes...

Why i can't handled this threads exceptions if i use OracleConnection?

Here is the simple app code example:

program.cs
[STAThread]
static void Main()
{
AppDomain.CurrentDomain.UnhandledException += CurrentDomain_UnhandledException;
Application.ThreadException += Application_ThreadException;
Application.SetUnhandledExceptionMode(UnhandledExceptionMode.ThrowException);

[code].....

View 0 Replies View Related

Security :: Creating Oracle Database Connection

Feb 26, 2013

Just installed the new 2.0.8 version. Its been a while I am interested on using PM for our company.The problem I have is creating an Oracle DB connection. When I create a new Oracle DB connection, and test it, Steps 3 and 4 fail.What is strange is that I followed the following procedure in PM 1.9-825 and worked fine. I am wondering if something changed in the new PM 2.0.8 version (I noticed that php_oci8.dll was commented out in php.ini).

Oracle Version is 10GR2
PM installed on clean XP sp3

1. Got a new Windows XP SP3 PC
2. Installed PM 2.0.8
3. Edited php.ini and uncommented [PHP_OCI8] and extension=php_oci8.dll
4. Installed oracle instant client “instantclient-basic-win32-10.2.0.5” in c:oracle
5. Installed oracle instant client “instantclient-sqlplus-win32-10.2.0.4” in c:oracle
6. Added c:oracle in PATH environment variable
7. Created ORACLE_HOME = c:oracle environment variable
8. Added TNS_ADMIN = c: environment variable
9. Copied working tnsnames.ora file into c:
10. Rebooted.
-------------------------------------
1. Tried sqlplus connection to my oracle db and worked.
2. Launched PM
3. Created a new process
4. Created a new DB connection as follows:
a. Engine:Oracle
b. Server:192.168.xxx.xxx
c. Database name: my_name (where my_name appears in tns_names.ora)
d. Username:my_username
e. Password:my_password
[code]....

View 1 Replies View Related

Networking And Gateways :: Connection Between Oracle And Mssql?

Jul 11, 2013

i have 2 instances (one on Oracle 11g and the otherone Mssql) i was asked to make a link between both.

btw i need excecute a procedure from Oracle against Mssql tables.

View 3 Replies View Related

Server Administration :: Database Connection Failure - Oracle Not Available

May 28, 2010

I'm getting the error messaage:

Database Connection failure. Reason: java.sql.SQLException: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist SVR4 Error: 2: No such file or directory

I'm not an Oracle expert, but I have research a little and seems that the SID could be wrong or that the DB is down, in fact I have already checked trhe server but everything seems normal to me.

View 3 Replies View Related

Server Administration :: Oracle Database Connection Error

Mar 5, 2013

While after connecting to server via my userid( its an externally id) ,after setting ORACLE_HOME and SID, while entering sqlplus / command,its not connecting.Error am getting is:-

ERROR:
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
HP-UX Error: 22: Invalid argument

Attaching output session.

View 16 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved