-
编辑 删除
menu issue
SELECT *FROM apps.fnd_compiled_menu_functionsWHERE menu_id = 80343AND function_id IN (SELECT function_idFROM apps.fnd_menu_entries_vlWHERE menu_id = 80343AND grant_flag = 'N')AND grant_flag = 'Y';UPDATE apps.fnd_compiled_menu_functionsSET grant_flag = 'N'WHERE menu_id = 80343AND function_id IN (SELECT function_idFROM apps.fnd_menu_entries_vlWHERE menu_id = 80343AND grant_flag = 'N')AND grant_flag = 'Y'; --7 records to be updatedCOMMIT;[@more@]
-
编辑 删除
dbms_sqltune
DECLARE my_task_name VARCHAR2(30); my_sqltext CLOB;BEGIN my_sqltext := 'SELECT *FROM lc_tun_tempWHERE to_char(lcid) = ''1'''; my_task_name := dbms_sqltune.create_tuning_task(sql_text => my_sqltext, bind_list => NULL, user_name => 'APPS', scope => 'COMPREHENSIVE', time
-
编辑 删除
Trace a Concurrent Request And Generate TKPROF File
Trace a Concurrent Request And Generate TKPROF FileOctober 5, 2008 · 1 CommentHello Friends, As in Oracle Application, there always need to tune programs , procedure and it is always difficult to make a perfect program, here i am trying to put a “How to” on tkprof and surely like to know if you find it useful.How to Trace a Concurrent Request And Generate TKPROF File Enable Tracing For The Concurrent Manager Program Responsibility: System Administrator Navigate: Concurrent > Program >
-
编辑 删除
通过后台创建用户及增加职责
DECLARE--By: Anil Passi--When Jun-2001v_session_id INTEGER := userenv('sessionid');v_user_name VARCHAR2(30) := upper('&Enter_User_Name');BEGIN--Note, can be executed only when you have apps password.-- Call the procedure to Creaet FND Userfnd_user_pkg.createuser(x_user_name => v_user_name,x_owner => '',x_unencrypted_password => 'oracle',x_session_number => v_session_id,x_start_date => SYSDATE - 10,x_end_date => SYSDATE + 100,x_last_logon_date => SYSDATE - 10,x_descriptio
-
编辑 删除
重建临时表空间
1.startup --启动数据库2.create temporary tablespace TEMP2 TEMPFILE @#/home2/oracle/oradata/sysmon/temp02.dbf@# SIZE 512M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED; --创建中转临时表空间3.alter database default temporary tablespace temp2; --改变缺省临时表空间 为刚刚创建的新临时表空间temp24.drop tablespace temp including contents and datafiles;--删除原来临时表空间5.create temporary tablespace TEMP TEMPFILE @#/home2/oracle/oradata/sysmon/temp01.dbf@# SIZE 512M REUSE AUTOEXTEND ON NEXT
-
编辑 删除
空间修改及查询
SELECT B.FILE_ID 文件ID号,B.TABLESPACE_NAME 表空间名,B.FILE_NAME 文件名,B.BYTES / 1024 / 1024 "空间(M)",(B.BYTES - SUM(NVL(A.BYTES, 0))) / 1024 / 1024 "已使用(M)",SUM(NVL(A.BYTES, 0)) / 1024 / 1024 "剩余空间(M)",SUM(NVL(A.BYTES, 0)) / (B.BYTES) * 100 剩余百分比FROM DBA_FREE_SPACE A,DBA_DATA_FILES BWHERE A.FILE_ID = B.FILE_IDAND B.TABLESPACE_NAME = 'POD' --GTDGROUP BY B.TABLESPACE_NAME,B.FILE_ID,B.FILE_NAME,B.BYTESORDER BY B.FILE_ID;SELECT d.status "Status"
