Dear OIPStaff OIPStaff,

This is your DBA-Village Weekly Newsletter.

New items

News: Oracle announces quarterly critical patch updates

Script: script to query all table row counts

Script: Reset DBID

Paper: Simple steps to follow to setup a standby database in 9i

Link: Generate Execution Plans Directly from the Library Cache !!

Link: Oracle 8i Quick Reference Card

Link: Oracle Security Checks

Link: Introduction to Oracle SQL Tuning

Link: Oracle Architecture for beginners

Link: Oracle 10g vs. MS SQL Server 2005

Script: Simple management of Oracle environments on UNIX or LINUX.

Script: Recovery Manager Setup

Paper: Oracle Recovery Manager

Question

By answering this question, you will see an overview of all results so far.
(You will have to enter your DBA-Village username/password, which you may find at the bottom of this email)

Imho

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

• What is your opinion about Oracle Technical Support? Give your opinion or read the opinion of others.

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. tnsnames.ora (1 repl.)
2. How to Delete a Record in a multi-record block ? (1 repl.)
3. how can i find tools "convert oracle form 3.0 to oracle form 5,6,6i " (3 repl.)
4. Why The Agent service is fial after Installing oRacle9i on Red hat 9 (1 repl.)
5. To set as default owner of the database (2 repl.)
6. cann't connect to oracle10g (5 repl.)
7. Bug in Oracle Enterprise Manager Console 9i ...
8. Linux to Windows connection (2 repl.)
9. loading the data to Server (2 repl.)
10. data retrieval very slow from a table (3 repl.)
11. Helpme!!! database down (12 repl.)
12. Tablespace I/O stats for TEMP tablespace (1 repl.)
13. !!!!! Dynamic SQL!!!!! (5 repl.)
14. 9iRAC - OCFS2
15. linking errors (3 repl.)
16. CJQ0 - User Process ? (1 repl.)
17. How to detect tables that experienced and are experiencing a wait. (3 repl.)
18. How should I backup the rman repository database (2 repl.)
19. modify the dbid (5 repl.)
20. URG : Oracle Applications Error APP-00222
21. trigger help (5 repl.)
22. cronjob is not running (16 repl.)
23. Intermittent ORA-12541 TNS-No Listener (4 repl.)
24. Full Import (2 repl.)
25. How to download forms 6i path 16 (4 repl.)
26. Expert one-on-one Oracle book (2 repl.)
27. straightforward query (4 repl.)
28. Oracle 9i Seed Database (2 repl.)
29. SQL*Plus exit (3 repl.)
30. Oracle block size (8 repl.)
31. RMAN 8i Script issue (4 repl.)
32. using the rank functionality in pl/sql table (1 repl.)
33. Legato and RMAN Backup Error (7 repl.)
34. can i set large_pool_size in bytes or in KB,or in MB (2 repl.)
35. DB link (1 repl.)
36. how to find whether database is referencing init.ora or spfile. (7 repl.)
37. Create standby Database for 10g RAC Databases (3 repl.)
38. Performance Tuning (5 repl.)
39. Rman error: OS 7009 the modem.inf file was not found (1 repl.)
40. pl/sql table -updateion (1 repl.)
41. To whom the DBA belongs to (5 repl.)
42. Dbms_Output.Put_Line Not Printing As Desired !! (6 repl.)
43. Select Query (4 repl.)
44. anatlitical function rank (1 repl.)
45. RAC and shared disk (1 repl.)
46. High Volume Tables (8 repl.)
47. the computer is slow after install oracle (3 repl.)
48. Error while installing 11i
49. Does root directory of ORACLE_HOME grow during migration ? (3 repl.)
50. SQL from Unix (4 repl.)
51. xml and dtd
52. 8.1.7 (3 repl.)
53. version control (7 repl.)
54. trigger (5 repl.)
55. Info needed on Oracle Benchmark Application
56. RMAN Backup to tape failing (2 repl.)
57. granule size (1 repl.)
58. Metalink. (2 repl.)
59. replication problem .urgent.....
60. Overhead of migrating from 8i to 9i (1 repl.)
61. tuning database buffer cache (1 repl.)
62. Cpu and nested loop (2 repl.)
63. Implementing a procedure on the database (1 repl.)
64. Oracle 9i DBA PDFs (2 repl.)
65. JInitiator on Linux Box
66. RAM utilization
67. Default quota to a table? (2 repl.)
68. RESOURCE & UNLIMITED TABLESPACE (6 repl.)
69. PCC-S-02322, found undefined identifier (1 repl.)
70. Can UNIX verify the date with Oracle database. (5 repl.)
71. RAC on Red Hat Linux (1 repl.)
72. Alter a normal table to a partitioned table (1 repl.)
73. Forms 4.5 Debugging (1 repl.)
74. Trouble installing Oralcle Apps (1 repl.)
75. How can I include SPOOL command in a Procedure (4 repl.)
76. two instances in the same machine same dbname (1 repl.)
77. Shutdown immediate leaves memory segments (4 repl.)
78. listener crashes whenever DB shut (3 repl.)
79. mv log (2 repl.)
80. 12560 TNS: protocol adapter error. (2 repl.)
81. partition on the hour of the day (6 repl.)
82. datafile information (7 repl.)
83. Oracle 9i DBA (2 repl.)
84. Packages going into invalid state (1 repl.)

Upcoming events

• Conference: Oracle on Unix

Oracle installation,Administration,security,Managing multiple database,Tunning system parameters,Diff flavour of unix with diff' version of oracle

If you organize an interesting event related to Oracle, please post it on our site.

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