This blog is created for the oracle DBA community who search a lot for valuable data on the internet. This is compilation of posts from various forums and groups. Oracle Database community is growing by the day and the necessity of such a blog will be felt very soon. Monday, February 20, 2012. Installing Oracle VM Server From a CDROM. To overwrite the existing installation. Installing Oracle VM Server From a CDROM.

Some useful links and scripts to manage Oracle. Friday, February 26, 2010.

Creating custom top in release12. Opening forms from linux machine. Replacing Jinitiator with JRE for Oracle Apps 11i. Enabling SSL for E-Business suite 11i. Executing gather schema statistics at backend. How to find patchset level.

Understanding CPU on AIX Power SMT Systems. This month I worked with a chicagoland company to improve performance for eBusiness Suite on AIX. Nevertheless, I got thrown for a loop this week. In the end, it came down to a fundamental change in resource accounting that IBM introduced with the POWER7 processor in 2010. Time that the process spent on the CPU.

January 31, 2008 by budignwn. Setelah susah Install Oracle dari versi Oracle 9i 2 dan Oracle 10 g rel 2. Di windows Vista , akhirnya dapat Trik untuk menjalankan. Right Click on Command Prompt. Left click on Run as Administrator. Button if it asks you for permission. Reboot and DEP should be off.

If you have paid attention to my other blog entries you have already figured that I am a fan of Literate Database Work. As well as a user of Vertica. And sql-interactive-mode are quite powerful. I combined them with yasnippet. A package you can install via MELPA. If you are like me you probably. For the last 6 years I used Perl and the Catalyst MVC framework. I wanted to switch to Orgmode.

Thursday, August 11, 2016. Temporary tablespace takes ages to drop. The reason behind this is quite simple, even if the users defaults to a different temporary tablespace there could still be sessions holding temporary segments there.

x 버전에서 테스트한 내용임! Oracle에서는 테이블에 date형의 컬럼을 만들면서 default 값을 sysdate로 넣어주면, 명시적으로 null 값을 넣으려하거나 insert 문장에서 해당 컬럼이 빠져도 현재 시각이 입력되게 되어 있다. 이런 설정을 여러개의 컬럼에 적용할 수 있다는게 아주 당연한 일이었다. PostgreSQL도 마찬가지로 current timestamp나 current date 둥을 여러 컬럼에 default로 설정해 줄 수 있다. 기본적으로 MySQL에서는 하나의 테이블에 하나의 timestamp 컬럼에만 current timestamp를 넣어줄 수 있다고한다. 그러나 꼼수가 존재하니 아래 코드를 돌려보시길. Id INT NOT NULL,.