Peter Lin-被動投資紀錄

1.檢查Table space 的使用情況
語法：select a.tablespace_name,round((total-free)/total,3)*100 pecent
from (select tablespace_name,sum(bytes) free from dba_free_space group by tablespace_name) a,
(select tablespace_name,sum(bytes) total from dba_data_files group by tablespace_name) b
where a.tablespace_name=b.tablespace_name

 yum install -y sysstat
$ iostat -d -m -t 2 10
      2：代表每2秒更新一次資訊。 
      10：代表顯示10次結果就停止動作。 

語法 : vmstat [參數] 
參數 | 功能 

1) You need to first Create LCM Activity Rule using application P482405-LCM Activity Rule. For example as follows.
Status Obj.Ty Role L.Stat N.Stat Approved
1 E1PAGE *PUBLIC Editing PendingApproval
1 E1PAGE *PUBLIC PendingApproval Approved A
2) Then open application P982400 - User generated Content Management
2.1) Click Form Exit>IMport/Export Mgmt>Import
2.2) Click Add, "Screen title is Work With Importing User Generated Contents"
2.3) Click "Load Import File" Button
2.4) Select file "V28658-01.zip" which downloaded from e-delivery.oracle.com and click Load button
2.5) imported zip file should appear in grid. Click "OK"
2.6) on Screen "User Generated Content Management", click find, will show 9 E1Pages Records in Grid
2.7) click Form Exit> Admin > Activate
2.8) Click Find on screen "Activate User Generated Objects"
2.9) Click on small button in "Active" column for each row, this will "Green" the button. Close this screen after activating all the pages.
2.10) On screen "User Generated Content Management", Click Form Exit> Admin> Publish
2.11) On screen "Published User Generated Contents" click Publish by user role.
2.12) on screen "Publish EnterpriseOne Page By User/Role" input "*PUBLIC" in user role field and in grid select all 9 E1 pages records one by one.
2.13) Click ok and close application.
Now you will be able see E1Pages.

.     選單的TABLE在control table中，