梦想有多远

首先概述一下oralce在windows和unix平台的差别

oracle在UNIX系统下是通过多个操作系统进程实现

oracle在windows下通过一个多线程的进程实现的

(全文…)

(全文…)

授予系统特权：

数据库： alter database ,alter system, audit system, audit any,
调试：debug connect session,debug any procedure
索引：create any index,alter any index,drop any index,
作业调度：create job,create any job,execute any program,execute any class,manage scheduler
过程： create procedure ,create any procedure,alter any procedure,drop any procedure execute any procedure

(全文…)

select name,phyrds,phywrts,readtim,writetim
         from v$filestat a,v$dbfile b
         where a.file# = b.file#
         order by readtim desc

(全文…)

Problem Description
——————-If “init.ora” resource_limit = true, and idle_time set in profile.