orastory.wordpress.com
Epoch | OraStory
https://orastory.wordpress.com/2015/06/26/epoch
Dominic Brooks on Oracle Performance, Tuning, Data Quality and Sensible Design … (Now with added Sets Appeal). SQL Plan Baseline Manual Evolution. SQL Plan Management Choices →. June 26, 2015. Note to self because it’s just one of those date/timezone-related topics which just doesn’t seem to stick…. Epoch/Unix time – See https:/ en.wikipedia.org/wiki/Unix time. Firstly when converting from Oracle date or timestamp – we need to work from UTC not local time. Assuming that this timestamp is in milliseconds:.
ruepprich.wordpress.com
APEX 5: Packaged Application Icons | Christoph's 2 Oracle Cents
https://ruepprich.wordpress.com/2015/06/03/apex-5-packaged-application-icons
Christoph's 2 Oracle Cents. APEX 5: Packaged Application Icons. June 3, 2015 at 8:30 am Posted in Oracle Developement. To use some of the packaged application icons for your own applications, include the packaged apps css file in your application, and reference the appropriate css class for the icon you want. Navigate to Edit Application Definition - User Interface. And edit the interface for your application. Under Cascading Style Sheets. Here are the available packaged application icons:. Thanks Christ...
ruepprich.wordpress.com
ORDS 3 – Enabling RESTful service for database tables | Christoph's 2 Oracle Cents
https://ruepprich.wordpress.com/2015/06/18/ords-3-enabling-restful-service-for-database-tables
Christoph's 2 Oracle Cents. ORDS 3 – Enabling RESTful service for database tables. June 18, 2015 at 2:26 pm Posted in Oracle Developement. We’ll take a look at how to enable a RESTful service in ORDS 3.0 via PL/SQL, and how to retrieve some data and metadata from this service. ORDS 3.0 is installed and configured with RESTful services. A schema named ORDSTEST with the EMP and DEPT tables is installed. DBA privileges are needed to execute the PL/SQL. Schema with the URI path ot. To disable a schema use:.
ruepprich.wordpress.com
Hierarchical Query: Roll-up leaf nodes to ancestors. | Christoph's 2 Oracle Cents
https://ruepprich.wordpress.com/2015/06/26/hierarchical-query-roll-up-leaf-nodes-to-ancestors
Christoph's 2 Oracle Cents. Hierarchical Query: Roll-up leaf nodes to ancestors. June 26, 2015 at 11:54 am Posted in Oracle Developement. This query may be more applicable to a bill of materials type of query. I’ve added a new column to the EMP table (value number). Then I only populated a value for this column for the leaf nodes, i.e. the employees lowest in the hierarchy (ADAMS, SMITH, ALLEN, WARD, MARTIN, TURNER, JAMES, MILLER). Leave a Comment ». Feed for comments on this post. Enter your comment here.
kerryosborne.oracle-guy.com
Kerry Osborne’s Oracle Blog » Blog Archive » Interesting Oracle Syntax Error – Kerry Osborne’s Oracle Blog
http://kerryosborne.oracle-guy.com/2014/11/interesting-oracle-syntax-error
Kerry Osborne’s Oracle Blog. Just another Oracle blog. Oracle Whitepapers / Presentations. Laquo; Dallas Oracle Users Group Performance Meetup. Interesting Oracle Syntax Error. November 3, 2014, 2:20 pm. As shared by a well known Oracle and Big Data performance geek! Click here to cancel reply. Mail (will not be published). RMOUG 2016 – Controlling Execution Plans Workshop. NOUG Fall Training Day. Controlling Execution Plans Workshop. OTN LA Tour 2015 Presentations. Interesting Oracle Syntax Error.
kerryosborne.oracle-guy.com
Kerry Osborne’s Oracle Blog » 10gR2 Archives Flush a Single SQL Statement – Take 2 – Kerry Osborne’s Oracle Blog
http://kerryosborne.oracle-guy.com/category/oracle/10gr2
Kerry Osborne’s Oracle Blog. Just another Oracle blog. Oracle Whitepapers / Presentations. Archive for the ‘10gR2’ Category. Flush a Single SQL Statement – Take 2. December 12, 2008, 12:34 pm. I posted earlier about the ability to flush a single SQL statement out of the shared pool in 11g (also back ported to 10.2.0.4 with a bit of extra work) here. So I wrote a little script (like I always do) and called it flush sql10.sql. There are a couple of things to be aware of with it. I don’t like having t...
kerryosborne.oracle-guy.com
Kerry Osborne’s Oracle Blog » Kerry Osborne’s Oracle Blog
http://kerryosborne.oracle-guy.com/page/2
Kerry Osborne’s Oracle Blog. Just another Oracle blog. Oracle Whitepapers / Presentations. Interesting Oracle Syntax Error. November 3, 2014, 2:20 pm. As shared by a well known Oracle and Big Data performance geek! SQL ALTER SYSTEM SET inmemory size = 5T SCOPE=spfile; ALTER SYSTEM SET inmemory size = 5T SCOPE=spfile * ERROR at line 1: ORA-32005: error while parsing size specification [5T] SQL ALTER SYSTEM SET inmemory size = 5120G SCOPE=spfile; System altered. Dallas Oracle Users Group Performance Meetup.
kerryosborne.oracle-guy.com
Kerry Osborne’s Oracle Blog » Blog Archive » Displaying SQL Baseline Plans – Kerry Osborne’s Oracle Blog
http://kerryosborne.oracle-guy.com/2012/03/displaying-sql-baseline-plans
Kerry Osborne’s Oracle Blog. Just another Oracle blog. Oracle Whitepapers / Presentations. Laquo; Hotsos Symposium 2012. Free Instant SQL Formatter. Displaying SQL Baseline Plans. March 15, 2012, 3:33 pm. The 11.2 documentation (Oracle Database PL/SQL Packages and Types Reference) says this about the DISPLAY SQL PLAN BASELINE function:. But what does that mean? Run a statement that uses an index and check the plan. Create a Baseline on the statement using the index (using my create baseline.sql. Pretty t...
kerryosborne.oracle-guy.com
Kerry Osborne’s Oracle Blog » Blog Archive » 12c In-Memory in PDB – Kerry Osborne’s Oracle Blog
http://kerryosborne.oracle-guy.com/2014/09/12c-in-memory-in-pdb
Kerry Osborne’s Oracle Blog. Just another Oracle blog. Oracle Whitepapers / Presentations. Laquo; The Next Big Thing. 12c In-Memory on RAC. 12c In-Memory in PDB. September 12, 2014, 4:21 pm. In preparation for our upcoming 12c In-Memory Webcast. So we’ve enabled inmemory at the container level. Now let’s check the PDB. Note: The CDB/PDB is still a little weird for me. I use this little script to set SQL*Plus prompt to keep me straight. connect pdb.sql. Th-th-th-that’s all folks! Click here to cancel reply.