javeedkaleem-oracledba.blogspot.com

Oracle DBA

Wednesday, November 17, 2010. MVIEW refresh Status on MASTER Site :. Col SNAPSHOT SITE for a30. Select r.name, r.snapshot site, l.current snapshots. From dba registered snapshots r, dba snapshot logs l. Where r.snapshot id = l.snapshot id and l.master in (select master. From dba snapshot logs) ;. Show all materialized and resfresh times. Set lines 100 pages 999. Col last refresh format a20. To char(last refresh date, 'dd/mm/yy hh24:mi') last refresh. Order by owner, last refresh. Manually start a refresh.

http://javeedkaleem-oracledba.blogspot.com/

OVERVIEW OF javeedkaleem-oracledba.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 JAVEEDKALEEM-ORACLEDBA.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

January

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Sunday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 3.8 out of 5 with 13 reviews

5 star

7

4 star

0

3 star

4

2 star

0

1 star

2

Hey there! Start your review of javeedkaleem-oracledba.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.6 seconds

FAVICON PREVIEW

16x16
32x32

CONTACTS AT JAVEEDKALEEM-ORACLEDBA.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

216.58.205.1

LOAD TIME

0.64 sec

SCORE

6.2

PAGE TITLE

Oracle DBA | javeedkaleem-oracledba.blogspot.com Reviews

<META> DESCRIPTION

Wednesday, November 17, 2010. MVIEW refresh Status on MASTER Site :. Col SNAPSHOT SITE for a30. Select r.name, r.snapshot site, l.current snapshots. From dba registered snapshots r, dba snapshot logs l. Where r.snapshot id = l.snapshot id and l.master in (select master. From dba snapshot logs) ;. Show all materialized and resfresh times. Set lines 100 pages 999. Col last refresh format a20. To char(last refresh date, 'dd/mm/yy hh24:mi') last refresh. Order by owner, last refresh. Manually start a refresh.

<META> KEYWORDS

1 oracle dba

2 materialized view

3 set linesize 180

4 clear columns

5 select owner

6 mview name

7 from dba mviews

8 posted by

9 javeedkaleem

10 reactions

CONTENT

Page content here

KEYWORDS ON PAGE

oracle dba,materialized view,set linesize 180,clear columns,select owner,mview name,from dba mviews,posted by,javeedkaleem,reactions,no comments,purpose,performance diagnostic information,scope and application,3 statspack reports,and tkprof,prerequisites

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

Oracle DBA | javeedkaleem-oracledba.blogspot.com Reviews

https://javeedkaleem-oracledba.blogspot.com

Wednesday, November 17, 2010. MVIEW refresh Status on MASTER Site :. Col SNAPSHOT SITE for a30. Select r.name, r.snapshot site, l.current snapshots. From dba registered snapshots r, dba snapshot logs l. Where r.snapshot id = l.snapshot id and l.master in (select master. From dba snapshot logs) ;. Show all materialized and resfresh times. Set lines 100 pages 999. Col last refresh format a20. To char(last refresh date, 'dd/mm/yy hh24:mi') last refresh. Order by owner, last refresh. Manually start a refresh.

INTERNAL PAGES

javeedkaleem-oracledba.blogspot.com

1

Oracle DBA: November 2008

http://javeedkaleem-oracledba.blogspot.com/2008_11_01_archive.html

Sunday, November 16, 2008. Regular scripts for Oracle DBA. Select prev hash value from v$session where sid='&sid;. SQL select prev hash value from v$session where sid='466'. Select sql text from v$sqlarea where hash value='&hash value'. SQL select sql text from v$sqlarea where hash value='590983'now kill the holders session;select * from v$lock where block=1;. Select username ,status,logon time,process,osuser,sid,serial#,sql hash value from v$session where status='ACTIVE' order by logon time;. Select a&#...

2

Oracle DBA: How to take backup of dblinks & synonym etc

http://javeedkaleem-oracledba.blogspot.com/2008/11/how-to-take-backup-of-dblinks-synonym.html

Sunday, November 16, 2008. How to take backup of dblinks and synonym etc. For Dropping objects :. Select 'drop 'object type,owner'.' object name';' from dba objects where owner='BPA2' and object type! Select 'drop 'object type,owner'.' object name' cascade constraint;' from dba objects where owner='BPA2' and object type! Taking the backup of Synonyms :. Select 'create synonym 'synonym name' for 'table owner'.'table name'@'db link'. Create Synonym Script from dba synonyms where owner=upper('&owner');.

3

Oracle DBA: Materialized View

http://javeedkaleem-oracledba.blogspot.com/2010/11/materialized-view.html

Wednesday, November 17, 2010. MVIEW refresh Status on MASTER Site :. Col SNAPSHOT SITE for a30. Select r.name, r.snapshot site, l.current snapshots. From dba registered snapshots r, dba snapshot logs l. Where r.snapshot id = l.snapshot id and l.master in (select master. From dba snapshot logs) ;. Show all materialized and resfresh times. Set lines 100 pages 999. Col last refresh format a20. To char(last refresh date, 'dd/mm/yy hh24:mi') last refresh. Order by owner, last refresh. Manually start a refresh.

4

Oracle DBA: November 2010

http://javeedkaleem-oracledba.blogspot.com/2010_11_01_archive.html

