How To Monitor Drop User
Jan 31, 2013How to monitor the DROP USER command?
OS: AIX, Oracle: 11.2.0.2
ADVERTISEMENT
Security :: SQLs To Monitor User Access?
Jul 2, 2011There is a user account called 'BALA'.How to create SQLs to monitor 'BALA' user access ?
View 9 Replies View RelatedReal Application Clusters :: Monitor Incident Or Regular Health Checkup Under Grid And Oracle User?
Apr 15, 2013I am new in RAC scenario though i have some system to look after. I want to know, like single instance there is alert log,trace log where we should investigate to check if there is any problem. For RAC system which are the logs that i can find the monitor the incident or regular health checkup under grid and oracle user?
View 3 Replies View RelatedHow To Drop More Than One User At Time
Nov 3, 2012in one short i want to drop more than one user?
View 6 Replies View RelatedXE :: How To Drop User And Schema
Aug 31, 2012I want to free up some space , as i have created some testing users and schema.
View 3 Replies View RelatedSQL & PL/SQL :: Drop All The Tables In A User At A Time
Sep 15, 2011is there any syntax to drop all the tables at a time in a user
View 12 Replies View RelatedServer Administration :: Precautions Before Drop User
Jul 28, 2011I want to drop some users which are no longer been used .What are the precautions i need to take before i drop users? I have taken logical backup (Export) of users i want to drop.Is there anything i missed out before i drop user?
View 4 Replies View RelatedServer Administration :: Unable To Drop User Without Database Shutdown
Apr 19, 2013We are unable to drop user due to below error, how to drop the below user without shutdown the database.
SQL> drop user mvm_2010 cascade;
drop user mvm_2010 cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-14452: attempt to create, alter or drop an index on temporary table already in use
No session was available for particular user.
Server Administration :: Unable To Drop User - Table Or View Does Not Exist
Jun 6, 2011Im facing the problem whenever I try to drop a user. Following thing that I m trying..
system@vahan> drop user knp cascade;
Error at line 1:
ORA-00604: error occured at recursive SQL level 1
ORA-00942: table or view does not exist
ORA-06512: at line 7
Server Administration :: Create / Drop User / Schema In Another Oracle Database Through Apex
Jul 7, 2012Through an Oracle Apex application I need to create/drop a user/schema in another Oracle database. i.e., create/drop user remotely using an Oracle Apex application.
View 12 Replies View RelatedCan Monitor 10.2.0.2 Databases Using OEM 11g
Feb 7, 2011In my company we have few 10.2.0.2 databases and few 10.2.0.4 databases.Currently we are monitoring using OEM 10g (10.1.0.5.0) installed on a seperate server.
Planning to install OEM on a new server as part of server room renovation. let me know the process of installing OEM on a different server without loosing the historical data?Also wondering if the OEM 11g will support the current databases?
Flag Or Monitor CPU Utilization?
Dec 22, 2010I have to run a resource extensive SQL. It utilizes CPU to a great extent. I've created a new user just to run this particular report. I need to ensure that this particular user doesn't uses more CPU.
Hence, I need to generate an alarm (email) only if a threshold is exceeded for a certain period of time (above x% for y minutes),(example more than 80% for 10 min.), so that I can either kill the process or continue running it depending on CPU usage.
Can I do it using scripts or OEM. I couldn't find any specific metrics to do it in latter. (I'd prefer scripts though. )
My system details are as follows:
1. Database: Oracle 10g R2
2. Unix: Sun OS 5.10
How To Monitor Oracle Application R12
Jul 16, 2011How can I monitor Oracle Apps R12 on Linux RHEL5. Application and database status.
View 2 Replies View RelatedSQL & PL/SQL :: Monitor Jobs From Procedure?
Dec 31, 2010We have a job table, and whenever jobs are added to this table the job processing procedure should be started.
In unix we have crontab facility where we can schedule to run for 24/7.
similarly do we have any option in oracle daatbase, to keep on running a prcedure in loop.
Windows :: Monitor The Cpu Utilization On Xp?
Jul 16, 2010how can we monitor the cpu utilization on windows xp.
View 2 Replies View RelatedHow To Monitor Space Of Database In RAC And NON-RAC
Nov 17, 2012I need to monitor the Database daily, so i need to check whether the size of the DB is increasing @ a slow rate or rather than that. I need to do it in RAC & NON-RAC.
View 3 Replies View RelatedMonitor The Creation Of New Datafiles / Tempfiles?
Oct 15, 2012I am looking for a way to monitor the creation of new datafiles / tempfiles.Let's say I am creating a new datafile of 8GB in size, and it takes a few minutes to create.
I have looked at v$session_longops, and several other system views, but cannot find any that indicate how the file creation is progressing.
I want to be able to display something simple, such as "72% complete".
Client Tools :: SQL Monitor Alternative?
Jan 5, 2011Many moons ago, at a previous employer, I had access to the SQL Monitor tool that came with TOAD. I could really use an alternative to this now, as we don't have TOAD here, and it would need to be free. I'm getting a problem with a forms update failing, and I really need to see what's actually being submitted to the database by the form. We're still stuck on Forms 6 by the way
View 2 Replies View RelatedReplication :: How To Monitor Complete Refresh
Oct 29, 2008I am using basic replication in oracle 10.2.0.3. My materialized view object contains around 3 million records. Usually we are using FAST refresh but in my materialized view having some problem that’s the reason I am going to Complete refresh.
If I start complete refresh it will take 8-12 hours to complete refresh.
My Question is: During Complete refresh how to monitor complete refresh running or not except using
v$mvrefresh.
Is there any way to monitor complete refresh because suppose target database not available/network problem/ dead lock occur in my database. I can’t able to track refresh.
Even there is no notification in alert log.
Server Administration :: Monitor PGA Utilization?
Dec 28, 2011I have a requirement to monitor the PGA utilization with time to time. Provide a good script which will effectively show the pga utilization.
View 2 Replies View RelatedHow To Monitor ALTER TABLESPACE Ddl Change
Jan 8, 2013I can use trigger to monitor ALTER TABLESPACE ddl statement against a particular tablespace in a schema.
CREATE OR REPLACE TRIGGER HOT_MAIL_DDL_CHANGE
AFTER ALTER TABLESPACE <tbs_name>
ON SHANNURA.SCHEMA
BEGIN
INSERT INTO HOT_MAIL_DDL_AUDIT_LOG VALUES
(SYSDATE,
SYS_CONTEXT('USERENV', 'SESSION_USER'),
ORA_SYSEVENT,
ORA_DICT_OBJ_TYPE,
ORA_DICT_OBJ_NAME
);
END;
/
I think, line no.2 isn't a valid statement. Or can I use AUDIT instead - in fact, I want to monitor/audit only ALTER TABLESPACE ddl statement and that too for a particular tablespace only.
Server Utilities :: How To Monitor Export And Import Job
Apr 28, 2012how can i monitor the export and import job and how increase the export and import job performance.
can i monitor the export and import job by checking the log and dump file created by export and import and can its performance increase by configure parallism. m i right or not?
How To Monitor Alert Log File (using Any Tool Or Manual)
May 10, 20131)How to monitor alert log file (using any tool or manual)?
2) What are the implications of a database with multiple data block sizes?
Windows :: Tool To Monitor Oracle Host And Services?
Jun 29, 2010What tool can be used to monitor Oracle host on Windows environment if the database goes down? I know about "Nagios" but like to know is there any other tool available?
View 6 Replies View RelatedNetworking And Gateways :: Logs Or Queries To Monitor Clients IP
Oct 13, 2012Is there any logs or query where I can monitor client's IP previously connected to the database? I have created 2 listener with 10.1.2.x and 10.1.100.x network. I would like to separate the oracle traffic to the 10.1.100.x alone. As of now both can connect to the database. I like to monitor if everybody is already transferred to the 10.1.100.x network before I will disable the 10.1.2.x.
View 2 Replies View RelatedApplication Express :: Database Monitor Module Missing In 4.2.2?
Jul 4, 2013When login as a administrator, am unable to find the above in SQL Workshop / Utilities. it's not drop from 4.2.2 , very useful functions.
View 2 Replies View RelatedServer Administration :: How To Monitor Instance Status And Log Switch Summary
Apr 27, 2012how can i monitor the instance status and log switch summary.
View 8 Replies View RelatedCall Interface :: Monitor Stream Activity With Strmmon Tool
Dec 20, 2012I want to monitor the stream activity with strmmon tool. How to compile the strmmon.mk? I was seeing with visual studio command prompt but it does not work properly.
Oracle Version: 10.2.0.4
Server: Win 2008 R2
Server Administration :: Monitor Increment Of Space Of Tablespace Based On Table?
Jun 9, 2011How to check for the increment of a space of the tablespace based on the particular table. (i.e.) Say a scenario, if am trying to load the data for a particular table, for first I loaded some 10000 records and then again loading 50000 records ,so based on the icrement of the reocrds the tablespace size also increases gradually . so for this scenario how to monitor the increment of the space.
View 13 Replies View RelatedForms :: Dual Monitor Forms With Alerts / Messages
Apr 18, 2013We have forms 11gr2 on win xp 32bit , weblogic linux server 64bit. We are converting 6i to 11g. Our system has many forms that span on 2 monitors. 1280x768 monitors, so some forms are 2560x768.
When alerts/messages pop up on the screen , they are positioned in the middle of both screens (guessing Oracle by default calculates width =2560/2, height =768/2).
Possible options:
1- is there a way to tell oracle to open alerts/messages a X Y coordinates? Maybe a config file on the server? Already file a Sr with Oracle tech support.
2- tried creating a form to do our messages. but this is flawed since when you call the new form to display the message, then the focus on current form is lost. when the message form is closed (then trigger when_window_activate fires)...this would be hell to try and control all our messages (we may have 20-30 on each big form. We have a total of 118 forms. Lots of messages with Y/N/Cancel options.
3- Maybe create a place holder for messages on all forms (bottom of screen)...thats the best idea we have so far.
4- Is there a way to do something with a java beans? We already have some knowledge with beans since we use image beans and pdf beans.