Saturday, November 21, 2009

ORA-01722: invalid number

ORA-01722: invalid number
Cause: The attempted conversion of a character string to a number failed because the character string was not a valid numeric literal. Only numeric fields or character fields containing numeric data may be used in arithmetic functions or expressions. Only numeric fields may be added to or subtracted from dates.
Action: Check the character strings in the function or expression. Check that they contain only numbers, a sign, a decimal point, and the character "E" or "e" and retry the operation.

ORA-06550:

ORA-06550: line string, column string:string
Cause: A PL/SQL compilation error has occurred. The numbers given for line and column are the location in the PL/SQL block where the error occurred.
Action: Refer to the following PL/SQL messages for more information about the error.

ORA-06512: at line

Error:
ORA-06512: at line
Cause:

This error message indicates the line number in the PLSQL code that the error resulted.
Action:

For example, if you had the following PLSQL code:
declare
v_number number(2);
begin
v_number := 100;
end;


You would receive the error message:
The first line of the error message (ie: ORA-06502) indicates the error that occurred, while the second line of the error message (ie: ORA-06512) indicates that the error occurred at line 4 of the PLSQL code.

Friday, November 20, 2009

ORA-12154 TNS:could not resolve service name

ORA-12154 TNS:could not resolve service name
ORA-12154 error occurs at the time of logon process to a database. This error indicates that the communication software (TNS) in Oracle ( SQL *Net or Net8 ) did not recognize the host/service name of the database specified in the connection parameters.

For a database name to be recognized, it must be resolved by Oracle Client. To resolve a name, Oracle client uses either a TNSNames.ora, A Directory Server or an Oracle Names Server. This error most likely indicates that the resolution is not working and that there is an error in the TNSNAMES.ORA or SQLNET.ORA. For database connectivity to work your database name has to be entered into the TNSNAMES.ORA at a minimum to make this work. In case you are using a directory or names server, we recommend that you check your sqlnet.ora file.

To fix the ORA 12154 error:

Check that the instance or database name is being typed in correctly. It is sometimes also referred to as the connect string of the database
Check the tns names.ora file to validate that the instance name has been entered correctly. If you are in Unix, validate that there are no control characters at the end of the instance or database name and that all paranthesis around the tns entry are properly terminated
If everything looks good in tnsnames.ora, validate that the domain name entry in sqlnet.ora is not conflicting with the full database name resolution.
If you are unable to find a solution, best practice is to delete and recreate the entry to eliminate any character or control character issues.
If the entry you are looking for in your tnsnames.ora is missing, use the following procedure to add a new entry using the SQL*Net Easy configuration utility.

Start>Programs>Oracle >SQL Net Easy Configuration.
Select the option to Add a new instance alias.
Enter the parameters are required in the forms. If you do not have this information, contact your dba.
Confirm the new entry.
Repeat for as many aliases as needed.
Tip : Most tnsnames issues arise out of multiple oracle homes, incorrect entries made somewhere in the file etc.
1. Try searching the drive to identify how many tnsnames.ora files you have
2. Try renaming the tnsnames.ora file in the oracle home where you are facing the issue and add just the entry you are having an issue with. If it works, you know that the issue is somewhere else in the file.
Tip for DBA's : Use a centralized naming service to avoid most issues with client connectivity and the generation of ORA-12154 errors.

Rapid Clone adcfgclone.pl Error

$ perl adcfgclone.pl appsTier oracle/crpappl/admin/ORACLE_APPSTIER.xml
Enter the APPS password [APPS]:

Running Rapid Clone with command:
perl oracle/crpcomn/clone/bin/adclone.pl java=oracle/crpcomn/clone/bin/../jre/1.3.1
mode=apply stage=oracle/crpcomn/clone/bin/.. component=appsTier
method=CUSTOM appctxtg=oracle/crpappl/admin/ORACLE_APPSTIER.xml
showProgress contextValidated=false

Beginning application tier Apply - Tue Apr 21 03:03:17 2009
Log file located at oracle/crpappl/admin/ORACLE_APPSTIER/log/ApplyAppsTier_04210303.log
RC-50004: Fatal: Error occurred in ApplyAppsTechStack:
Cannot proceed with ApplyAppsTechStack-the paths/ports in the context file are not valid

ERROR while running Apply...

ERROR: Failed to execute oracle/crpcomn/clone/bin/adclone.pl

Thursday, November 19, 2009

REP-3000: Internal error starting Oracle Toolkit

REP-3000: Internal error starting Oracle Toolkit

Metalink Note 279342.1

Fix
================
Set the following variables in the reports.sh file (which resides in
the $ORACLE_HOME/bin directory):

REPORTS_DEFAULT_DISPLAY = NO
LDR_CNTRL=MAXDATA = 0x80000000
DISPLAY =

Dblink Details

SELECT dl.owner
,dl.db_link
,dl.username login_name
,dl.host
,to_char(dl.created,'YYMMDD HH24:MI') crdate
FROM dba_db_links dl
ORDER BY dl.owner
,dl.db_link

ORA-01002: fetch out of sequence

ORA-01002: fetch out of sequence

Cause: This error means that a fetch has been attempted from a cursor which is no longer valid. Note that a PL/SQL cursor loop implicitly does fetches, and thus may also cause this error. There are a number of possible causes for this error, including: 1) Fetching from a cursor after the last row has been retrieved and the ORA-1403 error returned. 2) If the cursor has been opened with the FOR UPDATE clause, fetching after a COMMIT has been issued will return the error. 3) Rebinding any placeholders in the SQL statement, then issuing a fetch before reexecuting the statement.

Action: 1) Do not issue a fetch statement after the last row has been retrieved - there are no more rows to fetch. 2) Do not issue a COMMIT inside a fetch loop for a cursor that has been opened FOR UPDATE. 3) Reexecute the statement after rebinding, then attempt to fetch again.

How to get the 5th highest value from a table?

How to get the 5th highest value from a table?

Table:tblEmp
Fields Emp_Name,Emp_Salary

Emp_Name Emp_Salary
A 25000
B 35000
C 12000
D 50000
E 14000
F 18000
G 28000
H 50500
I 40000

From this table I want to konw who is getting 5th highest salary?


SELECT ROWNUM NUM_K, K.* FROM (SELECT ROWNUM NUM_M, M.*
FROM ( select A.EMPLID,A.EFFDT
from ( select * from ps_job where emplid = 'FHQ4' ORDER BY EFFDT DESC ) A
WHERE ROWNUM <= Variable ) M
ORDER BY EFFDT ASC ) K
WHERE ROWNUM <=1


Note :Where varaiable is the nth largest u want

Create Document in R12 Web ADI Menu Generates HTTP 404 File Not Found Error

Create Document in R12 Web ADI Menu Generates HTTP 404 File Not Found Error
Symptoms


When trying to use the function Create Document the following error is displayed:

HTTP 404 File Not Found Error
Steps To Reproduce:
===================
Navigation -
1. Log onto a Release 12 instance with WEB ADI Installed
2. Seleft Responsibility Oracle Web ADI
3. Select Create Document
Solution
1. Go into the responsibility System Administrator.
2. Navigate to System Administrator > Security > Responsibility > Define > Oracle web ADI Responsibility
3. Set the menu to Desktop Integration Menu and save
3. Retest the issue.
4. Migrate the solution as appropriate to other environments.

APP-FND-00804: Program error: Invalid arguments to the flexfield routines.

APP-FND-00804: Program error: Invalid arguments to the flexfield routines. Please inform your support representative that:

Routine FDFGST unable to find flexfield qualifier 2. The flexfield routines have been called incorrectly.

Make sure the flexfield qualifiers specified match those defined in the Register Key Flexfield form.

Uncosted Material Transactions with CSTPSISC.INS_STD_COST (70): ORA-20100

ERROR
CSTPSISC.INS_STD_COST (70): ORA-20100: File o0004044.tmp creation for FND_FILE failed.

STEPS
The issue can be reproduced at will with the following steps:

1. Submit transactions for costing.
2. Check the MMT for erred records.
Verified the issue as noted below:
Had customer run the diagnostics from Note 246467.1 and evaluated the resulting output files:
The transactions in MTL_MATERIAL_TRANSACTIONS are stuck. The following error occurs:
CSTPSISC.INS_STD_COST (70): ORA-20100: File o0004044.tmp creation for FND_FILE failed.


Cause
The issue is caused by the following setup:
The space allocated for the request log directory is
insufficient and needs to be increased to allow the transactions to be costed.
Solution
To implement the solution, please execute the following steps:

1. Please have your DBA allocate additional space for the request log to be written to. The
current error condition is due to insufficient space for the log file hence the portion of the
error which states: File o0004044.tmp creation for FND_FILE failed.

2. Ensure that sufficient space is available for the log.

3. Resubmit the transactions for costing from the application as follows:
Cost -> View Transactions -> Material Transactions Query for erred transactions and resubmit
from Tools menu.

Oracle Certification exams

Oracle Certification exams
Exam Code Exam Name
1z0-001 Introduction to Oracle: SQL and PL/SQL
1z0-007 Introduction to Oracle9i: SQL
1z0-013 Oracle8: Database Administration
1z0-014 Oracle8: Performance Tuning
1z0-016 Oracle8: Network Administration
1z0-020 Oracle8i: New Features for Administrators
1z0-023 Architecture and Administration
1z0-024 Performance Tuning
1z0-025 Backup and Recovery
1z0-026 Network Administration
1z0-030 Oracle9i: New Features for Administrators
1z0-031 Oracle9i:Database Fundamentals I
1z0-032 Oracle9i:Database Fundamentals II
1z0-033 Oracle9i:Performance Tuning
1z0-035 Oracle 7.3 & 8 to Oracle9i DBA OCP Upgrade
1z0-036 Managing Oracle 9i on Linux
1z0-040 Oracle Database 10g: New Features for Administrators
1z0-041 Oracle Database 10g: DBA Assessment
1z0-042 Oracle Database 10g: Administration I
1z0-043 Oracle Database 10g: Administration II
1z0-045 Oracle Database 10g: New Features for Oracle8i OCPs
1z0-046 Oracle Datebase 10g: Managing Oracle on Linux for DBAs
1z0-047 Oracle Database SQL Expert
1z0-048 Oracle Database 10g R2: Administering RAC
1z0-050 Oracle Database 11g: New Features for Administrators
1z0-051 Oracle Database: SQL Fundamentals I
1z0-052 Oracle Database 11g: Administration I
1z0-055 Oracle Database 11g: New Features for 9i OCPs
1z0-101 Develop PL/SQL Program Units
1z0-108 Oracle WebLogic Server 10g System Administration
1z0-121 Developer/2000: Build Forms I
1z0-122 Developer/2000: Build Forms II
1z0-123 Developer/2000: Build Reports
1z0-131 Oracle9i, Build Internet Applications I
1z0-132 Oracle9i, Build Internet Applications II
1z0-140 Oracle9i Forms Developer: New Features
1z0-141 Oracle9i Forms Developer: Build Internet Applications
1z0-146 Oracle Database 11g: Advanced PL/SQL
1z0-147 Oracle9i: Program with PL/SQL
1z0-200 Oracle 11i E-Business Essentials
1z0-202 Siebel 8 Consultant Exam
1z0-204 Oracle EBS R12: E-Business Essentials
1z0-208 Oracle Comm. Billing and Revenue Management: Server Developer
1z0-209 Oracle Comm. Billing & Revenue Mgmt: Server Administrator
1z0-211 Oracle 11i General Ledger
1z0-212 Oracle Payables 11i Fundamentals
1z0-213 Oracle Receivables 11i Fundamentals
1z0-216 Oracle EBS R12: General Ledger and Receivables Fundamentals
1z0-221 Oracle 11i Inventory Management Fundamentals
1z0-222 Oracle Purchasing 11i Fundamentals
1z0-223 Oracle Order Management 11i Fundamentals
1z0-231 Implement Oracle Workflow 11i
1z0-232 Oracle 11i Systems Administrator
1z0-233 Oracle 11i Install, Patch and Maintain Applications
1z0-235 Oracle 11i Applications DBA:Fundamentals I
1z0-236 11i Applications DBA Fundamentals II
1z0-241 PeopleSoft Application Developer I: People Tools & PeopleCode
1z0-242 PeopleSoft Application Developer II: Application Engine & Integration
1z0-255 Hyperion Essbase 7.1.2 Consultant
1Z0-257 Hyperion Financial Management4.1 Consultant
1z0-259 Hyperion Planning 4.1 Consultant
1z0-264 Hyperion Essbase Analytics9.3 Developer
1z0-265 Hyperion BI+ 9.3 Administrator
1z0-271 Hyperion Financial Management9.3 Administrator I&II
1z0-272 Hyperion Planning 9.3 Administrator I&II
1z0-273 Hyperion Financial Management 4.1 Administrator I&II
1z0-301 Oracle9iAS: Basic Administrations
1z0-311 Oracle Application Server 10g: Administration I
1z0-312 Oracle Application Server 10g:Administration II
1z0-402 Oracle Enterprise Linux: Fundamentals
1z0-403 Enterprise Linux System Administration
1z0-501 Java Certified Programmer
1z0-615 Siebel 7.7 Consultant Core Exam
1z0-640 Siebel 7.7 Analytics Data Warehouse Dev.Prof.Core Exam
1z1-007 Oracle9i SQL
1z1-031 Oracle9i Database Fundamentals
1z1-033 Oracle 9i Performance Tuning

ORA-00600 Internal error (contact support)

ORA-00600 Internal error (contact support)

For this error you have to contact Oracle support

Saturday, November 14, 2009

Multiple session list of a user

declare
cursor csess is select
s.osuser pu,
s.username su,
s.status stat,
s.sid ssid,
s.serial# sser,
lpad(p.spid,7) spid,
s.program txt
from v$process p,
v$session s
where p.addr=s.paddr
and s.username = upper('&1');

begin
dbms_output.put_line ('The Following Sessions are Traced');
dbms_output.put_line ('=================================');
dbms_output.put_line ('OS USER ORA USER STATUS SID SER# UNIX ID PROGRAM NAME');
dbms_output.put_line ('-------- -------- -------- ------- ------- ------- ----------------------------');
for rsess in csess loop
sys.dbms_system.set_sql_trace_in_session(rsess.ssid, rsess.sser, true);
dbms_output.put_line (rpad(rsess.pu,9) || rpad(rsess.su,9) || rpad(rsess.stat,9) || rpad(rsess.ssid,8) || rpad(rsess.sser,8) || rpad(rsess.spid,8) || rsess.txt) ;
end loop;
end;
/


