I have one tablespace called U01. This tablepspace contains 31 data files. Due to high water mark I was unable to most datafiles. Since my database running onair application they will not provide me downtime to move the tables. Is there anyway to fix the high water mark without getting downtime window? almost 700+g space unused. I need to reuse them asap because running out of space with in asm diskgroup.
I"Host operating system was experiencing significant paging but no particular root cause could be detected. Investigate processes that do not belong to this instance running on the host that are consuming significant amount of virtual memory. Also consider adding more physical memory to the host."
My database run on Windows Server 2008 R2 and have 12GB of physical RAM.
Oracle version is 10.2.0.4.0 and my sga and pga are:
sga_max_size 4000M sga_target 3904M pga 1200M
I try to find out something about this issue and read many blogs but unfortunately I didnt find anything which worked. Should this have something to do with the fact that on the server we have oracle database and terminal server with 30-40 users?
How can i check if paging happening while running the query. As i have 4gb of PGA target but the query is taking long time in parallel and has hash join.
I have some Javascript in an Apex page, running in 'Execute when page loads'. It does some stuff to a results grid. It works fine on page load, but then doesn't run when I page through, or sort the grid. I presume this is because the grid is being sorted / paged using Ajax, which means the page isn't being fully loaded. Is there anywhere else I can put the code so it gets applied to the grid on sorts and paging?
Sysaux Tablespace is running low. WE SET AWR RETENTION TIME=60 DAYS. WE ARE NOT INTEREST TO EXTEND SYSAUX TABLESPACE SIZE. Usually we take AWR weekly once. Some times we did ADDM report and ASH.
CODEsql>select TABLESPACE_NAME, FILE_NAME, BYTES/(1024*1024), AUTOEXTENSIBLE, MAXBYTES/(1024*1024) from dba_data_files where tablespace_name = 'SYSAUX';
1. What's the best SOLUTION ? 2. Can i shrink sysaux tablespace ? 3. I think , The size for all occupants in sysaux tablespace is less than 200 MB => how to find actual content of sysaux tablespace ? 4. What could be the reason for growth? Is there any way to free the space from sysaux table space?
In the program i wrote, posted in this thread I parallelize 340 jobs.
To do this, according to oracle documentation, i set the job_queue_processes parameters to 450. This works fine, all jobs are submitted, but, when i chek the dba_scheduler_job_run_details, i notice that there is a difference between REQ_START_DATE, which is my requested start date, when i enabled my job, and the ACTUAL_START_DATE, which is the date on which Oracle start this process.
And the more i submit job, the more difference between ACTUAL_START_DATE and REQ_START_DATE increase. But for each job, run duration is less than 1second. I check the processes parameter, and it is set to 100. if i have to increase the processes parameter to 450 too ?
I am having a data guard setup done in oracle 10g(10.2.0.4.0) WINDOWS Platform. some of the archive process are locked in primary db side.
PROCESS STATUS LOG_SEQUENCE STAT -------- ---------- ------------ ---- 0 ACTIVE 0 IDLE 1 ACTIVE 804462 IDLE 2 ACTIVE 0 IDLE 3 ACTIVE 0 IDLE 4 ACTIVE 0 IDLE 5 ACTIVE 800011 BUSY 6 ACTIVE 0 IDLE 7 ACTIVE 800009 BUSY 8 ACTIVE 0 IDLE 9 ACTIVE 802335 BUSY 10 ACTIVE 0 IDLE
Shall we kill the locking archive processes? killing archive processes will cause any problem?
In PL\SQL program, I am writing information from one table to file. In my current architecture, I am writing the information to approximately 1000 files.
If I put the database write operation in another package and in another method and call this method from my PL\SQL program asychronously, can that increase performance?
Is there any way to tell what processes/sessions were connected to a DB after I get an ORA 20error. As you can see from the query results below, I did hit the max value of processes but I would like to know when it happen and who was connected.
I realize I can up the value, but before I do that I want to see what caused this to happen.
SQL> select * from v$resource_limit where resource_name in ('sessions', 'processes'); RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_AL LIMIT_VALU ---------- processes 221 1000 1000 1000 sessions 223 1020 1105 1105
BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production PL/SQL Release 11.2.0.2.0 - Production CORE 11.2.0.2.0 Production TNS for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production NLSRTL Version 11.2.0.2.0 - ProductionI got below error on the datases.
ORA-00020: maximum number of processesBased on the suggestion got from previous posts, I did kill some (LOCAL=NO) processes to get myself in. When I looked at the number of processes the number is 150, I changed it to 1000. After a day I got the same error.
ORA-00020: maximum number of processes (1000) exceededI killed processes again to let my self in, bases on the post below, I queried database
ORA-00020: maximum number of processes (%s) exceededHere is the query to find out if there are any processes with out session attached to it.
select spid from v$process where addr not in (select paddr from v$session);Result
SPID null 35259840 36897866 13369762
[Code]...
To determine the from where greatest number of processes originated
SELECT MACHINE, COUNT(*) FROM V$SESSION GROUP BY MACHINE;Machine Count(*) 2 CAPITAL-D3F0092 1 DQAKDCDKLCSW01 14 desmond 20 DQAKDCDKLCSA01 52
My question is why I am keep getting this? Why do increasing process from 150 to 1000 did not resolve the issue?
What can I do to make sure that I don't get this error again?
ORA-00020: maximum number of processes (1100) exceeded
my oracle version is 10.2.0.2.0
when i was trying to login to oracle i got :ERROR at line 1: ORA-01012: not logged on
lucky i was having another sqlplus login ..
wht i should do to bring the number of process down without increasing the process value and shuting/restaring down db.
"Usually, when this happens, I want to get connected to the instance, so that I can try to figure out which user is causing the problem. One way to do that is to use the 'ps' command to identify some of the oldest server processes, and kill the 3-5 oldest processes, and then quickly try connecting to the database. Once you're in, you can look at things like V$SESSION to try and determine which user(s) is (are) consuming so many connections, and then go from there."
this is what i got from [URL]....
1.if i am giving ps -ef in OS it will give lot of detail ... 2. in v$session wht i should look for ....
I don't know if there is a beginner forum out there for PL SQL, but I cannot find one.I just started taking an Intermediate Oracle course to learn PL SQL. Today is my first day and I just installed Oracle 11g. I was in SQL Plus, tried the edit command. I got the message "wrote file Afiedt.buf" and then it was just a flashing cursor in the line below. I could not type any commands. I just hit the X to close the program.
What could I have done to exit the program with that flashing cursor since I was unable to type anything?
We have an oracle db V7.1 running on Open VMS V6.2. Lately we are having problems with oracle processes crashing...When I do a 'show sys' on VMS...I dont see any oracle processes running on it.....It should show 4 oracle processes....The trace is turned off on DB and alert.log has older info...We have another log which says the following
====================================== Wed 19:32:26 NoFLT Wed 19:32:26 P19: (SendDelays) ORA-01092: (Cnct err, can't get err txt. See Servr Msgs & Codes Manua Wed 19:32:26 ORA_NAS_PMON, ORA_NAS_LGWR, ORA_NAS_SMON, ORA_NAS_RECO are DEAD Wed 19:32:26 P19: (GetNumDelaysNotFilled) ORA-03114: (Cnct err, can't get err tx t. See Servr Msgs & Codes Manua Wed 19:32:26 10 ====================================
one of the drives has lot of errors but not sure how to check those errors....
I tried to restart the server and sometimes it comes backup. I have backups but really like to solve this issue. I know where the control files are located but not sure what would be good point to start this.
I know that in the profiles of the user I can set limit for the number of sessions per database user, using the below command:
alter profile <profile_name> limit sessions_per_user=<required_number>;
I need to set maximum number of processes for the application user so in case they opened too many number of processes on the database they do not block the automated jobs to be run.My questions:
1. set a limit on sessions_per_user is it the same as a limit on processes? 1 proccess= 1 session ? Is there any way to limit the number of processes (not sessions) for a database user? 2. I am using RAC so the number of sessions is per the whole database, while the max number of processes is by instance (not database), so even I set a limit on the number of sessions (above the limit of processes for one of the instances) one instance may face ORA-20 errors, while the max number of sessions did not hit the limit. is there any workaround for this case?
I have got a form in tabular format. each record contains some specific colour or it may not contain.
i want to chage the backgroud colour of that record based on what so ever user wants. for example, user want first record should be of RED back groud, second green, third blue etc.
colours are available in RGB format.
when i try to set_item_property(backgroundcolor) on post-query or on when new item instance, it makes all record of same colour.
note:- if a put another text/display item and make it number of record displayed property = 1 , then it works, because only one record colour is seen at a time.
I can not use multiple visual attributes because number of colours are up to user feedback.
my need is to call procedure2 from procedure1 "in background". What I mean... Let's say, procedure2 works about 10 seconds. So, procedure1 should call procedure2 and go on working without waiting for procedure2 to end its work.
How do I perform it? Is it possible at all? My thought was to use pragma autonomous transaction, am I right?
We are currently using OCI to connect to Oracle DB using c language. Each process has its own dedicated Connection and Env handle, session handle ...
Right now we decided to use Connection Pooling. In the documentation , Connection pooling examples were using multi-threaded environment. But in our case its multi-process system and we cant modify products architecture to multi-thread.
I would like to know how we can use Connection Pooling on multiple processes.
I have two Oracle databases (test1- 10gr2,test2 - 11gr2) on rhel 5.5. is it possible to find which particular oracle process belongs to which home from OS level. was trying to find which db processes are consuming more resources on my host.
I want to install datbase schemas using RCU but it is throwing me an message
"RCU-6083:Failed - Check prerequisites requirement for selected component:WEBCENTER Please refer to RCU log at C:OracleRCUofm_rcu_win32_11.1.1.2.1_disk1_1of1 cuHome culoglogdir.2013-01-22_16-03 cu.log for details. RCU-6107:DB Init Param Prerequisite failure for: PROCESSES Current Value is 150. It should be greater than or equal to 300."
I tried to change the process using SQL> alter system set processes=300 scope=spfile; and got the msg that system altered but still the error persisit. I reffered to a link RCU-6107, RCU-6092 for the same here it is mentioned in one ofthe post that some user has changed it manually ion init.ora file... Changing manually or through cmd ....
oracle 11.2.0.3 I have insert only tables that receive srecords from multiple processes at a rate of about 200/second. Each transaction can have up to 100 records. I have another set of processes that queries this table for the latest data. These processes run anywhere from once a minute to once an hour. Processes do not get all of the data. They get data based on a type field.
Both of these are from java middle tiers. The process that queries data (The subscriber) does so at the request of many remote servers (there will be vast numbers). I am not allowed to expose these downstream databases to the internet (they are not oracle DBs anyway) so I cannot use streams or golden gate
So basicallyInsert Process: multiple sessions that combined insert records up to 200/second. There will be between 1-100 records per commit.
Query Process: Downtream process makes a request to my middle tier. This middle tier runs a query to get the latest data and passes it back. This design is set and I cannot change it.
1. right now we capture the insert time of the record. However, at this rate of inserts some processes will commit faster than others. So I cant use a 'greater than my insert time' query. 2. streams/golden gate won't work. can't register these DBs. 3. don't want to serialize my inserts because since I am not sure I can keep up with the insert rate. I don't even know what the specs will be for the production hardware. I have to actually deliver this before its decided. So I am being conservative. 4. I really want to avoid updates on this table if possible. In part due to my limited ability to test. 5. due to the number of downstream processes it is possible that it will request data and for some reason fail to insert the data locally. So the downstream application will keep track of the latest data it received. This means that a subscriber may need to request the same data again.
Is there a way to set up change data capture with multiple subscribers to handle this? if my subscribers are just queries? All the queries come from the same servers(there will be several, but all the same thing). If so, when I performance test this are there any wait issues I should keep an eye on?
I am on H1 visa and working as chemical engineer...but I am bored of this job... I wanted to switch to IT and particularly oracle dba..
How much is the risk for me as I am coming from non computer science background..there are various IT consulting companies who can provide training and do h1 transfer......currently (year 2010) the market for oracle is booming a lot...so I was thinking what can go wrong if I do this switch.
