Parallel_max_server on the parallel implementation and parameters
rn
parallel_max_server parameters will be restricted to the parallel execution, the current value of the parameter 5
SQL> show parameter parallel
rn
NAME TYPE VALUE
------------------------------------ ----------- --- ---------
parallel_max_servers integer 5
rn
Parallel test form time to 8
SQL> alter table tt parallel 8;
rn
Then run a query
SQL> select * from tt;
...
rn
In another window, query the view v $ px_session to check the number of parallel execution
select * from v $ px_session
sid serial # qcsid
10,610
18 29 10
23,310
22,310
21,310
20,310
rn
Can see that a total of six session, the other five session is derived from the SID 10. Parallel line that will only reach 5 degrees.
rn
Parallel_max_server now be revised to 8, the implementation of the above steps again, we can see a total of nine session, the other 8 are generated by the parallel query.
rn
The reason to do this test, mainly in the first work will be read parallel to the high degree, but did not confirm the value of parallel_max_servers a result, the value of degree higher than the parallel_max_servers, this degree does not work in practice. Should also improve the value of parallel_max_servers parallel in order to comply with the requirements.
rn
Related Posts of Parallel_max_server on the parallel implementation and parameters
-
UNDO table space reconstruction
$ Sqlplus / nolog SQL> connect / as sysdba SQL> create undo tablespace UNDOTBS2 datafile '/ ora_data/UNDOTBS02.DBF' size 1M extent management local; SQL> alter system set undo_tablespace = UNDOTBS2; SQL> drop tablespace UNDOTBS1 includ
-
OEM setup
When at start OEM following error. http://:% s_oc4jWebsitePort% / em / console / aboutApplication Error opening logfile for output in nmeula_new Error opening logfile for output in nmeula_new Starting Oracle Enterprise Manager 10g Database Control .. ...
-
Oracle Sysdba certification authority management
<br /> Outlined one at ORACLE has a special level of competence - sysdba authority, sysdba privileges ORACLE systems have the highest authority, has opened the database, turn off the database, restore database, such as advanced permissions, the ...
-
Oracle Database exp imp Import Export by user examples
◆ 1. From one windows server A on Test1 export all objects in the user, and then into the linux server B on Test2 users. (Test1 known password for the system users Test1passwd or export is required) ◆ 2.B user Test2 machine does not exist, or Test2 b ...
-
Detailed: database name. Instance name. ORACLE_SID. Database name
Detailed: database name, instance name, ORACLE_SID, database name, global database names, service names and hand the script to create oracle database Database name, instance name, database name, global database names, service names, This is easy for some
-
LISTENER and EZCONNECT
listener =========================== Listener should be noted that there are two methods Register: Dynamic and Static Registration Registration Registration <br /> dynamic, that is, when the listener configuration, Do not need to configure stat ...
-
Oracle10g ASM database table space maintenance
1. Default naming Oracle when using ASM + OMF management, Oracle distribution file name will automatically create the appropriate file. Our job to create table space can be simplified as follows: A command. The following are the default Oracle naming ...
-
Merge the use of (1)
Merge to select from a table update or insert some data to another table. And finally is used to update or insert depends on the conditions of the statement. rn Here's our easy to cite an example: rn rn SQL> create table merge_test1 (a number, ...
-
Oracle deadlock related
ORACLE some were killed in the process, the status was set to "killed", but the lock does not release resources for a long time, sometimes it is no way but to restart the database. Now offers a way to solve this problem, that is, in the kil ...
-
An example of the use of TKPROF
First, view and edit parameters SQL> show parameter max_dump_file_size NAME TYPE VALUE ------------------------------------ ----------- --- --------------------------- max_dump_file_size string UNLIMITED SQL> show parameter user_dump_dest NAME TYPE
Leave a Reply