您好,欢迎光临! 请 |

Plan is a keyword to succeed

Plan is a keyword to succeed

Planning is a key to the success of many scholars because it forces you to examine yourself, to improve your performance, and to help overcome the three inherent problems of humans - laziness, greed, and selfishness! If you want to succeed, be serious about this. 下载本文的PDF版本, 方便离线阅读转载

Oracle数据库基本常用命令

Oracle数据库基本常用命令

1、得到数据库名和创建日期 SELECT name, created, log_mode, open_mode FROM v$database; 2、ORACLE数据库的计算机的主机名,ORACLE数据库的实例名及ORACLE数据库管理系统的版本信息 SELECT host_name, instance_name, version FROM v$instance; 3、为了知道oracle数据库版本的一些特殊信息 select * from v$version; 4、获取控制文件名......

Oracle static and dynamic parameters

Oracle static and dynamic parameters

在Oracle中,从9i开始引入了spfile,也就是服务 器端初始化参数,有很多是可以支持在线修改的,也就是修改会马上生效,详细内容看下面的说明: The ISSYS_MODIFIABLE column in V$PARAMETER tells us whether the parameters are static or dynamic. Static parameters require the instance to be restarted while dynamic parameters ca......

Oracle background processes

Oracle background processes

1 数据库的物理结构和逻辑结构之间的关系由后台进程来维护和实现,后台进程由数据库来管理 2 只有当出现问题,才创建跟踪文件。后台进程追踪文件的命令约定和位置随操作系统和数据库版本而定 3 一般而言,追踪文件含有后台进程名和后台进程的操作系统进程ID。通过设定BACKGROUND_DUMP_DEST来指定后台进程追踪文件位置 4 排除数据库故障时......

Oracle Granule Size

Oracle Granule Size

A granule is a unit of contiguous virtual memory allocated to a process. Oracle instance If an Oracle instance starts up, it allocates the SGA (System Global Area) in granule sized memory units. The size of these granules depends on your database version and somtimes even on the operating system port. For examp......

DB_CACHE_SIZE

DB_CACHE_SIZE

In Oracle Database,the db_cache_size and db_nk_cache_size parameters determine the size of Database Buffer Cache. Default value If SGA_TARGET is set: If the parameter is not specified, then the default is 0 (internally determined by the Oracle Database). If the parameter is specified, then the user-specified value i......

ORA-03113: end-of-file on communicati

ORA-03113: end-of-file on communication channel

Tonight,after I did some changes on the parameter(processes,changed it from 150 default to 2),I issued the commands below: SQL> alter system set processes=2 scope=spfile; System altered. SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup; ORA-03113: end......

Can objects of the same Schema reside

Can objects of the same Schema reside in different tablespaces?

The answer is YES. For example ,if  one user have a table and a index schema,he/she can put the table and index into respective  tablespaces. 下载本文的PDF版本, 方便离线阅读转载

What is SYSTEM tablespace and whe

What is SYSTEM tablespace and when is it created?

Every Oracle database contains a tablespace named SYSTEM, which is automatically created when the database is created. The SYSTEM tablespace always contains the data dictionary tables for the entire database. 下载本文的PDF版本, 方便离线阅读转载

What are the components of logical data

What are the components of logical database structure of Oracle database?

There are tablespaces and database's schema objects. Generally,the logical database structure can be divided into TABLESPACES,SEGMENTS,EXTENTS,BLOCKS. 下载本文的PDF版本, 方便离线阅读转载