Dear OIPStaff OIPStaff,

This is your DBA-Village Weekly Newsletter.

New items

Script: Shows all the hidden parameters current values

Link: Oracle FAQs #2

Link: Oracle DBA from Oracle Tips, Tricks, and Scripts

Tip: Explicit Defaults

Script: Estimated SGA Size In Oracle 9i

Tip: Correcting Values When Writing to Excel Files (Plsql and Forms)

Link: Oracle Database Error Code Lookup

Link: The Oracle Academy

Script: Query will tell you no ofrecords are being processes by rbs

Script: Generate move script for different types of objects

Tip: Convert your temp tablespace into permanent and vise versa.

Tip: DBVERIFY on Datafiles as well as Logfiles

Question

Thank you for answering our question before. These are the results so far.

There are 509 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. capturing after change and before change row data (1 repl.)
2. nproc kernel paramter for RAC
3. How to find out volume/count of transactions occured in segment level/db level (1 repl.)
4. OLAP (1 repl.)
5. Statspack (2 repl.)
6. Pro* C Documentation on internet needed (1 repl.)
7. in a record print column1 on line 1 and all the remaining columns on line 2 (3 repl.)
8. ORA-00600: internal error code, arguments: [19701], [kolsnxt2: next page not found] (2 repl.)
9. How can I include HOST statements in a procedure ?? (4 repl.)
10. scheduling Database Shutdown (7 repl.)
11. Mailing from Oracle (2 repl.)
12. retreive currently running procedure (1 repl.)
13. trend script for conncurrent connections (8 repl.)
14. spool query output without overwriting previous output in the file (7 repl.)
15. How to convert Data in MS -Excel sheet in to Database (4 repl.)
16. sql_trace and tkprof (5 repl.)
17. Rman Incremental vs Full (1 repl.)
18. Statspack !!! (2 repl.)
19. RAM used by Oracle user (1 repl.)
20. Oracle Disaster Recovery Plan! (5 repl.)
21. Creation of table (2 repl.)
22. SELECT ON DBA_ROLE_PRIVS (3 repl.)
23. NetBackup troubles
24. System account vs. Sys user (9 repl.)
25. PL/SQL help (2 repl.)
26. read only tablespace (10 repl.)
27. Oracle Security Alert #68: Security Vulnerabilities in Oracle's Server Products (3 repl.)
28. export (4 repl.)
29. DEVLOPER 6I (1 repl.)
30. URGENTLY !!! STORE/load & retrieve/DISPLAY file(e.g. : .doc, .txt, .PDF etc?..) (2 repl.)
31. Error while accessing the OracleService (1 repl.)
32. locally managed tablespace (2 repl.)
33. Clusters (1 repl.)
34. Interview FAQs Wanted ! (9 repl.)
35. Script for finding out what privileges unix users have on system? (1 repl.)
36. Flashback query in oracle 9i (3 repl.)
37. ROLLBACK Tablespace (5 repl.)
38. Select ORACLE_HOME defining data source using MS odbc driver for Oracle (3 repl.)
39. insert taking too long (6 repl.)
40. Object have how many grants (1 repl.)
41. Unable to CONNECT (2 repl.)
42. SQL count rows for each table (3 repl.)
43. Rollback segments (7 repl.)
44. output the table data into temporary file every night (4 repl.)
45. Manually Customized installation in RAC (4 repl.)
46. PGA too large (2 repl.)
47. cursors (3 repl.)
48. declare PL/SQL constant in package and use them from sql (2 repl.)
49. PROBLEMS INSTALLING DEVELOPER 2000 1.6.1 ON WINDOWS 2000 (3 repl.)
50. Error while creating SYNONYM (4 repl.)
51. Execution Plan (25 repl.)
52. Partitioning Table Options (3 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