Dear OIPStaff OIPStaff,

This is your DBA-Village Weekly Newsletter.

New items

Link: How much Redo is written by Oracle

Script: Get the allocation map of tablespaces

Script: Get the allocation map of objects

Script: Gathers basic O/S performance stats.

Script: Script to set-up a menu of available oracle instances

Paper: A brief guide to scp

Paper: Step by step guide to replace Oracle Names with Oracle LDAP

Link: Supinfo Oracle Laboratory

Link: Scaling Oracle8i - The Creative Commons Release

Link: Optimal DBA

Link: What Oracle9i Flashback Query Can Do For You

Link: Tons of Tips and links to other Sites

Link: Unix Semaphores and Shared Memory Explained

Link: Very Good PL/SQL Tuning PPT. Includes SQL Tuning too.

Paper: External Tables

Link: Installing 10g RAC on Red Hat Enterprise Linux Advanced Server 3

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)

There are 631 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:

• 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. nls_ncharacterset vs nls_nchar_characterset (2 repl.)
2. calling procedure with nclob input from asp (1 repl.)
3. finding selected rowids (2 repl.)
4. ldapsearch fails with Operations error
5. catexp.sql run by system not sys (1 repl.)
6. Need guidance on Data Warehousing (3 repl.)
7. Oracle enterrise manager (3 repl.)
8. ORA-07445 Core Dump (4 repl.)
9. How to add/drop a column without re-creating the materialized view ?? (2 repl.)
10. Help with STATSPACK (2 repl.)
11. oracle client 7.2.2 on windows 2000 (11 repl.)
12. Oracle Reports 6, How can I print something only on the each last page of a repeating frame
13. Histograms (1 repl.)
14. Data Guard - Standby DB (2 repl.)
15. Logging in and logging out of a sqlplus session takes time (1 repl.)
16. data file status in v$datafile is Recover (2 repl.)
17. how i should design new tablespace ? (2 repl.)
18. DBA tasks (2 repl.)
19. OAM pages aren't displayed. (2 repl.)
20. PATCHES REQUIRED (3 repl.)
21. Prerequisites required!!! for Installation (3 repl.)
22. what i have to see in STATSPACK report? (9 repl.)
23. What i have to see in STATSPACK report? urgent..urgent...
24. Instance will not start-up (7 repl.)
25. Grant Schema (3 repl.)
26. Maximum no. of Parameters in Stored proc/func (5 repl.)
27. compiling objects from oem
28. calculation of time difference (3 repl.)
29. Difference between Oracle 9i Enterprise Edition And Oracle 9i Standard Edition (4 repl.)
30. ifrun_dumpxxxxx Failure Error
31. urgent -user privileges problem... (7 repl.)
32. Why i cann't export file in thai font by Oracle enterprise manager (4 repl.)
33. Unable to open Dump Error
34. How to store image in the oracle?? (1 repl.)
35. 10g RAC on WIN 2004 CRS Installation failed (4 repl.)
36. Its urgent:-Installation of Oracle9i on Fedora2 (4 repl.)
37. SCN (5 repl.)
38. Error (3 repl.)
39. Oracle Developer 2000 resources (1 repl.)
40. importing schema (4 repl.)
41. PMON Error.. (9 repl.)
42. Installation of oracle applications interconnect (2 repl.)
43. Changing Segment Space Management from Manual to Automatic. (1 repl.)
44. Simple But Important Questions. (1 repl.)
45. adstpall.sh script is not stopping Apache processes (4 repl.)
46. REFCURSOR in stored procedure (6 repl.)
47. TOP command for queries (4 repl.)
48. One More thing regarding Query posted below (1 repl.)
49. Urgent - Forms get corrupted very often (2 repl.)
50. Urgent - Unix Shell Script Help Needed (5 repl.)
51. Questions Aboout Oracle 9i (1 repl.)
52. Problem - Importing Dump from 9i into 10g (2 repl.)
53. Urgent - Upgraded Form doesn't works well with values saved by previous version
54. Urgent - "Delete_Record" doesn't works ???????
55. Restore Object statistics (2 repl.)
56. Start of root element expected (2 repl.)
57. Is it a valid syntax or not... (4 repl.)
58. connection to database very slow: help Needed!!! (22 repl.)
59. NLS_UPPER Function & Accents (1 repl.)
60. Function Based Indexes & Accents (4 repl.)
61. Query performance after emptying a table (2 repl.)
62. Exp failed on 9i Db (4 repl.)
63. Blob data transfer from one table to another with SQL statement (2 repl.)
64. How to start one procedure from another??? (6 repl.)
65. bootstrap failed error (1 repl.)
66. need installation doc for oracle 8i (3 repl.)
67. Oracle installation on domain server with active directory (3 repl.)
68. Oracle RDB 7.1 (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