- SQL
- PL/SQL
- DBA
- Developer / Forms
- Developer / Reports
- Developer / Graphics
- Data-Warehouse
 
 
 

 
> DBA-Village Weekly Newsletter 10 Gennaio 2005
 

Dear OIPStaff OIPStaff,

This is your DBA-Village Weekly Newsletter for Jan 10, 2005.

Prologue

Thanks you all for your feedback about the new layout of the site.

New items

Tip :

When was archive log applied to database

Tip :

Linux Creating/Starting/Stopping services

Script :

Merge data into a custom templa

Tip :

Partitioning in Oracle Data Warhouses ( Mr Tim Gorman )

Tip :

Materialized Views in Action ( Mr Jeff Maresh )

Paper :

Undo Tablespace Corruption

Tip :

Kill your sessions

Script :

Tablespace Storage 9i

Link :

Presentation on Oracle 10g

Link :

OTN Greatest Hits of 2004

Link :

AllenHayden.com - Oracle - Whitepaper library

Question

This is the new question for the next two weeks. Below you see the results of the previous question. Please share your answer with us.
(You will have to enter your DBA-Village username/password, which you may find at the bottom of this Email)

Question


How much time will you have in 2005 for learning new 9i and 10g features?

A lot of time + will follow courses

A lot of time, but mostly selfstudy

Probably some time but not guaranteed

Not a lot

Not interested or not applicable

Which of the following 9i features do you find most useful?

Flashback query

25 %

Resumable space allocation

22 %

Online table redefinition

32 %

Oracle managed files

21 %

There are 433 responses so far

Imho

Please feel free to give your opinion in our Imho section, or just read the opinions of others. The current topic is:

New forum threads

The following threads are new since the previous newsletter. Remember that you can follow up interesting threads by clicking on the little white envelope on the website. In that case you get an email when there is a reply in the thread. And of course at any moment you can deregister.

  1. CREATING a matrix query (2 repl.)
  2. UPDATE DATE WITH TIME (2 repl.)
  3. retrive newly inserted rows (7 repl.)
  4. What is oracle spatial (2 repl.)
  5. Shell script (2 repl.)
  6. Oracle database migration (2 repl.)
  7. Partioning tables (2 repl.)
  8. local_listener (4 repl.)
  9. Installtion Of 10g Database (1 repl.)
  10. Oracle Apps 9 and DB 7.1.6 movement
  11. export to excel format (10 repl.)
  12. PL\SQL Function - How to Output two values (4 repl.)
  13. Restore spfile using rman in catalog mode (2 repl.)
  14. controlfile size (1 repl.)
  15. Recovery in a test environment (2 repl.)
  16. db size (1 repl.)
  17. PKG_BDY cannot be seen (10 repl.)
  18. How to add weeks in a specific date (3 repl.)
  19. Table drop in begin backup mode (1 repl.)
  20. pl/sql (4 repl.)
  21. Urgent Help needed (1 repl.)
  22. shell script execution in windows (4 repl.)
  23. telnet using in shell script (2 repl.)
  24. Date of index creation (2 repl.)
  25. 11.5.9 installation on Linux Advanced Server 3.0 (3 repl.)
  26. Oracle10g App Server EM Console (Infrastructure & Midtier) hangs intermittently
  27. HELP: accessing AS400 data in Oracle (1 repl.)
  28. Tunning (4 repl.)
  29. 100% CPU usage (2 repl.)
  30. 9ias http server is not getting started after successfull installation (1 repl.)
  31. How to merge these blocks of Code. (2 repl.)
  32. Oracle Licensing and Hyper Threading :( (3 repl.)
  33. How do you choose objects from a dmp file after export ?? (2 repl.)
  34. ARCHIVELOG (2 repl.)
  35. Extract exact query (1 repl.)
  36. maximum number of processes (3 repl.)
  37. Oracle Debugger: reliable in production environment?
  38. OCP certificate not yet recieved (2 repl.)
  39. export and import issues (2 repl.)
  40. schema size (2 repl.)
  41. REDO error (4 repl.)
  42. MAX SGA Size on 32 bit Oracle (2 repl.)
  43. MAX SGA (2 repl.)
  44. Does an index coalesce reset the high water mark? (3 repl.)
  45. clearing records in v$object_usage (7 repl.)
  46. Pl/SQL (1 repl.)
  47. Database Creation (3 repl.)
  48. What is Oracle Virtual Indexes ? (2 repl.)
  49. Oracle 10g not starting after installation
  50. Really Urgent !! Creating database using Rman backup at different location
  51. how to make a good performance in oracle (3 repl.)
  52. Clarification related to creation of Indexes (4 repl.)
  53. package dbms_sql (2 repl.)
  54. About Dual...? (7 repl.)
  55. Hyperthreading (8 repl.)
  56. Search for a tip. (2 repl.)
  57. How to calculate the Unix Kernel parameter? (2 repl.)
  58. SQL*Loader-282: Unable to locate character set handle for character set ID (873). (5 repl.)
  59. redo-buffer (2 repl.)
  60. database takes lot of time to startup and shutdown (5 repl.)
  61. Geert is a champ! (1 repl.)
  62. Reports generic frontpage
  63. Calculation of REDO BUFFER size in SGA (5 repl.)
  64. ISQLPLUS (2 repl.)
  65. index rebuild (2 repl.)
  66. First day of the month (3 repl.)
  67. How to avoid full table scan when where column name is NULL (4 repl.)
  68. I am getting an error while installing 10g ...!!! (2 repl.)
  69. 1Z0-031,1Z0-032 exams (1 repl.)

Epilogue

We remind you that your username for DBA-Village is OIPStaff and that your password is OIPStaff. If you don't want this information to be included, go to the DBA-Village website and click on Update Account.
Do not reply on this mail. At the moment, replies are ignored. Use the feedback form instead.



Regards,
The DBA-Village Team