OracleÓû§¹ÜÀí
--´´½¨±í¿Õ¼ä
create tablespace Ãû³Æ
(
datafile='·¾¶\Ãû³Æ.ora',
size='50M',
autoextend='on'
)
/
--´´½¨ÁÙʱ±í¿Õ¼ä
create temporary tablespace Ãû³Æ
(
tempfile='·¾¶\Ãû³Æ.ora',
size='50M',
autoextend='on'
)
/
--´´½¨Óû§
create user Óû§Ãû idtenified by ÃÜÂë
/
--ΪÓû§Ö¸¶¨±í¿Õ¼äÓëÁÙʱ±í¿Õ¼ä
alter Óû§Ãû default tablespace ±í¿Õ¼äÃû
alter Óû§Ãû temporary tablespace ÁÙʱ±í¿Õ¼äÃû
/
--ΪÓû§ÊÚȨ
Grant connect,resource,create session£¨Á¬½Ó£©,
dba, create table, create view, create trigger,
select any table, create sequence, create procedure, create role,
grant any privilege, drop any role,
create public synonym, drop public synonym,SELECT ANY DICTIONARY to ̞
/
---»òÕßÖ±½Ó¸³ÓèoracleÌṩµÄ½ÇɫȨÏÞ
grant resource,connect to ̞
/
--ÐÞ¸ÄÓû§ÃÜÂë
alter user Óû§Ãû idtenified by ÐÂÃÜÂë
/
--ÈÃÓû§ÃÜÂëʧЧ
alter user ̞ password expire
/
--ËøסÓû§
alter user Óû§Ãû account lock£»
/
--ÊÍ·ÅÓû§
alter user Óû§Ãû account unlock£»
/
--·ÃÎÊÆäËûÓû§µÄ±í
grant select,delete,... on Óû§Ãû1.±í to Óû§Ãû2;
/
---»ØÊÕȨÏÞ
revoke select,delete,....on Óû§Ãû1.±í from Óû§Ãû2;
Ïà¹ØÎĵµ£º
1.LVM:
[root@vmfs ~]# pvdisplay
--- Physical volume ---
PV Name /dev/sdg
VG Name db_v4
PV Size  ......
Êý¾Ý±íµÄÁ¬½ÓÓÐ:
1¡¢ÄÚÁ¬½Ó(×ÔÈ»Á¬½Ó): Ö»ÓÐÁ½¸ö±íÏàÆ¥ÅäµÄÐвÅÄÜÔÚ½á¹û¼¯ÖгöÏÖ
2¡¢ÍâÁ¬½Ó: °üÀ¨
£¨1£©×óÍâÁ¬½Ó(×ó±ßµÄ±í²»¼ÓÏÞÖÆ)
£¨2£©ÓÒÍâÁ¬½Ó(ÓÒ±ßµÄ±í²»¼ÓÏÞÖÆ)
£¨3£©È«ÍâÁ¬½Ó(×óÓÒÁ½±í¶¼²»¼ÓÏÞÖÆ)
3¡¢×ÔÁ¬½Ó(Á¬½Ó·¢ÉúÔÚÒ»Õ ......
½ñÌì²Î¼ÓÁËOracle & SUNºÏ²¢ºóµÚÒ»´ÎÓëºÏ×÷»ï°é¼°¿Í»§µÄͨÆø»á¡£Õû¸ö»áÒé¸øÎҵĸоõÊÇ£ºOracleÐÛÐIJª²ª£¬SUNÒâÆø·ç·¢£¬¶øÎÒ×Ô¼º£¬ÐÄ»³ã·ã·¡£ OracleÓÐÁËSUN£¬ÄÇô´ÓÓ²¼þµ½Èí¼þOracleµÄ²úÆ·Ïß¾ÍÊ®·ÖÆ뱸ÁË¡£Oracle°ëÄêÇ°ÍƳö11gR2 for linux£¬½Ó×Åfor solar ......
select count(*) from t1;
Õâ¾ä»°±È½Ï¼òµ¥£¬µ«ºÜÓÐÐþ»ú£¡¶ÔÕâ¾ä»°ÔËÐеÄÀí½â£¬·´Ó³ÁËÄã¶ÔÊý¾Ý¿âµÄÀí½âÉî¶È£¡
½¨Á¢ÊµÑéµÄ´ó±íËût1
SQL> conn scott/tiger
ÒÑÁ¬½Ó¡£
SQL> drop table t1 purge;
±íÒÑɾ³ý¡£
SQL> create table t1 as select * from emp where 0=9;
±íÒÑ´´½¨¡£
SQL> insert into t1 sele ......
Wait Problem Potential Fix Sequential Read Indicates many index reads—tune the code (especially joins) Scattered Read Indicates many full table scans—tune the code; cache small tables ......