tech.e2sn.com

garrettseibt.com

gseibt | Garrett Seibt's Oracle database blog

http://www.garrettseibt.com/database/author/gseibt

Garrett Seibt's Oracle database blog. September 8, 2011. I liked this explanation for “How Oracle process concurrent queries” on the OTN boards: https:/ forums.oracle.com/forums/thread.jspa? ThreadID=2280009&tstart=0 Unlike few databases (they too have changed the behaviour now), Oracle never locks the table for read operations. First of all, Oracle always have to pick up blocks as of right now (consistent mode) for a query and in current […]. Troubleshooting Oracle Cluster Verification Utility failed.

garrettseibt.com

limit number of rows | Garrett Seibt's Oracle database blog

http://www.garrettseibt.com/database/tag/limit-number-of-rows

Garrett Seibt's Oracle database blog. Tag Archives: limit number of rows. Top N query and Pagination. December 29, 2010. How to return only “n” number of records, usually the most recent 20, 50, or 100 rows. How to return “n” number of records one page at a time. Although you can use either one to accomplish either goal; This article will explain when it’s appropriate to use each one, how to exploit the strengths of each query and how to avoid the pitfalls of each. To get the top n records:. Use nl (.

hemantoracledba.blogspot.com

The difference between SELECT ANY DICTIONARY and SELECT_CATALOG_ROLE

https://hemantoracledba.blogspot.com/2014/02/the-difference-between-select-any.html

Hemant's Oracle DBA Blog. I am an Oracle Database Specialist in Singapore. Get an rss feed of this blog at http:/ hemantoracledba.blogspot.com/feeds/posts/default? Follow me on twitter : @HemantKChitale. Search My Oracle Blog. 06 February, 2014. The difference between SELECT ANY DICTIONARY and SELECT CATALOG ROLE. I've seen some DBAs confused about these two "privileges" or "roles". SELECT ANY DICTIONARY is a System Privilege. SELECT CATALOG ROLE predates the SELECT ANY DICTIONARY privilege. It is SELECT...

hemantoracledba.blogspot.com

Bringing ONLINE a Datafile that is in RECOVER mode because it was OFFLINE

https://hemantoracledba.blogspot.com/2009/04/bringing-online-datafile-that-is-in.html

Hemant's Oracle DBA Blog. I am an Oracle Database Specialist in Singapore. Get an rss feed of this blog at http:/ hemantoracledba.blogspot.com/feeds/posts/default? Follow me on twitter : @HemantKChitale. Search My Oracle Blog. 22 April, 2009. Bringing ONLINE a Datafile that is in RECOVER mode because it was OFFLINE. A recent forums thread. Was about a Datafile that had been taken OFFLINE by the DBA and was in RECOVER mode. SQL select log mode from v$database;. SQL archive log list;. Current log sequence 2.

aprakash.wordpress.com

Silent Upgrade Oracle GoldenGate 12.1.2.0.0 to 12.1.2.1.2 | Anand's Blog

https://aprakash.wordpress.com/2015/04/21/silent-upgrade-oracle-goldengate-12-1-2-0-0-to-12-1-2-1-2

My experiences and views on Oracle Database. Silent Upgrade Oracle GoldenGate 12.1.2.0.0 to 12.1.2.1.2. April 21, 2015. April 21, 2015. Today I worked on silent upgrade of Oracle GoldenGate from 12.1.2.0.0 to 12.1.2.1.2, so thought to blog it which might help some of you. These are the steps I performed. Current GoldenGate Home – /oracle/app/product/ogg12.1.2. 1 Gather the details of GoldenGate Processes before stopping them. 2 Backup the existing binaries and associated files needed for your environment.

garrettseibt.com

Top N query and Pagination | Garrett Seibt's Oracle database blog

http://www.garrettseibt.com/database/2010/12/top-n-query-and-pagination

Garrett Seibt's Oracle database blog. Oracle RAC 11g VMware Part 5 Grid install. Troubleshooting Oracle Cluster Verification Utility failed ». Top N query and Pagination. December 29, 2010. To get the top n records:. 1 Ensure proper indexing on applicable columns (access predicates first and then the ordered columns):. Create index test index on A TABLE(column a,column b,column c DESC,column d);. 2 Use this query (this example is using top 50 rows):. FIRST ROWS (. ROWNUM rnum from (. COLUMN D ). There ar...

garrettseibt.com

11gR2 | Garrett Seibt's Oracle database blog

http://www.garrettseibt.com/database/tag/11gr2

Garrett Seibt's Oracle database blog. Troubleshooting Oracle Cluster Verification Utility failed. January 17, 2011. When installing GRID the Cluster Verification Utility ( CVU ) can fail if DNS is not configured correctly or in this case if you have your SCAN IP entries in your /etc/host file. Found inconsistent name resolution entries for SCAN name. Name resolution setup check for “rac-scan” (IP address 192.168.1.202) failed. Don’t put SCAN IP addresses in the /etc/host file. 11gR2 (11.2.0.1).

datavirtualizer.com

Data Virtualizer » Oaktable World past years

http://datavirtualizer.com/oaktable-world/oaktable-world-2012

Free your data and the rest will follow! Oaktable World past years. Delphix & Oracle 12c. J Lewis on Delphix. Oaktable World past years. October 2nd, 2015. Agenda for Oaktable World 2014, located at Creativity Museum. Also on Tues 10am-5pm hands on labs with Delphix, DBvisit, Confio. 8:30 am) Mogens: welcome. Carlos Sierra: introducing edb360 tool slides. Riyaj Shamsudeen: in-memory internals slides. Kent Graziano: Worst Practices in DW Design slides. Tanel Poder: Hacking Oracle 12c video. Jonathan Genni...

hemantoracledba.blogspot.com

V$DATABASE.CREATED -- is this the Database Creation timestamp ?

https://hemantoracledba.blogspot.com/2010/07/vdatabasecreated-is-this-database.html

Hemant's Oracle DBA Blog. I am an Oracle Database Specialist in Singapore. Get an rss feed of this blog at http:/ hemantoracledba.blogspot.com/feeds/posts/default? Follow me on twitter : @HemantKChitale. Search My Oracle Blog. 20 July, 2010. V$DATABASE.CREATED - is this the Database Creation timestamp? Some of us who have done more than one CREATE CONTROLFILE and observed what happens know that V$DATABASE.CREATED is not "Creation date of the database". Here's a simple demonstration :. 11 - STANDBY LOGFILE.