manishappsdba.blogspot.com

Oracle Application DBA Posts

Oracle Application DBA Posts. Monday, October 1, 2012. Check privileges/role to table. NOTE* * * * * * * * *. Http:/ download.oracle.com/docs/cd/B10501 01/server.920/a96521/privs.htm. SQL desc DBA SYS PRIVS. GRANTEE NOT NULL VARCHAR2(30). PRIVILEGE NOT NULL VARCHAR2(40). SQL select GRANTEE,PRIVILEGE from DBA SYS PRIVS where GRANTEE='System';. XXXXX CREATE DATABASE LINK. SQL desc DBA ROLE PRIVS. GRANTED ROLE NOT NULL VARCHAR2(30). GRANTEE GRANTED ROLE DEF. XXXXX ARW APPS READ YES. FROM DBA TAB PRIVS.

http://manishappsdba.blogspot.com/

OVERVIEW OF manishappsdba.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

11

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR MANISHAPPSDBA.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

November

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Saturday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 3.5 out of 5 with 4 reviews

5 star

2

4 star

0

3 star

1

2 star

0

1 star

1

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

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.3 seconds

CONTACTS AT MANISHAPPSDBA.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

11

SSL

EXTERNAL LINKS

0

SITE IP

172.217.12.193

LOAD TIME

0.272 sec

SCORE

6.2

PAGE TITLE

Oracle Application DBA Posts | manishappsdba.blogspot.com Reviews

<META> DESCRIPTION

Oracle Application DBA Posts. Monday, October 1, 2012. Check privileges/role to table. NOTE* * * * * * * * *. Http:/ download.oracle.com/docs/cd/B10501 01/server.920/a96521/privs.htm. SQL desc DBA SYS PRIVS. GRANTEE NOT NULL VARCHAR2(30). PRIVILEGE NOT NULL VARCHAR2(40). SQL select GRANTEE,PRIVILEGE from DBA SYS PRIVS where GRANTEE='System';. XXXXX CREATE DATABASE LINK. SQL desc DBA ROLE PRIVS. GRANTED ROLE NOT NULL VARCHAR2(30). GRANTEE GRANTED ROLE DEF. XXXXX ARW APPS READ YES. FROM DBA TAB PRIVS.

<META> KEYWORDS

1 name null

2 type

3 admin option varchar2 3

4 grantee privilege

5 xxxxx unlimited tablespace

6 grantee varchar2 30

7 default role varchar2 3

8 xxxxx resource yes

9 xxxxx connect yes

10 posted by

CONTENT

Page content here

KEYWORDS ON PAGE

name null,type,admin option varchar2 3,grantee privilege,xxxxx unlimited tablespace,grantee varchar2 30,default role varchar2 3,xxxxx resource yes,xxxxx connect yes,posted by,manish chaudhari,no comments,v$session longops queries,rman backup details,where

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

Oracle Application DBA Posts | manishappsdba.blogspot.com Reviews

https://manishappsdba.blogspot.com

Oracle Application DBA Posts. Monday, October 1, 2012. Check privileges/role to table. NOTE* * * * * * * * *. Http:/ download.oracle.com/docs/cd/B10501 01/server.920/a96521/privs.htm. SQL desc DBA SYS PRIVS. GRANTEE NOT NULL VARCHAR2(30). PRIVILEGE NOT NULL VARCHAR2(40). SQL select GRANTEE,PRIVILEGE from DBA SYS PRIVS where GRANTEE='System';. XXXXX CREATE DATABASE LINK. SQL desc DBA ROLE PRIVS. GRANTED ROLE NOT NULL VARCHAR2(30). GRANTEE GRANTED ROLE DEF. XXXXX ARW APPS READ YES. FROM DBA TAB PRIVS.

INTERNAL PAGES

manishappsdba.blogspot.com

1

Oracle Application DBA Posts: All About TEMP

http://manishappsdba.blogspot.com/2012/10/all-about-temp.html

