I've been reviewing a lot of resume's lately. Please tell me, what is the purpose stating your "Job Objective"? Isn't it implied that your objective is to find a new job, specifically my job? I assume you're dynamic and technical and your vast expertise will help my company conquer the world.
Also, what is the purpose of summarizing your experience on the first page and then giving me eight more pages of the stuff you just summarized? Seriously, doesn't resume mean summary?
I've been at this for 20+ years, my resume is 2 pages. I don't need to know you did export/import at every one of your jobs for the last 12 years.
Back to the stack...
Tuesday, January 24, 2012
Monday, January 09, 2012
For People That Have Managers
Interesting take on what managers are thinking: http://quickbase.intuit.com/blog/2012/01/09/10-things-your-boss-isnt-telling-you/
Tuesday, November 01, 2011
Is SQL*Plus Resumable?
I am using resumable space for a lot of my operations. However, it seems as though the SQL*Plus copy command doesn't respect the resumable feature?
Note, I am issuing an "alter session enable resumable timeout 14400" through a login trigger. I know this works because if I do the same type of operation through an INSERT/SELECT through a dblink, my session waits for more space to be added.
Note, I am issuing an "alter session enable resumable timeout 14400" through a login trigger. I know this works because if I do the same type of operation through an INSERT/SELECT through a dblink, my session waits for more space to be added.
user@whouse1.us> select sysdate from dual; SYSDATE ------------------- 11/01/2011 15:48:45 Elapsed: 00:00:00.03 user@whouse1.us> COPY FROM user1/pw@proddb.us TO user/password@whouse1.us append dest_table (f1, f2, f3) using select f1, f2, f3 from source_table; Array fetch/bind size is 1000. (arraysize is 1000) Will commit after every 1000 array binds. (copycommit is 1000) Maximum long size is 80. (long is 80) ERROR: ORA-01653: unable to extend table USER.DEST_TABLE by 4096 in tablespace JH_TEST user@whouse1.us> select sysdate from dual; SYSDATE ------------------- 11/01/2011 15:49:01 Elapsed: 00:00:00.03Is RESUMABLE space not available with SQL*Plus copy?
Wednesday, September 28, 2011
Interesting Error
We just upgraded one of our 10.2.0.3 dbs to 11.2.0.2 plus some patches. Today an interesting ORA-07445 was thrown to the alert.log:
Searching metalink didn't get us anywhere, so we opened a TAR (or iTar, or SR, or ServReq, or whatever the heck they are calling them these days). While Oracle Support was looking at the issue, I looked at the query generating the error:
Huh? If the value is null, substitute a null? WTF?
Presto-changeo...
...and the error goes away.
Is it a bug on Oracle's side? Sure.
Is it a stupid thing to do on our side? You betcha.
ORA-07445: exception encountered: core dump [__intel_new_memcpy()+382] [SIGILL] [ADDR:0x3FE5CAE] [PC:0x3FE5CAE] [Illegal operand] []
Searching metalink didn't get us anywhere, so we opened a TAR (or iTar, or SR, or ServReq, or whatever the heck they are calling them these days). While Oracle Support was looking at the issue, I looked at the query generating the error:
SELECT nvl(t.value, null) FROM table t WHERE t.id = 12345;
Presto-changeo...
SELECT t.value FROM table t WHERE t.id = 12345;
...and the error goes away.
Is it a bug on Oracle's side? Sure.
Is it a stupid thing to do on our side? You betcha.
Thursday, September 15, 2011
Common Sense
Developer:
I am running this query:
DELETE FROM tab;
It's been running since 2PM yesterday. Can you make it go faster?
DBA:
You shouldn't delete 80M rows in a single transaction. You should have used TRUNCATE instead of DELETE. I have killed your session and it will be a while before it completes.
Developer (5 minutes later):
I tried TRUNCATE but it says my table is locked.
DBA:
I know, the table will be locked up for a while while the transaction rolls back.
Developer:
Can you make it go faster?
DBA:
I have turned on _transmogrify_delete_queries on so that is the best I can do.
Developer:
Thanks!! That should definitely help!!!
I am running this query:
DELETE FROM tab;
It's been running since 2PM yesterday. Can you make it go faster?
DBA:
You shouldn't delete 80M rows in a single transaction. You should have used TRUNCATE instead of DELETE. I have killed your session and it will be a while before it completes.
Developer (5 minutes later):
I tried TRUNCATE but it says my table is locked.
DBA:
I know, the table will be locked up for a while while the transaction rolls back.
Developer:
Can you make it go faster?
DBA:
I have turned on _transmogrify_delete_queries on so that is the best I can do.
Developer:
Thanks!! That should definitely help!!!
Wednesday, June 01, 2011
KEEP Pool
I have a persnickety problem with a particular table being aged out of the buffer cache. I have one query that runs on a defined basis. Sometimes when it is run, it does a lot of physical reads for this table. Other times, it does no physical reads.
So I decided to play around with a different buffer pool and let this table age out of cache on it's own terms rather than competing in the greater default pool. So far, it seems to be working pretty well.
I'll admit it, it's been a long time since I used a KEEP pool. Some helpful KEEP pool resources:
Edward Stoever at Database-expert.com
ORAFAQ
James Colestock
asktom.oracle.com
Standard Disclaimer: I understand that 99.9% of the time you don't need a KEEP pool. In this situation it seems to be warranted.
So I decided to play around with a different buffer pool and let this table age out of cache on it's own terms rather than competing in the greater default pool. So far, it seems to be working pretty well.
I'll admit it, it's been a long time since I used a KEEP pool. Some helpful KEEP pool resources:
Edward Stoever at Database-expert.com
ORAFAQ
James Colestock
asktom.oracle.com
Standard Disclaimer: I understand that 99.9% of the time you don't need a KEEP pool. In this situation it seems to be warranted.
Wednesday, May 25, 2011
Compression and SE
While researching a corrupt block on 11g SE, we came across a number of objects that were compressed according to the data dictionary.
How could that be? Compression is not a feature of SE, or so we thought.
The objects in question were all indexes. In fact, Oracle creates compressed indexes in ?/apex/core/tab.sql even though we are on SE.
Further investigation lead me to Doc 1084132.1 which calls the feature "Basic table compression".
Just something to be aware of.
How could that be? Compression is not a feature of SE, or so we thought.
The objects in question were all indexes. In fact, Oracle creates compressed indexes in ?/apex/core/tab.sql even though we are on SE.
Further investigation lead me to Doc 1084132.1 which calls the feature "Basic table compression".
Just something to be aware of.
Subscribe to:
Posts (Atom)








