Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on May 5th, 2012  |  syntax: None  |  size: 2.19 KB  |  hits: 14  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. DBMS_CRYPTO Performance Issues
  2. select decrypt(name), seq
  3.        
  4. select name, seq order by seq
  5.        
  6. ------------------------------------------------------------------------------------
  7. | Id  | Operation         | Name           | Rows  | Bytes | Cost (%CPU)| Time     |
  8. ------------------------------------------------------------------------------------
  9. |   0 | SELECT STATEMENT  |                |  8810 |  1453K|    98   (3)| 00:00:02 |
  10. |   1 |  TABLE ACCESS FULL| CSTN_MEMB_INFO |  8810 |  1453K|    98   (3)| 00:00:02 |
  11. ------------------------------------------------------------------------------------
  12.        
  13. ---------------------------------------------------------------------------------------------
  14. | Id  | Operation          | Name           | Rows  | Bytes |TempSpc| Cost (%CPU)| Time     |
  15. ---------------------------------------------------------------------------------------------
  16. |   0 | SELECT STATEMENT   |                |  8810 |  1453K|       |   428   (1)| 00:00:06 |
  17. |   1 |  SORT ORDER BY     |                |  8810 |  1453K|  3448K|   428   (1)| 00:00:06 |
  18. |   2 |   TABLE ACCESS FULL| CSTN_MEMB_INFO |  8810 |  1453K|       |    98   (3)| 00:00:02 |
  19. ---------------------------------------------------------------------------------------------
  20.        
  21. ---------------------------------------------------------------------------------------------
  22. | Id  | Operation          | Name           | Rows  | Bytes |TempSpc| Cost (%CPU)| Time     |
  23. ---------------------------------------------------------------------------------------------
  24. |   0 | SELECT STATEMENT   |                |  8810 |  1453K|       |   428   (1)| 00:00:06 |
  25. |   1 |  SORT ORDER BY     |                |  8810 |  1453K|  3448K|   428   (1)| 00:00:06 |
  26. |   2 |   TABLE ACCESS FULL| CSTN_MEMB_INFO |  8810 |  1453K|       |    98   (3)| 00:00:02 |
  27. ---------------------------------------------------------------------------------------------
  28.        
  29. select
  30.     seq, gender, wdate, address,
  31.     my_crypto_pkg.decrypt(tel, 'my_secret_key'),
  32.     my_crypto_pkg.decrypt(name, 'my_secret_key')
  33. from cstn_memb_info
  34. --  where my_crypto_pkg.decrypt(name, 'my_secret_key') like ?
  35. order by
  36.     seq desc
create a new version of this paste RAW Paste Data