 | | | Oracle List | | Dennis
You could avoid synonyms by creating the views in the users ' schemas -)
-----Original Message-----
From DENNIS WILLIAMS [mailto DWILLIAMS@(protected)]
Sent Tuesday November 02 2John here is a good method of making sure that system stats is 20
collected from a very busy system
begin
DBMS_STATS.GATHER_SYSTEM_STATS(gathering_mode 3D > 'START ')
DBMS_STATS.GATHER_DATABASE
I am using Toad and using the User B to view database
object created by User A. THis select priviliges is
been provided by granting SELECT on all SCHAME A
database object so ROLE and assigning RoWe have something similiar in our shop and we set up a login trigger
to kick the user out if they logginng in without using the
application. If you go this way then you would need to create a
sbased on JLewis example
A small fix it is not dbms_system.ksddt - writes a date-time stamp
it is dbms_system.ksdDdt - writes a date-time stamp
3 d
Executing as SYS
SQL > begin
2 dbms_systeIt would help to actually have an index on W_LOV_D....and make sure that
you reference all the keys in the index if there are more than one...you
can 't do a index range scan without a index... (
Welll many people responded directly to me. Many dba 's are going through
this hassle in various forms and some are being regretfully emasculated to
having squat for privileges... And I am not suHell List
I couldn 't find the patches for hp-ux superdom 11.23. Metalink has
only 11.22 version patch list. Could any one point me to the link or
any help is highly appreciated. By the way when
On 11/01/2004 03 02 55 AM Sinardy Xing wrote
> Hi all
> Since DBW will flush buffer cache
It doesn 't do anything even remotely like "flushing buffer cache "
It writes modified blocks to disFahd
I was only answering your 3rd question apologies. It 's hard to visit
Miracle DBForum and UKOUG in a consecutive way -)
Q1
It is the easiest way to keep DBNAME and instance name the sameHi.
I have Oracle 9i (9.2) RAC on RHAS 2.1 and are using Resouce Consumer
Groups. I have played around with the view GV$RSRC_CONSUMER_GROUP
however I wish to extract more detailed information. We are going to move our databases from AIX5L to HP SUPERDOM server.
Does any one have experience about the performance problems or
improvements? Can any one give me the best kernal parameters listsWe ran 8.1.7.4 SE with standby database on Win2k for many months before
finally upgrading to EE. ARC redo logs were manually shipped via custom
scripts and applied every hour via a scheduled task. AAshoke
yes. I have experienced issues with applying Security Alert #68
patchsets on 8.1.7.4.x on win32.
There is a bug in patchsets later than 8.1.7.4.15 that affects the
java virtual machineI know on ORACLE 8i and 9i Standard Edition does NOT
support "data guard redo apply and SQL apply ".
Does ORACLE Standard Edition on 8i support "standby
database "?
Does both servers need be saV$sql and statspack would qualify. ) 20
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)] On Behalf Of Seema Singh
Sent Friday October 29 HI
Here are the latest http //www.oracle.com/openworld/archive/index.html but
Does anyone knows please where are previous oracle worlds papers to 2003.
Thanks.
Juan Carlos Reyes Pacheco
OCMicrosoft and Veritas are both still listed
http //www.oracle.com/openworld/sanfrancisco/exhibitionhall/list2.html
http //www.oracle.com/openworld/sanfrancisco/exhibitionhall/sffloorplan.
pdf
I
Henry
I 'm just catching up on email after two consecutive
conferences and found this in the digest
I think your question arises from the fact that
Oracle clearly seems to be doing redundanI don 't have to request the system password but do have to
request the password for the application accounts on the servers.
We have personal logins with admin rights on the servers. The
point NO and that 's the way it 's going to stay. 20
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
From Spears Brian [mailto BSpears@(protected)] 20
Sent Hi Leslie
Alomari 's book is excellent. The problem is that not only he doesn 't
cover 9i but in addition AFAIK it doesn 't cover AIX! Therefore not the
right choice for you... 20
I never reaManoj
Kinda tough for us to provide your deliverables for you. Or what you are
bringing to the project don 't you think?
Tom Mercadante
Oracle Certified Professional
-----Original Messa > We did an install of Oracle 9.2.0.4 on HP-UX...
>
> Was only supposed to take a couple of hours to do that and convert the
> database.
>
> But when it was time to bring things up
>
> SQL*
Hi all
Please don 't send any mails to this id as for company rule I am not supposed
to use this mail id for any subscribing purpose. Please don 't mind and
deletemy subscribe.
Thanks
20
I 'm writing a batch update/insert procedure and am wondering if there is
a way to only update columns corresponding to the 'on ' clause if they
are different from the current value?...instead I am attempting to install 8.1.7.4.16 on Windows 2000.
After installing the software from the CD I installed the 8.1.7.4
patch and the #68 security patch (8.1.7.4.16). I then built
a new databaseUse
dbms_system.KSDWRT(2 ...)
Igor Neyman OCP DBA
ineyman@(protected)
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)] On Beh
-----Original Message-----
From Marley Darlene
Sent Thursday October 28 2004 1 11 PM
To 'Mercadante Thomas F '
Subject RE Sqlldr constants and dates w/timestamp
Thank you Thank yoHi
We are running Oracle Applications 11i on a Sun 15K with 12 cpus.
When one process consumes 8% of cpu utilization ( by running tops) the
idle time becomes 0%.
As soon as I terminate this |
|
|
