Top Tweets for #QualityTip
With 2 powerful keywords: "RESTART IDENTITY", and "SERIAL", I can easily handle sequences without even using the word "SEQUENCE" -- look at pix, where I create an autoincrement primary key, then empty the table and have that primary key restart from 0
#postgresql #DBA #qualitytip
Nifty SELECT to give you the breakdown between table , index and LOB sizes for one or several schemas.
#orclDB #DBA #qualitytip
To prepare your datapump import, get the CREATE TABLESPACE commands you require with this nifty
SELECT
dbms_metadata.get_ddl('TABLESPACE',TABLESPACE_NAME) from (SELECT DISTINCT TABLESPACE_NAME from dba_segments where OWNER in ('S','S2','S3'));
#orclDB #DBA #qualitytip
๐No scam no fake whatsoever... Many have been with my VIP group since many months... Thanks my VIP. U deserved more winners...
#testimonial #qualitytip #betteroddspick
Every single day is like this!!! BOOOoOoOoOoOoOoM
After setting up #Dataguard, check it with my cool one-liner:
dgmgrl / 'show configuration lag verbose' -silent
It gives you info about all the #orclDB involved, any lag, the observers, FSFO, properties...
#DBA #qualitytip
MAHQ QUALITY TIP TUESDAY!
MAHQ will be celebrating maintaining quality with patient safety on September 17th!
#patientsafety #qtt #mahq #qualitytip #patientsafetyday #qualitycare #patientcare #healthcarequality #qualitytiptuesday
MAHQ QUALITY TIP TUESDAY!
MAHQ will be celebrating maintaining quality with patient safety on 9/17/2020!
#patientsafety #qtt #mahq #qualitytip #patientsafetyday #qualitycare #patientcare #healthcarequality #qualitytiptuesday
https://t.co/fZ24YB9XNs
for DBSID in $(awk -F':' '/^#/ {next}; {print $1}' /etc/oratab)
do
export ORACLE_SID=$DBSID
echo " for this SID: $DBSID"
sqlplus -s / as sysdba <<EOF
set feed off pagesize 0 echo off
select name,open_mode from v\$database;
EOF
done
#orclDB #DBA #qualitytip
You can mention several TNS aliases for the same connection details (see picture). Useful for development environments (different schemas in the same database).
#orclDB #DBA #qualitytip
When installing #RAC (here a 12.2 2-node cluster), double-check the subnet for each interface with the subnets mentioned by
cluvfy stage -pre crsinst -verbose
#oracle #DBA #qualitytip
SELECT * FROM GV$LISTENER_NETWORK ORDER BY TYPE,VALUE,INST_ID;
will list all your LISTENERS and the IP addresses of the VIPs
#orclDB #RAC #qualitytip
New Year, New Goals!ย
https://t.co/D8HOSjEZ1X
.....
#SanAntonioUrgentCare #QualityCare #QualityUrgentCare #SanAntonio #Schertz #Pleasanton #PaloAlto #WestSanAntonio #MedicalCenter #TX #UrgentCare #Gym #Fit #Workout #QualityCare #QualityTip
SQL to generate the GRANTs on THEOWNER's objects for a _RO read-only user:
SELECT 'grant SELECT ON &&theowner..'||object_name||' to &&theowner._RO ;' FROM all_objects WHERE OWNER = '&&theowner' AND object_type IN ('VIEW','TABLE','SYNONYM') ORDER BY object_type;
#DBA #qualitytip
Porque nos encantan las cocinas y es una de las รกreas mรกs importantes en cada casa... les dejamos esta por aquรญ! #QualityTip #qualityinmobiliariarobina @AptTherapy https://t.co/00yK5OLcTs
In #oracldb >= 12.2 use the V$diag_trace_file view to keep track of the slowness of your LOG WRITER
SELECT MODIFY_TIME,TRACE_FILENAME FROM V$DIAG_TRACE_FILE WHERE TRACE_FILENAME LIKE '%lgwr%.trc' ORDER BY 1;
LGWR creates these traces if a write took more than 500ms
#qualitytip
#QualityTip #5 Stay home if you're sickย
Protect yourself and others, get your #flushot today. For more info: https://t.co/LYFEZwc9z6
The things we fail to focus on keep us from getting real results. https://t.co/iKFORffzPJ #leadership #qualitytip #qualityprogress
Gibbs for balon d'or? #qualitytip
El sol y el polvo son enemigos mortales de tus prendas, mantenlos en fundas... #QualityTIP
Last Seen Hashtags on Sotwe
nolimit() filter:videos
Seen from United States
ูุฑูุฎ
Seen from United Kingdom
monkeyappwinsfull
Seen from Mexico
malemasturbation
Seen from United Kingdom
Samajwadipension
Seen from United States
ุญูููู_ูุจูุงู
Seen from Saudi Arabia
ูุฑุนุงู
momson()
Seen from United States
Teenagegirls() + filter:native_video
Seen from United Arab Emirates
kuลadasฤฑgay
Seen from Turkey
Trends for you
Most Popular Users
Elon Musk 
@elonmusk
241M followers
Barack Obama
@barackobama
119.2M followers
Cristiano Ronaldo
@cristiano
112.1M followers
Donald J. Trump
@realdonaldtrump
111.8M followers
Narendra Modi
@narendramodi
107.1M followers
Rihanna
@rihanna
98.1M followers
NASA
@nasa
92.2M followers
Justin Bieber
@justinbieber
91.3M followers
KATY PERRY
@katyperry
88.5M followers
Taylor Swift
@taylorswift13
82.4M followers
Lady Gaga
@ladygaga
73.9M followers
Virat Kohli
@imvkohli
71.3M followers
Kim Kardashian
@kimkardashian
70.2M followers
YouTube
@youtube
68.7M followers
Bill Gates
@billgates
64.4M followers
Neymar Jr
@neymarjr
64.1M followers
The Ellen Show
@theellenshow
62.4M followers
CNN
@cnn
61.8M followers
Selena Gomez
@selenagomez
61.6M followers
X
@x
60.8M followers