appsdbarepository.blogspot.com

Info on Oracle Apps and DB

Info on Oracle Apps and DB. Sunday, March 25, 2007. Apps - Concurrent Queries. Request Details with Status/Phase Info. Select b.user concurrent program name, cp.request id, sc.MEANING,pc.MEANING ,. To char(cp.actual start date,'dd-mon-yyyy hh24:mi'),. To char(cp.actual completion date,'dd-mon-yyyy hh24:mi'). FROM apps.fnd concurrent requests cp ,apps.fnd concurrent programs vl b, apps.fnd lookups sc , apps.fnd lookups pc. Cprequest id between = ReqId. Bapplication id = cp.program application id and.

http://appsdbarepository.blogspot.com/

OVERVIEW OF appsdbarepository.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

9

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR APPSDBAREPOSITORY.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

August

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Sunday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 3.7 out of 5 with 9 reviews

5 star

0

4 star

6

3 star

3

2 star

0

1 star

0

Hey there! Start your review of appsdbarepository.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.3 seconds

FAVICON PREVIEW

16x16
32x32

CONTACTS AT APPSDBAREPOSITORY.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

9

SSL

EXTERNAL LINKS

0

SITE IP

172.217.6.33

LOAD TIME

0.281 sec

SCORE

6.2

PAGE TITLE

Info on Oracle Apps and DB | appsdbarepository.blogspot.com Reviews

<META> DESCRIPTION

Info on Oracle Apps and DB. Sunday, March 25, 2007. Apps - Concurrent Queries. Request Details with Status/Phase Info. Select b.user concurrent program name, cp.request id, sc.MEANING,pc.MEANING ,. To char(cp.actual start date,'dd-mon-yyyy hh24:mi'),. To char(cp.actual completion date,'dd-mon-yyyy hh24:mi'). FROM apps.fnd concurrent requests cp ,apps.fnd concurrent programs vl b, apps.fnd lookups sc , apps.fnd lookups pc. Cprequest id between = ReqId. Bapplication id = cp.program application id and.

<META> KEYWORDS

1 where

2 request id in

3 long running requests

4 dd mon yy hh24 mi ss' and

5 cpactual start date

6 todate

7 set linesize 150

8 and blanguage='us' and

9 column library a15

10 manager types

CONTENT

Page content here

KEYWORDS ON PAGE

where,request id in,long running requests,dd mon yy hh24 mi ss' and,cpactual start date,todate,set linesize 150,and blanguage='us' and,column library a15,manager types,posted by,sandeep s,42 comments,db links,no comments,standard db queries,bprogram,cups

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

Info on Oracle Apps and DB | appsdbarepository.blogspot.com Reviews

https://appsdbarepository.blogspot.com

Info on Oracle Apps and DB. Sunday, March 25, 2007. Apps - Concurrent Queries. Request Details with Status/Phase Info. Select b.user concurrent program name, cp.request id, sc.MEANING,pc.MEANING ,. To char(cp.actual start date,'dd-mon-yyyy hh24:mi'),. To char(cp.actual completion date,'dd-mon-yyyy hh24:mi'). FROM apps.fnd concurrent requests cp ,apps.fnd concurrent programs vl b, apps.fnd lookups sc , apps.fnd lookups pc. Cprequest id between = ReqId. Bapplication id = cp.program application id and.

INTERNAL PAGES

appsdbarepository.blogspot.com

1

Info on Oracle Apps and DB: CRS Issues

http://appsdbarepository.blogspot.com/2007/03/crs-issues.html

Info on Oracle Apps and DB. Saturday, March 24, 2007. How to enable Tracing for CRS. Tracing for CRS can be enabled using the below steps :. Set or export ORA CRSDEBUG=1. Set mesg logging level=5. File and its location : /etc/init.crsd. ORACLE CRS HOME/srvm/admin/ocrlog.ini. 1) "ps -ef grep d.bin". Must show all the CRS processes up and running. 2) "crs stat -t". Must shows the CRS resources (nodeapps) online in each node. 3) "crsctl check css". Must return css is healthy. 4) "crsctl check crs".

2

Info on Oracle Apps and DB: Apps - Concurrent Queries

http://appsdbarepository.blogspot.com/2007/03/apps-concurrent-queries.html

Info on Oracle Apps and DB. Sunday, March 25, 2007. Apps - Concurrent Queries. Request Details with Status/Phase Info. Select b.user concurrent program name, cp.request id, sc.MEANING,pc.MEANING ,. To char(cp.actual start date,'dd-mon-yyyy hh24:mi'),. To char(cp.actual completion date,'dd-mon-yyyy hh24:mi'). FROM apps.fnd concurrent requests cp ,apps.fnd concurrent programs vl b, apps.fnd lookups sc , apps.fnd lookups pc. Cprequest id between = ReqId. Bapplication id = cp.program application id and.

3

Info on Oracle Apps and DB: Standard DB Queries

http://appsdbarepository.blogspot.com/2007/03/standard-db-queries.html

Info on Oracle Apps and DB. Saturday, March 24, 2007. Session details when SPID is known. Select a.machine,a.process,a.last call et,a.module,to char(a.logon time,'dd-mm-yyyy hh24:mi:ss'),a.sid,a.serial#,status,. Substr(osuser,1,20) osuser,. Schemaname, pid, spid. From v$session a, v$process b. Where b.spid in(. And apaddr = b.addr;. Session details when CLIENT PROCESS is known. Substr(osuser,1,20) osuser,. Schemaname, pid, spid. From v$session a, v$process b. Where a.process like '%. Asid=b.sid ;. Hi, am...

