|
More site info...
Oracle DBA Forums - dbaforums.org | Site profile
|
|
Site profile page for http://dbaforums.org.
This report page has aggregated and summarized the online discussions from the Message Board located at http://dbaforums.org.
This site profile page outlines general site statistics such as: Users Activity, Site Activity, Site Rank, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional site profile information for http://dbaforums.org is also shown in the following divisions:
1) Top 10 Active Forums during Last Week
2) Top 10 Site Forums
3) Latest Active Threads
4) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a site's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity table on Oracle DBA Forums:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
65
|
222
|
612
|
|
Post:
|
127
|
497
|
1,588
|
|
|
Authority Badge:
|
|
|
BoardReader Authority Badge code for Oracle DBA Forums (http://dbaforums.org)
|
|
Put this code anywhere on your forum page:
|
|
|
|
|
|
|
|
Rating - The position measured by activity among all forum sites tracked by BoardReader.
If rating is 10 there are 9 forum sites which have higher activity.
Posts - Number of posts on forum site during last 7 days.
Threads - Number of threads on forum site active during last 7 days.
Authors - Number of authors which contributed to the site within last 7 days.
|
|
|
|
|
Oracle DBA Forums posting activity graph:
|
|
http://dbaforums.org Alexa graph:
|
Top authors on Oracle DBA Forums during last week:
user's latest post:
Stored Procedure Problem in...
Published (2009-12-03 06:45:00)
UPDATE EMPLOYEE SET PROCESSED='YES' WHERE PROCESSED='NO' just that is all you need, you put whatever logic you need into the where clause
user's latest post:
Performance issue with START...
Published (2009-11-27 09:21:00)
"Please suggest the way forward to tune this query ASAP." I would tune the query first to remove the full table scans. To learn how to tune SQL, read the instructions: http://www.rampant-books.com/book_0501_awr...tive_tuning.htm
user's latest post:
Bulk Deletion
Published (2009-11-24 18:16:00)
"truncate is the better way than delete" No not better, just different: http://www.oracle-training.cc/t_garmany_ea...ne_way_trip.htm "Does delete will release the free space from the tablespace. " You need to learn basic Oracle concepts fast, get the Easy Oracle Jumpstart book. http://www.rampant-books.com/book_2005_1_e...e_jumpstart.htm Only if the delete causes the data block to get put back on to the...
user's latest post:
Deadlock issue with ojdbc14
Published (2009-11-29 12:38:00)
Yes, it's an ORA-00060 not 600, any other option to investigate this issue ? Another thing, we have INITRANS set to 1 for tables, INITRANS set to 2 for indexes and MAXTRANS to 255 for both. Would you know a query to find out the blocks which couldn't handle more than a few TRANS due to a lack of space in the block ? Thanks, François This post has been edited by Interdit : Today, 03:30 PM
user's latest post:
Rebuilding Indexes
Published (2009-11-25 09:08:00)
This article goes into quite a bit of detail: http://www.dba-oracle.com/t_index_rebuilding_issues.htm
user's latest post:
Tuning SQL of Type Unknown
Published (2009-12-03 11:48:00)
Assuming you LOB columns are currently defined as "NOCACHE", that is using direct I/O and bypassing the buffer cache, change them to CACHE. If the direct path reads fall away, you have your answer.
user's latest post:
Flashback Database
Published (2009-11-25 19:51:00)
Hi, thank you but i just wrote that i queried this view and i see that i can only go 1 day ago.
user's latest post:
GUI tool to trace oracle session?
Published (2009-11-30 14:43:00)
if you are wanting to take the trace on the client side, there is this application that runs on Windows machines. http://www.aboves.com/?oracle
user's latest post:
Oracle Errors
Published (2009-12-01 03:46:00)
QUOTE (HAL9000 @ Nov 27 2009, 07:19 PM) "dba is me only" By your own admission you don't understand your own job duties. Oracle can take years to learn. To learn Oracle fast you can get the Easy Oracle series: http://www.rampant-books.com/menu_six_packs_bundles.htm#easy Thanx. Good suggestion
user's latest post:
Oracle Errors
Published (2009-11-29 07:35:00)
Extract AWR report Look at most inportant block -Top 5 wait events Analyze them, that will give you a good idea of system state. You cant fix your system in one day and believe me there is no magic trick. A senior DBA can look at your AWR and point our many things but a newbie has to read and observe everything.. Take things calmly and one by one .. read as much as you can. Oracle Tuning: The definitive Reference by Don Burleson is a good...
|
|
|
Top 10 active forums on Oracle DBA Forums during last week:
|
|
Top 10 forums on Oracle DBA Forums:
|
|
|
|
Latest active threads on Oracle DBA Forums:
Started 2 days ago (2009-12-03 20:17:00)
by Brian Carr
You're getting this because VIP was already configured Run VIPCA ( Virtual IP Configuration Assistant) manually before proceeding.
Started 1 day, 9 hours ago (2009-12-04 11:03:00)
by andrew kerber
This isnt really the forum for that, but ERwin is a handy tool, as is Visio. Unfortunately, when CA took over ERwin, they stopped making it better, and increased the price about 10 fold.
Started 1 day, 12 hours ago (2009-12-04 08:45:00)
by andrew kerber
The asm instance should be up even with your database down. Did you remember to set your sid to the sid of your asm instance, set your oracle home to the asm home, and add the asm home/bin directory to your path? If asm is up, you should be able to mount the database (startup mount) in rman, and use rman to delete the archivelogs: rman> startup mount; rman> delete archivelog all; Here ...
Started 1 day, 12 hours ago (2009-12-04 08:35:00)
by andrew kerber
Look here for some information on FGA in Oracle 9i: http://www.dba-oracle.com/security/fine_grained.ht m
Started 5 days, 11 hours ago (2009-11-30 09:10:00)
by andrew kerber
We would need see all the standby settings in your init file to determine the problem. However, this link shows the normal standby settings that need to be modified for a standby: http://www. dba-oracle.com/t_oracledataguar..._para meter_.htm
Started 2 days ago (2009-12-03 20:27:00)
by Brian Carr
>> to the emitting jdbc application so that I could avoid refreshing any cache or alike If I understand your question properly then the answer is yes. You can use a JDBC driver to create a registration on the server for change notifications. Look at the registerDatabaseChangeNotification method of oracle.jdbc.OracleConnection interface.
Started 6 days, 14 hours ago (2009-11-29 06:07:00)
by dave
restore the backup onto the other server - simple
Started 2 days ago (2009-12-03 20:10:00)
by Brian Carr
You'll need to make use of Oracle Date Functions. See here http://www.dba-oracle.com/t_oracle_date_functions. htm
|
|
Hot threads for last week on Oracle DBA Forums:
Started 1 week, 4 days ago (2009-11-24 17:34:00)
by aussie_dba
Whenever you get an ORA-00600 you need to open a SR with Oracle tech support. Also, see Metalink Note:62365.1 Important, is your target tablespace using "segment space management auto"? If so, that can cause huge deadlocks, because ASSM sucks: http://www. dba-oracle.com/oracle10g_tuning...perfo rmance.htm "java.sql.SQLException: ORA-00060: deadlock detected while waiting for ...
Started 1 week, 2 days ago (2009-11-26 08:56:00)
by dave
you need to have a word with your dba - each error needs to be looked at it detail
Started 2 days, 18 hours ago (2009-12-03 01:49:00)
by SteveC
So many things wrong here, but first is that homework problems are not critical. What is the point of the select * part? It is nonsensical as to its purpose, and even if you did need to select * based on the where clause, you would have to select the values into variables, and since you may be selecting more than one record via the * (or maybe get nothing returned), how would you account ...
Started 6 days, 14 hours ago (2009-11-29 06:07:00)
by dave
restore the backup onto the other server - simple
Started 1 week, 2 days ago (2009-11-26 18:09:00)
by HAL9000
"To process this query, its taking 3 hours in production." How many rows are returned? Is there a missing index opportunity? The best way to tell if other query forms run faster is to try different solutions and time their execution time. Since this is in PL/SQL anyway, I would completely remove the sub-query and make it a separate query. Read this for ideas: http://www.dba-oracle....
Started 1 week, 1 day ago (2009-11-27 13:04:00)
by akihabara85
Hi all, im new in this forum.. I googled so long but is not able to find any help for my assignment.. The question is as follow... Ques: I am required to implement a stored PL/SQL function LONGTRIP(DLNUM) that finds the length( the total number of legs) of the longest trip performed by a driver identified by a driving license number( L# attribute in table DRIVER and parameter DLNUM ...
Started 1 week, 1 day ago (2009-11-27 04:12:00)
by dave
oracle on windows is no different to oracle on linux / unix so do the same as you would on other platforms
Started 5 days, 11 hours ago (2009-11-30 08:54:00)
by andrew kerber
I dont know exactly what detail of tracing you need, but the the java EM console available in the Oracle client up through 10g allows you to watch the sessions running in the database. Oracle recommends the OEM grid control for later versions of Oracle, which allows very detailed analysis. Below is a link to information about grid control. Of course, there are additional licensing fees ...
Started 5 days, 11 hours ago (2009-11-30 09:10:00)
by andrew kerber
We would need see all the standby settings in your init file to determine the problem. However, this link shows the normal standby settings that need to be modified for a standby: http://www.dba-oracle.com/t_oracledataguar..._para meter_.htm
Started 1 week, 1 day ago (2009-11-27 09:19:00)
by HAL9000
'"which is the best training centre in chennai" Where is Chennai? Some foreign country? How to become dba: http://www.dba-oracle.com/t_how_to_become_an_oracl e_dba.htm
|
|
Size: 372 bytes
