Tracnac

Master Note: SQL Query Performance Overview [ID 199083.1]

http://dbakevin.blogspot.com/2012/11/tip-how-to-bind-sql-with-plan-from-awr.html

November 20, 2012

Tip: how to bind SQL with plan from AWR (or History tables/ DBA_HIST)

Materializing Segments

Beginning with Oracle Database 11g release 2 (11.2.0.2), the DBMS_SPACE_ADMIN package includes the MATERIALIZE_DEFERRED_SEGMENTS() procedure, which enables you to materialize segments for tables, table partitions, and dependent objects created with deferred segment creation enabled.

This enables you to add segments as needed, rather than starting with more than you need and using database resources unnecessarily.

The following example materializes segments for the EMPLOYEES table in the HR schema.

Beos 5.03 Pro installation

https://john-millikin.com/running-beos-5-in-qemu-i386

qemu-img create -f qcow2 beos-5.img 1G

qemu-system-ppc -m 1024M -drive media=cdrom,file=BeOS_Tools.iso01.iso -drive media=cdrom,file=BeOS_Tools.iso02.iso -drive file=beos-5.img

qemu-system-i386 -m 1024M -drive file=beos-5.img,cache=none -nic user,model=ne2k_pci -cpu qemu32 -vga std

SunOS 4.1.4 installation

https://fsck.technology/software/Sun%20Microsystems/SunOS%20Install%20Media http://defcon.no/sysadm/playing-with-sunos-4-1-4-on-qemu/ https://en.wikibooks.org/wiki/QEMU/SunOS_4.1.4

qemu-img create -f raw sunos414.img 2G

qemu-system-sparc -vga cg3 -M SS-5 -bios ss5.bin -m 32 -hda sunos414.img -hdb Solaris1_1_2.iso

arr=()	Create an empty array
arr=(1 2 3)	Initialize array
${arr[2]}	Retrieve third element
${arr[@]}	Retrieve all elements
${!arr[@]}	Retrieve array indices
${#arr[@]}	Calculate array size
arr[0]=3	Overwrite 1st element
arr+=(4)	Append value(s)
str=$(ls)	Save ls output as a string

select path, free_mb,total_mb,state from v$asm_disk where group_number in (select group_number from v$asm_diskgroup where name='DATA');

alter diskgroup data check all repair; alter diskgroup data rebalance power 10;

This machine is currently configured in rootless mode. If your containers require root permissions (e.g. ports < 1024), or if you run into compatibility issues with non-podman clients, you can switch using the following command:

podman machine set --rootful

API forwarding listening on: /Users/tracnac/.local/share/containers/podman/machine/podman-machine-default/podman.sock

The system helper service is not installed; the default Docker API socket address can't be used by podman. If you would like to install it run the

https://blogs.oracle.com/UPGRADE/

La bible de la migration...

	```sql
	select ( select username from v$session where saddr = session_addr) uname,
	v.* from v$sort_usage v
	```

	;; Cosmetique
	(setq inhibit-startup-screen t
	inhibit-startup-message t
	inhibit-startup-echo-area-message t
	initial-scratch-message nil)

	(menu-bar-mode -1)
	(scroll-bar-mode -1)
	(tool-bar-mode -1)
	(tooltip-mode -1)