Oracle Application DBA Posts. Monday, October 1, 2012. Check TEMP USAGE * * * * * * *. Column username format a20. Column osuser format a15. Column size format a6. Column sid serial format a10. Column spid format 9999999. Col PROGRAM for a40. Column machine format a20. Column logon time format a22. SELECT a.username,. ROUND( (b.blocks*pa.value)/1024/1024),2) 'M' "SIZE",. Asid ',' a.serial# SID SERIAL,. Substr(a.program,1,20) PROGRAM,. Substr(machine,1,20) MACHINE,. FROM v$session a,. V$sort usage b,.

2

Oracle Application DBA Posts: April 2010

http://manishappsdba.blogspot.com/2010_04_01_archive.html

Oracle Application DBA Posts. Friday, April 23, 2010. All Important scripts used for Oracle Apps DBA. To check files which are of huge size. Du -a . sort -n -r head -n 10. My session details *. Select sid,serial# from v$session where sid=(select sid from v$mystat where rownum=1);. GRid agent bounce *. To check top 5 process consuming more cpu* * *. Ps axo pcpu,comm,pid,ruser,time,etime,args sort -nr head -n 5. To check top 5 process consuming more memory * *. Ps auxf sort -nr -k 4 head -5. Select INST ID...

3

Oracle Application DBA Posts: Blocking sessions details

http://manishappsdba.blogspot.com/2012/10/blocking-sessions-details.html

Oracle Application DBA Posts. Monday, October 1, 2012. Find blocking sessions on instance:. Col PROGRAM for a20. Col EVENT for a20. Col USERNAME for a8. Col WAIT CLASS for a10. Select inst id, SID, serial#, BLOCKING SESSION,rpad(WAIT CLASS,8). WAIT CLASS,SECONDS IN WAIT,PROGRAM, MODULE , EVENT ,username. From gv$session where BLOCKING SESSION is not null order by BLOCKING SESSION,PROGRAM;. To find the Details about SID. Col MODULE for a20. Col OSUSER for a10. Col USERNAME for a10. Col MACHINE for a20.

4

Oracle Application DBA Posts: September 2011

http://manishappsdba.blogspot.com/2011_09_01_archive.html

Oracle Application DBA Posts. Thursday, September 29, 2011. HISTORY OF CONCURRENT REQUEST - SCRIPT (PROGRAM WISE) * * *. Col "Who submitted" for a25. Col "Status" for a10. Col "Parameters" for a20. Col USER CONCURRENT PROGRAM NAME for a42. SELECT distinct t.user concurrent program name,. To char(r.ACTUAL START DATE,'dd-mm-yy hh24:mi:ss') "Started at",. To char(r.ACTUAL COMPLETION DATE,'dd-mm-yy hh24:mi:ss') "Completed at",. Appsfnd concurrent requests r ,. Appsfnd concurrent programs p ,. Order by to cha...

5

Oracle Application DBA Posts: All About UNDO

http://manishappsdba.blogspot.com/2012/10/all-about-undo.html

Oracle Application DBA Posts. Monday, October 1, 2012. Http:/ blog.oracle48.nl/oracle-database-undo-space-explained/. Select sum(bytes)/1024/1024/1024 as "TOTAL UNDO SIZE" from dba data files where tablespace name='APPS UNDOTS1';. Undo tablespace management.:. Round(sum bytes / (1024*1024), 0) as MB,. Round( sum bytes / undo size) * 100, 0) as PERC. Select status, sum(bytes) sum bytes. From dba undo extents. Select sum(a.bytes) undo size. From dba tablespaces c. Join gv$datafile a on a.ts# = b.ts#. APPS ...

UPGRADE TO PREMIUM TO VIEW 6 MORE

TOTAL PAGES IN THIS WEBSITE

11

OTHER SITES

manishapatnaik.wordpress.com

Protected Blog › Log in

This site is marked private by its owner. If you would like to view it, you’ll need two things:. A WordPress.com account. Don’t have an account? All you need is an email address and password register here! Permission from the site owner. Once you've created an account, log in and revisit this screen to request an invite. If you already have both of these, great! Larr; Back to WordPress.com.

manishapharmoplast.com

:||:: Manisha Pharmo Plast Pvt. Ltd. :||:

