Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Production Database gets Hanged frequently...

Alagu770Jun 2 2022

Hi all,
Eventhough My database configure with,
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 1
cell_offload_processing boolean TRUE
db_writer_processes integer 13
gcs_server_processes integer 0
global_txn_processes integer 1
job_queue_processes integer 1000
log_archive_max_processes integer 15
processes integer 7000
processor_group_name string

Still gets Error in alert log as,
ORA-00445: background process "J000" did not start after 120 seconds
Incident details in: /orahome11g/diag/rdbms/mrcdgsiebprod/MRCDGSIEBPROD/incident/incdir_9240541/MRCDGSIEBPROD_cjq0_3429_i9240541.trc
kkjcre1p: unable to spawn jobq slave process
Errors in file /orahome11g/diag/rdbms/mrcdgsiebprod/MRCDGSIEBPROD/trace/MRCDGSIEBPROD_cjq0_3429.trc:
Thu Jun 02 09:57:41 2022

On that particular time DB gets hanged and new connections are not allowed, also server utilization being peaked up and RAM consumption been too high.

DB Size - 4.5TB
RAM - 224GB

Comments

HamidHelal

What is your form developer version and how you call the reports ?

add this

  Add_Parameter(pl_id, 'PARAMFORM', TEXT_PARAMETER, 'NO');     

to get clear answer, post your code...

Hamid

Eslam_Elbyaly

i am testing my report from report builder 6i ,

there is no code ,

i do not call the report from form .

Andreas Weiden

The run-report-functionality in report-builder is just for previewing purposes. I don't think you enter supress the paramform. But you can syimply close it by using ENTER.

Zlatko Sirotic

See:

Tools -> Preferences -> Runtime Settings tab -> Parameter Form

ayadsufyan

you can hide the parameters from report builder

go to Tools  Menu  ->Parameter Form builder

it will give you the whole parameter

any parameter with  black highlighting   will   appear  when you call the reports

if you want to hide it , try to unhighlight it  by pressing to the parameter's name

hope it helps you .

Eslam_Elbyaly

>you can hide the parameters from report builder ,

i did so , but the paramform still appears without parameters .

i do not want it to appear .

1 - 6

Post Details

Added on Jun 2 2022
4 comments
201 views