Wednesday, November 17, 2010. MVIEW refresh Status on MASTER Site :. Col SNAPSHOT SITE for a30. Select r.name, r.snapshot site, l.current snapshots. From dba registered snapshots r, dba snapshot logs l. Where r.snapshot id = l.snapshot id and l.master in (select master. From dba snapshot logs) ;. Show all materialized and resfresh times. Set lines 100 pages 999. Col last refresh format a20. To char(last refresh date, 'dd/mm/yy hh24:mi') last refresh. Order by owner, last refresh. Manually start a refresh.

5

Oracle DBA: February 2010

http://javeedkaleem-oracledba.blogspot.com/2010_02_01_archive.html

Tuesday, February 23, 2010. RMAN Performance Tuning Diagnostics. RMAN Performance Tuning Diagnostics [ID 311068.1]. Provide diagnostic reference for collecting RMAN backup. You should have some skills in database performance evaluation. RMAN Performance Tuning Diagnostics. Collecting performance information regarding RMAN backup. Performance problems, bottlenecks come from somewhere. Not all tracing. Shown here is required. It is up to you to determine which will help. What should be collected? The failu...

UPGRADE TO PREMIUM TO VIEW 4 MORE

TOTAL PAGES IN THIS WEBSITE

9

OTHER SITES

javeedbashadi3.blogspot.com

ABDULLAH BIN AHMED BASHADI

Thursday, 13 June 2013. ABDULLAH BIN AHMED BASHADI (INDIA) 01-06-2013 PHOTOS. Mohammed Bin Mahmood Bashadi. Subscribe to: Posts (Atom). Mohammed Bin Mahmood Bashadi. View my complete profile. Mohammed Bin Mahmood Bashadi. Awesome Inc. template. Powered by Blogger.

javeeddu13.skyrock.com

Blog de javeeddu13 - Blog de javeeddu13 - Skyrock.com

Mot de passe :. J'ai oublié mon mot de passe. Plus d'actions ▼. S'abonner à mon blog. Création : 24/07/2012 à 18:21. Mise à jour : 24/07/2012 à 18:21. Ce blog n'a pas encore d'articles. Abonne-toi à mon blog! Poster sur mon blog.

javeedfood.com

Javeed Food Stuff – Dubai, UAE Food Stuff – Dole, Rio Mare

Javeed Food Stuff Co.L.L.C stablished in 2004 in Dubai .our activity are : Canned Fruits , Canned Juice , fruit in cups, fruit in Jars, Fruit with Jelly in cups , Parfait ,custard with fruits canned vegetable ,Fruit snack under Dole Brand. Office No 2201,2202. Business Tower, Business Bay. Tel :04-4452893 (4 lines).

javeedhussain.wordpress.com

JAH | Am not gonna live forever, learn from me while am here…!!!

Am not gonna live forever, learn from me while am here…! Hello to all those lovely people out there…. Am writing this blog post about Denmark after living here for 6 years. School and schooling system in Denmark. Everyday life in Denmark. Create a free website or blog at WordPress.com.

javeedishaq.blogspot.com

Javeed Ishaq thoughts express

Javeed Ishaq thoughts express. Subscribe to: Posts (Atom). View my complete profile. Awesome Inc. theme. Powered by Blogger.

javeedkaleem-oracledba.blogspot.com

Oracle DBA

Wednesday, November 17, 2010. MVIEW refresh Status on MASTER Site :. Col SNAPSHOT SITE for a30. Select r.name, r.snapshot site, l.current snapshots. From dba registered snapshots r, dba snapshot logs l. Where r.snapshot id = l.snapshot id and l.master in (select master. From dba snapshot logs) ;. Show all materialized and resfresh times. Set lines 100 pages 999. Col last refresh format a20. To char(last refresh date, 'dd/mm/yy hh24:mi') last refresh. Order by owner, last refresh. Manually start a refresh.

javeedkaleem.blogspot.com

Oracle DBA

javeedmuhammad.wordpress.com

javeedmuhammad

Accéder au contenu principal. Bonjour tout le monde! Il s’agit de votre tout premier article Cliquez sur le lien Modifier pour le modifier ou le supprimer ou commencez un nouvel article. Si vous le souhaitez, utilisez cet article pour indiquer aux lecteurs pourquoi vous avez commencé ce blog et ce que vous envisagez d’en faire. Bon succès avec votre blog! Bonjour tout le monde! Sur Bonjour tout le monde…. Bonjour tout le monde! Sur Bonjour tout le monde…. Propulsé par WordPress.com.

javeedmunshi.com

Javeed Munshi - Home

Publications - Books and Design Aids. Publications - Journal and Conference Papers. PhD, PE, SE, FACI, FASCE, FSEI. CONCRETE STRUCTURES SPECIALIST AND. Javeed Munshi has over 25 years of experience in design, evaluation, and construction of concrete structures. He is a licensed Professional Engineer in the states of New York, Maryland and Wisconsin, and a licensed Structural Engineer in Illinois. Create a free website.

javeedsukhera.com

Welcome

Dr javeed sukhera md, frcpc. Dr Sukhera practices Child and Adolescent Psychiatry, researches the impact of implicit bias and advocates for the under-served. He speaks to groups or organizations about identity, politics, healthcare, education and mental illness stigma. Meet Dr. Sukhera.