|
| |
| |
| |
|
Statistics |
| Unique Visitors: 0 |
| Total Unique Visitors: 249944 |
| Visitors Out: 6553 |
| Total Visitors Out: 15785 |
|
|
|
| |
|
|
| |
|
| How to deploy files in a remote server? |
| 2009-01-06 23:09:49 |
It's easy you say, just share your drives when you connect through rdp --> http://technet2.microsoft.com/windowsserver/en/library/f47ce263-f72e-469d-bf14-6605b7f4cce51033.mspx?mfr=true. Ok, let's talk about worse case scenario, yo...
|
| |
|
| Oracle : Reduce your parsing times |
| 2009-01-06 23:08:25 |
All the queries that you execute in an Oracle database are parsed and then executed. However, is a nonsense(and a time wastefulness) to parse over and over the same query, even if executed by different users.So, to avoid this, Oracle uses a 'Shared pool' area where all the cursors are cached after being parsed.How it works? It's easy:Your query is hashed;Oracle searchs share...
|
| |
|
| Oracle : SQLCODE and SQLERRM in Inserts |
| 2009-01-06 23:07:44 |
Today I came across an unexpected problem when executing an exception block inside a procedure :My code was something like this :insert into dc_...
|
| |
|
| SQL * Plus Tip - 1 |
| 2009-01-06 23:07:15 |
To change the previous query, just type EDIT, this command ...
|
| |
|
| Oracle : Reducing join execution time |
| 2009-01-06 23:06:42 |
After executing a join over two tables, whith 4 million rows each and indexes in join columns, I realized that 4 minutes it's too much time waiting for results. So I decided to watch for the execution plan :select columns from tableA join TableB on tableA.id = tableB.idExecution Plan---------------------------------------------------------- 0 SELECT STATEMENT Optimizer=RULE 1 0 FILTER 2 1 SORT (GROUP BY) 3 2 TABLE ACCESS (BY INDEX ROWID) OF 'TABLEA' 4 3 NESTED LOOPS 5 4 TABLE ACCESS (FULL) OF 'TABLEB' 6 4 I...
|
| |
|
| PL/SQL Tip - 1 |
| 2009-01-06 23:04:24 |
Query v$parameter view for BD parameters checking.In...
|
| |
|
| PL/SQL : Show locked objects |
| 2009-01-06 23:03:56 |
Today, after trying unsuccessfully to drop my temporary tables, and subsequent fails due to object locks, I t...
|
| |
|
| PL/SQL : How to update using select |
| 2009-01-06 23:03:04 |
This "problem" came across me when I needed to update an entire temporary table column. One option is to loop all table rows, borin...
|
| |
|
| PL/SQL : Scripting for table drop |
| 2009-01-06 23:01:59 |
I came from MS SQLServer and I miss a lot of nice functionalities, like for instance, If exists.Why am I talking about this? Simple, I want to run ...
|
| |
|
|
| |
 |
