1
Show Results from : ALL Engines | from GoogleNews | from BingNews
Related Searches :
v -
0v dblink results 1 to 8 of Top 8 from All Search Engines
V$dblink - Oracle Documentation
V$
dblink. This view describes all database links (links with
...
Managing a Distributed Database
V$
dblink. Lists all open database links in your session, that is, all database links with the IN_TRANSACTION column set to YES . GV$
dblink. Lists all open
...
10g Database Link DBA_DB_LINKS mystery

Jul 3, 2006
... ALL_DB_LINKS DBA_DB_LINKS
V$
dblink GV$
dblink. SQL> select count(*) from DBA_DB_LINKS; select count(*) from DBA_DB_LINKS
...
Finding open database links database wide - oracle-l - FreeLists

Feb 11, 2005
... How can I find which sessions have open database links? I know
v$
dblink will show me if my own session has a database link open.
...
Monitoring Oracle Database Links Using V$ and DBA_ Views

Monitoring Oracle
Database Links Using
V$ and DBA_ Views.
V$dblink
V$
dblink. Data Dictionary View Columns. DB_LINK OWNER_ID LOGGED_ON HETEROGENEOUS PROTOCOL OPEN_CURSORS IN_TRANSACTION
...
If you access a database link in a session, then the link remains ...

Jan 16, 2008
... Even a select from a
db link starts a distributed transaction and gets an undo block.
... YAS@10G>select sid from
v$mystat where rownum=1;
...
How can I close Oracle dblinks in JDBC with XA datasources and ...

create or replace procedure rollback_and_close_db_links authid current_user is begin rollback; for links in (select db_link from
v$
dblink) loop
...
v dblink Top 10 from BingNews
v dblink Top 10 from Google
| V$DBLINK - Oracle Documentation
|
| V$DBLINK. This view describes all database links (links with ... |
| http://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_1087.htm |
| Managing a Distributed Database
|
| V$DBLINK. Lists all open database links in your session, that is, all database links with the IN_TRANSACTION column set to YES . GV$DBLINK. Lists all open ... |
| http://docs.oracle.com/cd/B10501_01/server.920/a96521/ds_admin.htm |
| 10g Database Link DBA_DB_LINKS mystery
|
| Jul 3, 2006 ... ALL_DB_LINKS DBA_DB_LINKS V$DBLINK GV$DBLINK. SQL> select count(*) from DBA_DB_LINKS; select count(*) from DBA_DB_LINKS ... |
| http://ora-00942.ora-code.com/msg/65849.html |
| Finding open database links database wide - oracle-l - FreeLists
|
| Feb 11, 2005 ... How can I find which sessions have open database links? I know v$dblink will show me if my own session has a database link open. ... |
| http://www.freelists.org/post/oracle-l/Finding-open-database-links-database-wide |
| Monitoring Oracle Database Links Using V$ and DBA_ Views
|
| Monitoring Oracle Database Links Using V$ and DBA_ Views. |
| http://www.remote-dba.net/t_grid_rac_db_links_v%24.htm |
| V$DBLINK
|
| V$DBLINK. Data Dictionary View Columns. DB_LINK OWNER_ID LOGGED_ON HETEROGENEOUS PROTOCOL OPEN_CURSORS IN_TRANSACTION ... |
| http://ss64.com/orav/V%24DBLINK.html |
| If you access a database link in a session, then the link remains ...
|
| Jan 16, 2008 ... Even a select from a db link starts a distributed transaction and gets an undo block. ... YAS@10G>select sid from v$mystat where rownum=1; ... |
| http://coskan.wordpress.com/2008/01/16/if-you-access-a-database-link-in-a-sessio... |
| How can I close Oracle DbLinks in JDBC with XA datasources and ...
|
| create or replace procedure rollback_and_close_db_links authid current_user is begin rollback; for links in (select db_link from v$dblink) loop ... |
| http://stackoverflow.com/questions/5088934/how-can-i-close-oracle-dblinks-in-jdb... |
1