A Wetpaint Site

juancarlosreyesp

Profile
Friends
Compliments (1)
Contributions (64)

Page Contributions (64)
| Thread Contributions

This report displays all page contributions made by juancarlosreyesp.

1 2 3 4 | Next

	Page	Date/Time	Type	Scope
	Script	Sep 30 2008, 10:07 PM EDT	edit	2180 words added
Change: -- If you want to grant permission to specific executables BEWARE to match case in the executable path and name-- for example --EXEC DBMS_JAVA.GRANT_PERMISSION ('M', 'java.io.FilePermission', --'F:\oracle\ora92\bin\tkprof.exe', 'execute');EXEC DBMS_JAVA.GRANT_PERMISSION('M','java.lang.RuntimePermission','*','writeFileDescriptor' ); 2 Debug Script -- Tables and others for debugCREATE OR REPLACE DIRECTORY D_DEBUG_FILE AS 'C:\';GRANT View changes from previous version. (Word count: 2370) View all updates.
	Script	Sep 30 2008, 10:06 PM EDT	create	No content added or deleted.
Change: Created by juancarlosreyesp Sep 30 2008, 10:06 PM EDT for: no reason given View all updates.
	Configuring on Windows	Sep 30 2008, 10:02 PM EDT	edit	973 words added
Change: conn sys/orcl@127.0.0.1:1521/orcl as sysdba 1.C.iv Fast open Sqlplus /nolog, to open without asking to connect 1.C.v Faster inserts Additionally to the settings we talk about on “Fast Execution saving to log file”, if you are running a script with hundreds of inserts, setting auto commits will improve the process.SQL> View changes from previous version. (Word count: 1033) View all updates.
	Configuring on Windows	Sep 30 2008, 10:02 PM EDT	create	No content added or deleted.
Change: Created by juancarlosreyesp Sep 30 2008, 10:02 PM EDT for: no reason given View all updates.
	sql plus	Sep 30 2008, 10:01 PM EDT	create	No content added or deleted.
Change: Created by juancarlosreyesp Sep 30 2008, 10:01 PM EDT for: no reason given View all updates.
	Database Tools	Sep 30 2008, 10:01 PM EDT	create	No content added or deleted.
Change: Created by juancarlosreyesp Sep 30 2008, 10:01 PM EDT for: no reason given View all updates.
	Oracle Dictionary	Sep 30 2008, 9:59 PM EDT	edit	958 words added
Change: DBA_, are views showing information related to all user, and sometimes has more columns than ALL_ views, But I didn’t found a dba view having more columns than a all view, in the few test I did like this.SQL> select TABLE_NAME,count(*) from dba_tab_columns where View changes from previous version. (Word count: 1307) View all updates.
	Oracle Dictionary	Sep 30 2008, 9:58 PM EDT	create	No content added or deleted.
Change: Created by juancarlosreyesp Sep 30 2008, 9:58 PM EDT for: no reason given View all updates.
	Tracing	Sep 30 2008, 9:57 PM EDT	edit	1324 words added
Change: The main view where you will see this columns is V$SESSION, but if you execute a query will see there are other too. I can View changes from previous version. (Word count: 1390) View all updates.
	Tracing	Sep 30 2008, 9:56 PM EDT	create	No content added or deleted.
Change: Created by juancarlosreyesp Sep 30 2008, 9:56 PM EDT for: no reason given View all updates.
	Hanganalyze	Sep 30 2008, 9:55 PM EDT	edit	718 words added
Change: This hang was caused for using several dblinks on procedures on an import, this was solved setting COMPILE=N in the import process. Usually this kind View changes from previous version. (Word count: 1270) View all updates.
	Hanganalyze	Sep 30 2008, 9:55 PM EDT	create	No content added or deleted.
Change: Created by juancarlosreyesp Sep 30 2008, 9:55 PM EDT for: no reason given View all updates.
	Dumping data	Sep 30 2008, 9:54 PM EDT	edit	513 words added
Change: You can dump the content the memory, tables, indexes, etc. This helps you to understand how is his internal structure in some situations. The example of dumping is in the specific object analysis. 1.A Systemstate dump This dump is very interesting because dumps View changes from previous version. (Word count: 591) View all updates.
	Dumping data	Sep 30 2008, 9:54 PM EDT	create	No content added or deleted.
Change: Created by juancarlosreyesp Sep 30 2008, 9:54 PM EDT for: no reason given View all updates.
	oradebug	Sep 30 2008, 9:54 PM EDT	edit	555 words added
Change: The importance of this utility is because you have several utilities on one, and can be very handy.But as an undocumented utility you can’t use on production databases without Oracle support and guidance.SQL> oradebug help HELP [command] Describe one or all commandsSETMYPID Debug current processSETOSPID View changes from previous version. (Word count: 584) View all updates.
	oradebug	Sep 30 2008, 9:53 PM EDT	create	No content added or deleted.
Change: Created by juancarlosreyesp Sep 30 2008, 9:53 PM EDT for: no reason given View all updates.
	Events	Sep 30 2008, 9:53 PM EDT	edit	942 words added
Change: There is few official information about events to use it, means a lot of investigation, but anyway the results deserves the effort, one example is View changes from previous version. (Word count: 1086) View all updates.
	Events	Sep 30 2008, 9:52 PM EDT	create	No content added or deleted.
Change: Created by juancarlosreyesp Sep 30 2008, 9:52 PM EDT for: no reason given View all updates.
	DBMS_PROFILER	Sep 30 2008, 9:52 PM EDT	edit	1563 words added
Change: The first thing you will note, is the time is not in seconds else milliseconds, the reason is because in releases after 8i some statistics had increased the accuracy, but obviously dbms_profiler didn’t.You can see using IF is faster than using CASE in PL/SQL. GRAND_TOTA---------- 13590.82 RUNID View changes from previous version. (Word count: 1724) View all updates.
	DBMS_PROFILER	Sep 30 2008, 9:51 PM EDT	create	No content added or deleted.
Change: Created by juancarlosreyesp Sep 30 2008, 9:51 PM EDT for: no reason given View all updates.

1 2 3 4 | Next

JavaScript must be enabled in order for you to contribute to this site.
To start contributing, enable JavaScript by changing your browser options, then try again.

Home