Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 38340

All versions of Oracle database. Add a version-specific tag like oracle-11g-r2 if that context is important in the question. Do not use for Oracle products such as applications or middleware or other database products owned by Oracle, like MySQL or BerkeleyDB.

0
votes
It seems that the settings is inside the dispatcher. So we have shutdown the dispatchers (and of course start others) and it solve our problem
answered May 21 '14 by eliatou
0
votes
Did you set the ORACLE_SID? I think the problem is there
answered May 13 '14 by eliatou
0
votes
1answer
We start a database without sqlnet.ora file. So as SQLNET.EXPIRE_TIME is not configured, some process has been disconnected. We had sqlnet.ora with a SQLNET.EXPIRE_TIME=1, restart the listener but h …
asked May 21 '14 by eliatou
1
vote
You can find information about connection in listener.log Location is under $ORACLE_HOME/diag/ or $ORACLE_HOME/network/log
answered May 21 '14 by eliatou
1
vote
you could put your table into a temporary table or a table of varchar2. ex: Instantiation : create global temporary table gpt_name(table_name varchar2(64)) on commit preserve rows; insert into gpt_n …
answered May 27 '14 by eliatou
12
votes
The most simple is to use tnsnames.ora file to connect to the database. For that edit it and add a new entry: This file normally resides in the $ORACLE HOME\NETWORK\ADMIN directory. myDb …
answered May 13 '14 by eliatou
1
vote
The best view (for me) to see the status of a long query is V$SQL_MONITOR. This view include all query that has consumed at least 5 seconds of CPU or I/O time. This view is very volatile, so you have …
answered Jun 2 '14 by eliatou