Study Memo

DBA_LMT_FREE_SPACE
DBA_LMT_USED_EXTENTS
DBA_FREE_SPACE
DBA_FREE_SPACE_COALESCED
DBA_HIGH_WATER_MARK_STATISTICS

http://www.orafaq.com/node/854
http://www.dba-oracle.com/t_alter_table_move_shrink_space.htm
http://www.dba-oracle.com/t_alter_table_shrink_space_command.htm

http://www.orafaq.com/wiki/Oracle_database_FAQ#Where_can_one_find_the_high_water_mark_for_a_table.3F

EBS System Administrator

Core Security now includes a Role Based Access Control
model that builds on the existing Function Security and Data Security models.

Application
Concurrent Program
Function
Role
Responsibility
Concurrent Managers
The Standard manager is active all the time; it works 365 days a year, 24 hours a day. around the clock.

Oracle Application Object Library
Work Shift

Security
Role
Responsibility
Audit

Bidirectional Provisioning

McGraw.Oracle Procure-to-Pay Guide.2009.pdf
Request for Quotes (RFQ), Quotes, Requisitions,and Purchase Orders
Purchasing,iProcurement,iSupplier Portal,Services Procurement,Sourcing,Procurement Contracts,Approval Management,E-Business Tax,iExpenses,Payables,Payments,Subledger Accounting
location,ship-to,site,deliver-to
The SHIP-TO LOCATION determines the address where any product for this location is to be delivered to
SHIP TO SITEs,BILL-TO SITEs
cost of goods sold (COGS)
Accrual basis accounting 应计制会计 权责发生制会计
Cash basis accounting 现金收付制会计,收付实现制会计

Encumbrances are a type of accrual accounting
where items are recorded when a commitment is made, such as a requisition or purchase order,
as opposed to when the item is received (accrual accounting) or invoiced (cash accounting).

predate,backdate

McGraw.Oracle General Ledger Guide.2009.pdf

select
a.file_name,
a.bytes file_size_in_bytes,
(c.block_id+(c.blocks-1)) * &_BLOCK_SIZE HWM_BYTES,
a.bytes - ((c.block_id+(c.blocks-1)) * &_BLOCK_SIZE) SAVING
from dba_data_files a,
(select file_id,max(block_id) maximum
from dba_extents
group by file_id) b,
dba_extents c
where a.file_id = b.file_id
and c.file_id = b.file_id
and c.block_id = b.maximum
and c.tablespace_name = 'EXAMPLE'

http://www.orafaq.com/forum/t/93108/2/
select block_id,bytes,blocks
from dba_free_space
where tablespace_name = 'WXQ_TBS'
order by block_id

http://www.blogjava.net/wxqxs/archive/2009/02/02/260636.html
http://www.itpub.net/89735.html
http://www.dbapool.com/forumthread/topic_7715.html
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License