andzsr.blogspot.com
De AndZs Torial: Desember 2009
http://andzsr.blogspot.com/2009_12_01_archive.html
Selasa, 22 Desember 2009. Explain Plan in Oracle. Explain plan in Oracle shows execution plan in Oracle which is choose by oracle optimizer for select statements, insert, update and delete statements. Informations we can get from explain plan in Oracle are :. Table used for sql statement we want to explain. Access method in tables we access. Steps for executing the sql. Steps using explain plan in Oracle :. Use explain plan by using this sql : EXPLAIN PLAN. SET STATEMENT ID = 'some identifier'. After tha...
andzsr.blogspot.com
De AndZs Torial: Explain Plan in Oracle
http://andzsr.blogspot.com/2009/12/explain-plan-in-oracle.html
Selasa, 22 Desember 2009. Explain Plan in Oracle. Explain plan in Oracle shows execution plan in Oracle which is choose by oracle optimizer for select statements, insert, update and delete statements. Informations we can get from explain plan in Oracle are :. Table used for sql statement we want to explain. Access method in tables we access. Steps for executing the sql. Steps using explain plan in Oracle :. Use explain plan by using this sql : EXPLAIN PLAN. SET STATEMENT ID = 'some identifier'. Template ...
andzsr.blogspot.com
De AndZs Torial: Oracle Database Monitoring
http://andzsr.blogspot.com/2014/04/oracle-database-monitoring.html
Rabu, 23 April 2014. Why Monitor Oracle Database. Database need to be monitored to check the performance of the monitored database, so we can change the database parameter based on result from monitoring and keep the database in it’s best performance. Database monitoring also needed so we always know the condition of database, and know the symptom of our database and we can take action right before more problem happens to database. Types of Oracle Database Monitoring. Examples of Trend Analysis are, make...
andzsr.blogspot.com
De AndZs Torial: SQL query for monitoring (next article Oracle Database Monitoring For Beginner)
http://andzsr.blogspot.com/2009/04/sql-query-for-monitoring-next-article.html
Jumat, 17 April 2009. SQL query for monitoring (next article Oracle Database Monitoring For Beginner). This article is the sequel of my article Oracle Database Monitoring for Beginner. 1 Query for Status Monitoring. Examples of Status Monitoring are, check tablespace where it's about to fills up, check segment near their maximum extents. This query will show tablespace with percentage free less than 20 percent or equal 20 percent. Select ddf.TABLESPACE NAME,. DdfBYTES-DFS.BYTES "BYTES USED",. Show object...
sowacz.blogspot.com
Sowacz blog, DBA and GNU/Linux Admin notes : ORACLE LINKS
http://sowacz.blogspot.com/2008/10/oraclelinks.html
Sowacz blog, DBA and GNU/Linux Admin notes. Old good html metalink. Free and Open Source Software. Critical Patch Updates and Security Alerts. Critical Patch Updates and Security Alerts FAQ. Oracle Database on AIX,HP-UX,Linux,Mac OS X,Solaris,Tru64 Unix Operating Systems Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1). Simple template. Powered by Blogger.
gasparotto.blogspot.com
On The Peoplesoft Road: Oracle 11.2.0.2 (out-of-place install)
http://gasparotto.blogspot.com/2010/10/oracle-11202-out-of-place-install.html
On The Peoplesoft Road. Oracle and PeopleSoft administration tasks. Sunday, October 03, 2010. Oracle 11.2.0.2 (out-of-place install). From the first patchset of Oracle 11gR2 (11.2.0.2), we are able to install it from “scratch” without having the need to install the based version (in most of the case *.1, e.g. 11.2.0.1), called out-of-place. Moreover, the Installer offers also the possibilities to install the latest PSU (PatchSet Update, a set of one-off patches and CPU) within a special step. Remember, I...
gasparotto.blogspot.com
On The Peoplesoft Road: Peoplesoft Installs
http://gasparotto.blogspot.com/p/installation.html
On The Peoplesoft Road. Oracle and PeopleSoft administration tasks. Here below, the links of all my articles I wrote about the Peoplesoft installation across the different versions of application and tools. Before going for a Peoplesoft Installation, I strongly recommand to read the article about Peoplesoft Database concept. Peoplesoft Installation (HRMS9.1 - PT8.50). Tuxedo10gR3 (10.3.0). Weblogic11gR1 (10.3.1). Peopletools 8.50.00 (console mode). Peopletools 8.50.06 (console mode). Oracle Linux 6.0.
andzsr.blogspot.com
De AndZs Torial: April 2009
http://andzsr.blogspot.com/2009_04_01_archive.html
Jumat, 17 April 2009. SQL query for monitoring (next article Oracle Database Monitoring For Beginner). This article is the sequel of my article Oracle Database Monitoring for Beginner. 1 Query for Status Monitoring. Examples of Status Monitoring are, check tablespace where it's about to fills up, check segment near their maximum extents. This query will show tablespace with percentage free less than 20 percent or equal 20 percent. Select ddf.TABLESPACE NAME,. DdfBYTES-DFS.BYTES "BYTES USED",. Show object...
gasparotto.blogspot.com
On The Peoplesoft Road: DRAC5 on Poweredge 2900III
http://gasparotto.blogspot.com/2015/06/drac5-on-poweredge-2900iii.html
On The Peoplesoft Road. Oracle and PeopleSoft administration tasks. Sunday, June 07, 2015. DRAC5 on Poweredge 2900III. It may sound old hardware, but still works like a charm and pretty good. I had a chance to get a Dell Remote Access Card (DRAC5). Easy to install, a little bit less to access. Once you configured the IP from the boot, you can access the card from a browser (this is a small webserver). 6/01/2015 02:17:42:500: packet type( 0x100). 160; at sun.security.ssl.AppOutputS...160; at...160;...
hrivera99.blogspot.com
Oracle by Madrid: December 2014
http://hrivera99.blogspot.com/2014_12_01_archive.html
Tuesday, December 09, 2014. This error recently showed up in a 11.2.0.3.0 Enterprise Edition RDBMS on Oracle Enterprise Linux: ORA-00600: internal error code, arguments: [kdiRelocateCommitted:DBAupd], [2126573183], [], [], [], [], [], [], [], [],. Incident details in: /u01/app/oracle/diag/rdbms/ . ora 5642 i10412.trc. Alter index INDEX OWNER.INDEX NAME modify partition PART NAME shrink space. ERROR at line 1:. The error is not documented, and so far Oracle Support doesn't have information about this error.
SOCIAL ENGAGEMENT