The Following Sessions are Traced
=================================
OS USER ORA USER STATUS SID SER# UNIX ID PROGRAM NAME
-------- -------- -------- ------- ------- ------- ----------------------------
applbkp APPS INACTIVE 321 63 15565 JDBC Thin Client
applbkp APPS INACTIVE 352 64 15567 JDBC Thin Client
applbkp APPS INACTIVE 314 12763 12827 STANDARD@kmctapp2 (TNS V1-V3)
applbkp APPS ACTIVE 332 29 15569 JDBC Thin Client
applbkp APPS ACTIVE 319 45 15571 JDBC Thin Client
applbkp APPS INACTIVE 343 62 15573 JDBC Thin Client
applbkp APPS INACTIVE 371 37 15368 ICM@kmctapp2 (TNS V1-V3)
applbkp APPS INACTIVE 372 138 15411 FNDSM@kmctapp2 (TNS V1-V3)
APPS INACTIVE 330 95 15577
applbkp APPS INACTIVE 373 25 15413 FNDSM@kmctapp2 (TNS V1-V3)
APPS INACTIVE 389 45 15579
applbkp APPS INACTIVE 363 15853 12868 STANDARD@kmctapp2 (TNS V1-V3)
applbkp APPS INACTIVE 339 29 15126 JDBC Thin Client
applbkp APPS INACTIVE 313 10787 12270 STANDARD@kmctapp2 (TNS V1-V3)
applbkp APPS INACTIVE 370 44 15130 JDBC Thin Client
applbkp APPS INACTIVE 374 44 15133 JDBC Thin Client
applbkp APPS INACTIVE 346 52 15135 JDBC Thin Client
applbkp APPS INACTIVE 286 4061 10267 STANDARD@kmctapp2 (TNS V1-V3)
applbkp APPS INACTIVE 290 13107 12882 INVMGR@kmctapp2 (TNS V1-V3)
applbkp APPS INACTIVE 365 185 15746 JDBC Thin Client
APPS INACTIVE 356 50 15748
applbkp APPS INACTIVE 315 2211 12815 STANDARD@kmctapp2 (TNS V1-V3)
applbkp APPS INACTIVE 302 3283 12708 STANDARD@kmctapp2 (TNS V1-V3)
applbkp APPS INACTIVE 362 16 15425 IEU_WL_CS@kmctapp2 (TNS V1-V3)
applbkp APPS INACTIVE 367 43 15423 IEU_SH_CS@kmctapp2 (TNS V1-V3)
applbkp APPS INACTIVE 333 28 15428 OAMCOLMGR@kmctapp2 (TNS V1-V3)
APPS INACTIVE 334 45 15581
applbkp APPS INACTIVE 354 9414 12737 STANDARD@kmctapp2 (TNS V1-V3)
applbkp APPS INACTIVE 308 6527 12855 STANDARD@kmctapp2 (TNS V1-V3)
applbkp APPS INACTIVE 284 3877 29831 JDBC Thin Client
applbkp APPS INACTIVE 292 2863 12595 STANDARD@kmctapp2 (TNS V1-V3)
applbkp APPS INACTIVE 353 19 15474 KMCRCVTP@kmctapp2 (TNS V1-V3)
applbkp APPS INACTIVE 355 25 15471 KMCRCVTP@kmctapp2 (TNS V1-V3)
applbkp APPS ACTIVE 318 18 15510 PODAMGR@kmctapp2 (TNS V1-V3)
applbkp APPS INACTIVE 357 51 15482 KMCRCVTP@kmctapp2 (TNS V1-V3)
applbkp APPS INACTIVE 364 20 15480 KMCRCVTP@kmctapp2 (TNS V1-V3)
applbkp APPS INACTIVE 320 19 15489 KMCALERTMGR@kmctapp2 (TNS V1-V3)
applbkp APPS INACTIVE 335 16 15491 KMCALERTMGR@kmctapp2 (TNS V1-V3)
applbkp APPS INACTIVE 328 24 15493 KMCALERTMGR@kmctapp2 (TNS V1-V3)
APPS INACTIVE 378 57 15585
applbkp APPS INACTIVE 329 13 15498 AMSDMIN@kmctapp2 (TNS V1-V3)
applbkp APPS ACTIVE 326 17 15500 CRPINQMGR@kmctapp2 (TNS V1-V3)
applbkp APPS ACTIVE 342 164 15502 INVTMRPM@kmctapp2 (TNS V1-V3)
applbkp APPS INACTIVE 348 75 15504 CRM@kmctapp2 (TNS V1-V3)
applbkp APPS ACTIVE 324 22 15506 RCVOLTM@kmctapp2 (TNS V1-V3)
APPS INACTIVE 379 27 15589
applbkp APPS INACTIVE 325 17 15514 PASMGR@kmctapp2 (TNS V1-V3)
applbkp APPS INACTIVE 317 7 15518 MRPMGR@kmctapp2 (TNS V1-V3)
applbkp APPS INACTIVE 316 6 15520 FNDSCH@kmctapp2 (TNS V1-V3)
AdministrAPPS INACTIVE 345 10244 8707 plsqldev.exe
applbkp APPS INACTIVE 289 4042 3980 JDBC Thin Client
applbkp APPS INACTIVE 331 15708 12516 STANDARD@kmctapp2 (TNS V1-V3)
AdministrAPPS ACTIVE 351 8847 12501 plsqldev.exe
AdministrAPPS INACTIVE 366 10745 12601 plsqldev.exe
applbkp APPS INACTIVE 358 1230 24690 JDBC Thin Client
applbkp APPS INACTIVE 359 4891 4709 JDBC Thin Client

uncommited TRANSACTION

SQL> SELECT A.TERMINAL,A.OSUSER, A.USERNAME FROM V$SESSION A,V$TRANSACTION B
2 WHERE
3 B.SES_ADDR = A.SADDR AND
4 A.AUDSID <> USERENV('SESSIONID')
5 ;

TERMINAL OSUSER USERNAME
------------------------------ ------------------------------ --------
applbkp APPS

user transuction details


SQL> set timing on
SQL> SET HEADING ONprompt ******************* User Transactions Information ****************************************
SQL> column "UserName" format a8
SQL> column "DB Sid" format 999999
SQL> column "Unix Pid" format 99999999
SQL> column "Trnx_start_time" format a19
SQL> column "Current Time" format a19
SQL> column "Elapsed(mins)" format 999999999.99
SQL> column "Undo Name" format a09
SQL> column "Used Undo Blks" format a13
SQL> column "Used Undo Size(Kb)" format a17
SQL> column "Logical I/O(Blks)" format 99999999999999999
SQL> column "Logical I/O(Kb)" format 999999999999999
SQL> column "Physical I/O(Blks)" format 999999999999999999
SQL> column "Physical I/O(Kb)" format 999999999999999999
SQL> select a.username "UserName" ,
2 a.sid "DB Sid",
3 e.spid "Unix Pid",
4 to_char(to_date(b.start_time,'mm/dd/yy hh24:mi:ss'),'yyyy/mm/dd hh24:mi:ss') "Trnx_start_time",
5 to_char(sysdate,'yyyy/mm/dd hh24:mi:ss') "Current Time",
6 round(60*24*(sysdate-to_date(b.start_time,'mm/dd/yy hh24:mi:ss')),2) "Elapsed(mins)",
7 c.segment_name "Undo Name",
8 to_char(b.used_ublk*d.value/1024) "Used Undo Size(Kb)",
9 to_char(b.used_ublk) "Used Undo Blks",
10 b.log_io "Logical I/O(Blks)" ,
11 b.log_io*d.value/1024 "Logical I/O(Kb)",
12 b.phy_io "Physical I/O(Blks)",
13 b.phy_io*d.value/1024 "Physical I/O(Kb)",
14 a.PROGRAM
15 from v$session a,
16 v$transaction b,
17 dba_rollback_segs c,
18 v$parameter d,
19 V$PROCESS e
20 where b.ses_addr=a.saddr
21 and b.xidusn=c.segment_id
22 and d.name='db_block_size'
23 and e.ADDR=a.PADDR
24 order by 4;