4

Info on Oracle Apps and DB: DB Advisories

http://appsdbarepository.blogspot.com/2007/03/db-advisories.html

Info on Oracle Apps and DB. Saturday, March 24, 2007. DB Cache Advisor (9i and above). Query below will provide advisory data depending on usage history :. SELECT a.size for estimate From Size , a.buffers for estimate Buffers. Aestd physical read factor Phy Read Factor , a.estd physical reads Phy Reads. FROM V$DB CACHE ADVICE a. WHERE a.name = 'DEFAULT'. AND ablock size = (SELECT value FROM V$PARAMETER. WHERE name = 'db block size'). AND aadvice status = 'ON'. Shared Pool Advisor (9i and above). SELECT r...

5

Info on Oracle Apps and DB: DB Links

http://appsdbarepository.blogspot.com/2007/03/db-links.html

Info on Oracle Apps and DB. Sunday, March 25, 2007. Query for getting DB Link name,password,username. Column Owner format a10. Column DbLinkName format a30. Column CONN USER format a10. Column CONN PWD format a10. Column CONN STRING format a20. Select l.name DbLinkName , du.username Owner ,l.userid CONN User, l.password CONN Pwd, l.host. Conn String from sys.link$ l,dba users du where l.owner#=du.user id . Public Link will have Owner as Null. From sys.link$ l. Subscribe to: Post Comments (Atom).

UPGRADE TO PREMIUM TO VIEW 4 MORE

TOTAL PAGES IN THIS WEBSITE

9

OTHER SITES

appsdbanotes.wordpress.com

Apps DBA notes | Just another WordPress.com weblog

Just another WordPress.com weblog. How Veeam backup MSSQL. July 8, 2016. I love Veeam. It is easy to use and do a nice job. Make our live easier than before. OK, What is important for DBAs here? What is the relation that DBA need to know about. How Veeam backup SQL server? This is first and most important question that I was looking for. Veeam is install service on VM during backup time and in our case is using Volume Shadow Copy Services (VSS) to backup SQL server. How this is going to be? BE CAREFUL AS...

appsdbaportal.blogspot.com

Oracle Application DBA Portal

Major changes from 11i. Compile Apps Schema invalid objects in R12. Apps Components and Architecture. Upgrade 11.5.9 to 11.5.10.2. Upgrade from 11.5.10.2 to R12. Upgrading 9i to 10g with 11i. AppsDBA System Management Utilities Guide. Identifying Long Idle Sessions. Identifying High Active Sessions. Change hostname for EBS. Oracle12c Datafile moved Online. Upgrade 10g to 11g R1. Upgrade 11.2.0.2 to 11.2.0.3. Top 99 Responsibilities of a DBA. Disk I/O,Events,Waits. Oracle AS10g null protocol issue. New an...

appsdbaquestions.blogspot.com

Oracle Apps DBA troubleshooting

Oracle Apps DBA troubleshooting. Saturday, November 14, 2009. ORA-27047: unable to read the header block of file. Trying to clone from prod. If you noticed following error message. CREATE CONTROLFILE REUSE SET DATABASE "DEV". ERROR at line 1:. ORA-01503: CREATE CONTROLFILE failed. ORA-01565: error in identifying file. ORA-27047: unable to read the header block of file. After above error I run following command and noticed header error. System01.dbf: Header block magic number is bad. Oracle Apps DBA blog.

appsdbaref.com

Coming Soon - Future home of something quite cool

Future home of something quite cool. If you're the site owner. To launch this site. If you are a visitor. Please check back soon.

appsdbarepository.blogspot.com

Info on Oracle Apps and DB

Info on Oracle Apps and DB. Sunday, March 25, 2007. Apps - Concurrent Queries. Request Details with Status/Phase Info. Select b.user concurrent program name, cp.request id, sc.MEANING,pc.MEANING ,. To char(cp.actual start date,'dd-mon-yyyy hh24:mi'),. To char(cp.actual completion date,'dd-mon-yyyy hh24:mi'). FROM apps.fnd concurrent requests cp ,apps.fnd concurrent programs vl b, apps.fnd lookups sc , apps.fnd lookups pc. Cprequest id between = ReqId. Bapplication id = cp.program application id and.

appsdbas.blogspot.com

Oracle Apps DBA

This blog is created to put all the Apps DBA relevant information at one place. Friday, December 02, 2011. Useful Articles for Apps DBAs Oracle noteID ID 828157.1. Java- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - note 418664.1. Overview of Using Java with Oracle E-Business Suite Release 12 note 455492.1. Using Latest Update of Java 6.0 with Oracle E-Business Suite Release 12 note 384249.1. Upgrading JInitiator with Oracle E-Business Suite 11i note 11...

appsdbastuff.blogspot.com

Oracle Apps DBA stuff

Oracle Apps DBA stuff. Friday, March 13, 2015. Method to Track Oracle Schema User Password and Modification History. Find out Current, New Password. Here are the steps:. Here these objects like table, Procedure, Function are created under sys user. Only sys can query the changes. SQL conn / as sysdba. Create a tracking table with a character column. SQL create table pass track (hist varchar2(200) ;. Create a procedure with autonomous transaction to insert the records to the table. END fn track pass;.