Home » SQL & PL/SQL » SQL & PL/SQL » ORA-12801 (Oracle10G)
ORA-12801 [message #389478] Mon, 02 March 2009 04:50 Go to next message
raghu.iv85
Messages: 13
Registered: December 2008
Location: banglore
Junior Member
Hi All,


While I am selecting the record count from one view i got an error like
"ORA-12801: error signaled in parallel query server P012, instance
bdhp4649:adw1d2 (2)"
But I am executing in 'bdhp4423' server and the ORACLE_SID is 'adw1d4'.

I am sending my view script below.

-----------------------------------------------------------

CREATE OR REPLACE VIEW sh30_3511_9760_xxxx_tmp_v
AS
SELECT /*+ NO_MERGE(m3) PARALLEL(a, 4) PARALLEL(m3, 4) */
a.proft_ctr_id AS proft_ctr_id,
a.time_perd_end_date AS time_perd_end_date, a.site_id AS site_id,
NVL (m3.site_id_plant, a.site_id_plant) AS site_id_plant,
a.cust_id AS cust_id, a.geo_id AS geo_id, a.prod_id AS prod_id,
a.time_perd_id AS time_perd_id,
a.vol_stat_unit
* NVL (m3.plant_prodn_pct, 100)
/ 100 AS vol_stat_unit,
a.vol_base_unit
* NVL (m3.plant_prodn_pct, 100)
/ 100 AS vol_base_unit,
a.prod_csu_type_code AS prod_csu_type_code
FROM sh30_3511_9759_xxxx_tmp_v a,
(SELECT site_id_dist_ctr, site_id_plant, plant_prodn_pct, dsend_id,
time_perd_end_date
FROM (SELECT /*+ PARALLEL(m, 4) PARALLEL(pdn, 4) */
m.site_id_dist_ctr, m.site_id_plant,
m.plant_prodn_pct, pdn.dsend_id, pdn.parnt_lvl,
q1.time_perd_end_date,
MAX (pdn.parnt_lvl) OVER (PARTITION BY site_id_dist_ctr, dsend_id, time_perd_end_date)
max_parnt_lvl
FROM mcr_plant_deriv m,
prod_assoc_dnorm pdn,
(SELECT /*+ PARALLEL(a, 4) */
DISTINCT prod_id, time_perd_end_date
FROM sh30_3511_9759_xxxx_tmp_v a
WHERE site_id_plant = 'UNKN') q1
/* where */
WHERE m.srce_sys_id = 1729
AND m.site_id_dist_ctr != 'G000'
AND pdn.strct_code = '5005'
AND pdn.ctrl_perd =
(SELECT ctrl_perd
FROM ref_ctrl
WHERE strct_code = '5005'
AND fact_type_code = 'BS'
AND stage_id = '31')
AND pdn.dsend_id = q1.prod_id
AND pdn.parnt_id = m.prod_id
AND pdn.dsend_lvl =
(SELECT strct_lvl
FROM strct_lvl
WHERE strct_code = '5005' AND lvl_name = 'FPC')
AND pdn.net_lvl != 0
AND q1.time_perd_end_date BETWEEN m.start_date
AND m.end_date)
WHERE parnt_lvl = max_parnt_lvl) m3
WHERE a.site_id_plant = 'UNKN'
AND a.prod_id = m3.dsend_id(+)
AND a.site_id = m3.site_id_dist_ctr(+)
AND a.time_perd_end_date = m3.time_perd_end_date(+)
UNION ALL
SELECT /*+ PARALLEL(a, 4) */
"PROFT_CTR_ID", "TIME_PERD_END_DATE", "SITE_ID", "SITE_ID_PLANT",
"CUST_ID", "GEO_ID", "PROD_ID", "TIME_PERD_ID", "VOL_STAT_UNIT",
"VOL_BASE_UNIT", "PROD_CSU_TYPE_CODE"
FROM sh30_3511_9759_xxxx_tmp_v a
WHERE site_id_plant != 'UNKN';


-----------------------------------------------------------

Can anyone help me that what is the reason to come this error and how to get the solution.


Thanks & Regards,
Raghunadh.



Re: ORA-12801 [message #389492 is a reply to message #389478] Mon, 02 March 2009 05:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
See your alert.log file.

Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

Regards
Michel
Re: ORA-12801 [message #390525 is a reply to message #389492] Fri, 06 March 2009 23:47 Go to previous message
Kevin Meade
Messages: 2101
Registered: December 1999
Location: Connecticut USA
Senior Member
are you in a RAC environment?
Previous Topic: Help Needed in Ref Cursors
Next Topic: xml data as parameter to a procedure
Goto Forum:
  


Current Time: Fri Dec 09 04:13:25 CST 2016

Total time taken to generate the page: 0.15563 seconds