piontekdd.blogspot.com
Prestidigitation of Oracle: Don't Cramp My (SQL) Style ... Musings from an Oracle DBA
http://piontekdd.blogspot.com/2008/10/dont-cramp-my-sql-style-musings-from.html
Revealing some of the magic of the Oracle RDBMS and related tools, as well as a look behind the curtain of my life. Friday, October 31, 2008. Don't Cramp My (SQL) Style . Musings from an Oracle DBA. This post was inspired by a Twitter thread. That took place on October 31st between myself. Maybe I only included Don for his tongue in cheek, playground banter), and @surfsearcher. Besides commas at the start of a line (sql, plsql), I also hate mixed case sql and plsql". I believe the gist of what Chet.
piontekdd.blogspot.com
Prestidigitation of Oracle: 10g Migration Ramification Part 1: ORA-1426, Numeric Overflow
http://piontekdd.blogspot.com/2008/07/10g-migration-ramification-part-1-ora.html
Revealing some of the magic of the Oracle RDBMS and related tools, as well as a look behind the curtain of my life. Sunday, July 27, 2008. 10g Migration Ramification Part 1: ORA-1426, Numeric Overflow. In part 1, I will discuss an ORA-1426 you may encounter in PL/SQL code if you are using large literal integers and expecting a NUMBER type to hold it. Lv results NUMBER := 0;. Lv results := 999999999 * 3;. PL/SQL procedure successfully completed. ERROR at line 1:. ORA-06512: at line 4. New Oracle 10g Code:.
piontekdd.blogspot.com
Prestidigitation of Oracle: ASP State and SQL Server: The Mirror Has Three Faces
http://piontekdd.blogspot.com/2008/07/asp-state-and-sql-server-mirror-has.html
Revealing some of the magic of the Oracle RDBMS and related tools, as well as a look behind the curtain of my life. Thursday, July 24, 2008. ASP State and SQL Server: The Mirror Has Three Faces. In the spirit of Jonathan Lewis' recent post, Sometimes, Everything I Write Sucks! Comes today's installment of the Prestidigitation of Oracle. Today's prestidigitation. This is part one in the series and will go over the set up of a custom ASP session state. Server database that is set up in a SQL. Mirroring and...
piontekdd.blogspot.com
Prestidigitation of Oracle: May 2008
http://piontekdd.blogspot.com/2008_05_01_archive.html
Revealing some of the magic of the Oracle RDBMS and related tools, as well as a look behind the curtain of my life. Monday, May 12, 2008. Tablespace 195% Full . must be the metric system. ALTER DATABASE DATAFILE '/u01/oracle/data01/blah.dbf' RESIZE 8GB;. I resumed the datapump and went on my merry way. A few minutes later I received an email from Grid Control that the tablespace was 195% full. 195%? Some further digging I discovered that the TABLESPACE SIZE field includes the max autoextensible size of t...
piontekdd.blogspot.com
Prestidigitation of Oracle: March 2009
http://piontekdd.blogspot.com/2009_03_01_archive.html
Revealing some of the magic of the Oracle RDBMS and related tools, as well as a look behind the curtain of my life. Monday, March 16, 2009. OT: Spring Ahead with The Pretender . Never Surrender. I have been anticipating the arrival of alice.com. In recent months. In the beginning, my interest was more due to the fact that I had worked with some of the alice employees. I think one is a Prairie Dog, one may be a Gopher, and I'm not sure what the other's are. Created by Bradd Piontek. The Tom Kyte Blog.
piontekdd.blogspot.com
Prestidigitation of Oracle: November 2008
http://piontekdd.blogspot.com/2008_11_01_archive.html
Revealing some of the magic of the Oracle RDBMS and related tools, as well as a look behind the curtain of my life. Friday, November 21, 2008. 10g Migration Ramification Part 2: Making the database a safer place. In Part 2, I will be discussing a couple of the security changes Oracle has made in 10g Release 2 that have affected my life as a. Changes to the DEFAULT profile:. Oracle has made a change to the out-of-the-box setting of. Attempts without a valid loginlogin. I've seen this change in security ca...
piontekdd.blogspot.com
Prestidigitation of Oracle: April 2008
http://piontekdd.blogspot.com/2008_04_01_archive.html
Revealing some of the magic of the Oracle RDBMS and related tools, as well as a look behind the curtain of my life. Friday, April 18, 2008. Rotate your Logs . Two birds with one stone. I'll wait until early next week to update the SR and close the SR with Oracle Support. While they didn't really help me solve my problem and I did 99% of the troubleshooting myself, I did learn about the emdiag toolkit and found some interesting items in that log. Created by Bradd Piontek. Subscribe to: Posts (Atom).
piontekdd.blogspot.com
Prestidigitation of Oracle: IOUG RAC Attack! ... I surrender!!!
http://piontekdd.blogspot.com/2008/07/ioug-rac-attack-i-surrender.html
Revealing some of the magic of the Oracle RDBMS and related tools, as well as a look behind the curtain of my life. Wednesday, July 23, 2008. The Oracle RAC SIG. Are putting on an event in a few weeks in Chicago, August 4th and 5th. It is called the IOUG RAC Attack! Has to say in the Oracle Clusterware lecture as well as Jeremy Schneider's. Oracle Services lecture. Hopefully one of my colleagues attend and take good notes and share with the group when they return. *hint hint*. Or both) to put together on...
piontekdd.blogspot.com
Prestidigitation of Oracle: OT: Spring Ahead with The Pretender ... Never Surrender
http://piontekdd.blogspot.com/2009/03/ot-spring-ahead-with-pretender-never.html
Revealing some of the magic of the Oracle RDBMS and related tools, as well as a look behind the curtain of my life. Monday, March 16, 2009. OT: Spring Ahead with The Pretender . Never Surrender. I have been anticipating the arrival of alice.com. In recent months. In the beginning, my interest was more due to the fact that I had worked with some of the alice employees. I think one is a Prairie Dog, one may be a Gopher, and I'm not sure what the other's are. Created by Bradd Piontek. Regardless, after my i...
piontekdd.blogspot.com
Prestidigitation of Oracle: 10g Migration Ramification Part 2: Making the database a safer place
http://piontekdd.blogspot.com/2008/11/10g-migration-ramification-part-2.html
Revealing some of the magic of the Oracle RDBMS and related tools, as well as a look behind the curtain of my life. Friday, November 21, 2008. 10g Migration Ramification Part 2: Making the database a safer place. In Part 2, I will be discussing a couple of the security changes Oracle has made in 10g Release 2 that have affected my life as a. Changes to the DEFAULT profile:. Oracle has made a change to the out-of-the-box setting of. Attempts without a valid loginlogin. I've seen this change in security ca...
