Oracle Forum List: List of Oracle technology related forums
Oracle Forum List: List of Oracle technology related forums
Often I find myself seeking help in Google for my Oracle technology related work. Be it developing new functionality at my workplace, looking for solutions to problems that I don’t know about or simply looking for more information on some particular topic I find oracle forums of great help.
In fact I have found senior Oracle technology guys who works for Oracle also use Google to find solutions when they are in customer sites. I am sure if they go through proper channel they have enough expert to these to provide a solution to issues. But that means a lot of time in SRs and involves a lot of team work and administrative overhead. I don’t think seeking information on internet is wrong as long as the job is done.
After all Internet is to share information and there are tons of information on the internet to help everybody. To my view any Oracle developers, Administrators (DBA), Designers or Architect should actively go to internet to find ideas to how to enhance a solution or simply finding new ideas.
In my experienced I keep forgetting which Oracle forum I have been looking for while looking for information.
So Here I have created a list of forums which you can use for your own good. Of course from now on this list of oracle forums will also help me to keep a note of which forums I frequently visit.
List of Oracle Forums:
http://www.dbforums.com/
http://www.orafaq.com/forum/f/9/0/
http://www.club-oracle.com/forums/
https://forums.oracle.com
http://www.dbasupport.com/forums/
http://dbaforums.org/
http://www.daniweb.com/web-development/databases/oracle/129
http://www.ukocn.com/forums/
http://erpstuff.com/forums/
http://kb.dbatoolz.com/
http://oracleerp.org/discussion/forum
http://forums.devshed.com/oracle-development-96/
http://forums.sdn.sap.com/
http://www.oracleappsblog.com/index.php/oracle-applications-e-business-suite-forum-listing1/
http:// www.dbasupport.com/forums/
http://www.codeguru.com/forum/showthread.php?t=370724
It is also very nice if you can help out others by answering questions to which you may know the correct answer.
However do keep in mind that posting answers to old questions is not a very good idea. As the person who may be asking the questions may have found the answer long time ago or simply abandoned to look for the answer in that forum.
Also while looking for answer or solution; it is good idea to put as much information as possible so that others may know your issue in details so that they can provide better solution to your particular needs.
I have found forum posting a great place to find answers quickly. They are usually frequented by very high calibre people who may be able to help you out within minutes.
This list of Oracle forums should be enough to start. The list is in no particular order.
If you find any good oracle forum please share it here by sending me as a comment so that I can add that in the list my mine and others reference.
How to find Oracle database object dependency using dbms_utility package
get_dependency: function returns the dependency of a given Oracle object. This is a procedure in Oracle built-in DBMS_UTILITY package.
Procedure signature:
procedure get_dependency (type IN VARCHAR2,
schema IN VARCHAR2,
name IN VARCHAR2);
Example:
This call returns the dependency of EMP table which is in SCOTT schema.
exec dbms_utility.get_dependency(‘TABLE’,'SCOTT’,'EMP’);
Learn more on dbms_utility in action:
How to get CPU time using Oracle dbms_utility package
get_cpu_time: functions returns the CPU time in 100th’s of a second. This is a function in Oracle built-in DBMS_UTILITY. Only available post Oracle8x versions.
Function signature:
function get_cpu_time return number;
Example:
declare
l_num number;
begin
l_num := dbms_utility.get_cpu_time;
dbms_output.put_line(l_num);
end;
Learn more on dbms_utility in action:
How to find Oracle Database Server cluster mode using dbms_utility package
is_cluster_database: functions returns boolean TRUE or FALSE to indicate whether the Oracle database server is running in cluster database server mode or not. This is a function is Oracle build-in DBMS_UTILITY package.
Function signature:
function is_cluster_database return boolean;
Example:
This anonymous pl/sql script will display message to tell you whether Oracle database server is running in CLUSTER mode or not.
set serverout on
declare
begin
if dbms_utility.is_cluster_database then
dbms_output.put_line(‘Your database is running in Parallel server mode’);
else
dbms_output.put_line(‘Your database is NOT running in Parallel server mode’);
end if;
end;
Learn more on dbms_utility in action:
How to find Oracle RAC Instance number using dbms_utility package
current_instance: function returns the instance number of the Oracle instance – applicable in RAC settings. This is a function ins Oracle built-in DBMS_UTILITY package.
Function signature:
function current_instance return number;
Example:
declare
l_num number;
begin
l_num := dbms_utility.current_instance;
dbms_output.put_line(l_num);
end;
/
Learn more on dbms_utility in action:
Recent Comments