Viewing 15 posts - 2,671 through 2,685 (of 3,060 total)
dmw (3/19/2009)
I may not register because their Privacy Policy seems to suggest 'you have no privacy from our advertisers'.
You can always create a gmail or whatever email account for the...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.March 20, 2009 at 3:13 am
Gift Peddie (3/13/2009)
... my actual question would be what are you doing with Oracle 9i because most people are now running 10g and 11g
This statement does not reflects reality.
Ora9i...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.March 17, 2009 at 9:36 am
I would create a new filegroup in the desired drive, once you have it there you can reorg tables/indexes the way better fits your I/O strategy.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.March 17, 2009 at 9:32 am
Steve Jones - Editor (3/13/2009)
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.March 13, 2009 at 8:54 am
Ratheesh.K.Nair (3/12/2009)
First you connect to that particular database using login 'system'ie conn system\password@DB_Name as sysdba. Then try
BA
SYS and SYSTEM are Oracle equivalents of "sa" account; you don't want to connect...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.March 13, 2009 at 8:49 am
If tempdb is your bottleneck you may want to setup tempdb on as many datafiles as CPUs you have in the box.
Datafiles should be distributed so to balance I/O -Your...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.March 13, 2009 at 8:46 am
Check the size of Procedure Cache, is Procedure Cache growing at the same time hit ratio goes down?
Remember that a growing Procedure Cache would take space away from Data Cache...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.March 9, 2009 at 10:10 am
shri_sastry (3/9/2009)
Do you think I should just disable the transaction log job and renable it after the full backup is done
I wouldn't be enabling/disabling backup jobs, as a DBA you...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.March 9, 2009 at 9:59 am
oerr ora 28547
28547, 0000, "connection to server failed, probable Oracle Net admin error"
// *Cause: A failure occurred during initialization of a network connection
// ...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.March 1, 2009 at 3:46 am
RJ (2/27/2009)
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.March 1, 2009 at 3:32 am
I do not think the issue has anything to do with partitioning but with the concept of referential integrity.
I would start by asking myself the question: "Which parent-child relationship do...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 27, 2009 at 6:52 am
As part of your testing do not forget to attempt to patch SQL Server.
During SQL Server patching you are going to find out if hidden mssqlsystemresource database is in the...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 27, 2009 at 6:39 am
I'm not sure if I'm following you to the atomic details of the issue but I would say you may want to work in two fronts.
1- Setting a explicit transaction
2-...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 27, 2009 at 2:34 am
Why would you like to install express edition to work on a production environment?
My suggestion is to install the full version.
I know... it doesn't install, huh?
You have to uninstall express...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 26, 2009 at 2:29 am
A much more easier query to remember is ...
select @@version
... everything you are looking for is there. 😎
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 25, 2009 at 5:48 am
Viewing 15 posts - 2,671 through 2,685 (of 3,060 total)