UserName DB Sid Unix Pid Trnx_start_time Current Time Elapsed(mins) Undo Name Used Undo Size(Kb Used Undo Blk Logical I/O(Blks) Logical I/O(Kb) Physical I/O(Blks) Physical I/O(Kb) PROGRAM
-------- ------ -------- ------------------- ------------------- ------------- --------- ----------------- ------------- ----------------- --------------- ------------------ ------------------ ------------------------------------------------
APPS 316 15520 2009/11/14 11:04:08 2009/11/14 11:04:24 0.27 _SYSSMU18 8 1 3 24 0 0 FNDSCH@kmctapp2 (TNS V1-V3)
$


Executed in 0.032 seconds

SQL>

Table Locking Information

SET LINESIZE 10000
SET TRIMSPOOL ON
set timing off

prompt ******************** Table Locking Information *******************************************
SELECT SUBSTR(B.OWNER,1,8) "Owner",
B.OBJECT_TYPE,
SUBSTR(B.OBJECT_NAME,1,18) "Object_name" ,
DECODE(A.LOCKED_MODE,0,'None' ,1,'Null' ,
2,'Row-S',3,'Row-X' ,
4,'Share',5,'S/Row-X',
6,'Exclusive') "Locked_Mode",
A.SESSION_ID "Sess_ID",
SUBSTR(A.ORACLE_USERNAME,1,10) "User_name",
A.OS_USER_NAME "OS_User",
to_char(c.logon_time,'YYYY/MM/DD HH24:MI:SS') "Logon_Time"
FROM V$LOCKED_OBJECT A,DBA_OBJECTS B,v$session c
WHERE A.OBJECT_ID=B.OBJECT_ID
and a.session_id=c.sid
ORDER BY B.OWNER,B.OBJECT_TYPE,B.OBJECT_NAME;
prompt ******************* User Transactions Information ****************************************
column "UserName" format a8
column "DB Sid" format 999999
column "Unix Pid" format 99999999
column "Trnx_start_time" format a19
column "Current Time" format a19
column "Elapsed(mins)" format 999999999.99
column "Undo Name" format a09
column "Used Undo Blks" format a13
column "Used Undo Size(Kb)" format a17
column "Logical I/O(Blks)" format 99999999999999999
column "Logical I/O(Kb)" format 999999999999999
column "Physical I/O(Blks)" format 999999999999999999
column "Physical I/O(Kb)" format 999999999999999999
select a.username "UserName" ,
a.sid "DB Sid",
e.spid "Unix Pid",
to_char(to_date(b.start_time,'mm/dd/yy hh24:mi:ss'),'yyyy/mm/dd hh24:mi:ss') "Trnx_start_time",
to_char(sysdate,'yyyy/mm/dd hh24:mi:ss') "Current Time",
round(60*24*(sysdate-to_date(b.start_time,'mm/dd/yy hh24:mi:ss')),2) "Elapsed(mins)",
c.segment_name "Undo Name",
to_char(b.used_ublk*d.value/1024) "Used Undo Size(Kb)",
to_char(b.used_ublk) "Used Undo Blks",
b.log_io "Logical I/O(Blks)" ,
b.log_io*d.value/1024 "Logical I/O(Kb)",
b.phy_io "Physical I/O(Blks)",
b.phy_io*d.value/1024 "Physical I/O(Kb)",
a.PROGRAM
from v$session a,
v$transaction b,
dba_rollback_segs c,
v$parameter d,
V$PROCESS e
where b.ses_addr=a.saddr
and b.xidusn=c.segment_id
and d.name='db_block_size'
and e.ADDR=a.PADDR
order by 4;
prompt ******************************************************************************************
set timing on
SET HEADING ON

Friday, November 13, 2009

Active queries in oracle

SELECT OSUSER,
SERIAL#,
SQL_TEXT
FROM V$SESSION, V$SQL
WHERE V$SESSION.SQL_ADDRESS = V$SQL.ADDRESS
AND V$SESSION.STATUS = 'ACTIVE';

Oracle Schema Summery

SELECT OWNER "Owner",
SEGMENT_NAME "Segment Name",
SEGMENT_TYPE "Type",
HEADER_FILE "Header|File",
HEADER_BLOCK "Header|Block",
EXTENTS "Extents",
BLOCKS "Blocks"
FROM DBA_SEGMENTS
WHERE OWNER LIKE UPPER('&ownr') AND SEGMENT_NAME LIKE UPPER('&segt')


Output

4 APPS ASFB05300902P_BIN_OBJ_MAP TABLE 23 6523 1 16
5 APPS ASFB10261245P_LF_ATTRIB TABLE 23 6571 1 16
6 APPS ASFB10261245P_LF_OBJECT TABLE 23 6587 1 16
7 APPS ASFB10261245P_LF_OBJECT_TYPE TABLE 23 6603 1 16
8 APPS ASFB10261245P_LF_VALUE TABLE 23 6619 1 16
9 APPS ASFB10261245P_OBJ_MAP TABLE 23 6635 1 16
10 APPS ASFB10261245P_OBJ_TYPE_MAP TABLE 23 6651 1 16
11 APPS ASFB10261245P_PROFILE TABLE 23 6667 1 16
12 APPS ASFB10261245P_PROFILE_ATTRIB TABLE 23 6683 1 16
13 APPS ASF_FNDATTDOC05310236_BAK TABLE 23 6699 1 16
14 APPS ASF_FNDATTDOC06250902_BAK TABLE 23 6715 1 16
15 APPS ASF_FNDATTDOC10261245_BAK TABLE 23 6731 1 16
16 APPS ASF_OPP_MGR_MV TABLE 21 53819 1 16
17 APPS ASF_OPP_PRD_FRCST_MV TABLE 21 54811 1 16
18 APPS BIC_PS_SUMM_CC_MV TABLE 21 54939 1 16
19 APPS BIC_PS_SUMM_CU_MV TABLE 21 54651 1 16
20 APPS BIC_PS_SUMM_DT_MV TABLE 21 54171 1 16
21 APPS BIC_PS_SUMM_MS_MV TABLE 21 54763 1 16
22 APPS BIC_PS_SUMM_MV TABLE 21 54427 1 16
23 APPS BIC_P_SUMM_CC_MV TABLE 21 53787 1 16
24 APPS BIC_P_SUMM_CU_MV TABLE 21 53723 1 16
25 APPS BIC_P_SUMM_DT_MV TABLE 21 54027 1 16
26 APPS BIC_P_SUMM_MS_MV TABLE 21 53771 1 16
27 APPS BIC_P_SUMM_MV TABLE 21 54411 1 16
28 APPS BIC_P_SUMM_OR_MV TABLE 21 54059 1 16
29 APPS BIM_R_CAMP_AGING_MV TABLE 21 54795 1 16
30 APPS BIM_R_CAMP_DIM_AGING_MV TABLE 21 54235 1 16
31 APPS CN_COLUMN_MAPS_ALL_UPG TABLE 23 8091 1 16
32 APPS CZ_MESSAGE_QENTRIES TABLE 17 75 1 16
33 APPS SYS_IL0000029462C00028$$ LOBINDEX 17 107 1 16
34 APPS SYS_LOB0000029462C00028$$ LOBSEGMENT 17 91 1 16
35 APPS AQ$_CZ_MESSAGE_QENTRIES_T INDEX 17 123 1 16
36 APPS AQ$_CZ_MESSAGE_QENTRIES_I INDEX 17 139 1 16
37 APPS SYS_C004298 INDEX 17 155 1 16
38 APPS JTF_FM_RAPID_BP_QTBL TABLE 17 427 1 16
39 APPS SYS_IL0000029551C00028$$ LOBINDEX 17 459 1 16
40 APPS SYS_LOB0000029551C00028$$ LOBSEGMENT 17 443 1 16
41 APPS AQ$_JTF_FM_RAPID_BP_QTBL_T INDEX 17 475 1 16
42 APPS AQ$_JTF_FM_RAPID_BP_QTBL_I INDEX 17 491 1 16
43 APPS SYS_C004373 INDEX 17 507 1 16
44 APPS JTF_FM_RAPID_B_QTBL TABLE 17 523 1 16
45 APPS SYS_IL0000029567C00028$$ LOBINDEX 17 555 1 16
46 APPS SYS_LOB0000029567C00028$$ LOBSEGMENT 17 539 1 16
47 APPS AQ$_JTF_FM_RAPID_B_QTBL_T INDEX 17 571 1 16
48 APPS AQ$_JTF_FM_RAPID_B_QTBL_I INDEX 17 587 1 16
49 APPS SYS_C004386 INDEX 17 603 1 16
50 APPS JTF_FM_RAPID_ER_QTBL TABLE 17 619 1 16
51 APPS SYS_IL0000029578C00028$$ LOBINDEX 17 651 1 16
52 APPS SYS_LOB0000029578C00028$$ LOBSEGMENT 17 635 1 16
53 APPS AQ$_JTF_FM_RAPID_ER_QTBL_T INDEX 17 667 1 16
54 APPS AQ$_JTF_FM_RAPID_ER_QTBL_I INDEX 17 683 1 16
55 APPS SYS_C004389 INDEX 17 699 1 16
56 APPS JTF_FM_RAPID_MP_QTBL TABLE 17 715 1 16
57 APPS SYS_IL0000029593C00028$$ LOBINDEX 17 747 1 16
58 APPS SYS_LOB0000029593C00028$$ LOBSEGMENT 17 731 1 16
59 APPS AQ$_JTF_FM_RAPID_MP_QTBL_T INDEX 17 763 1 16
60 APPS AQ$_JTF_FM_RAPID_MP_QTBL_I INDEX 17 779 1 16
61 APPS SYS_C004404 INDEX 17 795 1 16
62 APPS JTF_FM_RAPID_M_QTBL TABLE 17 811 1 16
63 APPS SYS_IL0000029610C00028$$ LOBINDEX 17 843 1 16
64 APPS SYS_LOB0000029610C00028$$ LOBSEGMENT 17 827 1 16
65 APPS AQ$_JTF_FM_RAPID_M_QTBL_T INDEX 17 859 1 16
66 APPS AQ$_JTF_FM_RAPID_M_QTBL_I INDEX 17 875 1 16
67 APPS SYS_C004419 INDEX 17 891 1 16
68 APPS JTF_FM_RAPID_Q1_QTBL TABLE 17 907 1 16
69 APPS SYS_IL0000029623C00028$$ LOBINDEX 17 939 1 16
70 APPS SYS_LOB0000029623C00028$$ LOBSEGMENT 17 923 1 16
71 APPS AQ$_JTF_FM_RAPID_Q1_QTBL_T INDEX 17 955 1 16
72 APPS AQ$_JTF_FM_RAPID_Q1_QTBL_I INDEX 17 971 1 16
73 APPS SYS_C004421 INDEX 17 987 1 16
74 APPS JTF_FM_RAPID_Q2_QTBL TABLE 17 1003 1 16
75 APPS SYS_IL0000029635C00028$$ LOBINDEX 17 1035 1 16
76 APPS SYS_LOB0000029635C00028$$ LOBSEGMENT 17 1019 1 16
77 APPS AQ$_JTF_FM_RAPID_Q2_QTBL_T INDEX 17 1051 1 16
78 APPS AQ$_JTF_FM_RAPID_Q2_QTBL_I INDEX 17 1067 1 16
79 APPS SYS_C004434 INDEX 17 1083 1 16
80 APPS JTF_PF_LOGGING_TABLE TABLE 17 1099 1 16
81 APPS SYS_IL0000029653C00064$$ LOBINDEX 17 1195 1 16
82 APPS SYS_LOB0000029653C00064$$ LOBSEGMENT 17 1179 1 16
83 APPS SYS_IL0000029653C00063$$ LOBINDEX 17 1163 1 16
84 APPS SYS_LOB0000029653C00063$$ LOBSEGMENT 17 1147 1 16
85 APPS SYS_IL0000029653C00062$$ LOBINDEX 17 1131 1 16
86 APPS SYS_LOB0000029653C00062$$ LOBSEGMENT 17 1115 1 16
87 APPS AQ$_JTF_PF_LOGGING_TABLE_T INDEX 17 1211 1 16
88 APPS AQ$_JTF_PF_LOGGING_TABLE_I INDEX 17 1227 1 16
89 APPS SYS_C004439 INDEX 17 1243 1 16
90 APPS MTL_MMTT_BACKUP TABLE 23 10459 1 16
91 APPS MTL_MSNT_BACKUP TABLE 23 10475 1 16
92 APPS MTL_MTLT_BACKUP TABLE 23 10507 1 16
93 APPS MTL_MTRL_BACKUP TABLE 23 10523 1 16
94 APPS PLAN_TABLE TABLE 23 10539 1 16
95 APPS RCV_RMA_UPGRADE_ERRORS TABLE 23 10715 1 16
96 APPS RCV_RMA_UPGRADE_SUCCESS TABLE 23 10731 1 16
97 APPS TEMP_SR_CPT_UPGERR TABLE 23 10747 1 16
98 APPS TMP_TAB_PRIVS TABLE 23 10763 72 1152
99 APPS AP_SUPPLIERS_BACKUP_6050423 TABLE 24 154859 1 16
100 APPS IBE_SCT_SEARCH_MV TABLE 21 64219 1 16
101 APPS CSP_USAGE_ORG_MV TABLE 21 64155 1 16
102 APPS CSP_USAGE_REG_MV TABLE 21 11 1 16
103 APPS FND_REGISTRATIONS_U3 INDEX 13 65931 1 16
104 APPS JTF_IH_BULK_QTBL TABLE 18 3787 1 16
105 APPS SYS_C00127277 INDEX 17 3483 1 16
106 APPS SYS_IL0000217825C00033$$ LOBINDEX 18 3771 1 16
107 APPS SYS_LOB0000217825C00033$$ LOBSEGMENT 18 3755 1 16
108 APPS AQ$_JTF_IH_BULK_QTBL_T INDEX 18 4299 1 16
109 APPS AQ$_JTF_IH_BULK_QTBL_I INDEX 18 4347 1 16
110 APPS CSP_SUP_DEM_PL_MV TABLE 21 68763 1 16
111 APPS CSP_SUP_DEM_PN_MV TABLE 21 68747 1 16
112 APPS CSP_SUP_DEM_RH_MV TABLE 21 64075 1 16
113 APPS CSP_SUP_DEM_SUB_MV TABLE 21 64123 1 16
114 APPS OZF_ORDER_SALES_SUMRY_MV TABLE 21 68539 1 16
115 APPS AS_SUBORDINATE_REPS_MV TABLE 21 43 1 16
116 APPS AS_GROUP_MV TABLE 21 155 1 16
117 APPS CN_SCA_RULE_COND_VALS_MV TABLE 21 63819 1 16
118 APPS ASF10310702PERZ_OBJ_MAP_TEMP TABLE 23 59819 1 16
119 APPS ASF10310702PERZ_LF_OBJECT_TEMP TABLE 23 59835 1 16
120 APPS AMS_ACT_METRICS_MONTHLY_MV TABLE 21 363 1 16
121 APPS AMS_ACT_METRICS_QTRLY_MV TABLE 21 395 1 16
122 APPS AMS_ACT_METRICS_MONTHLY_MV_N1 INDEX 21 379 1 16
123 APPS AMS_ACT_METRICS_WEEKLY_MV TABLE 21 443 1 16
124 APPS ASF_LEADS_BIN_MV TABLE 21 411 1 16
125 APPS AMS_ACT_METRICS_QTRLY_MV_N1 INDEX 21 427 1 16
126 APPS AMS_ACT_METRICS_YEARLY_MV TABLE 21 475 1 16
127 APPS AMS_ACT_METRICS_WEEKLY_MV_N1 INDEX 21 459 1 16
128 APPS AMS_ACT_METRICS_YEARLY_MV_N1 INDEX 21 27 1 16
129 APPS AS_FORECAST_MV TABLE 21 491 1 16
130 APPS ASF_LEADS_CHN_MV TABLE 21 507 1 16
131 APPS ASF_LEADS_CHN_SUM_MV TABLE 21 523 1 16
132 APPS ASF_LEADS_CMP_MV TABLE 21 18859 1 16
133 APPS ASF_LEADS_CHN_MAIN_MV TABLE 21 18891 1 16
134 APPS ASF_LEADS_GRP_MV TABLE 21 19371 1 16
135 APPS ASF_LEADS_PRD_MAIN_MV TABLE 21 19387 1 16
136 APPS ASF_LEADS_PRD_MV TABLE 21 32795 1 16
137 APPS ASF_LEADS_CMP_MAIN_MV TABLE 21 32811 1 16
138 APPS ASF_LEADS_PRD_SUM_MV TABLE 21 32827 1 16
139 APPS ASF_LEADS_TOP_MV TABLE 21 32843 1 16
140 APPS ASF_OPP_CHN_MV TABLE 21 32875 1 16
141 APPS ASF_OPP_CHN_FRCST_MV TABLE 21 32891 1 16
142 APPS ASF_OPP_CMP_MV TABLE 21 32923 1 16
143 APPS ASF_OPP_PRD_MV TABLE 21 32955 1 16
144 APPS ASF_OPP_TOP_MV TABLE 21 53899 1 16
145 APPS ASF_OPP_CMP_FRCST_MV TABLE 21 53947 1 16
146 APPS ASF_OPP_TOP_FRCST_MV TABLE 21 54155 1 16
147 APPS ASF_VAR_MV TABLE 21 55051 1 16
148 APPS ASF_SC_BIN_FRCST_MV TABLE 21 55083 1 16
149 APPS ASF_WIN_LOSS_COMPTATOR_MV TABLE 21 63755 1 16
150 APPS ASF_WIN_LOSS_MV TABLE 21 63771 1 16
151 APPS ASF_WIN_LOSS_TOP5_MV TABLE 21 63787 1 16
152 APPS ASF_WIN_WON_TOP5_MV TABLE 21 63803 1 16
153 APPS CN_SCA_RULE_COND_VALS_MV_N1 INDEX 21 63835 1 16
154 APPS CN_SCA_RULE_COND_VALS_MV_N2 INDEX 21 63851 1 16
155 APPS CSY_GROUP_RESPN_RESOL_MV TABLE 21 63867 1 16
156 APPS CSY_AGENT_RESPN_RESOL_MV TABLE 21 63883 1 16
157 APPS CSY_RESOLUTION_QUALITY_MV TABLE 21 63899 1 16
158 APPS CSY_RESOLUTION_QUALITY_MV_U1 INDEX 21 63915 1 16
159 APPS CSY_GROUP_RESPN_RESOL_MV_U1 INDEX 21 63931 1 16
160 APPS CSY_AGENT_RESPN_RESOL_MV_U1 INDEX 21 64059 1 16
161 APPS CSP_SUP_DEM_RH_MV_N1 INDEX 21 64091 1 16
162 APPS CSP_SUP_DEM_RH_MV_N2 INDEX 21 64107 1 16
163 APPS CSP_SUP_DEM_SUB_MV_N1 INDEX 21 64139 1 16
164 APPS CSP_SUP_DEM_SUB_MV_N2 INDEX 21 64171 1 16
165 APPS CSP_SUP_DEM_SUB_MV_N3 INDEX 21 64187 1 16
166 APPS CSP_SUP_DEM_SUB_MV_N4 INDEX 21 64203 1 16
167 APPS OZF_EARNING_SUMMARY_MV TABLE 21 68507 1 16
168 APPS OZF_ORDER_SALES_SUMRY_N1 INDEX 21 68555 1 16
169 APPS OZF_ORDER_SALES_SUMRY_N2 INDEX 21 68571 1 16
170 APPS POA_REQ_001_MV_N1 INDEX PARTITION 21 112395 1 16
171 APPS POA_REQ_001_MV_N2 INDEX PARTITION 21 112507 1 16
172 APPS POA_REQ_001_MV_N2 INDEX PARTITION 21 112491 1 16
173 APPS POA_REQ_001_MV_N2 INDEX PARTITION 21 112475 1 16
174 APPS POA_REQ_001_MV_N2 INDEX PARTITION 21 112459 1 16
175 APPS POA_REQ_002_MV TABLE PARTITION 21 112587 1 16
176 APPS POA_REQ_002_MV TABLE PARTITION 21 112571 1 16
177 APPS POA_REQ_002_MV TABLE PARTITION 21 112555 1 16
178 APPS POA_REQ_002_MV TABLE PARTITION 21 112539 1 16
179 APPS I_SNAP$_POA_REQ_002_MV INDEX 21 112603 1 16
180 APPS POA_REQ_002_MV_N1 INDEX PARTITION 21 112667 1 16
181 APPS POA_REQ_002_MV_N1 INDEX PARTITION 21 112651 1 16
182 APPS POA_REQ_002_MV_N1 INDEX PARTITION 21 112635 1 16
183 APPS POA_REQ_002_MV_N1 INDEX PARTITION 21 112619 1 16
184 APPS POA_REQ_002_MV_N2 INDEX PARTITION 21 112731 1 16
185 APPS POA_REQ_002_MV_N2 INDEX PARTITION 21 112715 1 16
186 APPS POA_REQ_002_MV_N2 INDEX PARTITION 21 112699 1 16
187 APPS POA_REQ_002_MV_N2 INDEX PARTITION 21 112683 1 16
188 APPS ASF_WIN_LOSS_PRODCAT_MV TABLE 21 68587 1 16
189 APPS ASF_ROLLUP_MGR_MV TABLE 21 68603 1 16
190 APPS ASF_SC_BIN_MV TABLE 21 68619 1 16
191 APPS ASF_SCBINLD_MV TABLE 21 68635 1 16
192 APPS ASF_SCBINLD_SUMMV TABLE 21 68651 1 16
193 APPS ASF_SCBIN_SUMMV TABLE 21 68667 1 16
194 APPS ASF_SL_BIN_MV TABLE 21 68683 1 16
195 APPS ASF_SLBIN_SUMMV TABLE 21 68699 1 16
196 APPS ASF_SLBINLD_MV TABLE 21 68715 1 16
197 APPS ASF_SLBINLD_SUMMV TABLE 21 68731 1 16
198 APPS CSP_SUP_DEM_PN_MV_N1 INDEX 21 68779 1 16
199 APPS CSP_SUP_DEM_PL_MV_N1 INDEX 21 68795 1 16
200 APPS CSP_SUP_DEM_PN_MV_N2 INDEX 21 68811 1 16
201 APPS CSP_SUP_DEM_PN_MV_N3 INDEX 21 68827 1 16
202 APPS PV_ROLLUP_MGR_MV TABLE 21 68843 1 16
203 APPS PV_SL_BIN_MV TABLE 21 68859 1 16
204 APPS PV_SLBIN_SUM_MV TABLE 21 68875 1 16
205 APPS PV_SLBINAMT_SUM_MV TABLE 21 68891 1 16
206 APPS PV_PRD_BIN_MV TABLE 21 68907 1 16
207 APPS PV_PRD_BIN_SUM_MV TABLE 21 68923 1 16
208 APPS PV_CHN_BIN_MV TABLE 21 68939 1 16
209 APPS PV_CHN_BIN_SUM_MV TABLE 21 68955 1 16
210 APPS PV_AMS_BIN_MV TABLE 21 68971 1 16
211 APPS PV_AMS_BIN_SUM_MV TABLE 21 68987 1 16
212 APPS I_SNAP$_ISC_FS_012_MV INDEX 21 114795 1 16
213 APPS ISC_FS_010_MV_N2 INDEX 21 114811 1 16
214 APPS ISC_FS_012_MV_N1 INDEX 21 114827 1 16
215 APPS ISC_FS_012_MV_N2 INDEX 21 114843 1 16
216 APPS ISC_FS_013_MV TABLE 21 114859 1 16
217 APPS I_SNAP$_ISC_FS_013_MV INDEX 21 114875 1 16
218 APPS ISC_FS_013_MV_N1 INDEX 21 114891 1 16
219 APPS ISC_FS_013_MV_N2 INDEX 21 114907 1 16
220 APPS ISC_FS_014_MV TABLE 21 114923 1 16
221 APPS I_SNAP$_ISC_FS_014_MV INDEX 21 114939 1 16
222 APPS ISC_FS_014_MV_N1 INDEX 21 114955 1 16
223 APPS ASO_BI_TOP_RSG_MV TABLE 21 72939 1 16
224 APPS I_SNAP$_ASO_BI_TOP_RSG_MV INDEX 21 72955 1 16
225 APPS ISC_FS_014_MV_N2 INDEX 21 114971 1 16
226 APPS ISC_FS_016_MV TABLE 21 114987 1 16
227 APPS I_SNAP$_ISC_FS_016_MV INDEX 21 115003 1 16
228 APPS ISC_FS_016_MV_N1 INDEX 21 115019 1 16
229 APPS ISC_FS_016_MV_N2 INDEX 21 115035 1 16
230 APPS MLOG$_ASO_BI_TOP_RSG_MV TABLE 21 100507 1 16
231 APPS ISC_FS_016_MV_N3 INDEX 21 115051 1 16
232 APPS ISC_FS_020_MV TABLE 21 115067 1 16
233 APPS BIL_BI_GRP_CNT_MV TABLE 21 73035 1 16
234 APPS I_SNAP$_BIL_BI_GRP_CNT_MV INDEX 21 73051 1 16
235 APPS I_SNAP$_ISC_FS_020_MV INDEX 21 115083 1 16
236 APPS MLOG$_BIL_BI_GRP_CNT_MV TABLE 21 100411 1 16
237 APPS ISC_FS_020_MV_N1 INDEX 21 115099 1 16
238 APPS ISC_FS_020_MV_N2 INDEX 21 115115 1 16
239 APPS ISC_FS_019_MV TABLE 21 115131 1 16
240 APPS I_SNAP$_ISC_FS_019_MV INDEX 21 115147 1 16
241 APPS ISC_FS_019_MV_N1 INDEX 21 115163 1 16
242 APPS ISC_FS_019_MV_N2 INDEX 21 115179 1 16
243 APPS ISC_SAM_000_MV TABLE 21 115195 1 16
244 APPS ISC_FS_018_MV TABLE 21 115211 1 16
245 APPS I_SNAP$_ISC_FS_018_MV INDEX 21 115227 1 16
246 APPS ISC_SAM_000_MV_N1 INDEX 21 115243 1 16
247 APPS ISC_SAM_000_MV_N2 INDEX 21 115259 1 16
248 APPS ISC_SAM_000_MV_N3 INDEX 21 115275 1 16
249 APPS ISC_FS_018_MV_N1 INDEX 21 115291 1 16
250 APPS ISC_SAM_000_MV_N4 INDEX 21 115307 1 16
251 APPS ISC_FS_018_MV_N2 INDEX 21 115323 1 16
252 APPS ISC_SAM_000_MV_N7 INDEX 21 115339 1 16
253 APPS U_SNAP$_ISC_SAM_000_MV_N5 INDEX 21 115355 1 16
254 APPS U_SNAP$_ISC_SAM_000_MV_N6 INDEX 21 115371 1 16
255 APPS ISC_SAM_001_MV TABLE 21 115387 1 16
256 APPS ISC_SAM_001_MV_N1 INDEX 21 115403 1 16
257 APPS ISC_SAM_001_MV_N2 INDEX 21 115419 1 16
258 APPS ISC_SAM_001_MV_N3 INDEX 21 115435 1 16
259 APPS BIX_AO_CALL_DETAILS_MV TABLE 21 73451 1 16
260 APPS I_SNAP$_BIX_AO_CALL_DETAIL INDEX 21 73467 1 16
261 APPS BIX_AO_CALL_DETAILS_MV_N1 INDEX 21 73579 1 16
262 APPS BIX_AO_CALL_DETAILS_MV_N2 INDEX 21 73595 1 16
263 APPS ENI_DBI_BOM_COMPONENTS_MV1 TABLE 21 73835 1 16
264 APPS BIX_AO_CALL_DETAILS_MV_N3 INDEX 21 73627 1 16
265 APPS I_SNAP$_ENI_DBI_BOM_COMPON INDEX 21 73851 1 16
266 APPS ENI_DBI_CO_OBJIDS_MV TABLE 21 73931 1 16
267 APPS I_SNAP$_ENI_DBI_CO_OBJIDS_ INDEX 21 73947 1 16
268 APPS MLOG$_ENI_DBI_CO_OBJIDS_MV TABLE 21 74011 1 16
269 APPS ENI_DBI_GL_BASE_MV TABLE 21 74027 1 16
270 APPS I_SNAP$_ENI_DBI_GL_BASE_MV INDEX 21 74043 1 16
271 APPS ENI_DBI_CO_OBJIDS_MV_N1 INDEX 21 74059 1 16
272 APPS ENI_DBI_BOM_COMPONENTS_MV2 TABLE 21 74107 1 16
273 APPS I_SNAP$_ENI_DBI_BOM_COMPON1 INDEX 21 74123 1 16
274 APPS MLOG$_ENI_DBI_GL_BASE_MV TABLE 21 74139 1 16
275 APPS ISC_DBI_CFM_006_MV_N2 INDEX 21 75483 1 16
276 APPS ISC_DBI_CFM_005_MV TABLE 21 75499 1 16
277 APPS I_SNAP$_ISC_DBI_CFM_005_MV INDEX 21 75515 1 16
278 APPS ISC_DBI_CFM_013_MV TABLE 21 75531 1 16
279 APPS MLOG$_ISC_DBI_CFM_005_MV TABLE 21 75547 1 16
280 APPS MLOG$_ISC_DBI_CFM_013_MV TABLE 21 75563 1 16
281 APPS ISC_DBI_CFM_005_MV_N1 INDEX 21 75579 1 16
282 APPS ISC_DBI_CFM_013_MV_N1 INDEX 21 75595 1 16
283 APPS ISC_DBI_CFM_005_MV_N2 INDEX 21 75643 1 16
284 APPS ISC_DBI_CFM_013_MV_N2 INDEX 21 75659 1 16
285 APPS ISC_DBI_CFM_005_MV_N3 INDEX 21 75675 1 16
286 APPS ISC_DBI_CFM_013_MV_N3 INDEX 21 75691 1 16
287 APPS ISC_DBI_CFM_013_MV_N4 INDEX 21 75723 1 16
288 APPS ISC_DBI_CFM_013_MV_N5 INDEX 21 75739 1 16
289 APPS ISC_DBI_CPM_000_MV TABLE 21 75755 1 16
290 APPS I_SNAP$_ISC_DBI_CPM_000_MV INDEX 21 75771 1 16
291 APPS MLOG$_ISC_DBI_CPM_000_MV TABLE 21 75787 1 16
292 APPS ISC_DBI_CPM_000_MV_N1 INDEX 21 75803 1 16
293 APPS ISC_DBI_CPM_000_MV_N2 INDEX 21 75611 1 16
294 APPS ISC_DBI_CPM_000_MV_N3 INDEX 21 75627 1 16
295 APPS ISC_DBI_CPM_000_MV_N4 INDEX 21 75707 1 16
296 APPS ISC_DBI_FM_0003_MV TABLE 21 75819 1 16
297 APPS ISC_DBI_FM_0003_MV_N1 INDEX 21 75835 1 16
298 APPS ISC_DBI_FM_0003_MV_N2 INDEX 21 75851 1 16
299 APPS ISC_DBI_FM_0003_MV_N3 INDEX 21 75867 1 16
300 APPS ISC_DBI_FM_0000_MV TABLE 21 75883 1 16
301 APPS I_SNAP$_ISC_DBI_FM_0000_MV INDEX 21 75899 1 16
302 APPS MLOG$_ISC_DBI_FM_0000_MV TABLE 21 75915 1 16
303 APPS ISC_DBI_CPM_002_MV TABLE 21 75931 1 16
304 APPS I_SNAP$_ISC_DBI_CPM_002_MV INDEX 21 75947 1 16
305 APPS ISC_DBI_FM_0000_MV_N1 INDEX 21 75963 1 16
306 APPS ISC_DBI_FM_0000_MV_N2 INDEX 21 75979 1 16
307 APPS ISC_DBI_FM_0000_MV_N3 INDEX 21 75995 1 16
308 APPS MLOG$_ISC_DBI_CPM_002_MV TABLE 21 76011 1 16
309 APPS ISC_DBI_FM_0000_MV_N4 INDEX 21 76027 1 16
310 APPS ISC_DBI_CPM_002_MV_N1 INDEX 21 76043 1 16
311 APPS ISC_DBI_FM_0000_MV_N5 INDEX 21 76059 1 16
312 APPS ISC_DBI_FM_0001_MV TABLE 21 76075 1 16
313 APPS I_SNAP$_ISC_DBI_FM_0001_MV INDEX 21 76091 1 16
314 APPS ISC_DBI_CPM_002_MV_N2 INDEX 21 76107 1 16
315 APPS ISC_DBI_FM_0000_MV_N6 INDEX 21 76123 1 16
316 APPS ISC_DBI_CPM_002_MV_N3 INDEX 21 76139 1 16
317 APPS ISC_DBI_FM_0004_MV TABLE 21 76155 1 16
318 APPS ISC_DBI_CPM_002_MV_N4 INDEX 21 76171 1 16
319 APPS I_SNAP$_ISC_DBI_FM_0004_MV INDEX 21 76187 1 16
320 APPS ISC_DBI_FM_0001_MV_N1 INDEX 21 76203 1 16
321 APPS ISC_DBI_FM_0001_MV_N2 INDEX 21 76219 1 16
322 APPS ISC_DBI_FM_0001_MV_N3 INDEX 21 76235 1 16
323 APPS ISC_DBI_FM_0007_MV TABLE 21 76251 1 16
324 APPS ISC_DBI_FM_0007_MV_N1 INDEX 21 76267 1 16
325 APPS ISC_DBI_FM_0008_MV TABLE 21 76283 1 16
326 APPS ISC_DBI_FM_0007_MV_N2 INDEX 21 76299 1 16
327 APPS ISC_DBI_FM_0007_MV_N3 INDEX 21 76315 1 16
328 APPS ISC_DBI_SCR_003_MV TABLE 21 76347 1 16
329 APPS MLOG$_ISC_DBI_FM_0008_MV TABLE 21 76331 1 16
330 APPS I_SNAP$_ISC_DBI_SCR_003_MV INDEX 21 76363 1 16
331 APPS ISC_DBI_FM_0008_MV_N1 INDEX 21 76379 1 16
332 APPS ISC_DBI_SCR_003_MV_N1 INDEX 21 76395 1 16
333 APPS ISC_DBI_FM_0008_MV_N2 INDEX 21 76411 1 16
334 APPS ISC_DBI_SCR_003_MV_N2 INDEX 21 76427 1 16
335 APPS ISC_DBI_FM_0008_MV_N3 INDEX 21 76443 1 16
336 APPS ISC_DBI_SCR_003_MV_N3 INDEX 21 76459 1 16
337 APPS ISC_DBI_SCR_003_MV_N4 INDEX 21 76475 1 16
338 APPS ISC_DBI_SCR_003_MV_N5 INDEX 21 76491 1 16
339 APPS ISC_DBI_PM_0001_MV TABLE 21 76539 1 16
340 APPS I_SNAP$_ISC_DBI_PM_0001_MV INDEX 21 76555 1 16
341 APPS MLOG$_ISC_DBI_PM_0001_MV TABLE 21 76571 1 16
342 APPS ISC_DBI_PM_0001_MV_N1 INDEX 21 76587 1 16
343 APPS ISC_DBI_PM_0001_MV_N2 INDEX 21 76603 1 16
344 APPS ISC_DBI_PM_0001_MV_N3 INDEX 21 76507 1 16
345 APPS ISC_DR_BKLG_01_MV TABLE 21 76523 1 16
346 APPS I_SNAP$_ISC_DR_BKLG_01_MV INDEX 21 76619 1 16
347 APPS ISC_DBI_PM_0000_MV TABLE 21 76635 1 16
348 APPS I_SNAP$_ISC_DBI_PM_0000_MV INDEX 21 76651 1 16
349 APPS MLOG$_ISC_DR_BKLG_01_MV TABLE 21 76667 1 16
350 APPS ISC_DBI_PM_0000_MV_N1 INDEX 21 76731 1 16
351 APPS ISC_DR_BKLG_01_MV_N1 INDEX 21 76747 1 16
352 APPS ISC_DBI_PM_0000_MV_N2 INDEX 21 76763 1 16
353 APPS ISC_DR_BKLG_01_MV_N2 INDEX 21 76811 1 16
354 APPS ISC_DBI_PM_0000_MV_N3 INDEX 21 76827 1 16
355 APPS I_SNAP$_ISC_DR_CHARGES_01_ INDEX 21 76843 1 16
356 APPS ISC_DR_BKLG_01_MV_N3 INDEX 21 76859 1 16
357 APPS MLOG$_ISC_DR_CHARGES_01_MV TABLE 21 76875 1 16
358 APPS ISC_DR_CHARGES_01_MV_N1 INDEX 21 76891 1 16
359 APPS ISC_DR_CHARGES_01_MV_N2 INDEX 21 76923 1 16
360 APPS ISC_DR_CHARGES_01_MV_N3 INDEX 21 76971 1 16
361 APPS ISC_DR_COSTS_01_MV TABLE 21 76795 1 16
362 APPS I_SNAP$_ISC_DR_COSTS_01_MV INDEX 21 76939 1 16
363 APPS MLOG$_ISC_DR_COSTS_01_MV TABLE 21 77003 1 16
364 APPS ISC_DR_MTTR_01_MV TABLE 21 77051 1 16
365 APPS ISC_DR_COSTS_01_MV_N1 INDEX 21 99243 1 16
366 APPS I_SNAP$_ISC_DR_MTTR_01_MV INDEX 21 99275 1 16
367 APPS ISC_DR_COSTS_01_MV_N2 INDEX 21 99291 1 16
368 APPS ISC_DR_COSTS_01_MV_N3 INDEX 21 99307 1 16
369 APPS MLOG$_ISC_DR_MTTR_01_MV TABLE 21 99355 1 16
370 APPS ISC_DR_MTTR_01_MV_N1 INDEX 21 99371 1 16
371 APPS ISC_DBI_SCR_000_MV TABLE 21 99419 1 16
372 APPS ISC_DR_MTTR_01_MV_N2 INDEX 21 99451 1 16
373 APPS ISC_DR_MTTR_01_MV_N3 INDEX 21 100027 1 16
374 APPS MLOG$_ISC_DBI_SCR_000_MV TABLE 21 100043 1 16
375 APPS ISC_FS_007_MV TABLE 21 108939 1 16
376 APPS I_SNAP$_ISC_FS_007_MV INDEX 21 108955 1 16
377 APPS U_SNAP$_ISC_DBI_SCR_000_MV INDEX 21 108971 1 16
378 APPS ISC_FS_001_MV TABLE 21 108987 1 16
379 APPS I_SNAP$_ISC_FS_001_MV INDEX 21 109003 1 16
380 APPS MLOG$_ISC_FS_007_MV TABLE 21 109019 1 16
381 APPS ISC_FS_005_MV TABLE 21 109035 1 16
382 APPS I_SNAP$_ISC_FS_005_MV INDEX 21 109051 1 16
383 APPS MLOG$_ISC_FS_001_MV TABLE 21 109067 1 16
384 APPS ISC_FS_007_MV_N1 INDEX 21 109083 1 16
385 APPS ISC_FS_001_MV_N1 INDEX 21 109099 1 16
386 APPS ISC_FS_003_MV TABLE 21 109115 1 16
387 APPS ISC_FS_007_MV_N2 INDEX 21 109131 1 16
388 APPS I_SNAP$_ISC_FS_003_MV INDEX 21 109147 1 16
389 APPS MLOG$_ISC_FS_005_MV TABLE 21 109163 1 16
390 APPS ISC_FS_005_MV_N1 INDEX 21 109179 1 16
391 APPS MLOG$_ISC_FS_003_MV TABLE 21 109195 1 16
392 APPS ISC_FS_005_MV_N2 INDEX 21 109211 1 16
393 APPS ISC_FS_009_MV TABLE 21 109227 1 16
394 APPS I_SNAP$_ISC_FS_009_MV INDEX 21 109243 1 16
395 APPS ISC_FS_003_MV_N1 INDEX 21 109259 1 16
396 APPS ISC_FS_003_MV_N2 INDEX 21 109275 1 16
397 APPS ISC_FS_011_MV TABLE 21 109291 1 16
398 APPS I_SNAP$_ISC_FS_011_MV INDEX 21 109307 1 16
399 APPS MLOG$_ISC_FS_009_MV TABLE 21 109323 1 16
400 APPS MLOG$_ISC_FS_011_MV TABLE 21 109339 1 16
401 APPS ISC_FS_009_MV_N1 INDEX 21 109355 1 16
402 APPS ISC_FS_009_MV_N2 INDEX 21 109371 1 16
403 APPS ISC_FS_011_MV_N1 INDEX 21 109387 1 16
404 APPS ISC_FS_011_MV_N2 INDEX 21 109403 1 16
405 APPS ISC_TRN_000_MV TABLE 21 109419 1 16
406 APPS I_SNAP$_ISC_TRN_000_MV INDEX 21 109435 1 16
407 APPS ISC_TRN_000_MV_N1 INDEX 21 109451 1 16
408 APPS ISC_TRN_000_MV_N2 INDEX 21 109467 1 16
409 APPS ISC_TRN_001_MV TABLE 21 109483 1 16
410 APPS I_SNAP$_ISC_TRN_001_MV INDEX 21 109499 1 16
411 APPS ISC_TRN_000_MV_N3 INDEX 21 109515 1 16
412 APPS ISC_TRN_000_MV_N4 INDEX 21 109531 1 16
413 APPS ISC_TRN_000_MV_N5 INDEX 21 109547 1 16
414 APPS ISC_TRN_001_MV_N1 INDEX 21 109563 1 16
415 APPS ISC_TRN_002_MV TABLE 21 109579 1 16
416 APPS I_SNAP$_ISC_TRN_002_MV INDEX 21 109595 1 16
417 APPS ISC_TRN_001_MV_N2 INDEX 21 109611 1 16
418 APPS ISC_TRN_001_MV_N3 INDEX 21 109627 1 16
419 APPS ISC_TRN_002_MV_N1 INDEX 21 109643 1 16
420 APPS ISC_TRN_002_MV_N2 INDEX 21 109659 1 16
421 APPS ISC_TRN_002_MV_N3 INDEX 21 109675 1 16
422 APPS ISC_TRN_006_MV TABLE 21 109691 1 16
423 APPS I_SNAP$_ISC_TRN_006_MV INDEX 21 109707 1 16
424 APPS ISC_TRN_006_MV_N1 INDEX 21 109723 1 16
425 APPS ISC_TRN_006_MV_N2 INDEX 21 109739 1 16
426 APPS ISC_TRN_006_MV_N3 INDEX 21 109755 1 16
427 APPS ISC_TRN_003_MV TABLE 21 109771 1 16
428 APPS I_SNAP$_ISC_TRN_003_MV INDEX 21 109787 1 16
429 APPS ISC_TRN_003_MV_N1 INDEX 21 109803 1 16
430 APPS ISC_TRN_003_MV_N2 INDEX 21 109819 1 16
431 APPS ISC_TRN_003_MV_N3 INDEX 21 109835 1 16
432 APPS ISC_TRN_004_MV TABLE 21 109851 1 16
433 APPS I_SNAP$_ISC_TRN_004_MV INDEX 21 109867 1 16
434 APPS ISC_TRN_004_MV_N1 INDEX 21 109883 1 16
435 APPS ISC_TRN_004_MV_N2 INDEX 21 109899 1 16
436 APPS ISC_WMS_000_MV TABLE 21 109915 1 16
437 APPS I_SNAP$_ISC_WMS_000_MV INDEX 21 109931 1 16
438 APPS ISC_TRN_004_MV_N3 INDEX 21 109947 1 16
439 APPS ISC_WMS_000_MV_N1 INDEX 21 109963 1 16
440 APPS ISC_WMS_001_MV TABLE 21 109979 1 16
441 APPS I_SNAP$_ISC_WMS_001_MV INDEX 21 109995 1 16
442 APPS ISC_WMS_000_MV_N2 INDEX 21 110011 1 16
443 APPS ISC_WMS_000_MV_N3 INDEX 21 110027 1 16
444 APPS ISC_WMS_001_MV_N1 INDEX 21 110043 1 16
445 APPS ISC_WMS_001_MV_N2 INDEX 21 110059 1 16
446 APPS ISC_WMS_001_MV_N3 INDEX 21 110075 1 16
447 APPS ISC_WMS_001_MV_N4 INDEX 21 110091 1 16
448 APPS ISC_WMS_001_MV_N5 INDEX 21 110107 1 16
449 APPS JTF_TERR_CNRG_BTWN_MV_N1 INDEX 21 110139 1 16
450 APPS PJI_TIME_PA_RPT_STR_MV TABLE 21 78395 1 16
451 APPS PJI_TIME_TREND_MV TABLE 21 82171 1 16
452 APPS PJI_TIME_PA_RPT_STR_MV_N1 INDEX 21 82187 1 16
453 APPS PJI_TIME_TREND_MV_N1 INDEX 21 98939 1 16
454 APPS POA_API_BS_J_MV TABLE 21 78443 1 16
455 APPS MLOG$_POA_API_BS_J_MV TABLE 21 98987 1 16
456 APPS POA_IDL_BS_J_MV TABLE 21 78411 1 16
457 APPS MLOG$_POA_IDL_BS_J_MV TABLE 21 78475 1 16
458 APPS POA_NEG_000_MV TABLE 21 78427 1 16
459 APPS MLOG$_POA_NEG_000_MV TABLE 21 78507 1 16
460 APPS POA_MID_BS_J_MV TABLE 21 98907 1 16
461 APPS POA_POD_BS_J_MV TABLE 21 99035 1 16
462 APPS MLOG$_POA_MID_BS_J_MV TABLE 21 99051 1 16
463 APPS MLOG$_POA_POD_BS_J_MV TABLE 21 99067 1 16
464 APPS POA_REQ_000_MV TABLE PARTITION 21 78571 1 16
465 APPS POA_REQ_000_MV TABLE PARTITION 21 78555 1 16
466 APPS POA_REQ_000_MV TABLE PARTITION 21 78539 1 16
467 APPS POA_REQ_000_MV TABLE PARTITION 21 78523 1 16
468 APPS POA_REQ_000_MV_N1 INDEX PARTITION 21 99099 1 16
469 APPS POA_REQ_000_MV_N1 INDEX PARTITION 21 99083 1 16
470 APPS POA_REQ_000_MV_N1 INDEX PARTITION 21 98955 1 16
471 APPS POA_REQ_000_MV_N1 INDEX PARTITION 21 78587 1 16
472 APPS POA_REQ_000_MV_N2 INDEX PARTITION 21 112283 1 16
473 APPS POA_REQ_000_MV_N2 INDEX PARTITION 21 99211 1 16
474 APPS POA_REQ_000_MV_N2 INDEX PARTITION 21 99163 1 16
475 APPS POA_REQ_000_MV_N2 INDEX PARTITION 21 99147 1 16
476 APPS POA_REQ_001_MV TABLE PARTITION 21 112347 1 16
477 APPS POA_REQ_001_MV TABLE PARTITION 21 112331 1 16
478 APPS POA_REQ_001_MV TABLE PARTITION 21 112315 1 16
479 APPS POA_REQ_001_MV TABLE PARTITION 21 112299 1 16
480 APPS I_SNAP$_POA_REQ_001_MV INDEX 21 112363 1 16
481 APPS POA_REQ_001_MV_N1 INDEX PARTITION 21 112443 1 16
482 APPS POA_REQ_001_MV_N1 INDEX PARTITION 21 112427 1 16
483 APPS POA_REQ_001_MV_N1 INDEX PARTITION 21 112411 1 16
484 APPS ISC_TRN_005_MV TABLE 21 113947 1 16
485 APPS I_SNAP$_ISC_TRN_005_MV INDEX 21 113963 1 16
486 APPS ISC_TRN_005_MV_N1 INDEX 21 113979 1 16
487 APPS ISC_TRN_005_MV_N2 INDEX 21 113995 1 16
488 APPS ISC_TRN_005_MV_N3 INDEX 21 81275 1 16
489 APPS I_SNAP$_OKI_SRM_011_MV INDEX 21 81115 1 16
490 APPS OKI_SRM_011_MV_N1 INDEX 21 81131 1 16
491 APPS OKI_SRM_011_MV_N2 INDEX 21 81147 1 16
492 APPS OKI_RS_GROUP_MV TABLE 21 81163 1 16
493 APPS OKI_SRM_011_MV_N3 INDEX 21 81179 1 16
494 APPS MLOG$_OKI_RS_GROUP_MV TABLE 21 81211 1 16
495 APPS I_SNAP$_OKI_SRM_012_MV INDEX 21 81227 1 16
496 APPS OKI_SRM_012_MV_N1 INDEX 21 81387 1 16
497 APPS OKI_RS_GROUP_MV_N1 INDEX 21 81403 1 16
498 APPS I_SNAP$_OKI_SRM_015_MV INDEX 21 81451 1 16
499 APPS OKI_RS_GROUP_MV_N2 INDEX 21 81467 1 16
500 APPS OKI_SRM_012_MV_N2 INDEX 21 101579 1 16
501 APPS OKI_SRM_015_MV_N1 INDEX 21 101643 1 16
502 APPS OKI_SRM_012_MV_N3 INDEX 21 114011 1 16
503 APPS OKI_SRM_015_MV_N2 INDEX 21 114043 1 16
504 APPS I_SNAP$_OKI_SRM_013_MV INDEX 21 114059 1 16
505 APPS OKI_SRM_015_MV_N3 INDEX 21 114075 1 16
506 APPS OKI_SRM_013_MV_N1 INDEX 21 114091 1 16
507 APPS OKI_SRM_013_MV_N2 INDEX 21 114107 1 16
508 APPS OKI_SRM_013_MV_N3 INDEX 21 114123 1 16
509 APPS I_SNAP$_OKI_SRM_014_MV INDEX 21 114155 1 16
510 APPS I_SNAP$_OKI_SRM_016_MV INDEX 21 114187 1 16
511 APPS OKI_SRM_014_MV_N1 INDEX 21 114203 1 16
512 APPS OKI_SRM_014_MV_N2 INDEX 21 114219 1 16
513 APPS OKI_SRM_016_MV_N1 INDEX 21 114235 1 16
514 APPS OKI_SRM_014_MV_N3 INDEX 21 114267 1 16
515 APPS I_SNAP$_OKI_SRM_017_MV INDEX 21 114283 1 16
516 APPS OKI_SRM_016_MV_N2 INDEX 21 114299 1 16
517 APPS OKI_SRM_016_MV_N3 INDEX 21 114315 1 16
518 APPS OKI_SRM_017_MV_N1 INDEX 21 114331 1 16
519 APPS I_SNAP$_OKI_SRM_018_MV INDEX 21 114363 1 16
520 APPS OKI_SRM_017_MV_N2 INDEX 21 114379 1 16
521 APPS ASO_BI_QOT_CUSTB_MV TABLE 21 78619 1 16
522 APPS OKI_SRM_017_MV_N3 INDEX 21 114395 1 16
523 APPS OKI_SRM_018_MV_N1 INDEX 21 114427 1 16
524 APPS I_SNAP$_OKI_SRM_019_MV INDEX 21 114443 1 16
525 APPS OKI_SRM_018_MV_N2 INDEX 21 114459 1 16
526 APPS OKI_SRM_018_MV_N3 INDEX 21 114475 1 16
527 APPS I_SNAP$_OKI_SRM_020_MV INDEX 21 114507 1 16
528 APPS OKI_SRM_019_MV_N1 INDEX 21 114523 1 16
529 APPS OKI_SRM_019_MV_N2 INDEX 21 114539 1 16
530 APPS OKI_SRM_020_MV_N1 INDEX 21 114555 1 16
531 APPS OKI_SRM_019_MV_N3 INDEX 21 114571 1 16
532 APPS OKI_SRM_020_MV_N2 INDEX 21 114587 1 16
533 APPS OKI_SRM_020_MV_N3 INDEX 21 114603 1 16
534 APPS OPI_JOBS_001_MV TABLE 21 81243 1 16
535 APPS I_SNAP$_OPI_JOBS_001_MV INDEX 21 81259 1 16
536 APPS OPI_INV_ITD_ORG_MV TABLE 21 114619 1 16
537 APPS OPI_JOBS_001_MV_N1 INDEX 21 114635 1 16
538 APPS OPI_JOBS_001_MV_N2 INDEX 21 114651 1 16
539 APPS OPI_INV_ITD_ORG_MV_N1 INDEX 21 114667 1 16
540 APPS OPI_JOBS_001_MV_N3 INDEX 21 114683 1 16
541 APPS OPI_MTL_VAR_ACT_MV_F TABLE 21 77163 1 16
542 APPS I_SNAP$_OPI_MTL_VAR_ACT_MV INDEX 21 77179 1 16
543 APPS MLOG$_OPI_MTL_VAR_ACT_MV_F TABLE 21 77227 1 16
544 APPS OPI_MFG_VAR_SUM_MV TABLE 21 77195 1 16
545 APPS I_SNAP$_OPI_MFG_VAR_SUM_MV INDEX 21 77211 1 16
546 APPS OPI_MFG_VAR_SUM_MV_N1 INDEX 21 77243 1 16
547 APPS OPI_MFG_VAR_SUM_MV_N2 INDEX 21 77259 1 16
548 APPS OPI_MFG_VAR_SUM_MV_N3 INDEX 21 81323 1 16
549 APPS OPI_MTL_VAR_MV_F TABLE 21 81339 1 16
550 APPS I_SNAP$_OPI_MTL_VAR_MV_F INDEX 21 81435 1 16
551 APPS OPI_PROD_SCR_MV TABLE 21 81515 1 16
552 APPS I_SNAP$_OPI_PROD_SCR_MV INDEX 21 81531 1 16
553 APPS MLOG$_OPI_MTL_VAR_MV_F TABLE 21 81595 1 16
554 APPS MLOG$_OPI_PROD_SCR_MV TABLE 21 81611 1 16
555 APPS OPI_PGM_CBN_MV TABLE 21 77835 1 16
556 APPS OPI_PTP_ITEM_F_MV TABLE 21 77851 1 16
557 APPS MLOG$_OPI_PGM_CBN_MV TABLE 21 77867 1 16
558 APPS I_SNAP$_OPI_PTP_ITEM_F_MV INDEX 21 81627 1 16
559 APPS MLOG$_OPI_PTP_ITEM_F_MV TABLE 21 81643 1 16
560 APPS PJI_AC_CLSO_F_MV TABLE 21 81691 1 16
561 APPS I_SNAP$_PJI_AC_CLSO_F_MV INDEX 24 145611 1 16
562 APPS PJI_AV_ORGO_F_MV TABLE 21 81707 1 16
563 APPS PJI_AC_CLSO_F_MV_N1 INDEX 21 99131 1 16
564 APPS I_SNAP$_PJI_AV_ORGO_F_MV INDEX 24 145627 1 16
565 APPS PJI_AV_ORGO_F_MV_N1 INDEX 21 101483 1 16
566 APPS PJI_AC_ORGO_F_MV TABLE 21 101563 1 16
567 APPS I_SNAP$_PJI_AC_ORGO_F_MV INDEX 24 145643 1 16
568 APPS PJI_AC_ORGO_F_MV_N1 INDEX 21 101595 1 16
569 APPS PJI_CA_ORGO_F_MV TABLE 21 77883 1 16
570 APPS I_SNAP$_PJI_CA_ORGO_F_MV INDEX 22 145515 1 16
571 APPS PJI_CA_ORGO_F_MV_N1 INDEX 21 77899 1 16
572 APPS PJI_FP_CLSO_F_MV TABLE 21 77947 1 16
573 APPS I_SNAP$_PJI_FP_CLSO_F_MV INDEX 22 145531 1 16
574 APPS PJI_FP_CLSO_F_MV_N1 INDEX 21 81659 1 16
575 APPS PJI_FP_CLSO_ET_WT_F_MV TABLE 21 81675 1 16
576 APPS I_SNAP$_PJI_FP_CLSO_ET_WT_ INDEX 22 145547 1 16
577 APPS PJI_FP_CLSO_ET_WT_F_MV_N1 INDEX 21 81723 1 16
578 APPS PJI_FP_CLSO_ET_F_MV TABLE 21 81739 1 16
579 APPS I_SNAP$_PJI_FP_CLSO_ET_F_M INDEX 23 145819 1 16
580 APPS PJI_FP_CLSO_ET_F_MV_N1 INDEX 21 81755 1 16
581 APPS PJI_FP_ORGO_ET_WT_F_MV TABLE 21 81771 1 16
582 APPS I_SNAP$_PJI_FP_ORGO_ET_WT_ INDEX 24 145659 1 16
583 APPS PJI_FP_ORGO_ET_WT_F_MV_N1 INDEX 21 81787 1 16
584 APPS PJI_RM_JOBO_F_MV TABLE 21 81803 1 16
585 APPS I_SNAP$_PJI_RM_JOBO_F_MV INDEX 24 145675 1 16
586 APPS PJI_RM_JOBO_F_MV_N1 INDEX 21 81819 1 16
587 APPS PJI_FP_ORGO_ET_F_MV TABLE 21 81835 1 16
588 APPS I_SNAP$_PJI_FP_ORGO_ET_F_M INDEX 23 145835 1 16
589 APPS PJI_FP_ORGO_ET_F_MV_N1 INDEX 21 81851 1 16
590 APPS PJI_FP_ORGO_F_MV TABLE 21 81867 1 16
591 APPS I_SNAP$_PJI_FP_ORGO_F_MV INDEX 24 145691 1 16
592 APPS PJI_FP_ORGO_F_MV_N1 INDEX 21 81883 1 16
593 APPS POA_API_001_MV TABLE PARTITION 21 81931 1 16
594 APPS POA_API_001_MV TABLE PARTITION 21 81915 1 16
595 APPS POA_API_001_MV TABLE PARTITION 21 81899 1 16
596 APPS I_SNAP$_POA_API_001_MV INDEX 21 81947 1 16
597 APPS MLOG$_POA_API_001_MV TABLE 21 81963 1 16
598 APPS POA_API_001_MV_N1 INDEX PARTITION 21 82011 1 16
599 APPS POA_API_001_MV_N1 INDEX PARTITION 21 81995 1 16
600 APPS POA_API_001_MV_N1 INDEX PARTITION 21 81979 1 16
601 APPS POA_API_001_MV_N2 INDEX PARTITION 21 82059 1 16
602 APPS POA_API_001_MV_N2 INDEX PARTITION 21 82043 1 16
603 APPS POA_API_001_MV_N2 INDEX PARTITION 21 82027 1 16
604 APPS PJI_RM_WTO_F_MV TABLE 21 82075 1 16
605 APPS I_SNAP$_PJI_RM_WTO_F_MV INDEX 22 145563 1 16
606 APPS PJI_RM_WTO_F_MV_N1 INDEX 21 82091 1 16
607 APPS POA_IDL_001_MV TABLE PARTITION 21 82139 1 16
608 APPS POA_IDL_001_MV TABLE PARTITION 21 82123 1 16
609 APPS POA_IDL_001_MV TABLE PARTITION 21 82107 1 16
610 APPS I_SNAP$_POA_IDL_001_MV INDEX 21 82155 1 16
611 APPS PJI_RM_ORGO_F_MV TABLE 21 82203 1 16
612 APPS MLOG$_POA_IDL_001_MV TABLE 21 82219 1 16
613 APPS I_SNAP$_PJI_RM_ORGO_F_MV INDEX 23 145851 1 16
614 APPS POA_IDL_001_MV_N1 INDEX PARTITION 21 82267 1 16
615 APPS POA_IDL_001_MV_N1 INDEX PARTITION 21 82251 1 16
616 APPS POA_IDL_001_MV_N1 INDEX PARTITION 21 82235 1 16
617 APPS POA_API_BS_MV TABLE PARTITION 21 82587 1 16
618 APPS POA_API_BS_MV TABLE PARTITION 21 82491 1 16
619 APPS POA_API_BS_MV TABLE PARTITION 21 82283 1 16
620 APPS POA_IDL_001_MV_N2 INDEX PARTITION 21 82635 1 16
621 APPS POA_IDL_001_MV_N2 INDEX PARTITION 21 82619 1 16
622 APPS POA_IDL_001_MV_N2 INDEX PARTITION 21 82603 1 16
623 APPS I_SNAP$_POA_API_BS_MV INDEX 21 82651 1 16
624 APPS PJI_RM_ORGO_F_MV_N1 INDEX 21 82667 1 16
625 APPS POA_BM_ITEM_O_MV TABLE 21 82683 1 16
626 APPS I_SNAP$_POA_BM_ITEM_O_MV INDEX 21 82699 1 16
627 APPS POA_API_BS_MV_N1 INDEX PARTITION 21 82747 1 16
628 APPS POA_API_BS_MV_N1 INDEX PARTITION 21 82731 1 16
629 APPS POA_API_BS_MV_N1 INDEX PARTITION 21 82715 1 16
630 APPS POA_API_BS_MV_N2 INDEX PARTITION 21 82795 1 16
631 APPS POA_API_BS_MV_N2 INDEX PARTITION 21 82779 1 16
632 APPS POA_API_BS_MV_N2 INDEX PARTITION 21 82763 1 16
633 APPS MLOG$_POA_BM_ITEM_O_MV TABLE 21 82811 1 16
634 APPS POA_API_BS_MV_N3 INDEX PARTITION 21 82987 1 16
635 APPS POA_API_BS_MV_N3 INDEX PARTITION 21 82971 1 16
636 APPS POA_API_BS_MV_N3 INDEX PARTITION 21 82827 1 16
637 APPS POA_BM_ITEM_O_MV_U1 INDEX 21 83003 1 16
638 APPS POA_BM_ITEM_S_MV TABLE 21 82411 1 16
639 APPS I_SNAP$_POA_BM_ITEM_S_MV INDEX 21 82427 1 16
640 APPS MLOG$_POA_BM_ITEM_S_MV TABLE 21 82443 1 16
641 APPS POA_BM_ITEM_S_MV_U1 INDEX 21 82459 1 16
642 APPS POA_NEG_001_MV TABLE PARTITION 21 82379 1 16
643 APPS POA_NEG_001_MV TABLE PARTITION 21 82363 1 16
644 APPS POA_NEG_001_MV TABLE PARTITION 21 82347 1 16
645 APPS POA_NEG_001_MV TABLE PARTITION 21 82331 1 16
646 APPS I_SNAP$_POA_NEG_001_MV INDEX 21 82395 1 16
647 APPS POA_IDL_BS_MV TABLE PARTITION 21 82859 1 16
648 APPS POA_IDL_BS_MV TABLE PARTITION 21 82843 1 16
649 APPS POA_IDL_BS_MV TABLE PARTITION 21 82475 1 16
650 APPS I_SNAP$_POA_IDL_BS_MV INDEX 21 82875 1 16
651 APPS POA_NEG_001_MV_N1 INDEX PARTITION 21 82939 1 16
652 APPS POA_NEG_001_MV_N1 INDEX PARTITION 21 82923 1 16
653 APPS POA_NEG_001_MV_N1 INDEX PARTITION 21 82907 1 16
654 APPS POA_NEG_001_MV_N1 INDEX PARTITION 21 82891 1 16
655 APPS POA_NEG_001_MV_N2 INDEX PARTITION 21 83131 1 16
656 APPS POA_NEG_001_MV_N2 INDEX PARTITION 21 83115 1 16
657 APPS POA_NEG_001_MV_N2 INDEX PARTITION 21 83019 1 16
658 APPS POA_NEG_001_MV_N2 INDEX PARTITION 21 82955 1 16
659 APPS POA_IDL_BS_MV_N1 INDEX PARTITION 21 83179 1 16
660 APPS POA_IDL_BS_MV_N1 INDEX PARTITION 21 83163 1 16
661 APPS POA_IDL_BS_MV_N1 INDEX PARTITION 21 83147 1 16
662 APPS POA_NEG_001_MV_N3 INDEX PARTITION 21 83243 1 16
663 APPS POA_NEG_001_MV_N3 INDEX PARTITION 21 83227 1 16
664 APPS POA_NEG_001_MV_N3 INDEX PARTITION 21 83211 1 16
665 APPS POA_NEG_001_MV_N3 INDEX PARTITION 21 83195 1 16
666 APPS POA_IDL_BS_MV_N2 INDEX PARTITION 21 83291 1 16
667 APPS POA_IDL_BS_MV_N2 INDEX PARTITION 21 83275 1 16
668 APPS POA_IDL_BS_MV_N2 INDEX PARTITION 21 83259 1 16
669 APPS POA_MID_BS_MV TABLE PARTITION 21 82539 1 16
670 APPS POA_MID_BS_MV TABLE PARTITION 21 82523 1 16
671 APPS POA_MID_BS_MV TABLE PARTITION 21 82507 1 16
672 APPS I_SNAP$_POA_MID_BS_MV INDEX 21 82555 1 16
673 APPS POA_MID_BS_MV_N1 INDEX PARTITION 21 83323 1 16
674 APPS POA_MID_BS_MV_N1 INDEX PARTITION 21 83307 1 16
675 APPS POA_MID_BS_MV_N1 INDEX PARTITION 21 82571 1 16
676 APPS POA_MID_BS_MV_N2 INDEX PARTITION 21 83371 1 16
677 APPS POA_MID_BS_MV_N2 INDEX PARTITION 21 83355 1 16
678 APPS POA_MID_BS_MV_N2 INDEX PARTITION 21 83339 1 16
679 APPS POA_POD_001_MV TABLE PARTITION 21 83435 1 16
680 APPS POA_POD_001_MV TABLE PARTITION 21 83419 1 16
681 APPS POA_POD_001_MV TABLE PARTITION 21 83403 1 16
682 APPS POA_POD_001_MV TABLE PARTITION 21 83387 1 16
683 APPS I_SNAP$_POA_POD_001_MV INDEX 21 83451 1 16
684 APPS MLOG$_POA_POD_001_MV TABLE 21 83467 1 16
685 APPS POA_POD_001_MV_N1 INDEX PARTITION 21 83515 1 16
686 APPS POA_POD_001_MV_N1 INDEX PARTITION 21 83499 1 16
687 APPS POA_POD_001_MV_N1 INDEX PARTITION 21 83483 1 16
688 APPS POA_POD_001_MV_N1 INDEX PARTITION 21 78603 1 16
689 APPS POA_POD_001_MV_N2 INDEX PARTITION 21 83579 1 16
690 APPS POA_POD_001_MV_N2 INDEX PARTITION 21 83563 1 16
691 APPS OPI_INV_TYP_ORG_MV TABLE 21 81291 1 16
692 APPS I_SNAP$_OPI_INV_TYP_ORG_MV INDEX 21 81307 1 16
693 APPS POA_POD_001_MV_N2 INDEX PARTITION 21 83547 1 16
694 APPS POA_POD_001_MV_N2 INDEX PARTITION 21 83531 1 16
695 APPS ASO_BI_QOT_DISC_MV TABLE 21 83595 1 16
696 APPS OPI_INV_TYP_ORG_MV_N1 INDEX 21 81355 1 16
697 APPS ASO_BI_QOT_DISC_MV_N1 INDEX 21 83611 1 16
698 APPS OPI_INV_TYP_ORG_MV_N2 INDEX 21 81371 1 16
699 APPS POA_POD_BS_MV TABLE PARTITION 21 83691 1 16
700 APPS POA_POD_BS_MV TABLE PARTITION 21 83675 1 16
701 APPS POA_POD_BS_MV TABLE PARTITION 21 83659 1 16
702 APPS POA_POD_BS_MV TABLE PARTITION 21 83643 1 16
703 APPS POA_POD_BS_MV TABLE PARTITION 21 83627 1 16
704 APPS I_SNAP$_POA_POD_BS_MV INDEX 21 83707 1 16
705 APPS POA_POD_BS_MV_N1 INDEX PARTITION 21 83787 1 16
706 APPS POA_POD_BS_MV_N1 INDEX PARTITION 21 83771 1 16
707 APPS POA_POD_BS_MV_N1 INDEX PARTITION 21 83755 1 16
708 APPS POA_POD_BS_MV_N1 INDEX PARTITION 21 83739 1 16
709 APPS POA_POD_BS_MV_N1 INDEX PARTITION 21 83723 1 16
710 APPS POA_RTX_BS_J_MV TABLE 21 83803 1 16
711 APPS POA_POD_BS_MV_N2 INDEX PARTITION 21 83883 1 16
712 APPS POA_POD_BS_MV_N2 INDEX PARTITION 21 83867 1 16
713 APPS POA_POD_BS_MV_N2 INDEX PARTITION 21 83851 1 16
714 APPS POA_POD_BS_MV_N2 INDEX PARTITION 21 83835 1 16
715 APPS POA_POD_BS_MV_N2 INDEX PARTITION 21 83819 1 16
716 APPS POA_POD_BS_MV_N3 INDEX PARTITION 21 83963 1 16
717 APPS POA_POD_BS_MV_N3 INDEX PARTITION 21 83947 1 16
718 APPS POA_POD_BS_MV_N3 INDEX PARTITION 21 83931 1 16
719 APPS POA_POD_BS_MV_N3 INDEX PARTITION 21 83915 1 16
720 APPS POA_POD_BS_MV_N3 INDEX PARTITION 21 83899 1 16
721 APPS POA_POD_BS_MV_N4 INDEX PARTITION 21 84043 1 16
722 APPS POA_POD_BS_MV_N4 INDEX PARTITION 21 84027 1 16
723 APPS POA_POD_BS_MV_N4 INDEX PARTITION 21 84011 1 16
724 APPS POA_POD_BS_MV_N4 INDEX PARTITION 21 83995 1 16
725 APPS POA_POD_BS_MV_N4 INDEX PARTITION 21 83979 1 16
726 APPS MLOG$_POA_RTX_BS_J_MV TABLE 21 84059 1 16
727 APPS ASO_BI_QLIN_PC_MV_N1 INDEX 21 84107 1 16
728 APPS ASO_BI_QLIN_PC_MV TABLE 21 84075 1 16
729 APPS ASO_BI_QOT_SG_MV TABLE 21 84091 1 16
730 APPS ASO_BI_QOT_RUL_MV TABLE 21 84123 1 16
731 APPS ASO_BI_QOT_SG_MV_N1 INDEX 21 84139 1 16
732 APPS ASO_BI_QOT_RUL_MV_N1 INDEX 21 84155 1 16
733 APPS ASO_BI_QOT_APR_MV TABLE 21 84171 1 16
734 APPS BIL_BI_OP12_PG_MV TABLE 21 84187 1 16
735 APPS ASO_BI_QOT_APR_MV_N1 INDEX 21 84267 1 16
736 APPS BIL_BI_OPLDC_MV TABLE 21 84283 1 16
737 APPS MLOG$_BIL_BI_OP12_PG_MV TABLE 21 84299 1 16
738 APPS BIL_BI_OP21_G_MV TABLE 21 84315 1 16
739 APPS BIL_BI_FST1_PG_MV TABLE 21 84395 1 16
740 APPS MLOG$_BIL_BI_OPLDC_MV TABLE 21 84411 1 16
741 APPS BIL_BI_OP12_PG_MV_N1 INDEX 21 84427 1 16
742 APPS BIL_BI_OP12_PG_MV_U1_SNAP$ INDEX 21 84443 1 16
743 APPS MLOG$_BIL_BI_FST1_PG_MV TABLE 21 84523 1 16
744 APPS MLOG$_BIL_BI_OP21_G_MV TABLE 21 73115 1 16
745 APPS BIL_BI_OPLPC_MV TABLE 21 84539 1 16
746 APPS MLOG$_BIL_BI_OPLPC_MV TABLE 21 84555 1 16
747 APPS BIL_BI_PIPEC_WG_MV TABLE 21 84571 1 16
748 APPS BIL_BI_PIPE_MV TABLE 21 85131 1 16
749 APPS MLOG$_BIL_BI_PIPEC_WG_MV TABLE 21 85147 1 16
750 APPS MLOG$_BIL_BI_PIPE_MV TABLE 21 85163 1 16
751 APPS BIL_BI_PIPEC_WG_MV_N1 INDEX 21 85179 1 16
752 APPS BIL_BI_PIPE_MV_N1 INDEX 21 85195 1 16
753 APPS BIL_BI_PIPE_MV_N1_SNAP$ INDEX 21 85211 1 16
754 APPS BIL_BI_PIPE_MV_N2 INDEX 21 85243 1 16
755 APPS BIL_BI_PIPE_MV_N2_SNAP$ INDEX 21 85259 1 16
756 APPS BIM_LD_CAMP_GH_MV TABLE 21 85275 1 16
757 APPS MLOG$_BIM_LD_CAMP_GH_MV TABLE 21 85307 1 16
758 APPS BIM_SGMT_ACT_CH_MV TABLE 21 85323 1 16
759 APPS I_SNAP$_BIM_SGMT_ACT_CH_MV INDEX 21 85371 1 16
760 APPS BIM_I_EXT_COL_MV TABLE 21 85419 1 16
761 APPS BIM_I_LD_GH_SUM_MV TABLE 21 85483 1 16
762 APPS BIM_I_LP_GH_SUM_MV TABLE 21 92395 1 16
763 APPS MLOG$_BIM_I_EXT_COL_MV TABLE 21 92411 1 16
764 APPS MLOG$_BIM_I_LD_GH_SUM_MV TABLE 21 92443 1 16
765 APPS BIM_SGMT_ACT_MV TABLE 21 98891 1 16
766 APPS I_SNAP$_BIM_SGMT_ACT_MV INDEX 21 100443 1 16
767 APPS MLOG$_BIM_I_LP_GH_SUM_MV TABLE 21 101083 1 16
768 APPS BIM_SGMT_ACT_SH_MV TABLE 21 101099 1 16
769 APPS I_SNAP$_BIM_SGMT_ACT_SH_MV INDEX 21 101307 1 16
770 APPS ENI_DBI_GL_BASE_SUM_C_MV TABLE 21 79067 1 16
771 APPS ENI_DBI_GL_BASE_SUM_C_MV_U1 INDEX 21 85435 1 16
772 APPS ENI_DBI_CO_NUM_MV TABLE 21 85451 1 16
773 APPS I_SNAP$_ENI_DBI_CO_NUM_MV INDEX 21 85467 1 16
774 APPS MLOG$_ENI_DBI_CO_NUM_MV TABLE 21 85499 1 16
775 APPS ENI_DBI_PRC_UNION_MV TABLE 21 85563 1 16
776 APPS MLOG$_ENI_DBI_PRC_UNION_MV TABLE 21 85579 1 16
777 APPS ENI_DBI_INV_SUM_MV TABLE 21 85627 1 16
778 APPS ENI_RES_3_MV TABLE 21 85643 1 16
779 APPS ENI_DBI_INV_SUM_MV_U1 INDEX 21 85659 1 16
780 APPS I_SNAP$_ENI_RES_3_MV INDEX 21 85675 1 16
781 APPS MLOG$_ENI_RES_3_MV TABLE 21 85723 1 16
782 APPS FII_AP_HCAT_IB_MV TABLE 21 85595 1 16
783 APPS I_SNAP$_FII_AP_HCAT_IB_MV INDEX 21 85611 1 16
784 APPS FII_AP_HHIST_IB_MV TABLE 21 85739 1 16
785 APPS I_SNAP$_FII_AP_HHIST_IB_MV INDEX 21 85755 1 16
786 APPS FII_AP_HCAT_IB_MV_N1 INDEX 21 85803 1 16
787 APPS FII_AP_HCAT_IB_MV_N2 INDEX 21 85819 1 16
788 APPS FII_AP_HHIST_IB_MV_N1 INDEX 21 85835 1 16
789 APPS FII_AP_LIA_IB_MV TABLE 21 85851 1 16
790 APPS I_SNAP$_FII_AP_LIA_IB_MV INDEX 21 85931 1 16
791 APPS FII_AP_MGT_KPI_MV TABLE 21 85947 1 16
792 APPS FII_AP_LIA_IB_MV_N1 INDEX 21 98747 1 16
793 APPS FII_AP_LIA_IB_MV_N2 INDEX 21 101291 1 16
794 APPS FII_AP_MGT_KPI_MV_N1 INDEX 21 101323 1 16
795 APPS FII_GL_MGMT_SUM_MV TABLE 21 85691 1 16
796 APPS I_SNAP$_FII_GL_MGMT_SUM_MV INDEX 21 85707 1 16
797 APPS HRI_MDP_SUP_WRKFC_JFN_MV TABLE 21 85771 1 16
798 APPS FII_GL_MGMT_SUM_MV_N1 INDEX 21 85787 1 16
799 APPS HRI_MDP_SUP_WRKFC_SUP_MV TABLE 21 85867 1 16
800 APPS HRI_MDP_SUP_WRKFC_JFN_MV_U1 INDEX 21 85883 1 16
801 APPS FII_GL_MGMT_SUM_MV_N2 INDEX 21 85899 1 16
802 APPS FII_GL_MGMT_SUM_MV_N3 INDEX 21 85915 1 16
803 APPS HRI_MDP_SUP_WRKFC_SUP_MV_U1 INDEX 21 85963 1 16
804 APPS I_SNAP$_HRI_MDS_SUP_WCNT_C INDEX 21 86043 1 16
805 APPS HRI_MDS_SUP_WRKFC_CTR_MV TABLE 21 86059 1 16
806 APPS HRI_MDS_SUP_WCNT_CHG_MV_U1 INDEX 21 86155 1 16
807 APPS HRI_MDS_SUP_WRKFC_CTR_MV_U1 INDEX 21 86203 1 16
808 APPS IBW_PAGE_SA_TIME_MV TABLE 21 85995 1 16
809 APPS I_SNAP$_IBW_PAGE_SA_TIME_M INDEX 21 86011 1 16
810 APPS IBW_PAGE_SA_TIME_MV_N1 INDEX 21 86027 1 16
811 APPS IBE_BI_CAT_MV TABLE 21 86075 1 16
812 APPS MLOG$_IBE_BI_CAT_MV TABLE 21 86123 1 16
813 APPS IBE_BI_ITEM_MV TABLE 21 86107 1 16
814 APPS MLOG$_IBE_BI_ITEM_MV TABLE 21 86139 1 16
815 APPS IBE_BI_ORDERS_MV TABLE 21 86187 1 16
816 APPS I_SNAP$_IBE_BI_ORDERS_MV INDEX 23 145867 1 16
817 APPS MLOG$_IBE_BI_ORDERS_MV TABLE 21 86219 1 16
818 APPS ISC_DBI_CFM_001_MV TABLE 21 86235 1 16
819 APPS I_SNAP$_ISC_DBI_CFM_001_MV INDEX 21 86251 1 16
820 APPS ISC_DBI_CFM_001_MV_N1 INDEX 21 86267 1 16
821 APPS ISC_FS_004_MV TABLE 21 86283 1 16
822 APPS I_SNAP$_ISC_FS_004_MV INDEX 21 86299 1 16
823 APPS ISC_DBI_CFM_001_MV_N2 INDEX 21 86315 1 16
824 APPS ISC_FS_004_MV_N1 INDEX 21 86331 1 16
825 APPS ISC_FS_004_MV_N2 INDEX 21 86347 1 16
826 APPS ISC_DBI_CFM_012_MV TABLE 21 86363 1 16
827 APPS ISC_DBI_CPM_004_MV TABLE 21 86379 1 16
828 APPS I_SNAP$_ISC_DBI_CPM_004_MV INDEX 21 86427 1 16
829 APPS ISC_DBI_CFM_012_MV_N1 INDEX 21 86603 1 16
830 APPS ISC_DBI_CFM_012_MV_N2 INDEX 21 86635 1 16
831 APPS ISC_DBI_CPM_004_MV_N1 INDEX 21 86683 1 16
832 APPS ISC_DBI_CFM_012_MV_N3 INDEX 21 86715 1 16
833 APPS ISC_DBI_CFM_012_MV_N4 INDEX 21 86731 1 16
834 APPS ISC_DBI_CPM_004_MV_N2 INDEX 21 101163 1 16
835 APPS ISC_DBI_SCR_001_MV TABLE 21 101179 1 16
836 APPS MLOG$_ISC_DBI_SCR_001_MV TABLE 21 101195 1 16
837 APPS ISC_FS_006_MV TABLE 21 101227 1 16
838 APPS I_SNAP$_ISC_FS_006_MV INDEX 21 101339 1 16
839 APPS ISC_DBI_SCR_001_MV_N1 INDEX 21 101355 1 16
840 APPS ISC_DBI_SCR_001_MV_N2 INDEX 21 101371 1 16
841 APPS ISC_FS_006_MV_N1 INDEX 21 101387 1 16
842 APPS ISC_DBI_SCR_001_MV_N3 INDEX 21 101419 1 16
843 APPS ISC_FS_006_MV_N2 INDEX 21 101451 1 16
844 APPS ISC_DBI_SCR_001_MV_N4 INDEX 21 101467 1 16
845 APPS ISC_FS_008_MV TABLE 21 101499 1 16
846 APPS ISC_DBI_SCR_001_MV_N5 INDEX 21 101515 1 16
847 APPS U_SNAP$_ISC_DBI_SCR_001_MV INDEX 21 101531 1 16
848 APPS I_SNAP$_ISC_FS_008_MV INDEX 21 101547 1 16
849 APPS ISC_FS_008_MV_N1 INDEX 21 114699 1 16
850 APPS ISC_FS_010_MV TABLE 21 114715 1 16
851 APPS I_SNAP$_ISC_FS_010_MV INDEX 21 114731 1 16
852 APPS ISC_FS_008_MV_N2 INDEX 21 114747 1 16
853 APPS ISC_FS_010_MV_N1 INDEX 21 114763 1 16
854 APPS ISC_FS_012_MV TABLE 21 114779 1 16
855 APPS MLOG$_BIM_I_CPB_METR_MV TABLE 21 91707 1 16
856 APPS BIM_OBJ_LD_CHNL_MV_N1 INDEX 21 91723 1 16
857 APPS BIM_OBJ_LD_CHNL_MV_N2 INDEX 21 91739 1 16
858 APPS BIM_I_MKT_CRPL_MV TABLE 21 91755 1 16
859 APPS I_SNAP$_BIM_I_MKT_CRPL_MV INDEX 23 145979 1 16
860 APPS BIM_OBJ_LD_CCAT_MV TABLE 21 91771 1 16
861 APPS I_SNAP$_BIM_OBJ_LD_CCAT_MV INDEX 21 91787 1 16
862 APPS BIM_OBJ_CHNL_MV TABLE 21 91803 1 16
863 APPS I_SNAP$_BIM_OBJ_CHNL_MV INDEX 21 91819 1 16
864 APPS BIM_I_MKT_CRPL_MV_N1 INDEX 21 91835 1 16
865 APPS MLOG$_BIM_MKT_KPI_INT_MV TABLE 21 91851 1 16
866 APPS BIM_I_OBJ_METS_MV TABLE 21 91867 1 16
867 APPS I_SNAP$_BIM_I_OBJ_METS_MV INDEX 21 91883 1 16
868 APPS BIM_OBJ_LD_CCAT_MV_N1 INDEX 21 91899 1 16
869 APPS BIM_I_OBJ_CHNL_N1 INDEX 21 91915 1 16
870 APPS BIM_OBJ_LD_CCAT_MV_N2 INDEX 21 91931 1 16
871 APPS BIM_I_OBJ_CHNL_N2 INDEX 21 91947 1 16
872 APPS BIM_I_OBJ_METS_N1 INDEX 21 91963 1 16
873 APPS BIM_I_OBJ_METS_N2 INDEX 21 91979 1 16
874 APPS BIM_OBJ_LD_QUAL_MV TABLE 21 91995 1 16
875 APPS I_SNAP$_BIM_OBJ_LD_QUAL_MV INDEX 21 92011 1 16
876 APPS BIM_OBJ_LD_QUAL_MV_N1 INDEX 21 92027 1 16
877 APPS BIM_OBJ_LD_QUAL_MV_N2 INDEX 21 92043 1 16
878 APPS BIM_OBJ_LD_SRC_MV TABLE 21 92059 1 16
879 APPS I_SNAP$_BIM_OBJ_LD_SRC_MV INDEX 21 92075 1 16
880 APPS BIM_OBJ_REGN_MV TABLE 21 92091 1 16
881 APPS BIM_OBJ_LD_SRC_MV_N1 INDEX 21 92107 1 16
882 APPS I_SNAP$_BIM_OBJ_REGN_MV INDEX 21 92123 1 16
883 APPS BIM_OBJ_LD_SRC_MV_N2 INDEX 21 92139 1 16
884 APPS BIM_OBJ_REGN_MV_N1 INDEX 21 92155 1 16
885 APPS BIM_OBJ_REGN_MV_N2 INDEX 21 92171 1 16
886 APPS ENI_DBI_CO_NEW_MV TABLE 21 92187 1 16
887 APPS I_SNAP$_ENI_DBI_CO_NEW_MV INDEX 21 92203 1 16
888 APPS ENI_DBI_CO_SUM_MV TABLE 21 92219 1 16
889 APPS I_SNAP$_ENI_DBI_CO_SUM_MV INDEX 21 92235 1 16
890 APPS IBW_KPI_METRICS_TIME_MV TABLE 21 92251 1 16
891 APPS I_SNAP$_IBW_KPI_METRICS_TI INDEX 21 92267 1 16
892 APPS ENI_DBI_CO_SUM_MV_N1 INDEX 21 92283 1 16
893 APPS FII_AP_LIA_KPI_MV TABLE 21 92299 1 16
894 APPS IBW_KPI_METRICS_TIME_MV_N1 INDEX 21 92315 1 16
895 APPS FII_AP_LIA_KPI_MV_N1 INDEX 21 92331 1 16
896 APPS IBW_CMPANALYSIS_TIME_MV TABLE 21 92347 1 16
897 APPS I_SNAP$_IBW_CMPANALYSIS_TI INDEX 22 145675 1 16
898 APPS IBW_PRODUCT_SUM_MV TABLE 21 92363 1 16
899 APPS I_SNAP$_IBW_PRODUCT_SUM_MV INDEX 22 145691 1 16
900 APPS MLOG$_IBW_CMPANALYSIS_TIME TABLE 21 92379 1 16
901 APPS IBW_REFANALYSIS_TIME_MV TABLE 21 92427 1 16
902 APPS MLOG$_IBW_PRODUCT_SUM_MV TABLE 21 92459 1 16
903 APPS I_SNAP$_IBW_REFANALYSIS_TI INDEX 21 92475 1 16
904 APPS IBW_REFANALYSIS_TIME_MV_N1 INDEX 21 92491 1 16
905 APPS IBW_VISIT_CUST_TIME_MV TABLE 21 92507 1 16
906 APPS I_SNAP$_IBW_VISIT_CUST_TIM INDEX 21 92523 1 16
907 APPS IBW_VISIT_CUST_TIME_MV_N1 INDEX 21 92539 1 16
908 APPS BIM_I_CPB_METS_MV TABLE 21 92555 1 16
909 APPS I_SNAP$_BIM_I_CPB_METS_MV INDEX 21 92571 1 16
910 APPS ASO_BI_QOT_CUST_MV TABLE 21 85099 1 16
911 APPS ASO_BI_QOT_CUST_MV_N1 INDEX 21 85115 1 16
912 APPS BIM_I_CPB_CHNL_MV TABLE 21 92587 1 16
913 APPS I_SNAP$_BIM_I_CPB_CHNL_MV INDEX 21 92603 1 16
914 APPS BIM_MKT_LD_CHNL_MV TABLE 21 92619 1 16
915 APPS I_SNAP$_BIM_MKT_LD_CHNL_MV INDEX 24 145819 1 16
916 APPS BIM_I_CPB_METS_N1 INDEX 21 92635 1 16
917 APPS BIM_I_CPB_METS_N2 INDEX 21 92651 1 16
918 APPS BIM_I_CPB_CHNL_N1 INDEX 21 92667 1 16
919 APPS BIL_BI_SLS_PERF_MV TABLE 21 92683 1 16
920 APPS ISC_SAM_001_MV_N4 INDEX 21 115451 1 16
921 APPS ISC_SAM_001_MV_N7 INDEX 21 115467 1 16
922 APPS U_SNAP$_ISC_SAM_001_MV_N5 INDEX 21 115483 1 16
923 APPS U_SNAP$_ISC_SAM_001_MV_N6 INDEX 21 115499 1 16
924 APPS ISC_SAM_002_MV TABLE 21 115515 1 16
925 APPS ISC_SAM_003_MV TABLE 21 115531 1 16
926 APPS ISC_SAM_002_MV_N1 INDEX 21 115547 1 16
927 APPS ISC_SAM_002_MV_N2 INDEX 21 115563 1 16
928 APPS ISC_SAM_002_MV_N3 INDEX 21 115579 1 16
929 APPS ISC_SAM_003_MV_N1 INDEX 21 115595 1 16
930 APPS ISC_SAM_002_MV_N4 INDEX 21 115611 1 16
931 APPS ISC_SAM_002_MV_N7 INDEX 21 115627 1 16
932 APPS ISC_SAM_003_MV_N2 INDEX 21 115643 1 16
933 APPS U_SNAP$_ISC_SAM_002_MV_N5 INDEX 21 115659 1 16
934 APPS ISC_SAM_003_MV_N3 INDEX 21 115675 1 16
935 APPS U_SNAP$_ISC_SAM_002_MV_N6 INDEX 21 115691 1 16
936 APPS ISC_SAM_003_MV_N4 INDEX 21 115707 1 16
937 APPS ISC_SAM_003_MV_N7 INDEX 21 115723 1 16
938 APPS U_SNAP$_ISC_SAM_003_MV_N5 INDEX 21 115739 1 16
939 APPS U_SNAP$_ISC_SAM_003_MV_N6 INDEX 21 115755 1 16
940 APPS ISC_SAM_004_MV TABLE 21 115771 1 16
941 APPS ISC_SAM_004_MV_N1 INDEX 21 115787 1 16
942 APPS ISC_SAM_004_MV_N2 INDEX 21 115803 1 16
943 APPS ISC_FS_017_MV TABLE 21 115819 1 16
944 APPS ISC_SAM_004_MV_N3 INDEX 21 115835 1 16
945 APPS I_SNAP$_ISC_FS_017_MV INDEX 21 115851 1 16
946 APPS ISC_SAM_004_MV_N4 INDEX 21 115867 1 16
947 APPS ISC_SAM_004_MV_N7 INDEX 21 115883 1 16
948 APPS ISC_FS_017_MV_N1 INDEX 21 115899 1 16
949 APPS U_SNAP$_ISC_SAM_004_MV_N5 INDEX 21 115915 1 16
950 APPS ISC_FS_017_MV_N2 INDEX 21 115931 1 16
951 APPS U_SNAP$_ISC_SAM_004_MV_N6 INDEX 21 115947 1 16
952 APPS ISC_FS_015_MV TABLE 21 115963 1 16
953 APPS I_SNAP$_ISC_FS_015_MV INDEX 21 115979 1 16
954 APPS ISC_FS_015_MV_N1 INDEX 21 115995 1 16
955 APPS ISC_FS_015_MV_N2 INDEX 21 116011 1 16
956 APPS ISC_FS_015_MV_N3 INDEX 21 116027 1 16
957 APPS ISC_SAM_006_MV TABLE 21 116043 1 16
958 APPS ISC_SAM_006_MV_N1 INDEX 21 116059 1 16
959 APPS ISC_SAM_006_MV_N2 INDEX 21 116075 1 16
960 APPS ISC_SAM_006_MV_N3 INDEX 21 116091 1 16
961 APPS ISC_SAM_006_MV_N4 INDEX 21 116107 1 16
962 APPS ISC_SAM_006_MV_N7 INDEX 21 116123 1 16
963 APPS U_SNAP$_ISC_SAM_006_MV_N5 INDEX 21 116139 1 16
964 APPS U_SNAP$_ISC_SAM_006_MV_N6 INDEX 21 116155 1 16
965 APPS ISC_SAM_005_MV TABLE 21 116171 1 16
966 APPS ISC_SAM_005_MV_N1 INDEX 21 116187 1 16
967 APPS ISC_SAM_005_MV_N2 INDEX 21 116203 1 16
968 APPS ISC_SAM_007_MV TABLE 21 116219 1 16
969 APPS ISC_SAM_005_MV_N3 INDEX 21 116235 1 16
970 APPS ISC_SAM_005_MV_N4 INDEX 21 116251 1 16
971 APPS ISC_SAM_005_MV_N7 INDEX 21 116267 1 16
972 APPS U_SNAP$_ISC_SAM_005_MV_N5 INDEX 21 116283 1 16
973 APPS ISC_SAM_007_MV_N1 INDEX 21 116299 1 16
974 APPS U_SNAP$_ISC_SAM_005_MV_N6 INDEX 21 116315 1 16
975 APPS ISC_SAM_007_MV_N2 INDEX 21 116331 1 16
976 APPS ISC_SAM_007_MV_N3 INDEX 21 116347 1 16
977 APPS ISC_SAM_007_MV_N4 INDEX 21 116363 1 16
978 APPS ISC_SAM_007_MV_N7 INDEX 21 116379 1 16
979 APPS U_SNAP$_ISC_SAM_007_MV_N5 INDEX 21 116395 1 16
980 APPS U_SNAP$_ISC_SAM_007_MV_N6 INDEX 21 116411 1 16
981 APPS OKI_SRM_002_MV TABLE 21 86395 1 16
982 APPS I_SNAP$_OKI_SRM_002_MV INDEX 21 86411 1 16
983 APPS MLOG$_OKI_SRM_002_MV TABLE 21 86443 1 16
984 APPS OPI_MTL_VAR_SUM_MV TABLE 21 81483 1 16
985 APPS I_SNAP$_OPI_MTL_VAR_SUM_MV INDEX 21 81499 1 16
986 APPS OPI_MTL_VAR_SUM_MV_N1 INDEX 21 81547 1 16
987 APPS OPI_MTL_VAR_SUM_MV_N2 INDEX 21 81563 1 16
988 APPS OPI_MTL_VAR_SUM_MV_N3 INDEX 21 81579 1 16
989 APPS OPI_PGM_GRP_MV TABLE 21 86459 1 16
990 APPS I_SNAP$_OPI_PGM_GRP_MV INDEX 21 86475 1 16
991 APPS MLOG$_OPI_PGM_GRP_MV TABLE 21 86491 1 16
992 APPS POA_IDL_002_MV TABLE PARTITION 21 86523 1 16
993 APPS POA_IDL_002_MV TABLE PARTITION 21 86507 1 16
994 APPS I_SNAP$_POA_IDL_002_MV INDEX 21 86539 1 16
995 APPS POA_IDL_002_MV_N1 INDEX PARTITION 21 86571 1 16
996 APPS POA_IDL_002_MV_N1 INDEX PARTITION 21 86555 1 16
997 APPS POA_API_002_MV TABLE PARTITION 21 86619 1 16
998 APPS POA_API_002_MV TABLE PARTITION 21 86587 1 16
999 APPS I_SNAP$_POA_API_002_MV INDEX 21 86651 1 16
1000 APPS POA_API_002_MV_N1 INDEX PARTITION 21 86699 1 16
1001 APPS POA_API_002_MV_N1 INDEX PARTITION 21 86667 1 16
1002 APPS OPI_PTP_SUM_F_MV TABLE PARTITION 21 86779 1 16
1003 APPS OPI_PTP_SUM_F_MV TABLE PARTITION 21 86763 1 16
1004 APPS OPI_PTP_SUM_F_MV TABLE PARTITION 21 86747 1 16
1005 APPS I_SNAP$_OPI_PTP_SUM_F_MV INDEX 21 86795 1 16
1006 APPS OPI_PTP_SUM_F_MV_N1 INDEX 21 86811 1 16
1007 APPS OPI_SCRAP_SUM_MV TABLE 21 86827 1 16
1008 APPS OPI_PTP_SUM_F_MV_N2 INDEX 21 86843 1 16
1009 APPS I_SNAP$_OPI_SCRAP_SUM_MV INDEX 21 86859 1 16
1010 APPS OPI_PTP_SUM_F_MV_N3 INDEX 21 86875 1 16
1011 APPS OPI_SCRAP_SUM_MV_N1 INDEX 21 86891 1 16
1012 APPS OPI_SCRAP_SUM_MV_N2 INDEX 21 86907 1 16
1013 APPS OPI_SCRAP_SUM_MV_N3 INDEX 21 86923 1 16

Oracle Dependency Tree

SELECT LPAD(' ', (A.NIVEL - 1) * 2) || OBJ.NAME A,
LPAD(' ', (A.NIVEL - 1) * 2) || CONS.NAME B
FROM SYS.OBJ$ OBJ,
SYS.CON$ CONS,
(SELECT OBJ# OBJ#, CON#, LEVEL NIVEL
FROM SYS.CDEF$
WHERE RCON# IS NOT NULL AND ROBJ# IS NOT NULL
CONNECT BY ROBJ# = PRIOR OBJ# AND ROBJ# != OBJ# AND
PRIOR ROBJ# != PRIOR OBJ#
START WITH ROBJ# = (SELECT OBJ#
FROM SYS.OBJ$
WHERE NAME = UPPER('fnd_concurrent_requests') AND TYPE# = 2 AND
OWNER# = USERENV('SCHEMAID'))) A
WHERE CONS.CON# = A.CON# AND OBJ.OBJ# = A.OBJ# AND OBJ.TYPE# = 2
UNION ALL
SELECT LPAD(' ', (A.NIVEL - 1) * 2) || OBJ.NAME A, TO_CHAR(NULL)
FROM SYS.OBJ$ OBJ,
(SELECT D_OBJ# OBJ#, LEVEL NIVEL
FROM SYS.DEPENDENCY$
CONNECT BY P_OBJ# = PRIOR D_OBJ#
START WITH P_OBJ# = (SELECT OBJ#
FROM SYS.OBJ$
WHERE NAME = UPPER('fnd_concurrent_requests') AND
OWNER# = USERENV('SCHEMAID'))) A
WHERE OBJ.OBJ# = A.OBJ# AND OBJ.TYPE# != 2

Database uptime and startup time

SELECT 'Hostname : ' || HOST_NAME "Host name",
'Instance Name : ' || INSTANCE_NAME "Instance Name",
'Started At : ' || TO_CHAR(STARTUP_TIME, 'DD-MON-YYYY HH24:MI:SS') "Startup Time",
'Uptime : ' || FLOOR(SYSDATE - STARTUP_TIME) || ' days(s) ' ||
TRUNC(24 *
((SYSDATE - STARTUP_TIME) - TRUNC(SYSDATE - STARTUP_TIME))) ||
' hour(s) ' || MOD(TRUNC(1440 * ((SYSDATE - STARTUP_TIME) -
TRUNC(SYSDATE - STARTUP_TIME))),
60) || ' minute(s) ' ||
MOD(TRUNC(86400 *
((SYSDATE - STARTUP_TIME) - TRUNC(SYSDATE - STARTUP_TIME))),
60) || ' seconds' "Uptime"
FROM V$INSTANCE

Setting Audit on a Oracle table

Description: Creates a procedure in which table names may be passed to create an AFTER UPDATE audit trigger for the table.


INSTRUCTIONS
1.Run this procedure in a plsql editor
2.Set ServerOutPut on
3.Call the procedure with a valid
table name
4.Copy and paste the output in an
iSQL*Plus session and run to create
a trigger.
Code:

CREATE OR REPLACE PROCEDURE genTriggerCode(
--
--INSTRUCTIONS
--Run this procedure
--Set ServerOutPut on
--Call the procedure with a valid table name
--Copy and paste the output in an iSQL*Plus session and run
-- to create a trigger.
--
tbl IN VARCHAR2,
owner IN VARCHAR2 := USER,
proc IN VARCHAR2 := 'CallMyProc'
)
IS
recType CONSTANT VARCHAR2(100) := tbl || '%ROWTYPE';
cols DBMS_SQL.varchar2s;

PROCEDURE genProc(oldNew IN VARCHAR2)
IS
BEGIN
DBMS_OUTPUT.put_line( 'FUNCTION copy_'
|| oldNew
|| ' RETURN '
|| recType
|| ' IS l_return '
|| recType
|| '; '
);
DBMS_OUTPUT.put_line('BEGIN');

FOR indx IN 1 .. cols.COUNT
LOOP
DBMS_OUTPUT.put_line( ' l_return.'
|| cols(indx)
|| ' := '
|| ' :'
|| oldNew
|| '.'
|| cols(indx)
|| ';'
);
END LOOP;

DBMS_OUTPUT.put_line('RETURN l_return;');
DBMS_OUTPUT.put_line('END copy_' || oldNew || ';');
END genProc;
BEGIN
SELECT LOWER (column_name) column_name
BULK COLLECT INTO cols
FROM all_tab_columns
WHERE table_name = UPPER(tbl) AND owner = UPPER(owner);
DBMS_OUTPUT.PUT_LINE('CREATE OR REPLACE TRIGGER tri_' || tbl);
DBMS_OUTPUT.PUT_LINE(' AFTER UPDATE');
DBMS_OUTPUT.PUT_LINE(' ON ' || tbl);
DBMS_OUTPUT.PUT_LINE(' FOR EACH ROW');
DBMS_OUTPUT.PUT_LINE('DECLARE');
DBMS_OUTPUT.PUT_LINE(' oldRow ' || tbl || '%ROWTYPE;');
DBMS_OUTPUT.PUT_LINE(' newRow ' || tbl || '%ROWTYPE;');
genProc('old');
genProc('new');
DBMS_OUTPUT.PUT_LINE('BEGIN');
DBMS_OUTPUT.PUT_LINE(' oldRow := copy_Old();');
DBMS_OUTPUT.PUT_LINE(' newRow := copy_New();');
DBMS_OUTPUT.PUT_LINE(' --Change the value of proc to a valid procedure');
DBMS_OUTPUT.PUT_LINE(' --and unREM the line below');
DBMS_OUTPUT.PUT_LINE(' --' || proc || '(oldRow, newRow);');
DBMS_OUTPUT.PUT_LINE('END;');
END genTriggerCode;
/



--Test the new procedure.
--Set MYTABLENAME to any valid table name.
--SET SERVEROUTPUT on;
--EXEC genTriggerCode('MYTABLENAME');

Oracle Instance last started

Description: Find the date when the Oracle Instance was last started
Code:

select to_char(TO_DATE(VALUE,'J'),'mm/dd/yyyy') startDate
from v$instance
where KEY LIKE 'STARTUP TIME - J%';

Obsolete Database Parameters


Oracle provides the view V$OBSOLETE_PARAMETER to display all obsolete and underscored parameters. This view contains the name of the parameter and a flag ISSPECIFIED indicating if the parameter has actually been set in the init.ora file. Keep in mind that Oracle has not really retired all of the parameters contained in V$OBSOLETE_PARAMETER, some of them have been underscored. Underscored parameters are ones that Oracle wants to keep around, but does not want you to use them unless absolutely necessary. These underscored parameters are better know as hidden parameters. They are not documented and they all start with an _, like _lgwr_io_slaves in Oracle8i.

SQL> SELECT name, isspecified
2 FROM v$obsolete_parameter;

NAME ISSPECIFIED
---------------------------------------------------------------- -----------
spin_count FALSE
use_ism FALSE
lock_sga_areas FALSE
instance_nodeset FALSE
large_pool_min_alloc FALSE
shared_pool_reserved_min_alloc FALSE
_kspptbl_mem_usage FALSE
enqueue_resources FALSE
lgwr_io_slaves FALSE
arch_io_slaves FALSE
backup_disk_io_slaves FALSE
ops_interconnects FALSE
lm_procs FALSE
ogms_home FALSE
parallel_transaction_resource_timeout FALSE
_lm_statistics FALSE
lm_locks FALSE
lm_ress FALSE
lm_procs FALSE
_lm_multiple_receivers FALSE

NAME ISSPECIFIED
---------------------------------------------------------------- -----------
_lm_direct_sends FALSE
db_block_max_dirty_target FALSE
db_block_lru_latches FALSE
db_block_checkpoint_batch FALSE
db_block_lru_statistics FALSE
db_block_lru_extended_statistics FALSE
_compatible_no_recovery FALSE
_average_dirties_half_life FALSE
log_block_checksum FALSE
log_small_entry_max_size FALSE
log_simultaneous_copies FALSE
log_parallelism FALSE
db_file_simultaneous_writes FALSE
log_files FALSE
_db_no_mount_lock FALSE
standby_preserves_names FALSE
gc_lck_procs FALSE
gc_releasable_locks FALSE
gc_latches FALSE
gc_rollback_locks FALSE
gc_defer_time FALSE

NAME ISSPECIFIED
---------------------------------------------------------------- -----------
freeze_DB_for_fast_instance_recovery FALSE
temporary_table_locks FALSE
row_locking FALSE
serializable FALSE
delayed_logging_block_cleanouts FALSE
max_rollback_segments FALSE
transaction_auditing FALSE
cleanup_rollback_entries FALSE
undo_suppress_errors FALSE
discrete_transactions_enabled FALSE
sequence_cache_entries FALSE
sequence_cache_hash_buckets FALSE
_seq_process_cache_const FALSE
row_cache_cursors FALSE
text_enable FALSE
dblink_encrypt_login FALSE
distributed_transactions FALSE
max_transaction_branches FALSE
distributed_recovery_connection_hold_time FALSE
mts_dispatchers FALSE
mts_servers FALSE

NAME ISSPECIFIED
---------------------------------------------------------------- -----------
mts_max_servers FALSE
mts_max_dispatchers FALSE
mts_circuits FALSE
mts_sessions FALSE
mts_service FALSE
mts_listener_address FALSE
mts_multiple_listeners FALSE
plsql_native_c_compiler FALSE
plsql_native_linker FALSE
plsql_native_make_utility FALSE
plsql_native_make_file_name FALSE
_plsql_conditional_compilation FALSE
job_queue_interval FALSE
job_queue_keep_connections FALSE
snapshot_refresh_processes FALSE
snapshot_refresh_interval FALSE
snapshot_refresh_keep_connections FALSE
parallel_default_max_instances FALSE
cache_size_threshold FALSE
parallel_server_idle_time FALSE
allow_partial_sn_results FALSE

NAME ISSPECIFIED
---------------------------------------------------------------- -----------
ops_admin_group FALSE
parallel_min_message_pool FALSE
hash_join_enabled FALSE
hash_multiblock_io_count FALSE
oracle_trace_enable FALSE
oracle_trace_facility_path FALSE
oracle_trace_collection_path FALSE
oracle_trace_facility_name FALSE
oracle_trace_collection_name FALSE
oracle_trace_collection_size FALSE
_oracle_trace_events FALSE
_oracle_trace_facility_version FALSE
close_cached_open_cursors FALSE
sort_direct_writes FALSE
sort_write_buffers FALSE
sort_write_buffer_size FALSE
sort_spacemap_size FALSE
sort_read_fac FALSE
sort_multiblock_read_count FALSE
always_anti_join FALSE
partition_view_enabled FALSE

NAME ISSPECIFIED
---------------------------------------------------------------- -----------
b_tree_bitmap_plans FALSE
complex_view_merging FALSE
push_join_predicate FALSE
fast_full_scan_enabled FALSE
parallel_broadcast_enabled FALSE
always_semi_join FALSE
optimizer_max_permutations FALSE
optimizer_percent_parallel FALSE
optimizer_search_limit FALSE

113 rows selected

SQL>

SQL> SELECT kspponm,
2 DECODE(ksppoflg, 1,'Obsolete', 2, 'Underscored')
3 FROM x$ksppo
4 ORDER BY kspponm;

Free Space in Tempory Tablespace

Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.2.0
Connected as apps


SQL>
SQL> SELECT T.TABLESPACE_NAME,
2 NVL(ROUND(((SUM(U.BLOCKS) * P.VALUE) / 1024 / 1024), 2), 0) USED_MB,
3 T.TOT_MB,
4 NVL(ROUND(SUM(U.BLOCKS) * P.VALUE / 1024 / 1024 / T.TOT_MB * 100, 2),
5 0) "USED %"
6 FROM GV$SORT_USAGE U,
7 GV$PARAMETER P,
8 (SELECT TABLESPACE_NAME, SUM(BYTES) / 1024 / 1024 TOT_MB
9 FROM DBA_TEMP_FILES
10 GROUP BY TABLESPACE_NAME) T
11 WHERE P.NAME = 'db_block_size' AND U.TABLESPACE(+) = T.TABLESPACE_NAME
12 GROUP BY T.TABLESPACE_NAME, P.VALUE, T.TOT_MB
13 ORDER BY 1, 2;

TABLESPACE_NAME USED_MB TOT_MB USED %
------------------------------ ---------- ------ ----------
TEMP2 160 6000 2.67

SQL>

Important Tables for Oracle Apps DBA

oncurrent Manager
FND_CONCURRENT_QUEUES
FND_CONCURRENT_PROGRAMS
FND_CONCURRENT_REQUESTS
FND_CONCURRENT_PROCESSES
FND_CONCURRENT_QUEUE_SIZE

FND

FND_APPL_TOPS
FND_LOGINS
FND_USER
FND_DM_NODES
FND_TNS_ALIASES
FND_NODES
FND_RESPONSIBILITY
FND_DATABASES
FND_UNSUCCESSFUL_LOGINS
FND_LANGUAGES
FND_APPLICATION
FND_PROFILE_OPTION_VALUES

AD / Patches

AD_APPLIED_PATCHES
AD_PATCH_DRIVERS
AD_BUGS
AD_INSTALL_PROCESSES
AD_SESSIONS
AD_APPL_TOPS

Oracle apps Reports 6i FAQ

1. What are the various types of reports?
2. What is the difference between Master - Detail Report and report created by breaks?
3. What are Anchors?
4. What are the various types of anchors in Reports?
5. What are the various report triggers? What is their order of firing?
6. What are Placeholder Columns?
7. What are the various Module Types in Reports?
8. What are Physical and Logical pages in Reports?
9. What are the various page layout sections in Oracle Reports?
10. What are various types of parameters?
10. How do you reference parameters and columns in reports?
12. What are Bind Referencing and Lexical Referencing?
13. Can you create a group without any break columns?
14. Types of Matrix report?
15. In Reports, how can you print one record per page in the output?
16. How do you print a Report 2.5 report in character mode?
17. What are widow lines?
18. What are widow records?
19. What is 'page protect' property for objects?
20. What is the 'Print Condition Type' property?
21. What are the various values of the 'Print Condition Type' property in Reports?
22. What is the 'Print Condition Object' property?
23. What are the various values of the 'Print Condition Object' property in Reports?
24. What is the horizontal of vertical sizing property of objects?
25. What are the various values of the horizontal of vertical sizing property?
26. How do you display a message in reports?
27. What are the various values of 'Print Panel Order' property of report?
28. What is the 'Print Direction' Property of Repeating frames?
29. What are the various values of the 'Print Direction' Property of Repeating frames?
30. What is the 'Keep with Anchoring Object' object property?
31. What is 'Page Break Before' object property?
32. What is 'Page Break After' object property?
33. What is the 'Break Order' property of columns?
34. What are the various types of links?
35. Name some of the procedures in the SRW package?
36. What are the various report layout regions?
37. What is more efficient: Maximum rows or Group Filter?

Command to do active duplicate for Oracle Database

1. First login to target server 2. Validate tns connectivity between Source DB and Target DB 3. Prepare and validate space availability 4. S...