Hello All, This is first message from my group. this is OracleClub. Related to Oracle Activity. I am working as an Oracle DBA. you can find more about me...
hi, i have installed oracle 10g on solaris 8 having a previous installation of 8i.i have created a new user for this new installation but groups are same as...
Dear friends, There are some Question and Answer which you face frequently. 1. Can we install different oracle version on same machine. like Oracle 8i,9i or...
1. Linux is case sensitive and windows is not case sensitive. so please during datafile creation type use only one case "lower" or "upper" don't use both case...
Dear list, My colleages were asking me if there's a way to speed up the rebuilding of indexes (online). I haven't experience this though but do you think...
I want to ask one question: "why you want to rebuild indexes" for performance, if yes then don't do that. it will not increase any performance. Yes it is...
Dear Friends, Today my article is based on general thoughts about Oracle DBA with some technical details. When we complete oracle certification and start our...
Please read below link from asktom...why index rebuild is not needed. http://asktom.oracle.com/pls/asktom/f? p=100:11:0::::P11_QUESTION_ID:2913600659112...
What is most important work for DBA's ? It is Database BACKUP. There are simple three methods which you can use to take database backup. 1. COLD backup /...
First use "shutdown immediate" command to shutdown database server without "SHUTDOWN ABORT" if shutdown immediate command is HANG then use "SHUTDOWN ABORT" +...
Nice information taj. Babu Mohammad Taj <star_taj@...> wrote: First use "shutdown immediate" command to shutdown database server without "SHUTDOWN ABORT"...
Hello All, I would like to know how to gather statistics on Oracle Application Server, number of concurrent users on the application server. We have Web users...
...I would like to know how to gather statistics on Oracle Application Server,... same like Database Server. Statistics gather only on database, it is not...
Dear Friends, Today I discuss some NETWORK related issues which we database administrator usually faced. First understand which network files is important for...
Thanks for reply... Please check this one also... http://download.oracle.com/docs/cd/B32110_01/core.1013/b28942/monitor _b2.htm#CHDEGJHD Regards Mohammad Taj ...
Nice Info. Taj. We are using Oracle 2003 R2 + Orace 10g R2. And my applicaion is Oracle 6i D2K. While connect my prod. database i'm getting this error msg...
"SYS" is a magic User? Answer: Yes, but why? Why everyone recommended to "don't use sys" user for database activities. Because: 1. SYS (SYSDBA) is super and...
Hi all, I want to know the schemas in particular user after connecting as sys, Because I don't have users passwords to access the user tables. Thanks msd....
Query the USER_OBJECTS data dictionary hth kelvin ... ____________________________________________________________________________________ Looking for last...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