91 22 3028 7475 / 76. Manisha Pharmo Plast Pvt. Ltd. Is an ISO 22000: 2005; ISO 9001 : 2008; GMP; HACCP certified company, started in 1980’s to manufacture Nycil. The Company is in this business for over 30 years and places an emphasis on Quality Control and better House Keeping systems. Being Part of Deora’s Group. Our commitments in the Nutrition's and Co-packing is personified with support from our sister concern Graham BlowPack Pvt. Ltd. Vitamin and mineral supplements. Prickly Heat Powders / Talcum.

manishaplacements.com

MANISHA PLACEMENT CONSULTING (P) LTD HYDERABAD

MANISHA PLACEMENT CONSULTING (P) LTD. Building Careers, Building Organizations". Phone : 91 - 9849 997 730. 91 - 9949 365 100. Email : info@manishaplacements.com. 1 st floor, Federal Bank Building,. Main Road, Dr. AS Rao Nagar, Hyderabad - 40. 2 nd floor, K Ramona Central,. Opp Ayyappa Swamy temple, Sheelanagar, Visakhapatnam - 12.

manishaplastics.com

Manisha Plastics - Home

PVC Foam Board Sheets. Welcome To Manisha Plastics. We are pleased to introduce ourselves as one amongst the most eminent firms in Bangalore, predominantly specialized in the supply of a wide array of Acrylic plastic sheets, PVC foam board sheets and a variety of sign making materials. We not only offer Indian-made products but also best-quality imported ones which can be availed in the most affordable price ranges. PVC Foam Board Sheets. Manisha Plastics also involved in offering first-class quality mat...

manishappsdba.blogspot.com

Oracle Application DBA Posts

Oracle Application DBA Posts. Monday, October 1, 2012. Check privileges/role to table. NOTE* * * * * * * * *. Http:/ download.oracle.com/docs/cd/B10501 01/server.920/a96521/privs.htm. SQL desc DBA SYS PRIVS. GRANTEE NOT NULL VARCHAR2(30). PRIVILEGE NOT NULL VARCHAR2(40). SQL select GRANTEE,PRIVILEGE from DBA SYS PRIVS where GRANTEE='System';. XXXXX CREATE DATABASE LINK. SQL desc DBA ROLE PRIVS. GRANTED ROLE NOT NULL VARCHAR2(30). GRANTEE GRANTED ROLE DEF. XXXXX ARW APPS READ YES. FROM DBA TAB PRIVS.

manishappy-nengatik.blogspot.com

manis happy

Minggu, 14 April 2013. DAUN BINAHONG SEBAGAI OBAT HERBAL GAGAL GINJAL. Pada penderita gagal ginjal yang sudah akut dan kronis, akan diperlukan tindakan medis, yaitu cuci darah (dialisys) secara rutin dan terus-menerus. Cuci darah (dialisys) memerlukan biaya yang tidak sedikit. Pada beberapa RSUD biayanya Rp 500rb – 1 juta rupiah (kadang lebih). Dan pada beberapa rumah sakit swasta biayanya berkisar jutaan rupiah (biasanya). DAUN BINAHONG SEMBUHKAN GAGAL GINJAL. Menurut dr Zainal Gani, dokter dan herbalis...

manishaprabhakar.com

Manisha Prabhakar

manishaprabhu.com

Darshan Prabhu

Mr darshan Prabhu - India. Siddhakala building, Gurav Nagar, Pimpalbhat,. ALIBAG, Raigad district, Maharashtra State,. INDIA, pin 402209 Asia.

manishapunwanimd.com

Manisha Punwani, MD

ABOUT DR. PUNWANI. PRACTICE and TREATMENT APPROACH. 1801 Bush Street San Francisco, CA 94109 415-599-4349 itmatters2u@manishapunwanimd.com.

manisharaghunath.wordpress.com

A Bit of This & That – An insight into a bit of my thought process

A Bit of This and That. An insight into a bit of my thought process. 5 Pairs of Commonly Confused Homonyms. It seems like I have woken up from a deep slumber after 4 years! Anyway, let’s get to the point, shall we? Well, you might have very often noticed errors made by people while using homonyms. This happens when they mean something and due to the usage of the wrong homonym, end up conveying an altogether different meaning. So, here we go through a list of 5 such words along with their meanings. The Un...