![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
oracle
疏楼望月
见贤思齐,见不贤则内自省。
展开
-
Oracle Database Undo space explained
原文地址:http://blog.oracle48.nl/wordpress/oracle-database-undo-space-explained/In this blog post I will talk about the basic workings of Automatic Undo Management, which can cause ORA-01555 and ORA-300...转载 2017-09-02 17:03:47 · 293 阅读 · 0 评论 -
ORACLE的隔离级别
Oracle 支持的 2 种事务隔离级别 Read committed 和 SerializableRead committed 是默认的隔离级别。隔离级别(isolation level)l隔离级别定义了事务与事务之间的隔离程度。l隔离级别与并发性是互为矛盾的:隔离程度越高,数据库的并发性越差;隔离程度越低,数据库的并发性越好。...转载 2017-01-12 16:36:57 · 535 阅读 · 0 评论 -
where can down OCI Demonstration Programs
原文地址:http://stackoverflow.com/questions/6331024/does-oracle-really-offer-any-oci-demo-sample-programs最新下载地址:http://www.oracle.com/technetwork/database/enterprise-edition/downloads/database12c-l...翻译 2016-12-28 17:24:22 · 358 阅读 · 0 评论 -
ORA-12514 TNS:listener does not currently know of service requested in connect descriptor
原文地址:http://stackoverflow.com/questions/10786782/ora-12514-tnslistener-does-not-currently-know-of-service-requested-in-connect-d第一步:在数据库中查询数据库服务名称select value from v$parameter where name=...翻译 2016-12-23 16:45:03 · 672 阅读 · 0 评论 -
Linux下sqlplus远程访问Oracle
转载请注明:http://blog.csdn.net/fuqiangnxn/article/details/53841062第一步:下载instantclient,下载地址如下http://www.oracle.com/technetwork/database/features/instant-client/index-097480.htmlinstantclien...原创 2016-12-23 16:03:29 · 14965 阅读 · 2 评论 -
Oracle启动与停止命令
一:环境变量配置export ORACLE_BASE=$HOME/app/oracle;export ORACLE_HOME=$ORACLE_BASE/product/12.1.0/dbhome_1;export ORACLE_SID=orcl;export PATH=$ORACLE_HOME/bin:$PATH;export LD_LIBRARY_PATH=$ORACLE_H...原创 2019-06-29 09:43:23 · 1516 阅读 · 0 评论