ORACLE DBA
Dsmbr
这个作者很懒,什么都没留下…
展开
-
PLSQL安装步骤
plsql原创 2022-09-21 17:46:31 · 52 阅读 · 0 评论 -
2021-09-17
ORACLE EBS常用表call fnd_global.APPS_INITIALIZE(1318,50583,401)select fnd_profile.VALUE(‘ORG_ID’) FROM DUALselect * from hr_operating_units hou where hou.organization_id=204–fndselect * from fnd_applicationselect * from fnd_application_tl where applicat原创 2021-09-17 08:23:36 · 694 阅读 · 0 评论 -
ORACLE查询表空间大小
ORACLE查询表空间大小–1、查看表空间的名称及大小SELECT t.tablespace_name, round(SUM(bytes / (1024 * 1024)), 0) ts_sizeFROM dba_tablespaces t, dba_data_files dWHERE t.tablespace_name = d.tablespace_nameGROUP BY t.tablespace_name;–2、查看表空间物理文件的名称及大小SELECT tablespace_name,原创 2020-12-16 10:15:02 · 255 阅读 · 0 评论