#db12cR2
#oratidbit #db12cR2 The Parallel Upgrade Utility (catctl.pl) parameter -N controls the number of parallel SQL... http://fb.me/9mbpTa9lW
Biju Thomas - Oracle Notes
#oratidbit #db12cR2 The Parallel Upgrade Utility (catctl....
fb.me
November 30, 2024 at 12:16 AM
#oratidbit #orcldb #db12cR2 Oracle Cluster Health Advisor collects data from Oracle Real Application Clusters... http://fb.me/5GmOh6MrU
Biju Thomas - Oracle Notes
#oratidbit #orcldb #db12cR2 Oracle Cluster Health Advisor...
fb.me
December 1, 2024 at 6:56 AM
#oratidbit #db12cR2 #sqlplus New SET LOBPREFETCH to define the amount of LOB data (in bytes) to prefetch from... http://fb.me/324QGXzBi
Biju Thomas - Oracle Notes
#oratidbit #db12cR2 #sqlplus New SET LOBPREFETCH to defin...
fb.me
December 1, 2024 at 7:27 AM
#oratidbit #db12cR2 In 12.2, Query the V$ONLINE_REDEF view to monitor the progress of an online table redefinition operation.
December 1, 2024 at 10:11 AM
#oratidbit #orcldb #db12cr2 Use OCLUMON to query the Cluster Health Monitor repository to display node-specific... http://fb.me/6oUe7HFxb
User’s Guide
You can use the OCLUMON command-line tool to interact wit...
fb.me
December 1, 2024 at 6:04 AM
#oratidbit #db12cR2 Init parameter DATA_GUARD_SYNC_LATENCY, defines the maximum amount of time (in seconds) that the primary database may wait before disconnecting subsequent standby destinations after at least one synchronous standby has acknowledged receipt of the redo.
November 29, 2024 at 10:05 AM
#oratidbit A non-partitioned table in Oracle #DB12cR2 can be converted to a partitioned table by using the MODIFY... http://fb.me/Pxof34Ft
Biju Thomas - Oracle Notes
#oratidbit A non-partitioned table in Oracle #DB12cR2 can...
fb.me
December 1, 2024 at 11:39 AM
#oratidbit In Oracle #DB12cR2 many data type conversion functions (TO_DATE, TO_NUMBER, etc) and CAST function... http://fb.me/2XQmkr3c3
Biju Thomas - Oracle Notes
#oratidbit In Oracle #DB12cR2 many data type conversion f...
fb.me
December 1, 2024 at 11:34 AM
#oratidbit In Oracle #DB12cR2 a table segment or table partion segment can be moved to a new segment (or... http://fb.me/7Et2BWZZL
Biju Thomas - Oracle Notes
#oratidbit In Oracle #DB12cR2 a table segment or table pa...
fb.me
December 1, 2024 at 11:34 AM
#oratidbit In Oracle #DB12cR2 most object names can be as long as 128 bytes. You no longer have to limit a table... http://fb.me/OqU2dGJ4
Biju Thomas - Oracle Notes
#oratidbit In Oracle #DB12cR2 most object names can be as...
fb.me
December 1, 2024 at 11:34 AM
#Oracle ® Database Online Documentation Library 12c Release 2 (12.2) #DB12cR2 http://buff.ly/2fw1YWa
Oracle Database 12c Release 2 - Get Started
buff.ly
December 1, 2024 at 10:52 AM
#oratidbit #DB12cR2 Duties that belonged exclusively to PMON now belong to the PMON process group, which includes... http://fb.me/5902KSVvp
Biju Thomas - Oracle Notes
#oratidbit #DB12cR2 Duties that belonged exclusively to P...
fb.me
December 1, 2024 at 10:52 AM
#oratidbit #DB12cR2 Optimizer Statistics Advisor analyzes how you are currently gathering statistics, the... http://fb.me/5X7l6xkji
Biju Thomas - Oracle Notes
#oratidbit #DB12cR2 Optimizer Statistics Advisor analyzes...
fb.me
December 1, 2024 at 10:47 AM
#oratidbit #DB12cR2 #Oracle Sharding is a scalability and availability feature for suitable OLTP applications in... http://fb.me/5v6Bk8rWw
Biju Thomas - Oracle Notes
#oratidbit #DB12cR2 #Oracle Sharding is a scalability and...
fb.me
December 1, 2024 at 10:47 AM
#oratidbit #DB12cR2 You can relocate a PDB from one CDB to another with minimal downtime.
December 1, 2024 at 10:42 AM
#oratidbit #DB12cR2 During a PDB clone operation, the source PDB no longer needs to be in read-only mode.
December 1, 2024 at 10:37 AM
#oratidbit #DB12cR2 You can use FLASHBACK PLUGGABLE DATABASE command to rewind a PDB to any SCN without affecting... http://fb.me/7ot2dxASh
Biju Thomas - Oracle Notes
#oratidbit #DB12cR2 You can use FLASHBACK PLUGGABLE DATAB...
fb.me
December 1, 2024 at 10:32 AM
#oratidbit #DB12cR2 A PDB lockdown profile is a security mechanism to restrict operations that are available to... http://fb.me/1B782owbv
Biju Thomas - Oracle Notes
#oratidbit #DB12cR2 A PDB lockdown profile is a security ...
fb.me
December 1, 2024 at 10:31 AM
#oratidbit #DB12cR2 You can configure PDB parameters to guarantee or limit SGA memory, PGA memory, sessions, CPU,... http://fb.me/8rvAaYgVN
Biju Thomas - Oracle Notes
#oratidbit #DB12cR2 You can configure PDB parameters to g...
fb.me
December 1, 2024 at 10:26 AM
#oratidbit #DB12cR2 You can create local, nonshared temporary tablespaces in PDB. When many read-only instances... http://fb.me/1zf91omiV
Biju Thomas - Oracle Notes
#oratidbit #DB12cR2 You can create local, nonshared tempo...
fb.me
December 1, 2024 at 10:26 AM
#oratidbit #DB12cR2 You can pre-create a pool of server processes by using the DBMS_PROCESS PL/SQL package. The... http://fb.me/5nf0hhjqj
Biju Thomas - Oracle Notes
#oratidbit #DB12cR2 You can pre-create a pool of server p...
fb.me
December 1, 2024 at 10:26 AM
#oratidbit #DB12cR2 Read-only and read-write instances can co-exist within a single database. To designate an... http://fb.me/3FQ5ADAsr
Biju Thomas - Oracle Notes
#oratidbit #DB12cR2 Read-only and read-write instances ca...
fb.me
December 1, 2024 at 10:26 AM
#oratidbit #DB12cR2 In the root of a CDB, you can configure a single port (known as the global port), which... http://fb.me/5LoAlSKTg
Biju Thomas - Oracle Notes
#oratidbit #DB12cR2 In the root of a CDB, you can configu...
fb.me
December 1, 2024 at 10:21 AM
#oratidbit #DB12cR2 In EM Express, you can view real-time performance statistics for a standby database in the Performance Hub.
December 1, 2024 at 10:21 AM
#oratidbit #DB12cR2 You can capture Automatic Workload Repository (AWR) data for Oracle Active Data Guard standby... http://fb.me/8hvAD8L7V
Biju Thomas - Oracle Notes
#oratidbit #DB12cR2 You can capture Automatic Workload Re...
fb.me
December 1, 2024 at 10:21 AM