oracledba-in.com

OracleDba.In - All Article of OracleDba.In

Saturday, September 28, 2013. Finding out Last DDL and DML Activity on a Table. I received one of a mail with the query of how could we figure out Last DML and DDL time on a table. Here is a small piece of SQL Commands to get the same info. Create table t (t1 number,t2 varchar2(20),t3 date);. Here is how you could find the same. 2 (select last ddl time from dba objects where object name='T' and owner='SYS') "DDL Time",. 3 decode(maxscn,0,'N/A',scn to timestamp(maxscn) "DML Time". DDL Time DML Time. 2012-...

http://www.oracledba-in.com/

OVERVIEW OF oracledba-in.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

19

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR ORACLEDBA-IN.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

July

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Saturday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 4.5 out of 5 with 8 reviews

5 star

4

4 star

4

3 star

0

2 star

0

1 star

0

Hey there! Start your review of oracledba-in.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

CONTACTS AT ORACLEDBA-IN.COM

Domains By Proxy, LLC

Registration Private

Domain●●●●●●xy.com

14747 N Norths●●●●●●●●●●●●●●e 111, PMB 309

Sco●●●ale , Arizona, 85260

United States

1.48●●●●2599

1.48●●●●2598

OR●●●●●●●●●●●●●●@domainsbyproxy.com

View this contact

Domains By Proxy, LLC

Registration Private

Domain●●●●●●xy.com

14747 N Norths●●●●●●●●●●●●●●e 111, PMB 309

Sco●●●ale , Arizona, 85260

United States

1.48●●●●2599

1.48●●●●2598

OR●●●●●●●●●●●●●●@domainsbyproxy.com

View this contact

Domains By Proxy, LLC

Registration Private

Domain●●●●●●xy.com

14747 N Norths●●●●●●●●●●●●●●e 111, PMB 309

Sco●●●ale , Arizona, 85260

United States

1.48●●●●2599

1.48●●●●2598

OR●●●●●●●●●●●●●●@domainsbyproxy.com

View this contact

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

DOMAIN REGISTRATION INFORMATION

REGISTERED: 2011 October 21
UPDATED: 2013 October 14
EXPIRATION: EXPIRED REGISTER THIS DOMAIN

BUY YOUR DOMAIN

DOMAIN AGE

13

YEARS
6

MONTHS
7

DAYS

NAME SERVERS

1: ns41.domaincontrol.com
2: ns42.domaincontrol.com

REGISTRAR

GODADDY.COM, LLC

WHOIS : whois.godaddy.com

REFERRED : http://registrar.godaddy.com

CONTENT

PAGES IN
THIS WEBSITE

19

SSL

EXTERNAL LINKS

0

SITE IP

0.0.0.0

LOAD TIME

0 sec

SCORE

6.2

PAGE TITLE

OracleDba.In - All Article of OracleDba.In | oracledba-in.com Reviews

<META> DESCRIPTION

Saturday, September 28, 2013. Finding out Last DDL and DML Activity on a Table. I received one of a mail with the query of how could we figure out Last DML and DDL time on a table. Here is a small piece of SQL Commands to get the same info. Create table t (t1 number,t2 varchar2(20),t3 date);. Here is how you could find the same. 2 (select last ddl time from dba objects where object name='T' and owner='SYS') DDL Time,. 3 decode(maxscn,0,'N/A',scn to timestamp(maxscn) DML Time. DDL Time DML Time. 2012-...

<META> KEYWORDS

1 loading

2 table created

3 oracledba in select

4 4 from

5 1 row created

6 oradba in select

7 from

8 commit complete

9 1 row updated

10 table altered

CONTENT

Page content here

KEYWORDS ON PAGE

loading,table created,oracledba in select,4 from,1 row created,oradba in select,from,commit complete,1 row updated,table altered,0 comments,email this,blogthis,share to twitter,share to facebook,share to pinterest,materialized view dropped,3 begin,5 loop

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

OracleDba.In - All Article of OracleDba.In | oracledba-in.com Reviews

https://oracledba-in.com

Saturday, September 28, 2013. Finding out Last DDL and DML Activity on a Table. I received one of a mail with the query of how could we figure out Last DML and DDL time on a table. Here is a small piece of SQL Commands to get the same info. Create table t (t1 number,t2 varchar2(20),t3 date);. Here is how you could find the same. 2 (select last ddl time from dba objects where object name='T' and owner='SYS') "DDL Time",. 3 decode(maxscn,0,'N/A',scn to timestamp(maxscn) "DML Time". DDL Time DML Time. 2012-...

INTERNAL PAGES

oracledba-in.com

1

OracleDba.In - All Article of OracleDba.In: February 2011

http://www.oracledba-in.com/2011_02_01_archive.html

Saturday, February 19, 2011. Asm - Part 5 : Acfs Snapshot For Advm Managed Volumes. In this article i would demonstrate you on how to secure your ADVM Volumes by creating a snapshot copy of it. A snapshot copy is a widely used concept with Storage Vendors, where they use it to reduce backup and recovery. Snapshot Copy is the read only copy of a partition at a particular point in time. It doesn't take much time to create the snapshot. And would be accessible from inside the .ACFS directory. Rw-r- - - 1 or...

2

OracleDba.In - All Article of OracleDba.In: October 2010

http://www.oracledba-in.com/2010_10_01_archive.html

Thursday, October 21, 2010. Sub Partitioned - Execute Immediate Using Bind Variable. Yesterday ireceiveda question from Moinul who work for Robi Axiadata in bangladesh, please find the answer of the query. Hope you are doing well. INTO dimension.TBL DIM OP CX. USING (select distinct op cx,op cx operator from TBL TRANS PR VOICE CALL(. ON ( vc.op cx = dim.op cx ). UPDATE SET dim.snap date = ' '. INSERT ( dim.op cx. VALUES ( vc.op cx. Dbms output.put line(sql text). Above code snap is not working. Create ta...

3

OracleDba.In - All Article of OracleDba.In: Finding out Last DDL and DML Activity on a Table

http://www.oracledba-in.com/2013/09/test.html

Saturday, September 28, 2013. Finding out Last DDL and DML Activity on a Table. I received one of a mail with the query of how could we figure out Last DML and DDL time on a table. Here is a small piece of SQL Commands to get the same info. Create table t (t1 number,t2 varchar2(20),t3 date);. Here is how you could find the same. 2 (select last ddl time from dba objects where object name='T' and owner='SYS') "DDL Time",. 3 decode(maxscn,0,'N/A',scn to timestamp(maxscn) "DML Time". DDL Time DML Time. 2012-...

4

OracleDba.In - All Article of OracleDba.In: July 2010

http://www.oracledba-in.com/2010_07_01_archive.html

Thursday, July 29, 2010. Rolling upgrade Rough steps. Put both database in mount mode. Database A - Primary. Database B - Physical standby. Create restore point in Database A. Create standby controlfile in Database A. Convert your physical standby database to logical with keep identity. So that it utilize the earlier primary as the current physical standby. Upgrade the Logical standby system and Database with new version ( Software Installation ). Use Software installation and startup upgrade ). And rest...

5

OracleDba.In - All Article of OracleDba.In: January 2012

http://www.oracledba-in.com/2012_01_01_archive.html

Wednesday, January 25, 2012. Finding out Last DDL and DML Activity on a Table. I received one of a mail with the query of how could we figure out Last DML and DDL time on a table. Here is a small piece of SQL Commands to get the same info. Create table t (t1 number,t2 varchar2(20),t3 date);. Here is how you could find the same. 2 (select last ddl time from dba objects where object name='T' and owner='SYS') "DDL Time",. 3 decode(maxscn,0,'N/A',scn to timestamp(maxscn) "DML Time". DDL Time DML Time. 2012-0...

UPGRADE TO PREMIUM TO VIEW 14 MORE

TOTAL PAGES IN THIS WEBSITE

19

OTHER SITES

oracledb.com

Click here to proceed.

oracledb.wordpress.com

Oracle Database Exchanging Experiences | Just another WordPress.com weblog but more technically oriented to Oracle Database

Oracle Database Exchanging Experiences. I’ve created this blog about four months ago. My initial intent was to challenge with english language, to open my possibilities to exchange experiences (from which the blog title) with other persons from all over the world. It is written in my mother-tongue so there i’ve written more information that here. I was inspired also by Jonathan Lewis and his Oracle Scratchpad. To view my posts on this blog you have to go. On this page named “All Postings”. That my sign o...

oracledb101.wordpress.com

Oracle Database 101 | Exploring Whats Possible With Data

Exploring Whats Possible With Data. March 26, 2018. 181c New Features Part I. 181 is now available on Oracle Cloud so going to cover some of the new features. Topics like Multitentant have enough new features to warrant a dedicated post. So with that lets dive in. OCI Timeout – With using the OCI driver applications can set a time out when making DB calls. This prevents a long running call or a call that is being blocked from making it look like the application is hung. Parallel Queue Timeout – Wit...

oracledba-duniya.blogspot.com

Oracle DBA

oracledba-guide.blogspot.com

Oracle DBA Guide

Wednesday, May 12, 2010. DIM-00014: Cannot open the Windows NT Service Control Manager. One of the most common error that user faced in using oradim utility is :. DIM-00014: Cannot open the Windows NT Service Control Manager. O/S-Error: (OS 5) Access is denied. This error is common in Windows Vista and windows 7 . So the solution is very simple ,. Just goto start wirte cmd ,cmd icon appears ,right click on it . Then click on "Run as administrator" and then create your required service . Nter any desired ...

oracledba-in.com

OracleDba.In - All Article of OracleDba.In

Saturday, September 28, 2013. Finding out Last DDL and DML Activity on a Table. I received one of a mail with the query of how could we figure out Last DML and DDL time on a table. Here is a small piece of SQL Commands to get the same info. Create table t (t1 number,t2 varchar2(20),t3 date);. Here is how you could find the same. 2 (select last ddl time from dba objects where object name='T' and owner='SYS') "DDL Time",. 3 decode(maxscn,0,'N/A',scn to timestamp(maxscn) "DML Time". DDL Time DML Time. 2012-...

oracledba-interview.blogspot.com

Oracle DBA Interview

Tuesday, March 30, 2010. Oracle DBA 11g Lesson- 28 Monitoring and Tuning RMAN. Oracle DBA Interview Questions and Answers, CBT, Oracle E-books, Certifications http:/ oracledba-interview.blogspot.com. 1)This is a workshop for 11G complete each ppt in 1 days and 25 days u can become gem in oracle 11g DBA. 2)This below form is PPT so office 2003 or 2007 should be available in system to see it clearly. 3)Each PPT contain 10 to 50 slides so click the next button to see the next side. Les 10 Tune Rman. Oracle ...

oracledba-kuwait.blogspot.com

CORE DBA KNOWLEDGE SOURCE

CORE DBA KNOWLEDGE SOURCE. Thursday, January 3, 2008. Oracle Application Documents Downloadable. Oracle Application release 12 Documents http:/ downloaduk.oracle.com/docs/cd/B34956 01/current/html/docset.html. Releas12 ,12,11i,11i http:/ www.oracle.com/technology/documentation/applications.html. Release 11.5.10.2 Document libraury http:/ download.oracle.com/docs/cd/B25516 18/current/html/docset.html. Tuesday, January 1, 2008. 7 Tips on becoming an ERP consultant. The beauty of this ERP is, it always keep...

oracledba-ocp.blogspot.com

Oracle D.B.A. - O.C.P.

Oracle D.B.A. - O.C.P. Este sitio esta dedicado a todas las personas que dia a dia trabajamos en la ardua tarea de administrar, optimizar y estudiar el RDBMS de ORACLE Corp. EXPLICACION DEL ITL ENQUEUE. Query para verificar que un evento enqueue hace . Cambiar el poder de balanceo de una instancia ASM. Ing Juan Carlos Castro. Ing de Sistemas en la U.D.A., O.C.P. ORACLE 10G. Ver todo mi perfil. Martes, 31 de marzo de 2009. EXPLICACION DEL "ITL ENQUEUE". SID SERIAL# TY OBJECT NAM HELD REQUEST. Una vez que ...

oracledba-skills.com

Oracle DBA Skills | Know real time Oracle DBA skills…

Know real time Oracle DBA skills…. Easy online loans no paperwork. Welcome to WordPress. This is your first post. Edit or delete it, then start blogging! This entry was posted in Uncategorized. March 31, 2014. Proudly powered by WordPress.

oracledba-tunning.blogspot.com

oracle dba and performance tunning

Oracle dba and performance tunning. Thursday, 19 November 2009. Oracle 11g New Features for Administrators. Detailed explanation of the concepts. Details of using Oracle Grid Control in implementing the concepts. What is not covered? The document discussed new features in Oracle 11g in only the topics as stated in the contents section. New features introduced in other areas are not covered. To mention some of them, this document does not cover the new features in the following areas:. Oracle Database 11g...