|
More site info...
Database - General
| Forum profile
|
|
Forum profile page for Database - General
on http://www.oracle.com.
This report page is the aggregated overview from a single forum: Database - General
, located on the Message Board at http://www.oracle.com.
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "Database - General
" on the Message Board at http://www.oracle.com is also shown in the following ways:
1) Latest Active Threads
2) 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 forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on Database - General
:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
1,077
|
3,149
|
8,212
|
|
Post:
|
4,444
|
13,046
|
33,304
|
|
|
Database - General
Posting activity graph:
|
Top authors during last week:
user's latest post:
question about temporary table...
Published (2009-11-25 12:30:00)
To see the contents of a table you select from it. Other sessions will not see the data changes until they are committed. Do you mean a global temporary table ? If so, then other sessions can't see the data.
user's latest post:
inconsistent processing time...
Published (2009-11-25 17:44:00)
http://www.oracle.com/technology/oramag/oracle/08-jan/o18asktom.html perhaps results are being impacted by "bind variable peeking". Then again, perhaps not.
user's latest post:
Tracing sessions when using web...
Published (2009-11-25 08:00:00)
look at the program ...from the v$session.. Normal java think clients will be shown as JDBC THIN CLIENT... How does the appserver connects...JDBC?
user's latest post:
RA-27040: skgfrcre: create...
Published (2009-11-25 04:20:00)
Do you have the permission to create file as oracle software owner user in the mention mount point? '/dev/vg201/ HP-UX Error: 13: Permission denied Check with your system admin. Grant the permission and re-create the file. Regards Asif Kabir
user's latest post:
Workload Stats vs NoWorkload stats
Published (2009-11-25 09:44:00)
Gunners, NW stats are run on need basis. It does not run on its own as it collect system statistics (Mainly sys, system schema). So you may run it one a year or twice a year. Regards
user's latest post:
parsing in library cache
Published (2009-11-25 12:19:00)
I recommend you to read this paper titled: Understanding Shared Pool Memory Structures http://www.oracle.com/technology/products/manageability/database/pdf/ow05/PS_S003_274003_106-1_FIN_v2.pdf HTH, Joze Co-author of forthcoming OakTable book "Expert Oracle Practices" http://www.apress.com/book/view/9781430226680 Home page: http://www.dbprof.com Oracle related blog: http://joze-senegacnik.blogspot.com/ Blog about flying:...
user's latest post:
parsing in library cache
Published (2009-11-25 06:03:00)
user3266490 wrote: Hi, what is the parse tree while parse statment.where the parse tress stored. http://www.google.com/search?q=oracle+%2B+%22parse+tree%22&start=0&ie=utf-8&oe=utf-8&client=firefox-a&rls=org.mozilla:en-US:official what is the difference between execution and fetch? Execution is to execuet the query and fetch is to return it back to the client. HTH Aman....
user's latest post:
change on checkBox checked value...
Published (2009-11-24 15:49:00)
Lamya wrote: Hi there, we have used java script function that test if a check Box is checked then it enables another text Item in the page, otherwise it disables it, the same java script function is called twice, one in the HTML attribute of the check box (onchange), another in the footer of the region the items are in, in order to load the text Item accordingly, but the case is as follows: when the page has a validation and it fails, the...
user's latest post:
parsing in library cache
Published (2009-11-25 06:23:00)
Aman, I think we should not give any reply to such forum members, until and unless they do'nt want to follow the forum rules even after saying.... http://forums.oracle.com/forums/message.jspa?messageID=3928045#3928045 Regards Girish Sharma
|
|
|
|
Latest active threads on Database - General
::
Started 6 days, 13 hours ago (2009-11-20 11:30:00)
by Timur Akhmadeev
Hi,
We have a file that has about 14,000 employees.
We have a job that loads timecard data from a text file into a temporary table in our PeopleSoft database which it then loads into permanent tables.
The process itself works by running in a loop and loading each record one at a time.
Why are using intermediate temp table? Why are using slow-by-slow ...
Started 1 day, 7 hours ago (2009-11-25 17:24:00)
by sb92075
GRANT REFERENCES ON "FLOWS_FILES"."WWV_FLOW_FILE_OBJECTS$ TO FLOWS_020000;
Started 1 day, 8 hours ago (2009-11-25 16:14:00)
by sb92075
Does not look like any Oracle trace/log file I have seen before.
Post Operating System (OS) name & version for DB server system.
Post results of SELECT * from v$version.
Started 1 day, 13 hours ago (2009-11-25 11:35:00)
by sb92075
Any help would be very much appreciated.
post output from following command
SET
Started 2 days, 5 hours ago (2009-11-24 18:55:00)
by stuartu
FYI,... I'm on 10.2.0.4 64-bit on RHEL5
Started 1 day, 13 hours ago (2009-11-25 10:57:00)
by Hans Forbrich
Perhaps it is because the X$ tables (under the V_$ views and V$ synonyms) are internal and not changeable by the user or administrator ... IOW 'the structure is "fixed" in code'
Or perhaps because they have to be 'fixed' in each version before they will work
Edited by: Hans Forbrich on Nov 25, 2009 3:01 PM
Started 1 week ago (2009-11-19 08:49:00)
by Pointless
user1958693 wrote:
Any suggestion please contact.
How about adding -
Use T-SQL functions in ORACLE too, so you can write one script version that works in SYBASE, SQLSERVER and very slowly in ORACLE
Started 1 day, 10 hours ago (2009-11-25 13:50:00)
by sybrand_b
As the code is correct, you should have
a) looked up the error message in the online documentation
b) if you can't resolve using that, post the error message
c) include the four digit version.
Sybrand Bakker
Senior Oracle DBA
Started 1 day, 18 hours ago (2009-11-25 06:03:00)
by Aman....
user3266490 wrote:
Hi,
what is the parse tree while parse statment.where the parse tress stored.
http://www.google.com/search?q=oracle+%2B+%22parse +tree%22&start=0&ie=utf-8&oe=utf-8&client=firefox- a&rls=org.mozilla:en-US:official
what is the difference between execution and fetch?
Execution is to execuet the query and fetch is to return it back...
|
|
Hot threads for last week on Database - General
::
Started 2 weeks ago (2009-11-12 22:07:00)
by Justin Cave
Are your statistics accurate? The optimizer expects that no step is going to return more than 10 rows, that you're dealing with less than 1 kb of data, and that the query will take 1 second. That makes me wager that the optimizer is off in left field because the statistics are out of date.
Justin
Started 2 days, 23 hours ago (2009-11-24 01:32:00)
by SIDDABATHUNI
Hi,
Here is the output of my alertlog file.
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non- default values:
processes = 150
__shared_pool_size = 100663296
__large_pool_size = 4194304
__java_pool_size = 8388608
__streams_pool_size = 8388608
sga_target = ...
Started 1 week ago (2009-11-19 06:58:00)
by EdStevens
user8703472 wrote:
Hi
I have generated a spool file which has a black record at the end of the file.
How can i eliminate that ?
Thanks in advance
What do you mean by "a black record"?? Do you mean a record with a single unprintable character that is represented by a black block?
My crystal ball is out for repair, making it rather difficult...
Started 3 days, 17 hours ago (2009-11-23 07:07:00)
by Robert Geier
Why do you want to use this parameter ? It is better to NOT use understore parameters like "_OPTIMIZER_COST_BASED_TRANSFORMATION".
You upgrade to 10g, you get better performance by without parameter, so what is the problem ? Why tune a query so you can use a parameter you don't need ?
Started 1 week, 6 days ago (2009-11-13 12:43:00)
by Gunners
perhaps I should post my whole parameter listing
SQL> show parameter
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
O7_DICTIONARY_ACCES SIBILITY boolean FALSE
_lgwr_io_slaves integer 0
_log_parallelism ...
Started 2 days, 17 hours ago (2009-11-24 07:19:00)
by Robert Geier
Can you show the explain plans for the two servers ? Are the stats on both servers up to date ?
Started 2 days, 3 hours ago (2009-11-24 21:41:00)
by sb92075
now i how i be able to restrict normal user to login like sysdba?
do not allow this user to log onto the DB server system
Started 6 days, 13 hours ago (2009-11-20 11:23:00)
by oradba
Read this for a discussion:
http://asktom.oracle.com/pls/asktom/f?p=100:11:0:: ::P11_QUESTION_ID:69012348056
Werner
Started 1 day, 19 hours ago (2009-11-25 04:50:00)
by Robert Geier
Maybe you can show your script ?
Probably you are not setting the environment when you run from cron. (e.g using oraenv)
Started 1 week ago (2009-11-19 12:10:00)
by schavali
Pl identify the user you are connecting as. Then post the output of these statements.
SQL> select * from dba_users where username = '<your username>' ;
SQL> select * from dba_profiles where profile_name = 'value returned from above query' ;
HTH
Srini
|
|
Size: 754 bytes
