- 浏览: 84262 次
- 性别:
- 来自: 深圳
文章分类
最新评论
-
guji528:
可以这样监控某Oracle用户已执行的sql:
--TEST用 ...
v$sql,v$sqlarea,v$sqltext区别 -
xiaoliu216:
印象深刻。。。
爱情守则
Oracle Net manages the flow of information from client computers to Oracle servers and forms the foundation of all networked computing in the Oracle environment. Oracle Net provides services that can be divided into five main categories: connectivity, directory services, scalability, security, and accessibility. Connectivity solutions include support for multiple protocols, multiple operating systems, and Java and Internet. Directory services provide an infrastructure to resolve Oracle service names through a centralized naming repository. Scalability solutions include Connection Manager and Oracle Shared Server. Security options include Oracle Advanced Security, which provides an additional layer of security options and robust support for many varieties of firewalls. Accessibility support includes Heterogeneous Services and support for calling external procedures. Oracle Net also provides connectivity to Java stored procedures and URL connections.
The names resolution methods available for clients include hostnaming, Oracle Easy Connect, localnaming, Oracle Internet Directory, and External Naming. Hostnaming, which can only be used if you are using TCP/IP, is mainly used for simple Oracle networks. Oracle Easy Connect is an extension of hostnaming and allows for
the inclusion of additional information such as the hostname and port specification. Localnaming is the most popular of the names resolution methods, and it uses the tnsnames.ora file,
which is typically located on each client, to resolve net service names. The client looks up the net service name in the tnsnames.ora file and uses the resulting connect descriptor information
to connect to the Oracle server. The hostnaming and localnaming methods are configured using
the Oracle Net Manager or Oracle Enterprise Manager. Oracle Internet Directory is a Lightweight
Directory Access Protocol (LDAP)–compliant server that provides for centralized management
of Oracle database connection identifier information. External Naming uses a non-
Oracle facility, such as DNS, to manage and resolve Oracle service names
The names resolution methods available for clients include hostnaming, Oracle Easy Connect, localnaming, Oracle Internet Directory, and External Naming. Hostnaming, which can only be used if you are using TCP/IP, is mainly used for simple Oracle networks. Oracle Easy Connect is an extension of hostnaming and allows for
the inclusion of additional information such as the hostname and port specification. Localnaming is the most popular of the names resolution methods, and it uses the tnsnames.ora file,
which is typically located on each client, to resolve net service names. The client looks up the net service name in the tnsnames.ora file and uses the resulting connect descriptor information
to connect to the Oracle server. The hostnaming and localnaming methods are configured using
the Oracle Net Manager or Oracle Enterprise Manager. Oracle Internet Directory is a Lightweight
Directory Access Protocol (LDAP)–compliant server that provides for centralized management
of Oracle database connection identifier information. External Naming uses a non-
Oracle facility, such as DNS, to manage and resolve Oracle service names
发表评论
-
Hp unix中问题解决方案讲解
2010-08-13 18:29 1062当我们经常操作Hp unix的时候,就会遇到在操作系统上rm掉 ... -
HP-UX下删除文件无法释放空间
2010-08-13 18:28 24901 引言 很多人会遇到在操作系统上rm掉一个大的文件,以解决 ... -
v$sql,v$sqlarea,v$sqltext区别
2009-12-17 13:11 3064v$sqltext 存储的是完整的SQL,SQL被分割 SQ ... -
oracle SYS_CONTEXT列表
2009-10-16 10:27 940select SYS_CONTEXT('USERENV', ... -
Oracle CONNECT BY 循环 错误
2009-10-10 23:16 1610java.sql.SQLException: ORA-0143 ... -
Oracle创建索引要做到三个适当
2009-09-28 11:59 2384在Oracle数据库中,创建 ... -
分布式oracle中databaselink
2009-09-21 20:31 1151数据库链接定义从一个Oracle数据库到另一个数据库的单行通信 ... -
oracle:java stored procedure or function
2009-09-20 14:35 1136--java source hasn't return val ... -
create oracle package
2009-09-20 14:15 4255一、程序包的相关知识 1.定义与说明 a. 相关对象的封装 ... -
Procedure to kill a session
2009-09-07 22:31 1004On the Oracle-L mailing list a ... -
oracle 动态SQL
2009-09-06 19:47 747sql_update := 'update ' || tabl ... -
1.Oracle游标大全;2.分析Oracle日志文件
2009-07-17 16:28 13031.Oracle游标大全 SELECT语句用于从数据库 ... -
PI 实时数据库系统
2009-07-17 10:21 2320PI 实时数据库系统(Plant Information Sy ... -
rlwrap使用方法
2008-12-04 15:45 1126在Windows操作系统上,当在DOS命令窗口中运行SQL*P ... -
recovery
2008-09-27 15:31 704Understanding the types of fail ... -
backup
2008-09-27 15:30 758The control files contain the m ... -
Database Maintenance
2008-09-24 16:11 771Oracle 10g provides many tools ... -
Assigning a Profile to a User
2008-09-19 15:04 924A profile serves two purposes: ... -
Sizing the Large Pool
2008-09-19 09:35 707select sum(value) "Max MTS ... -
Heterogeneous Services
2008-09-16 12:12 785Heterogeneous Services provide ...
相关推荐
Practical Oracle Database Appliance is for the Oracle database administrator or system administrator who currently manages, or will be implementing, the Oracle Database Appliance within a small- to ...
示例数据库模式为Oracle...Schema IX – Division Information Exchange manages shipping through B2B applications. Schema SH – Division Sales tracks business statistics to facilitate business decisions.
Transaction design in turn relies upon a good understanding of how the underlying database platform manages of the locking of resources so as to prevent access conflicts and data loss that might ...
Hotkey Manager Beta Version: Manages and implements hotkey in Windows 95/98/NT.
manages.pymanages.pymanages.pymanages.pymanages.pymanages.pymanages.pymanages.pymanages.pymanages.pymanages.pymanages.pymanages.pymanages.pymanages.py
This core infrastructure manages transactions and the ability to commit and roll back changes, protects the integrity of the database, enables backup and recovery, and allows for scalability to ...
1、Manages, 2、新闻浏览模块 3、运用C#及ASP.NEt技术
在原有的1.0版本上
程序加入了后台管理功能,对会员的资料可以任意进行编辑,修改,添加,删除.以及加入会员搜索等功能.由于时间紧迫,程序的邮件列表功能,在线升级功能
With virtually limitless scalability, it manages peak transaction volumes efficiently, improving business agility and letting IT organizations quickly react to changes in business demands and ...
vue + typescript课程后台管理系统。非常适合初学vue、typescript项目的小伙伴!
图书管理信息系统,可以实现图书借阅管理,读存盘等
虚拟机管理方法的文章,主要是针对微软的virtual
搭建HBase详细的步骤,是份非常好的材料
《数据库系统概念(第五版)》英文课后答案
阿尔弗雷德工作流包管理器工作流 :bomb: 该项目处于开发的早期阶段。 为它加星以关注其发展或做出贡献。 Alfred Workflow Package Manager 是一个用于管理 alfred 工作流的 Ruby on Rails 应用程序。...
plays audio songs and manages it..
PostgreSQL manages concurrency through multiversion concurrency control (MVCC)
This module handles ARP messages and ARP resolution and manages the ARP cache