| 失效链接处理 |
|
oracle基础命o(h)ȝ PDF 下蝲
本站整理下蝲Q?/strong>
链接Q?a target="_blank">https://pan.baidu.com/s/1NKoezGYkKzD_CzZ-7bjgUg
提取码：(x)za2t
相关截图Q?/strong>
主要内容Q?/strong>
一、数据܇语句Q创建目?/div>
1、DOSH口的命令行使用sys理员登录oracle
sqlplus sys/sys@127.0.0.1/orcl as sysdba
2、创建数据导出目录，需要手工创建好对应文g夹，如D:\mydmp
create directory dump_dir as 'D:\mydmp';
3、ؓ(f)oracle的需要导出的数据用户授予讉K数据目录的权?/div>
Grant read,write on directory dump_dir to system;
二、常用oracle语句
1、创I间
create tablespace 表空?/div>
datafile '表空?dbf'
size 400M autoextend
on next 100M
maxsize unlimited;
2、创Z(f)时表I间
CREATE TEMPORARY TABLESPACE 临时表空?TEMPFILE
'临时表空?DBF' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED
TABLESPACE GROUP ''
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;
3、创建用?/div>
create user 用户
identified by "密码"
default tablespace 表空?/div>
temporary tablespace TEMP
profile DEFAULT;
4、用h?/div>
grant connect to 用户;
grant dba to 用户;
grant resource to 用户;
5、修改密?/div>
CMDQsqlplus / as sysdba;
sys as sysdba
alter user用户 identified by 新密?/div>
6、修Ҏ(gu)据库最大连接数
查看processes和sessions参数
SQL> show parameter processes
修改processes和sessions?/div>
alter system set processes=500 scope=spfile;
alter system set sessions=500 scope=spfile;
修改processes和sessions值必重启oracle服务器才能生?/div>
查询数据库当前进E的q接敎ͼ(x)
select count(*) from v$process;
查看数据库当前会(x)话的q接敎ͼ(x)
elect count(*) from v$session;
查看数据库的q发q接敎ͼ(x)
select count(*) from v$session where status='ACTIVE';
查看当前数据库徏立的?x)话情况Q?/div>
select sid,serial#,username,program,machine,status from v$session;
查询数据库允许的最大连接数Q?/div>
select value from v$parameter where name = 'processes';
或者：(x)show parameter processes;
修改数据库允许的最大连接数Q?/div>
alter system set processes = 300 scope = spfile;
(需要重启数据库才能实现q接数的修改)
重启数据库：(x)
SQL> shutdown immediate;
SQL> startup;
查看当前有哪些用h在用数据：(x)
select osuser,a.username,cpu_time/executions/1000000||'s',sql_fulltext,machine
from v$session a,v$sqlarea b
where a.sql_address = b.address
order by cpu_time/executions desc;
7、修Ҏ(gu)据库文g大小Q扩展表I间
ALTER DATABASE DATAFILE '表空?dbf'
AUTOEXTEND ON NEXT 100M
MAXSIZE unlimitedQ?/div>
|
| Java1234官方?5Q?/td> | 
|
| Java1234官方?5Q?/td> | 838462530 |
苏公|安?32061202001004?/p>
