 | | | Oracle List | | Anyone know if it is possible to connect via IPC using JDBC thin driver as
example from Oracle SQL Developer and if so what is the syntax?
I 've read that it requires the listener and tcp/ip which Hi
11g engine is more complex than ever which leads to 'better bugs ' that are
more difficult to solve enlarged attack surface for hacking more often
unexpected side-effects of so called fixes morPL/SQL has always done this "optimization " automatically. so the default within a pl/sql procedure is to commit upon return to the caller. the cwiw setting must override the default pl/sql optimizProbably this article by Connor McDonald will explain you this behaviour
http //www.oracledba.co.uk/tips/lgwr_dilemma.htm
A while ago I did almost exactly the same test and was as suprised as you )
In 10GR2 there is an option to commit immediate nowait which allows the
commit to return before the redo is persistent in the redo log. This is
not the default. The default commit remains as commit wrIt 's not "misleading " as far as you know how it works
"db file sequential/scattered read " wait time is the time
elapsed from the instant Oracle noticed the buffer
was not in the buffer cache and theJonathan Lewis has written an answer here about the maximum number of entries
http //www.mcse.ms/message1574958.html
He said "The number of slots
in v$session_longops for 9.2.0.6 seems to be the loweNot exact but similar data on HPUX could be retrieved with
sar -d 1 10
You 'd need to map the names of devices onto datafiles that your query is
reading.
Vlad Sadilovskiy
Oracle Database Tools
htQuite a nice improvement there! I would caution everyone to carefully test
of course but it seems to have worked well here. I would expect that
recoveries may well go faster too.
RF
Robert G. FreeThe health checks are perhaps better documented and you can get some
insights into them by using OEM which provides a window into them (the
"checkers " as they are called). They feed some of the new fAm I the only one who has been unable to do much with this feature due
to the woefully absent documentation? Three components of "fault
diagnosability " in particular seem very interesting
- automOur database is running on hpux on which AIO is not possible to
achieve(except use raw device which is out of our considertion). And the "log
file parallel write " is very high. Since we use two redo gThe database is on the EMC storage with BCVs for both primary and standby.
I can sync the BCV with the standby and mount the storage on a different
host.
Once I mount the storage I can create one morThe database is running on hpux. And the sql is the exactly the same on test
and production.
Thanks
Qihua
On 10/2/07 Vlad Sadilovskiy <vlovsky@(protected) > wrote
>
> Sun iostat -cnmxPz 1 would showSun iostat -cnmxPz 1 would show you the most of the information on IO
subsystem throughput and lattency as well as the current load. What is OS
you are operating on?
Vlad Sadilovskiy
Oracle Database Just an update on this - after running the compressed backups on this
database and another one for 3 weeks now they are consistently running
much faster than before the compression - a little less thHi Alberto
Thanks very much for your message.
Based on the formula you mentioned if the cpu is always 100%busy for a long
time. Then the time that actually wating to be scheduled will be counted As far as I know Oracle doesn 't communicate anything to
the OS it is the other way around - Oracle reads OS
instrumentation data from the OS ). Unless that has changed
in some recent version in whI 've been looking at v$session_longops and I have a couple of questions and
I am hoping somebody can give me a hint.
There appears to be a maximum number of entries retrieved by the view. What
dete...but best of all in my opinion is have the developers put the call to
dbms_application_info.set_module at the very beginning of all
procedures. This way v$sqlarea.module won 't lie.
I have a procV$sqlarea holds a PARSING_SCHEMA_ID column.
This holds the user-id under which the SQL was parsed.
If from stored procedure it holds the user-id from the owner of the stored procedure (assuming auth_I have used v$sql.program_id with moderate success. This is the object id of the stored code so link to dba_objects or obj$ to get the additional information.
Regards
Daniel Fink
------- Original Apart of checking v$sqlarea.module for any differences I only could
think of of joining the addr and hash_value with v$session to obtain
v$session.prev_sql_addr and v$session.prev_hash_value and usI 'm not certain of disaster but I think the odds are surely in the
house 's favor. I doubt that this application has a requirement for
10000 *active* database connections. For whatever reason the
aHi
I have a question about v$sqlarea. Appreciate your help/inputs on this.
Background
Few questions
Can you elaborate on the "bad " values? What makes them bad?
Are other values (like NDV) non-representative as well?
What is your DBMS_STATS.GATHER_* command?
The reason I am asking isHi Tom
Yesterday queries against this table used the index. Today they do
not. There was no large data load overnight. We add about 10 000
records per day. This behavior has happened beforeAll
Thanks to Alvaro Jose Fernandez & Ric Van Dyke this is solved. The
DENSITY and CLUSTER FACTOR values in the user_tab_columns for my
database table had bad values. These values are calculatSorry for the delayed reaction but I 've been on a long overdue vacation ...
Learning to tune Oracle is a never ending process I 'm not an expert and
doubt I ever will be thank god. That 's what I loCan you provide us with a (couple of) example(s) of these queries?
-----Oorspronkelijk bericht-----
Van oracle-l-bounce@(protected) [mailto oracle-l-bounce@(protected)]Namens Mercadante Thomas |
|
|
